问题详情

    • 项目环境:
      PRD

      描述

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

        活动

          用户

          • 经办人:
            李小龙
            报告人:
            李小龙
          • 投票:
            0 为这个问题投票
            关注人:
            1 关注这个问题

            日期

            • 创建:
              更新:
              解决: