除蟑螂最有效的方法

页面:/news/view-3271402/ | 耗时:0.4676 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3271402 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3271402 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3271402 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1110113,1096611,1092868,1102738,1104434,1043385,1046512,1115511,1047441,1076209,1100583,1066941,1088884,1100899,1097779,1049870,1110674,1066498,1054388,1108401,1084081,1083113,1115412,1115819,1095888,1110988,1094383,1048878,1100033,1069505) ORDER BY field (ArticleID,1110113,1096611,1092868,1102738,1104434,1043385,1046512,1115511,1047441,1076209,1100583,1066941,1088884,1100899,1097779,1049870,1110674,1066498,1054388,1108401,1084081,1083113,1115412,1115819,1095888,1110988,1094383,1048878,1100033,1069505)