从高速档换低速档技巧

页面:/news/view-732629/ | 耗时:0.2288 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=732629 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=732629 LIMIT 0,1
select * from tbl_Articles_sphinx where id=732629 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(537626,490173,2482974,767635,378218,570370,546724,462064,880853,858712,737980,487745,578624,854123,1655631,743443,840212,530191,381038,461659,467764,709172,541398,410218,466611,747047,771397,519607,456045,454860) ORDER BY field (ArticleID,537626,490173,2482974,767635,378218,570370,546724,462064,880853,858712,737980,487745,578624,854123,1655631,743443,840212,530191,381038,461659,467764,709172,541398,410218,466611,747047,771397,519607,456045,454860)