2020-12-14

mysql in 查询优化，快没快俺也不知道

<select id="listExistOrgCode" resultType="java.lang.String">
        select a.org_code from jf_vis_db.vms_video_orgrange a
        inner join (
            <foreach collection="allParentAndChildCodeSet" item="item" index="index" separator="UNION ALL" >
                select #{item} as org_code
            </foreach>
        ) tmp
        on a.org_code=tmp.org_code
        where a.videoplan_id=#{videoPlanId}
 </select>