The most efficient method for MySQL to randomly fetch data

I found that an SQL statement such as order by rand () is convenient, but the efficiency is too low. So I used the following methods to optimize it, the JOIN table method is used to obtain random data rows. You can use the explain SQL statement to analyze the efficiency of the following two SQL statements. Of course, the performance can be seen only when the data volume is at least 0.1 million.
 
[1] ordinary method, low efficiency
 
SELECT * FROM table order by rand () LIMIT 10;
 
[2] JOIN method:
 
SELECT *
FROM 'table' AS t1 JOIN (select round (RAND () * (select max (id) FROM 'table')-(select min (id) FROM 'table ')) + (select min (id) FROM 'table') AS id) AS t2
WHERE t1.id> = t2.id
Order by t1.id LIMIT 10;
 

Author: "Will software"