ID_, WAREHOUSE_ID_, SPARE_CODE_, SPARE_NAME_, SPARE_SPECS_, SPARE_TYPE_, SPARE_NUM_, SPARE_UNIT_, SUPPLIER_COMPANY_ID_, 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_spare s LEFT JOIN device_base_company c ON c.id_ = s.SUPPLIER_COMPANY_ID_ ${ew.customSqlSegment} WHERE AND s.IS_DELE_ = 0