/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

13 votes116 views6 answers
Route group in laravel
PHP Laravel
4 votes127 views3 answers
Laravel on delete set null
PHP Laravel
8 votes100 views1 answer
Laravel link storage to public
PHP Laravel
0 vote119 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
15 votes117 views3 answers
How to install bootstrap in laravel 8 with auth
PHP Laravel
1 vote119 views2 answers
How add field to table by another migration in laravel
PHP Laravel
2 votes111 views2 answers
Get all sort by laravel
PHP Laravel
29 votes167 views3 answers
Seed date laravel
PHP Laravel
8 votes124 views4 answers
Laravel model soft delete
PHP Laravel
1 vote132 views1 answer
Laravel migration add datetime column with default
PHP Laravel