腌萝卜干的方法

页面:/news/view-920512/ | 耗时:0.9383 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=920512 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=920512 LIMIT 0,1
select * from tbl_Articles_sphinx where id=920512 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1078887,1122821,1111066,1094979,1117950,1104087,1107224,1056328,1095672,1089904,1097549,1076560,1106170,1109242,1072415,1112136,1104559,1105709,1121396,1119864,1118026,1091424,1098903,1085570,1113427,1082299,1086362,1049934,1098135,1116421) ORDER BY field (ArticleID,1078887,1122821,1111066,1094979,1117950,1104087,1107224,1056328,1095672,1089904,1097549,1076560,1106170,1109242,1072415,1112136,1104559,1105709,1121396,1119864,1118026,1091424,1098903,1085570,1113427,1082299,1086362,1049934,1098135,1116421)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90002 ORDER BY ArticleID DESC LIMIT 20