面试时要掌握的技巧

页面:/news/view-1169423/ | 耗时:0.1262 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1169423 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1169423 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1169423 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1068314,1110480,1061410,1103423,1116950,1117830,1123283,1119466,1054232,1114598,1104383,1091845,1123219,1095443,1109803,1123563,1053400,1074914,1103652,1103031,1120679,1017717,1109398,1109487,1110626,1114010,1105145,1114612,1070928,1123865) ORDER BY field (ArticleID,1068314,1110480,1061410,1103423,1116950,1117830,1123283,1119466,1054232,1114598,1104383,1091845,1123219,1095443,1109803,1123563,1053400,1074914,1103652,1103031,1120679,1017717,1109398,1109487,1110626,1114010,1105145,1114612,1070928,1123865)