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 vote276 views2 answers
How set field after another field in migration in laravel
PHP
0 vote273 views1 answer
Php force array keys trim
PHP
1 vote287 views1 answer
Php parse html
PHP
19 votes333 views6 answers
Laravel query builder join
PHP Laravel
0 vote270 views1 answer
Php mod real numbers
PHP
0 vote410 views1 answer
Yii2 gridview action change urls
PHP Yii
0 vote262 views2 answers
Sorting sql query array by column key php
PHP
0 vote292 views1 answer
Replicating claims as headers is deprecated and will removed from v4.0. Please manually set the header if you need it replicated.",
PHP
0 vote267 views1 answer
Count cpt wp
PHP
12 votes275 views3 answers
For else laravel
PHP Laravel