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

1 vote164 views1 answer
Array_last in laravel 8
PHP
0 vote183 views1 answer
Multiplication des variables sur laravel
PHP Laravel
2 votes201 views2 answers
Laravel eloquent get all where in
PHP
1 vote147 views2 answers
Enable socket in php
PHP
0 vote194 views1 answer
Entrust laravel
PHP Laravel
0 vote160 views1 answer
Php regex markdown link
PHP
0 vote153 views1 answer
How to filter the all special characters in cakephp from an array
PHP
0 vote220 views1 answer
Taxonomy_get_parents drupal 8
PHP Drupal
2 votes148 views2 answers
Php delete directory
PHP
0 vote230 views2 answers
Phpmyadmin centos 8
PHP