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

Parameters
Request Start Time: Fri Jul 29 15:03:19 PDT 2005
Request Completion Time: Fri Jul 29 15:03:19 PDT 2005
Request Duration: 22ms
IP: 172.31.0.5
Method: GET
URL: /jatt/tasks.do
Query: open=15184882
Request Parameters: (display)
open 15184882

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

Stages
StageTimeQueriesProcessing
 wattFilter* 22ms 7ms (6 queries) 15ms

Database Requests
Total Queries: 6
Total Time: 7ms
ID Duration Conn Command
1 (duplicated) 1ms 10594949 SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1

BINDS: {}
2 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: {}
3 (duplicates # 1) 1ms 10594949 SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1

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

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

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

BINDS: {}

Long running Database Requests
Total Queries: 6
Total Query Execution Time: 7ms
Average Query Execution Time: 1ms
Query # Query Text Duration # % of Total Query
exec Time #
Query # 4 SELECT user_id,amendment,unexpected,rank,description,pare... 3ms 0.42857142857142855
Query # 1 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 1ms 0.14285714285714285
Query # 2 SELECT t.id AS id, ws.stop AS stop FROM jatt_task A... 1ms 0.14285714285714285
Query # 3 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 1ms 0.14285714285714285
Query # 6 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.14285714285714285

Duplicate DB Requests
Total Queries: 6
Total Query Execution Time: 7ms
Average Query Execution Time: 1ms
Query # Query text Duplicates Total Query time % of Total Query
exec Time #
Query # 1 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 3 2ms 0.2857142857142857
Total 2 2ms 0.2857142857142857