底层查询语句会做多子查询,ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER;
效率会比较低,只能用原生查询。
例子
SELECT * FROM Equipment
实际执行
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Equipment] ) AS thinkphp) AS T1