/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

14 votes149 views5 answers
Laravel model tablename
PHP Laravel
0 vote140 views1 answer
How to get post by comment in laravel
PHP Laravel
19 votes157 views6 answers
Laravel logger
PHP Laravel
0 vote146 views1 answer
Laravel enable extensions on Ubuntu
PHP Laravel
20 votes163 views6 answers
Laravel 8 make:auth
PHP Laravel
0 vote135 views2 answers
Php artisan app:name in laravel 6
PHP Laravel
18 votes142 views6 answers
Install laravel auth
PHP Laravel
0 vote166 views1 answer
How use variable in string in laravel
PHP Laravel
1 vote160 views4 answers
Current url route laravel
PHP Laravel
0 vote139 views1 answer
Laravel faker title
PHP Laravel