Context Navigation

Changes between Initial Version and Version 1 of Ticket #31072, comment 3

initial	v1
16	16	}}}
17	17
18		This query runs for every page that displays the admin top bar and, in one of my sites which has about ~~70k comments, it takes +5 seconds. Adding the index below makes the query run in 1.7~~ seconds, which is still slow but much better.
	18	This query runs for every page that displays the admin top bar and, in one of my sites which has about 2.5 million comments (most of them are of custom WooCommerce comment type called 'order_note'), it takes +5 seconds. Adding the index below makes the query run in 0.3 seconds, which is still slow but much better.
19	19
20	20	{{{#!sql