<ul><li>Removed 154 synchronous external HTTP calls to analyze.tools API from page load — <code>curlAnalyzeTools()</code> was called once per domain in a blocking loop with no timeout; result was stored in <code>has_analytics</code> which was only used in commented-out code — pure dead weight causing 77-308s load time (CRITICAL)</li><li>Fixed N+1: <code>domain_names_type</code> queried once per row (154 queries for a 7-row table) — replaced with pre-cached array keyed by id; now 1 query total (HIGH)</li><li>Fixed N+1: <code>domain_names_status</code> queried once per row (154 queries for a 10-row table) — replaced with pre-cached array keyed by domstatusid; now 1 query total (HIGH)</li><li>Fixed N+1: <code>acctDetails()</code> called once per row making 2 DB queries each (308 queries) — replaced with pre-cached owner names array built from unique owner_ids before render loop (HIGH)</li><li>File: <code>platform/services/domains/inc/page/domains.php</code> — total query count on page load reduced from ~620 to 4</li></ul>