数据库：zhcxkj_center_listing_comprehensive
查询时间：401.676
执行次数: 24
扫描行数：2086670
发送行数：596470
指纹SQL: select id , source_id , source_name , sku , upc , spu , pf_listing_id , pf_sku , source_sku , status , status_name , moderate_status , category_id , category_name , image , title , stock , sale_price , price_color_index , min_price , min_price_update_time , currency , country_code , parent_category_id , is_archived , platform_atrributes , is_auto_archived , is_kgt , is_super , vat , publisher_id , publisher_name , sales_id , sales_name , fail_msg , publish_time , pf_online_time , pf_offline_time , pf_update_time , create_by , update_by , update_time , create_time , is_deleted , archived_status , status_update_time , modify_type FROM ? where ( update_time < ? AND update_time >= ? ) ;
真实SQL：select id,source_id,source_name,sku,upc,spu,pf_listing_id,pf_sku,source_sku,status,status_name,moderate_status,category_id,category_name,image,title,stock,sale_price,price_color_index,min_price,min_price_update_time,currency,country_code,parent_category_id,is_archived,platform_atrributes,is_auto_archived,is_kgt,is_super,vat,publisher_id,publisher_name,sales_id,sales_name,fail_msg,publish_time,pf_online_time,pf_offline_time,pf_update_time,create_by,update_by,update_time,create_time,is_deleted,archived_status,status_update_time,modify_type from t_listing_ozon where (update_time<2025/09/27 04:00:42 AND update_time>= 2025/09/27 03:00:32);
王凯,人工修改过
AISQL修改建议：
explain表：
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t_listing_ozon | None | range | idx_update_time | idx_update_time | 6 | None | 34636 | 100 | Using index condition |
额外建议：
索引建议：
索引之前就已加上