Request Information

Trace Tools Parameters | Headers | Stages | Database Requests | Execution Trace

Parameters

Request Start Time: Fri Jul 29 15:03:35 PDT 2005
Request Completion Time: Fri Jul 29 15:03:35 PDT 2005
Request Duration: 66ms
IP: 172.31.0.5
Method: GET
URL: /jatt/reports.do
Query:
Request Parameters: (display)

HTTP Request Headers

accept text/xml, application/xml, application/xhtml+xml, text/html;q=0.9, text/plain;q=0.8, image/png, image/jpeg, image/gif;q=0.2, */*;q=0.1
accept-charset ISO-8859-15, utf-8;q=0.7, *;q=0.7
accept-language en, de;q=0.5
connection close
cookie JSESSIONID=156AB647C98876B3FB52357C26D788CE
host tomcat.example.com
referer http://tomcat.example.com/jatt/editPreferences.do
user-agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040204 Galeon/1.3.12

Stages

StageTimeQueriesProcessing
 wattFilter* 66ms 3ms (5 queries) 63ms

Database Requests

Total Queries: 5
Total Time: 3ms
ID Duration Conn Command
1 (duplicated) 0ms 10594949 SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1

BINDS: {}
2 1ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3

BINDS: {}
3 1ms 10594949 SELECT stop,start,task_id,comment,id FROM jatt_worksession WHERE task_id=3 ORDER BY start DESC

BINDS: {}
4 (duplicates # 1) 0ms 10594949 SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1

BINDS: {}
5 1ms 10594949 SELECT t.id AS id, ws.stop AS stop FROM jatt_task AS t INNER JOIN jatt_worksession AS ws ON ws.task_id = t.id WHERE t.user_id = 1 ORDER BY ws.stop DESC;

BINDS: {}

Long running Database Requests

Total Queries: 5
Total Query Execution Time: 3ms
Average Query Execution Time: 0ms
Query # Query Text Duration # % of Total Query
exec Time #
Query # 2 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.3333333333333333
Query # 3 SELECT stop,start,task_id,comment,id FROM jatt_worksessio... 1ms 0.3333333333333333
Query # 5 SELECT t.id AS id, ws.stop AS stop FROM jatt_task A... 1ms 0.3333333333333333
Query # 1 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 0ms 0.0
Query # 4 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 0ms 0.0

Duplicate DB Requests

Total Queries: 5
Total Query Execution Time: 3ms
Average Query Execution Time: 0ms
Query # Query text Duplicates Total Query time % of Total Query
exec Time #
Query # 1 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 4 0ms 0.0
Total 2 0ms 0.0