We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

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

one sql is

builder = $this->modelsManager->createBuilder()
        ->columns('*')
        ->from('List')
        ->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?



17.8k
Accepted
answer

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



98.9k

ok, the version is 1.1.0 beta3