001- 反馈人：李冠
001+ 反馈人：李冠 严重级别：一般 所属项目：CRM= DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hAmongst, SUM( CASE WHEN er.reply_status = 0 AND er.receive_time < DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hBefore, SUM( CASE WHEN er.service_admin_id = 0 THEN 1 ELSE 0 END ) unAssignCustomerService, SUM( CASE WHEN er.email_rule_code IS NULL OR er.email_rule_code = '' THEN 1 ELSE 0 END ) unMatchingRule, SUM( CASE WHEN er.email_forward_rule_code IS NOT NULL THEN 1 ELSE 0 END ) dingTransfer FROM t_crm_email_receive_amazon er WHERE er.is_deleted = 0 AND er.receive_time >= '2025-04-10 00:00:00' AND er.receive_time 解决方案：（推荐）方案一：切换StarRocks查询；方案二：创建合适的索引
002- 严重级别：一般
002+ https://alidocs.dingtalk.com/i/nodes/6LeBq413JAzM5aEKsnq5OZE68DOnGvpb?utm_scene=team_space
003- 所属项目：CRM= DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hAmongst, SUM( CASE WHEN er.reply_status = 0 AND er.receive_time < DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hBefore, SUM( CASE WHEN er.service_admin_id = 0 THEN 1 ELSE 0 END ) unAssignCustomerService, SUM( CASE WHEN er.email_rule_code IS NULL OR er.email_rule_code = '' THEN 1 ELSE 0 END ) unMatchingRule, SUM( CASE WHEN er.email_forward_rule_code IS NOT NULL THEN 1 ELSE 0 END ) dingTransfer FROM t_crm_email_receive_amazon er WHERE er.is_deleted = 0 AND er.receive_time >= '2025-04-10 00:00:00' AND er.receive_time
004- 解决方案：（推荐）方案一：切换StarRocks查询；方案二：创建合适的索引

001- 反馈人：李冠<br />
001+ 反馈人：李冠<br /> 严重级别：一般<br /> 所属项目：CRM<br />= DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hAmongst, SUM( CASE WHEN er.reply_status = 0 AND er.receive_time &lt; DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hBefore, SUM( CASE WHEN er.service_admin_id = 0 THEN 1 ELSE 0 END ) unAssignCustomerService, SUM( CASE WHEN er.email_rule_code IS NULL OR er.email_rule_code = '' THEN 1 ELSE 0 END ) unMatchingRule, SUM( CASE WHEN er.email_forward_rule_code IS NOT NULL THEN 1 ELSE 0 END ) dingTransfer FROM t_crm_email_receive_amazon er WHERE er.is_deleted = 0 AND er.receive_time &gt;= '2025-04-10 00:00:00' AND er.receive_time <br /><p>解决方案：（推荐）方案一：切换StarRocks查询；方案二：创建合适的索引</p>
002- 严重级别：一般<br />
002+ <p>https://alidocs.dingtalk.com/i/nodes/6LeBq413JAzM5aEKsnq5OZE68DOnGvpb?utm_scene=team_space</p>
003- 所属项目：CRM<br />= DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hAmongst, SUM( CASE WHEN er.reply_status = 0 AND er.receive_time &lt; DATE_SUB( NOW(), INTERVAL 1 DAY ) THEN 1 ELSE 0 END ) unReply24hBefore, SUM( CASE WHEN er.service_admin_id = 0 THEN 1 ELSE 0 END ) unAssignCustomerService, SUM( CASE WHEN er.email_rule_code IS NULL OR er.email_rule_code = '' THEN 1 ELSE 0 END ) unMatchingRule, SUM( CASE WHEN er.email_forward_rule_code IS NOT NULL THEN 1 ELSE 0 END ) dingTransfer FROM t_crm_email_receive_amazon er WHERE er.is_deleted = 0 AND er.receive_time &gt;= '2025-04-10 00:00:00' AND er.receive_time <br />
004- 解决方案：（推荐）方案一：切换StarRocks查询；方案二：创建合适的索引

001- 技术研发中心-严重级别：一般所属项目：CRM问题原因：慢SQL、查询
001+ CRM：慢SQL查询

001- 技术研发中心-严重级别：一般所属项目：CRM问题原因：慢SQL、查询
001+ CRM：慢SQL查询

001- CRM：慢SQL查询
001+ CRM：亚马逊邮件大表迁移到starrocks

001- CRM：慢SQL查询
001+ CRM：亚马逊邮件大表迁移到starrocks