Laravel Query Printer

An easy way to print queries in Laravel 🖨️

Example:

// Enable query log
\DB::enableQueryLog();

// Use whatever queries you want to debug:
User::where('email', '[email protected]')->where('verified', true)->first();
User::where('id', '<', '5')->get();

// See what the queries were executed
\QueryPrinter::printQueryLog();

Output without this package:

Output with this package:

Now you can simply copy and run this query, so you don't need to spend your time struggling with the bindings 🙌

How to install

composer require loburets/laravel-query-printer

If you use Laravel < 5.5 also add the alias to your config/app.php:

'QueryPrinter' => Loburets\LaravelQueryPrinter\Facade::class,

Usage

Use it with query builder before you run the query:

    // Build your query, but don't call ->first(), ->get() etc. So it is an instance of the Query Builder here:
    $query = \Model::where()->join()->etc();

    // Then you can print it and see what Laravel was going to execute:
    \QueryPrinter::print($query);

Or use it with query logs when you have already run the query:

    // Enable the Query log:
    \DB::enableQueryLog();

    // Do any actions which you want to be logged:
    $results = \Model::where()->join()->etc()->get();

    // Then you can print all the queries which were executed after you enabled the query log:
    \QueryPrinter::printQueryLog();