Referto Partita: Decepticon vs Skoppiati
Decepticon
Skoppiati
RISULTATO FINALE
64
86
1° Tempo
27
15
2° Tempo
18
39
3° Tempo
19
32
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2022/2023 B1
Giornata: 7
Giornata: 7
Data e Luogo
14-01-2023 16:40 - Maritano
Arbitri
Primo Arbitro
Fontana Marco
Secondo Arbitro
Principato Lucrezia
Refertista
Principato Lucrezia
Sorteggio
Sorteggio Vinto Da
Decepticon
Scelta Sorteggio
Campo
Progresso
Punteggi Individuali
Decepticon
-
Enrico TestaTot.19
8
x21
x3
0
x AUTOHIT -
Riccardo ToppanTot.12
3
x22
x3
0
x AUTOHIT -
Giuseppe ArmannoTot.19
5
x23
x3
0
x AUTOHIT -
Simone GuglielmettoTot.0
0
x20
x3
0
x AUTOHIT -
Luca CavagliàTot.10
2
x22
x3
0
x AUTOHIT -
Stefano LavinoTot.4
2
x20
x3
0
x AUTOHIT -
Daniele BarbatoTot.0
0
x20
x3
0
x AUTOHIT
Skoppiati
-
Lennin Jarek Garcia
3
x21
x3
0
x AUTOHITTot.9
Matteo Bercan
4
x21
x3
0
x AUTOHITTot.11
Federico Suppo
3
x20
x3
0
x AUTOHITTot.6
Giovanni Marsico
5
x23
x3
0
x AUTOHITTot.19
Lorenzo Fontana
5
x20
x3
0
x AUTOHITTot.10
Riccardo Francabandiera
11
x23
x3
0
x AUTOHITTot.31
Total Queries: 55
Total Time: 1.5548963546753
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770979956.4956
[end] => 1770979956.4977
[time] => 0.002122163772583
)
[1] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979956.5002
[end] => 1770979956.5004
[time] => 0.0002129077911377
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979956.5004
[end] => 1770979956.5025
[time] => 0.0020859241485596
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979956.5026
[end] => 1770979956.5628
[time] => 0.060177087783813
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979956.5631
[end] => 1770979956.5702
[time] => 0.007094144821167
)
[5] => Array
(
[query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
left join player_to_team on (player.player_id = player_to_team.player_id) where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770979956.5704
[end] => 1770979956.587
[time] => 0.016619205474854
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770979956.5906
[end] => 1770979956.5928
[time] => 0.002169132232666
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770979956.5932
[end] => 1770979956.5935
[time] => 0.0002589225769043
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770979956.5936
[end] => 1770979956.5943
[time] => 0.00069212913513184
)
[9] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979956.5948
[end] => 1770979956.5969
[time] => 0.0021011829376221
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979956.5969
[end] => 1770979956.603
[time] => 0.0060679912567139
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979956.6031
[end] => 1770979956.6393
[time] => 0.036209106445312
)
[12] => Array
(
[query] => select * from match_roster where match_id = '2558'
[start] => 1770979956.6395
[end] => 1770979956.6564
[time] => 0.016880989074707
)
[13] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979956.6565
[end] => 1770979956.6629
[time] => 0.0063910484313965
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979956.663
[end] => 1770979956.671
[time] => 0.0080499649047852
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979956.6711
[end] => 1770979956.7188
[time] => 0.047711133956909
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2558' and (point.point = 'P' or point.point = 'E')
[start] => 1770979956.7219
[end] => 1770979957.0673
[time] => 0.34536600112915
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1770979957.0674
[end] => 1770979957.0789
[time] => 0.011511087417603
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1770979957.079
[end] => 1770979957.0792
[time] => 0.00018405914306641
)
[19] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979957.0793
[end] => 1770979957.0795
[time] => 0.00020980834960938
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979957.0795
[end] => 1770979957.0897
[time] => 0.01012396812439
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979957.0897
[end] => 1770979957.1582
[time] => 0.068413019180298
)
[22] => Array
(
[query] => select * from match_roster where match_id = '2558'
[start] => 1770979957.1584
[end] => 1770979957.1956
[time] => 0.037170886993408
)
[23] => Array
(
[query] =>
SELECT
player_id,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN point
END )
,0)
as attack,
COALESCE(
SUM(
CASE
WHEN point = '3' THEN point
END )
,0)
as defense,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN point
WHEN point = '3' THEN point
END )
,0)
as total,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN 1
END )
,0)
as hit_attack,
COALESCE(
SUM(
CASE
WHEN point = '3' THEN 1
END )
,0)
as hit_defense,
COALESCE(
SUM(
CASE
WHEN point = '2' THEN 1
WHEN point = '3' THEN 1
END )
,0)
as hit_total,
COALESCE(
SUM(
CASE
WHEN point = 'A' THEN 1
END )
,0)
as autohit
FROM point where match_id = '2558' group by player_id
[start] => 1770979957.1956
[end] => 1770979957.4398
[time] => 0.24416613578796
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '2558'
[start] => 1770979957.4399
[end] => 1770979957.4479
[time] => 0.0080130100250244
)
[25] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979957.448
[end] => 1770979957.4482
[time] => 0.00019502639770508
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979957.4483
[end] => 1770979957.4574
[time] => 0.0091259479522705
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979957.4575
[end] => 1770979957.5155
[time] => 0.058016061782837
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1770979957.5158
[end] => 1770979957.5161
[time] => 0.00027799606323242
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1770979957.5162
[end] => 1770979957.5193
[time] => 0.0031130313873291
)
[30] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979957.5195
[end] => 1770979957.5198
[time] => 0.00025200843811035
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979957.5198
[end] => 1770979957.5279
[time] => 0.0080549716949463
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979957.5279
[end] => 1770979957.5922
[time] => 0.064220905303955
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '2558'
[start] => 1770979957.5924
[end] => 1770979957.5932
[time] => 0.00081491470336914
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1770979957.5933
[end] => 1770979957.5959
[time] => 0.0025999546051025
)
[35] => Array
(
[query] => select penalty_to_staff.*, staff_penalty.cumulative from penalty_to_staff
inner join staff_penalty on (penalty_to_staff.staff_penalty_id = staff_penalty.staff_penalty_id)
where penalty_to_staff.match_id = '2558' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1770979957.5959
[end] => 1770979957.6017
[time] => 0.0057799816131592
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1770979957.6018
[end] => 1770979957.6021
[time] => 0.00021696090698242
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1770979957.6021
[end] => 1770979957.6023
[time] => 0.00016498565673828
)
[38] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979957.6025
[end] => 1770979957.6026
[time] => 0.00019288063049316
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979957.6027
[end] => 1770979957.6047
[time] => 0.0020480155944824
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979957.6048
[end] => 1770979957.6753
[time] => 0.070565938949585
)
[41] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979957.6756
[end] => 1770979957.6759
[time] => 0.00024080276489258
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979957.6759
[end] => 1770979957.6829
[time] => 0.0070548057556152
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979957.683
[end] => 1770979957.748
[time] => 0.064965009689331
)
[44] => Array
(
[query] => select * from match_roster where match_id = '2558'
[start] => 1770979957.7482
[end] => 1770979957.7828
[time] => 0.03459095954895
)
[45] => Array
(
[query] => select * from point where match_id = '2558' order by point_id ASC
[start] => 1770979957.7829
[end] => 1770979957.9901
[time] => 0.20724701881409
)
[46] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979957.9906
[end] => 1770979957.991
[time] => 0.00042390823364258
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979957.991
[end] => 1770979957.995
[time] => 0.004004955291748
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979957.9951
[end] => 1770979958.0265
[time] => 0.031450986862183
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1770979958.027
[end] => 1770979958.0273
[time] => 0.00031113624572754
)
[50] => Array
(
[query] => select * from matches where match_id = '2558'
[start] => 1770979958.0274
[end] => 1770979958.0276
[time] => 0.00020408630371094
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2558'
[start] => 1770979958.0276
[end] => 1770979958.032
[time] => 0.0044112205505371
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2558'
[start] => 1770979958.0321
[end] => 1770979958.0658
[time] => 0.033668041229248
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770979958.0705
[end] => 1770979958.071
[time] => 0.00043892860412598
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770979958.0717
[end] => 1770979958.072
[time] => 0.0002439022064209
)
)