钻探的三种方法

页面:/news/view-765607/ | 耗时:0.2244 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=765607 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=765607 LIMIT 0,1
select * from tbl_Articles_sphinx where id=765607 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(849548,1376378,1313984,1452458,1030288,782459,2450677,1187026,2565632,1396634,901459,3478922,2905513,757801,1127380,2299154,3488064,941949,648577,2302833,2952654,2820638,3510407,2065394,860199,1384093,950778,3471100,2387029,358079) ORDER BY field (ArticleID,849548,1376378,1313984,1452458,1030288,782459,2450677,1187026,2565632,1396634,901459,3478922,2905513,757801,1127380,2299154,3488064,941949,648577,2302833,2952654,2820638,3510407,2065394,860199,1384093,950778,3471100,2387029,358079)