mysql> explain select count(downloadco0_.id) as col_0_0_ from DownloadConfirmation downloadco0_ where downloadco0_.platform='EU' and downloadco0_.fulfillerId='5' and (downloadco0_.downloadCompleted is null)\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: downloadco0_
type: ref
possible_keys: platformFulfillerIdExecutionId,downloadCompleted
key: downloadCompleted
key_len: 779
ref: const,const,const
rows: 8
Extra: Using where; Using index
1 row in set (0.00 sec)
mysql> explain select count(downloadc o0_.id) as col_0_0_ from DownloadConfirm ation downloadco0_ where downloadco0_ .platform= 'EU' and downloadco0_ .fulfillerId= '5' and (downloadco0_ .downloadComple ted is null)\G ******* ******* ****** 1. row ******* ******* ******* ****** erIdExecutionId ,downloadComple ted
*******
id: 1
select_type: SIMPLE
table: downloadco0_
type: ref
possible_keys: platformFulfill
key: downloadCompleted
key_len: 779
ref: const,const,const
rows: 8
Extra: Using where; Using index
1 row in set (0.00 sec)