title: MySQL query is slow?
body: <p>Today I have a problem in my SQL query, my request take most 30 seconds, so I get an error in my php.</p>
  
  <p>My SQL query:</p>
  
  <pre><code>SELECT v.ID
       , v.TITLE 
       , v.THUMB  
    FROM video v
    JOIN join_video_date d
      ON d.ID_VIDEO = v.ID 
    JOIN join_video_category c 
      ON c.ID_VIDEO = v.ID
   WHERE c.ID_CATEGORY = $ID
   ORDER 
      BY d.DATE DESC 
   LIMIT $PAGE,24
  </code></pre>
  
  <p>This query take 24 video of category ordered by date, but this query is slow.</p>
  
  <p>I have indexes all tables, example of table "join_video_date"</p>
  
  <pre><code>join_video_date (ID, ID_VIDEO, DATE)
  </code></pre>
  
  <p>Index: </p>
  
  <pre><code>PRIMARY -&gt; ID
  ID_VIDEO -&gt; ID_VIDEO
  DATE -&gt; DATE
  </code></pre>