[TAISHAN-868] 【慢SQL优化——2023-06-12】相关功能记录 - 道康互联（DDSC）

李小龙创建问题 - 12/六月/23 6:18 下午

李小龙进行了改变 - 12/六月/23 6:18 下午

字段	原值	新值
描述		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"]

李小龙进行了改变 - 12/六月/23 6:19 下午

描述

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 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%"]

李小龙进行了改变 - 12/六月/23 6:20 下午

描述

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 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%"]

李小龙进行了改变 - 12/六月/23 6:21 下午

描述

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

李小龙进行了改变 - 12/六月/23 6:22 下午

描述

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]

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]

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]

李小龙进行了改变 - 12/六月/23 6:29 下午

描述

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]

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]

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]

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]

李小龙进行了改变 - 12/六月/23 6:29 下午

描述

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]

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]

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]

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]

李小龙进行了改变 - 12/六月/23 6:30 下午

描述

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]

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]

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]

预报案相关
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]

李小龙进行了改变 - 12/六月/23 6:31 下午

描述

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]

预报案相关
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]

仅出现一次
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]

预报案相关
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]

李小龙进行了改变 - 12/六月/23 6:33 下午

描述

仅出现一次
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]

预报案相关
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]

仅出现一次
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]

预报案相关,总共出现四次
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]

李小龙进行了改变 - 14/六月/23 10:01 上午

主题

【慢SQL记录】2023-06-12

【慢SQL优化——2023-06-12】相关功能记录

李小龙进行了改变 - 14/六月/23 5:37 下午

描述

仅出现一次
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]

预报案相关,总共出现四次
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]

仅出现一次
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]

预报案相关,总共出现四次
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]

李小龙进行了改变 - 14/六月/23 5:39 下午

描述

仅出现一次
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]

预报案相关,总共出现四次
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]

仅出现一次
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]

预报案相关,总共出现四次
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]

李小龙进行了改变 - 14/六月/23 5:39 下午

描述

仅出现一次
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]

预报案相关,总共出现四次
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]

仅出现一次
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]

预报案相关,总共出现四次
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]

李小龙进行了改变 - 14/六月/23 5:43 下午

描述

仅出现一次
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]

预报案相关,总共出现四次
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]

仅出现一次
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]

李小龙进行了改变 - 14/六月/23 5:55 下午

描述

仅出现一次
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]

案件列表查询——天津分公司
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]

【慢SQL优化——2023-06-12】相关功能记录

问题详情

描述

活动

用户

日期