title: WordPress administrators query
body: <p>I have a rather large user db on my WordPress database (around 1m).</p>
  <p>I am seeing a slow query on my log and it looks like this:</p>
  <pre><code>SELECT wp_users.ID,wp_users.user_login,wp_users.display_name FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND ( 
    ( 
      ( 
        ( wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%\&quot;edit\\_posts\&quot;%' ) 
        OR 
        ( wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%\&quot;administrator\&quot;%' ) 
        OR 
        ( wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%\&quot;editor\&quot;%' ) 
        OR 
        ( wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%\&quot;author\&quot;%' ) 
        OR 
        ( wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%\&quot;contributor\&quot;%' )
      )
    )
  ) ORDER BY display_name ASC;
  </code></pre>
  <p>I think it is made by <code>wp-includes/class-wp-user-query.php</code>. I feel like this is a query to populate some dropdown with all the administrator accounts, but for the life of me I cannot find out what triggers it.</p>
  <p>I want to find what is triggering it and stop it from executing this query. (Listing admins is not something I'm intending on using.</p>