在 laravel 中轻松容易的输出完整的 sql 语句

$ composer require guanguans/laravel-dump-sql -vCopy

$app->register(\Guanguans\LaravelDumpSql\ServiceProvider::class);Copy

$ php artisan server:dump-sqlCopy

$sql = User::query()->where('id', 1)->toRawSql();
dd($sql);Copy

"select * from `xb_users` where `id` = 1"Copy

User::query()->where('id', 1)->dumpSql();
User::query()->where('id', 2)->dumpSql();Copy

"select * from `xb_users` where `id` = 1"
"select * from `xb_users` where `id` = 2"Copy

User::query()->where('id', 1)->ddSql();
User::query()->where('id', 2)->ddSql();Copy

"select * from `xb_users` where `id` = 1"Copy

User::query()->where('id', 1)->logListenedSql()->first();
User::query()->where('id', 2)->first();Copy

# 日志中
[Laravel] [39.97ms] select * from `xb_users` where `id` = '1' limit 1 | GET: /
[Laravel] [39.93ms] select * from `xb_users` where `id` = '2' limit 1 | GET: /Copy

User::query()->where('id', 1)->dumpListenedSql()->first();
User::query()->where('id', 2)->first();Copy

[Laravel] [39.97ms] select * from `xb_users` where `id` = '1' limit 1 | GET: /
[Laravel] [39.93ms] select * from `xb_users` where `id` = '2' limit 1 | GET: /Copy

User::query()->where('id', 1)->ddListenedSql()->first();
User::query()->where('id', 2)->first();Copy

[Laravel] [39.97ms] select * from `xb_users` where `id` = '1' limit 1 | GET: /Copy