如何让查询构建器将其原始 SQL 查询作为字符串输出? [英] How do I get the query builder to output its raw SQL query as a string?

问题描述

给定以下代码:

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"
  }
}

(感谢 Joshua 的 评论如下.)

(Thanks to Joshua's comment below.)

这篇关于如何让查询构建器将其原始 SQL 查询作为字符串输出?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！