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

2 votes152 views3 answers
Ajax post json data handle in php
PHP
38 votes126 views6 answers
Create table laravel
PHP
0 vote153 views1 answer
Take 10 skip 10 laravel
PHP Laravel
0 vote152 views1 answer
Laravel collection flatMap
PHP Laravel
2 votes131 views2 answers
Wp is user admin
PHP
1 vote163 views1 answer
How to get current location in laravel
PHP Laravel
0 vote135 views1 answer
Ile_put_contents(/opt/bitnami/apache2/htdocs/bootstrap/cache/services.php): failed to open stream: Permission denied
PHP
7 votes140 views2 answers
Php clone
PHP
0 vote136 views1 answer
Laravel factory relationship one to many
PHP
7 votes129 views4 answers
Php sort by associative array value
PHP