SELECT pturl
FROM `albumpics` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(pid) FROM `albumpics`)-(SELECT MIN(pid) FROM `albumpics`))+(SELECT MIN(pid) FROM `albumpics`)) AS id) AS t2
WHERE t1.pid >= t2.id
FROM `albumpics` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(pid) FROM `albumpics`)-(SELECT MIN(pid) FROM `albumpics`))+(SELECT MIN(pid) FROM `albumpics`)) AS id) AS t2
WHERE t1.pid >= t2.id
ORDER BY t1.pid LIMIT 1
修改albumpics
和索引列pid
即可提速6倍