除蟑螂最有效的方法

页面:/news/view-954864/ | 耗时:0.1221 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=954864 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=954864 LIMIT 0,1
select * from tbl_Articles_sphinx where id=954864 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1123430,1112468,1104567,1121808,1117295,1112590,1118825,1044292,1109487,1067145,1098167,1045390,1107509,1087321,1071933,1093825,1120803,1116769,1097153,1120729,1055858,1119013,1071695,1116123,1057623,1123215,1076718,1117554,1112364,1117868) ORDER BY field (ArticleID,1123430,1112468,1104567,1121808,1117295,1112590,1118825,1044292,1109487,1067145,1098167,1045390,1107509,1087321,1071933,1093825,1120803,1116769,1097153,1120729,1055858,1119013,1071695,1116123,1057623,1123215,1076718,1117554,1112364,1117868)