SELECT * FROM `表` WHERE `id`
IN (SELECT max(id) FROM `表` WHERE `product_id` IN ('1', '2') GROUP BY product_id)
这段SELECT max(id) FROM `表` WHERE `product_id` IN ('1', '2') GROUP BY product_id会查到 id值
SELECT * FROM `表` WHERE `id`
IN (SELECT max(id) FROM `表` WHERE `product_id` IN ('1', '2') GROUP BY product_id)
这段SELECT max(id) FROM `表` WHERE `product_id` IN ('1', '2') GROUP BY product_id会查到 id值