/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 vote129 views1 answer
Laravel eloquent get x number of results
PHP Laravel
15 votes144 views6 answers
Laravel migration delete column
PHP Laravel
37 votes146 views6 answers
Laravel order by
PHP Laravel
1 vote139 views2 answers
Laravel check if object empty
PHP Laravel
0 vote122 views4 answers
Error": "Trying to get property 'id' of non-object" in laravel
PHP Laravel
0 vote141 views1 answer
Laravel migration add contraint to other database
PHP Laravel
8 votes130 views3 answers
Storage link laravel
PHP Laravel
0 vote178 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
0 vote234 views1 answer
Laravel find or fail exception
PHP Laravel
8 votes129 views1 answer
Laravel custom attributes
PHP Laravel