Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

when i use new \Phalcon\Paginator\Adapter\QueryBuilder, it execute two sql.

one sql is

builder = $this->modelsManager->createBuilder()
        ->orderBy('sendtime DESC');

second sql is

SELECT COUNT(*) AS rowcount FROM fast_list ORDER BY fast_list.sendtime DESC

how can i get second sql count?


ok, i resolved.

now i use phalcon v1.1 beta, before v1.1 beta, getPaginate() method havn't return

[total_pages] => 85162 [total_items] => 1277418


ok, the version is 1.1.0 beta3