Laravel — Logging Query Events

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Database\Events\QueryExecuted;

private function queryListener(): void
{
DB::listen(function (QueryExecuted $q) {
File::append(
storage_path('/logs/query.log'),
$q->sql.' ['.implode(', ', $q->bindings).']'.PHP_EOL
);
});
}

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store