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());

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 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);
}

laravel log query for model (full)

namespace AppProviders;

use DB;
use Log;
use IlluminateSupportServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        DB::listen(function($query) {
            Log::info(
                $query->sql,
                $query->bindings,
                $query->time
            );
        });
    }

    // ...
}

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