反馈人：李冠
严重级别：一般
所属项目：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查询；方案二：创建合适的索引
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 < 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 <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 < 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 <br />
004- 解决方案：（推荐）方案一：切换StarRocks查询；方案二：创建合适的索引
