Taxonomy problems?? Causing SQL overloads – please help!!

Hi all, i am in need of some huge help here, i dont know much about php and sql commands but i keep getting flagged for sql overloads on my hosting plan and now some of my rather small blogs are havign this issue. it seems that the problem is relatign to a ‘taxonomy’ that is being performed. i tried to look at wordpress.org but still dont understand what exactly its used for

can anyone help me determine what is wrong based on this sql stat report. this seems to be the sql queries that overload my shared server

Most common queries were as follows:

Time: 14% (2506 sec) Amount: 16% (319 queries) Rows Examined/Sent: 7218 / 494 Avg. Query Exec/Lock Time: 7 / 0 sec.
use C251142_ratethistrack; SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’) AND tr.object_id IN (3031) ORDER BY t.name ASC;

Time: 10% (1714 sec) Amount: 10% (194 queries) Rows Examined/Sent: 23802 / 4756 Avg. Query Exec/Lock Time: 8 / 1 sec.
use C251142_djlounge; SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’) AND tr.object_id IN (2561) ORDER BY t.name ASC;

Time: 9% (1546 sec) Amount: 10% (205 queries) Rows Examined/Sent: 3019097 / 1992 Avg. Query Exec/Lock Time: 7 / 0 sec.
use C251142_djfreaks; SELECT p.ID, p.post_title, p.post_content,p.post_excerpt, p.post_date, p.comment_count, count(t_r.object_id) as cnt FROM wp_term_taxonomy t_t, wp_term_relationships t_r, wp_posts p WHERE t_t.taxonomy =’post_tag’ AND t_t.term_taxonomy_id = t_r.term_taxonomy_id AND t_r.object_id = p.ID AND (t_t.term_id IN (‘194′, ’56’, ’55’, ‘314’, ‘312’, ‘313’)) AND p.ID != 1126 AND p.post_status = ‘publish’ AND p.post_date_gmt < ‘2010-01-18 08:09:37’ GROUP BY t_r.object_id ORDER BY cnt DESC, p.post_date_gmt DESC LIMIT 10;

Time: 8% (1444 sec) Amount: 9% (177 queries) Rows Examined/Sent: 7385 / 7074 Avg. Query Exec/Lock Time: 8 / 0 sec.
use C251142_movie; SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (220,197,17,180,94,271,82,167,182,284);

Time: 5% (999 sec) Amount: 4% (90 queries) Rows Examined/Sent: 480090 / 430 Avg. Query Exec/Lock Time: 11 / 1 sec.
use C251142_freshdjmixes; SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.ID ASC LIMIT 0, 1;

Time: 4% (794 sec) Amount: 3% (75 queries) Rows Examined/Sent: 320449 / 276 Avg. Query Exec/Lock Time: 10 / 0 sec.
use C251142_djlounge; SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id IN (’28’) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1;

Time: 3% (543 sec) Amount: 2% (50 queries) Rows Examined/Sent: 19703 / 15265 Avg. Query Exec/Lock Time: 10 / 3 sec.
use C251142_chris; SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’;

Time: 2% (474 sec) Amount: 2% (45 queries) Rows Examined/Sent: 47625 / 45 Avg. Query Exec/Lock Time: 10 / 1 sec.
use C251142_justfordjs; SELECT p.* FROM wp_posts AS p WHERE p.post_date < ‘2009-12-23 08:00:00’ AND p.post_type = ‘post’ AND p.post_status = ‘publish’ ORDER BY p.post_date DESC LIMIT 1;

Time: 2% (447 sec) Amount: 2% (48 queries) Rows Examined/Sent: 155 / 155 Avg. Query Exec/Lock Time: 9 / 1 sec.
use C251142_clhfeeds; SELECT * FROM wp_gdsr_data_article WHERE post_id in (620, 2564, 1401, 4239, 4240, 2240, 2938, 3292, 2967, 3121);

thank you in advance for any help you can give with this matter. my sites greatly depend on your help 🙂