library query-tracer

fitztrev/query-tracer

Backtrace database queries

Laravel Query Tracer

, _(*1)

Find exactly where a specific database query is being called in your Laravel application., _(*2)

Want to optimize or debug your database queries but not sure where they're being called? See how it works below with Clockwork:, _(*3)

, _(*4)

If you use Debugbar, it has this functionality built-in if you set debugbar.options.db.backtrace to true., _(*5)

Installation

1. Install via composer:, _(*6)

   composer require fitztrev/query-tracer
   

2. Add the service provider to your config/app.php:, _(*7)

   'providers' => [
       // ...
       Fitztrev\QueryTracer\Providers\QueryTracerServiceProvider::class,
   ],
   

How does it do it?

It makes use of Laravel's global query scopes to do a backtrace and find where a query originated. Then it puts that info in extraneous but helpful WHERE clauses., _(*8)

By default, it's only enabled when debug is on. You can change this behavior for specific models by adding an enableQueryTracer() method to your model(s). For example:, _(*9)

public function enableQueryTracer()
{
    return config('app.env') == 'local';
}