问题详情
描述
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]