antonmarin/traceable-pdo

Wrapper for PDO that adds trace of statement source to analyze slow SQL statements in real-time

traceable-pdo

Adds trace to your sql statement, _(*1)

, _(*2)

, _(*3)

Usage

When you use traceablePDO\PDO your statement looks like SELECT 1 /* eJxT0NdSKM7PTVUoKUpMTlUoLinKzEtX0NIHAF05B60= */ so to get trace you should just enter in your terminal php -r 'echo gzuncompress(base64_decode("eJxT0NdSKM7PTVUoKUpMTlUoLinKzEtX0NIHAF05B60="));', _(*4)

Examples

Yii2

config/main.php, _(*5)

...
    'db' => [
        'class' => yii\db\Connection::class,
        'dsn' => 'mysql:host=localhost;dbname=stay2',
        'username' => 'root',
        'password' => 'pass',
        'charset' => 'utf8',
        'pdoClass' => antonmarin\TraceablePDO\PDO::class, // this line adds traces
    ],
...