古代记时方法

页面:/news/view-3047395/ | 耗时:0.1576 s | 内存:1.89 MB | 查询:6 | 缓存读取:4 写入:2 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3047395 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3047395 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90018 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3047395 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1205833,2952473,2310427,3411461,558437,1210912,1193592,3090102,1356388,717683,2530058,2831793,591609,1432478,3067101,1068331,1553413,2098733,614157,2497943,857605,921724,2412504,3505421,3307787,798389,957494,851947,3167428,616209) ORDER BY field (ArticleID,1205833,2952473,2310427,3411461,558437,1210912,1193592,3090102,1356388,717683,2530058,2831793,591609,1432478,3067101,1068331,1553413,2098733,614157,2497943,857605,921724,2412504,3505421,3307787,798389,957494,851947,3167428,616209)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90018 ORDER BY ArticleID DESC LIMIT 20