集合竞价挂单技巧

页面:/news/view-842065/ | 耗时:0.6856 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=842065 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=842065 LIMIT 0,1
select * from tbl_Articles_sphinx where id=842065 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(248648,140260,165713,245008,116085,170625,926812,201087,171861,1083473,1523245,204958,154908,240009,132668,997282,213074,195676,188451,2382643,109408,147872,240891,1100887,242857,121763,224324,238579,181031,487336) ORDER BY field (ArticleID,248648,140260,165713,245008,116085,170625,926812,201087,171861,1083473,1523245,204958,154908,240009,132668,997282,213074,195676,188451,2382643,109408,147872,240891,1100887,242857,121763,224324,238579,181031,487336)