抽屉原理的诀窍

页面:/news/view-105231/ | 耗时:0.2165 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=105231 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=105231 LIMIT 0,1
select * from tbl_Articles_sphinx where id=105231 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1109102,1110848,1120843,1103815,1082938,1111544,1053448,1122411,1113027,1125203,1082059,1046554,1070928,1089068,1109430,1111588,1096783,1111938,1102390,1106455,1043043,1124879,1073417,1113906,1093825,1048508,1069061,1070884,1103652,1078116) ORDER BY field (ArticleID,1109102,1110848,1120843,1103815,1082938,1111544,1053448,1122411,1113027,1125203,1082059,1046554,1070928,1089068,1109430,1111588,1096783,1111938,1102390,1106455,1043043,1124879,1073417,1113906,1093825,1048508,1069061,1070884,1103652,1078116)