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

修改了 解决方案，旧值为 ""，新值为 "history"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2025-12-03 17:47:10"。
修改了 指派给 ，旧值为 "weisicheng"，新值为 "chenlizhen"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "weisicheng"。

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

001-
001+ 反馈人：王凯
002- 反馈人：王凯
002+ HWY-ZH-GZ-RDS-ComprehensiveListing 实例 慢sql: SELECT tsgl.id as listingId, tsgl.status as listingStatus, tsgl.item_id, tsgl.item_sku, tsgl.source_id, tsgl.source_name, tsgl.first_publish_time as publishTime from t_shopee_global_listing tsgl WHERE tsgl.is_deleted = 0 and tsgl.status in (1,2,3) and tsgl.source_id =13975 and tsgl.first_publish_time >= 2024-01-01 00:00:00 and tsgl.first_publish_time <= 2025-08-31 23:59:59 -- and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_pubished tsglp WHERE -- tsglp.global_listing_id = tsgl.id and tsglp.is_deleted = 0 AND tsglp.STATUS IN ( 1, 3, 8 ) GROUP BY -- tsglp.global_listing_id) and tsgl.global_publish_status = 0 and tsgl.id > 0 and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_sku tsgls WHERE tsgls.global_listing_id = tsgl.id and tsgls.is_deleted = 0 and tsgls.sku in ( 17936893 ) GROUP BY tsgls.global_listing_id) order by tsgl.id asc limit 1000;
003-
004-
005- HWY-ZH-GZ-RDS-ComprehensiveListing 实例 慢sql: SELECT tsgl.id as listingId, tsgl.status as listingStatus, tsgl.item_id, tsgl.item_sku, tsgl.source_id, tsgl.source_name, tsgl.first_publish_time as publishTime from t_shopee_global_listing tsgl WHERE tsgl.is_deleted = 0 and tsgl.status in (1,2,3) and tsgl.source_id =13975 and tsgl.first_publish_time >= 2024-01-01 00:00:00 and tsgl.first_publish_time <= 2025-08-31 23:59:59 -- and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_pubished tsglp WHERE -- tsglp.global_listing_id = tsgl.id and tsglp.is_deleted = 0 AND tsglp.STATUS IN ( 1, 3, 8 ) GROUP BY -- tsglp.global_listing_id) and tsgl.global_publish_status = 0 and tsgl.id > 0 and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_sku tsgls WHERE tsgls.global_listing_id = tsgl.id and tsgls.is_deleted = 0 and tsgls.sku in ( 17936893 ) GROUP BY tsgls.global_listing_id) order by tsgl.id asc limit 1000;
006-

001- <p>
001+ <p>反馈人：王凯</p>
002- 反馈人：王凯
002+ <p>HWY-ZH-GZ-RDS-ComprehensiveListing 实例 慢sql: SELECT tsgl.id as listingId, tsgl.status as listingStatus, tsgl.item_id, tsgl.item_sku, tsgl.source_id, tsgl.source_name, tsgl.first_publish_time as publishTime from t_shopee_global_listing tsgl WHERE tsgl.is_deleted = 0 and tsgl.status in (1,2,3) and tsgl.source_id =13975 and tsgl.first_publish_time &gt;= 2024-01-01 00:00:00 and tsgl.first_publish_time &lt;= 2025-08-31 23:59:59 -- and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_pubished tsglp WHERE -- tsglp.global_listing_id = tsgl.id and tsglp.is_deleted = 0 AND tsglp.STATUS IN ( 1, 3, 8 ) GROUP BY -- tsglp.global_listing_id) and tsgl.global_publish_status = 0 and tsgl.id &gt; 0 and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_sku tsgls WHERE tsgls.global_listing_id = tsgl.id and tsgls.is_deleted = 0 and tsgls.sku in ( 17936893 ) GROUP BY tsgls.global_listing_id) order by tsgl.id asc limit 1000;</p>
003- </p>
004- <p>
005- HWY-ZH-GZ-RDS-ComprehensiveListing 实例 慢sql: SELECT tsgl.id as listingId, tsgl.status as listingStatus, tsgl.item_id, tsgl.item_sku, tsgl.source_id, tsgl.source_name, tsgl.first_publish_time as publishTime from t_shopee_global_listing tsgl WHERE tsgl.is_deleted = 0 and tsgl.status in (1,2,3) and tsgl.source_id =13975 and tsgl.first_publish_time &gt;= 2024-01-01 00:00:00 and tsgl.first_publish_time &lt;= 2025-08-31 23:59:59 -- and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_pubished tsglp WHERE -- tsglp.global_listing_id = tsgl.id and tsglp.is_deleted = 0 AND tsglp.STATUS IN ( 1, 3, 8 ) GROUP BY -- tsglp.global_listing_id) and tsgl.global_publish_status = 0 and tsgl.id &gt; 0 and tsgl.id not in (SELECT global_listing_id FROM t_shopee_global_listing_sku tsgls WHERE tsgls.global_listing_id = tsgl.id and tsgls.is_deleted = 0 and tsgls.sku in ( 17936893 ) GROUP BY tsgls.global_listing_id) order by tsgl.id asc limit 1000;
006- </p>

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
修改了 关闭日期，旧值为 ""，新值为 "2025-12-03 18:56:48"。