Doctrine1 ZFDebug plugin

application.ini

[development : production]
resources.Core_Application_Resource_ZFDebug.enabled = true
resources.Core_Application_Resource_ZFDebug.params.plugins[] = "Variables"
resources.Core_Application_Resource_ZFDebug.params.plugins.File.base_path = APPLICATION_PATH "/../"
resources.Core_Application_Resource_ZFDebug.params.plugins[] = "Memory"
resources.Core_Application_Resource_ZFDebug.params.plugins[] = "Time"
resources.Core_Application_Resource_ZFDebug.params.plugins[] = "Registry"
resources.Core_Application_Resource_ZFDebug.params.plugins[] = "Exception"
resources.Core_Application_Resource_ZFDebug.params.plugins[] = "Core_Controller_Plugin_Debug_Plugin_Doctrine1"

Doctrine1.php

<?php
/**
 * @category   ZFDebug
 * @package    ZFDebug_Controller
 * @subpackage Plugins
 * @author     aur1mas <aur1mas@devnet.lt>
 * @copyright  Copyright (c) 2008-2009 ZF Debug Bar Team (http://code.google.com/p/zfdebug)
 * @license    http://code.google.com/p/zfdebug/wiki/License     New BSD License
 */
class Core_Controller_Plugin_Debug_Plugin_Doctrine1 extends ZFDebug_Controller_Plugin_Debug_Plugin implements ZFDebug_Controller_Plugin_Debug_Plugin_Interface
{

    /**
     * plugin identified name
     *
     * @var string
     */
    protected $_identifier = 'Doctrine1';

    /**
     * @var Doctrine_Connection_Profiler
     */
    protected $_profiler = null;

    /**
     * Create ZFDebug_Controller_Plugin_Debug_Plugin_Dprofiler
     *
     * @param Zend_Db_Adapter_Abstract|array $adapters
     * @author Paulius Petronis <paulius@art21.lt>
     * @return void
     */
    public function __construct($profiler = null)
    {
        if(!$profiler) {
            $profiler = new Doctrine_Connection_Profiler();
            $conn = Doctrine_Manager::connection();
            $conn->setListener($profiler);
        }
        $this->_profiler = $profiler;
    }

    /**
     * Gets menu tab for the Debugbar
     * @author Paulius Petronis <paulius@art21.lt>
     * @return string
     */
    public function getTab()
    {
        if (!$this->_profiler)
            return 'No profiler';

        $time = 0;
        foreach ($this->_profiler as $event) {
            $time += $event->getElapsedSecs();
        }
        $html = "Query: ".$this->_profiler->count().' in '.round($time*1000, 2).' ms';

        return $html;
    }

    /**
     * Gets content panel for the Debugbar
     * @author Paulius Petronis <paulius@art21.lt>
     * @return string
     */
    public function getPanel()
    {
        if (!$this->_profiler) {
            return '';
        }

        $html = '<h4>Database queries</h4>';
        $html .= '<ol>';
        foreach ($this->_profiler as $event) {
            $html .= '<li><strong>'.$event->getName() . " " . sprintf("%f", $event->getElapsedSecs()) . "</strong><br/>";
            $html .= $event->getQuery() . "<br />";
            $params = $event->getParams();
            if(is_array($params) && !empty ($params)) {
                $html .= '<fieldset><legend>Params:</legend>';
                $html .= '<ol>';
                foreach($params as $key => $value) {
                    $html .= '<li>'.$key." = ".$value.'</li>';
                }
                $html .= '</ol>';
                $html .= '</fieldset>';
            }
        }
        $html .= '</ol>';
        return $html;
    }

    /**
     * returns a unique identifier for the specific plugin
     *
     * @author aur1mas <aur1mas@devnet.lt>
     * @return string
     */
    public function getIdentifier()
    {
        return $this->_identifier;
    }
}