Laravel Api profiling with duplication queries information.

ProfileJsonResponse.php

<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Http\JsonResponse;

class ProfileJsonResponse
{
    /**
     * Handle an incoming request.
     * Ref: https://github.com/barryvdh/laravel-debugbar/issues/252
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        $response = $next($request);

        if (
            $response instanceof JsonResponse &&
            app()->bound('debugbar') &&
            app('debugbar')->isEnabled() &&
            is_object($response->getData())
        ) {
            $debugData = app('debugbar')->getData();

            // Adding duplicated queries information.
            $statements = collect($debugData['queries']['statements']);
            // Dùng array_count_values có thể sẽ nhanh hơn.
            $duplicated_queries = $statements->groupBy(function ($statement) {
                return $statement['sql'];
            })->map(function ($queries, $sql) {
                return [
                    'sql'   => $sql,
                    'count' => count($queries),
                    'hint'  => 'Stop re-run same queries condition(Cache it by using php variable). Stop running queries in loop.'
                ];
            })->sortByDesc('count')->values();

            $debugData['queries']['duplication'] = $duplicated_queries;

            $response->setData($response->getData(true) + [
                    '_debugbar' => $debugData,
                ]);
        }

        return $response;
    }
}