Laravel中轻松输出完整的SQL语句

laravel

$ composer require guanguans/laravel-dump-sql -v
$ php artisan vendor:publish --provider="GuanguansLaravelDumpSqlServiceProvider"
// 获取 SQL User::where('id', 1)->toRawSql(); DB::table('user')->where('id', 1)->toRawSql();  // 打印 SQL User::where('id', 1)->dumpSql(); DB::table('user')->where('id', 1)->dumpSql();  // 打印 SQL 并退出 User::where('id', 1)->ddSql(); DB::table('user')->where('id', 1)->ddSql();
$ php artisan vendor:publish --tag=laravel-dump-sql
<?php return [     /*      * Get sql statement.      */     'to_raw_sql' => 'toRawSql',      /*      * Print SQL statements.      */     'dump_sql' => 'dumpSql',      /*      * Print SQL statements and exit.      */     'dd_sql' => 'ddSql', ];

© 版权声明
THE END
喜欢就支持一下吧
点赞5 分享