Laravel SQL Log

AppServiceProvider.php

<?php
// Ajouter ce code dans boot()
if ($this->app->isLocal() && ($_SERVER['PHP_SELF'] ?? null) !== 'artisan') {
    $k = 0;
    \Illuminate\Support\Facades\DB::listen(function (\Illuminate\Database\Events\QueryExecuted $q) use (&$k) {
        $k++;
        file_put_contents('php://stdout', "[{$k}] \e[34m{$q->sql}\t\e[37m]".json_encode($q->bindings)."\t\e[32m{$q->time}ms\e[0m\n");
    });
}