如何获取查询生成器以字符串形式输出其原始SQL查询? [英] How Do I Get the Query Builder to Output Its Raw SQL Query as a String?
本文介绍了如何获取查询生成器以字符串形式输出其原始SQL查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
给出以下代码:
DB::table('users')->get();
我想获取上面的数据库查询构建器将生成的原始SQL查询字符串.在此示例中,该名称为SELECT * FROM users
.
I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users
.
我该怎么做?
推荐答案
要将最近一次运行的查询输出到屏幕上,可以使用以下方法:
To output to the screen the last queries ran you can use this:
DB::enableQueryLog(); // Enable query log
// Your Eloquent query executed by using get()
dd(DB::getQueryLog()); // Show results of log
我相信最近的查询将在数组的底部.
I believe the most recent queries will be at the bottom of the array.
您将看到类似的内容:
array(1) {
[0]=>
array(3) {
["query"]=>
string(21) "select * from "users""
["bindings"]=>
array(0) {
}
["time"]=>
string(4) "0.92"
}
}
(感谢 查看全文