id_, coll_time_, device_code_, action_, status_, create_by_, create_org_id_, create_time_, last_time_, warn_id_ SELECT b.*,d.name_ as deviceName FROM device_data_barricade b LEFT JOIN device_info d ON d.code_ = b.device_code_ ${ew.customSqlSegment}