php+mysql优化order by rand() 使用JOIN 进行渲染优化 傲世零零 2020年06月29日 建站秘籍 2044 人围观 抢沙发 select t1.id,t1.title from YC_news AS t1 JOIN ( select round( rand() * ( select max(id) from YC_news ) ) as id ) as t2 where t1.id >= t2.id order by t1.id asc limit&... 继续阅读»