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 votes181 views2 answers
Laravel required if it meet some value from another field
PHP
4 votes173 views3 answers
Php define()
PHP
2 votes159 views1 answer
Php capital string
PHP
0 vote199 views1 answer
Yajra laravel datatables rawcolumn
PHP Laravel
9 votes198 views3 answers
Get env app url laravel
PHP
0 vote113 views2 answers
Php bytes to mb
PHP
0 vote219 views1 answer
Codeigniter remote queries very slow
PHP CodeIgniter
0 vote192 views1 answer
My laravel has no docker-composer.yml file
PHP Laravel
2 votes261 views2 answers
Open php.ini in ubuntu
PHP
0 vote170 views1 answer
Set cookie on button click JavaScript
PHP