考科二的最有效的方法

页面:/news/view-3125580/ | 耗时:0.8827 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3125580 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3125580 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3125580 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3158067,3408313,1507936,2642331,3481039,2433211,1062139,1285224,407794,1114910,1607090,928617,1111264,627845,827089,3378338,2788489,3255824,600665,835106,1481978,1367320,933435,2580230,2747782,1075364,466585,857517,508236,1115763) ORDER BY field (ArticleID,3158067,3408313,1507936,2642331,3481039,2433211,1062139,1285224,407794,1114910,1607090,928617,1111264,627845,827089,3378338,2788489,3255824,600665,835106,1481978,1367320,933435,2580230,2747782,1075364,466585,857517,508236,1115763)