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 vote233 views1 answer
Laravel sprintf span in controller
PHP Laravel
0 vote165 views1 answer
Php 3 months ago
PHP
2 votes193 views1 answer
You can also run `php --ini` in a terminal to see which files are used by PHP in CLI mode. Alternatively, you can run Composer with `--ignore-platform-req=ext-mb
PHP
1 vote187 views1 answer
Laravel model created_at format edit
PHP Laravel
0 vote212 views6 answers
The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.3.28 Server at localhost Port 80 error in laravel
PHP Laravel
51 votes170 views6 answers
Laravel make seeder
PHP
0 vote157 views1 answer
Php extensions for apache2
PHP
1 vote161 views1 answer
Laravel profile migration tool
PHP
0 vote175 views1 answer
Php insert hyphen into spaces in string
PHP
-1 vote194 views1 answer
Create new record via model in laravel
PHP