关键词搜索技巧

页面:/news/view-216668/ | 耗时:0.1230 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=216668 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=216668 LIMIT 0,1
select * from tbl_Articles_sphinx where id=216668 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(302175,608490,347095,581628,218845,247483,270589,233086,255888,339834,584345,166938,437808,252985,181819,420982,256309,609998,133104,352376,319506,272425,397049,350028,116688,232207,302089,261376,356663,224112) ORDER BY field (ArticleID,302175,608490,347095,581628,218845,247483,270589,233086,255888,339834,584345,166938,437808,252985,181819,420982,256309,609998,133104,352376,319506,272425,397049,350028,116688,232207,302089,261376,356663,224112)