Very Simple SQL Dump In Laravel
Very Simple SQL Dump In Laravel
Sometimes when you're working on a specific feature, or maybe a specific page of your website, or even a unit test, you're wondering about the SQL queries that are executed.
Laravel Eloquent is great and all but it can be difficult to clearly see what query is executed. This is very important because it might help you to greatly improve the performance of your application.
A very simple way to display every request is possible through this small snippet.
DB::listen(function ($query) {
dump($query->sql);
});You can just paste this snippet at the top of your script and you're good to go!
This will obviously dump the query out on the page. You can choose to dump it on you terminal with beyondcode/laravel-dump-server
Another way would be to write all of that in your log file with the info() helper like this:
DB::listen(function ($query) {
info($query->sql);
});Happy debugging !
about me
I consider myself as an IT Business Artisan. Or Consultant CTO. I'm a self-taught Web Developper, coach and teacher. My main work is helping and guiding digital startups.
more about mesupport my work
-
BTC
18SY81ejLGFuJ9KMWQu5zPrDGuR5rDiauM
-
ETH
0x68e8c828b8ce670062a83199cd8f62667c792f23
-
XMR
895bSneY4eoZjsr2hN2CAALkUrMExHEV5Pbg8TJb6ejnMLN7js1gLAXQySqbSbfzjWHQpQhQpvFtojbkdZQZmM9qCFz7BXU
popular posts
Laravel 5 And His F*cking non-persistent App SetLocale
Simple Like System with Laravel 5
categories
recent posts
What is a Service Container / IoC Container in PHP ?
Recette Bolognaise Tomates Fraiches
Simple yet powerful search mixins for vuejs
Gitweet.io is now open source !
What the Hell is Callback Hell in Javascript ?
2021 My Dynamic Production SPRL All rights Reserved.