提高效率的管理方法有哪些

页面:/news/view-1667565/ | 耗时:0.7590 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1667565 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1667565 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1667565 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1074851,1064249,993285,1122122,1091757,1130810,1068330,1094387,1067049,1074306,1086902,1089962,1064449,1092642,1090032,1122098,1055361,1091621,1058093,1049542,1126464,1071197,1124893,1067437,1093240,1109499,1076199,1085062,1096354,1084587) ORDER BY field (ArticleID,1074851,1064249,993285,1122122,1091757,1130810,1068330,1094387,1067049,1074306,1086902,1089962,1064449,1092642,1090032,1122098,1055361,1091621,1058093,1049542,1126464,1071197,1124893,1067437,1093240,1109499,1076199,1085062,1096354,1084587)