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

5 votes264 views2 answers
Laravel mail send
PHP Laravel
0 vote189 views1 answer
Laravel controller constructor auth user null
PHP
1 vote225 views1 answer
How match array in laravel collection
PHP Laravel
7 votes219 views2 answers
String compare in php
PHP
6 votes177 views3 answers
Laravel ecommerce
PHP
1 vote182 views1 answer
Php for each schleife
PHP
3 votes246 views4 answers
Laravel where has Relation
PHP Laravel
48 votes276 views5 answers
Laravel clear route cache
PHP Laravel
0 vote201 views1 answer
Doctrine getrepository findby
PHP
50 votes179 views6 answers
Php string to array
PHP