code: public function offsetGet($page)
      {
          if (! $this->routeGenerator instanceof RouteGeneratorInterface) {
              throw new NotInitialized();
          }
  
          $countQueryBuilderModifier = function (Select $select) {
              foreach (\array_keys($select->getCols()) as $key) {
                  $select->removeCol($key);
              }
  
              return $select->cols(['COUNT(*) AS total_results'])->resetOrderBy()->limit(1);
          };
          $pagerfanta = new Pagerfanta(new AuraSqlQueryAdapter($this->pdo, $this->select, $countQueryBuilderModifier));
          $pagerfanta->setMaxPerPage($this->paging);
          $pagerfanta->setCurrentPage($page);
  
          $pager = new Page($pagerfanta, $this->routeGenerator, $this->view, $this->viewOptions);
          $pager->maxPerPage = $pagerfanta->getMaxPerPage();
          $pager->current = $pagerfanta->getCurrentPage();
          $pager->hasNext = $pagerfanta->hasNextPage();
          $pager->hasPrevious = $pagerfanta->hasPreviousPage();
          $pager->data = $pagerfanta->getCurrentPageResults();
          $pager->total = $pagerfanta->getNbResults();
  
          return $pager;
      }
docs: {@inheritdoc}