title: How to optimize MySQL query ‘SELECT * from table WHERE Date=CURDATE() and ID=1;’
body: <p>I have the following data in a MySQL table <code>table</code>:</p>
  
  <p><code>ID</code>: int(11)  [this is the primary key]</p>
  
  <p><code>Date</code>: date</p>
  
  <p>and I run the MySQL query:</p>
  
  <pre><code>SELECT * from table WHERE Date=CURDATE() and ID=1;
  </code></pre>
  
  <p>This takes between 0.6 and 1.2 seconds.</p>
  
  <p>Is there any way to optimize this query to get results quicker?</p>
  
  <p>My objective is to find out if I already have a record for today for this <code>ID</code>.</p>