Request Information

Your Workspace : Admin Home : Developer Support : Request Information

Parameters

Request Start Time: Thu Jun 01 10:49:16 2000 (959870956)
Request Completion Time: Thu Jun 01 10:49:20 2000 (959870960)
Request Duration: 4077 ms
Method: GET
URL: /intranet/ad-index
Query: (empty)

Headers

Connection: Keep-Alive
User-Agent: Mozilla/4.61 [en] (X11; U; Linux 2.2.12-20 i686)
Host: dev.arsdigita.com
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, image/png, */*
Accept-Encoding: gzip
Accept-Language: en
Accept-Charset: iso-8859-1,*,utf-8
Cookie: last_visit=959374634; ad_browser_id=4608; second_to_last_visit=959269200; ad_user_login=1472%2cISotUu64GyYZUPdBdNVRWMsdVnRaFzwG; ad_session_id=198622%2c1472%2cjbJ4dmbI8QQd5nSSobE%2e9c5H%2fQyOVs1v%2c959870956

Output Headers

Set-Cookie: last_visit=959870956; path=/; expires=Fri, 01-Jan-2010 01:00:00 GMT
Set-Cookie: second_to_last_visit=959374634; path=/; expires=Fri, 01-Jan-2010 01:00:00 GMT
MIME-Version: 1.0
Date: Thu, 01 Jun 2000 14:49:20 GMT
Server: AOLserver/3.0+ad2
Content-Type: text/html
Content-Length: 10715
Connection: close

Database Requests

  Duration  Command
  1 ms  gethandle -timeout -1 (returned nsdb0)
  13 ms  dml nsdb0 (main pool)
update session_statistics 
set session_count = session_count + 1, 
repeat_count = repeat_count + 1 
where entry_date = trunc(sysdate)
  124 ms  dml nsdb0 (main pool)
update users
set last_visit = sysdate,
    second_to_last_visit = last_visit,
    n_sessions = n_sessions + 1
where user_id = 1472
  1 ms  releasehandle nsdb0 (main pool)
  1 ms  gethandle (returned nsdb1)
  6 ms  1row nsdb1 (main pool)
select decode(count(1),0,0,1) 
               from user_group_map 
              where user_id=1472 
                and (group_id=6
                     or group_id=1181)
  1 ms  releasehandle nsdb1 (main pool)
  1 ms  gethandle (returned nsdb2)
  10 ms  0or1row nsdb2 (main pool)
select group_id 
from administration_info 
where module = 'intranet' 
and submodule is null
  13 ms  1row nsdb2 (main pool)
select count(*) from user_group_map where user_id =1472 and group_id = 2
  9 ms  0or1row nsdb2 (main pool)
select group_id 
from administration_info 
where module = 'site_wide' 
and submodule is null
  12 ms  1row nsdb2 (main pool)
select multi_role_p from user_groups where group_id = 1
  17 ms  1row nsdb2 (main pool)
select decode(count(*), 0, 0, 1) from user_group_map where user_id = 1472 and group_id = 1 and role in ('administrator', 'all')
  18 ms  0or1row nsdb2 (main pool)
select first_names || ' ' || last_name as full_name, 
                decode(portrait_upload_date,NULL,0,1) as portrait_exists_p
           from users 
          where user_id=1472
  1225 ms  select nsdb2 (main pool)
select ug.group_name, ug.group_id
           from user_groups ug, im_projects p
          where ad_group_member_p ( 1472, ug.group_id ) = 't'
            and ug.group_id=p.group_id
            and p.project_status_id in (select project_status_id
                                          from im_project_status 
                                         where project_status='Open' 
                                            or project_status='Future' )
          order by lower(group_name)
  1 ms  getrow nsdb2 t39 (main pool)
  2 ms  getrow nsdb2 t39 (main pool)
  1 ms  getrow nsdb2 t39 (main pool)
  1 ms  getrow nsdb2 t39 (main pool)
  1 ms  getrow nsdb2 t39 (main pool)
  2 ms  getrow nsdb2 t39 (main pool)
  1578 ms  select nsdb2 (main pool)
select ug.group_name, ug.group_id
           from user_groups ug, im_customers c
          where ad_group_member_p ( 1472, ug.group_id ) = 't'
            and ug.group_id=c.group_id
            and c.customer_status_id in (select customer_status_id 
                                          from im_customer_status 
                                         where customer_status in ('Current','Inquiries','Creating Bid','Bid out'))
          order by lower(group_name)
  2 ms  getrow nsdb2 t54 (main pool)
  30 ms  1row nsdb2 (main pool)
select sum(hours) from im_hours where user_id=1472
    and on_which_table='im_projects'
    and day >= sysdate - 7
  14 ms  1row nsdb2 (main pool)
select decode(count(1),0,0,1) 
           from user_groups ug
          where ad_group_member_p ( 1472, ug.group_id ) = 't'
            and ug.short_name='Business'
  15 ms  1row nsdb2 (main pool)
select decode(count(1),0,0,1) 
           from user_groups ug
          where ad_group_member_p ( 1472, ug.group_id ) = 't'
            and ug.short_name='Finance'
  5 ms  1row nsdb2 (main pool)
select sysdate - 30 from dual
  4 ms  select nsdb2 (main pool)
select newsgroup_id from newsgroups where scope = 'all_users' or scope = 'registered_users' or (scope = 'group' and group_id = 6)
  1 ms  getrow nsdb2 t71 (main pool)
  1 ms  getrow nsdb2 t71 (main pool)
  1 ms  getrow nsdb2 t71 (main pool)
  2 ms  getrow nsdb2 t71 (main pool)
  16 ms  select nsdb2 (main pool)
select news.title, news.news_item_id, news.approval_state, 
 expired_p(news.expiration_date) as expired_p, 
 to_char(news.release_date,'Mon DD, YYYY') as release_date_pretty
from news_items news, users ut
where creation_date > '2000-05-02'
and (newsgroup_id = 1 or newsgroup_id = 2 or newsgroup_id = 4)
and news.approval_state = 'approved'
and release_date < sysdate
and news.creation_user = ut.user_id
order by release_date desc, creation_date desc
  1 ms  getrow nsdb2 t82 (main pool)
  2 ms  getrow nsdb2 t82 (main pool)
  1 ms  getrow nsdb2 t82 (main pool)
  2 ms  getrow nsdb2 t82 (main pool)
  2 ms  getrow nsdb2 t82 (main pool)
  137 ms  select nsdb2 (main pool)
select g.group_name, g.group_id
               from user_groups g, im_projects p, im_employees_active u, im_project_types
              where p.project_lead_id = u.user_id
                and p.project_type_id = im_project_types.project_type_id
                and p.group_id=g.group_id
                and p.requires_report_p='t'
         and u.user_id='1472'
         and p.project_status_id = (select project_status_id 
                                               from im_project_status
                                              where project_status='Open')
         and ( (lower(project_type) not in ('client - full service')
               and not exists  (select 1 
                                  from general_comments gc
                                 where gc.comment_date > sysdate - 7
                                   and on_which_table = 'user_groups'
                                   and on_what_id = p.group_id)) or (lower(project_type) in ('client - full service')
               and exists (select 1
                             from survsimp_surveys
                            where short_name in ('project_report'))
               and not exists (select 1
                                 from survsimp_responses
                                where survey_id=(select survey_id 
                                                   from survsimp_surveys
                                                  where short_name in ('project_report'))
                                  and submission_date > sysdate - 7
                                  and group_id=p.group_id)) )
  1 ms  getrow nsdb2 t96 (main pool)
  2 ms  getrow nsdb2 t96 (main pool)
  20 ms  select nsdb2 (main pool)
select distinct u.user_id
           from users_active u, user_group_map ugm
          where u.user_id = ugm.user_id
            and ugm.group_id = 6
            and u.portrait is not null
  1 ms  getrow nsdb2 t103 (main pool)
  3 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  52 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  4 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  3 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  4 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  8 ms  getrow nsdb2 t103 (main pool)
  16 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  1 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  2 ms  getrow nsdb2 t103 (main pool)
  33 ms  0or1row nsdb2 (main pool)
select u.first_names || ' ' || u.last_name as name, u.bio, u.skills, 
                    ug.group_name as office, ug.group_id as office_id
               from im_employees_active u, user_groups ug, user_group_map ugm
              where u.user_id = ugm.user_id(+)
                and ug.group_id = ugm.group_id
                and ug.parent_group_id = 5
                and u.user_id = 1678
                and rownum < 2
  12 ms  select nsdb2 (main pool)
select ug.group_id, ug.group_name, ai.url as ai_url
from  user_groups ug, administration_info ai
where ug.group_id = ai.group_id
and ad_group_member_p ( 1472, ug.group_id ) = 't'
  1 ms  getrow nsdb2 t207 (main pool)
  119 ms  getrow nsdb2 t207 (main pool)
  1 ms  releasehandle nsdb2 (main pool)
  1 ms  gethandle log (returned nsdb3)
  11 ms  1row nsdb3 (log pool)
select ad_group_member_p(1472, system_administrator_group_id) from dual
  1 ms  releasehandle nsdb3 (log pool)
  3678 ms  (total)

webmaster@dev.arsdigita.com

Last Modified: $Id: developer-support-example.html,v 1.2 2017/08/07 23:47:56 gustafn Exp $