blocks|key|390827|text|对于Eloquent，你可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|390828|$result->getQuery()->toSql();|code-block|syntax|javascript|390829|但是您需要从查询中删除"->get()“部分。|390830|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For Eloquent you can just do:

<pre><code>$result-&gt;getQuery()-&gt;toSql();
</code></pre>

But you need to remove the "->get()" part from your query.

blocks|key|390781|text|对于Laraver+4来说|type|unstyled|depth|inlineStyleRanges|entityRanges|data|390782|DB::getQueryLog()|code-block|syntax|javascript|390783|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For Laraver 4 it's 

<pre><code>DB::getQueryLog()
</code></pre>

blocks|key|172774|text|这是一个快速的Javascript代码片段，您可以将其添加到母版页模板中。只要包含它，所有查询都将输出到浏览器的Javascript控制台。它将它们打印在一个易于阅读的列表中，使浏览您的站点和查看每个页面上执行的查询变得简单。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|172775|完成调试后，只需将其从模板中删除即可。|172776|<script+type="text/javascript">
++++var+queries+=+{{+json_encode(DB::getQueryLog())+}};
++++console.log('/******************************+Database+Queries+******************************/');
++++console.log('+');
++++queries.forEach(function(query)+{
++++++++console.log('+++'+%2B+query.time+%2B+'+%7C+'+%2B+query.query+%2B+'+%7C+'+%2B+query.bindings[0]);
++++});
++++console.log('+');
++++console.log('/******************************+End+Queries+***********************************/');
</script>|code-block|syntax|javascript|172777|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Here is a quick Javascript snippet you can throw onto your master page template.
As long as it's included, all queries will be output to your browser's Javascript Console.
It prints them in an easily readable list, making it simple to browse around your site and see what queries are executing on each page.

When you're done debugging, just remove it from your template.

<pre><code>&lt;script type="text/javascript"&gt;
 var queries = {{ json_encode(DB::getQueryLog()) }};
 console.log('/****************************** Database Queries ******************************/');
 console.log(' ');
 queries.forEach(function(query) {
 console.log(' ' + query.time + ' | ' + query.query + ' | ' + query.bindings[0]);
 });
 console.log(' ');
 console.log('/****************************** End Queries ***********************************/');
&lt;/script&gt;
</code></pre>

blocks|key|390879|text|使用查询日志不会给出实际执行的原始查询，特别是在有绑定值的情况下。这是获取原始sql的最佳方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|390880|DB::table('tablename')->toSql();|code-block|syntax|javascript|390881|或更多涉及：|390882|$query+=+Article::whereIn('author_id',+[1,2,3])->orderBy('published',+'desc')->toSql();
dd($query);|390883|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Using the query log doesnt give you the actual RAW query being executed, especially if there are bound values.
This is the best approach to get the raw sql:

<pre><code>DB::table('tablename')-&gt;toSql();
</code></pre>

or more involved:

<pre><code>$query = Article::whereIn('author_id', [1,2,3])-&gt;orderBy('published', 'desc')-&gt;toSql();
dd($query);
</code></pre>

blocks|key|391037|text|如果您使用的是Laravel+5，则需要在查询之前或中间件上插入以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|391038|\DB::enableQueryLog();|code-block|syntax|javascript|391039|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you are using Laravel 5 you need to insert this before query or on middleware :

<pre><code>\DB::enableQueryLog();
</code></pre>

blocks|key|390811|text|或者，作为laravel+3+profiler的替代方案，您可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|390812|https://github.com/paulboco/profiler或https://github.com/barryvdh/laravel-debugbar|offset|length|390813|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/paulboco/profiler|1|https://github.com/barryvdh/laravel-debugbar^0|0|0|10|0|11|18|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]|$D|U|E|V|1|W]]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]|N|$5|I|J|K|A|$L|O]]]]

Or as alternative to laravel 3 profiler you can use:

<a href="https://github.com/paulboco/profiler" rel="nofollow">https://github.com/paulboco/profiler</a>
or
<a href="https://github.com/barryvdh/laravel-debugbar" rel="nofollow">https://github.com/barryvdh/laravel-debugbar</a>

blocks|key|172848|text|在Laravel+4中，您实际上可以使用事件侦听器进行数据库查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|172849|Event::listen('illuminate.query',+function($sql,+$bindings)
{
++++foreach+($bindings+as+$val)+{
++++++++$sql+=+preg_replace('/\?/',+"'{$val}'",+$sql,+1);
++++}

++++Log::info($sql);
});|code-block|syntax|javascript|172850|将此代码段放在任何位置，例如start/global.php中。它会将查询写入信息日志(storage/log/laravel.log)。|offset|length|style|CODE|172851|entityMap^0|0|0|E|G|18|N|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

in Laravel 4 you can actually use an Event Listener for database queries.

<pre><code>Event::listen('illuminate.query', function($sql, $bindings)
{
 foreach ($bindings as $val) {
 $sql = preg_replace('/\?/', "'{$val}'", $sql, 1);
 }

 Log::info($sql);
});
</code></pre>

Place this snippet anywhere, e.g. in <code>start/global.php</code>. It'll write the queries to the info log (<code>storage/log/laravel.log</code>).

blocks|key|172932|text|Event::listen('illuminate.query',+function($sql,+$param)
{
++++\Log::info($sql+.+",+with["+.+join(',',+$param)+."] \n");
});|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|172933|将其放入global.php中，它将记录您的sql查询。|unstyled|172934|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>Event::listen('illuminate.query', function($sql, $param)
{
 \Log::info($sql . ", with[" . join(',', $param) ."]&lt;br&gt;\n");
});
</code></pre>

put it in global.php it will log your sql query.

blocks|key|391131|text|L4一行程序|type|unstyled|depth|inlineStyleRanges|entityRanges|data|391132|(写查询的)：|391133|$q=\DB::getQueryLog();dd(end($q));|offset|length|style|CODE|391134|entityMap^0|0|0|0|Y|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

<h1>L4 one-liner</h1>

(which write query): 

<code>$q=\DB::getQueryLog();dd(end($q));</code>

blocks|key|390946|text|Laravel+3|type|unstyled|depth|inlineStyleRanges|entityRanges|data|390947|另一种方法是：|390948|#config/database.php

'profiler'+=>+true|code-block|syntax|javascript|390949|对于所有查询结果：|390950|print_r(DB::profiler());|390951|对于最终结果：|390952|print_r(DB::last_query());|390953|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

<h1>Laravel 3</h1>
Another way to do this is:
<pre><code>#config/database.php

'profiler' =&gt; true
</code></pre>
For all Queries result:
<pre><code>print_r(DB::profiler());
</code></pre>
For last Result:
<pre><code>print_r(DB::last_query());
</code></pre>

blocks|key|173019|text|为了得到laravel中最后一次执行的查询，我们将使用laravel的DB::getQueryLog()函数，它将返回所有执行的查询。为了得到最后一个查询，我们将使用end()函数，该函数返回最后执行的查询。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|173020|$student+=+DB::table('student')->get();
$query+=+DB::getQueryLog();
$lastQuery+=+end($query);
print_r($lastQuery);|code-block|syntax|javascript|173021|我参考了http://www.tutsway.com/how-to-get-the-last-executed-query-in-laravel.php的内容。|173022|entityMap|0|LINK|mutability|MUTABLE|url|http://www.tutsway.com/how-to-get-the-last-executed-query-in-laravel.php^0|Z|H|2B|5|0|0|4|20|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@$9|11|A|12|1|13]]|E|$]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

To get the last executed query in laravel,We will use <code>DB::getQueryLog()</code> function of laravel it return all executed queries. To get last query we will use <code>end()</code> function which return last executed query.

<pre><code>$student = DB::table('student')-&gt;get();
$query = DB::getQueryLog();
$lastQuery = end($query);
print_r($lastQuery);
</code></pre>

I have taken reference from <a href="http://www.tutsway.com/how-to-get-the-last-executed-query-in-laravel.php" rel="nofollow">http://www.tutsway.com/how-to-get-the-last-executed-query-in-laravel.php</a>.

blocks|key|391092|text|有一种非常简单的方法可以做到这一点，从您的laravel查询只需重命名任何列名，它将显示您的查询错误。:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|391093|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

There is very easy way to do it, from your laravel query just rename any column name, it will show you an error with your query.. :)

How can I retrieve the raw executed SQL query in Laravel 3/4 using Laravel Query Builder or Eloquent ORM?

For example, something like this:

<pre><code>DB::table('users')-&gt;where_status(1)-&gt;get();
</code></pre>

Or:

<pre><code>(posts (id, user_id, ...))

User::find(1)-&gt;posts-&gt;get();
</code></pre>

Otherwise, at the very least how can I save all queries executed to laravel.log?

Get the Query Executed in Laravel 3/4

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如何使用Laravel query Builder或Eloquent ORM检索Laravel 3/4中的原始执行SQL查询？例如，如下所示：DB::table('users')->where_status(1)->get();或者：(posts (id, user_id, ...))User::find(1)->posts->get();否则，至少我如何将执行的所有查询保存到laravel.lo

问获取在Laravel 3/4中执行的查询
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问获取在Laravel 3/4中执行的查询EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问获取在Laravel 3/4中执行的查询
EN