title: Doctrine queries take over 4 seconds to execute
body: <p>We're in the last stage of a project and started optimizing it.</p>
  
  <p>After a few tests, we realized that most (if not all) of the time spent loading a page, is spent in Doctrine.</p>
  
  <p>Out of 5 seconds page load, 3 - 4 seconds are spent only on 2 Doctrine queries.</p>
  
  <p>We've enabled query cache on the mysql server and on Doctrine as well as result cache, but this only seems to make the load times worse.</p>
  
  <p>As far as I can gather, the mysql query cache is active:</p>
  
  <p>[edit] for some reason the rest of my question has vanished so I am posting it again[/edit]</p>
  
  <p>Qcache_free_blocks      | 57<br>
   Qcache_free_memory      | 22300072<br>
   Qcache_hits             | 7117<br>
   Qcache_inserts          | 3308<br>
   Qcache_lowmem_prunes    | 0<br>
   Qcache_not_cached       | 4537<br>
   Qcache_queries_in_cache | 1225<br>
   Qcache_total_blocks     | 2609     </p>
  
  <p>The problem is that the cache doesn't seem to be hit, the query that takes most of the time (3 seconds on average) never changes.</p>
  
  <p>Does anyone have any tips on why enabling query / result caching wouldn't improve load times?</p>