任务描述
SELECT `OrderSourceId` AS `OrderSourceId` , COUNT(1) AS `PublishNum` FROM `M_ShopeeV2_Listing` WHERE (((( `CustomerId` = 1 ) AND ( ( `IsGlobal`=1 ) OR NOT ( `IsGlobal`=1 ) )) AND (`OrderSourceId` IN (14384)) ) AND ( `Status` = 'normal' ))GROUP BY `OrderSourceId`;
需求描述
业务背景
1)业务方临时数据处理、统计、导出等无法得到及时帮助
2)生产问题排查排期周期过长
业务文档
https://alidocs.dingtalk.com/i/nodes/mExel2BLV541nqKkSZX5MzAlWgk9rpMq?utm_scene=team_space
验收标准
及时响应业务问题并处理妥善,保持系统稳定性
1.优化代码sql,移除汇总逻辑