/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

9 votes206 views5 answers
Return view with variable laravel
PHP Laravel
2 votes195 views3 answers
For each loop syntax in laravel
PHP Laravel
0 vote214 views3 answers
Laravel echo
PHP Laravel
11 votes212 views3 answers
Laravel get last month records
PHP Laravel
0 vote225 views1 answer
Laravel relationship retrieve data
PHP Laravel
4 votes212 views2 answers
On update current timestamp laravel migration
PHP Laravel
16 votes253 views5 answers
Get user auth in laravel
PHP Laravel
13 votes218 views2 answers
Laravel turn off timestamps
PHP Laravel
6 votes230 views4 answers
Laravel base url
PHP Laravel
0 vote200 views1 answer
String length laravel validation
PHP Laravel