修改了
所属模块 ，旧值为 "0"，新值为 "1872"。
修改了
业务部门 ，旧值为 "0"，新值为 "2"。
修改了
测试责任人，旧值为 ""，新值为 "chenlizhen"。
修改了
解决时效 ，旧值为 "0"，新值为 "0.89"。
修改了
重现步骤 ，区别为：
001- 反馈人：袁慧斌
001+ 反馈人：袁慧斌 严重级别：严重 所属项目：战略 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引 SELECT DATE(b.create_time) AS 日期, CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型, COUNT(*) AS 进队列总数, SUM(b.business_status = 2) AS 成功数, SUM(b.business_status = 3) AS 失败数, SUM(b.business_status NOT IN (2, 3)) AS 其余状态数, CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率, CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率 FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b FORCE INDEX (idx_create_time) INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id WHERE b.create_time >= DATE_SUB(CURDATE(), INTERVAL 2 DAY) GROUP BY DATE(b.create_time), a.source_type ORDER BY a.source_type, DATE(b.create_time) 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
002- 严重级别：严重
003- 所属项目：战略
004- 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引
005- SELECT
006- DATE(b.create_time) AS 日期,
007- CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型,
008- COUNT(*) AS 进队列总数,
009- SUM(b.business_status = 2) AS 成功数,
010- SUM(b.business_status = 3) AS 失败数,
011- SUM(b.business_status NOT IN (2, 3)) AS 其余状态数,
012- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率,
013- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率
014- FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b
015- FORCE INDEX (idx_create_time)
016- INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id
017- WHERE b.create_time >= DATE_SUB(CURDATE(), INTERVAL 2 DAY)
018- GROUP BY DATE(b.create_time), a.source_type
019- ORDER BY a.source_type, DATE(b.create_time)
020- 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
001- 反馈人：袁慧斌<br />
001+ 反馈人：袁慧斌<br /> 严重级别：严重<br /> 所属项目：战略<br /> 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引 <br /> SELECT<br /> DATE(b.create_time) AS 日期,<br /> CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型,<br /> COUNT(*) AS 进队列总数,<br /> SUM(b.business_status = 2) AS 成功数,<br /> SUM(b.business_status = 3) AS 失败数,<br /> SUM(b.business_status NOT IN (2, 3)) AS 其余状态数,<br /> CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率,<br /> CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率<br /> FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b<br /> FORCE INDEX (idx_create_time)<br /> INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id<br /> WHERE b.create_time >= DATE_SUB(CURDATE(), INTERVAL 2 DAY)<br /> GROUP BY DATE(b.create_time), a.source_type<br /> ORDER BY a.source_type, DATE(b.create_time)<br /> 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)
002- 严重级别：严重<br />
003- 所属项目：战略<br />
004- 问题原因：HWY-ZH-GZ-RDS-strategy SQL zhcxkj_center_strategy_comprehensive 强制使用了索引 <br />
005- SELECT<br />
006- DATE(b.create_time) AS 日期,<br />
007- CASE a.source_type WHEN 0 THEN 直发 ELSE WFS END AS 渠道类型,<br />
008- COUNT(*) AS 进队列总数,<br />
009- SUM(b.business_status = 2) AS 成功数,<br />
010- SUM(b.business_status = 3) AS 失败数,<br />
011- SUM(b.business_status NOT IN (2, 3)) AS 其余状态数,<br />
012- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5))), 0) * 100, 2), %) AS 总成功率,<br />
013- CONCAT(ROUND(SUM(b.business_status = 2) / NULLIF((COUNT(*) - SUM(b.business_status IN (0, 1, 5) OR b.error_type IN (8, 33))), 0) * 100, 2), %) AS 排除后成功率<br />
014- FROM zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy_execute_queue_detail b<br />
015- FORCE INDEX (idx_create_time)<br />
016- INNER JOIN zhcxkj_center_strategy_comprehensive.t_walmart_publish_strategy a ON a.id = b.strategy_id<br />
017- WHERE b.create_time >= DATE_SUB(CURDATE(), INTERVAL 2 DAY)<br />
018- GROUP BY DATE(b.create_time), a.source_type<br />
019- ORDER BY a.source_type, DATE(b.create_time)<br />
020- 解决方案：删除强制使用索引 FORCE INDEX (idx_create_time)