砌墙最快的方法

页面:/news/view-2291243/ | 耗时:0.1704 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2291243 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2291243 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2291243 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1117389,1115541,1104923,1076586,1111086,1125257,1112430,1109406,1124235,1074912,1110946,1108488,1502468,1111724,1117674,1106557,1088754,1071695,1098587,1105787,1072184,1117169,1104001,1108864,1108205,986816,1063203,1122030,1093633,1093825) ORDER BY field (ArticleID,1117389,1115541,1104923,1076586,1111086,1125257,1112430,1109406,1124235,1074912,1110946,1108488,1502468,1111724,1117674,1106557,1088754,1071695,1098587,1105787,1072184,1117169,1104001,1108864,1108205,986816,1063203,1122030,1093633,1093825)