芒果千层最简单的做法

页面:/news/view-420584/ | 耗时:0.5553 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=420584 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=420584 LIMIT 0,1
select * from tbl_Articles_sphinx where id=420584 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1108586,1115121,1114999,1096270,1092790,1084645,1116447,1066108,1303628,1119864,1108716,1076984,1116231,1092333,1105709,1108812,1119766,1119437,1093422,1063655,1095868,1093585,1122296,1083431,1121423,1120701,1071103,1133071,1087831,1090404) ORDER BY field (ArticleID,1108586,1115121,1114999,1096270,1092790,1084645,1116447,1066108,1303628,1119864,1108716,1076984,1116231,1092333,1105709,1108812,1119766,1119437,1093422,1063655,1095868,1093585,1122296,1083431,1121423,1120701,1071103,1133071,1087831,1090404)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90002 ORDER BY ArticleID DESC LIMIT 20