count函数的用法

页面:/news/view-900450/ | 耗时:0.0512 s | 内存:1.89 MB | 查询:6 | 缓存读取:4 写入:2 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=900450 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=900450 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90031 LIMIT 0,1
select * from tbl_Articles_sphinx where id=900450 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2094555,1848064,1955656,2295037,2790139,3529670,1339231,3285491,3078636,3138011,3143166,3529931,1723838,2791946,1069457,3528759,2344219,3527140,2321612,1528367,2341394,2815033,3357844,2584508,903387,3527238,2679049,2138541,266097,2286322) ORDER BY field (ArticleID,2094555,1848064,1955656,2295037,2790139,3529670,1339231,3285491,3078636,3138011,3143166,3529931,1723838,2791946,1069457,3528759,2344219,3527140,2321612,1528367,2341394,2815033,3357844,2584508,903387,3527238,2679049,2138541,266097,2286322)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90031 ORDER BY ArticleID DESC LIMIT 20