重现步骤

反馈人：吴荣发

问题1：

数据库：zhcxkj_center_crm
节点ID：9cdfae993beb44d38947be143de364b6in01
查询时间：66.9876
扫描行数：25393800.0
返回行数：1.0
一天执行次数： 52
慢日志时间：2025-07-26
指纹：8c22ac3076f742038549d6eba18c7d06
SQL语句：SELECT COUNT ( * ) AS total FROM ? em WHERE em . customer_id = ? AND em . receive_time >= '?' AND em . receive_time <= '?' AND em . subject LIKE CONCAT ( '?' , '?' , '?' ) ;
真实SQL：SELECT COUNT(*) AS total FROM t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND em.receive_time >= '2024-07-01 00:00:00' AND em.receive_time <= '2024-08-01 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%');
负责人参考：王海浪

项目参考：java项目


问题2：

数据库：zhcxkj_center_crm
节点ID：9cdfae993beb44d38947be143de364b6in01
查询时间：84.3015
扫描行数：10471600.0
返回行数：49.0408
一天执行次数： 49
慢日志时间：2025-07-26
指纹：d145813376da000d0e3adc6b211ef2e0
SQL语句：SELECT em . email_code , em . order_source_id , em . order_source_name , em . receive_time , em . mail_from_name , em . mail_from , em . service_admin_name , em . business_team_id , em . business_team_name , em . sale_admin_id , em . sale_admin_name , em . subject , em . create_time FROM ? em WHERE em . customer_id = ? AND em . receive_time >= '?' AND em . receive_time <= '?' AND em . subject LIKE CONCAT ( '?' , '?' , '?' ) ORDER BY em . receive_time DESC LIMIT ? , ? ;
真实SQL：SELECT em.email_code, em.order_source_id, em.order_source_name, em.receive_time, em.mail_from_name, em.mail_from, em.service_admin_name, em.business_team_id, em.business_team_name, em.sale_admin_id, em.sale_admin_name, em.subject, em.create_time FROM t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND em.receive_time >= '2023-12-01 00:00:00' AND em.receive_time <= '2025-07-27 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%') ORDER BY em.receive_time DESC LIMIT 50,50;
负责人参考：王海浪
项目参考：java项目


问题3：

数据库：zhcxkj_center_crm
节点ID：9cdfae993beb44d38947be143de364b6in01
查询时间：74.7995
扫描行数：25219100.0
返回行数：100.0
一天执行次数： 24
慢日志时间：2025-07-26
指纹：2f1da5512b28eca0cf6d4a81da601c30
SQL语句：select t1 . id , t1 . customer_id , t1 . platform , t1 . order_source_id , t1 . order_source_name , t1 . platform , t1 . email_code , t1 . mail_uid , t1 . mail_from , t1 . mail_from_name , t1 . mail_to , t1 . subject , t1 . receive_time , t1 . reply_status , t1 . reply_time , t1 . reply_admin_name , t1 . service_admin_id , t1 . service_admin_name , t1 . business_team_id , t1 . create_time FROM ? t1 WHERE t1 . create_time >= '?' and t1 . reply_status = ? and t1 . is_deleted = ? and t1 . id > ? order by t1 . id asc LIMIT ? ;
真实SQL：select t1.id , t1.customer_id , t1.platform , t1.order_source_id , t1.order_source_name , t1.platform , t1.email_code , t1.mail_uid , t1.mail_from , t1.mail_from_name , t1.mail_to , t1.subject , t1.receive_time , t1.reply_status , t1.reply_time , t1.reply_admin_name , t1.service_admin_id , t1.service_admin_name , t1.business_team_id , t1.create_time from t_crm_email_receive_amazon t1 WHERE t1.create_time >= '2025-07-23 00:00:00' and t1.reply_status = 0 and t1.is_deleted = 0 and t1.id>0 order by t1.id asc LIMIT 100;
负责人参考：王海浪
项目参考：java项目

历史记录  
  1. 2025-07-28 09:24:27, 由 陈莉珍 创建。
  2. 2025-07-28 09:25:12, 由 陈莉珍 指派给 王海浪。
    修改了 指派给，旧值为 "yangjinxuan"，新值为 "wanghailang"。
  3. 2025-07-28 09:30:17, 由 陈莉珍 编辑。
    修改了 所属模块，旧值为 "0"，新值为 "1858"。
    修改了 业务部门，旧值为 "0"，新值为 "2"。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 重现步骤，区别为：
    001- 反馈人：吴荣发
    001+ 反馈人：吴荣发
    002- 数据库：zhcxkj_center_crm
    002+ 问题1：
    003- 节点ID：9cdfae993beb44d38947be143de364b6in01
    003+ 数据库：zhcxkj_center_crm
    004- 查询时间：66.9876
    004+ 节点ID：9cdfae993beb44d38947be143de364b6in01 查询时间：66.9876 扫描行数：25393800.0 返回行数：1.0 一天执行次数： 52 慢日志时间：2025-07-26 指纹：8c22ac3076f742038549d6eba18c7d06 SQL语句：SELECT COUNT ( * ) AS total FROM ? em WHERE em . customer_id = ? AND em . receive_time &gt;= '?' AND em . receive_time &lt;= '?' AND em . subject LIKE CONCAT ( '?' , '?' , '?' ) ; 真实SQL：SELECT COUNT(*) AS total FROM t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND em.receive_time &gt;= '2024-07-01 00:00:00' AND em.receive_time &lt;= '2024-08-01 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%'); 负责人参考：王海浪项目参考：java项目
    005- 扫描行数：25393800.0
    005+
    006- 返回行数：1.0
    006+ 问题2：
    007- 一天执行次数： 52
    007+ 数据库：zhcxkj_center_crm节点ID：9cdfae993beb44d38947be143de364b6in01查询时间：84.3015扫描行数：10471600.0返回行数：49.0408一天执行次数： 49慢日志时间：2025-07-26指纹：d145813376da000d0e3adc6b211ef2e0SQL语句：SELECT
    008- 慢日志时间：2025-07-26
    008+ em . email_code , em . order_source_id , em . order_source_name , em .
    009- 指纹：8c22ac3076f742038549d6eba18c7d06
    009+ receive_time , em . mail_from_name , em . mail_from , em .
    010- SQL语句：SELECT COUNT ( * ) AS total FROM ? em WHERE em . customer_id = ? AND em . receive_time &gt;= '?' AND em . receive_time &lt;= '?' AND em . subject LIKE CONCAT ( '?' , '?' , '?' ) ;
    010+ service_admin_name , em . business_team_id , em . business_team_name ,
    011- 真实SQL：SELECT COUNT(*) AS total FROM t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND em.receive_time &gt;= '2024-07-01 00:00:00' AND em.receive_time &lt;= '2024-08-01 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%');
    011+ em . sale_admin_id , em . sale_admin_name , em . subject , em .
    012- 负责人参考：王海浪
    012+ create_time FROM ? em WHERE em . customer_id = ? AND em . receive_time
    013- 项目参考：java项目
    013+ &gt;= '?' AND em . receive_time &lt;= '?' AND em . subject LIKE CONCAT (
    014+ '?' , '?' , '?' ) ORDER BY em . receive_time DESC LIMIT ? , ? ;真实SQL：SELECT
    015+ em.email_code, em.order_source_id, em.order_source_name,
    016+ em.receive_time, em.mail_from_name, em.mail_from, em.service_admin_name,
    017+ em.business_team_id, em.business_team_name, em.sale_admin_id,
    018+ em.sale_admin_name, em.subject, em.create_time FROM
    019+ t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND
    020+ em.receive_time &gt;= '2023-12-01 00:00:00' AND em.receive_time &lt;=
    021+ '2025-07-27 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%')
    022+ ORDER BY em.receive_time DESC LIMIT 50,50;负责人参考：王海浪项目参考：java项目
    023+
    001- 反馈人：吴荣发<br />
    001+ <p>反馈人：吴荣发</p>
    002- 数据库：zhcxkj_center_crm<br />
    002+ <p>问题1：</p>
    003- 节点ID：9cdfae993beb44d38947be143de364b6in01<br />
    003+ 数据库：zhcxkj_center_crm<br />
    004- 查询时间：66.9876<br />
    004+ 节点ID：9cdfae993beb44d38947be143de364b6in01<br /> 查询时间：66.9876<br /> 扫描行数：25393800.0<br /> 返回行数：1.0<br /> 一天执行次数： 52<br /> 慢日志时间：2025-07-26<br /> 指纹：8c22ac3076f742038549d6eba18c7d06<br /> SQL语句：SELECT COUNT ( * ) AS total FROM ? em WHERE em . customer_id = ? AND em . receive_time &gt;= '?' AND em . receive_time &lt;= '?' AND em . subject LIKE CONCAT ( '?' , '?' , '?' ) ;<br /> 真实SQL：SELECT COUNT(*) AS total FROM t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND em.receive_time &gt;= '2024-07-01 00:00:00' AND em.receive_time &lt;= '2024-08-01 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%');<br /> 负责人参考：王海浪<br /><p>项目参考：java项目</p>
    005- 扫描行数：25393800.0<br />
    005+ <p><br /></p>
    006- 返回行数：1.0<br />
    006+ <p>问题2：</p>
    007- 一天执行次数： 52<br />
    007+ <p>数据库：zhcxkj_center_crm<br />节点ID：9cdfae993beb44d38947be143de364b6in01<br />查询时间：84.3015<br />扫描行数：10471600.0<br />返回行数：49.0408<br />一天执行次数： 49<br />慢日志时间：2025-07-26<br />指纹：d145813376da000d0e3adc6b211ef2e0<br />SQL语句：SELECT
    008- 慢日志时间：2025-07-26<br />
    008+ em . email_code , em . order_source_id , em . order_source_name , em .
    009- 指纹：8c22ac3076f742038549d6eba18c7d06<br />
    009+ receive_time , em . mail_from_name , em . mail_from , em .
    010- SQL语句：SELECT COUNT ( * ) AS total FROM ? em WHERE em . customer_id = ? AND em . receive_time &gt;= '?' AND em . receive_time &lt;= '?' AND em . subject LIKE CONCAT ( '?' , '?' , '?' ) ;<br />
    010+ service_admin_name , em . business_team_id , em . business_team_name ,
    011- 真实SQL：SELECT COUNT(*) AS total FROM t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND em.receive_time &gt;= '2024-07-01 00:00:00' AND em.receive_time &lt;= '2024-08-01 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%');<br />
    011+ em . sale_admin_id , em . sale_admin_name , em . subject , em .
    012- 负责人参考：王海浪<br />
    012+ create_time FROM ? em WHERE em . customer_id = ? AND em . receive_time
    013- 项目参考：java项目<br />
    013+ &gt;= '?' AND em . receive_time &lt;= '?' AND em . subject LIKE CONCAT (
    014+ '?' , '?' , '?' ) ORDER BY em . receive_time DESC LIMIT ? , ? ;<br />真实SQL：SELECT
    015+ em.email_code, em.order_source_id, em.order_source_name,
    016+ em.receive_time, em.mail_from_name, em.mail_from, em.service_admin_name,
    017+ em.business_team_id, em.business_team_name, em.sale_admin_id,
    018+ em.sale_admin_name, em.subject, em.create_time FROM
    019+ t_crm_email_receive_amazon em WHERE em.customer_id = 1 AND
    020+ em.receive_time &gt;= '2023-12-01 00:00:00' AND em.receive_time &lt;=
    021+ '2025-07-27 23:59:59' AND em.subject LIKE CONCAT('%', 'Easy Ship', '%')
    022+ ORDER BY em.receive_time DESC LIMIT 50,50;<br />负责人参考：王海浪<br />项目参考：java项目</p>
    023+ <p><br /></p>
  4. 2025-07-28 09:34:41, 由 陈莉珍 编辑。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 重现步骤，区别为：
    023-
    023+
    024+ 问题3：
    025+ 数据库：zhcxkj_center_crm节点ID：9cdfae993beb44d38947be143de364b6in01查询时间：74.7995扫描行数：25219100.0返回行数：100.0一天执行次数： 24慢日志时间：2025-07-26指纹：2f1da5512b28eca0cf6d4a81da601c30SQL语句：select
    026+ t1 . id , t1 . customer_id , t1 . platform , t1 . order_source_id , t1 .
    027+ order_source_name , t1 . platform , t1 . email_code , t1 . mail_uid ,
    028+ t1 . mail_from , t1 . mail_from_name , t1 . mail_to , t1 . subject , t1 .
    029+ receive_time , t1 . reply_status , t1 . reply_time , t1 .
    030+ reply_admin_name , t1 . service_admin_id , t1 . service_admin_name , t1 .
    031+ business_team_id , t1 . create_time FROM ? t1 WHERE t1 . create_time
    032+ &gt;= '?' and t1 . reply_status = ? and t1 . is_deleted = ? and t1 . id
    033+ &gt; ? order by t1 . id asc LIMIT ? ;真实SQL：select t1.id
    034+ , t1.customer_id , t1.platform ,
    035+ t1.order_source_id , t1.order_source_name ,
    036+ t1.platform , t1.email_code , t1.mail_uid
    037+ , t1.mail_from , t1.mail_from_name ,
    038+ t1.mail_to , t1.subject , t1.receive_time
    039+ , t1.reply_status , t1.reply_time ,
    040+ t1.reply_admin_name , t1.service_admin_id ,
    041+ t1.service_admin_name , t1.business_team_id ,
    042+ t1.create_time from t_crm_email_receive_amazon t1 WHERE
    043+ t1.create_time &gt;= '2025-07-23 00:00:00' and
    044+ t1.reply_status = 0 and t1.is_deleted = 0 and
    045+ t1.id&gt;0 order by t1.id asc LIMIT 100;负责人参考：王海浪项目参考：java项目
    023- <p><br /></p>
    023+ <p><br /></p>
    024+ <p>问题3：</p>
    025+ <p>数据库：zhcxkj_center_crm<br />节点ID：9cdfae993beb44d38947be143de364b6in01<br />查询时间：74.7995<br />扫描行数：25219100.0<br />返回行数：100.0<br />一天执行次数： 24<br />慢日志时间：2025-07-26<br />指纹：2f1da5512b28eca0cf6d4a81da601c30<br />SQL语句：select
    026+ t1 . id , t1 . customer_id , t1 . platform , t1 . order_source_id , t1 .
    027+ order_source_name , t1 . platform , t1 . email_code , t1 . mail_uid ,
    028+ t1 . mail_from , t1 . mail_from_name , t1 . mail_to , t1 . subject , t1 .
    029+ receive_time , t1 . reply_status , t1 . reply_time , t1 .
    030+ reply_admin_name , t1 . service_admin_id , t1 . service_admin_name , t1 .
    031+ business_team_id , t1 . create_time FROM ? t1 WHERE t1 . create_time
    032+ &gt;= '?' and t1 . reply_status = ? and t1 . is_deleted = ? and t1 . id
    033+ &gt; ? order by t1 . id asc LIMIT ? ;<br />真实SQL：select t1.id
    034+ , t1.customer_id , t1.platform ,
    035+ t1.order_source_id , t1.order_source_name ,
    036+ t1.platform , t1.email_code , t1.mail_uid
    037+ , t1.mail_from , t1.mail_from_name ,
    038+ t1.mail_to , t1.subject , t1.receive_time
    039+ , t1.reply_status , t1.reply_time ,
    040+ t1.reply_admin_name , t1.service_admin_id ,
    041+ t1.service_admin_name , t1.business_team_id ,
    042+ t1.create_time from t_crm_email_receive_amazon t1 WHERE
    043+ t1.create_time &gt;= '2025-07-23 00:00:00' and
    044+ t1.reply_status = 0 and t1.is_deleted = 0 and
    045+ t1.id&gt;0 order by t1.id asc LIMIT 100;<br />负责人参考：王海浪<br />项目参考：java项目</p>
  5. 2025-07-28 09:42:03, 由 王海浪 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2025-07-28 09:39:54"。
    修改了 指派给 ，旧值为 "wanghailang"，新值为 "jingdan"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "wanghailang"。
    已经安排进主干，修复中，预计月底上线
  6. 2025-07-28 10:55:34, 由 陈莉珍 编辑。
    修改了 开发责任人，旧值为 ""，新值为 "wanghailang"。
    修改了 测试责任人，旧值为 ""，新值为 "wanghailang"。
    修改了 解决时效 ，旧值为 "0"，新值为 "0.26"。
    修改了 上线时间 ，旧值为 "0000-00-00 00:00:00"，新值为 "2025-07-28 09:45"。
    修改了 上线时效 ，旧值为 "-1"，新值为 "0.34"。
  7. 2025-07-29 10:47:50, 由 敬丹 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "jingdan"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "jingdan"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-07-29 10:47:50"。
返回
所属项目 技术中心-需求池
所属模块 客服账号   客服CRM
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 王海浪
测试责任人 王海浪
解决时效 0.26
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-07-29 10:47:50
截止日期 0000-00-00
上线时间 2025-07-28 09:45:00
上线时效 0.34
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-07-28 09:24:27
影响环境 生产环境-业务反馈
由谁解决 王海浪 于 2025-07-28 09:39:54
解决版本 主干
解决方案 性能问题
由谁关闭 敬丹 于 2025-07-29 10:47:50
最后修改 敬丹 于 2025-07-29 10:47:50
相关Bug