上镜最佳方法

页面:/news/view-1099412/ | 耗时:0.3579 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1099412 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1099412 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1099412 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1130536,1814410,1115436,1148802,1105179,1095251,786848,1131339,1148878,1050283,81468,483946,1129537,1100193,1095295,1221160,1085374,374569,1120765,1126985,1113163,1090713,661736,1123038,1148001,618216,1123515,437064,506382,1116207) ORDER BY field (ArticleID,1130536,1814410,1115436,1148802,1105179,1095251,786848,1131339,1148878,1050283,81468,483946,1129537,1100193,1095295,1221160,1085374,374569,1120765,1126985,1113163,1090713,661736,1123038,1148001,618216,1123515,437064,506382,1116207)