laravel中内置的查询构造方法toSql得到的sql语句是不绑定条件参数的，类似这个select*fromuserswhereid=?，所以写了一个扩展包laravel-dump-sql来得到完整的sql陈述。源代码laravel-dump-sql-https://github.com/guanguans/...安装$composerrequireguanguans/laravel-dump-sql-vpublishservice$phpartisanvendor:publish--provider="Guangans\\LaravelDumpSql\\ServiceProvider"安装成功后，查询生成器会添加三个新方法：toRawSql、dumpSql和ddSql//GetSQLUser::where('id',1)->toRawSql();DB::table('user')->where('id',1)->toRawSql();//打印SQLUser::where('id',1)->dumpSql();DB::table('user')->where('id',1)->dumpSql();//打印SQL并退出User::where('id',1)->ddSql();DB::table('user')->where('id',1)->ddSql();自定义方法名发布配置文件$phpartisanvendor:publish--tag=laravel-dump-sqlconfig/dumpsql.php方法名可以在文件中配置'toRawSql',/**打印SQL语句。*/'dump_sql'=>'dumpSql',/**打印SQL语句并退出。*/'dd_sql'=>'ddSql',];
