增强力量的4种技巧

页面:/news/view-769368/ | 耗时:0.0939 s | 内存:1.89 MB | 查询:6 | 缓存读取:4 写入:2 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=769368 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=769368 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90013 LIMIT 0,1
select * from tbl_Articles_sphinx where id=769368 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1023396,765419,984275,2566696,546480,2643790,2054227,2012368,2006971,2316227,567414,1635129,1096445,1135573,655625,782601,844848,406731,1767711,1079304,1208060,387740,677518,1010800,600311,474474,846293,2469175,1125418,1472946) ORDER BY field (ArticleID,1023396,765419,984275,2566696,546480,2643790,2054227,2012368,2006971,2316227,567414,1635129,1096445,1135573,655625,782601,844848,406731,1767711,1079304,1208060,387740,677518,1010800,600311,474474,846293,2469175,1125418,1472946)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90013 ORDER BY ArticleID DESC LIMIT 20