刮墙角手法技巧

页面:/news/view-1906042/ | 耗时:0.5236 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1906042 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1906042 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1906042 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(579644,492803,466785,579134,472060,557724,575767,1066264,411693,505847,468987,1047435,534089,453639,369489,409133,492933,482641,494365,380841,564240,395511,381102,553897,534906,395375,97219,401298,479771,495479) ORDER BY field (ArticleID,579644,492803,466785,579134,472060,557724,575767,1066264,411693,505847,468987,1047435,534089,453639,369489,409133,492933,482641,494365,380841,564240,395511,381102,553897,534906,395375,97219,401298,479771,495479)