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

001- 反馈人：李冠
001+ 反馈人：李冠 严重级别：一般 所属项目：多平台（fruugo） 问题原因：慢SQL、，影响策略库其它业务正常运行，SQL为：（ SELECT id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,category_name,title,title_id,pf_quantity,price,image,description,calculation_formula_id,status,type,remark,create_time,update_time,is_deleted FROM t_strategy_pool_publish_fruugo WHERE (source_id = 29139 AND status = 0 AND update_time <= '2025-07-22 17:14:46' AND is_deleted = 0) ORDER BY id ASC limit 100 ） 解决方案：优化SQL为（ select t.* from t_strategy_pool_publish_fruugo t join (select id from t_strategy_pool_publish_fruugo FORCE INDEX(idx_source_id_status_type) where source_id = 29139 AND status = 0 AND update_time <= '2025-07-22 17:14:46' AND is_deleted = 0 order by id asc limit 100) tt on t.id=tt.id ），其中t.*调整为查询的字段
002- 严重级别：一般
003- 所属项目：多平台（fruugo）
004- 问题原因：慢SQL、，影响策略库其它业务正常运行，SQL为：（
005- SELECT id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,category_name,title,title_id,pf_quantity,price,image,description,calculation_formula_id,status,type,remark,create_time,update_time,is_deleted FROM t_strategy_pool_publish_fruugo
006-
007- WHERE (source_id = 29139 AND status = 0 AND update_time <= '2025-07-22 17:14:46' AND is_deleted = 0) ORDER BY id ASC limit 100
008- ）
009- 解决方案：优化SQL为（
010- select t.*
011- from t_strategy_pool_publish_fruugo t join (select id from t_strategy_pool_publish_fruugo FORCE INDEX(idx_source_id_status_type) where source_id = 29139 AND status = 0 AND update_time <= '2025-07-22 17:14:46' AND is_deleted = 0 order by id asc limit 100) tt on t.id=tt.id
012- ），其中t.*调整为查询的字段

001- 反馈人：李冠<br />
001+ 反馈人：李冠<br /> 严重级别：一般<br /> 所属项目：多平台（fruugo）<br /> 问题原因：慢SQL、，影响策略库其它业务正常运行，SQL为：（<br /> SELECT id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,category_name,title,title_id,pf_quantity,price,image,description,calculation_formula_id,status,type,remark,create_time,update_time,is_deleted FROM t_strategy_pool_publish_fruugo <br /><br /> WHERE (source_id = 29139 AND status = 0 AND update_time &lt;= '2025-07-22 17:14:46' AND is_deleted = 0) ORDER BY id ASC limit 100 <br /> ）<br /> 解决方案：优化SQL为（<br /> select t.*<br /> from t_strategy_pool_publish_fruugo t join (select id from t_strategy_pool_publish_fruugo FORCE INDEX(idx_source_id_status_type) where source_id = 29139 AND status = 0 AND update_time &lt;= '2025-07-22 17:14:46' AND is_deleted = 0 order by id asc limit 100) tt on t.id=tt.id<br /> ），其中t.*调整为查询的字段
002- 严重级别：一般<br />
003- 所属项目：多平台（fruugo）<br />
004- 问题原因：慢SQL、，影响策略库其它业务正常运行，SQL为：（<br />
005- SELECT id,customer_id,source_id,sku,pf_listing_id,source_sku,category_id,category_name,title,title_id,pf_quantity,price,image,description,calculation_formula_id,status,type,remark,create_time,update_time,is_deleted FROM t_strategy_pool_publish_fruugo <br />
006- <br />
007- WHERE (source_id = 29139 AND status = 0 AND update_time &lt;= '2025-07-22 17:14:46' AND is_deleted = 0) ORDER BY id ASC limit 100 <br />
008- ）<br />
009- 解决方案：优化SQL为（<br />
010- select t.*<br />
011- from t_strategy_pool_publish_fruugo t join (select id from t_strategy_pool_publish_fruugo FORCE INDEX(idx_source_id_status_type) where source_id = 29139 AND status = 0 AND update_time &lt;= '2025-07-22 17:14:46' AND is_deleted = 0 order by id asc limit 100) tt on t.id=tt.id<br />
012- ），其中t.*调整为查询的字段