/PHP/Laravel/Laravel log query for model

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

3 votes287 views2 answers
Laravel collection find duplicates
PHP Laravel
36 votes274 views6 answers
Laravel 8 foreign key migration
PHP Laravel
0 vote321 views1 answer
Flash message laravel for incorrect password
PHP Laravel
0 vote308 views1 answer
How to add page link in laravel
PHP Laravel
10 votes314 views2 answers
Array to string conversion in laravel controller
PHP Laravel
6 votes281 views2 answers
Disable laravel debugbar
PHP Laravel
3 votes266 views2 answers
Using laravel back function on blade
PHP Laravel
0 vote282 views1 answer
Laravel collection times
PHP Laravel
6 votes316 views6 answers
Composer install laravel
PHP Laravel
14 votes301 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel