问题详情
-
类型:
任务
-
状态: 开始 (查看工作流)
-
优先级:
重要
-
解决结果: 未解决
-
影响版本: v5.0.20231108_release
-
解决版本: V5.0.0_2024
-
模块: 调度后台
-
标签:无 编辑标签
-
项目环境:SIT
描述
slow sql 7873 millis. DELETE FROM dd_scheduling WHERE (upload_dept_code = ? AND batch_no = ?)["12","56"]
slow sql 3883 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 03%"]
slow sql 2005 millis. SELECT COUNT(1) FROM dd_case_info c
LEFT JOIN dd_case_task t ON c.regist_no=t.regist_no
WHERE 1=1
AND t.loss_type='0101'
AND c.forecast_case_no in
(
?
,
?
,
?
,
?
,
?
,
?
,
?
,
?
,
?
,
?
)
AND c.video_user IS NOT NULL["VIDEO20240105102300陕A7N05J","VIDEO20240104163800蒙FAN412","VIDEO20240104105900蒙E106G8","VIDEO20240103101600LC0C74C45P1388982","VIDEO20240101161600鲁B6DJ02","VIDEO20231231104900蒙A082UQ","VIDEO20231231093300鲁V532SR","VIDEO20231229161600蒙DAN180","VIDEO20231228091100鲁GS779E","VIDEO20231225150000陕UCT270"]
slow sql 2841 millis. SELECT COUNT(1)
FROM
dd_case_info c
WHERE 1=1
AND c.org_code LIKE '03%'
and c.deal_type = ?
AND c.has_commit_video='0'
AND c.video_user IS NULL["1"]
slow sql 3224 millis. SELECT
c.regist_no,
c.license_no,
c.insured_name,
c.linker_name,
c.linker_phone,
c.damage_time,
c.report_time,
c.damage_place,
c.damage_remark,
c.case_status,
c.subrogation,
c.vip_level,
c.insurance_type,
c.org_code,
c.org_name,
c.video_user,
c.video_user_name,
c.is_new_policy_flag,
c.is_black_list,
c.black_list_type,
c.black_list_type_desc,
c.deal_type,
c.has_commit_video
FROM
dd_case_info c
WHERE 1=1
AND c.org_code LIKE '03%'
and c.deal_type = ?
AND c.has_commit_video='0'
AND c.video_user IS NULL
limit ? , ?["1",0,100]
slow sql 4427 millis. SELECT COUNT( * ) FROM dd_case_info
WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 17%"]
活动
| 字段 | 原值 | 新值 |
|---|---|---|
| 描述 |
slow sql 7873 millis. DELETE FROM dd_scheduling WHERE (upload_dept_code = ? AND batch_no = ?)["12","56"]
slow sql 3883 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 03%"] slow sql 2005 millis. SELECT COUNT(1) FROM dd_case_info c LEFT JOIN dd_case_task t ON c.regist_no=t.regist_no WHERE 1=1 AND t.loss_type='0101' AND c.forecast_case_no in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND c.video_user IS NOT NULL["VIDEO20240105102300陕A7N05J","VIDEO20240104163800蒙FAN412","VIDEO20240104105900蒙E106G8","VIDEO20240103101600LC0C74C45P1388982","VIDEO20240101161600鲁B6DJ02","VIDEO20231231104900蒙A082UQ","VIDEO20231231093300鲁V532SR","VIDEO20231229161600蒙DAN180","VIDEO20231228091100鲁GS779E","VIDEO20231225150000陕UCT270"] slow sql 2841 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '03%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] slow sql 3224 millis. SELECT c.regist_no, c.license_no, c.insured_name, c.linker_name, c.linker_phone, c.damage_time, c.report_time, c.damage_place, c.damage_remark, c.case_status, c.subrogation, c.vip_level, c.insurance_type, c.org_code, c.org_name, c.video_user, c.video_user_name, c.is_new_policy_flag, c.is_black_list, c.black_list_type, c.black_list_type_desc, c.deal_type, c.has_commit_video FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '03%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] slow sql 4427 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2024-01-09 17%"] |