Laravel log query for model

How to Log Query in Laravel

DB::enableQueryLog();
$arr_user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());

Source: artisansweb.net

Eloquent get query log

 DB::connection()->enableQueryLog(); //enable query log
 $data = $order->all(); //query execute
 $queries = DB::getQueryLog(); //get query
 return dd($queries); //show query

Laravel log query for model

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

Source: stackoverflow.com

Similar codes

0 vote144 views1 answer
Get data from csv file in php and print in table
PHP
3 votes146 views2 answers
Laravel find by field
PHP
1 vote175 views1 answer
Laravel session add array
PHP Laravel
0 vote189 views1 answer
Meyfa/phpunit-assert-gd[v2.0.0, ..., v2.x-dev, v3.0.0] require ext-gd * -> it is missing from your system. Install or enable PHP's gd extension
PHP
1 vote170 views1 answer
How to set a validation on a value if its not null in laravel php
PHP
1 vote131 views1 answer
Php explode trim
PHP
0 vote136 views1 answer
Call to undefined function App\Models\str_slug()
PHP
0 vote129 views1 answer
How-to-generate-an-xlsx-using-php
PHP
3 votes147 views1 answer
Laravel eloquent increment
PHP Laravel
7 votes153 views6 answers
Get params from url php
PHP