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 |