SQL优化 随机显示记录

SELECT * FROM Ads ORDER BY RAND() LIMIT 1
我们可以使用索引，并分解为下列语句
SELECT @row_id := COUNT(*) FROM Ads;
SELECT @row_id := FLOOR(RAND() * @row_id) + 1;
SELECT * FROM Ads WHERE ad_id = @row_id;