Request Information |
|
| Trace Tools | Parameters | Headers | Stages | Database Requests | Execution Trace |
Parameters |
|
| Request Start Time: | Fri Jul 29 15:03:33 PDT 2005 |
| Request Completion Time: | Fri Jul 29 15:03:33 PDT 2005 |
| Request Duration: | 79ms |
| IP: | 172.31.0.5 |
| Method: | GET |
| URL: | /jatt/editPreferences.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/startWorkSession.do?task_id=3 |
| 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* | 79ms | 4ms (5 queries) | 75ms |
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 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: | 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 user_id,amendment,unexpected,rank,description,pare... | 1ms | 0.25 |
| Query # 3 | SELECT stop,start,task_id,comment,id FROM jatt_worksessio... | 1ms | 0.25 |
| Query # 5 | SELECT t.id AS id, ws.stop AS stop FROM jatt_task A... | 1ms | 0.25 |
| 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: | 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... | 4 | 1ms | 0.25 |
| Total | 2 | 1ms | 0.25 | |