深圳智汇创想科技有限公司

修改了 指派给，旧值为 "renfangtao"，新值为 "liuhanze"。

修改了 指派给，旧值为 "liuhanze"，新值为 "renfangtao"。

修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2025-11-13 13:47:35"。
修改了 指派给 ，旧值为 "renfangtao"，新值为 "chenlizhen"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "renfangtao"。

修改了 所属模块 ，旧值为 "0"，新值为 "1868"。
修改了 业务部门 ，旧值为 "0"，新值为 "2"。
修改了 开发责任人，旧值为 ""，新值为 "renfangtao"。
修改了 测试责任人，旧值为 ""，新值为 "renfangtao"。
修改了 解决时效 ，旧值为 "0"，新值为 "4.11"。
修改了 重现步骤 ，区别为：

001-
001+ 反馈人：王凯
002- 反馈人：王凯
002+ starrocks大sql打爆数据库内存，内存开销：443GB ，优化 ，数据 分批、分步处理 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,twpri.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,twl.fist_online_time,twl.ship_methods as shipMethods, twl.is_no_sale as isNoSale, twl.has_law_firm_agent as hasLawFirmAgent 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 LEFT JOIN t_walmart_platform_report_item twpri ON twl.source_id = twpri.source_id and twl.source_sku=twpri.source_sku and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 10
003-
004-
005- starrocks大sql打爆数据库内存，内存开销：443GB ，优化 ，数据 分批、分步处理 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,twpri.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,twl.fist_online_time,twl.ship_methods as shipMethods, twl.is_no_sale as isNoSale, twl.has_law_firm_agent as hasLawFirmAgent 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 LEFT JOIN t_walmart_platform_report_item twpri ON twl.source_id = twpri.source_id and twl.source_sku=twpri.source_sku and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 10
006-

001- <p>
001+ <p>反馈人：王凯</p>
002- 反馈人：王凯
002+ <p>starrocks大sql打爆数据库内存，内存开销：443GB ，优化 ，数据 分批、分步处理 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,twpri.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,twl.fist_online_time,twl.ship_methods as shipMethods, twl.is_no_sale as isNoSale, twl.has_law_firm_agent as hasLawFirmAgent 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 LEFT JOIN t_walmart_platform_report_item twpri ON twl.source_id = twpri.source_id and twl.source_sku=twpri.source_sku and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 10</p>
003- </p>
004- <p>
005- starrocks大sql打爆数据库内存，内存开销：443GB ，优化 ，数据 分批、分步处理 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,twpri.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,twl.fist_online_time,twl.ship_methods as shipMethods, twl.is_no_sale as isNoSale, twl.has_law_firm_agent as hasLawFirmAgent 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 LEFT JOIN t_walmart_platform_report_item twpri ON twl.source_id = twpri.source_id and twl.source_sku=twpri.source_sku and ros.source_status != 3 group by twl.source_id,twl.source_sku ORDER BY twl.id DESC LIMIT 10
006- </p>

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
修改了 关闭日期，旧值为 ""，新值为 "2025-11-13 13:52:53"。