stefano/stefano-db-profiler

A ZF2, ZF3 module to profile db queries using Zend\Db\Adapter\Profiler\Profiler and write them to ZendDeveloperTools toolbar.

[DEPRECATED] Db Profiler

This library is NOT MAINTAINED anymore please use bjyoungblood/BjyProfiler instead., _(*1)

Dependencies

A ZF2, ZF3 module to profile db queries using \Zend\Db\Adapter\Profiler\Profiler and write them to ZendDeveloperTools toolbar, _(*2)

, _(*3)

Features

• profiling db queries
• support multiple db connections

Dependencies

• Zend Framework 2 or Zend Framework 3
• Zend Developer Tools

Instalation

• Add following line to your composer.json file "stefano/stefano-db-profiler": "*", _(*4)

• run composer update, _(*5)

• Add module StefanoDbProfiler to your application.config.php, _(*6)

• Enable profiler for your Db Adapter or Adapters, _(*7)

'db' => array(
    'driver' => 'Pdo_Mysql',
    'database' => 'db',
    'username' => 'username',
    'password' => 'pass',
    'profiler' => true, //this line enable db profiler
)

• Library uses Zend\Db\Adapter\Adapter service key. If you are uses different key for your Db Adapter you must set it by configuration options.

Options

Configuration options are available in config/stefano.db.profiler.global.php.dist file. If you want to change the default ones, copy it in your config/autoload directory, remove the .dist extension and edit it., _(*8)

Options available :, _(*9)

• dbAdapterServiceManagerKey : List of all Db Adapter service manager keys which you want to profile. Zend\Db\Adapter\Adapter is default