There is a severe flaw for high traffic website.

This query is called for every comment view and the tables seesmic_videos and seesmic_comments are not indexed correctly. For this query you should add an index on seesmic_video_id on the table seesmic_comment

SELECT dsvid FROM {seesmic_videos} sv INNER JOIN {seesmic_comments} sc ON sv.seesmic_video_id = sc.seesmic_video_id WHERE sc.cid = %d