/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 votes333 views1 answer
Laravel throw function
PHP Laravel
0 vote342 views1 answer
Laravel notification attach file
PHP Laravel
8 votes365 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
1 vote371 views4 answers
Create json laravel
PHP Laravel
0 vote342 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
2 votes309 views5 answers
Laravel drop table migration
PHP Laravel
2 votes382 views1 answer
Laravel 8 delete by id
PHP Laravel
13 votes382 views6 answers
Laravel api routes
PHP Laravel
0 vote361 views2 answers
Str lower laravel
PHP Laravel
6 votes316 views2 answers
Laravel migration make column nullable
PHP Laravel