id_, common_id_, file_id_, file_name_, file_type_, file_suffix_, file_url_, file_sizes, is_dele_, create_by_, create_name_, create_org_name_, create_company_id_, create_company_name_, create_org_id_, create_time_, update_by_, update_name_, update_company_name_, update_company_id_, update_org_id_, update_org_name_, update_time_, last_time_, tenant_id_ select biz_id_ AS commonId, id_ AS fileId, file_name_, biz_code_, ext_ AS fileExt, file_path_ from portal_sys_file psf is_del_='0' AND biz_id_ IN #{id} select biz_id_ AS commonId, id_ AS fileId, file_name_, biz_code_, ext_ AS fileExt, file_path_ from portal_sys_file and is_del_='0' and biz_id_=#{companyId} select biz_id_ AS commonId, psf.id_ AS fileId, file_name_, biz_code_, ext_ AS fileExt, file_path_, psf.file_path_, oc.name_ as companyName from biz_base_team_member tm join biz_base_out_company oc on tm.OUT_COMPANY_ID_=oc.ID_ join portal_sys_file psf on oc.ID_=psf.biz_id_ where tm.is_dele_='0' and oc.is_dele_='0' and psf.is_del_='0' and tm.user_id_ = #{userId} order by psf.create_time_ desc limit 1