面试终试技巧

页面:/news/view-430914/ | 耗时:0.6536 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=430914 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=430914 LIMIT 0,1
select * from tbl_Articles_sphinx where id=430914 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(87961,545305,412506,1171245,97219,1050609,440603,482919,466972,553017,1217439,372386,374074,422915,360160,405848,531944,399499,494957,441113,102967,398301,492703,483740,1075405,1062682,547391,478954,517755,457447) ORDER BY field (ArticleID,87961,545305,412506,1171245,97219,1050609,440603,482919,466972,553017,1217439,372386,374074,422915,360160,405848,531944,399499,494957,441113,102967,398301,492703,483740,1075405,1062682,547391,478954,517755,457447)