diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceImeiMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceImeiMapper.xml
index d726dd2..1236a51 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceImeiMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceImeiMapper.xml
@@ -12,11 +12,11 @@
     </sql>
 
     <sql id="dateTime_toChar" databaseId="pgsql">
-          TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss')
+        TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss')
     </sql>
 
     <sql id="dateTime_toChar" databaseId="oracle">
-          TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss')
+        TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss')
     </sql>
 
     <select id="getImeiListPage" resultType="MAP">
@@ -28,9 +28,7 @@
         WHERE 1=1
         <if test="devcode != null and devcode !=''">
             AND (DEVCODE like <include refid="devcode_sql"/> or imei like <include refid="devcode_sql"/> )
-            AND DEVCODE  like CONCAT('%',#{devcode},'%')
         </if>
-        order by logtime desc
     </select>
     <sql id="devcode_sql" databaseId="oracle">
         CONCAT('%',#{devcode},'%')