萃取过滤等实验方法的区别是什么

页面:/news/view-122328/ | 耗时:0.7497 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=122328 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=122328 LIMIT 0,1
select * from tbl_Articles_sphinx where id=122328 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1081905,1110810,1070796,1076209,1103556,1097283,1049542,1066828,1105029,2247196,1081969,1052425,1128231,1114000,1125063,1064883,1093693,1094155,1084909,3315151,1110850,1125231,1097351,1104335,1071701,1114866,1042020,993285,1108522,1084259) ORDER BY field (ArticleID,1081905,1110810,1070796,1076209,1103556,1097283,1049542,1066828,1105029,2247196,1081969,1052425,1128231,1114000,1125063,1064883,1093693,1094155,1084909,3315151,1110850,1125231,1097351,1104335,1071701,1114866,1042020,993285,1108522,1084259)