SQL:

select * from user where (user_id,type) in ((568,6),(569,6),(600,8));

MyBatis XML:

 select date_format(create_Time,'%Y-%m-%d %H:%i:%s') as createTime ,reason,operator,remarks,operation from refund_order_log
        where (order_no,channel) in
        <foreach collection="list" item="item" open="(" close=")" separator=",">
            (#{item.orderNo},#{item.channel})
        </foreach>
        and status =1 order by create_time  desc