Display executed queries in Laravel blade (counting duplicates)

queries.blade.php

@php
    // requires \DB::enableQueryLog(); to be executed for the query log is available
    $queries = array_count_values(array_column(\DB::getQueryLog(), 'query'));
    arsort($queries);
    echo "\n";
    foreach($queries as $query => $count) {
        echo sprintf("%s: %s\n", $count > 1 ? "<span style='color:red'>{$count}</span>" : $count, $query);            
    }
@endphp