ID_, COMPANY_ID_, CODE_, NAME_, TYPE_, TEL_, MOBILE_, ADDRESS_, MEMO_, SN_, IS_DELE_, CREATE_BY_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_, VERSION_, LAST_TIME_ SELECT s.*, c.COMPANY_NAME_ AS companyName FROM device_base_user s LEFT JOIN device_base_company c ON c.id_ = s.COMPANY_ID_ ${ew.customSqlSegment} WHERE AND s.IS_DELE_ = 0