反馈人:吴荣发
数据库:zhcxkj_center_listing_amazon
节点ID:71c519c608f342baae6f9f2af18f4559in01
查询时间:125.528
扫描行数:169338.0
返回行数:169338.0
一天执行次数: 32
慢日志时间:2025-07-30
指纹:01f42759de9c878c5a485e4741f36e63
SQL语句:select 'id' , 'customer_id' , 'source_id' , 'msku' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'remark_content' , 'remark_color' , 'remark_expiration_date' , 'issues' , 'issues_event_time' , 'product_images' , 'score_internal_detail' , 'trans_to_fba_pending_situation' , 'desc_update_time' , 'images_update_time' , 'generic_keyword_update_time' , 'bullet_point_update_time' , 'score_quality_detail' FROM ? force index ( idx_update_time ) where ( update_time < replace ( '?' , '?' , '?' ) AND update_time >= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? minute ) ) ;
真实SQL:select 'id','customer_id','source_id','msku','create_by','create_time','update_by','update_time','is_deleted','remark_content','remark_color','remark_expiration_date','issues','issues_event_time','product_images','score_internal_detail','trans_to_fba_pending_situation','desc_update_time','images_update_time','generic_keyword_update_time','bullet_point_update_time','score_quality_detail' from t_amazon_listing_properties_31 force index (idx_update_time) where (update_time= date_add(replace('2025-07-28 03:40:03','%',' '), INTERVAL -0 minute));
负责人参考:宋宁
项目参考:java项目
('2025-07-29>
重现步骤