Overrides \Drupal\views\Plugin\views\pager\SqlBase::query().
Overrides SqlBase::query
public function query() {
parent::query();
// Don't query for the next page if we have a pager that has a limited
// amount of pages.
if (empty($this->options['total_pages']) || $this
->getCurrentPage() < $this->options['total_pages']) {
// Increase the items in the query in order to be able to find out whether
// there is another page.
$limit = $this->view->query
->getLimit();
$limit += 1;
$this->view->query
->setLimit($limit);
}
}