速记的方法

页面:/news/view-1068455/ | 耗时:0.9890 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1068455 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1068455 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1068455 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1836768,3356208,3340987,2537560,1163528,1096128,883282,2896848,2085975,2001752,1098139,906782,3398867,939415,1085926,1087052,1093222,3182317,424622,1531121,1667566,3226340,2798176,2665077,86719,1122925,1108532,1728550,1097299,415136) ORDER BY field (ArticleID,1836768,3356208,3340987,2537560,1163528,1096128,883282,2896848,2085975,2001752,1098139,906782,3398867,939415,1085926,1087052,1093222,3182317,424622,1531121,1667566,3226340,2798176,2665077,86719,1122925,1108532,1728550,1097299,415136)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90001 ORDER BY ArticleID DESC LIMIT 20