剥板栗皮的最快方法

页面:/news/view-3186777/ | 耗时:0.9272 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3186777 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3186777 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3186777 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1108187,1067145,1060493,1110221,1084213,1121000,1092770,1114374,1081865,1123989,1114124,1105653,1063667,1112873,1110906,1132753,1121032,1109541,1112680,1108706,1117295,1120729,1061384,1104139,1061728,1109815,1109767,1114934,1113161,1116225) ORDER BY field (ArticleID,1108187,1067145,1060493,1110221,1084213,1121000,1092770,1114374,1081865,1123989,1114124,1105653,1063667,1112873,1110906,1132753,1121032,1109541,1112680,1108706,1117295,1120729,1061384,1104139,1061728,1109815,1109767,1114934,1113161,1116225)