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 vote308 views3 answers
CONTACT FORM SQL
PHP
6 votes327 views2 answers
Login selected user laravel
PHP Laravel
0 vote311 views1 answer
Js unserialize
PHP
1 vote338 views1 answer
How to create controler in laravel
PHP Laravel
0 vote271 views1 answer
Laravel 2 queries similar reuse code
PHP Laravel
3 votes303 views1 answer
Line : 83 -- syntax error, unexpected end of file php
PHP
4 votes391 views2 answers
Validate year laravel
PHP Laravel
6 votes308 views5 answers
Php new object
PHP
10 votes308 views3 answers
Php define object
PHP
0 vote290 views1 answer
SQLSTATE[22023]: Invalid parameter value:
PHP