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

how get query logs in laravel

Method #1
instead of ->get use ->toSql() on query 
$users = User::orderBy('name', 'asc')->toSql();

echo $users;

// Outputs the string:
'select * from `users` order by `name` asc'
Method # 2

DB::enableQueryLog();

// and then you can get query log

dd(DB::getQueryLog());

query log laravel

import DB with this line first, 
use IlluminateSupportFacadesDB;

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