Display Laravel queries in PHP files (like the DebugBar but without view)

Laravel - Get DB queries.php

<?php

/*
 * Display Laravel queries in PHP files (like the DebugBar but without view)
 */


/**
 * 1. Create the helper
 */
if (!function_exists('get_db_queries')) {
    /**
     * Get queries used in the $callback
     * 
     * @param  \Closure $callback             Method calling DB queries
     * @return Illuminate\Support\Collection  ['query binded', 'execution time']
     */
    function get_db_queries($callback)
    {
        $queries = collect();
        \DB::listen(function ($query) use ($queries) {
            $queries->push([
                'query' => vsprintf(str_replace('?', '%s', $query->sql), collect($query->bindings)->map(function ($binding) {
                    return is_numeric($binding) ? $binding : "'{$binding}'";
                })->toArray()),
                'time' => $query->time
            ]);
        });

        $callback();

        return $queries;
    }
}

/**
 * 2. Call it anywhere (like Controller, etc)
 */
$queries = get_db_queries(function() use ($MyModel) {
    $MyModel->methodWithQueryCalls();
});

// Dump it
dd($queries);