问题详情
改进
重要
描述
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info
WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"]
2.WX_DP20——查询案件（视频页面自助个人池——总数统计）——总共出现两次
slow sql 5189 millis. SELECT COUNT(1)
FROM
dd_case_info c
WHERE 1=1
and c.video_user = ?
and c.deal_type = ?
AND c.has_commit_video='0'["075027","1"]
3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——需求导致的未触发索引（出现次数最多）
slow sql 2614 millis. SELECT COUNT(1)
FROM
dd_case_info c
WHERE 1=1
AND c.org_code LIKE '05%'
and c.deal_type = ?
AND c.has_commit_video='0'
AND c.video_user IS NULL["1"]
4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——需求导致的未触发索引（出现次数最多）
slow sql 2853 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 '05%'
and c.deal_type = ?
AND c.has_commit_video='0'
AND c.video_user IS NULL
limit ? , ?["1",0,100]
活动
| 字段 | 原值 | 新值 |
|---|---|---|
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.功能模块待确定 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.功能模块待确定 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.功能模块待确定——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.功能模块待确定——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定——出现次数最多 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.功能模块待确定——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.功能模块待确定——出现次数最多 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.功能模块待确定——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——出现次数最多 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——出现次数最多 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定——总共出现两次 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——出现次数最多 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定——总共出现两次 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——出现次数最多 slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——出现次数最多 slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定——总共出现两次 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——需求导致的未触发索引（出现次数最多） slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——需求导致的未触发索引（出现次数最多） slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
| 描述 |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.功能模块待确定——总共出现两次 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——需求导致的未触发索引（出现次数最多） slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——需求导致的未触发索引（出现次数最多） slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |
1.-报表统计（机构报案时间分布统计）
slow sql 3664 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-07-16 01%"] 2.WX_DP20——查询案件（视频页面自助个人池——总数统计）——总共出现两次 slow sql 5189 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 and c.video_user = ? and c.deal_type = ? AND c.has_commit_video='0'["075027","1"] 3.WX_DP20——查询案件（视频页面自助公共池——总数统计）——需求导致的未触发索引（出现次数最多） slow sql 2614 millis. SELECT COUNT(1) FROM dd_case_info c WHERE 1=1 AND c.org_code LIKE '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL["1"] 4.WX_DP20——查询案件（视频页面自助公共池——列表数据 ）——需求导致的未触发索引（出现次数最多） slow sql 2853 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 '05%' and c.deal_type = ? AND c.has_commit_video='0' AND c.video_user IS NULL limit ? , ?["1",0,100] |