id_, coll_time_, device_code_, src_data_, data_type_, lean_angle_, voltage_, rsrp_, rssi_, create_time_, last_time_ SELECT b.*,d.name_ as deviceName FROM device_data_signboaerd b LEFT JOIN device_info d ON d.code_ = b.device_code_ ${ew.customSqlSegment}