蛤蜊吐沙最快的方法

页面:/news/view-400870/ | 耗时:0.9220 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=400870 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=400870 LIMIT 0,1
select * from tbl_Articles_sphinx where id=400870 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1073714,1060867,1123253,1045464,1117385,1131897,1068562,1124219,1123701,1112997,1073786,1113690,1100533,1114404,1121400,1103670,1102969,1007198,1502468,1107190,1122411,1053396,1046554,1104268,1075787,1071511,1123219,1094525,1112024,1112006) ORDER BY field (ArticleID,1073714,1060867,1123253,1045464,1117385,1131897,1068562,1124219,1123701,1112997,1073786,1113690,1100533,1114404,1121400,1103670,1102969,1007198,1502468,1107190,1122411,1053396,1046554,1104268,1075787,1071511,1123219,1094525,1112024,1112006)