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

0 vote170 views3 answers
Laravel load relationship
PHP
1 vote204 views3 answers
Laravel artisan command run in route
PHP Laravel
0 vote214 views1 answer
Php configuration in apache server 2.4
PHP
1 vote177 views3 answers
Calculate time difference php
PHP
0 vote254 views3 answers
CONTACT FORM SQL
PHP
25 votes210 views5 answers
Php get user ip address
PHP
4 votes226 views3 answers
Laravel on delete set null
PHP Laravel
2 votes214 views3 answers
Add data to the collection laravel
PHP Laravel
0 vote192 views2 answers
How to retrieve image from database in php mysqli
PHP
0 vote267 views1 answer
Get action name in yii2
PHP