Need help understanding Slow Query Log

Here’s the output from tonights running of the MySql slow query log at my host, MediaTemple. I’m having a difficult time understanding which query is slow. Is it a plugin (I use many, but just yesterday the blog text would load in 5 seconds (ads and twitter feed are of course slower).

I have 3,000 posts and 6,000 comments.

I’m also curious why https://tools.pingdom.com/?url=https://onlinedatingpost.com shows my main html page as taking up to 8 seconds to download.

Strange that some days it’s fast, others the page load can be 15 seconds total. I am on the Media Temple Grid Server so I know that I can run up against resource issues but this is an ongoing vexing problem. I’ve tried removing all plugins several times, doesn’t seem to help much.

Here is the slow query log:

### 5 Queries
### Total time: 33, Average time: 6.6
### Taking 6 , 6 , 6 , 7 , 8 seconds to complete
### Rows analyzed 6197, 6197, 6197, 6197 and 6197
SELECT ID, post_author, post_date, post_date_gmt, post_status, post_name, post_modified, post_modified_gmt, post_parent, post_type FROM wp_posts WHERE ( (post_status = ‘XXX’ AND (post_type = ‘XXX’ OR post_type = ‘XXX’)) OR (post_status = ‘XXX’ AND post_type = ‘XXX’) ) AND post_password=’XXX’ ORDER BY post_modified DESC;

SELECT ID, post_author, post_date, post_date_gmt, post_status, post_name, post_modified, post_modified_gmt, post_parent, post_type FROM wp_posts WHERE ( (post_status = ‘publish’ AND (post_type = ‘post’ OR post_type = ”)) OR (post_status = ‘publish’ AND post_type = ‘page’) ) AND post_password=” ORDER BY post_modified DESC;

### 1 Query
### Total time: 28, Average time: 28
### Taking 28 seconds to complete
### Rows analyzed 6736
SELECT /*!XXX SQL_NO_CACHE */ * FROM wp_comments;

SELECT /*!40001 SQL_NO_CACHE */ * FROM wp_comments;

### 1 Query
### Total time: 20, Average time: 20
### Taking 20 seconds to complete
### Rows analyzed 4899
SELECT /*!XXX SQL_NO_CACHE */ * FROM wp_posts;

SELECT /*!40001 SQL_NO_CACHE */ * FROM wp_posts;

### 1 Query
### Total time: 6, Average time: 6
### Taking 6 seconds to complete
### Rows analyzed 0
use dbXXX_onlinedatingpost;
SELECT option_name, option_value FROM wp_options WHERE autoload = ‘XXX’;

use db2873_onlinedatingpost;
SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’;

Any idea whats going on?

Ill try the W3 Total Cache this week, wanted to see if there was anything else I should do first.