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]