面试的有效技巧

页面:/news/view-523736/ | 耗时:0.3179 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=523736 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=523736 LIMIT 0,1
select * from tbl_Articles_sphinx where id=523736 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1120729,1110940,1119646,1116583,1122334,1079291,1124392,1124299,1125311,1104567,1108325,1097619,1070062,1126270,1079410,1103670,1108718,1042654,1121980,1121280,1092974,1116956,1116363,1103861,1048298,1089936,1089160,1074608,1105055,1109312) ORDER BY field (ArticleID,1120729,1110940,1119646,1116583,1122334,1079291,1124392,1124299,1125311,1104567,1108325,1097619,1070062,1126270,1079410,1103670,1108718,1042654,1121980,1121280,1092974,1116956,1116363,1103861,1048298,1089936,1089160,1074608,1105055,1109312)