title: How can I improve the performance of this MySQL INNER JOIN?
body: <p>I have the following mysql query</p>
  
  <pre><code>SELECT p. *
  FROM posts AS p
  INNER JOIN followings AS f ON p.id_user = f.id_user
  WHERE 
  f.id_me =(my id)
  ORDER BY id LIMIT 11
  </code></pre>
  
  <p>I have indexes for:</p>
  
  <ul>
  <li><code>id_user</code> in the <code>posts</code> table</li>
  <li><code>id_user, id_me</code> in the <code>followings</code> table.</li>
  </ul>
  
  <p>100K rows in the <code>followings</code> table, 30K rows in the <code>posts</code> table.</p>
  
  <p>My question is it takes more than 1 second, is it possible to write this query that takes a few milliseconds?</p>