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 vote105 views1 answer
Acf get sub field
PHP
5 votes148 views5 answers
Unique laravel migration
PHP Laravel
1 vote140 views1 answer
Image dimension when uploading in laravel validation
PHP Laravel
3 votes129 views3 answers
Php copy array
PHP
0 vote134 views2 answers
Mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
PHP
9 votes124 views4 answers
Laravel time format
PHP
0 vote135 views1 answer
Check website ssl certificate using php openssl_x509_parse
PHP
2 votes101 views1 answer
Redirect from controller in laravel
PHP
4 votes132 views5 answers
Laravel storage
PHP Laravel
1 vote109 views1 answer
Convert Carbon Seconds Into Days Hours Minute
PHP