传奇爆率小技巧

页面:/news/view-2756829/ | 耗时:0.3266 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2756829 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2756829 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2756829 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(568109,406437,2601830,1981228,463171,747461,1121171,2529450,1168798,679236,1022856,2463191,606544,1035498,1735467,1337274,708370,1408337,1115780,657652,1318936,720571,660255,1206444,1091570,2184002,1095927,920536,2237206,1163297) ORDER BY field (ArticleID,568109,406437,2601830,1981228,463171,747461,1121171,2529450,1168798,679236,1022856,2463191,606544,1035498,1735467,1337274,708370,1408337,1115780,657652,1318936,720571,660255,1206444,1091570,2184002,1095927,920536,2237206,1163297)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90016 ORDER BY ArticleID DESC LIMIT 20