面试优缺点漂亮回答

页面:/news/view-3431293/ | 耗时:0.4951 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3431293 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3431293 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3431293 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1256698,3952364,458755,3891056,3357517,3873827,1251682,715712,1553828,608687,4073812,1223611,3484662,417210,2347736,3352569,939684,510562,772975,943658,365326,890208,3938747,398755,82438,832263,1251343,2344951,1245370,2736776) ORDER BY field (ArticleID,1256698,3952364,458755,3891056,3357517,3873827,1251682,715712,1553828,608687,4073812,1223611,3484662,417210,2347736,3352569,939684,510562,772975,943658,365326,890208,3938747,398755,82438,832263,1251343,2344951,1245370,2736776)