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

34 votes123 views2 answers
Add a new column to existing table in a migration
PHP
0 vote113 views1 answer
Php octal to decimal
PHP
1 vote120 views1 answer
Use model from variable laravel
PHP
0 vote131 views1 answer
Laravel move/rename file ftp
PHP Laravel
0 vote117 views3 answers
Old codestar checkbox field
PHP
1 vote119 views1 answer
Php close session
PHP
0 vote156 views1 answer
Laravel new line in language file
PHP Laravel
11 votes124 views4 answers
Redirect back with input laravel in request
PHP
7 votes117 views3 answers
Try catch php
PHP
1 vote116 views1 answer
What is app_env in laravel
PHP