<select id="getListByUUIDs" parameterType="pd" resultType="pd" fetchSize="500">
select * from ZK_BASEINFO where 1=1
<if test="list.size() > 0">
AND
"UUID" IN
<!--<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>-->
<foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
<if test="(index % 999) == 998"> NULL ) OR "UUID" IN (</if>#{item}
</foreach>
</if>
</select>