Mybatis实现多个条件批量查询

sql形如

select * from international i
where i.deleted = 'N'  and 
(i.internation_key, i.language_key, i.system_model)
in (('a', 'zh', 'common') , ('b', 'zh', 'common') , ('c', 'zh', 'common'))
order by id desc

<select id="getListByParam" parameterType="list" resultType="com...InternationalPo">
   select i.*
   from international i
   where i.deleted = 'N'
   and ( i.internation_key, i.language_key, i.system_model ) in
   <foreach collection="list" item="item" open="(" separator="," close=")">
       ( #{item.internationKey} , #{item.languageKey}, #{item.systemModel} )
   </foreach>
</select>