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 votes285 views1 answer
Laravel eloquent increment
PHP Laravel
0 vote267 views1 answer
The post function wordpress
PHP Wordpress
0 vote220 views2 answers
Percentage in php
PHP
3 votes281 views6 answers
Jwt for Laravel
PHP
1 vote246 views3 answers
Laravel invoice toturial
PHP
0 vote236 views1 answer
Laravel inverse one to many relationship
PHP
-1 vote234 views1 answer
Change the php version in linux
PHP
17 votes240 views2 answers
Find type in php
PHP
0 vote255 views1 answer
Symfony 5 - Customize Twig error templates
PHP Symfony
5 votes286 views5 answers
Unique laravel migration
PHP Laravel