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

001- 反馈人：吴荣发
001+ 反馈人：吴荣发 数据库：zhcxkj_center_strategy_comprehensive 节点ID：d7ea76feded04ab4bdfeee5c8e18b4f0in01 查询时间：86.4933 扫描行数：214434.0 返回行数：24 一天执行次数： 214434.0 慢日志时间：2025-07-19 指纹：0c58310603102bda86f50319edc6c8c9 SQL语句：select id , customer_id , source_id , sku , pf_listing_id , source_sku , category_id , calculation_formula_id , category_name , status , type , remark , create_time , update_time , is_deleted , title , title_id , pf_quantity , price , image , description , strategy_name , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time < replace ( ? , ? , ? ) AND update_time >= date_add ( replace ( ? , ? , ? ) , INTERVAL ? HOUR ) ) ; 真实SQL：select id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,calculation_formula_id,category_name,status,type,remark,create_time,update_time,is_deleted,title,title_id,pf_quantity,price,image,description,strategy_name,now() StarRocksUpdateTime from t_strategy_pool_publish_fruugo force index (idx_update_time) where (update_time= date_add(replace(2025/07/18 03:00:28,%, ), INTERVAL -0 HOUR)); 负责人参考：任芳涛,蔡俊伟 项目参考：java项目(2025>
002- 数据库：zhcxkj_center_strategy_comprehensive
003- 节点ID：d7ea76feded04ab4bdfeee5c8e18b4f0in01
004- 查询时间：86.4933
005- 扫描行数：214434.0
006- 返回行数：24
007- 一天执行次数： 214434.0
008- 慢日志时间：2025-07-19
009- 指纹：0c58310603102bda86f50319edc6c8c9
010- SQL语句：select id , customer_id , source_id , sku , pf_listing_id , source_sku , category_id , calculation_formula_id , category_name , status , type , remark , create_time , update_time , is_deleted , title , title_id , pf_quantity , price , image , description , strategy_name , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time < replace ( ? , ? , ? ) AND update_time >= date_add ( replace ( ? , ? , ? ) , INTERVAL ? HOUR ) ) ;
011- 真实SQL：select id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,calculation_formula_id,category_name,status,type,remark,create_time,update_time,is_deleted,title,title_id,pf_quantity,price,image,description,strategy_name,now() StarRocksUpdateTime from t_strategy_pool_publish_fruugo force index (idx_update_time) where (update_time= date_add(replace(2025/07/18 03:00:28,%, ), INTERVAL -0 HOUR));
012- 负责人参考：任芳涛,蔡俊伟
013- 项目参考：java项目
014-

001- 反馈人：吴荣发<br />
001+ 反馈人：吴荣发<br /> 数据库：zhcxkj_center_strategy_comprehensive<br /> 节点ID：d7ea76feded04ab4bdfeee5c8e18b4f0in01<br /> 查询时间：86.4933<br /> 扫描行数：214434.0<br /> 返回行数：24<br /> 一天执行次数： 214434.0<br /> 慢日志时间：2025-07-19<br /> 指纹：0c58310603102bda86f50319edc6c8c9<br /> SQL语句：select id , customer_id , source_id , sku , pf_listing_id , source_sku , category_id , calculation_formula_id , category_name , status , type , remark , create_time , update_time , is_deleted , title , title_id , pf_quantity , price , image , description , strategy_name , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time &lt; replace ( ? , ? , ? ) AND update_time &gt;= date_add ( replace ( ? , ? , ? ) , INTERVAL ? HOUR ) ) ;<br /> 真实SQL：select id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,calculation_formula_id,category_name,status,type,remark,create_time,update_time,is_deleted,title,title_id,pf_quantity,price,image,description,strategy_name,now() StarRocksUpdateTime from t_strategy_pool_publish_fruugo force index (idx_update_time) where (update_time= date_add(replace(2025/07/18 03:00:28,%, ), INTERVAL -0 HOUR));<br /> 负责人参考：任芳涛,蔡俊伟<br /> 项目参考：java项目<br />(2025&gt;
002- 数据库：zhcxkj_center_strategy_comprehensive<br />
003- 节点ID：d7ea76feded04ab4bdfeee5c8e18b4f0in01<br />
004- 查询时间：86.4933<br />
005- 扫描行数：214434.0<br />
006- 返回行数：24<br />
007- 一天执行次数： 214434.0<br />
008- 慢日志时间：2025-07-19<br />
009- 指纹：0c58310603102bda86f50319edc6c8c9<br />
010- SQL语句：select id , customer_id , source_id , sku , pf_listing_id , source_sku , category_id , calculation_formula_id , category_name , status , type , remark , create_time , update_time , is_deleted , title , title_id , pf_quantity , price , image , description , strategy_name , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time &lt; replace ( ? , ? , ? ) AND update_time &gt;= date_add ( replace ( ? , ? , ? ) , INTERVAL ? HOUR ) ) ;<br />
011- 真实SQL：select id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,calculation_formula_id,category_name,status,type,remark,create_time,update_time,is_deleted,title,title_id,pf_quantity,price,image,description,strategy_name,now() StarRocksUpdateTime from t_strategy_pool_publish_fruugo force index (idx_update_time) where (update_time<replace(2025 07="" 18="" 04:00:28,%,="" )="" and="" update_time="">= date_add(replace(2025/07/18 03:00:28,%, ), INTERVAL -0 HOUR));<br />
012- 负责人参考：任芳涛,蔡俊伟<br />
013- 项目参考：java项目<br />
014- </replace(2025>