挖藕快速的方法

页面:/news/view-2652894/ | 耗时:0.1368 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2652894 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2652894 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2652894 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1118306,1100037,1101839,1123329,1103670,1084091,1121000,1064179,1108624,1118074,1077154,1084125,1062632,1076840,1116123,1108235,1124191,1077986,1063935,1120376,1107359,1073714,1123817,1106868,1110145,1069061,1105673,1114906,1109100,1117674) ORDER BY field (ArticleID,1118306,1100037,1101839,1123329,1103670,1084091,1121000,1064179,1108624,1118074,1077154,1084125,1062632,1076840,1116123,1108235,1124191,1077986,1063935,1120376,1107359,1073714,1123817,1106868,1110145,1069061,1105673,1114906,1109100,1117674)