osTicket queue loads extremely slowly with 40+ second MySQL queries containing hundreds of REGEXP operations when many custom queues exist.

Patch include/class.search.php to replace the single mega-query approach with individual per-queue counts. Replace the try/catch block at line ~990 that calls $query->values()->one() with: foreach ($queues as $q) $counts['q'.$q->getId()] = $q->getTotal(); This removes the REGEXP-heavy combined COUNT query entirely. On v1.18.3 use $q->getTotal($agent) if counts appear wrong. Update to v1.18.3 which includes related performance improvements.