面试时的技巧及注意事项

页面:/news/view-1843238/ | 耗时:0.7170 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1843238 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1843238 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1843238 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1063021,1114048,1081835,1062930,1104266,1107062,1094442,1041729,1113471,1078150,1091621,1010909,1083453,1076209,1120410,1070014,1044609,1097635,1087625,1081881,1066804,1102328,1060755,1078294,1049030,1119938,1078735,1049542,1111130,1117884) ORDER BY field (ArticleID,1063021,1114048,1081835,1062930,1104266,1107062,1094442,1041729,1113471,1078150,1091621,1010909,1083453,1076209,1120410,1070014,1044609,1097635,1087625,1081881,1066804,1102328,1060755,1078294,1049030,1119938,1078735,1049542,1111130,1117884)