phalcon_db_log.php

<?php
$evtManager = new \Phalcon\Events\Manager();
$logger = new \Phalcon\Logger\Adapter\File($configs->database->$nodeName->logger . date("Ymd"));
$evtManager->attach('db', function($event, $connection) use ($logger) {
    if ($event->getType() == 'beforeQuery') {
        $variables = $connection->getSqlVariables();
        if (count($variables)) {
            $logger->log($connection->getSQLStatement() . "; Bind parameters: ". join(", ", $variables), \Phalcon\Logger::INFO);
        } else {
            $logger->log($connection->getSQLStatement(), \Phalcon\Logger::INFO);                            
        }
    }
});
$connection->setEventsManager($evtManager);