<select id="queryByOrderIdAndTradeStatusList" parameterType="java.util.List" resultMap="BaseResultMap">
select * from saint_order_comment
where
<foreach collection="list" item="item" separator=" or " >
(order_id = #{item.orderId} and trade_status = #{item.tradeStatus})
</foreach>
</select>