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 vote180 views1 answer
Laravel get week dates
PHP
15 votes216 views4 answers
How to convert unix timestamp to date php
PHP
45 votes194 views5 answers
Add column migration laravel
PHP
1 vote178 views1 answer
How import the impliment countable php
PHP
5 votes208 views1 answer
Php 8.1 release date
PHP
0 vote189 views3 answers
Laravel - How to create custom configuration variables and access
PHP
15 votes211 views4 answers
Change existing migration laravel
PHP Laravel
46 votes239 views6 answers
Add new column in existing table in laravel migration
PHP Laravel
0 vote205 views1 answer
Php regex file extension
PHP
0 vote235 views1 answer
Install php extensions for magento 2
PHP