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

12 votes314 views5 answers
Php post
PHP
1 vote279 views1 answer
Php remove bom
PHP
0 vote284 views1 answer
How to get private images in s3 laravel
PHP
0 vote307 views4 answers
Share var in a maser layout laravel
PHP Laravel
3 votes310 views1 answer
Events.js:174 error discord.js
PHP
0 vote343 views1 answer
Converting php to codeigniter
PHP CodeIgniter
20 votes280 views3 answers
Php file exist
PHP
1 vote475 views1 answer
Sort relation model count yii2
PHP Yii
1 vote342 views1 answer
Laravel 6 make http request
PHP Laravel
5 votes270 views3 answers
Remove html from string php
PHP