深圳智汇创想科技有限公司

001- 反馈人：吴荣发
001+ 反馈人：吴荣发
002- 数据库：zhcxkj_center_listing_amazon
002+ 问题1：
003- 节点ID：26f05d35fbdd452d80c86a50157fbf52in01
003+ 数据库：zhcxkj_center_listing_amazon
004- 查询时间：46.3198
004+ 节点ID：26f05d35fbdd452d80c86a50157fbf52in01 查询时间：46.3198 扫描行数：49376.5 返回行数：49376.5 一天执行次数： 192 慢日志时间：2025-07-30 指纹：cb4c8adab64a78cd2c3e86390cdd37e4 SQL语句：select 'id' , 'source_id' , 'msku' , 'customer_id' , 'fifteen_page_view' , 'pre_fifteen_page_view' , 'recent_date' , 'browser_page_views_percentage' , 'pre_browser_page_views_percentage' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'fourteen_page_view' , 'thirty_page_view' , 'seven_page_view' , 'twenty_eight_page_view' , 'sixty_page_view' , 'ninety_page_view' , 'one_hundred_eighty_page_view' , 'seven_page_view_yoy' , 'fourteen_page_view_yoy' , 'twenty_eight_page_view_yoy' , 'thirty_page_view_yoy' , 'sixty_page_view_yoy' , 'ninety_page_view_yoy' , 'one_hundred_eighty_page_view_yoy' , now ( ) starrocksupdatetime FROM ? where ( customer_id = ? AND update_time < replace ( '?' , '?' , '?' ) AND update_time >= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? HOUR ) ) ; 真实SQL：select 'id','source_id','msku','customer_id','fifteen_page_view','pre_fifteen_page_view','recent_date','browser_page_views_percentage','pre_browser_page_views_percentage','create_by','create_time','update_by','update_time','is_deleted','fourteen_page_view','thirty_page_view','seven_page_view','twenty_eight_page_view','sixty_page_view','ninety_page_view','one_hundred_eighty_page_view','seven_page_view_yoy','fourteen_page_view_yoy','twenty_eight_page_view_yoy','thirty_page_view_yoy','sixty_page_view_yoy','ninety_page_view_yoy','one_hundred_eighty_page_view_yoy',now() starrocksupdatetime from t_amazon_listing_extra_sku_13 where (customer_id =1 AND update_time= date_add(replace('2025-07-29 07:00:10','%',' '), INTERVAL -0 HOUR)); 负责人参考：宋宁('2025-07-29>
005- 扫描行数：49376.5
005+ 项目参考：java项目('2025-07-29>
006- 返回行数：49376.5
006+ ('2025-07-29>
007- 一天执行次数： 192
007+ 问题2：('2025-07-29>
008- 慢日志时间：2025-07-30
008+ 数据库：zhcxkj_center_listing_comprehensive节点ID：497fd948de9643998944407f361dd881in01查询时间：70.5668扫描行数：3757480.0返回行数：889.966一天执行次数： 145慢日志时间：2025-07-30指纹：b0b5ea83f70647b1208d563476a09a29SQL语句：select
009- 指纹：cb4c8adab64a78cd2c3e86390cdd37e4
009+ 'id' , 'product_id' , 'sku' , 'source_sku' , 'source_id' ,
010- SQL语句：select 'id' , 'source_id' , 'msku' , 'customer_id' , 'fifteen_page_view' , 'pre_fifteen_page_view' , 'recent_date' , 'browser_page_views_percentage' , 'pre_browser_page_views_percentage' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'fourteen_page_view' , 'thirty_page_view' , 'seven_page_view' , 'twenty_eight_page_view' , 'sixty_page_view' , 'ninety_page_view' , 'one_hundred_eighty_page_view' , 'seven_page_view_yoy' , 'fourteen_page_view_yoy' , 'twenty_eight_page_view_yoy' , 'thirty_page_view_yoy' , 'sixty_page_view_yoy' , 'ninety_page_view_yoy' , 'one_hundred_eighty_page_view_yoy' , now ( ) starrocksupdatetime FROM ? where ( customer_id = ? AND update_time < replace ( '?' , '?' , '?' ) AND update_time >= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? HOUR ) ) ;
010+ 'source_name' , 'category_name' , 'title' , 'brand' , 'attribute_color' ,
011- 真实SQL：select 'id','source_id','msku','customer_id','fifteen_page_view','pre_fifteen_page_view','recent_date','browser_page_views_percentage','pre_browser_page_views_percentage','create_by','create_time','update_by','update_time','is_deleted','fourteen_page_view','thirty_page_view','seven_page_view','twenty_eight_page_view','sixty_page_view','ninety_page_view','one_hundred_eighty_page_view','seven_page_view_yoy','fourteen_page_view_yoy','twenty_eight_page_view_yoy','thirty_page_view_yoy','sixty_page_view_yoy','ninety_page_view_yoy','one_hundred_eighty_page_view_yoy',now() starrocksupdatetime from t_amazon_listing_extra_sku_13 where (customer_id =1 AND update_time= date_add(replace('2025-07-29 07:00:10','%',' '), INTERVAL -0 HOUR));
011+ 'attribute_height' , 'attribute_length' , 'attribute_weight' ,
012- 负责人参考：宋宁
012+ 'attribute_width' , 'ean' , 'color' , 'discount_price_country' ,
013- 项目参考：java项目
013+ 'discount_price_currency' , 'discount_price' , 'language' ,
014-
014+ 'normal_price_country' , 'normal_price_currency' , 'price' , 'vate_rate'
015+ , 'status' , 'package_weight' , 'lead_time' , 'stock_status' ,
016+ 'stock_value' , 'description' , 'image' , 'create_by' , 'create_time' ,
017+ 'update_by' , 'update_time' , 'is_deleted' , 'manufacturer' ,
018+ 'original_status' , 'pf_listing_id' , now ( ) StarRocksUpdateTime FROM ?
019+ where ( update_time < replace ( '?' , '?' , '?' ) AND update_time
020+ >= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? HOUR ) ) ;真实SQL：select
021+ 'id','product_id','sku','source_sku','source_id','source_name','category_name','title','brand','attribute_color','attribute_height','attribute_length','attribute_weight','attribute_width','ean','color','discount_price_country','discount_price_currency','discount_price','language','normal_price_country','normal_price_currency','price','vate_rate','status','package_weight','lead_time','stock_status','stock_value','description','image','create_by','create_time','update_by','update_time','is_deleted','manufacturer','original_status','pf_listing_id',now()
022+ StarRocksUpdateTime from t_listing_fruugo where (update_time= date_add(replace('2025/07/29 07:50:07','%',' '), INTERVAL -0 HOUR));负责人参考：蔡俊伟项目参考：java项目('2025>('2025-07-29>

001- 反馈人：吴荣发<br />
001+ <p>反馈人：吴荣发</p>
002- 数据库：zhcxkj_center_listing_amazon<br />
002+ <p>问题1：</p>
003- 节点ID：26f05d35fbdd452d80c86a50157fbf52in01<br />
003+ 数据库：zhcxkj_center_listing_amazon<br />
004- 查询时间：46.3198<br />
004+ 节点ID：26f05d35fbdd452d80c86a50157fbf52in01<br /> 查询时间：46.3198<br /> 扫描行数：49376.5<br /> 返回行数：49376.5<br /> 一天执行次数： 192<br /> 慢日志时间：2025-07-30<br /> 指纹：cb4c8adab64a78cd2c3e86390cdd37e4<br /> SQL语句：select 'id' , 'source_id' , 'msku' , 'customer_id' , 'fifteen_page_view' , 'pre_fifteen_page_view' , 'recent_date' , 'browser_page_views_percentage' , 'pre_browser_page_views_percentage' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'fourteen_page_view' , 'thirty_page_view' , 'seven_page_view' , 'twenty_eight_page_view' , 'sixty_page_view' , 'ninety_page_view' , 'one_hundred_eighty_page_view' , 'seven_page_view_yoy' , 'fourteen_page_view_yoy' , 'twenty_eight_page_view_yoy' , 'thirty_page_view_yoy' , 'sixty_page_view_yoy' , 'ninety_page_view_yoy' , 'one_hundred_eighty_page_view_yoy' , now ( ) starrocksupdatetime FROM ? where ( customer_id = ? AND update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? HOUR ) ) ;<br /> 真实SQL：select 'id','source_id','msku','customer_id','fifteen_page_view','pre_fifteen_page_view','recent_date','browser_page_views_percentage','pre_browser_page_views_percentage','create_by','create_time','update_by','update_time','is_deleted','fourteen_page_view','thirty_page_view','seven_page_view','twenty_eight_page_view','sixty_page_view','ninety_page_view','one_hundred_eighty_page_view','seven_page_view_yoy','fourteen_page_view_yoy','twenty_eight_page_view_yoy','thirty_page_view_yoy','sixty_page_view_yoy','ninety_page_view_yoy','one_hundred_eighty_page_view_yoy',now() starrocksupdatetime from t_amazon_listing_extra_sku_13 where (customer_id =1 AND update_time= date_add(replace('2025-07-29 07:00:10','%',' '), INTERVAL -0 HOUR));<br /> 负责人参考：宋宁<br />('2025-07-29&gt;
005- 扫描行数：49376.5<br />
005+ <p> 项目参考：java项目('2025-07-29&gt;</p>
006- 返回行数：49376.5<br />
006+ <p><br />('2025-07-29&gt;</p>
007- 一天执行次数： 192<br />
007+ <p>问题2：('2025-07-29&gt;</p>
008- 慢日志时间：2025-07-30<br />
008+ <p>数据库：zhcxkj_center_listing_comprehensive<br />节点ID：497fd948de9643998944407f361dd881in01<br />查询时间：70.5668<br />扫描行数：3757480.0<br />返回行数：889.966<br />一天执行次数： 145<br />慢日志时间：2025-07-30<br />指纹：b0b5ea83f70647b1208d563476a09a29<br />SQL语句：select
009- 指纹：cb4c8adab64a78cd2c3e86390cdd37e4<br />
009+ 'id' , 'product_id' , 'sku' , 'source_sku' , 'source_id' ,
010- SQL语句：select 'id' , 'source_id' , 'msku' , 'customer_id' , 'fifteen_page_view' , 'pre_fifteen_page_view' , 'recent_date' , 'browser_page_views_percentage' , 'pre_browser_page_views_percentage' , 'create_by' , 'create_time' , 'update_by' , 'update_time' , 'is_deleted' , 'fourteen_page_view' , 'thirty_page_view' , 'seven_page_view' , 'twenty_eight_page_view' , 'sixty_page_view' , 'ninety_page_view' , 'one_hundred_eighty_page_view' , 'seven_page_view_yoy' , 'fourteen_page_view_yoy' , 'twenty_eight_page_view_yoy' , 'thirty_page_view_yoy' , 'sixty_page_view_yoy' , 'ninety_page_view_yoy' , 'one_hundred_eighty_page_view_yoy' , now ( ) starrocksupdatetime FROM ? where ( customer_id = ? AND update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? HOUR ) ) ;<br />
010+ 'source_name' , 'category_name' , 'title' , 'brand' , 'attribute_color' ,
011- 真实SQL：select 'id','source_id','msku','customer_id','fifteen_page_view','pre_fifteen_page_view','recent_date','browser_page_views_percentage','pre_browser_page_views_percentage','create_by','create_time','update_by','update_time','is_deleted','fourteen_page_view','thirty_page_view','seven_page_view','twenty_eight_page_view','sixty_page_view','ninety_page_view','one_hundred_eighty_page_view','seven_page_view_yoy','fourteen_page_view_yoy','twenty_eight_page_view_yoy','thirty_page_view_yoy','sixty_page_view_yoy','ninety_page_view_yoy','one_hundred_eighty_page_view_yoy',now() starrocksupdatetime from t_amazon_listing_extra_sku_13 where (customer_id =1 AND update_time<replace('2025-07-29 08:00:10','%','="" ')="" and="" update_time="">= date_add(replace('2025-07-29 07:00:10','%',' '), INTERVAL -0 HOUR));<br />
011+ 'attribute_height' , 'attribute_length' , 'attribute_weight' ,
012- 负责人参考：宋宁<br />
012+ 'attribute_width' , 'ean' , 'color' , 'discount_price_country' ,
013- 项目参考：java项目<br />
013+ 'discount_price_currency' , 'discount_price' , 'language' ,
014- </replace('2025-07-29>
014+ 'normal_price_country' , 'normal_price_currency' , 'price' , 'vate_rate'
015+ , 'status' , 'package_weight' , 'lead_time' , 'stock_status' ,
016+ 'stock_value' , 'description' , 'image' , 'create_by' , 'create_time' ,
017+ 'update_by' , 'update_time' , 'is_deleted' , 'manufacturer' ,
018+ 'original_status' , 'pf_listing_id' , now ( ) StarRocksUpdateTime FROM ?
019+ where ( update_time &lt; replace ( '?' , '?' , '?' ) AND update_time
020+ &gt;= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? HOUR ) ) ;<br />真实SQL：select
021+ 'id','product_id','sku','source_sku','source_id','source_name','category_name','title','brand','attribute_color','attribute_height','attribute_length','attribute_weight','attribute_width','ean','color','discount_price_country','discount_price_currency','discount_price','language','normal_price_country','normal_price_currency','price','vate_rate','status','package_weight','lead_time','stock_status','stock_value','description','image','create_by','create_time','update_by','update_time','is_deleted','manufacturer','original_status','pf_listing_id',now()
022+ StarRocksUpdateTime from t_listing_fruugo where (update_time= date_add(replace('2025/07/29 07:50:07','%',' '), INTERVAL -0 HOUR));<br />负责人参考：蔡俊伟<br />项目参考：java项目('2025&gt;<br />('2025-07-29&gt;</p>

005- 项目参考：java项目('2025-07-29&gt;
005+ 项目参考：java项目('2025-07-29&gt;

005- <p> 项目参考：java项目('2025-07-29&gt;</p>
005+ <p>项目参考：java项目('2025-07-29&gt;</p>