ID_, MOULD_ID_, API_NAME_, API_DESC_, API_URL_, API_MODE_, API_QUREY_TYPE_, DB_ALIAS_, API_SQL_, REQUEST_HEADER_, REQUEST_PARAMS_, REQUEST_EXAMPLE_, RESPONSE_STATUS_, RESPONSE_PARAMS_, RESPONSE_EXAMPLE_, STATUS_, SN_, IS_DELE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_ORG_ID_, UPDATE_TIME_, TENANT_ID_ SELECT a1.* FROM ( SELECT * FROM biz_share_api a JOIN ( SELECT t1.ID_ AS tableId FROM biz_share_table t1 WHERE t1.IS_DELE_ = '0' AND t1.CATALOG_ID_ = #{catalogId} AND t1.DEPLOYED_STATUS_ = '1' AND t1.IS_API_ = '1' ) AS t2 ON a.TABLE_ID_ = t2.tableId WHERE a.IS_DELE_ = '0' AND a.STATUS_ = '1' AND a.ID_ NOT IN ( SELECT au.RESOURCE_ID_ FROM biz_share_auth au WHERE au.MEMBER_ID_ = #{consumerId} AND au.RESOURCE_TYPE_ = '3' )) a1 ${ew.customSqlSegment}