针对这条SQL, TiDB 的查询速度较慢，是什么引起的？

CREATE TABLE atdtimeordercalendar (
calendardate date NOT NULL COMMENT ‘行事日期’,
TIMEORDERID varchar(40) NOT NULL DEFAULT ‘’ COMMENT ‘班次ID’,
CALENDARTYPE int(11) DEFAULT ‘0’ COMMENT ‘行事类型’
PRIMARY KEY (Id) /*T![clustered_index] NONCLUSTERED */,
KEY ix_calendardate (calendardate),
KEY ix_TIMEORDERID (TIMEORDERID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin