关键词搜索技巧

页面:/news/view-2097620/ | 耗时:0.8493 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2097620 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2097620 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2097620 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(632834,417852,496945,3208052,3338164,1123240,1851808,373095,3454166,504767,698614,537061,3034012,3410104,3124237,433318,626726,1139277,1210237,1191801,3501191,769202,81595,2097620,3460974,639828,3079316,1018694,2972050,1069995) ORDER BY field (ArticleID,632834,417852,496945,3208052,3338164,1123240,1851808,373095,3454166,504767,698614,537061,3034012,3410104,3124237,433318,626726,1139277,1210237,1191801,3501191,769202,81595,2097620,3460974,639828,3079316,1018694,2972050,1069995)