发一个优化的Yii2 试用的千万级数据分页 2 [ 2.0 版本 ]

use app\models\User;
use yii\data\Pagination;

$subQuery = User::find()->select('id')->where('id>0');
if (($count = Yii::$app->cache->get(__METHOD__) == false)) {
    $count = $subQuery->count();
    Yii::$app->cache->set(__METHOD__, $count, 3600);
}

$pagination = new Pagination(['totalCount' => $count]);

$subQuery->offset($pagination->offset)
    ->limit($pagination->limit);

$query = User::find()->select('*')->from(['t1' => User::tableName(), 't2' => $subQuery])->where('t1.id=t2.id');

$articles = $query->all();

print_r($articles);

相比上一次写的，缓存了count结果