百万数据库某个表「伪」随机显示 N 条数据思路

random.php

/**
 * 随机
 * @param int $rows 数据池
 * @return mixed
 */
protected function random($rows = 100)
{
    $count = User::find()->select(['itemid'])->where([])->count();
    $random = mt_rand($rows, $count - $rows);
    $model = User::find()->where(['>=', 'id', $random])->joinWith(['type'])->limit($rows)->all();

    shuffle($model); // 洗牌
    return $model;
}