面试中的相应技巧

页面:/news/view-655509/ | 耗时:0.4725 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=655509 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=655509 LIMIT 0,1
select * from tbl_Articles_sphinx where id=655509 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1126204,1109196,1104115,1116950,1096877,1114778,1117674,1070010,1114562,1108275,1087803,1068274,1111882,1121910,1108005,1115767,1071519,1125050,1103101,1098591,1055217,1099947,1066448,1120843,1118553,1120719,1104567,1093138,1111172,1092766) ORDER BY field (ArticleID,1126204,1109196,1104115,1116950,1096877,1114778,1117674,1070010,1114562,1108275,1087803,1068274,1111882,1121910,1108005,1115767,1071519,1125050,1103101,1098591,1055217,1099947,1066448,1120843,1118553,1120719,1104567,1093138,1111172,1092766)