Did I mention forum preview is broken?. Apparently preview did not like my content (it was too large), so it just cut it down in half. Either way, here are the other two queries in full beauty.

812 ms       select       dbqd.www.templates.widgets.postings.messages_select: select nsdb0

select fm.message_id,
      fm.forum_id,
      ff.name as forum_name,
      fm.subject

from (select message_id,
            forum_id,
            subject,
            parent_id,
            posting_date,
            last_child_post
      from forums_messages_approved
      order by last_child_post desc)  fm, forums_forums ff

where fm.forum_id = ff.forum_id
and fm.parent_id is null
and ff.package_id = 3061
and ff.forum_id <> 46408
--and ff.package_id = 3928
and ff.enabled_p='t'
-- and last_child_post > (current_timestamp - 7)
--order by forum_name
limit 11


###################

664 ms       select       dbqd.edit-this-page.tcl.etp-procs.etp::get_content_items.get_content_items: select nsdb0

select * from
  (select
  i.item_id, i.name, tree_sortkey as sort_order,
  to_char(r.publish_date, 'Mon DD, YYYY') as publish_date,
  (select object_type from acs_objects
    where object_id = i.item_id) as object_type,
          etp__get_relative_url(i.item_id, i.name) as url,
          etp__get_title(i.item_id, r.title) as title,
          etp__get_description(i.item_id, r.description) as description

  from cr_items i left join cr_revisions r on (i.live_revision = r.revision_id)
  where i.parent_id = etp__get_folder_id('4053') and i.name != 'index'
  ) attributes
where
1 = 1

order by
  sort_order

limit 4