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

0 vote266 views1 answer
PHP extension simplexml
PHP
1 vote252 views1 answer
Laravel routing controller get and post method
PHP
0 vote263 views1 answer
Php apply function to array elements
PHP
10 votes263 views4 answers
Get current date carbon laravel
PHP
5 votes256 views2 answers
16 digit random password generator php code without function
PHP
1 vote269 views1 answer
Laravel active route check
PHP Laravel
3 votes275 views4 answers
PHP executable not found. Install PHP 7 and add it to your PATH or set the php.executablePath setting
PHP
11 votes274 views5 answers
Laravel redirect back url with message
PHP Laravel
0 vote387 views1 answer
Inner pages not found yii
PHP Yii
20 votes270 views6 answers
Laravel validation types
PHP Laravel