antonmarin/traceable-pdo

此包已被弃用,不再维护。未建议替代包。

PDO包装器,可实时跟踪语句来源以分析慢SQL语句

2.1.0 2019-12-31 04:26 UTC

This package is auto-updated.

Last update: 2024-01-29 01:19:22 UTC


README

为您的SQL语句添加跟踪

Build Status Latest Stable Version License

Code Climate Test Coverage Total Downloads

用法

当您使用 traceablePDO\PDO 时,您的语句看起来像 SELECT 1 /* eJxT0NdSKM7PTVUoKUpMTlUoLinKzEtX0NIHAF05B60= */,要获取跟踪信息,您只需在终端中输入 php -r 'echo gzuncompress(base64_decode("eJxT0NdSKM7PTVUoKUpMTlUoLinKzEtX0NIHAF05B60="));'

示例

Yii2

config/main.php

...
    '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
    ],
...