跑一千米的技巧

页面:/news/view-680974/ | 耗时:0.7402 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=680974 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=680974 LIMIT 0,1
select * from tbl_Articles_sphinx where id=680974 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(389559,410016,1877819,724824,362271,782441,607168,795350,669294,794768,1155442,664994,891335,1724713,382858,3473623,971269,634199,487379,3069557,519503,3490920,81360,3232129,94830,443273,517842,571158,769948,937748) ORDER BY field (ArticleID,389559,410016,1877819,724824,362271,782441,607168,795350,669294,794768,1155442,664994,891335,1724713,382858,3473623,971269,634199,487379,3069557,519503,3490920,81360,3232129,94830,443273,517842,571158,769948,937748)