Profiling Doctrine 2 with Zend Framework

application.ini

# ../application/configs/application.ini
resources.doctrine.dbal.connections.default.sqlLoggerClass  = "Doctrine\DBAL\Logging\DebugStack"
ZFDebug = 1

boostrap_with_config_file.php

<?php
// ../application/Bootstrap.php

if($this->getOption('ZFDebug') == '1')
{
    $autoloader = Zend_Loader_Autoloader::getInstance();
    $autoloader->registerNamespace('ZFDebug');
    
    $em = $this->bootstrap('doctrine')->getResource('doctrine')->getEntityManager();

    $options = array(
        'plugins' => array(
            'Variables',
            'ZFDebug_Controller_Plugin_Debug_Plugin_Doctrine2'  => array(
               'entityManagers' => array($em),
            ),
           'File'          => array('basePath' => APPLICATION_PATH . '/application'),
           'Exception',
           'Html',
           'Memory',
           'Time',
        )
    );

    $debug = new ZFDebug_Controller_Plugin_Debug($options);

    $this->bootstrap('frontController');

    $frontController = $this->getResource('frontController');
    $frontController->registerPlugin($debug);
}

bootstrap_without_config_file.php

<?php
// ../application/Bootstrap.php

protected function _initZFDebug()
{
    if(APPLICATION_ENV == 'development')
    {
        $autoloader = Zend_Loader_Autoloader::getInstance();
        $autoloader->registerNamespace('ZFDebug');
        $em = $this->bootstrap('doctrine')->getResource('doctrine')->getEntityManager();
        $em->getConnection()->getConfiguration()->setSQLLogger(new \Doctrine\DBAL\Logging\DebugStack());

        $options = array(
            'plugins' => array(
                'Variables',
                'ZFDebug_Controller_Plugin_Debug_Plugin_Doctrine2'  => array(
                    'entityManagers' => array($em),
                 ),
                 'File' => array('basePath' => APPLICATION_PATH . '/application'),
                 'Exception',
                 'Html',
                 'Memory',
                 'Time',
             )
         );

         $debug = new ZFDebug_Controller_Plugin_Debug($options);
         $this->bootstrap('frontController');
         $frontController = $this->getResource('frontController');
         $frontController->registerPlugin($debug);
    }
}

fire_php_application.ini

# ../application/configs/application.ini
resources.doctrine.dbal.connections.default.sqlLoggerClass     = "ZendX\Doctrine2\FirebugProfiler"