mysql 随机查出优化

SELECT id
FROM dede_archives t1
JOIN (

SELECT ROUND( RAND( ) * ( 
SELECT MAX( id ) 
FROM dede_archives ) ) AS nid
FROM dede_archives
LIMIT 1
)t2 ON t1.id = t2.nid