面试小技巧

页面:/news/view-2776868/ | 耗时:0.6514 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2776868 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2776868 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2776868 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1089732,970294,814279,1226954,634494,3443616,3490408,1075521,3338695,509002,2210207,1027635,1503285,2776868,608663,1083198,771495,651340,1382392,1740218,3352670,993825,2188750,1025127,1182131,1076400,1415310,1259994,1081592,2381261) ORDER BY field (ArticleID,1089732,970294,814279,1226954,634494,3443616,3490408,1075521,3338695,509002,2210207,1027635,1503285,2776868,608663,1083198,771495,651340,1382392,1740218,3352670,993825,2188750,1025127,1182131,1076400,1415310,1259994,1081592,2381261)