001- 反馈人：吴荣发
001+ 反馈人：吴荣发 数据库：zhcxkj_center_listing_comprehensive 节点ID：497fd948de9643998944407f361dd881in01 查询时间：115.124 扫描行数：205241.0 返回行数：26 一天执行次数： 205241.0 慢日志时间：2025-07-17 指纹：92e1e6c1fc555e6b2b164002e909afd9 SQL语句：select 'id' , 'customer_id' , 'source_id' , 'source_name' , 'name' , 'name_cn' , 'gtin' , 'spu' , 'sku' , 'item_id' , 'source_sku' , 'main_image' , 'platform_category_id' , 'platform_category_name' , 'brand_id' , 'brand' , 'publish_status' , 'status' , 'product_state' , 'tort' , 'upc' , 'sale_price' , 'purchase_price' , 'original_price' , 'days_to_ship' , 'first_publish_time' , 'primary_variant' , 'has_variant' , 'has_new' , 'description_type' , 'default_local_warehouse' , 'currency' , 'country_code' , 'remark' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'salesman_id' , 'salesman' , 'listing_person' , 'fulfillment_type' , 'template_id' , 'template_name' , 'freight_price' , 'average_rating' , 'transit_time' FROM ? force index ( idx_update_time ) where ( update_time < replace ( '?' , '?' , '?' ) AND update_time >= DATE_SUB ( replace ( '?' , '?' , '?' ) , INTERVAL ? MINUTE ) ) ; 真实SQL：select 'id','customer_id','source_id','source_name','name','name_cn','gtin','spu','sku','item_id','source_sku','main_image','platform_category_id','platform_category_name','brand_id','brand','publish_status','status','product_state','tort','upc','sale_price','purchase_price','original_price','days_to_ship','first_publish_time','primary_variant','has_variant','has_new','description_type','default_local_warehouse','currency','country_code','remark','create_by','create_time','update_by','update_time','is_deleted','salesman_id','salesman','listing_person','fulfillment_type','template_id','template_name','freight_price','average_rating','transit_time' from t_walmart_listing force index(idx_update_time) where (update_time= DATE_SUB(replace('2025-07-16 07:30:00','%',' '),INTERVAL 5 MINUTE)); 负责人参考：蔡俊伟 项目参考：java项目('2025-07-16>
002- 数据库：zhcxkj_center_listing_comprehensive
003- 节点ID：497fd948de9643998944407f361dd881in01
004- 查询时间：115.124
005- 扫描行数：205241.0
006- 返回行数：26
007- 一天执行次数： 205241.0
008- 慢日志时间：2025-07-17
009- 指纹：92e1e6c1fc555e6b2b164002e909afd9
010- SQL语句：select 'id' , 'customer_id' , 'source_id' , 'source_name' , 'name' , 'name_cn' , 'gtin' , 'spu' , 'sku' , 'item_id' , 'source_sku' , 'main_image' , 'platform_category_id' , 'platform_category_name' , 'brand_id' , 'brand' , 'publish_status' , 'status' , 'product_state' , 'tort' , 'upc' , 'sale_price' , 'purchase_price' , 'original_price' , 'days_to_ship' , 'first_publish_time' , 'primary_variant' , 'has_variant' , 'has_new' , 'description_type' , 'default_local_warehouse' , 'currency' , 'country_code' , 'remark' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'salesman_id' , 'salesman' , 'listing_person' , 'fulfillment_type' , 'template_id' , 'template_name' , 'freight_price' , 'average_rating' , 'transit_time' FROM ? force index ( idx_update_time ) where ( update_time < replace ( '?' , '?' , '?' ) AND update_time >= DATE_SUB ( replace ( '?' , '?' , '?' ) , INTERVAL ? MINUTE ) ) ;
011- 真实SQL：select 'id','customer_id','source_id','source_name','name','name_cn','gtin','spu','sku','item_id','source_sku','main_image','platform_category_id','platform_category_name','brand_id','brand','publish_status','status','product_state','tort','upc','sale_price','purchase_price','original_price','days_to_ship','first_publish_time','primary_variant','has_variant','has_new','description_type','default_local_warehouse','currency','country_code','remark','create_by','create_time','update_by','update_time','is_deleted','salesman_id','salesman','listing_person','fulfillment_type','template_id','template_name','freight_price','average_rating','transit_time' from t_walmart_listing force index(idx_update_time) where (update_time= DATE_SUB(replace('2025-07-16 07:30:00','%',' '),INTERVAL 5 MINUTE));
012- 负责人参考：蔡俊伟
013- 项目参考：java项目
014-

001- 反馈人：吴荣发<br />
001+ 反馈人：吴荣发<br /> 数据库：zhcxkj_center_listing_comprehensive<br /> 节点ID：497fd948de9643998944407f361dd881in01<br /> 查询时间：115.124<br /> 扫描行数：205241.0<br /> 返回行数：26<br /> 一天执行次数： 205241.0<br /> 慢日志时间：2025-07-17<br /> 指纹：92e1e6c1fc555e6b2b164002e909afd9<br /> SQL语句：select 'id' , 'customer_id' , 'source_id' , 'source_name' , 'name' , 'name_cn' , 'gtin' , 'spu' , 'sku' , 'item_id' , 'source_sku' , 'main_image' , 'platform_category_id' , 'platform_category_name' , 'brand_id' , 'brand' , 'publish_status' , 'status' , 'product_state' , 'tort' , 'upc' , 'sale_price' , 'purchase_price' , 'original_price' , 'days_to_ship' , 'first_publish_time' , 'primary_variant' , 'has_variant' , 'has_new' , 'description_type' , 'default_local_warehouse' , 'currency' , 'country_code' , 'remark' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'salesman_id' , 'salesman' , 'listing_person' , 'fulfillment_type' , 'template_id' , 'template_name' , 'freight_price' , 'average_rating' , 'transit_time' FROM ? force index ( idx_update_time ) where ( update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= DATE_SUB ( replace ( '?' , '?' , '?' ) , INTERVAL ? MINUTE ) ) ;<br /> 真实SQL：select 'id','customer_id','source_id','source_name','name','name_cn','gtin','spu','sku','item_id','source_sku','main_image','platform_category_id','platform_category_name','brand_id','brand','publish_status','status','product_state','tort','upc','sale_price','purchase_price','original_price','days_to_ship','first_publish_time','primary_variant','has_variant','has_new','description_type','default_local_warehouse','currency','country_code','remark','create_by','create_time','update_by','update_time','is_deleted','salesman_id','salesman','listing_person','fulfillment_type','template_id','template_name','freight_price','average_rating','transit_time' from t_walmart_listing force index(idx_update_time) where (update_time= DATE_SUB(replace('2025-07-16 07:30:00','%',' '),INTERVAL 5 MINUTE));<br /> 负责人参考：蔡俊伟<br /> 项目参考：java项目<br />('2025-07-16&gt;
002- 数据库：zhcxkj_center_listing_comprehensive<br />
003- 节点ID：497fd948de9643998944407f361dd881in01<br />
004- 查询时间：115.124<br />
005- 扫描行数：205241.0<br />
006- 返回行数：26<br />
007- 一天执行次数： 205241.0<br />
008- 慢日志时间：2025-07-17<br />
009- 指纹：92e1e6c1fc555e6b2b164002e909afd9<br />
010- SQL语句：select 'id' , 'customer_id' , 'source_id' , 'source_name' , 'name' , 'name_cn' , 'gtin' , 'spu' , 'sku' , 'item_id' , 'source_sku' , 'main_image' , 'platform_category_id' , 'platform_category_name' , 'brand_id' , 'brand' , 'publish_status' , 'status' , 'product_state' , 'tort' , 'upc' , 'sale_price' , 'purchase_price' , 'original_price' , 'days_to_ship' , 'first_publish_time' , 'primary_variant' , 'has_variant' , 'has_new' , 'description_type' , 'default_local_warehouse' , 'currency' , 'country_code' , 'remark' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'salesman_id' , 'salesman' , 'listing_person' , 'fulfillment_type' , 'template_id' , 'template_name' , 'freight_price' , 'average_rating' , 'transit_time' FROM ? force index ( idx_update_time ) where ( update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= DATE_SUB ( replace ( '?' , '?' , '?' ) , INTERVAL ? MINUTE ) ) ;<br />
011- 真实SQL：select 'id','customer_id','source_id','source_name','name','name_cn','gtin','spu','sku','item_id','source_sku','main_image','platform_category_id','platform_category_name','brand_id','brand','publish_status','status','product_state','tort','upc','sale_price','purchase_price','original_price','days_to_ship','first_publish_time','primary_variant','has_variant','has_new','description_type','default_local_warehouse','currency','country_code','remark','create_by','create_time','update_by','update_time','is_deleted','salesman_id','salesman','listing_person','fulfillment_type','template_id','template_name','freight_price','average_rating','transit_time' from t_walmart_listing force index(idx_update_time) where (update_time<replace('2025-07-16 08:00:01','%','="" ')="" and="" update_time="">= DATE_SUB(replace('2025-07-16 07:30:00','%',' '),INTERVAL 5 MINUTE));<br />
012- 负责人参考：蔡俊伟<br />
013- 项目参考：java项目<br />
014- </replace('2025-07-16>