I'm looking for some help to read mysql_slow_queries log files so I can optimize some scripts. I'm including some random entries. Any help reading these, or does anyone know of a FAQ that could help?

# Sat Mar 8 04:16:37 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
use shireweb_enewspf;
SELECT * FROM jos_redirection WHERE `oldurl` = 'commentary/index.php' AND `newurl` != '' LIMIT 1

# Sat Mar 8 04:45:58 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 4
use shireweb_wrdp1;
SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 26 ) AND taxonomy = 'link_category' ORDER BY link_name ASC

# Sat Mar 8 04:46:05 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 3 Rows_examined: 298
use shireweb_enewspf;
SELECT * FROM jos_content
WHERE catid=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
AND state = 1
ORDER BY created DESC
LIMIT 3