antonmarin / traceable-pdo
此包已被弃用,不再维护。未建议替代包。
PDO包装器,可实时跟踪语句来源以分析慢SQL语句
2.1.0
2019-12-31 04:26 UTC
Requires
- php: ^5.6 || ^7.0
- ext-pdo: *
- ext-zlib: *
Requires (Dev)
- ext-pdo_sqlite: *
- codeclimate/php-test-reporter: ^0.4.1
- phpunit/phpunit: ^5.7
This package is auto-updated.
Last update: 2024-01-29 01:19:22 UTC
README
为您的SQL语句添加跟踪
用法
当您使用 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 ], ...