mybatis拼接SQL时自动做优化(错误，请勿参考)

当orgId不在orgIds中时，orgId会被自动更换为orgIds集合中的第一条记录。

当orgIds为{1,2,3}时，传参orgId=3，能够正常生成SQL

SELECT count(*)
 FROM m_promotion mp
 LEFT JOIN m_pages mps
 ON mps.id = mp.page_id
 LEFT JOIN m_categories mc
 ON mc.id = mps.category_id
 LEFT JOIN m_organization_task mot
 ON mp.id = mot.promotion_id
 WHERE mp.is_published = 1 and mp.type = 2 AND mot.org_id = 3 AND mot.org_id IN ( 1 , 2 , 3 ) AND mps.category_id = 48 AND '2019-09-30 02:53:44.913' BETWEEN mp.published_up AND mp.published_down;

当orgIds为{1,2}时，传参orgId=3，不能够正常生成SQL（orgId会被自动替换为1）

 

SELECT count(*)
 FROM m_promotion mp
 LEFT JOIN m_pages mps
 ON mps.id = mp.page_id
 L