logger.php

<?php

use lithium\analysis\Logger;
use lithium\data\Connections;

Logger::config([
    'default' => [
        'adapter' => 'File',
        'file' => function() { return "combined.log"; },
        'format' => "{:timestamp} {:priority}\t{:message}\n"
    ]
]);

Connections::get('default')->applyFilter('_execute', function($self, $params, $chain) {
    Logger::debug($params['sql']);

    return $chain->next($self, $params, $chain);
});