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

1 vote129 views2 answers
How console log laravel
PHP
1 vote141 views1 answer
Select selected fields in laravel join
PHP
0 vote143 views1 answer
Php empy a file
PHP
36 votes145 views6 answers
Laravel 8 foreign key migration
PHP Laravel
4 votes136 views2 answers
Php get browser
PHP
0 vote176 views1 answer
Form submitting is not working in php
PHP
1 vote158 views3 answers
Laravel multiple paginate
PHP Laravel
0 vote136 views1 answer
Combine 2 columns search query laravel
PHP
-1 vote89 views1 answer
Laravel edit form select don't repeat a selected value
PHP
11 votes149 views2 answers
How login one user with id in laravel
PHP