删除备注

你确定要删除这个备注吗?

李小龙
12/六月/23
李小龙
14/六月/23

之前已经记录的慢SQL——TS_SLD02
slow sql 2476 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"]

2900 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]