$orderModel = new OrderModel();
$orderList = $orderModel->where('status', 1)->paginate(10);通过runtime日志可以看到底层通过2次查询结果；[2020-09-11T23:37:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `admin_user` WHERE `id` = 9999 [ RunTime:0.000305s ]
[2020-09-11T23:37:57+08:00][sql] SELECT * FROM `admin_user` WHERE `id` = 9999 LIMIT 0,100 [ RunTime:0.000297s ]建议官方在paginate底层做一次判断，若 think_count > 0 时，才真正执行第二句查询。PS:在大数据量的情况下，若count出的结果为0条数据，也无需在消耗数据库资源查询了。
最佳答案
