Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Calculation of a status life duration

Language: Layout:
View schema
Execution time: 3,06 sec, rows selected: 28, rows affected: 14, absolute service time: 3,27 sec, absolute service time: 3,26 sec  
latest |  history
   id message status_code stamp
1 1 1 0 10.01.2019 16:24:35
2 2 2 0 10.01.2019 16:24:35
3 3 3 0 10.01.2019 16:24:35
4 4 4 0 10.01.2019 16:24:35
5 5 5 0 10.01.2019 16:24:35
6 6 1 1 10.01.2019 16:24:36
7 7 2 1 10.01.2019 16:24:36
8 8 2 3 10.01.2019 16:24:37
9 9 3 3 10.01.2019 16:24:37
10 10 5 3 10.01.2019 16:24:37
11 11 1 4 10.01.2019 16:24:38
12 12 2 4 10.01.2019 16:24:38
13 13 3 4 10.01.2019 16:24:38
14 14 5 3 10.01.2019 16:24:38
   message status_code duration
1 1 0 1
2 1 1 2
3 1 4 0
4 2 0 1
5 2 1 1
6 2 3 1
7 2 4 0
8 3 0 2
9 3 3 1
10 3 4 0
11 4 0 3
12 5 0 2
13 5 3 1
14 5 3 0