/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

-1 vote311 views2 answers
Laravel 5.6 orderby
PHP Laravel
1 vote312 views1 answer
Trim laravel
PHP Laravel
0 vote431 views1 answer
How to retrieve data from database using select option in laravel
PHP Laravel
7 votes406 views4 answers
Many to many relationship laravel
PHP Laravel
0 vote347 views1 answer
Laravel collection mode
PHP Laravel
5 votes328 views4 answers
Laravel model wherein
PHP Laravel
1 vote352 views2 answers
Table has column laravel
PHP Laravel
7 votes380 views3 answers
How to remove public from url in laravel 8
PHP Laravel
1 vote375 views1 answer
Laravel eloquent get only field name
PHP Laravel
3 votes364 views1 answer
Laravel remove controller
PHP Laravel