/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

0 vote173 views4 answers
How to use sweetalert in laravel controller
PHP Laravel
1 vote185 views2 answers
Update checkbox value in laravel
PHP Laravel
7 votes182 views2 answers
Date time format for laravel validation
PHP Laravel
34 votes181 views6 answers
Laravel create controller with methods
PHP Laravel
4 votes173 views4 answers
Delete all rows from table laravel
PHP Laravel
3 votes173 views1 answer
Laravel policy create
PHP Laravel
0 vote162 views1 answer
Laravel, if ->get() array is not emtpy
PHP Laravel
0 vote170 views1 answer
Trying to access variable outside laravel collection
PHP Laravel
0 vote187 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
2 votes183 views1 answer
When image update laravel delete remove image
PHP Laravel