Request Information |
|
| Trace Tools | Parameters | Headers | Stages | Database Requests | Execution Trace |
Parameters |
|
| Request Start Time: | Fri Jul 29 15:01:32 PDT 2005 |
| Request Completion Time: | Fri Jul 29 15:01:32 PDT 2005 |
| Request Duration: | 38ms |
| IP: | 172.31.0.5 |
| Method: | GET |
| URL: | /jatt/tasks.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/login.do;jsessionid=156AB647C98876B3FB52357C26D788CE |
| user-agent | Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040204 Galeon/1.3.12 |
Stages |
|||
| Stage | Time | Queries | Processing |
|---|---|---|---|
| wattFilter* | 36ms | 4ms (5 queries) | 32ms |
Database Requests |
|||
| Total Queries: | 5 | ||
| Total Time: | 4ms | ||
| 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 | 1ms | 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=4
BINDS: {}
|
Long running Database Requests |
|||
| Total Queries: | 5 | ||
| Total Query Execution Time: | 4ms | ||
| Average Query Execution Time: | 0ms | ||
| Query # | Query Text | Duration # | % of Total Query exec Time # |
|---|---|---|---|
| Query # 1 | SELECT user_id,start,task_id,comment FROM jatt_worksessio... | 1ms | 0.25 |
| Query # 2 | SELECT t.id AS id, ws.stop AS stop FROM jatt_task A... | 1ms | 0.25 |
| Query # 3 | SELECT user_id,start,task_id,comment FROM jatt_worksessio... | 1ms | 0.25 |
| Query # 4 | SELECT user_id,amendment,unexpected,rank,description,pare... | 1ms | 0.25 |
| Query # 5 | SELECT user_id,amendment,unexpected,rank,description,pare... | 0ms | 0.0 |
Duplicate DB Requests |
||||
| Total Queries: | 5 | |||
| Total Query Execution Time: | 4ms | |||
| 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... | 3 | 2ms | 0.5 |
| Total | 2 | 2ms | 0.5 | |