Alterando a Paginação para 15 registros por página

public $paginate = [
'limit' => 15,
'order' => ['Clientes.id' => 'asc']
];

Controller

<?php
class ArticlesController extends AppController
{

    public function initialize()
    {
        parent::initialize();
        // Requerido
        $this->loadComponent('Flash'); // Include the FlashComponent
    }

    public function index()
    {
        $articles = $this->Articles->find('all');
        $this->set(compact('articles'));
    }

    public function view($id = null)
    {
        $article = $this->Articles->get($id);
        $this->set(compact('article'));
    }

    public function add()
    {
        $article = $this->Articles->newEntity();
        if ($this->request->is('post')) {
            $article = $this->Articles->patchEntity($article, $this->request->data);
            if ($this->Articles->save($article)) {
                $this->Flash->success(__('Your article has been saved.'));
                return $this->redirect(['action' => 'index']);
            }
            $this->Flash->error(__('Unable to add your article.'));
        }
        $this->set('article', $article);
    }

    public function edit($id = null)
    {
        $article = $this->Articles->get($id);
        if ($this->request->is(['post', 'put'])) {
            $this->Articles->patchEntity($article, $this->request->data);
            if ($this->Articles->save($article)) {
                $this->Flash->success(__('Your article has been updated.'));
                return $this->redirect(['action' => 'index']);
            }
            $this->Flash->error(__('Unable to update your article.'));
        }

        $this->set('article', $article);
    }

    public function delete($id)
    {
        $this->request->allowMethod(['post', 'delete']);

        $article = $this->Articles->get($id);
        if ($this->Articles->delete($article)) {
            $this->Flash->success(__('The article with id: {0} has been deleted.', h($id)));
            return $this->redirect(['action' => 'index']);
        }
    }
}

Template/view index.ctp

<!-- File: src/Template/Articles/index.ctp  (edit links added) -->

<h1>Blog articles</h1>
<p><?= $this->Html->link("Add Article", ['action' => 'add']) ?></p>
<table>

    <tr>

        <th>Id</th>

        <th>Title</th>

        <th>Created</th>

        <th>Action</th>

    </tr>



<!-- Here's where we iterate through our $articles query object, printing out article info -->



<?php foreach ($articles as $article): ?>

    <tr>

        <td><?= $article->id ?></td>

        <td>

            <?= $this->Html->link($article->title, ['action' => 'view', $article->id]) ?>

        </td>

        <td>

            <?= $article->created->format(DATE_RFC850) ?>

        </td>

        <td>

            <?= $this->Html->link('Edit', ['action' => 'edit', $article->id]) ?>

        </td>

        <td>

            <?= $this->Form->postLink(

                'Delete',

                ['action' => 'delete', $article->id],

                ['confirm' => 'Are you sure?'])

            ?>

            <?= $this->Html->link('Edit', ['action' => 'edit', $article->id]) ?>

        </td>

    </tr>

<?php endforeach; ?>



</table>



<!-- File: src/Template/Articles/view.ctp -->



<h1><?= h($article->title) ?></h1>

<p><?= h($article->body) ?></p>

<p><small>Created: <?= $article->created->format(DATE_RFC850) ?></small></p>



<!-- File: src/Template/Articles/add.ctp -->



<h1>Add Article</h1>

<?php

    echo $this->Form->create($article);

    echo $this->Form->input('title');

    echo $this->Form->input('body', ['rows' => '3']);

    echo $this->Form->button(__('Save Article'));

    echo $this->Form->end();

?>



<!-- File: src/Template/Articles/edit.ctp -->



<h1>Edit Article</h1>

<?php

    echo $this->Form->create($article);

    echo $this->Form->input('title');

    echo $this->Form->input('body', ['rows' => '3']);

    echo $this->Form->button(__('Save Article'));

    echo $this->Form->end();

?>

    <?= $this->Form->create($articles, [

          'url'   => [

               'controller' => 'Articles','action' => 'busca'

           ],

          'id'    => 'web-form',

          'class' =>'panel-body wrapper-lg'

       ]

    ) 

?>

Conexão
$connection = ConnectionManager::get('default');

Select
$results = $connection->execute('SELECT * FROM articles')->fetchAll('assoc');

ou
$results = $connection->execute('SELECT * FROM articles WHERE id = :id', ['id' => 1])->fetchAll('assoc');


Insert
use Cake\Datasource\ConnectionManager;

$connection = ConnectionManager::get('default');
$connection->insert('articles', [
'title' => 'A New Article',
'created' => new DateTime('now')
], ['created' => 'datetime']);

Update
use Cake\Datasource\ConnectionManager;
$connection = ConnectionManager::get('default');
$connection->update('articles', ['title' => 'New title'], ['id' => 10]);

Delete
use Cake\Datasource\ConnectionManager;
$connection = ConnectionManager::get('default');
$connection->delete('articles', ['id' => 10]);


$stmt = $conn->query('UPDATE posts SET published = 1 WHERE id = 2');

The query() method does not allow for additional parameters. If you need additional parameters you should use the execute() method, which allows for placeholders to be used:

$stmt = $conn->execute(
'UPDATE posts SET published = ? WHERE id = ?',
[1, 2]
);

$stmt = $conn->execute(
'UPDATE posts SET published_date = ? WHERE id = ?',
[new DateTime('now'), 2],
['date', 'integer']
);

$stmt->execute();

Ler um registro
$row = $stmt->fetch('assoc');

Ler todos os registros
$rows = $stmt->fetchAll('assoc');

Ler registros interagindo
foreach ($rows as $row) {
// Do work
}

$rowCount = count($stmt);
$rowCount = $stmt->rowCount();

Insert
$query = $articles->query();
$query->insert(['title', 'body'])
->values([
'title' => 'First post',
'body' => 'Some body text'
])
->execute();

$select = $articles->find()
->select(['title', 'body', 'published'])
->where(['id' => 3]);

$query = $articles->query()
->insert(['title', 'body', 'published'])
->values($select)
->execute()

Update
$query = $articles->query();
$query->update()
->set(['published' => true])
->where(['id' => $id])
->execute();

Delete
$query = $articles->query();
$query->delete()
->where(['id' => $id])
->execute();

Outras
$matchingComment = $articles->association('Comments')->find()
->select(['article_id'])
->distinct()
->where(['comment LIKE' => '%CakePHP%']);

$query = $articles->find()
->where(['id' => $matchingComment]);