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

7 votes122 views1 answer
Rollback laravel transaction
PHP Laravel
2 votes122 views2 answers
Laravel abort with message
PHP Laravel
0 vote123 views1 answer
Laravel array to string error
PHP
1 vote108 views2 answers
Laravel get url parameter value in controller
PHP Laravel
0 vote99 views1 answer
Php array longest string
PHP
7 votes118 views1 answer
Laravel wher in
PHP Laravel
2 votes123 views2 answers
Laravel eloquent get all where in
PHP Laravel
0 vote105 views1 answer
Onesignal update device api
PHP
0 vote90 views2 answers
Sorting sql query array by column key php
PHP
0 vote139 views1 answer
Laravel parse markdown
PHP Laravel