分类法在检索中的利用优势

页面:/news/view-228153/ | 耗时:0.1661 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=228153 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=228153 LIMIT 0,1
select * from tbl_Articles_sphinx where id=228153 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1044745,1112730,1108828,1042020,1073493,1101929,1044569,1076744,1114502,1066106,1046963,1045793,1098747,1070284,1111696,1079956,1094015,1084445,1110586,1076299,1089962,1086698,1107833,1069793,1092139,1109749,1114836,1042658,1112500,1100537) ORDER BY field (ArticleID,1044745,1112730,1108828,1042020,1073493,1101929,1044569,1076744,1114502,1066106,1046963,1045793,1098747,1070284,1111696,1079956,1094015,1084445,1110586,1076299,1089962,1086698,1107833,1069793,1092139,1109749,1114836,1042658,1112500,1100537)