去黑头的最佳方法

页面:/news/view-2011229/ | 耗时:0.4097 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2011229 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2011229 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2011229 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1125086,1121910,1082904,1114010,1117243,1120615,1055133,1132761,1116327,1103066,1122893,1112006,1107759,1116859,1104967,1124863,1106234,1055996,1089936,1098307,1046462,1074377,1060940,1109316,1048508,1123375,1119454,1068274,1108359,981473) ORDER BY field (ArticleID,1125086,1121910,1082904,1114010,1117243,1120615,1055133,1132761,1116327,1103066,1122893,1112006,1107759,1116859,1104967,1124863,1106234,1055996,1089936,1098307,1046462,1074377,1060940,1109316,1048508,1123375,1119454,1068274,1108359,981473)