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

5 votes185 views1 answer
Limit 1 1 in laravel query
PHP Laravel
14 votes130 views2 answers
Php 3 digit decimal
PHP
0 vote160 views1 answer
Php define variable type
PHP
-2 votes128 views4 answers
Laravel get ID from insert
PHP
0 vote111 views1 answer
How to display category and subcategory list
PHP
0 vote145 views1 answer
Messagebird php curl send sms example
PHP
0 vote143 views1 answer
Php zeilenumbruch
PHP
0 vote158 views2 answers
How to delete empty rows in phpmyadmin
PHP
1 vote135 views1 answer
Close mysql connection in php
PHP
1 vote140 views5 answers
Check if value change laravel
PHP