ID_,NAME_,CODE_,TYPE_,CTL_TYPE_,JSON_,UPDATE_TIME_,IS_DELE_,VERSION_,TENANT_TYPE_ID_ DELETE FROM uc_params WHERE IS_DELE_='1' SELECT FROM uc_params WHERE CODE_ = #{code} AND IS_DELE_!='1' SELECT FROM uc_params WHERE CODE_ = #{code} AND TENANT_TYPE_ID_ = #{tenantTypeId} AND IS_DELE_!='1' SELECT FROM uc_params WHERE TYPE_ = #{type} AND IS_DELE_!='1' SELECT FROM uc_params WHERE TENANT_TYPE_ID_ = #{tenantTypeId} AND IS_DELE_!='1' select up.*,tt.name_ "type_name_" from uc_params up left join uc_tenant_type tt on up.tenant_type_id_ = tt.id_ ${ew.customSqlSegment} select count(1) from uc_params where code_ = #{code}