How to print last query in CakePHP 3?

1
2

// Turn query logging on.
$connection->enableQueryLogging(true);

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

// Console logging
Log::config('queries', [
    'className' => 'Console',
    'stream' => 'php://stderr',
    'scopes' => ['queriesLog']
]);

// File logging
Log::config('queries', [
    'className' => 'File',
    'path' => LOGS,
    'file' => 'queries.log',
    'scopes' => ['queriesLog']
]);

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

$query = $this->Table->find()->where(/* your conditions */);

// Run the query and get the result set
$results = $query->all();

// Get the SQL string of the last executed query
$lastQuery = $query->sql();

// Print the last executed query
echo $lastQuery;