/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

8 votes187 views6 answers
Laravel collection sum
PHP Laravel
0 vote198 views1 answer
Laravel Code To Rename file on server in the storage folder
PHP Laravel
0 vote245 views5 answers
Laravel tricks and tips
PHP Laravel
12 votes188 views6 answers
Laravel validation
PHP Laravel
0 vote193 views2 answers
Carbon Format date with timezone in views Laravel
PHP Laravel
2 votes188 views1 answer
Laravel delete route
PHP Laravel
6 votes200 views3 answers
Laravel blade route redirect back
PHP Laravel
5 votes191 views6 answers
Laravel sort collection
PHP Laravel
0 vote203 views1 answer
Get All dates of a month with laravel carbon
PHP Laravel
0 vote205 views1 answer
Sort by number of views descending laravel
PHP Laravel