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

18 votes150 views4 answers
Protected table laravel
PHP Laravel
2 votes137 views1 answer
Redirect on validation error laravel to specific section laravel
PHP Laravel
1 vote133 views2 answers
How to make a child theme in wordpress
PHP
6 votes116 views3 answers
Laravel ide-helper
PHP
0 vote87 views1 answer
Can't see php7 in my mac
PHP
0 vote167 views2 answers
How to insert last id from crud grocery codeigniter
PHP CodeIgniter
1 vote127 views1 answer
Npm watch laravel
PHP
0 vote159 views1 answer
Php remove all but numbers
PHP
4 votes122 views4 answers
Laravel carbon today date format
PHP
8 votes142 views3 answers
Php join
PHP