MyBatis中使用foreach循环的坑及解决

SELECT * FROM table where id in
<foreach item="item" collection="ids1" open="(" close=")" index="0" separator=",">
#{item}
</foreach>

SELECT * FROM table where id in
<foreach item="item" collection="ids1" open="(" close=")" index="0" separator=",">#{item}</foreach>

mybatis.version=3.2.8

AND (
   <foreach collection="list" open=" id IN (" separator="," close=")" item="id" index="index">
     #{id}
   </foreach>
OR (GRADE In ('0','1')
   AND user_type = '5'
 )
)

AND ( id IN ('1','2','3')
  OR (GRADE In ('0', '1') AND user_type = '5')
)

AND ( 
  OR (GRADE In ('0', '1') AND user_type = '5')
)