title: Long query time
body: <p>I have a query to post last 10 tv show episodes by sorting it by date (from newest to oldest) like this:</p>
  
  <pre><code>return $this-&gt;getEntityManager()-&gt;createQuery('SELECT t FROM AppBundle:TvShow t JOIN t.episodes e ORDER BY e.date DESC')-&gt;setFirstResult(0)-&gt;setMaxResults(10)-&gt;getResult();
  </code></pre>
  
  <p>It returns only 9 nine episode. We have similar queries in same page too, they are working fine. When i setMaxResults to (11) just then it returns 10 episodes. </p>
  
  <p>Another issue related with this query is: it takes too long compared to other similar queries. (about 200ms) </p>
  
  <p>What do you suggest for me?</p>
  
  <p>Thanks in advance.</p>