Zend FR

SELECT COUNT(1) AS `c` FROM (SELECT `posts`.* FROM `posts`) AS `original_select`

SELECT count (*) as count from posts

SELECT `posts`.* FROM `posts` LIMIT 10, 20

public function fetchAll($paginated=false)
    {
        if($paginated) {
            // create a new Select object for the table annonce
            $select = new Select('posts');
           

            // create a new result set based on the Annonce entity
            $resultSetPrototype = new ResultSet();
            $resultSetPrototype->setArrayObjectPrototype(new Posts());
            // create a new pagination adapter object
            $paginatorAdapter = new DbSelect(
                // our configured select object
                $select,
                // the adapter to run it against
                $this->tableGateway->getAdapter(),
                // the result set to hydrate
                $resultSetPrototype
            );
            

            $paginator = new Paginator($paginatorAdapter);
            return $paginator;
        }
        $resultSet = $this->tableGateway->select();
        return $resultSet;
    }

        $paginator = $this->getpostTable()->fetchAll(true);

        // set the current page to what has been passed in query string, or to 1 if none set
        $paginator->setCurrentPageNumber((int)$this->params()->fromQuery('page', 1));