diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
index 30709aa..ef2f571 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
@@ -259,16 +259,29 @@
     </select>
 
     <select id="offlineListPage" resultType="MAP">
-        SELECT dv.devcode as devcode, bdt.TYPE_NAME as "deviceTypeName",dv.devicetype,wellcode,dv.lasttime as lasttime,timestampdiff(DAY,dv.LASTTIME,now()) as offlineDays
-        FROM   device_view  dv,base_device_type  bdt
-        LEFT JOIN  bus_device_status bds ON  bds.DEVICE_ID=dv.ID,
-        WHERE    dv.deviceType=bdt.ID
-        <if test="deviceType != null and deviceType !=''">
-            AND  dv.deviceType= #{deviceType}
-        </if>
-        AND bds.ONLINE_STATE='0'
+        SELECT
+        bd.devcode AS devcode,
+        bdt.TYPE_NAME AS deviceTypeName,
+        bd.device_type AS deviceType,
+        bwi.well_code AS wellCode,
+        bds.last_data_ts AS lastDataTs,
+        timestampdiff(
+        DAY,
+        bds.last_data_ts,
+        now()) AS offlineDays
+        FROM
+        bus_device_status bds
+        JOIN bus_device bd ON bds.device_id = bd.id
+        JOIN bus_device_well bdw ON bdw.device_id = bds.device_id
+        JOIN bus_well_info bwi ON bwi.ID = bdw.well_id
+        JOIN base_device_type bdt on bdt.ID = bd.DEVICE_TYPE
+        WHERE
+        bds.online_State = '0'
         <if test="deviceCode != null and deviceCode !=''">
-        AND  DEVCODE = #{deviceCode}
+            AND  bd.DEVCODE = #{deviceCode}
+        </if>
+        <if test="deviceType != null and deviceType !=''">
+            AND  bd.deviceType = #{deviceType}
         </if>
     </select>