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

3 votes109 views3 answers
Php print array nice format
PHP
0 vote121 views2 answers
Laravel set middleware default
PHP Laravel
0 vote102 views2 answers
Laravel insert multiple rows from form
PHP
2 votes122 views1 answer
The $cfg['TempDir'] (/usr/share/phpmyadmin/tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.
PHP
13 votes122 views6 answers
Find auth laravel
PHP Laravel
4 votes107 views3 answers
Laravel cmd command to watch logs
PHP
0 vote111 views1 answer
How to create header in csv file inphp
PHP
1 vote144 views2 answers
DeleteAll cakephp 2
PHP
13 votes140 views3 answers
Laravel password encryption
PHP Laravel
1 vote102 views1 answer
Npm watch laravel
PHP