重现步骤

反馈人：王凯

问题1：

数据库：zhcxkj_center_datasync_comprehensive
查询时间：19.8114
扫描行数：5368810
发送行数：100
指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id > ? AND update_time > '?' AND update_time <= '?' ) ORDER BY id ASC limit ? ;
真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id > 0 AND update_time > '2024-12-16 21:50:01' AND update_time <= '2025-08-04 15:48:52') ORDER BY id ASC limit 100;
##无人工修改##
AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id > 0 AND update_time > '2024-12-16 21:50:01' AND update_time <= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100;
explain表：






id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t_shopee_published_item None range PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time PRIMARY 8 None 16676088 0.24 Using where

额外建议：
索引建议：
取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。

建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time);

【t_shopee_published_item】表 【id,update_time】字段，索引分析：
+-------------------------+---------------------------+---------------+---------------+
| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |
+=========================+===========================+===============+===============+
| t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 |
+-------------------------+---------------------------+---------------+---------------+
| t_shopee_published_item | idx_update_time | update_time | 2786773 |
+-------------------------+---------------------------+---------------+---------------+
| t_shopee_published_item | PRIMARY | id | 33192776 |
+-------------------------+---------------------------+---------------+---------------+



问题2：数据库：zhcxkj_center_datasync_comprehensive
查询时间：12.253
扫描行数：200
发送行数：100
指纹SQL: select b2 . id , b2 . customer_id , b2 . seller_id , b2 . source_id , b2 . global_item_id , b2 . category_id , b2 . global_item_name , b2 . description , b2 . global_item_sku , b2 . attribute_list , b2 . price_info , b2 . image , b2 . weight , b2 . dimension , b2 . pre_order , b2 . size_chart , b2 . has_condition , b2 . global_item_status , b2 . shopee_create_time , b2 . shopee_update_time , b2 . has_model , b2 . video , b2 . brand , b2 . stock_info , b2 . description_info , b2 . description_type , b2 . update_time , b2 . is_deleted from ( select b . id FROM ? b force key ( idx_update_time_id ) WHERE b . source_id = ? and b . id > ? and b . update_time > '?' and b . update_time <= '?' order by b . id asc limit ? ) b1 join t_shopee_item_global_base_info b2 on b1 . id = b2 . id ;
真实SQL：select b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku, b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time, b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deleted from (select b.id from t_shopee_item_global_base_info b force key(idx_update_time_id) WHERE b.source_id=13975 and b.id>58245533 and b.update_time > '2024-12-16 20:50:00' and b.update_time <= '2025-08-04 20:01:27' order by b.id asc limit 100 ) b1 join t_shopee_item_global_base_info b2 on b1.id=b2.id;
##无人工修改##
AISQL修改建议：SELECT b2.id,
b2.customer_id,
b2.seller_id,
b2.source_id,
b2.global_item_id,
b2.category_id,
b2.global_item_name,
b2.description,
b2.global_item_sku,
b2.attribute_list,
b2.price_info,
b2.image,
b2.weight,
b2.dimension,
b2.pre_order,
b2.size_chart,
b2.has_condition,
b2.global_item_status,
b2.shopee_create_time,
b2.shopee_update_time,
b2.has_model,
b2.video,
b2.brand,
b2.stock_info,
b2.description_info,
b2.description_type,
b2.update_time,
b2.is_deleted
FROM t_shopee_item_global_base_info b2
WHERE b2.id IN (
SELECT b.id
FROM t_shopee_item_global_base_info b
WHERE b.source_id = 13975
AND b.id > 58245533
AND b.update_time > '2024-12-16 20:50:00'
AND b.update_time <= '2025-08-04 20:01:27'
ORDER BY b.id ASC
LIMIT 100
);
explain表：






id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 PRIMARY <derived2> None ALL None None None None 100 100 None
1 PRIMARY b2 None eq_ref PRIMARY PRIMARY 8 b1.id 1 100 None
2 DERIVED b None range idx_update_time_id idx_update_time_id 13 None 10204968 33.33 Using where; Using index; Using filesort

额外建议：
索引建议：
→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。

【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：
+--------------------------------+--------------------+---------------+---------------+
| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |
+================================+====================+===============+===============+
| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |
+--------------------------------+--------------------+---------------+---------------+

→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。

【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：
+--------------------------------+--------------------+---------------+---------------+
| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |
+================================+====================+===============+===============+
| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |
+--------------------------------+--------------------+---------------+---------------+
| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |
+--------------------------------+--------------------+---------------+---------------+

历史记录  
  1. 2025-08-05 15:44:48, 由 陈莉珍 创建。
  2. 2025-08-05 15:45:46, 由 陈莉珍 编辑。
    修改了 所属模块，旧值为 "0"，新值为 "1869"。
    修改了 业务部门，旧值为 "0"，新值为 "2"。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 重现步骤，区别为：
    001- 反馈人：袁慧斌
    001+ 反馈人：王凯 数据库：zhcxkj_center_datasync_comprehensive 查询时间：19.8114 扫描行数：5368810 发送行数：100 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ; 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100; ##无人工修改## AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100; explain表：id
    002- 数据库：zhcxkj_center_datasync_comprehensive
    002+ select_type
    003- 查询时间：19.8114
    003+ table
    004- 扫描行数：5368810
    004+ partitions
    005- 发送行数：100
    005+ type
    006- 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ;
    006+ possible_keys
    007- 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100;
    007+ key
    008- ##无人工修改##
    008+ key_len
    009- AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100;
    009+ ref
    010- explain表：
    010+ rows
    011-
    011+ filtered
    012-
    012+ Extra
    013-
    013+ 1
    014-
    014+ SIMPLE
    015-
    015+ t_shopee_published_item
    016-
    016+ None
    017-
    017+ range
    018-
    018+ PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time
    019-
    019+ PRIMARY
    020-
    020+ 8
    021- id
    021+ None
    022-
    022+ 16676088
    023-
    023+ 0.24
    024- select_type
    024+ Using where
    025-
    025+
    026-
    026+ 额外建议： 索引建议： 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time); 【t_shopee_published_item】表 【id,update_time】字段，索引分析： +-------------------------+---------------------------+---------------+---------------+ | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY | +=========================+===========================+===============+===============+ | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 | +-------------------------+---------------------------+---------------+---------------+ | t_shopee_published_item | idx_update_time | update_time | 2786773 | +-------------------------+---------------------------+---------------+---------------+ | t_shopee_published_item | PRIMARY | id | 33192776 | +-------------------------+---------------------------+---------------+---------------+
    027- table
    028-
    029-
    030- partitions
    031-
    032-
    033- type
    034-
    035-
    036- possible_keys
    037-
    038-
    039- key
    040-
    041-
    042- key_len
    043-
    044-
    045- ref
    046-
    047-
    048- rows
    049-
    050-
    051- filtered
    052-
    053-
    054- Extra
    055-
    056-
    057-
    058-
    059-
    060-
    061- 1
    062-
    063-
    064- SIMPLE
    065-
    066-
    067- t_shopee_published_item
    068-
    069-
    070- None
    071-
    072-
    073- range
    074-
    075-
    076- PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time
    077-
    078-
    079- PRIMARY
    080-
    081-
    082- 8
    083-
    084-
    085- None
    086-
    087-
    088- 16676088
    089-
    090-
    091- 0.24
    092-
    093-
    094- Using where
    095-
    096-
    097-
    098-
    099-
    100- 额外建议：
    101- 索引建议：
    102- 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。
    103-
    104- 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time);
    105-
    106- 【t_shopee_published_item】表 【id,update_time】字段，索引分析：
    107- +-------------------------+---------------------------+---------------+---------------+
    108- | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |
    109- +=========================+===========================+===============+===============+
    110- | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 |
    111- +-------------------------+---------------------------+---------------+---------------+
    112- | t_shopee_published_item | idx_update_time | update_time | 2786773 |
    113- +-------------------------+---------------------------+---------------+---------------+
    114- | t_shopee_published_item | PRIMARY | id | 33192776 |
    115- +-------------------------+---------------------------+---------------+---------------+
    116-
    117-
    001- 反馈人：袁慧斌<br />
    001+ 反馈人：王凯<br /> 数据库：zhcxkj_center_datasync_comprehensive<br /> 查询时间：19.8114<br /> 扫描行数：5368810<br /> 发送行数：100<br /> 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ;<br /> 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100;<br /> ##无人工修改##<br /> AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100;<br /> explain表：<br /><br /><br /><br /><br /><br /><br /><table><tbody><tr><th>id</th>
    002- 数据库：zhcxkj_center_datasync_comprehensive<br />
    002+ <th>select_type</th>
    003- 查询时间：19.8114<br />
    003+ <th>table</th>
    004- 扫描行数：5368810<br />
    004+ <th>partitions</th>
    005- 发送行数：100<br />
    005+ <th>type</th>
    006- 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ;<br />
    006+ <th>possible_keys</th>
    007- 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100;<br />
    007+ <th>key</th>
    008- ##无人工修改##<br />
    008+ <th>key_len</th>
    009- AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100;<br />
    009+ <th>ref</th>
    010- explain表：<br />
    010+ <th>rows</th>
    011- <br />
    011+ <th>filtered</th>
    012- <br />
    012+ <th>Extra</th>
    013- <br />
    013+ </tr></tbody><tbody><tr><td>1</td>
    014- <br />
    014+ <td>SIMPLE</td>
    015- <br />
    015+ <td>t_shopee_published_item</td>
    016- <br />
    016+ <td>None</td>
    017- <table>
    017+ <td>range</td>
    018- <tbody>
    018+ <td>PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time</td>
    019- <tr>
    019+ <td>PRIMARY</td>
    020- <th>
    020+ <td>8</td>
    021- id
    021+ <td>None</td>
    022- </th>
    022+ <td>16676088</td>
    023- <th>
    023+ <td>0.24</td>
    024- select_type
    024+ <td>Using where</td>
    025- </th>
    025+ </tr></tbody></table><br />
    026- <th>
    026+ 额外建议：<br /> 索引建议：<br /> 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。<br /><span style="color:#FFA500;"><br /> 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time);</span><br /><br /> 【t_shopee_published_item】表 【id,update_time】字段，索引分析：<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |<br /> +=========================+===========================+===============+===============+<br /> | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | t_shopee_published_item | idx_update_time | update_time | 2786773 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | t_shopee_published_item | PRIMARY | id | 33192776 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /><br /><br />
    027- table
    028- </th>
    029- <th>
    030- partitions
    031- </th>
    032- <th>
    033- type
    034- </th>
    035- <th>
    036- possible_keys
    037- </th>
    038- <th>
    039- key
    040- </th>
    041- <th>
    042- key_len
    043- </th>
    044- <th>
    045- ref
    046- </th>
    047- <th>
    048- rows
    049- </th>
    050- <th>
    051- filtered
    052- </th>
    053- <th>
    054- Extra
    055- </th>
    056- </tr>
    057- </tbody>
    058- <tbody>
    059- <tr>
    060- <td>
    061- 1
    062- </td>
    063- <td>
    064- SIMPLE
    065- </td>
    066- <td>
    067- t_shopee_published_item
    068- </td>
    069- <td>
    070- None
    071- </td>
    072- <td>
    073- range
    074- </td>
    075- <td>
    076- PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time
    077- </td>
    078- <td>
    079- PRIMARY
    080- </td>
    081- <td>
    082- 8
    083- </td>
    084- <td>
    085- None
    086- </td>
    087- <td>
    088- 16676088
    089- </td>
    090- <td>
    091- 0.24
    092- </td>
    093- <td>
    094- Using where
    095- </td>
    096- </tr>
    097- </tbody>
    098- </table>
    099- <br />
    100- 额外建议：<br />
    101- 索引建议：<br />
    102- 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。<br />
    103- <span style="color:#FFA500;"><br />
    104- 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time);</span><br />
    105- <br />
    106- 【t_shopee_published_item】表 【id,update_time】字段，索引分析：<br />
    107- +-------------------------+---------------------------+---------------+---------------+<br />
    108- | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |<br />
    109- +=========================+===========================+===============+===============+<br />
    110- | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 |<br />
    111- +-------------------------+---------------------------+---------------+---------------+<br />
    112- | t_shopee_published_item | idx_update_time | update_time | 2786773 |<br />
    113- +-------------------------+---------------------------+---------------+---------------+<br />
    114- | t_shopee_published_item | PRIMARY | id | 33192776 |<br />
    115- +-------------------------+---------------------------+---------------+---------------+<br />
    116- <br />
    117- <br />
  3. 2025-08-05 15:47:31, 由 陈莉珍 编辑。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 重现步骤，区别为：
    001- 反馈人：王凯 数据库：zhcxkj_center_datasync_comprehensive 查询时间：19.8114 扫描行数：5368810 发送行数：100 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ; 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100; ##无人工修改## AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100; explain表：id
    001+ 反馈人：王凯
    002- select_type
    002+ 问题1：
    003- table
    003+ 数据库：zhcxkj_center_datasync_comprehensive
    004- partitions
    004+ 查询时间：19.8114 扫描行数：5368810 发送行数：100 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ; 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100; ##无人工修改## AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100; explain表：id
    005- type
    005+ select_type
    006- possible_keys
    006+ table
    007- key
    007+ partitions
    008- key_len
    008+ type
    009- ref
    009+ possible_keys
    010- rows
    010+ key
    011- filtered
    011+ key_len
    012- Extra
    012+ ref
    013- 1
    013+ rows
    014- SIMPLE
    014+ filtered
    015- t_shopee_published_item
    015+ Extra
    016- None
    016+ 1
    017- range
    017+ SIMPLE
    018- PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time
    018+ t_shopee_published_item
    019- PRIMARY
    019+ None
    020- 8
    020+ range
    021- None
    021+ PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time
    022- 16676088
    022+ PRIMARY
    023- 0.24
    023+ 8
    024- Using where
    024+ None
    025-
    025+ 16676088
    026- 额外建议： 索引建议： 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time); 【t_shopee_published_item】表 【id,update_time】字段，索引分析： +-------------------------+---------------------------+---------------+---------------+ | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY | +=========================+===========================+===============+===============+ | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 | +-------------------------+---------------------------+---------------+---------------+ | t_shopee_published_item | idx_update_time | update_time | 2786773 | +-------------------------+---------------------------+---------------+---------------+ | t_shopee_published_item | PRIMARY | id | 33192776 | +-------------------------+---------------------------+---------------+---------------+
    026+ 0.24
    027+ Using where
    028+
    029+ 额外建议： 索引建议： 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time); 【t_shopee_published_item】表 【id,update_time】字段，索引分析： +-------------------------+---------------------------+---------------+---------------+ | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY | +=========================+===========================+===============+===============+ | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 | +-------------------------+---------------------------+---------------+---------------+ | t_shopee_published_item | idx_update_time | update_time | 2786773 | +-------------------------+---------------------------+---------------+---------------+ | t_shopee_published_item | PRIMARY | id | 33192776 | +-------------------------+---------------------------+---------------+---------------+
    030+
    031+ 问题2：数据库：zhcxkj_center_datasync_comprehensive查询时间：12.253扫描行数：200发送行数：100指纹SQL: select b2 . id , b2 . customer_id , b2 . seller_id , b2 . source_id , b2 . global_item_id , b2 . category_id , b2 . global_item_name , b2 . description , b2 . global_item_sku , b2 . attribute_list , b2 . price_info , b2 . image , b2 . weight , b2 . dimension , b2 . pre_order , b2 . size_chart , b2 . has_condition , b2 . global_item_status , b2 . shopee_create_time , b2 . shopee_update_time , b2 . has_model , b2 . video , b2 . brand , b2 . stock_info , b2 . description_info , b2 . description_type , b2 . update_time , b2 . is_deleted from ( select b . id FROM ? b force key ( idx_update_time_id ) WHERE b . source_id = ? and b . id &gt; ? and b . update_time &gt; '?' and b . update_time &lt;= '?' order by b . id asc limit ? ) b1 join t_shopee_item_global_base_info b2 on b1 . id = b2 . id ;真实SQL：select b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku, b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time, b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deleted from (select b.id from t_shopee_item_global_base_info b force key(idx_update_time_id) WHERE b.source_id=13975 and b.id&gt;58245533 and b.update_time &gt; '2024-12-16 20:50:00' and b.update_time &lt;= '2025-08-04 20:01:27' order by b.id asc limit 100 ) b1 join t_shopee_item_global_base_info b2 on b1.id=b2.id;##无人工修改##AISQL修改建议：SELECT b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku,b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time,b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deletedFROM t_shopee_item_global_base_info b2WHERE b2.id IN (SELECT b.idFROM t_shopee_item_global_base_info bWHERE b.source_id = 13975AND b.id &gt; 58245533AND b.update_time &gt; '2024-12-16 20:50:00'AND b.update_time &lt;= '2025-08-04 20:01:27'ORDER BY b.id ASCLIMIT 100);explain表：id
    032+ select_type
    033+ table
    034+ partitions
    035+ type
    036+ possible_keys
    037+ key
    038+ key_len
    039+ ref
    040+ rows
    041+ filtered
    042+ Extra
    043+ 1
    044+ PRIMARY
    045+ &lt;derived2&gt;
    046+ None
    047+ ALL
    048+ None
    049+ None
    050+ None
    051+ None
    052+ 100
    053+ 100
    054+ None
    055+ 1
    056+ PRIMARY
    057+ b2
    058+ None
    059+ eq_ref
    060+ PRIMARY
    061+ PRIMARY
    062+ 8
    063+ b1.id
    064+ 1
    065+ 100
    066+ None
    067+ 2
    068+ DERIVED
    069+ b
    070+ None
    071+ range
    072+ idx_update_time_id
    073+ idx_update_time_id
    074+ 13
    075+ None
    076+ 10204968
    077+ 33.33
    078+ Using where; Using index; Using filesort
    079+ 额外建议：索引建议：→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：+--------------------------------+--------------------+---------------+---------------+| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |+================================+====================+===============+===============+| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |+--------------------------------+--------------------+---------------+---------------+→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：+--------------------------------+--------------------+---------------+---------------+| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |+================================+====================+===============+===============+| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |+--------------------------------+--------------------+---------------+---------------+
    001- 反馈人：王凯<br /> 数据库：zhcxkj_center_datasync_comprehensive<br /> 查询时间：19.8114<br /> 扫描行数：5368810<br /> 发送行数：100<br /> 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ;<br /> 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100;<br /> ##无人工修改##<br /> AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100;<br /> explain表：<br /><br /><br /><br /><br /><br /><br /><table><tbody><tr><th>id</th>
    001+ <p>反馈人：王凯</p>
    002- <th>select_type</th>
    002+ <p>问题1：</p>
    003- <th>table</th>
    003+ 数据库：zhcxkj_center_datasync_comprehensive<br />
    004- <th>partitions</th>
    004+ 查询时间：19.8114<br /> 扫描行数：5368810<br /> 发送行数：100<br /> 指纹SQL: SELECT id , customer_id , seller_id , source_id , global_item_id , shop_id , shop_region , item_id , item_status , create_time , update_time , is_deleted FROM ? WHERE ( source_id = ? AND id &gt; ? AND update_time &gt; '?' AND update_time &lt;= '?' ) ORDER BY id ASC limit ? ;<br /> 真实SQL：SELECT id,customer_id,seller_id,source_id,global_item_id,shop_id,shop_region,item_id,item_status,create_time,update_time,is_deleted FROM t_shopee_published_item WHERE (source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52') ORDER BY id ASC limit 100;<br /> ##无人工修改##<br /> AISQL修改建议：SELECT id, customer_id, seller_id, source_id, global_item_id, shop_id, shop_region, item_id, item_status, create_time, update_time, is_deleted FROM t_shopee_published_item FORCE INDEX(PRIMARY) WHERE source_id = 13927 AND id &gt; 0 AND update_time &gt; '2024-12-16 21:50:01' AND update_time &lt;= '2025-08-04 15:48:52' ORDER BY id ASC LIMIT 100;<br /> explain表：<br /><br /><br /><br /><br /><br /><br /><table><tbody><tr><th>id</th>
    005- <th>type</th>
    005+ <th>select_type</th>
    006- <th>possible_keys</th>
    006+ <th>table</th>
    007- <th>key</th>
    007+ <th>partitions</th>
    008- <th>key_len</th>
    008+ <th>type</th>
    009- <th>ref</th>
    009+ <th>possible_keys</th>
    010- <th>rows</th>
    010+ <th>key</th>
    011- <th>filtered</th>
    011+ <th>key_len</th>
    012- <th>Extra</th>
    012+ <th>ref</th>
    013- </tr></tbody><tbody><tr><td>1</td>
    013+ <th>rows</th>
    014- <td>SIMPLE</td>
    014+ <th>filtered</th>
    015- <td>t_shopee_published_item</td>
    015+ <th>Extra</th>
    016- <td>None</td>
    016+ </tr></tbody><tbody><tr><td>1</td>
    017- <td>range</td>
    017+ <td>SIMPLE</td>
    018- <td>PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time</td>
    018+ <td>t_shopee_published_item</td>
    019- <td>PRIMARY</td>
    019+ <td>None</td>
    020- <td>8</td>
    020+ <td>range</td>
    021- <td>None</td>
    021+ <td>PRIMARY,idx_source_id,IDX_source_id_update_time,idx_update_time</td>
    022- <td>16676088</td>
    022+ <td>PRIMARY</td>
    023- <td>0.24</td>
    023+ <td>8</td>
    024- <td>Using where</td>
    024+ <td>None</td>
    025- </tr></tbody></table><br />
    025+ <td>16676088</td>
    026- 额外建议：<br /> 索引建议：<br /> 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。<br /><span style="color:#FFA500;"><br /> 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time);</span><br /><br /> 【t_shopee_published_item】表 【id,update_time】字段，索引分析：<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |<br /> +=========================+===========================+===============+===============+<br /> | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | t_shopee_published_item | idx_update_time | update_time | 2786773 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | t_shopee_published_item | PRIMARY | id | 33192776 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /><br /><br />
    026+ <td>0.24</td>
    027+ <td>Using where</td>
    028+ </tr></tbody></table><br />
    029+ 额外建议：<br /> 索引建议：<br /> 取出表 【t_shopee_published_item】 where条件字段 【source_id】 100000 条记录，重复的数据有：【57367】 条，没有必要为该字段创建索引。<br /><span style="color:#FFA500;"><br /> 建议添加索引：ALTER TABLE t_shopee_published_item ADD INDEX idx_id_update_time(id,update_time);</span><br /><br /> 【t_shopee_published_item】表 【id,update_time】字段，索引分析：<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |<br /> +=========================+===========================+===============+===============+<br /> | t_shopee_published_item | IDX_source_id_update_time | update_time | 5219210 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | t_shopee_published_item | idx_update_time | update_time | 2786773 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /> | t_shopee_published_item | PRIMARY | id | 33192776 |<br /> +-------------------------+---------------------------+---------------+---------------+<br /><p><br /></p>
    030+ <p><br /></p>
    031+ <p>问题2：<span style="color:#000000;">数据库：zhcxkj_center_datasync_comprehensive</span><br /><span style="color:#000000;">查询时间：12.253</span><br /><span style="color:#000000;">扫描行数：200</span><br /><span style="color:#000000;">发送行数：100</span><br /><span style="color:#000000;">指纹SQL: select b2 . id , b2 . customer_id , b2 . seller_id , b2 . source_id , b2 . global_item_id , b2 . category_id , b2 . global_item_name , b2 . description , b2 . global_item_sku , b2 . attribute_list , b2 . price_info , b2 . image , b2 . weight , b2 . dimension , b2 . pre_order , b2 . size_chart , b2 . has_condition , b2 . global_item_status , b2 . shopee_create_time , b2 . shopee_update_time , b2 . has_model , b2 . video , b2 . brand , b2 . stock_info , b2 . description_info , b2 . description_type , b2 . update_time , b2 . is_deleted from ( select b . id FROM ? b force key ( idx_update_time_id ) WHERE b . source_id = ? and b . id &gt; ? and b . update_time &gt; '?' and b . update_time &lt;= '?' order by b . id asc limit ? ) b1 join t_shopee_item_global_base_info b2 on b1 . id = b2 . id ;</span><br /><span style="color:#000000;">真实SQL：select b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku, b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time, b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deleted from (select b.id from t_shopee_item_global_base_info b force key(idx_update_time_id) WHERE b.source_id=13975 and b.id&gt;58245533 and b.update_time &gt; '2024-12-16 20:50:00' and b.update_time &lt;= '2025-08-04 20:01:27' order by b.id asc limit 100 ) b1 join t_shopee_item_global_base_info b2 on b1.id=b2.id;</span><br /><span style="color:#000000;">##无人工修改##</span><br /><span style="color:#000000;">AISQL修改建议：SELECT b2.id,</span><br /><span style="color:#000000;">b2.customer_id,</span><br /><span style="color:#000000;">b2.seller_id,</span><br /><span style="color:#000000;">b2.source_id,</span><br /><span style="color:#000000;">b2.global_item_id,</span><br /><span style="color:#000000;">b2.category_id,</span><br /><span style="color:#000000;">b2.global_item_name,</span><br /><span style="color:#000000;">b2.description,</span><br /><span style="color:#000000;">b2.global_item_sku,</span><br /><span style="color:#000000;">b2.attribute_list,</span><br /><span style="color:#000000;">b2.price_info,</span><br /><span style="color:#000000;">b2.image,</span><br /><span style="color:#000000;">b2.weight,</span><br /><span style="color:#000000;">b2.dimension,</span><br /><span style="color:#000000;">b2.pre_order,</span><br /><span style="color:#000000;">b2.size_chart,</span><br /><span style="color:#000000;">b2.has_condition,</span><br /><span style="color:#000000;">b2.global_item_status,</span><br /><span style="color:#000000;">b2.shopee_create_time,</span><br /><span style="color:#000000;">b2.shopee_update_time,</span><br /><span style="color:#000000;">b2.has_model,</span><br /><span style="color:#000000;">b2.video,</span><br /><span style="color:#000000;">b2.brand,</span><br /><span style="color:#000000;">b2.stock_info,</span><br /><span style="color:#000000;">b2.description_info,</span><br /><span style="color:#000000;">b2.description_type,</span><br /><span style="color:#000000;">b2.update_time,</span><br /><span style="color:#000000;">b2.is_deleted</span><br /><span style="color:#000000;">FROM t_shopee_item_global_base_info b2</span><br /><span style="color:#000000;">WHERE b2.id IN (</span><br /><span style="color:#000000;">SELECT b.id</span><br /><span style="color:#000000;">FROM t_shopee_item_global_base_info b</span><br /><span style="color:#000000;">WHERE b.source_id = 13975</span><br /><span style="color:#000000;">AND b.id &gt; 58245533</span><br /><span style="color:#000000;">AND b.update_time &gt; '2024-12-16 20:50:00'</span><br /><span style="color:#000000;">AND b.update_time &lt;= '2025-08-04 20:01:27'</span><br /><span style="color:#000000;">ORDER BY b.id ASC</span><br /><span style="color:#000000;">LIMIT 100</span><br /><span style="color:#000000;">);</span><br /><span style="color:#000000;">explain表：</span><br /><br /><br /><br /><br /><br /><br /><br /><br /></p><table><tbody><tr><th>id</th>
    032+ <th>select_type</th>
    033+ <th>table</th>
    034+ <th>partitions</th>
    035+ <th>type</th>
    036+ <th>possible_keys</th>
    037+ <th>key</th>
    038+ <th>key_len</th>
    039+ <th>ref</th>
    040+ <th>rows</th>
    041+ <th>filtered</th>
    042+ <th>Extra</th>
    043+ </tr></tbody><tbody><tr><td style="font-size:12px;">1</td>
    044+ <td style="font-size:12px;">PRIMARY</td>
    045+ <td style="font-size:12px;">&lt;derived2&gt;</td>
    046+ <td style="font-size:12px;">None</td>
    047+ <td style="font-size:12px;">ALL</td>
    048+ <td style="font-size:12px;">None</td>
    049+ <td style="font-size:12px;">None</td>
    050+ <td style="font-size:12px;">None</td>
    051+ <td style="font-size:12px;">None</td>
    052+ <td style="font-size:12px;">100</td>
    053+ <td style="font-size:12px;">100</td>
    054+ <td style="font-size:12px;">None</td>
    055+ </tr><tr><td style="font-size:12px;">1</td>
    056+ <td style="font-size:12px;">PRIMARY</td>
    057+ <td style="font-size:12px;">b2</td>
    058+ <td style="font-size:12px;">None</td>
    059+ <td style="font-size:12px;">eq_ref</td>
    060+ <td style="font-size:12px;">PRIMARY</td>
    061+ <td style="font-size:12px;">PRIMARY</td>
    062+ <td style="font-size:12px;">8</td>
    063+ <td style="font-size:12px;">b1.id</td>
    064+ <td style="font-size:12px;">1</td>
    065+ <td style="font-size:12px;">100</td>
    066+ <td style="font-size:12px;">None</td>
    067+ </tr><tr><td style="font-size:12px;">2</td>
    068+ <td style="font-size:12px;">DERIVED</td>
    069+ <td style="font-size:12px;">b</td>
    070+ <td style="font-size:12px;">None</td>
    071+ <td style="font-size:12px;">range</td>
    072+ <td style="font-size:12px;">idx_update_time_id</td>
    073+ <td style="font-size:12px;">idx_update_time_id</td>
    074+ <td style="font-size:12px;">13</td>
    075+ <td style="font-size:12px;">None</td>
    076+ <td style="font-size:12px;">10204968</td>
    077+ <td style="font-size:12px;">33.33</td>
    078+ <td style="font-size:12px;">Using where; Using index; Using filesort</td>
    079+ </tr></tbody></table><br /><span style="color:#000000;">额外建议：</span><br /><span style="color:#000000;">索引建议：</span><br /><span>→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。</span><br /><br /><span style="color:#000000;">【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |</span><br /><span style="color:#000000;">+================================+====================+===============+===============+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><br /><span>→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。</span><br /><br /><span style="color:#000000;">【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |</span><br /><span style="color:#000000;">+================================+====================+===============+===============+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><br />
  4. 2025-08-05 15:55:44, 由 任芳涛 解决，方案为 历史bug（180天以上） 。
    修改了 解决方案，旧值为 ""，新值为 "history"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2025-08-05 15:55:06"。
    修改了 指派给 ，旧值为 "renfangtao"，新值为 "chenlizhen"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "renfangtao"。

  5. 2025-08-05 19:59:33, 由 陈莉珍 编辑。
    修改了 开发责任人，旧值为 ""，新值为 "renfangtao"。
    修改了 测试责任人，旧值为 ""，新值为 "renfangtao"。
    修改了 解决时效 ，旧值为 "0"，新值为 "0.17"。
    修改了 上线时间 ，旧值为 "0000-00-00 00:00:00"，新值为 "2025-08-05 15:55"。
    修改了 上线时效 ，旧值为 "-1"，新值为 "0.17"。
    修改了 重现步骤 ，区别为：
    031- 问题2：数据库：zhcxkj_center_datasync_comprehensive查询时间：12.253扫描行数：200发送行数：100指纹SQL: select b2 . id , b2 . customer_id , b2 . seller_id , b2 . source_id , b2 . global_item_id , b2 . category_id , b2 . global_item_name , b2 . description , b2 . global_item_sku , b2 . attribute_list , b2 . price_info , b2 . image , b2 . weight , b2 . dimension , b2 . pre_order , b2 . size_chart , b2 . has_condition , b2 . global_item_status , b2 . shopee_create_time , b2 . shopee_update_time , b2 . has_model , b2 . video , b2 . brand , b2 . stock_info , b2 . description_info , b2 . description_type , b2 . update_time , b2 . is_deleted from ( select b . id FROM ? b force key ( idx_update_time_id ) WHERE b . source_id = ? and b . id &gt; ? and b . update_time &gt; '?' and b . update_time &lt;= '?' order by b . id asc limit ? ) b1 join t_shopee_item_global_base_info b2 on b1 . id = b2 . id ;真实SQL：select b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku, b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time, b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deleted from (select b.id from t_shopee_item_global_base_info b force key(idx_update_time_id) WHERE b.source_id=13975 and b.id&gt;58245533 and b.update_time &gt; '2024-12-16 20:50:00' and b.update_time &lt;= '2025-08-04 20:01:27' order by b.id asc limit 100 ) b1 join t_shopee_item_global_base_info b2 on b1.id=b2.id;##无人工修改##AISQL修改建议：SELECT b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku,b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time,b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deletedFROM t_shopee_item_global_base_info b2WHERE b2.id IN (SELECT b.idFROM t_shopee_item_global_base_info bWHERE b.source_id = 13975AND b.id &gt; 58245533AND b.update_time &gt; '2024-12-16 20:50:00'AND b.update_time &lt;= '2025-08-04 20:01:27'ORDER BY b.id ASCLIMIT 100);explain表：id
    031+ 问题2：数据库：zhcxkj_center_datasync_comprehensive查询时间：12.253扫描行数：200发送行数：100指纹SQL: select b2 . id , b2 . customer_id , b2 . seller_id , b2 . source_id , b2 . global_item_id , b2 . category_id , b2 . global_item_name , b2 . description , b2 . global_item_sku , b2 . attribute_list , b2 . price_info , b2 . image , b2 . weight , b2 . dimension , b2 . pre_order , b2 . size_chart , b2 . has_condition , b2 . global_item_status , b2 . shopee_create_time , b2 . shopee_update_time , b2 . has_model , b2 . video , b2 . brand , b2 . stock_info , b2 . description_info , b2 . description_type , b2 . update_time , b2 . is_deleted from ( select b . id FROM ? b force key ( idx_update_time_id ) WHERE b . source_id = ? and b . id &gt; ? and b . update_time &gt; '?' and b . update_time &lt;= '?' order by b . id asc limit ? ) b1 join t_shopee_item_global_base_info b2 on b1 . id = b2 . id ;真实SQL：select b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku, b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time, b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deleted from (select b.id from t_shopee_item_global_base_info b force key(idx_update_time_id) WHERE b.source_id=13975 and b.id&gt;58245533 and b.update_time &gt; '2024-12-16 20:50:00' and b.update_time &lt;= '2025-08-04 20:01:27' order by b.id asc limit 100 ) b1 join t_shopee_item_global_base_info b2 on b1.id=b2.id;##无人工修改##AISQL修改建议：SELECT b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku,b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time,b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deletedFROM t_shopee_item_global_base_info b2WHERE b2.id IN (SELECT b.idFROM t_shopee_item_global_base_info bWHERE b.source_id = 13975AND b.id &gt; 58245533AND b.update_time &gt; '2024-12-16 20:50:00'AND b.update_time &lt;= '2025-08-04 20:01:27'ORDER BY b.id ASCLIMIT 100);explain表：
    032- select_type
    032+ id
    033- table
    033+ select_type
    034- partitions
    034+ table
    035- type
    035+ partitions
    036- possible_keys
    036+ type
    037- key
    037+ possible_keys
    038- key_len
    038+ key
    039- ref
    039+ key_len
    040- rows
    040+ ref
    041- filtered
    041+ rows
    042- Extra
    042+ filtered
    043- 1
    043+ Extra
    044- PRIMARY
    044+ 1
    045- &lt;derived2&gt;
    045+ PRIMARY
    046- None
    046+ &lt;derived2&gt;
    047- ALL
    047+ None
    048- None
    048+ ALL
    049- None
    049+ None
    050- None
    050+ None
    051- None
    051+ None
    052- 100
    052+ None
    053- 100
    053+ 100
    054- None
    054+ 100
    055- 1
    055+ None
    056- PRIMARY
    056+ 1
    057- b2
    057+ PRIMARY
    058- None
    058+ b2
    059- eq_ref
    059+ None
    060- PRIMARY
    060+ eq_ref
    061- PRIMARY
    061+ PRIMARY
    062- 8
    062+ PRIMARY
    063- b1.id
    063+ 8
    064- 1
    064+ b1.id
    065- 100
    065+ 1
    066- None
    066+ 100
    067- 2
    067+ None
    068- DERIVED
    068+ 2
    069- b
    069+ DERIVED
    070- None
    070+ b
    071- range
    071+ None
    072- idx_update_time_id
    072+ range
    073- idx_update_time_id
    073+ idx_update_time_id
    074- 13
    074+ idx_update_time_id
    075- None
    075+ 13
    076- 10204968
    076+ None
    077- 33.33
    077+ 10204968
    078- Using where; Using index; Using filesort
    078+ 33.33
    079- 额外建议：索引建议：→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：+--------------------------------+--------------------+---------------+---------------+| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |+================================+====================+===============+===============+| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |+--------------------------------+--------------------+---------------+---------------+→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：+--------------------------------+--------------------+---------------+---------------+| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |+================================+====================+===============+===============+| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |+--------------------------------+--------------------+---------------+---------------+
    079+ Using where; Using index; Using filesort
    080+ 额外建议：索引建议：→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：+--------------------------------+--------------------+---------------+---------------+| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |+================================+====================+===============+===============+| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |+--------------------------------+--------------------+---------------+---------------+→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：+--------------------------------+--------------------+---------------+---------------+| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |+================================+====================+===============+===============+| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |+--------------------------------+--------------------+---------------+---------------+| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |+--------------------------------+--------------------+---------------+---------------+
    031- <p>问题2：<span style="color:#000000;">数据库：zhcxkj_center_datasync_comprehensive</span><br /><span style="color:#000000;">查询时间：12.253</span><br /><span style="color:#000000;">扫描行数：200</span><br /><span style="color:#000000;">发送行数：100</span><br /><span style="color:#000000;">指纹SQL: select b2 . id , b2 . customer_id , b2 . seller_id , b2 . source_id , b2 . global_item_id , b2 . category_id , b2 . global_item_name , b2 . description , b2 . global_item_sku , b2 . attribute_list , b2 . price_info , b2 . image , b2 . weight , b2 . dimension , b2 . pre_order , b2 . size_chart , b2 . has_condition , b2 . global_item_status , b2 . shopee_create_time , b2 . shopee_update_time , b2 . has_model , b2 . video , b2 . brand , b2 . stock_info , b2 . description_info , b2 . description_type , b2 . update_time , b2 . is_deleted from ( select b . id FROM ? b force key ( idx_update_time_id ) WHERE b . source_id = ? and b . id &gt; ? and b . update_time &gt; '?' and b . update_time &lt;= '?' order by b . id asc limit ? ) b1 join t_shopee_item_global_base_info b2 on b1 . id = b2 . id ;</span><br /><span style="color:#000000;">真实SQL：select b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku, b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time, b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deleted from (select b.id from t_shopee_item_global_base_info b force key(idx_update_time_id) WHERE b.source_id=13975 and b.id&gt;58245533 and b.update_time &gt; '2024-12-16 20:50:00' and b.update_time &lt;= '2025-08-04 20:01:27' order by b.id asc limit 100 ) b1 join t_shopee_item_global_base_info b2 on b1.id=b2.id;</span><br /><span style="color:#000000;">##无人工修改##</span><br /><span style="color:#000000;">AISQL修改建议：SELECT b2.id,</span><br /><span style="color:#000000;">b2.customer_id,</span><br /><span style="color:#000000;">b2.seller_id,</span><br /><span style="color:#000000;">b2.source_id,</span><br /><span style="color:#000000;">b2.global_item_id,</span><br /><span style="color:#000000;">b2.category_id,</span><br /><span style="color:#000000;">b2.global_item_name,</span><br /><span style="color:#000000;">b2.description,</span><br /><span style="color:#000000;">b2.global_item_sku,</span><br /><span style="color:#000000;">b2.attribute_list,</span><br /><span style="color:#000000;">b2.price_info,</span><br /><span style="color:#000000;">b2.image,</span><br /><span style="color:#000000;">b2.weight,</span><br /><span style="color:#000000;">b2.dimension,</span><br /><span style="color:#000000;">b2.pre_order,</span><br /><span style="color:#000000;">b2.size_chart,</span><br /><span style="color:#000000;">b2.has_condition,</span><br /><span style="color:#000000;">b2.global_item_status,</span><br /><span style="color:#000000;">b2.shopee_create_time,</span><br /><span style="color:#000000;">b2.shopee_update_time,</span><br /><span style="color:#000000;">b2.has_model,</span><br /><span style="color:#000000;">b2.video,</span><br /><span style="color:#000000;">b2.brand,</span><br /><span style="color:#000000;">b2.stock_info,</span><br /><span style="color:#000000;">b2.description_info,</span><br /><span style="color:#000000;">b2.description_type,</span><br /><span style="color:#000000;">b2.update_time,</span><br /><span style="color:#000000;">b2.is_deleted</span><br /><span style="color:#000000;">FROM t_shopee_item_global_base_info b2</span><br /><span style="color:#000000;">WHERE b2.id IN (</span><br /><span style="color:#000000;">SELECT b.id</span><br /><span style="color:#000000;">FROM t_shopee_item_global_base_info b</span><br /><span style="color:#000000;">WHERE b.source_id = 13975</span><br /><span style="color:#000000;">AND b.id &gt; 58245533</span><br /><span style="color:#000000;">AND b.update_time &gt; '2024-12-16 20:50:00'</span><br /><span style="color:#000000;">AND b.update_time &lt;= '2025-08-04 20:01:27'</span><br /><span style="color:#000000;">ORDER BY b.id ASC</span><br /><span style="color:#000000;">LIMIT 100</span><br /><span style="color:#000000;">);</span><br /><span style="color:#000000;">explain表：</span><br /><br /><br /><br /><br /><br /><br /><br /><br /></p><table><tbody><tr><th>id</th>
    031+ <p>问题2：<span style="color:#000000;">数据库：zhcxkj_center_datasync_comprehensive</span><br /><span style="color:#000000;">查询时间：12.253</span><br /><span style="color:#000000;">扫描行数：200</span><br /><span style="color:#000000;">发送行数：100</span><br /><span style="color:#000000;">指纹SQL: select b2 . id , b2 . customer_id , b2 . seller_id , b2 . source_id , b2 . global_item_id , b2 . category_id , b2 . global_item_name , b2 . description , b2 . global_item_sku , b2 . attribute_list , b2 . price_info , b2 . image , b2 . weight , b2 . dimension , b2 . pre_order , b2 . size_chart , b2 . has_condition , b2 . global_item_status , b2 . shopee_create_time , b2 . shopee_update_time , b2 . has_model , b2 . video , b2 . brand , b2 . stock_info , b2 . description_info , b2 . description_type , b2 . update_time , b2 . is_deleted from ( select b . id FROM ? b force key ( idx_update_time_id ) WHERE b . source_id = ? and b . id &gt; ? and b . update_time &gt; '?' and b . update_time &lt;= '?' order by b . id asc limit ? ) b1 join t_shopee_item_global_base_info b2 on b1 . id = b2 . id ;</span><br /><span style="color:#000000;">真实SQL：select b2.id,b2.customer_id,b2.seller_id,b2.source_id,b2.global_item_id,b2.category_id,b2.global_item_name,b2.description,b2.global_item_sku, b2.attribute_list,b2.price_info,b2.image,b2.weight,b2.dimension,b2.pre_order,b2.size_chart,b2.has_condition,b2.global_item_status,b2.shopee_create_time, b2.shopee_update_time,b2.has_model,b2.video,b2.brand,b2.stock_info,b2.description_info,b2.description_type,b2.update_time,b2.is_deleted from (select b.id from t_shopee_item_global_base_info b force key(idx_update_time_id) WHERE b.source_id=13975 and b.id&gt;58245533 and b.update_time &gt; '2024-12-16 20:50:00' and b.update_time &lt;= '2025-08-04 20:01:27' order by b.id asc limit 100 ) b1 join t_shopee_item_global_base_info b2 on b1.id=b2.id;</span><br /><span style="color:#000000;">##无人工修改##</span><br /><span style="color:#000000;">AISQL修改建议：SELECT b2.id,</span><br /><span style="color:#000000;">b2.customer_id,</span><br /><span style="color:#000000;">b2.seller_id,</span><br /><span style="color:#000000;">b2.source_id,</span><br /><span style="color:#000000;">b2.global_item_id,</span><br /><span style="color:#000000;">b2.category_id,</span><br /><span style="color:#000000;">b2.global_item_name,</span><br /><span style="color:#000000;">b2.description,</span><br /><span style="color:#000000;">b2.global_item_sku,</span><br /><span style="color:#000000;">b2.attribute_list,</span><br /><span style="color:#000000;">b2.price_info,</span><br /><span style="color:#000000;">b2.image,</span><br /><span style="color:#000000;">b2.weight,</span><br /><span style="color:#000000;">b2.dimension,</span><br /><span style="color:#000000;">b2.pre_order,</span><br /><span style="color:#000000;">b2.size_chart,</span><br /><span style="color:#000000;">b2.has_condition,</span><br /><span style="color:#000000;">b2.global_item_status,</span><br /><span style="color:#000000;">b2.shopee_create_time,</span><br /><span style="color:#000000;">b2.shopee_update_time,</span><br /><span style="color:#000000;">b2.has_model,</span><br /><span style="color:#000000;">b2.video,</span><br /><span style="color:#000000;">b2.brand,</span><br /><span style="color:#000000;">b2.stock_info,</span><br /><span style="color:#000000;">b2.description_info,</span><br /><span style="color:#000000;">b2.description_type,</span><br /><span style="color:#000000;">b2.update_time,</span><br /><span style="color:#000000;">b2.is_deleted</span><br /><span style="color:#000000;">FROM t_shopee_item_global_base_info b2</span><br /><span style="color:#000000;">WHERE b2.id IN (</span><br /><span style="color:#000000;">SELECT b.id</span><br /><span style="color:#000000;">FROM t_shopee_item_global_base_info b</span><br /><span style="color:#000000;">WHERE b.source_id = 13975</span><br /><span style="color:#000000;">AND b.id &gt; 58245533</span><br /><span style="color:#000000;">AND b.update_time &gt; '2024-12-16 20:50:00'</span><br /><span style="color:#000000;">AND b.update_time &lt;= '2025-08-04 20:01:27'</span><br /><span style="color:#000000;">ORDER BY b.id ASC</span><br /><span style="color:#000000;">LIMIT 100</span><br /><span style="color:#000000;">);</span><br /><span style="color:#000000;">explain表：</span><br /><br /><br /><br /><br /><br /><br /></p>
    032- <th>select_type</th>
    032+ <table><tbody><tr><th>id</th>
    033- <th>table</th>
    033+ <th>select_type</th>
    034- <th>partitions</th>
    034+ <th>table</th>
    035- <th>type</th>
    035+ <th>partitions</th>
    036- <th>possible_keys</th>
    036+ <th>type</th>
    037- <th>key</th>
    037+ <th>possible_keys</th>
    038- <th>key_len</th>
    038+ <th>key</th>
    039- <th>ref</th>
    039+ <th>key_len</th>
    040- <th>rows</th>
    040+ <th>ref</th>
    041- <th>filtered</th>
    041+ <th>rows</th>
    042- <th>Extra</th>
    042+ <th>filtered</th>
    043- </tr></tbody><tbody><tr><td style="font-size:12px;">1</td>
    043+ <th>Extra</th>
    044- <td style="font-size:12px;">PRIMARY</td>
    044+ </tr></tbody><tbody><tr><td style="font-size:12px;">1</td>
    045- <td style="font-size:12px;">&lt;derived2&gt;</td>
    045+ <td style="font-size:12px;">PRIMARY</td>
    046- <td style="font-size:12px;">None</td>
    046+ <td style="font-size:12px;">&lt;derived2&gt;</td>
    047- <td style="font-size:12px;">ALL</td>
    047+ <td style="font-size:12px;">None</td>
    048- <td style="font-size:12px;">None</td>
    048+ <td style="font-size:12px;">ALL</td>
    049- <td style="font-size:12px;">None</td>
    049+ <td style="font-size:12px;">None</td>
    050- <td style="font-size:12px;">None</td>
    050+ <td style="font-size:12px;">None</td>
    051- <td style="font-size:12px;">None</td>
    051+ <td style="font-size:12px;">None</td>
    052- <td style="font-size:12px;">100</td>
    052+ <td style="font-size:12px;">None</td>
    053- <td style="font-size:12px;">100</td>
    053+ <td style="font-size:12px;">100</td>
    054- <td style="font-size:12px;">None</td>
    054+ <td style="font-size:12px;">100</td>
    055- </tr><tr><td style="font-size:12px;">1</td>
    055+ <td style="font-size:12px;">None</td>
    056- <td style="font-size:12px;">PRIMARY</td>
    056+ </tr><tr><td style="font-size:12px;">1</td>
    057- <td style="font-size:12px;">b2</td>
    057+ <td style="font-size:12px;">PRIMARY</td>
    058- <td style="font-size:12px;">None</td>
    058+ <td style="font-size:12px;">b2</td>
    059- <td style="font-size:12px;">eq_ref</td>
    059+ <td style="font-size:12px;">None</td>
    060- <td style="font-size:12px;">PRIMARY</td>
    060+ <td style="font-size:12px;">eq_ref</td>
    061- <td style="font-size:12px;">PRIMARY</td>
    061+ <td style="font-size:12px;">PRIMARY</td>
    062- <td style="font-size:12px;">8</td>
    062+ <td style="font-size:12px;">PRIMARY</td>
    063- <td style="font-size:12px;">b1.id</td>
    063+ <td style="font-size:12px;">8</td>
    064- <td style="font-size:12px;">1</td>
    064+ <td style="font-size:12px;">b1.id</td>
    065- <td style="font-size:12px;">100</td>
    065+ <td style="font-size:12px;">1</td>
    066- <td style="font-size:12px;">None</td>
    066+ <td style="font-size:12px;">100</td>
    067- </tr><tr><td style="font-size:12px;">2</td>
    067+ <td style="font-size:12px;">None</td>
    068- <td style="font-size:12px;">DERIVED</td>
    068+ </tr><tr><td style="font-size:12px;">2</td>
    069- <td style="font-size:12px;">b</td>
    069+ <td style="font-size:12px;">DERIVED</td>
    070- <td style="font-size:12px;">None</td>
    070+ <td style="font-size:12px;">b</td>
    071- <td style="font-size:12px;">range</td>
    071+ <td style="font-size:12px;">None</td>
    072- <td style="font-size:12px;">idx_update_time_id</td>
    072+ <td style="font-size:12px;">range</td>
    073- <td style="font-size:12px;">idx_update_time_id</td>
    073+ <td style="font-size:12px;">idx_update_time_id</td>
    074- <td style="font-size:12px;">13</td>
    074+ <td style="font-size:12px;">idx_update_time_id</td>
    075- <td style="font-size:12px;">None</td>
    075+ <td style="font-size:12px;">13</td>
    076- <td style="font-size:12px;">10204968</td>
    076+ <td style="font-size:12px;">None</td>
    077- <td style="font-size:12px;">33.33</td>
    077+ <td style="font-size:12px;">10204968</td>
    078- <td style="font-size:12px;">Using where; Using index; Using filesort</td>
    078+ <td style="font-size:12px;">33.33</td>
    079- </tr></tbody></table><br /><span style="color:#000000;">额外建议：</span><br /><span style="color:#000000;">索引建议：</span><br /><span>→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。</span><br /><br /><span style="color:#000000;">【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |</span><br /><span style="color:#000000;">+================================+====================+===============+===============+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><br /><span>→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。</span><br /><br /><span style="color:#000000;">【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |</span><br /><span style="color:#000000;">+================================+====================+===============+===============+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><br />
    079+ <td style="font-size:12px;">Using where; Using index; Using filesort</td>
    080+ </tr></tbody></table><br /><span style="color:#000000;">额外建议：</span><br /><span style="color:#000000;">索引建议：</span><br /><span>→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。</span><br /><br /><span style="color:#000000;">【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |</span><br /><span style="color:#000000;">+================================+====================+===============+===============+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><br /><span>→ 【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，联合索引已经存在，无需添加任何索引。</span><br /><br /><span style="color:#000000;">【t_shopee_item_global_base_info】表 【source_id,id,update_time】字段，索引分析：</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |</span><br /><span style="color:#000000;">+================================+====================+===============+===============+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_source_id | source_id | 17019 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time | update_time | 993424 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | source_id | 15442 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | update_time | 781548 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | idx_update_time_id | id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | PRIMARY | id | 34253392 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><span style="color:#000000;">| t_shopee_item_global_base_info | uk_global_item_id | source_id | 34264416 |</span><br /><span style="color:#000000;">+--------------------------------+--------------------+---------------+---------------+</span><br /><br />
  6. 2025-08-05 19:59:36, 由 陈莉珍 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-08-05 19:59:36"。
返回
所属项目 技术中心-需求池
所属模块 多平台   shopee
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 任芳涛
测试责任人 任芳涛
解决时效 0.17
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-08-05 19:59:36
截止日期 0000-00-00
上线时间 2025-08-05 15:55:00
上线时效 0.17
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-08-05 15:44:48
影响环境 生产环境-业务反馈
由谁解决 任芳涛 于 2025-08-05 15:55:06
解决版本 主干
解决方案 历史bug（180天以上）
由谁关闭 陈莉珍 于 2025-08-05 19:59:36
最后修改 陈莉珍 于 2025-08-05 19:59:36
相关Bug