/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

2 votes221 views1 answer
Check if value is not null in db laravel
PHP Laravel
10 votes209 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel
0 vote194 views3 answers
Laravel package console command
PHP Laravel
10 votes203 views4 answers
In random order laravel
PHP Laravel
1 vote202 views4 answers
Create json laravel
PHP Laravel
0 vote229 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP Laravel
0 vote183 views1 answer
Lazy loading in laravel
PHP Laravel
0 vote228 views1 answer
Check Data Load More Laravel Livewire
PHP Laravel
0 vote226 views1 answer
Multiple databases user validation in Laravel
PHP Laravel
5 votes193 views2 answers
Current loggedin user laravel
PHP Laravel