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

7 votes357 views2 answers
Prevent SQL injection in PHP?
PHP
0 vote416 views1 answer
Allow json uploads in Wordpress
PHP Wordpress
0 vote336 views1 answer
Unknown column type "double" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType
PHP
1 vote320 views1 answer
Twig replace char in string
PHP
2 votes320 views1 answer
Gd extension docker php
PHP
0 vote325 views1 answer
Bcmath php extension in ubuntu
PHP
5 votes357 views1 answer
Php add element to array first position
PHP
0 vote321 views1 answer
Debugbar:clear in laravel
PHP
0 vote328 views2 answers
Laravel allow all fillable
PHP
1 vote355 views1 answer
Php déclarer une constante URL
PHP