编辑备注

备注详细内容

作者李小龙

创建日期 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]