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

Parameters
Request Start Time: Fri Jul 29 15:03:21 PDT 2005
Request Completion Time: Fri Jul 29 15:03:21 PDT 2005
Request Duration: 129ms
IP: 172.31.0.5
Method: GET
URL: /jatt/editTask.do
Query: id=3
Request Parameters: (display)
id 3

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/tasks.do?open=15184882
user-agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040204 Galeon/1.3.12

Stages
StageTimeQueriesProcessing
 wattFilter* 127ms 9ms (11 queries) 118ms

Database Requests
Total Queries: 11
Total Time: 9ms
ID Duration Conn Command
1 (duplicated) 1ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3

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

BINDS: {}
3 (duplicated) 1ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE parent_id=3 ORDER BY rank

BINDS: {}
4 1ms 10594949 SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1

BINDS: {}
5 0ms 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: {}
6 (duplicates # 1) 1ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3

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

BINDS: {}
8 (duplicates # 1) 0ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3

BINDS: {}
9 (duplicates # 3) 1ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE parent_id=3 ORDER BY rank

BINDS: {}
10 (duplicates # 1) 1ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3

BINDS: {}
11 (duplicates # 2) 1ms 10594949 SELECT stop,start,task_id,comment,id FROM jatt_worksession WHERE task_id=3 ORDER BY start DESC

BINDS: {}

Long running Database Requests
Total Queries: 11
Total Query Execution Time: 9ms
Average Query Execution Time: 0ms
Query # Query Text Duration # % of Total Query
exec Time #
Query # 1 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.1111111111111111
Query # 2 SELECT stop,start,task_id,comment,id FROM jatt_worksessio... 1ms 0.1111111111111111
Query # 3 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.1111111111111111
Query # 4 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 1ms 0.1111111111111111
Query # 6 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.1111111111111111
Query # 7 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.1111111111111111
Query # 9 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.1111111111111111
Query # 10 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.1111111111111111
Query # 11 SELECT stop,start,task_id,comment,id FROM jatt_worksessio... 1ms 0.1111111111111111

Duplicate DB Requests
Total Queries: 11
Total Query Execution Time: 9ms
Average Query Execution Time: 0ms
Query # Query text Duplicates Total Query time % of Total Query
exec Time #
Query # 1 SELECT user_id,amendment,unexpected,rank,description,pare... 6 8 10 3ms 0.3333333333333333
Query # 3 SELECT user_id,amendment,unexpected,rank,description,pare... 9 2ms 0.2222222222222222
Query # 2 SELECT stop,start,task_id,comment,id FROM jatt_worksessio... 11 2ms 0.2222222222222222
Total 8 7ms 0.7777777777777778