大量腌鱼的方法

页面:/news/view-1491494/ | 耗时:0.0317 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1491494 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1491494 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1491494 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1085564,1073894,1063785,1099685,1070286,1104039,1095432,1089822,1109282,1105611,1115795,1107481,1073556,1130053,1074905,1112726,1063037,1047697,1090717,1102991,1077070,1064941,1094045,1097549,1091249,1071936,1100569,1095536,1062046,1084315) ORDER BY field (ArticleID,1085564,1073894,1063785,1099685,1070286,1104039,1095432,1089822,1109282,1105611,1115795,1107481,1073556,1130053,1074905,1112726,1063037,1047697,1090717,1102991,1077070,1064941,1094045,1097549,1091249,1071936,1100569,1095536,1062046,1084315)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90002 ORDER BY ArticleID DESC LIMIT 20