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

15 votes367 views4 answers
Php compare dates
PHP
2 votes312 views1 answer
Get the current route in laravel
PHP Laravel
18 votes291 views1 answer
Laravel migation error
PHP
1 vote328 views1 answer
Laravel update method resource
PHP Laravel
0 vote316 views1 answer
Php not display notice
PHP
0 vote345 views1 answer
Php post variables to another page with submit button php
PHP
0 vote350 views1 answer
Create auto image path folder in laravel 8
PHP Laravel
7 votes362 views6 answers
Get current route laravel
PHP Laravel
0 vote352 views1 answer
Delete an array in multidimensional array php
PHP
0 vote420 views1 answer
Laravel nova create user
PHP Laravel