<select id="getByInventoryIds" resultMap="beanMap">

        SELECT * FROM <include refid="t_onsale_resource" />

        <where>

            inventory_id in

            <foreach collection="inventoryIds" item="item" index="index" open="(" separator="," close=")">

                #{item}

            </foreach>

        </where>

    </select>

    List<OnSaleResource> getByInventoryIds(@Param("inventoryIds") List<Long> inventoryIds);