mysql> explain select downloadco0_.id as id1_9_, downloadco0_.attempts as attempts2_9_, downloadco0_.dateCreated as dateCrea3_9_, downloadco0_.dateModified as dateModi4_9_, downloadco0_.downloadCompleted as download5_9_, downloadco0_.downloadStarted as download6_9_, downloadco0_.executionId as executio7_9_, downloadco0_.fileId as fileId8_9_, downloadco0_.fileSize as fileSize9_9_, downloadco0_.fulfillerId as fulfill10_9_, downloadco0_.platform as platfor11_9_ from DownloadConfirmation downloadco0_ where downloadco0_.platform='EU' and downloadco0_.fulfillerId='12' and downloadco0_.executionId='103906' and (downloadco0_.downloadCompleted is not null) order by downloadco0_.downloadCompleted asc limit 1\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: downloadco0_
type: range
possible_keys: platformFulfillerIdExecutionId,downloadCompleted
key: downloadCompleted
key_len: 6
ref: NULL
rows: 403364
Extra: Using where
1 row in set (0.00 sec)
mysql> explain select downloadco0_.id as id1_9_, downloadco0_ .attempts as attempts2_9_, downloadco0_ .dateCreated as dateCrea3_9_, downloadco0_ .dateModified as dateModi4_9_, downloadco0_ .downloadComple ted as download5_9_, downloadco0_ .downloadStarte d as download6_9_, downloadco0_ .executionId as executio7_9_, downloadco0_.fileId as fileId8_9_, downloadco0_ .fileSize as fileSize9_9_, downloadco0_ .fulfillerId as fulfill10_9_, downloadco0_ .platform as platfor11_9_ from DownloadConfirm ation downloadco0_ where downloadco0_ .platform= 'EU' and downloadco0_ .fulfillerId= '12' and downloadco0_ .executionId= '103906' and (downloadco0_ .downloadComple ted is not null) order by downloadco0_ .downloadComple ted asc limit 1\G ******* ******* ****** 1. row ******* ******* ******* ****** erIdExecutionId ,downloadComple ted
*******
id: 1
select_type: SIMPLE
table: downloadco0_
type: range
possible_keys: platformFulfill
key: downloadCompleted
key_len: 6
ref: NULL
rows: 403364
Extra: Using where
1 row in set (0.00 sec)