产品经理面试时遇到的问题

页面:/news/view-2575522/ | 耗时:0.3926 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2575522 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2575522 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2575522 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1126414,1058958,1077826,1101745,1105502,1067505,1113507,1089820,1082310,1081277,1117722,1088974,1100527,1086434,1088906,1109671,1104266,1084427,995175,1097667,1077490,1078903,1101921,1117207,1103971,1086832,1016441,1072831,1104855,1047637) ORDER BY field (ArticleID,1126414,1058958,1077826,1101745,1105502,1067505,1113507,1089820,1082310,1081277,1117722,1088974,1100527,1086434,1088906,1109671,1104266,1084427,995175,1097667,1077490,1078903,1101921,1117207,1103971,1086832,1016441,1072831,1104855,1047637)