Request Information |
|
| Trace Tools | Parameters | Headers | Stages | Database Requests | Execution Trace |
Parameters |
|||||||||
| Request Start Time: | Fri Jul 29 15:01:27 PDT 2005 | ||||||||
| Request Completion Time: | Fri Jul 29 15:01:29 PDT 2005 | ||||||||
| Request Duration: | 2033ms | ||||||||
| IP: | 172.31.0.5 | ||||||||
| Method: | POST | ||||||||
| URL: | /jatt/login.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 |
| content-length | 50 |
| content-type | application/x-www-form-urlencoded |
| cookie | JSESSIONID=156AB647C98876B3FB52357C26D788CE |
| host | tomcat.example.com |
| referer | http://tomcat.example.com/jatt/ |
| 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* | 2031ms | 26ms (8 queries) | 2005ms |
Database Requests |
|||
| Total Queries: | 8 | ||
| Total Time: | 26ms | ||
| ID | Duration | Conn | Command |
|---|---|---|---|
| 1 (duplicated) | 2ms | 10594949 |
SELECT password,login,email,admin,id FROM jatt_user WHERE login='admin'
BINDS: {}
|
| 2 (duplicates # 1) | 1ms | 10594949 |
SELECT password,login,email,admin,id FROM jatt_user WHERE login='admin'
BINDS: {}
|
| 3 | 19ms | 10594949 |
SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE user_id=1
BINDS: {}
|
| 4 (duplicated) | 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: {}
|
| 6 (duplicates # 4) | 1ms | 10594949 |
SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1
BINDS: {}
|
| 7 | 1ms | 10594949 |
SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=2
BINDS: {}
|
| 8 | 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: | 8 | ||
| Total Query Execution Time: | 26ms | ||
| Average Query Execution Time: | 3ms | ||
| Query # | Query Text | Duration # | % of Total Query exec Time # |
|---|---|---|---|
| Query # 3 | SELECT user_id,amendment,unexpected,rank,description,pare... | 19ms | 0.7307692307692307 |
| Query # 1 | SELECT password,login,email,admin,id FROM jatt_user WHERE... | 2ms | 0.07692307692307693 |
| Query # 2 | SELECT password,login,email,admin,id FROM jatt_user WHERE... | 1ms | 0.038461538461538464 |
| Query # 5 | SELECT t.id AS id, ws.stop AS stop FROM jatt_task A... | 1ms | 0.038461538461538464 |
| Query # 6 | SELECT user_id,start,task_id,comment FROM jatt_worksessio... | 1ms | 0.038461538461538464 |
Duplicate DB Requests |
||||
| Total Queries: | 8 | |||
| Total Query Execution Time: | 26ms | |||
| Average Query Execution Time: | 3ms | |||
| Query # | Query text | Duplicates | Total Query time | % of Total Query exec Time # |
|---|---|---|---|---|
| Query # 1 | SELECT password,login,email,admin,id FROM jatt_user WHERE... | 2 | 3ms | 0.11538461538461539 |
| Query # 4 | SELECT user_id,start,task_id,comment FROM jatt_worksessio... | 6 | 1ms | 0.038461538461538464 |
| Total | 4 | 4ms | 0.15384615384615385 | |