mysql 2秒 慢查询_2秒以上的MYSQL慢查询出来的一些数据，高手帮看一下怎么优化...

Count: 6  Time=14.91s (89s)  Lock=0.00s (0s)  Rows=4155435.2 (24932611), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_ucenter_members`

Count: 6  Time=3.69s (22s)  Lock=0.00s (0s)  Rows=4154733.5 (24928401), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_common_member_field_forum`

Count: 6  Time=6.12s (36s)  Lock=0.00s (0s)  Rows=4154733.5 (24928401), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_common_member_field_home`

Count: 6  Time=21.72s (130s)  Lock=0.00s (0s)  Rows=4154733.5 (24928401), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_common_member_profile`

Count: 6  Time=8.18s (49s)  Lock=0.00s (0s)  Rows=4154733.5 (24928401), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_common_member_status`

Count: 6  Time=9.77s (58s)  Lock=0.00s (0s)  Rows=4154733.5 (24928401), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_common_member_count`

Count: 6  Time=19.13s (114s)  Lock=0.00s (0s)  Rows=4152272.5 (24913635), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_common_member`

Count: 6  Time=2.46s (14s)  Lock=0.00s (0s)  Rows=3130240.8 (18781445), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_forum_attachment`

Count: 6  Time=11.12s (66s)  Lock=0.00s (0s)  Rows=1703289.0 (10219734), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_forum_post_tmp`

Count: 2  Time=2.26s (4s)  Lock=0.00s (0s)  Rows=4157801.5 (8315603), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_ucenter_memberfields`

Count: 6  Time=9.96s (59s)  Lock=0.00s (0s)  Rows=749347.3 (4496084), root[root]@localhost

SELECT /*!40001 SQL_NO_CACHE */ * FROM `mb_forum_thread`

Count: 1483  Time=2.33s (3462s)  Lock=0.00s (0s)  Rows=21.0 (31143), mbbbs_f[mbbbs_f]@localhost

SELECT DISTINCT t.*

FROM `mb_forum_thread` t

WHERE t.readperm='0'

AND t.special IN ('0') AND t.displayorder IN ('3') AND t.tid NOT IN ('8138820','13155402','10094767','8283673','10025650') AND t.isgroup='0'

AND t.displayorder>='0'

ORDER BY t.lastpost DESC

LIMIT 0,40

Count: 129  Time=70.93s (9150s)  Lock=0.00s (0s)  Rows=8.0 (1032), mbbbs_f[mbbbs_f]@localhost

SELECT * FROM mb_forum_post WHERE tid=7049623 AND `invisible`='0' AND `authorid`='1369075' ORDER BY dateline  LIMIT 15

Count: 326  Time=78.01s (25432s)  Lock=0.00s (0s)  Rows=2.0 (652), mbbbs_f[mbbbs_f]@localhost

SELECT * FROM mb_forum_post WHERE tid=174051 AND `invisible`='0' AND `authorid`='9016' ORDER BY dateline  LIMIT 15

一周的完整的TXT文件，见附件。

那位大神帮看看，如何优化配置。谢谢。