To log all queries we need to use Event Listeners
class QueryDebuggerListener extends Doctrine_EventListener
{
public function preStmtExecute(Doctrine_Event $event)
{
$q = $event->getQuery();
$params = $event->getParams();
while (sizeof($params) > 0) {
$param = array_shift($params);
if (!is_numeric($param)) {
$param = sprintf("'%s'", $param);
}
$q = substr_replace($q, $param, strpos($q, '?'), 1);
}
error_log($q);
}
}
$queryDbg = new QueryDebuggerListener();
$dbh = new PDO($dsn, $user, $password);
$conn = Doctrine_Manager::connection($dbh);
$conn->addListener($queryDbg);
