数据量比较大时,Laravel 获取分页数据比较耗时,明显慢很多,请问您是怎么解决的呢?
/ Query 1 - 2018-08-30 13:16:22 [240.3ms] /
select from video
where create_time
>= '1535558400000' and like_count
>= '0' order by like_count
desc, create_time
desc limit 30 offset 0;
/==================================================/
/ Query 1 - 2018-08-30 13:20:23 [3467.66ms] /
select from video
where create_time
>= '1535558400000' and like_count
>= '0' order by like_count
desc, create_time
desc limit 30 offset 5970;
/==================================================/
推荐文章: