案件列表查询——天津分公司
slow sql 2447 millis. SELECT COUNT FROM dd_case_info WHERE (case_status = ? AND actual_org_code IN (?, ?, ?, ?, ?, ?))[2,"13","010007","020001","0398","1301","1302"]

首页报表——各机构案件数量
slow sql 3446 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (org_code = ? AND create_time LIKE ?)["01","2023-06-12 00%"]
改造为：日期范围查询
报表——机构案件统计（车险、非车险）
slow sql 2031 millis. SELECT COUNT( * ) FROM dd_case_info WHERE (insurance_type = ? AND report_time LIKE ?)[1,"2023-06-12%"]
改造为：日期范围查询

仅出现一次
slow sql 9291 millis. SELECT COUNT( * ) FROM dd_case_task WHERE (surveyor_code = ? AND insurance_type = ? AND loss_status BETWEEN ? AND ?)["990556",1,2,12]

TS_SLD02——从调度系统查询案件信息(做过视频的案件)，入参携带预报案号
slow sql 2278 millis. SELECT
c.regist_no,
c.forecast_case_no,
t.loss_id,
c.policy_no,
c.is_auto_video_flag,
c.damage_place,
c.damage_time,
c.damage_remark,
c.report_time,
c.informant,
c.informant_phone,
c.insured_name,
c.license_no,
c.vin,
c.linker_name,
c.linker_phone,
c.org_code,
c.sponsor_type,
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
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
GROUP BY c.regist_no

ORDER BY c.report_time DESC
limit ? , ?["VIDEO20230611125100陕A1F2E3","VIDEO20230610115100陕A21D7U","VIDEO20230610094000陕UZ3681","VIDEO20230609124900冀G632Z5","VIDEO20230608083700鲁AFP007","VIDEO20230605164800蒙EA7652","VIDEO20230601083300陕A8A57X","VIDEO20230531105800陕AU185F","VIDEO20230530111800陕U2Y871","VIDEO20230530095300川ACM282",0,10]