Heavy Database load? (Problematic query)

Had my Drupal database turned off by my server.

Had a super high traffic day.

Was this mod the culprit or a combo?

Problematic query:
SELECT DISTINCT node.nid AS nid,
node.title AS node_title,
COALESCE(radioactivity_node_1_s.energy,0) AS radioactivity_node_1_s_energy_sortkey
FROM node node
LEFT JOIN radioactivity radioactivity_node_1_s ON node.nid = radioactivity_node_1_s.id AND (radioactivity_node_1_s.class = 'node' AND radioactivity_node_1_s.decay_profile = 1)
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.status <> 0) AND (node.type in ('all', 'articles', 'dast', 'glmovie', 'moviearticles', 'movienews', 'moviereviews', 'movietrailers', 'news', 'podcast', 'previews', 'reviews', 'rtp'))
)ORDER BY radioactivity_node_1_s_energy_sortkey DESC
LIMIT 0, 5

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE na ALL PRIMARY 29374 Using where; Using temporary; Using filesort
1 SIMPLE node eq_ref PRIMARY,node_status_type,node_type PRIMARY 4 cos0925007480493.na.nid 1 Using where
1 SIMPLE radioactivity_node_1_s eq_ref PRIMARY PRIMARY 31 cos0925007480493.na.nid,const,const 1

This query examines 29374 rows, which is unacceptable in shared hosting.