/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

0 vote322 views1 answer
Laravel 404 not found not showing error
PHP Laravel
0 vote352 views1 answer
Cut pice of text in laravel
PHP Laravel
0 vote359 views1 answer
How to get local current time in laravel
PHP Laravel
0 vote314 views2 answers
Nested array in laravel
PHP Laravel
8 votes326 views1 answer
Get all routes laravel
PHP Laravel
0 vote331 views1 answer
Laravel select error
PHP Laravel
0 vote269 views1 answer
The Laravel installer requires PHP 7.3.0 or greater. Please use "composer create-project laravel/laravel" instead.
PHP Laravel
0 vote301 views1 answer
Laravel 8 blade get days and hours ago
PHP Laravel
1 vote327 views1 answer
Laravel 8 bootstrap pagination fix
PHP Laravel
1 vote291 views1 answer
Isset blade laravel
PHP Laravel