CakePHP 分页计数与查询不匹配

使用CakePHP进行分页查询是一个常见的需求，但有时候我们会遇到分页计数与实际查询不匹配的情况。这个问题可能会导致分页结果不正确，因此需要解决这个问题。

public $components = ['Paginator'];

php
$query = $this->Model->find('all', [
    'conditions' => [...], // 查询条件
    'limit' => 10, // 每页显示的记录数
    'order' => ['field' => 'asc'], // 排序方式
]);
$result = $this->Paginator->paginate($query);
$this->set('result', $result);

php
echo $this->Paginator->prev('上一页');
echo $this->Paginator->numbers();
echo $this->Paginator->next('下一页');

php
$result = $this->Paginator->paginate($query, [
    'count' => $customCount // 自定义的总记录数
]);

php
public $components = ['Paginator'];

php
public function index() {
    $this->Paginator->settings = [
        'limit' => 10, // 每页显示的记录数
        'order' => ['created' => 'desc'] // 按创建时间倒序排序
    ];
    $articles = $this->Paginator->paginate($this->Article->find('all'));
    $this->set('articles', $articles);
}

php
echo $this->Paginator->prev('上一页');
echo $this->Paginator->numbers();
echo $this->Paginator->next('下一页');