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 vote220 views1 answer
Cakephp extract array
PHP
0 vote261 views1 answer
Subdomain in laravel and xampp
PHP Laravel
4 votes216 views4 answers
Installing laravel 8
PHP
0 vote205 views1 answer
Php check if two arrays are equal
PHP
7 votes233 views6 answers
Laravel get url path
PHP Laravel
7 votes315 views5 answers
Codeigniter get last query
PHP CodeIgniter
0 vote259 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter
1 vote231 views1 answer
Npm watch laravel
PHP Laravel
11 votes223 views2 answers
Woocommerce get product id
PHP
49 votes197 views6 answers
Laravel migration add column to existing table
PHP