Slow query in admin dashboard after update to 2.6.7

Hello, after updating to v2.6.7 there is a slow query that runs on every page of the WordPress admin dashboard (see below). It appears this query is related to counting users on the new UM -> Settings -> Secure page, so is there any reason this query needs to run on every admin page and not just that specific page? As you can imagine with lots of users, running this query on every page significantly slows down page load time within the admin dashboard.

SELECT?COUNT(NULLIF(meta_value?LIKE?‘%\”administrator\”%’, false)), COUNT(NULLIF(meta_value?LIKE?‘%\”author\”%’, false)), COUNT(NULLIF(meta_value?LIKE?‘%\”contributor\”%’, false)), COUNT(NULLIF(meta_value?LIKE?‘%\”editor\”%’, false)), COUNT(NULLIF(meta_value?LIKE?‘%\”subscriber\”%’, false)), COUNT(NULLIF(meta_value?LIKE?‘%\”wpseo\\_manager\”%’, false)), COUNT(NULLIF(meta_value?LIKE?‘%\”wpseo\\_editor\”%’, false)), COUNT(NULLIF(meta_value = ‘a:0:{}’, false)), COUNT(*)
FROM?wp_usermeta
INNER?JOIN?wp_users
ON?user_id = ID
WHERE?meta_key = ‘wp_capabilities’

• This topic was modified 1 year, 7 months ago by jasnon.