面试中常见的问题

页面:/news/view-450841/ | 耗时:0.1601 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=450841 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=450841 LIMIT 0,1
select * from tbl_Articles_sphinx where id=450841 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1066924,1073832,1102022,1089620,1078424,1063641,1115699,1082318,1075907,1122096,1091621,1049542,995175,1046512,1068830,1093693,1088906,1094771,1106545,1069223,1067623,1063159,1121320,1032968,1094811,1085154,1092129,1111448,1042066,1052349) ORDER BY field (ArticleID,1066924,1073832,1102022,1089620,1078424,1063641,1115699,1082318,1075907,1122096,1091621,1049542,995175,1046512,1068830,1093693,1088906,1094771,1106545,1069223,1067623,1063159,1121320,1032968,1094811,1085154,1092129,1111448,1042066,1052349)