重现步骤
数据库:zhcxkj_center_datasync_comprehensive
节点ID:755adaa3b6f349f48b98e1325ff6b8a9in01
查询时间:76.5434
扫描行数:67358.5
返回行数:24
一天执行次数: 67358.5
慢日志时间:2025-07-19
指纹:8f19136ccd98c176580117ee3555a893
SQL语句:select 'id' , 'customer_id' , 'source_id' , 'source_name' , 'source_sku' , 'download_task_id' , 'item_id' , 'product_name' , 'lifecycle_status' , 'publish_status' , 'status_change_reason' , 'product_category' , 'primary_category_path' , 'price' , 'currency' , 'buy_box_item_price' , 'buy_box_shipping_price' , 'buy_box_eligible' , 'msrp' , 'product_tax_code' , 'ship_methods' , 'ship_weight' , 'ship_weight_unit' , 'fulfillment_lag_time' , 'fulfillment_type' , 'wfs_sales_restriction' , 'wpid' , 'gtin' , 'upc' , 'item_page_url' , 'primary_image_url' , 'brand' , 'offer_start_date' , 'item_creation_date' , 'item_last_updated' , 'reviews_count' , 'average_rating' , 'variant_group_id' , 'primary_variant' , 'variant_grouping_attributes' , 'variant_grouping_values' , 'competitor_url' , 'competitor_price' , 'competitor_ship_price' , 'competitor_last_date_fetched' , 'repricer_strategy' , 'minimum_seller_allowed_price' , 'maximum_seller_allowed_price' , 'repricer_status' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'unpublished_reasons' FROM ? where ( update_time < replace ( '?' , '?' , '?' ) AND update_time >= replace ( '?' , '?' , '?' ) ) ;
真实SQL:select 'id','customer_id','source_id','source_name','source_sku','download_task_id','item_id','product_name','lifecycle_status','publish_status','status_change_reason','product_category','primary_category_path','price','currency','buy_box_item_price','buy_box_shipping_price','buy_box_eligible','msrp','product_tax_code','ship_methods','ship_weight','ship_weight_unit','fulfillment_lag_time','fulfillment_type','wfs_sales_restriction','wpid','gtin','upc','item_page_url','primary_image_url','brand','offer_start_date','item_creation_date','item_last_updated','reviews_count','average_rating','variant_group_id','primary_variant','variant_grouping_attributes','variant_grouping_values','competitor_url','competitor_price','competitor_ship_price','competitor_last_date_fetched','repricer_strategy','minimum_seller_allowed_price','maximum_seller_allowed_price','repricer_status','create_by','create_time','update_by','update_time','is_deleted','unpublished_reasons' from t_walmart_platform_report_item where (update_time= replace('2025-07-18 03:00:02','%',' '));
负责人参考:蔡俊伟
项目参考:java项目
('2025-07-18>
data数据同步任务。目前调整数据查询频率