CREATE TABLEtest(
idint(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
creatorvarchar(128) NOT NULL DEFAULT '0' COMMENT '创建人',
gmt_createtimestamp NULL DEFAULT NULL COMMENT '创建时间',
modifiervarchar(128) DEFAULT '0' COMMENT '修改人',
gmt_modifiedtimestamp NULL DEFAULT NULL COMMENT '修改时间',
titlevarchar(64) DEFAULT NULL COMMENT '工单标题',
categoryvarchar(32) DEFAULT NULL COMMENT '工单类别',
subjectvarchar(32) DEFAULT NULL COMMENT '工单类型',
demandervarchar(30) DEFAULT NULL COMMENT '需求方',
is_atomicchar(1) DEFAULT 'y' COMMENT '是否原子工单',
atomic_idint(11) DEFAULT NULL COMMENT '当前原子工单在列表中ID',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=182431 DEFAULT CHARSET=utf8 COMMENT='测试表';

SHOW INDEX FROM test

ALTER TABLE test ADD INDEX test_title (title)

EXPLAIN SELECT * FROM test.test WHERE id = 100 or title = 'gg'

EXPLAIN SELECT * FROM test.test WHERE title = 'ggg'