mybatis中使用in查询是速度特别慢

Question

AND tqi.id in
<foreach collection="questionIdList"  item="item" index="index"
         open="(" separator="," close=")">
  #{item}
</foreach>

Answer 1

用关联查询不可以吗？ 一定要用in?