diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/ProjectInfoMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/ProjectInfoMapper.xml
index e928934..932d76c 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/ProjectInfoMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/ProjectInfoMapper.xml
@@ -26,9 +26,7 @@
 
     <!-- 通用查询结果列 -->
     <sql id="Base_Column_List">
-        t
-        .
-        id
+        t.id
         , t.project_code
     	, t.project_name
     	, t.upload_api
@@ -79,12 +77,14 @@
 
 
     <select id="selectUploadApiBySn" resultType="com.newfiber.termite.domain.ProjectInfo">
-        select DISTINCT tb.project_code  as projectCode
-                      , tb.project_name  as projectName
-                      , tb.upload_api    as uploadApi
-                      , tb.field_explain as fieldExplain
-        from ter_device_info ta
-                 left join ter_project_info tb on ta.project_code = tb.project_code
+        select
+            DISTINCT
+            tb.project_code as projectCode
+                   , tb.project_name as projectName
+                   , tb.upload_api  as  uploadApi
+                   , tb.field_explain  as fieldExplain
+        from  ter_device_info ta
+                  left join ter_project_info tb on ta.project_code=tb.project_code
         where ta.sn = #{sn}
     </select>
 </mapper>