短跑最佳方法

页面:/news/view-2639706/ | 耗时:0.6916 s | 内存:1.89 MB | 查询:5 | 缓存读取:4 写入:1 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2639706 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2639706 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2639706 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2919212,429485,3186156,471487,476977,723114,1351482,787356,3093421,1366664,1038758,551096,650080,815240,2374102,722566,854957,597159,956197,2702120,1336194,3114207,3214198,804624,1024304,817493,627446,1454528,3092089,2097419) ORDER BY field (ArticleID,2919212,429485,3186156,471487,476977,723114,1351482,787356,3093421,1366664,1038758,551096,650080,815240,2374102,722566,854957,597159,956197,2702120,1336194,3114207,3214198,804624,1024304,817493,627446,1454528,3092089,2097419)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90024 ORDER BY ArticleID DESC LIMIT 20