php - Laravel Eloquent display query log

Question

use AppOrder;

public function show(Order $order){

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

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

I tried getQueryLog(); but its not working

question from:https://stackoverflow.com/questions/41140975/laravel-eloquent-display-query-log

Answer 1

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);

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

Example

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