Laravel中輕松輸出完整的SQL語句

$ 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', ];