Laravel雄辩的显示查询日志 [英] Laravel Eloquent display query log

问题描述

use App\Order;

public function show(Order $order){

        $data = $order->all();
        return dd($order->getQueryLog());

有什么方法可以显示Eloquent在Laravel中建立的查询吗?

Is there any way to display the query built by Eloquent in Laravel?

我尝试了getQueryLog();，但是它不起作用

I tried getQueryLog(); but its not working

推荐答案

首先，您必须启用查询日志 可以使用

First you have to enable query log it can be done using

DB::connection()->enableQueryLog();

然后您可以使用以下代码查看查询日志

then you can use below code to see the query log

$queries = DB::getQueryLog();

如果您想查看最后执行的查询

if you want to see the last executed query

$last_query = end($queries);

要了解有关日志记录的更多信息，请参见此 https://laravel.com/docs/5.0 /database#query-logging

to know more about logging see this https://laravel.com/docs/5.0/database#query-logging

示例

public function show(Order $order){
        \DB::connection()->enableQueryLog();
        $data = $order->all();
        $queries = \DB::getQueryLog();
        return dd($queries);
}

这篇关于Laravel雄辩的显示查询日志的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！