Debug sql query in laravel

Laravel show debug query sql

// Debug SQL query
// app/Providers/AppServiceProvider.php
public function boot()
{
    //...

    $this->debugQueries();
}
protected function debugQueries()
{
    if (env('APP_DEBUG_QUERIES')) {
        DB::listen(function ($query) {
            error_log(
                "Query [$query->time ms]: $query->sql\n"
                . "Params: " . print_r($query->bindings, true)
            );
        });
    }
}

Source: grepper.com

Similar codes

3 votes240 views2 answers
Cannot create an instance of class viewmodel
PHP
1 vote271 views2 answers
Laravel observer get old value
PHP
5 votes224 views3 answers
Get users of specific role laravel role spatie
PHP
0 vote215 views2 answers
Old codestar textarea field
PHP
2 votes302 views1 answer
Laravel how to test email testing
PHP Laravel
1 vote221 views1 answer
How get the latest data in database in laravel
PHP
1 vote290 views1 answer
Laravel http retry
PHP
0 vote237 views2 answers
Laravel "query()->find"
PHP
0 vote226 views1 answer
Textarea autocomplete phpmyadmin style
PHP
0 vote237 views1 answer
Access to this resource on the server is denied laravel
PHP