数据库的优化包括哪些方面呀

页面:/news/view-2101046/ | 耗时:0.6578 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=2101046 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2101046 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2101046 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1108522,1102738,1103348,1091197,1083461,1068774,1048878,1094079,1094607,1090835,1042114,1055361,1067207,1370914,1072138,1055718,1105605,1080913,1095928,1108976,1092331,1489308,1130158,1087485,1494417,1042879,1104266,1060817,1083530,1126815) ORDER BY field (ArticleID,1108522,1102738,1103348,1091197,1083461,1068774,1048878,1094079,1094607,1090835,1042114,1055361,1067207,1370914,1072138,1055718,1105605,1080913,1095928,1108976,1092331,1489308,1130158,1087485,1494417,1042879,1104266,1060817,1083530,1126815)