@php
// All status counts in one query instead of two per status
$statusCounts = \App\Support\Ticket::fromCurrentUser()->selectRaw('status_code, count(*) as amount')->groupBy('status_code')->pluck('amount', 'status_code');
@endphp
@foreach(\App\Support\Ticket::STATUS_NAMES as $id => $name)