MYSQL 随机查询 百万级

SELECT * FROM `product` WHERE `ID` >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `product`))) ORDER BY `ID` LIMIT 7 SELECT * FROM `product` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(`ID`) FROM `product`)-(SELECT MIN(`ID`) FROM `product`))+(SELECT MIN(`ID`) FROM `product`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 1 SELECT * FROM `product` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(`product_id`) FROM `product`)-(SELECT MIN(`product_id`) FROM `product`))+(SELECT MIN(`product_id`) FROM `product`)) AS id) AS t2 WHERE t1.`product_id` >= t2.id ORDER BY t1.`product_id` LIMIT 7