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

1 vote129 views1 answer
Php create object without clas
PHP
7 votes133 views3 answers
Laravel creat new model
PHP
-2 votes124 views3 answers
SQLSTATE[42S02] lumen
PHP
0 vote138 views1 answer
Woocommerce php reset password length
PHP
0 vote161 views1 answer
Php collapse common columns in associative array
PHP
4 votes129 views2 answers
Php $randomUA[rand(0, count($randomUA) 1)
PHP
2 votes118 views1 answer
Redirect on validation error laravel to specific section laravel
PHP
3 votes174 views2 answers
Wp do sql query from function
PHP
1 vote151 views1 answer
Searching and removing element from an array php
PHP
2 votes196 views3 answers
Create new user fortify action how it work laravel 8
PHP Laravel