Change the paginate method

You know better! But now the following code accesses the database 3 times and this is not correct:

PHP Code:

$segment  = 3; 
$perPage  = 10;
$page       = (int)$params[0];
if(!$page)$page++;
$template = 'default'; 
$model = new CustomerModel();
$validation = \Config\Services::validation();
$validation->setRules([
        'name'      => ['label' => 'Name', 'rules' => 'required|max_length[50]'],
        'email'  => ['label' => 'e-mail', 'rules' => 'required|max_length[100]'],
$model->where('active','yes');

$total = $model->countAllResults(false);

$data  =  [ 
    'table' =>  $model->paginate($perPage,$template,$page),
    'pagerlinks' =>  $model->pager->Makelinks($page,$perPage,$total,$template.'_full',$segment)
    ]; 


The first call to the COUNT database: $total = $model->countAllResults(false);
The second two calls to the COUNT and * DB: $model->paginate($perPage,$template,$page)