Laravel的分页是如何工作的? [英] How does Laravel's pagination work exactly?

问题描述

我需要澄清Laravel的分页器在后台的工作方式:假设我有一个包含1000行的表格，我使用 $ results = Model :: paginate(100); 如果我理解正确，Eloquent将从表中带回包含所有行(1000)的集合，将其切成较小的100行集合，并将分页按钮数据附加到它们.现在， $ results 包含 Page 1 集合和按钮的分页数据.我的问题是:按下 Page 2 按钮在后台会发生什么?Eloquent会再次查询数据库，再次检索整个1000行集合，对其进行切片并返回Page 2集合吗，或者它可用于我先前的请求已检索回的集合?还是Eloquent的 :: paginate(100)使用限制查询数据库?喜欢从表限制100中选择* ?

I need some clarifications about how Laravel's paginator works in the background: Say I have a table with 1000 rows and I use $results = Model::paginate(100); If I understood correctly, Eloquent will bring back a collection containing all the rows (1000) from the table, slice it in smaller, 100 rows collections and attach the pagination buttons data to them. Now $results contains the Page 1 collection and the pagination data for the buttons. My question is: what happens in the background when I press Page 2 button? Will Eloquent query the database again, retrieve the whole 1000 rows collection again, slice it and return the Page 2 collection, or does it work on the collection already retrieved back by my previous request? Or, does Eloquent's ::paginate(100) query the database using limits? Like select * from table limit 100?

推荐答案

您可以使用Laravel望远镜来查看Laravel的工作原理.在查询选项卡上，您将看到发出请求时执行的查询(如果未启用缓存).

You can use Laravel Telescope to see how Laravel works. On the queries tab you will see what queries executed when you make requests (if caching is not enabled).

这篇关于Laravel的分页是如何工作的?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！