001-
001+ 严重级别：严重 所属项目：walmart 问题原因：严重违反starrocks使用规范，影响面较广，在starrocks跑批（并发过高）（SELECT twl.id,twl.customer_id as customerId,twl.source_id as sourceId,twl.source_name as sourceName,twl.name,twl.name_cn as nameCn,twl.spu,twl.sku, twl.item_id as itemId,twl.source_sku as sourceSku,twl.main_image as mainImage,twl.platform_category_id as platformCategoryId,twl.platform_category_name as platformCategoryName, twl.brand_id as brandId,twl.brand,twl.publish_status as publishStatus,twl.status ,twl.tort ,twl.upc ,twl.gtin ,twl.sale_price as salePrice,twl.purchase_price as purchasePrice,twl.original_price as originalPrice, twl.days_to_ship as daysToShip,twl.first_publish_time as firstPublishTime,twl.primary_variant as primaryVariant,twl.has_variant as hasVariant,twl.has_new as hasNew,twl.description_type as descriptionType, twl.default_local_warehouse as defaultLocalWarehouse,twl.currency as currency,twl.country_code as countryCode,twl.create_by as createBy, twl.update_by as updateBy,twl.update_time as updateTime, twl.is_deleted as isDeleted,twl.salesman,twl.salesman_id as salesmanId,twl.listing_person as listingPerson,twl.fulfillment_type as fulfillmentType ,twl.template_id as templateId,twl.template_name as templateName, twl.freight_price as freightPrice,twl.product_state as productState,twl.average_rating,twl.transit_time as transitTime,IFNULL(lt.status,0) as titleStatus,lt.original_name as originalName, IFNULL(tpr.risk_level,0) as riskLevel,rpa.has_imitation_country as hasImitationCountry, group_concat(concat(ric.country_cn,'(',ric.short_thand,')')) AS imitationCountryCode, IFNULL(rpa.is_amazon_us_white_list,2) as isAmazonUsWhiteList,IFNULL(rpa.has_pattern,3) as hasPattern FROM t_walmart_listing twl left join t_walmart_listing_title lt on twl.source_id=lt.source_id and twl.source_sku=lt.source_sku left join t_walmart_listing_brand_change bc on twl.source_id=bc.source_id and twl.source_sku=bc.source_sku left join rb_product_risk_level_platform_country tpr on twl.sku = tpr.sku and twl.country_code = tpr.site_code and tpr.platform_id = 10 and tpr.platform_type = 45 and tpr.is_deleted = 0 left join rb_product_admin rpa on twl.sku = rpa.sku left join rb_imitation_country_comprehensive ric ON twl.sku = ric.sku left join rb_order_source ros ON ros.id = twl.source_id WHERE twl.source_id in ( 25611 , 22040 , 23594 , 25654 , 24634 , 22592 , 27716 , 26198 , 22106 , 23132 , 24181 , 22650 , 21626 , 23202 , 20643 , 23204 , 23205 , 24235 , 22237 , 28398 , 22274 , 22277 , 22794 , 23821 , 21805 , 24367 , 22841 , 23367 , 26979 , 23446 , 24999 , 23987 , 28625 , 26099 , 23033 , 22012 ) and twl.publish_status in ( 1 , 3 ) and twl.status in ( 1 ) and ( tpr.risk_level in ( 3 ) ) and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 58000,2000） 解决方案：方案一（如果是导出可以暂用）：在下载中心nacos配置限流；方案二（推荐）：转到mysql处理
002- 严重级别：严重
003- 所属项目：walmart
004- 问题原因：严重违反starrocks使用规范，影响面较广，在starrocks跑批（并发过高）（SELECT twl.id,twl.customer_id as customerId,twl.source_id as sourceId,twl.source_name as sourceName,twl.name,twl.name_cn as nameCn,twl.spu,twl.sku, twl.item_id as itemId,twl.source_sku as sourceSku,twl.main_image as mainImage,twl.platform_category_id as platformCategoryId,twl.platform_category_name as platformCategoryName, twl.brand_id as brandId,twl.brand,twl.publish_status as publishStatus,twl.status ,twl.tort ,twl.upc ,twl.gtin ,twl.sale_price as salePrice,twl.purchase_price as purchasePrice,twl.original_price as originalPrice, twl.days_to_ship as daysToShip,twl.first_publish_time as firstPublishTime,twl.primary_variant as primaryVariant,twl.has_variant as hasVariant,twl.has_new as hasNew,twl.description_type as descriptionType, twl.default_local_warehouse as defaultLocalWarehouse,twl.currency as currency,twl.country_code as countryCode,twl.create_by as createBy, twl.update_by as updateBy,twl.update_time as updateTime, twl.is_deleted as isDeleted,twl.salesman,twl.salesman_id as salesmanId,twl.listing_person as listingPerson,twl.fulfillment_type as fulfillmentType ,twl.template_id as templateId,twl.template_name as templateName, twl.freight_price as freightPrice,twl.product_state as productState,twl.average_rating,twl.transit_time as transitTime,IFNULL(lt.status,0) as titleStatus,lt.original_name as originalName, IFNULL(tpr.risk_level,0) as riskLevel,rpa.has_imitation_country as hasImitationCountry, group_concat(concat(ric.country_cn,'(',ric.short_thand,')')) AS imitationCountryCode, IFNULL(rpa.is_amazon_us_white_list,2) as isAmazonUsWhiteList,IFNULL(rpa.has_pattern,3) as hasPattern FROM t_walmart_listing twl left join t_walmart_listing_title lt on twl.source_id=lt.source_id and twl.source_sku=lt.source_sku left join t_walmart_listing_brand_change bc on twl.source_id=bc.source_id and twl.source_sku=bc.source_sku left join rb_product_risk_level_platform_country tpr on twl.sku = tpr.sku and twl.country_code = tpr.site_code and tpr.platform_id = 10 and tpr.platform_type = 45 and tpr.is_deleted = 0 left join rb_product_admin rpa on twl.sku = rpa.sku left join rb_imitation_country_comprehensive ric ON twl.sku = ric.sku left join rb_order_source ros ON ros.id = twl.source_id WHERE twl.source_id in ( 25611 , 22040 , 23594 , 25654 , 24634 , 22592 , 27716 , 26198 , 22106 , 23132 , 24181 , 22650 , 21626 , 23202 , 20643 , 23204 , 23205 , 24235 , 22237 , 28398 , 22274 , 22277 , 22794 , 23821 , 21805 , 24367 , 22841 , 23367 , 26979 , 23446 , 24999 , 23987 , 28625 , 26099 , 23033 , 22012 ) and twl.publish_status in ( 1 , 3 ) and twl.status in ( 1 ) and ( tpr.risk_level in ( 3 ) ) and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 58000,2000）
005- 解决方案：方案一（如果是导出可以暂用）：在下载中心nacos配置限流；方案二（推荐）：转到mysql处理

001- <br />
001+ <br /> 严重级别：严重<br /> 所属项目：walmart<br /> 问题原因：严重违反starrocks使用规范，影响面较广，在starrocks跑批（并发过高）（SELECT twl.id,twl.customer_id as customerId,twl.source_id as sourceId,twl.source_name as sourceName,twl.name,twl.name_cn as nameCn,twl.spu,twl.sku, twl.item_id as itemId,twl.source_sku as sourceSku,twl.main_image as mainImage,twl.platform_category_id as platformCategoryId,twl.platform_category_name as platformCategoryName, twl.brand_id as brandId,twl.brand,twl.publish_status as publishStatus,twl.status ,twl.tort ,twl.upc ,twl.gtin ,twl.sale_price as salePrice,twl.purchase_price as purchasePrice,twl.original_price as originalPrice, twl.days_to_ship as daysToShip,twl.first_publish_time as firstPublishTime,twl.primary_variant as primaryVariant,twl.has_variant as hasVariant,twl.has_new as hasNew,twl.description_type as descriptionType, twl.default_local_warehouse as defaultLocalWarehouse,twl.currency as currency,twl.country_code as countryCode,twl.create_by as createBy, twl.update_by as updateBy,twl.update_time as updateTime, twl.is_deleted as isDeleted,twl.salesman,twl.salesman_id as salesmanId,twl.listing_person as listingPerson,twl.fulfillment_type as fulfillmentType ,twl.template_id as templateId,twl.template_name as templateName, twl.freight_price as freightPrice,twl.product_state as productState,twl.average_rating,twl.transit_time as transitTime,IFNULL(lt.status,0) as titleStatus,lt.original_name as originalName, IFNULL(tpr.risk_level,0) as riskLevel,rpa.has_imitation_country as hasImitationCountry, group_concat(concat(ric.country_cn,'(',ric.short_thand,')')) AS imitationCountryCode, IFNULL(rpa.is_amazon_us_white_list,2) as isAmazonUsWhiteList,IFNULL(rpa.has_pattern,3) as hasPattern FROM t_walmart_listing twl left join t_walmart_listing_title lt on twl.source_id=lt.source_id and twl.source_sku=lt.source_sku left join t_walmart_listing_brand_change bc on twl.source_id=bc.source_id and twl.source_sku=bc.source_sku left join rb_product_risk_level_platform_country tpr on twl.sku = tpr.sku and twl.country_code = tpr.site_code and tpr.platform_id = 10 and tpr.platform_type = 45 and tpr.is_deleted = 0 left join rb_product_admin rpa on twl.sku = rpa.sku left join rb_imitation_country_comprehensive ric ON twl.sku = ric.sku left join rb_order_source ros ON ros.id = twl.source_id WHERE twl.source_id in ( 25611 , 22040 , 23594 , 25654 , 24634 , 22592 , 27716 , 26198 , 22106 , 23132 , 24181 , 22650 , 21626 , 23202 , 20643 , 23204 , 23205 , 24235 , 22237 , 28398 , 22274 , 22277 , 22794 , 23821 , 21805 , 24367 , 22841 , 23367 , 26979 , 23446 , 24999 , 23987 , 28625 , 26099 , 23033 , 22012 ) and twl.publish_status in ( 1 , 3 ) and twl.status in ( 1 ) and ( tpr.risk_level in ( 3 ) ) and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 58000,2000）<br /> 解决方案：方案一（如果是导出可以暂用）：在下载中心nacos配置限流；方案二（推荐）：转到mysql处理
002- 严重级别：严重<br />
003- 所属项目：walmart<br />
004- 问题原因：严重违反starrocks使用规范，影响面较广，在starrocks跑批（并发过高）（SELECT twl.id,twl.customer_id as customerId,twl.source_id as sourceId,twl.source_name as sourceName,twl.name,twl.name_cn as nameCn,twl.spu,twl.sku, twl.item_id as itemId,twl.source_sku as sourceSku,twl.main_image as mainImage,twl.platform_category_id as platformCategoryId,twl.platform_category_name as platformCategoryName, twl.brand_id as brandId,twl.brand,twl.publish_status as publishStatus,twl.status ,twl.tort ,twl.upc ,twl.gtin ,twl.sale_price as salePrice,twl.purchase_price as purchasePrice,twl.original_price as originalPrice, twl.days_to_ship as daysToShip,twl.first_publish_time as firstPublishTime,twl.primary_variant as primaryVariant,twl.has_variant as hasVariant,twl.has_new as hasNew,twl.description_type as descriptionType, twl.default_local_warehouse as defaultLocalWarehouse,twl.currency as currency,twl.country_code as countryCode,twl.create_by as createBy, twl.update_by as updateBy,twl.update_time as updateTime, twl.is_deleted as isDeleted,twl.salesman,twl.salesman_id as salesmanId,twl.listing_person as listingPerson,twl.fulfillment_type as fulfillmentType ,twl.template_id as templateId,twl.template_name as templateName, twl.freight_price as freightPrice,twl.product_state as productState,twl.average_rating,twl.transit_time as transitTime,IFNULL(lt.status,0) as titleStatus,lt.original_name as originalName, IFNULL(tpr.risk_level,0) as riskLevel,rpa.has_imitation_country as hasImitationCountry, group_concat(concat(ric.country_cn,'(',ric.short_thand,')')) AS imitationCountryCode, IFNULL(rpa.is_amazon_us_white_list,2) as isAmazonUsWhiteList,IFNULL(rpa.has_pattern,3) as hasPattern FROM t_walmart_listing twl left join t_walmart_listing_title lt on twl.source_id=lt.source_id and twl.source_sku=lt.source_sku left join t_walmart_listing_brand_change bc on twl.source_id=bc.source_id and twl.source_sku=bc.source_sku left join rb_product_risk_level_platform_country tpr on twl.sku = tpr.sku and twl.country_code = tpr.site_code and tpr.platform_id = 10 and tpr.platform_type = 45 and tpr.is_deleted = 0 left join rb_product_admin rpa on twl.sku = rpa.sku left join rb_imitation_country_comprehensive ric ON twl.sku = ric.sku left join rb_order_source ros ON ros.id = twl.source_id WHERE twl.source_id in ( 25611 , 22040 , 23594 , 25654 , 24634 , 22592 , 27716 , 26198 , 22106 , 23132 , 24181 , 22650 , 21626 , 23202 , 20643 , 23204 , 23205 , 24235 , 22237 , 28398 , 22274 , 22277 , 22794 , 23821 , 21805 , 24367 , 22841 , 23367 , 26979 , 23446 , 24999 , 23987 , 28625 , 26099 , 23033 , 22012 ) and twl.publish_status in ( 1 , 3 ) and twl.status in ( 1 ) and ( tpr.risk_level in ( 3 ) ) and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 58000,2000）<br />
005- 解决方案：方案一（如果是导出可以暂用）：在下载中心nacos配置限流；方案二（推荐）：转到mysql处理