去蟑螂最有效的方法

页面:/news/view-923761/ | 耗时:0.8075 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=923761 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=923761 LIMIT 0,1
select * from tbl_Articles_sphinx where id=923761 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1074912,1107827,1110401,1127399,1106236,1071175,1120615,1120803,1082059,1106557,1103111,1105553,1104843,1108706,1077788,988817,1110656,1095674,1106629,1097619,1063629,1109507,1074914,1123255,1052269,1120679,1113906,1073349,1112606,1110221) ORDER BY field (ArticleID,1074912,1107827,1110401,1127399,1106236,1071175,1120615,1120803,1082059,1106557,1103111,1105553,1104843,1108706,1077788,988817,1110656,1095674,1106629,1097619,1063629,1109507,1074914,1123255,1052269,1120679,1113906,1073349,1112606,1110221)