mysql索引执行效率

CREATE TABLE `memory` (
  `ID` varchar(255) NOT NULL,
  `RESID` varchar(255) DEFAULT NULL,
  `TYPE` varchar(255) DEFAULT NULL,
  `INDEXNUM` varchar(255) DEFAULT NULL,
  `INDEXNAME` varchar(255) DEFAULT NULL,
  `STYPE` varchar(255) DEFAULT NULL,
  `SIZE` varchar(255) DEFAULT NULL,
  `FREQUENCY` varchar(255) DEFAULT NULL,
  `LOCATION` varchar(255) DEFAULT NULL,
  `TOTALSLOT` varchar(255) DEFAULT NULL,
  `USEDSLOT` varchar(255) DEFAULT NULL,
  `DATA` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`,`DATA`),
  KEY `resid` (`RESID`) USING BTREE,
  KEY `data` (`DATA`) USING BTREE,
  KEY `data_union_indexname` (`INDEXNAME`,`DATA`) USING BTREE,
  KEY `residall` (`RESID`,`INDEXNAME`,`DATA`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

一 const
EXPLAIN SELECT * FROM `memory` WHERE id = '0002f004008c48d99ebc0eb1c5a30d20' and data = '2018-04-16 15:00:36';

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	memory	const	PRIMARY,data	PRIMARY	775	const,const	1	

二 ref
EXPLAIN SELECT * FROM `memory` WHERE resid = '0bc22dada7ba4f5aab272a2ff16b1d35'
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	memory	ref	resid,residall	resid	768	const	17872	Using where

三 range
EXPLAIN SELECT * FROM `memory` WHERE  id = '0002f004008c48d99ebc0eb1c5a30d20' and data > '2018-04-16 15:00:00'
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	memory	range	PRIMARY,data	PRIMARY	775		1	Using where

四 all
EXPLAIN SELECT * FROM `memory` WHERE  data > '2018-04-16 15:00:00'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	memory	ALL	data				59144	Using where