Answered by : indian-gooner
DB::enableQueryLog();
$arr_user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());Source : https://artisansweb.net/how-to-log-query-in-laravel/ | Last Update : Wed, 06 May 20
Answered by : amit-rajput
DB::enableQueryLog();
$user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());Source : | Last Update : Thu, 14 Jan 21
Answered by : shafeeque-ahmad
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());Source : https://stackoverflow.com/questions/27753868/how-to-get-the-query-executed-in-laravel-5-dbgetquerylog-returning-empty-ar | Last Update : Tue, 07 Dec 21
Answered by : dfg
use Illuminate\Support\Facades\DB;
...
...
public function UserController()
{
DB::enableQueryLog();
$arr_user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());
}Source : https://artisansweb.net/how-to-log-query-in-laravel/ | Last Update : Wed, 27 Jul 22
Answered by : tough-turkey-wg8gm7zwzto8
public function show(Order $order){ \DB::connection()->enableQueryLog(); $data = $order->all(); $queries = \DB::getQueryLog(); return dd($queries);
}Source : https://stackoverflow.com/questions/41140975/laravel-eloquent-display-query-log | Last Update : Thu, 27 Jan 22
Answered by : kriss-sachintha
import DB with this line first,
use Illuminate\Support\Facades\DB;Source : | Last Update : Wed, 14 Sep 22
Answered by : tough-turkey-wg8gm7zwzto8
namespace App\Providers;
use DB;
use Log;
use Illuminate\Support\ServiceProvider;
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 ); }); } // ...
}Source : https://stackoverflow.com/questions/41140975/laravel-eloquent-display-query-log | Last Update : Thu, 27 Jan 22
Answered by : dfg
DB::connection()->enableQueryLog();Source : https://stackoverflow.com/questions/41140975/laravel-eloquent-display-query-log | Last Update : Wed, 27 Jul 22
Answered by : kriss-sachintha
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 Source : https://stackoverflow.com/questions/40695978/how-to-fix-service-provider-class-not-found-when-using-repository | Last Update : Wed, 14 Sep 22