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

CREATE TABLE atdadjusttimeorder (
begindate date NOT NULL COMMENT ‘开始日期’,
enddate date NOT NULL COMMENT ‘结束日期’,
PERSONID varchar(40) NOT NULL DEFAULT ‘’ COMMENT ‘人员ID’,
TIMEORDERID varchar(40) DEFAULT ‘’ COMMENT ‘班次ID’
PRIMARY KEY (Id) /*T![clustered_index] NONCLUSTERED */,
KEY ATDADJUSTTIMEORDER_Main (PERSONID,begindate,enddate),
KEY ix_TIMEORDERID (TIMEORDERID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin