This is an example developer support report, part of the Forums Performance article. The start of a message insert is highlighted below

Request Information

Your Workspace : Main Site : ds : Request Information

Parameters

Request Start Time: Wed Dec 11 12:27:38 2002
Request Completion Time: Wed Dec 11 12:27:43 2002
Request Duration: 5544 ms
IP: 127.0.0.1
Method: GET
URL: /qa/loader
Query: (empty)

Request Processor

Comments

Headers

Host: localhost:8080
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130
Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1
Accept-Language: en-us, en;q=0.66, de;q=0.33
Accept-Encoding: gzip, deflate, compress;q=0.9
Accept-Charset: ISO-8859-1, utf-8;q=0.66, *;q=0.66
Keep-Alive: 300
Connection: keep-alive
Cookie: ad_user_login=2599%20%7b900%200%20CE30D8A509C2E36DBE609E85AC3B1021AAE589B6%7d; ad_session_id=190101%2c2599%20%7b927%201039610837%2076859EFCFA62ABE922216633A9005D8EAF0321F0%7d

Output Headers

Server: AOLserver/3.3.1+ad13

Database Requests

  Duration    Pool  Command
  0 ms    subquery  gethandle (returned nsdb0)
  11 ms    subquery  dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p: 0or1row nsdb0
            select 1
            where 't' = acs_permission__permission_p(:object_id, :party_id, :privilege)
One message insert starts here.
  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id
  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id
  11 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email
  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)
  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
  164 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)
  3 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  1 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




message insert is done.


  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  3 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  34 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  1 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  4 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  30 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  21 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  9 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  32 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  41 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  0 ms    subquery  releasehandle nsdb0


  0 ms    subquery  gethandle (returned nsdb0)


  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::new.message_exists_p: 0or1row nsdb0
	  select count(message_id)
	  from forums_messages 
	  where message_id = :message_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  3 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  32 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  32 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  4 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  8 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  4 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  3 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  123 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  2 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  4 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  60 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  1 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  220 ms    subquery  dbqd.acs-tcl.tcl.community-core-procs.ad_user_new.user_insert: 0or1row nsdb0

	    select acs__add_user(
                         :user_id,
                         'user',
                         now(),
                         null,
	                 :peeraddr,
			 :email,
			 :url,
			 :first_names,
			 :last_name,
			 :hashed_password,
	                 :salt,
	                 :password_question,
	                 :password_answer,
                         null,
	                 :email_verified_p,
	                 :member_state);
	
      




  0 ms    subquery  releasehandle nsdb0


  0 ms    subquery  gethandle (returned nsdb0)


  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  2 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  63 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  0 ms    subquery  releasehandle nsdb0


  0 ms    subquery  gethandle (returned nsdb0)


  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::new.message_exists_p: 0or1row nsdb0
	  select count(message_id)
	  from forums_messages 
	  where message_id = :message_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  32 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  5 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  1 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  36 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  4 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  39 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  1 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  1 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  33 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  5 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  1 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  33 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  2 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  3 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  2 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        




  1 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        




  2 ms    subquery  dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id




  2 ms    subquery  dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    




  2 ms    subquery  dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    




  2 ms    subquery  dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)




  1 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    




  31 ms    subquery  dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      




  4 ms    subquery  dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      




  0 ms    subquery  getrow nsdb0




  5 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        




  4 ms    subquery  dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        




  3 ms    subquery  dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2