单选题

Mysql中表user的建表语句如下， CREATE TABLE `use...

Question

Mysql中表user的建表语句如下，

CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `created_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_com1` (`name`,`age`,`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表'

以下哪个查询语句没有使用到索引idx_com1？

A. select * from user where name='张三' and age = 25 and address='北京大兴区'

B. select * from user where name='张三' and address='北京大兴区'

C. select * from user where age = 25 and address='北京大兴区'

D. select * from user where address='北京大兴区' and age = 25 and name='张三'