Zend Framework 2 : ZendDeveloperTools : The ZF2 tools You must install

ZendDeveloperTools is a Module for developer and debug tools for working with the ZF2 MVC layer. It can show you a request method, response code, current controller/action, current route we access, execution time, memory consumption, grab the profiler of Zend\Db adapter instance, and Zend Framework version you currently use.

The success installed :

ZendDeveloperTools Module installation :
1. Clone ZendDeveloperTools from Github

git clone git://github.com/zendframework/ZendDeveloperTools.git

2. Copy to vendor folder
3. Copy `ZendDeveloperTools/config/zenddevelopertools.local.php.dist` to
`./config/autoload/zenddevelopertools.local.php`. Change the settings
if you like to.
4. Add the following in your `index.php` first line :

define('REQUEST_MICROTIME', microtime(true));

5. Enable it in application.config.php

<?php
return array(
    'modules' => array(
        'Application',
        'ZendDeveloperTools',
    ),
    'module_listener_options' => array(
        'config_glob_paths'    => array(
            'config/autoload/{,*.}{global,local}.php',
        ),
        'module_paths' => array(
            './module',
            './vendor',
        ),
    ),
);

If you wish to profile Zend\Db, you have to install and enable [BjyProfiler] :
1. Clone BjyProfiler Module from Github/

git clone git://github.com/bjyoungblood/BjyProfiler.git

2. Copy to vendor folder
3. Change your database configuration like the following :

$dbParams = array(
    'database'  => 'zf2',
    'username'  => 'developer',
    'password'  => '123456',
    'hostname'  => 'localhost'
);

return array(
    'service_manager' => array(
        'factories' => array(
            'Zend\Db\Adapter\Adapter' => function ($sm) use ($dbParams) {
                $adapter = new BjyProfiler\Db\Adapter\ProfilingAdapter(array(
                    'driver'    => 'pdo',
                    'dsn'       => 'pgsql:dbname='.$dbParams['database'].';host='.$dbParams['hostname'],
                    'database'  => $dbParams['database'],
                    'username'  => $dbParams['username'],
                    'password'  => $dbParams['password'],
                    'hostname'  => $dbParams['hostname'],
                ));

                $adapter->setProfiler(new BjyProfiler\Db\Profiler\Profiler);
                $adapter->injectProfilingStatementPrototype();
                return $adapter;
            },
        ),
    ),
);

4. Enable it in application.config.php

<?php
return array(
    'modules' => array(
        'Application',
        'ZendDeveloperTools',
        'BjyProfiler'
   ),
    'module_listener_options' => array(
        'config_glob_paths'    => array(
            'config/autoload/{,*.}{global,local}.php',
        ),
        'module_paths' => array(
            './module',
            './vendor',
        ),
    ),
);

If your installation succeded, you can debug your application :

$profiler = $this->getServiceLocator()->get('Zend\Db\Adapter\Adapter')->getProfiler();
$queryProfiles = $profiler->getQueryProfiles();

foreach($queryProfiles as $key=>$row)
{
    print_r($row->toArray());
}

And the result will like this :

References :
1. https://github.com/zendframework/ZendDeveloperTools/blob/master/README.md
2. https://github.com/bjyoungblood/BjyProfiler/blob/master/README.md