title: Which index to add here?
body: <p>This query ends up in slow query log because join without index. Which index do I add and where? This simple query takes anywhere from 500ms to 1,2s. I guess it should easily complete within 100ms.</p>
  
  <pre><code>SELECT users.*, user_roles.apirequests, user_roles.downloadrequests, NOW() AS now
              FROM users
              INNER JOIN user_roles ON user_roles.id = users.role
              WHERE users.rsstoken =
              '775e155c780ed5af9119f797f814c714' LIMIT 1;
  </code></pre>
  
  <p>See query and show create tables: <a href="https://kopy.io/iCz1z" rel="nofollow noreferrer">https://kopy.io/iCz1z</a></p>