ID_, PLAN_ID_, TASK_ID_, TYPE_, WORKCLASS_, INSPECT_TYPE_, ROAD_ID_, ROAD_NAME_, ROAD_CODE_, START_PATROL_ID_, START_PATROL_NAME_, END_PATROL_ID_, END_PATROL_NAME_, TEAM_ID_, TEAM_FULL_ID_, START_TIME_, END_TIME_, INSPECT_USERS_ID_, INSPECT_USERS_NAME_, WEATHER_, CAR_CODE_, INSPECT_LENGTH_, CREATE_BY_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT r.*, p.PLAN_NO_, t.TASK_NO_, d.MAX_CREATE_TIME_NODE_2 AS planStartTime, d.MAX_CREATE_TIME_NODE_4 AS planEndTime, t.TASK_STATUS_ AS inspectStatus FROM biz_inspection_result r LEFT JOIN biz_inspection_plan p ON r.PLAN_ID_ = p.ID_ LEFT JOIN biz_inspection_task t ON r.TASK_ID_ = t.ID_ LEFT JOIN ( SELECT RESULT_ID_, MAX(CASE WHEN INSPECT_NODE_ = 2 THEN CREATE_TIME_ END) AS MAX_CREATE_TIME_NODE_2, MAX(CASE WHEN INSPECT_NODE_ = 4 THEN CREATE_TIME_ END) AS MAX_CREATE_TIME_NODE_4 FROM biz_inspection_result_detail t GROUP BY RESULT_ID_ ) d ON r.id_=d.RESULT_ID_ ${ew.customSqlSegment} SELECT r.*, tk.team_name_ AS teamName FROM biz_inspection_result r INNER JOIN biz_inspection_task tk ON r.TASK_ID_=tk.ID_ ${ew.customSqlSegment} SELECT bir.*, bip.team_name_ as teamName FROM biz_inspection_result bir JOIN biz_inspection_plan bip ON bir.plan_id_ = bip.id_ WHERE bip.is_dele_ = '0' AND bir.is_dele_ = '0' AND bir.ID_ = #{id} LIMIT 1 SELECT id_ FROM biz_inspection_result WHERE is_dele_ = '0' AND task_id_ = #{taskId} UPDATE biz_inspection_result r JOIN (SELECT task_id_, ifnull(SUM( END_MILEAGE_ - START_MILEAGE_ ),0) AS mileage FROM biz_car_task_log WHERE is_dele_ = '0' GROUP BY task_id_ ) tl ON r.task_id_= tl.task_id_ SET r.mileage_ = tl.mileage,r.end_time_ = now() WHERE r.task_id_=#{taskId} AND r.is_dele_='0'