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 vote179 views2 answers
Sanitize form data php
PHP
0 vote211 views1 answer
Wordpress get user profile picture
PHP
2 votes147 views1 answer
Command to delete storage logs in laravel
PHP
7 votes191 views3 answers
Parsefloat php
PHP
15 votes196 views6 answers
Laravel db transaction
PHP
0 vote303 views1 answer
Download yii 1.1
PHP Yii
0 vote208 views1 answer
Laravel factory relationship one to many
PHP Laravel
0 vote165 views1 answer
Rest api php
PHP
0 vote165 views1 answer
Laravel 8 date difference in days
PHP
0 vote198 views1 answer
Refresh web route laravel
PHP Laravel