大跳技巧分解教学

页面:/news/view-457701/ | 耗时:0.3513 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=457701 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=457701 LIMIT 0,1
select * from tbl_Articles_sphinx where id=457701 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(968695,782265,1006149,524858,840066,563708,1160559,712140,1199569,1056823,634447,1177511,446303,673491,1205276,840212,695041,709980,519425,971444,393079,740800,591218,484469,510572,1215279,986949,1166285,853232,973615) ORDER BY field (ArticleID,968695,782265,1006149,524858,840066,563708,1160559,712140,1199569,1056823,634447,1177511,446303,673491,1205276,840212,695041,709980,519425,971444,393079,740800,591218,484469,510572,1215279,986949,1166285,853232,973615)