ID_, TEAM_ID_, TEAM_FULL_ID_, NAME_, ROAD_ID_, MONITOR_ID_, MONITOR_NAME_, MONITOR_TEL_, TRAFFIC_POLICE_Z_, TRAFFIC_POLICE_D_, MANAGEMENT_Z_, MANAGEMENT_D_, TYPE_, PEG_, PEG_ADD_, PEG_VAL_, LINK_NAME__, LINK_TEL_, DUTY_TEL_, DUTY_NUM_, TURN_NUM_, LNG_, LAT_, RESCUS_TEL_, MANAGE_UNIT_ID_, MANAGE_UNIT_NAME_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_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 s.*, t.name_ AS teamName, r.name_ AS roadName, r.code_ AS roadCode FROM biz_base_stationary s LEFT JOIN biz_base_team t ON s.team_id_ = t.id_ AND t.is_dele_ = '0' LEFT JOIN biz_base_road r ON s.road_id_ = r.id_ AND r.is_dele_ = '0' ${ew.customSqlSegment} SELECT s.*, t.name_ AS teamName, r.name_ AS roadName, r.code_ AS roadCode FROM biz_base_stationary s LEFT JOIN biz_base_team t ON s.team_id_ = t.id_ AND t.is_dele_ = '0' LEFT JOIN biz_base_road r ON s.road_id_ = r.id_ AND r.is_dele_ = '0' WHERE s.is_dele_='0' AND s.id_=#{id}