Simple query not using indexes
As far as I can tell, your query is using an index, the one that backs your primary key.

Look at the EXPLAIN Output Format documentation for the "join type" column. The second bullet point for the index join type is what your select is using:


  
  A full table scan is performed using reads from the index to look up data rows in index order. Uses index does not appear in the Extra column.