001- 反馈人：吴荣发
001+ 反馈人：吴荣发 数据库：zhcxkj_center_listing_comprehensive 节点ID：497fd948de9643998944407f361dd881in01 查询时间：581.743 扫描行数：1313260.0 返回行数：24 一天执行次数： 2025-07-14 慢日志时间：2025-07-15 SQL语句：select 'id' , 'source_id' , 'source_name' , 'sku' , 'upc' , 'spu' , 'pf_listing_id' , 'pf_sku' , 'source_sku' , 'status_name' , 'moderate_status' , 'image' , 'platform_atrributes' , 'title' , 'stock' , 'sale_price' , 'price_color_index' , 'min_price' , 'min_price_update_time' , 'country_code' , 'currency' , 'category_id' , 'category_name' , 'parent_category_id' , 'is_archived' , 'is_auto_archived' , 'is_kgt' , 'is_super' , 'vat' , 'publisher_id' , 'publisher_name' , 'sales_id' , 'sales_name' , 'fail_msg' , 'status' , 'publish_time' , 'pf_online_time' , 'pf_offline_time' , 'pf_update_time' , 'create_by' , 'update_by' , 'update_time' , 'create_time' , 'is_deleted' , 'archived_status' , 'status_update_time' , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time >= date_sub ( '?' , INTERVAL ? HOUR ) ) ; 真实SQL：select 'id','source_id','source_name','sku','upc','spu','pf_listing_id','pf_sku','source_sku','status_name','moderate_status','image','platform_atrributes','title','stock','sale_price','price_color_index','min_price','min_price_update_time','country_code','currency','category_id','category_name','parent_category_id','is_archived','is_auto_archived','is_kgt','is_super','vat','publisher_id','publisher_name','sales_id','sales_name','fail_msg','status','publish_time','pf_online_time','pf_offline_time','pf_update_time','create_by','update_by','update_time','create_time','is_deleted','archived_status','status_update_time',now() StarRocksUpdateTime from t_listing_ozon force index(idx_update_time) where (update_time >= date_sub('2025/07/14 07:00:22', INTERVAL 2 HOUR)); 负责人参考：蔡俊伟 项目参考：java项目
002- 数据库：zhcxkj_center_listing_comprehensive
003- 节点ID：497fd948de9643998944407f361dd881in01
004- 查询时间：581.743
005- 扫描行数：1313260.0
006- 返回行数：24
007- 一天执行次数： 2025-07-14
008- 慢日志时间：2025-07-15
009- SQL语句：select 'id' , 'source_id' , 'source_name' , 'sku' , 'upc' , 'spu' , 'pf_listing_id' , 'pf_sku' , 'source_sku' , 'status_name' , 'moderate_status' , 'image' , 'platform_atrributes' , 'title' , 'stock' , 'sale_price' , 'price_color_index' , 'min_price' , 'min_price_update_time' , 'country_code' , 'currency' , 'category_id' , 'category_name' , 'parent_category_id' , 'is_archived' , 'is_auto_archived' , 'is_kgt' , 'is_super' , 'vat' , 'publisher_id' , 'publisher_name' , 'sales_id' , 'sales_name' , 'fail_msg' , 'status' , 'publish_time' , 'pf_online_time' , 'pf_offline_time' , 'pf_update_time' , 'create_by' , 'update_by' , 'update_time' , 'create_time' , 'is_deleted' , 'archived_status' , 'status_update_time' , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time >= date_sub ( '?' , INTERVAL ? HOUR ) ) ;
010- 真实SQL：select 'id','source_id','source_name','sku','upc','spu','pf_listing_id','pf_sku','source_sku','status_name','moderate_status','image','platform_atrributes','title','stock','sale_price','price_color_index','min_price','min_price_update_time','country_code','currency','category_id','category_name','parent_category_id','is_archived','is_auto_archived','is_kgt','is_super','vat','publisher_id','publisher_name','sales_id','sales_name','fail_msg','status','publish_time','pf_online_time','pf_offline_time','pf_update_time','create_by','update_by','update_time','create_time','is_deleted','archived_status','status_update_time',now() StarRocksUpdateTime from t_listing_ozon force index(idx_update_time) where (update_time >= date_sub('2025/07/14 07:00:22', INTERVAL 2 HOUR));
011- 负责人参考：蔡俊伟
012- 项目参考：java项目

001- 反馈人：吴荣发<br />
001+ 反馈人：吴荣发<br /> 数据库：zhcxkj_center_listing_comprehensive<br /> 节点ID：497fd948de9643998944407f361dd881in01<br /> 查询时间：581.743<br /> 扫描行数：1313260.0<br /> 返回行数：24<br /> 一天执行次数： 2025-07-14<br /> 慢日志时间：2025-07-15<br /> SQL语句：select 'id' , 'source_id' , 'source_name' , 'sku' , 'upc' , 'spu' , 'pf_listing_id' , 'pf_sku' , 'source_sku' , 'status_name' , 'moderate_status' , 'image' , 'platform_atrributes' , 'title' , 'stock' , 'sale_price' , 'price_color_index' , 'min_price' , 'min_price_update_time' , 'country_code' , 'currency' , 'category_id' , 'category_name' , 'parent_category_id' , 'is_archived' , 'is_auto_archived' , 'is_kgt' , 'is_super' , 'vat' , 'publisher_id' , 'publisher_name' , 'sales_id' , 'sales_name' , 'fail_msg' , 'status' , 'publish_time' , 'pf_online_time' , 'pf_offline_time' , 'pf_update_time' , 'create_by' , 'update_by' , 'update_time' , 'create_time' , 'is_deleted' , 'archived_status' , 'status_update_time' , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time &gt;= date_sub ( '?' , INTERVAL ? HOUR ) ) ;<br /> 真实SQL：select 'id','source_id','source_name','sku','upc','spu','pf_listing_id','pf_sku','source_sku','status_name','moderate_status','image','platform_atrributes','title','stock','sale_price','price_color_index','min_price','min_price_update_time','country_code','currency','category_id','category_name','parent_category_id','is_archived','is_auto_archived','is_kgt','is_super','vat','publisher_id','publisher_name','sales_id','sales_name','fail_msg','status','publish_time','pf_online_time','pf_offline_time','pf_update_time','create_by','update_by','update_time','create_time','is_deleted','archived_status','status_update_time',now() StarRocksUpdateTime from t_listing_ozon force index(idx_update_time) where (update_time &gt;= date_sub('2025/07/14 07:00:22', INTERVAL 2 HOUR));<br /> 负责人参考：蔡俊伟<br /> 项目参考：java项目<br />
002- 数据库：zhcxkj_center_listing_comprehensive<br />
003- 节点ID：497fd948de9643998944407f361dd881in01<br />
004- 查询时间：581.743<br />
005- 扫描行数：1313260.0<br />
006- 返回行数：24<br />
007- 一天执行次数： 2025-07-14<br />
008- 慢日志时间：2025-07-15<br />
009- SQL语句：select 'id' , 'source_id' , 'source_name' , 'sku' , 'upc' , 'spu' , 'pf_listing_id' , 'pf_sku' , 'source_sku' , 'status_name' , 'moderate_status' , 'image' , 'platform_atrributes' , 'title' , 'stock' , 'sale_price' , 'price_color_index' , 'min_price' , 'min_price_update_time' , 'country_code' , 'currency' , 'category_id' , 'category_name' , 'parent_category_id' , 'is_archived' , 'is_auto_archived' , 'is_kgt' , 'is_super' , 'vat' , 'publisher_id' , 'publisher_name' , 'sales_id' , 'sales_name' , 'fail_msg' , 'status' , 'publish_time' , 'pf_online_time' , 'pf_offline_time' , 'pf_update_time' , 'create_by' , 'update_by' , 'update_time' , 'create_time' , 'is_deleted' , 'archived_status' , 'status_update_time' , now ( ) StarRocksUpdateTime FROM ? force index ( idx_update_time ) where ( update_time &gt;= date_sub ( '?' , INTERVAL ? HOUR ) ) ;<br />
010- 真实SQL：select 'id','source_id','source_name','sku','upc','spu','pf_listing_id','pf_sku','source_sku','status_name','moderate_status','image','platform_atrributes','title','stock','sale_price','price_color_index','min_price','min_price_update_time','country_code','currency','category_id','category_name','parent_category_id','is_archived','is_auto_archived','is_kgt','is_super','vat','publisher_id','publisher_name','sales_id','sales_name','fail_msg','status','publish_time','pf_online_time','pf_offline_time','pf_update_time','create_by','update_by','update_time','create_time','is_deleted','archived_status','status_update_time',now() StarRocksUpdateTime from t_listing_ozon force index(idx_update_time) where (update_time &gt;= date_sub('2025/07/14 07:00:22', INTERVAL 2 HOUR));<br />
011- 负责人参考：蔡俊伟<br />
012- 项目参考：java项目<br />