学霸考试的小技巧

页面:/news/view-2575554/ | 耗时:0.6311 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2575554 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2575554 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2575554 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1121540,807098,1659394,1114262,600424,636010,565222,1429907,541844,832872,608249,657293,2794259,3263903,450096,511443,2149566,1154087,707121,925816,449325,2270155,666614,534167,1104161,1157314,1062459,1109418,1108532,442546) ORDER BY field (ArticleID,1121540,807098,1659394,1114262,600424,636010,565222,1429907,541844,832872,608249,657293,2794259,3263903,450096,511443,2149566,1154087,707121,925816,449325,2270155,666614,534167,1104161,1157314,1062459,1109418,1108532,442546)