id_, type_id_, code_, name_, is_intellect_, device_type_, full_id_, full_name_, sn_, memo_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_, version_, last_time_ SELECT t.*,d.code_ as deviceCode FROM device_info d LEFT JOIN device_product_info p on p.id_ = d.product_id_ LEFT JOIN device_product_type t on t.id_ = p.type_id_ WHERE d.id_ = #{deviceId}