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 vote113 views2 answers
Laravel login register api
PHP
1 vote99 views1 answer
Disabling Caching of Queries Laravel Model Cache
PHP
0 vote133 views1 answer
Laravel Google Line Chart
PHP Laravel
4 votes99 views4 answers
Nginx codeigniter remove index.php
PHP
1 vote129 views1 answer
Laravel redirect external url
PHP Laravel
2 votes103 views1 answer
Create migration, controller, model and seeder laravel
PHP
4 votes107 views1 answer
Convert a value to a float in php
PHP
1 vote115 views2 answers
Laravel middleware in constructor
PHP
4 votes128 views4 answers
Laravel sum relationship column
PHP Laravel
47 votes136 views6 answers
How to add new column in laravel migration
PHP Laravel