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 vote220 views3 answers
Laravel model where in
PHP Laravel
7 votes308 views3 answers
How to create wordpress shortcodes
PHP Wordpress
12 votes212 views2 answers
Include and require in php
PHP
2 votes235 views3 answers
Kill phpstorm process ubuntu
PHP
16 votes195 views6 answers
Session laravel
PHP
0 vote258 views1 answer
Php for next loop step
PHP
2 votes212 views2 answers
Add two numbers in php
PHP
-1 vote250 views1 answer
Laravel merge two arrays helper
PHP Laravel
1 vote198 views2 answers
Insert data to table in wordpress 2
PHP
0 vote222 views1 answer
Php array remove value if exists
PHP