数据库：zhcxkj-center-warehouse
查询时间：60.9031
执行次数: 58
扫描行数：13173700
发送行数：1000
指纹SQL: SELECT warehouse_id , sku , good_num , id FROM ? WHERE ( api_update_time >= ? ) ORDER BY id ASC limit ? ;
真实SQL：SELECT warehouse_id,sku,good_num,id FROM rb_ware_house_product WHERE (api_update_time >= 2025-12-06 23:40:00) ORDER BY id ASC limit 1000;
袁慧斌,人工修改过
AISQL修改建议：SELECT warehouse_id, sku, good_num, id
FROM rb_ware_house_product
WHERE api_update_time >= 2025-12-06 23:40:00
ORDER BY id
LIMIT 1000;
explain表：
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | rb_ware_house_product | None | index | idx_api_update_time | PRIMARY | 8 | None | 3909 | 25.58 | Using where |
额外建议：
索引建议：
建议添加索引：ALTER TABLE rb_ware_house_product ADD INDEX idx_api_update_time_id(api_update_time,id);
【rb_ware_house_product】表 【api_update_time,id】字段，索引分析：
+-----------------------+---------------------+-----------------+---------------+
| TABLE_NAME | INDEX_NAME | COLUMN_NAME | CARDINALITY |
+=======================+=====================+=================+===============+
| rb_ware_house_product | idx_api_update_time | api_update_time | 1269898 |
+-----------------------+---------------------+-----------------+---------------+
| rb_ware_house_product | PRIMARY | id | 12375100 |
+-----------------------+---------------------+-----------------+---------------+
