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

3 votes211 views4 answers
Round() laravel
PHP Laravel
8 votes186 views2 answers
Laravel storage hard link
PHP
9 votes203 views3 answers
Laravel download
PHP Laravel
7 votes192 views3 answers
Array_intersect php
PHP
39 votes165 views6 answers
Foreign key laravel migration
PHP
0 vote255 views2 answers
Laravel livewire-datatable delete column pop up issue
PHP Laravel
0 vote211 views1 answer
Drupal 8 custom form image field
PHP Drupal
0 vote205 views1 answer
Converting php to codeigniter
PHP
1 vote374 views1 answer
Tutorial crud laravel VueJS
PHP Laravel
0 vote207 views1 answer
Id type laravel
PHP Laravel