扫描速度如何提高

页面:/news/view-149582/ | 耗时:0.2496 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=149582 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=149582 LIMIT 0,1
select * from tbl_Articles_sphinx where id=149582 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(139644,1733058,1719854,576866,641700,339987,255618,253447,503062,3427545,237060,1457820,1127027,127174,145091,1575083,1132577,456360,246985,1050207,483633,1626367,1749007,256655,347540,2461504,322999,1058415,1053058,1083030) ORDER BY field (ArticleID,139644,1733058,1719854,576866,641700,339987,255618,253447,503062,3427545,237060,1457820,1127027,127174,145091,1575083,1132577,456360,246985,1050207,483633,1626367,1749007,256655,347540,2461504,322999,1058415,1053058,1083030)