Dramatic slow down in site speed

I've got a Drupal 6.13 installation that has really slowed down a lot over the last few days and I'm trying to figure out what is wrong. I've installed the latest security patches and installed and ran the DB Maintenance Module and the Devel Module.

The weird thing is that sometimes the site is nice and fast, and then without warning, it will grind to a halt and not load the pages for 45 or more seconds, if at all... then for no apparent reason it will revert to under 2 seconds to load.

I've contact the hosting provider (godaddy) and they swear the server is not having any issues and it not overloaded.

My caching mode is set to normal, Page compression enabled, Block cache enabled, Optimize CSS files enabled, Optimize JavaScript files enabled.

I'll post the Devel query below. If I refresh the page, I get totally different data though, so I'm a little stumped.

If anybody has some idea of what else I should be looking at I would appreciate the help.

Oh, the website address might help! http://www.appsaddicts.com

Thanks,
Janet

Executed 104 queries in 39296.05 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 41463.59 ms.
ms
#
where
query
0.55
1
module_list
SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC
2.21
1
drupal_get_filename
SELECT filename FROM system WHERE name = 'user' AND type = 'module'
7.36
1
drupal_lookup_path
SELECT COUNT(pid) FROM url_alias
0.92
1
module_list
SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
0.49
1
menu_get_item
SELECT * FROM menu_router WHERE path IN ('node') ORDER BY fit DESC LIMIT 0, 1
0.33
1
node_access_view_all_nodes
SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all')) AND grant_view >= 1
0.28
1
pager_query
SELECT COUNT(*) FROM node n WHERE n.promote = 1 AND n.status = 1
0.32
1
pager_query
SELECT n.nid, n.sticky, n.created FROM node n WHERE n.promote = 1 AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10
2.14
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'schema'
0.51
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 92
0.42
1
_node_types_build
SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
0.32
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 92
0.34
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 92 ORDER BY v.weight, t.weight, t.name
0.34
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 92 ORDER BY r.weight, f.fid
0.31
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 92
0.36
1
taxonomy_vocabulary_load
SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 2
0.4
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:b2f09018e0ca7adb90e8f9484209f71d'
0.47
1
list_themes
SELECT * FROM system WHERE type = 'theme'
1.14
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:appsaddicts'
0.39
1
taxonomy_vocabulary_load
SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 4
0.44
1
block_list
SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'appsaddicts' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
0.54
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 91
0.31
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 91
0.34
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 91 ORDER BY v.weight, t.weight, t.name
0.34
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 91 ORDER BY r.weight, f.fid
0.35
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 91
0.4
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:979a0e7d1c2eb329813c7affa6ad1707'
0.48
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 90
0.3
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 90
0.3
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 90 ORDER BY v.weight, t.weight, t.name
0.34
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 90 ORDER BY r.weight, f.fid
0.31
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 90
0.4
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:c1971f44a56eb132a87462518ab177d0'
0.5
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 89
0.36
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 89
0.36
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 89 ORDER BY v.weight, t.weight, t.name
1125.78
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 89 ORDER BY r.weight, f.fid
1846.87
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 89
1.43
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:6816cf2fc1dac2df21ae10bf856f67f0'
4.14
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 88
0.48
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 88
0.4
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 88 ORDER BY v.weight, t.weight, t.name
0.42
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 88 ORDER BY r.weight, f.fid
0.46
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 88
0.74
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:e5100ed62b6539098c696f52cc5d0d65'
0.65
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 87
0.34
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 87
0.32
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 87 ORDER BY v.weight, t.weight, t.name
0.38
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 87 ORDER BY r.weight, f.fid
0.36
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 87
0.41
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:6c9c6f0397e8d541e3990c2e8174f6df'
21.92
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 86
0.37
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 86
0.33
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 86 ORDER BY v.weight, t.weight, t.name
0.36
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 86 ORDER BY r.weight, f.fid
0.37
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 86
0.42
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:9304d9e738279f93099edb46c724b86a'
0.72
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 85
0.33
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 85
0.33
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 85 ORDER BY v.weight, t.weight, t.name
0.38
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 85 ORDER BY r.weight, f.fid
0.36
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 85
0.42
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:f2183055660c9f1a7e317379f78e1cd6'
1.06
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 84
0.46
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 84
0.43
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 84 ORDER BY v.weight, t.weight, t.name
0.45
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 84 ORDER BY r.weight, f.fid
0.44
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 84
0.52
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:95504a24cf3117264b2df13e0f9c0fee'
3.96
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 83
0.39
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 83
0.42
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 83 ORDER BY v.weight, t.weight, t.name
0.45
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 83 ORDER BY r.weight, f.fid
1200.53
1
ad_nodeapi
SELECT * FROM ads WHERE aid = 83
5.64
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:3ced753749402c589ee9fc8cb9c9eb89'
1946.44
1
system_region_list
SELECT info FROM system WHERE type = 'theme' AND name = 'appsaddicts'
3246.6
3
menu_get_menus
SELECT * FROM menu_custom ORDER BY title
1374.63
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:menu-sidebar-left:page-cid:node:1'
8429.16
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:menu-sidebar-left:tree-data:ea4e43f2c2d681ab9636d11a750138d1'
0.61
3
menu_get_menus
SELECT * FROM menu_custom ORDER BY title
2941.7
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:menu-articles:page-cid:node:1'
0.63
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:menu-articles:tree-data:4471dbea53c58d624af55837ca98039a'
893.42
1
menu_tree_check_access
SELECT n.nid FROM node n WHERE n.status = 1 AND n.nid IN (53, 57, 77)
1589.55
1
block_block
SELECT body, format FROM boxes WHERE bid = 4
953.5
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:3eea62e9107c086f6707baa0d72818af'
643.25
1
block_block
SELECT body, format FROM boxes WHERE bid = 1
0.81
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:643f14aeabe8f2c857f835a6871d31c2'
1871.96
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:navigation:page-cid:node:1'
37.05
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:navigation:tree-data:d4c39679b3207ffb02deca4962e290b6'
2731.1
2
user_load
SELECT * FROM users u WHERE uid = 1
0.58
2
user_load
SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
0.66
2
user_load
SELECT * FROM users u WHERE uid = 1
0.54
2
user_load
SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
3207.58
1
taxonomy_get_tree
SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE t.vid = 1 ORDER BY weight, name
0.48
3
menu_get_menus
SELECT * FROM menu_custom ORDER BY title
2386.67
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:secondary-links:page-cid:node:1'
4.11
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:secondary-links:tree-data:8f6dc78f5e804caae3e5db35794b7844'
2.35
1
menu_tree_check_access
SELECT n.nid FROM node n WHERE n.status = 1 AND n.nid IN (7, 38, 8)
694.38
1
menu_local_tasks
SELECT * FROM menu_router WHERE tab_root = 'node' ORDER BY weight, title
1305.29
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:page-cid:node:1'
0.79
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:tree-data:29b4016fb1aee48414f8a3631ee9784e'
0.34
1
menu_tree_check_access
SELECT n.nid FROM node n WHERE n.status = 1 AND n.nid IN (7, 38)
766.09
1
sess_write
UPDATE sessions SET uid = 1, cache = 0, hostname = '173.76.19.75', session = 'dblog_overview_filter|a:0:{}updates_remaining|a:0:{}node_overview_filter|a:0:{}', timestamp = 1250198907 WHERE sid = 'pmk7gde6bmi0di3e3747hvi501'
15.87
1
sess_write
UPDATE users SET access = 1250198908 WHERE uid = 1
Memory usage:
Memory used at: devel_init()=1.17 MB, devel_shutdown()=10.28 MB.