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

2 votes258 views1 answer
Check null in_array php
PHP
0 vote287 views1 answer
Implement class in autoloader athow to implment data table in laravel project
PHP Laravel
6 votes259 views6 answers
Remove duplicate values in array php
PHP
0 vote293 views1 answer
Laravel firstorcreate usage
PHP
3 votes261 views2 answers
Laravel longblob migration
PHP
0 vote253 views1 answer
Failed to open stream permission denied in php
PHP
0 vote210 views1 answer
Check custom post type post exists
PHP
0 vote327 views1 answer
Laravel 8 date difference in days
PHP Laravel
1 vote272 views1 answer
How to store an image in laravel directly from url
PHP
1 vote253 views3 answers
Php check if some string contains from array
PHP