sql优化

linwei

2026-02-06 04d27ad79f9bf0c9b5f96e094170ba94c2d63a31

sql优化

 drone-ops/drone-resource/src/main/java/org/sxkj/resource/mapper/AttachMapper.xml

@@ -25,7 +25,7 @@
        select
            ba.*,
            bd.dept_name,
            ifnull(ba.nick_name,ba.original_name) nickName
            coalesce(ba.nick_name,ba.original_name) nickName
        from
            blade_attach ba
        left join

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdPatrolTaskMapper.xml

@@ -34,8 +34,8 @@
            pt.*,
            md.nickname as device_name,
            wo.work_order_name,
            IFNULL(tr.result_count, 0) as result_count,
            IFNULL(tr.issue_event_count, 0) as issue_event_count
            COALESCE(tr.result_count, 0) as result_count,
            COALESCE(tr.issue_event_count, 0) as issue_event_count
        from
            ja_gd_patrol_task pt
        left join

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdTaskResultMapper.xml

@@ -45,7 +45,7 @@

    <select id="selectGdTaskResultListByPatrolTaskId" resultMap="gdTaskResultResultMap">
        SELECT tr.*,
               IFNULL(bu.real_name, bu.name) as distribute_user_name,
               COALESCE(bu.real_name, bu.name) as distribute_user_name,
               bd.dept_name                  as distribute_dept_name
        FROM ja_gd_task_result tr
                 LEFT JOIN (SELECT *

 drone-service/drone-system/src/main/java/org/sxkj/system/mapper/RegionMapper.xml

@@ -135,7 +135,7 @@
            code,
            parent_code,
            ancestors,
            `name`,
            "name",
            province_code,
            province_name,
            city_code,
@@ -150,7 +150,7 @@
            type,
            sort,
            remark,
            `status`,
            "status",
            CASE
            WHEN
                region_level = '5' THEN town_name