PHP

How to Log Query in Laravel

DB::enableQueryLog();
$arr_user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());

How to Log Query in Laravel

DB::enableQueryLog();
$user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());

laravel enable query log

use IlluminateSupportFacadesDB;
...
...
 
public function UserController()
{
    DB::enableQueryLog();
    $arr_user = DB::table('users')->select('name', 'email as user_email')->get();
    dd(DB::getQueryLog());
}

laravel log query for model

public function show(Order $order){
    DB::connection()->enableQueryLog();
    $data = $order->all();
    $queries = DB::getQueryLog();
    return dd($queries);
}

query log laravel

import DB with this line first, 
use IlluminateSupportFacadesDB;

laravel enable query log

DB::connection()->enableQueryLog();

query log laravel

check whethe the serviceprovider is added in the providers array in config/app.php
 if no then check whether the service provider class is the correct location and 
   include the serivce provider in the providers array in config.app.php
   

query log laravel

check whethe the serviceprovider is added in the providers array in config/app.php
 if no then check whether the service provider class is the correct location and 
   include the serivce provider in the providers array in config.app.php
   

larave log all query

DB::listen(function ($query) {
    var_dump([
        $query->sql,
        $query->bindings,
        $query->time
    ]);
});