重现步骤

反馈人:王凯

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;

历史记录  
  1. 2025-12-03 10:31:20, 由 陈莉珍 创建。
  2. 2025-12-03 18:30:44, 由 韦思成 解决,方案为 历史bug(180天以上) 。
    修改了 解决方案,旧值为 "",新值为 "history"。
    修改了 解决版本,旧值为 "",新值为 "trunk"。
    修改了 解决日期,旧值为 "",新值为 "2025-12-03 17:47:10"。
    修改了 指派给 ,旧值为 "weisicheng",新值为 "chenlizhen"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "weisicheng"。

    先自动删除服务关闭,转需求优化后再开启

  3. 2025-12-03 18:56:45, 由 陈莉珍 编辑。
    修改了 所属模块 ,旧值为 "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 &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;
    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 &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-
    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>
  4. 2025-12-03 18:56:48, 由 陈莉珍 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "chenlizhen",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "chenlizhen"。
    修改了 关闭日期,旧值为 "",新值为 "2025-12-03 18:56:48"。
所属项目 技术中心-需求池
所属模块 多平台   shopee
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 韦思成
测试责任人 郭晗
解决时效 7.26
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-12-03 18:56:48
截止日期 0000-00-00
上线时间 2025-12-03 17:47:10
上线时效 7.26
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-12-03 10:31:20
影响环境 生产环境-业务反馈
由谁解决 韦思成 于 2025-12-03 17:47:10
解决版本 主干
解决方案 历史bug(180天以上)
由谁关闭 陈莉珍 于 2025-12-03 18:56:48
最后修改 陈莉珍 于 2025-12-03 18:56:48
相关Bug