挖掘机使用的技巧

页面:/news/view-3159711/ | 耗时:0.5887 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3159711 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3159711 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3159711 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(451208,607975,1194854,374763,437288,596394,484591,386007,2227344,570940,2776539,448775,1143615,445415,479006,497170,1206976,455771,528214,551388,434838,991208,635622,380797,591200,628183,430884,391107,1950331,1214318) ORDER BY field (ArticleID,451208,607975,1194854,374763,437288,596394,484591,386007,2227344,570940,2776539,448775,1143615,445415,479006,497170,1206976,455771,528214,551388,434838,991208,635622,380797,591200,628183,430884,391107,1950331,1214318)