摘用音序查字法先查什么再查什么

页面:/news/view-1720136/ | 耗时:0.7223 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1720136 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1720136 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1720136 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1114066,1044316,1054358,1071233,1103033,1078354,1131377,1065053,983947,1113584,1041283,1078414,1077268,1128936,1064663,1070650,1043706,1065871,1062130,1125297,1077352,1071501,1057696,1072093,1101053,1063675,1071003,1073588,1072721,1078438) ORDER BY field (ArticleID,1114066,1044316,1054358,1071233,1103033,1078354,1131377,1065053,983947,1113584,1041283,1078414,1077268,1128936,1064663,1070650,1043706,1065871,1062130,1125297,1077352,1071501,1057696,1072093,1101053,1063675,1071003,1073588,1072721,1078438)