反馈人:吴荣发
数据库:zhcxkj-center-product
节点ID:0e95197892a84afdb4a86b4eae5de8d6in01
查询时间:336.42
扫描行数:18664400.0
返回行数:7265.64
一天执行次数: 143
慢日志时间:2025-07-24
指纹:40411d710559c0b444a47ba47a207adb
SQL语句:select 'id' , 'customer_id' , 'sku' , 'title_source' , 'status' , 'title_name' , 'language' , 'create_log' , 'user_log' , 'title_repetition_value' , 'remark' , 'user_time' , 'create_time' , 'update_time' , 'is_deleted' , 'title_md5' , 'site_code' , 'prompt_type' , 'category1_id' , 'title_source_id' , now ( ) StarRocksUpdateTime FROM ? where ( update_time < replace ( '?' , '?' , '?' ) AND update_time >= date_add ( replace ( '?' , '?' , '?' ) , INTERVAL ? minute ) ) ;
真实SQL:select 'id','customer_id','sku','title_source','status','title_name','language','create_log','user_log','title_repetition_value','remark','user_time','create_time','update_time','is_deleted','title_md5','site_code','prompt_type','category1_id','title_source_id',now() StarRocksUpdateTime from t_product_sku_title_fruugo where (update_time= date_add(replace('2025/07/23 07:50:07','%',' '), INTERVAL -0 minute));
负责人参考:公用
项目参考:java项目
('2025>
重现步骤