Referto Partita: Dracarys Chivasso vs Sheet
Dracarys Chivasso
Sheet
RISULTATO FINALE
51
80
1° Tempo
15
29
2° Tempo
16
27
3° Tempo
20
24
INVASIONI A MURO
0
0
Data e Luogo
Evento
Playout 2022
Data e Luogo
26-05-2022 20:30 - Palazzeschi
Arbitri
Primo Arbitro
Riccio Roberto
Secondo Arbitro
Centin Davide
Refertista
Principato Lucrezia
Sorteggio
Sorteggio Vinto Da
Dracarys Chivasso
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Dracarys Chivasso
-
Marcello SaporitoTot.8
4
x20
x3
0
x AUTOHIT -
Gaetano RendineTot.25
11
x21
x3
0
x AUTOHIT -
Ivano ReatoTot.4
2
x20
x3
0
x AUTOHIT -
Davide BaldusTot.4
2
x20
x3
0
x AUTOHIT -
Antonio D'ElicioTot.0
0
x20
x3
0
x AUTOHIT -
Manuel SpataforaTot.10
5
x20
x3
0
x AUTOHIT
Sheet
-
Andrea Lavalle
5
x20
x3
0
x AUTOHITTot.10
Cristina Rijillo
0
x20
x3
0
x AUTOHITTot.0
Daniele Demarchi
2
x20
x3
0
x AUTOHITTot.4
Stefano Benedetti
7
x22
x3
0
x AUTOHITTot.20
Carlo Pangallo
4
x22
x3
0
x AUTOHITTot.14
Filippo Venturini
8
x21
x3
0
x AUTOHITTot.19
Davide Salvaggio
5
x21
x3
0
x AUTOHITTot.13
Total Queries: 55
Total Time: 0.39945530891418
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770965928.826
[end] => 1770965928.8262
[time] => 0.00026392936706543
)
[1] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965928.8285
[end] => 1770965928.8307
[time] => 0.0022280216217041
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965928.8307
[end] => 1770965928.8351
[time] => 0.0043439865112305
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965928.8352
[end] => 1770965928.8618
[time] => 0.026637077331543
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965928.8622
[end] => 1770965928.8664
[time] => 0.0042068958282471
)
[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] => 1770965928.8666
[end] => 1770965928.8785
[time] => 0.011885166168213
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770965928.8841
[end] => 1770965928.8846
[time] => 0.00052714347839355
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770965928.8851
[end] => 1770965928.8867
[time] => 0.0016770362854004
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770965928.8868
[end] => 1770965928.8884
[time] => 0.0015749931335449
)
[9] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965928.8889
[end] => 1770965928.8891
[time] => 0.0002140998840332
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965928.8891
[end] => 1770965928.8938
[time] => 0.0046389102935791
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965928.8938
[end] => 1770965928.9179
[time] => 0.024096012115479
)
[12] => Array
(
[query] => select * from match_roster where match_id = '2255'
[start] => 1770965928.9182
[end] => 1770965928.9306
[time] => 0.01243782043457
)
[13] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965928.9308
[end] => 1770965928.931
[time] => 0.00026488304138184
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965928.931
[end] => 1770965928.9332
[time] => 0.0021049976348877
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965928.9332
[end] => 1770965928.946
[time] => 0.01276707649231
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2255' and (point.point = 'P' or point.point = 'E')
[start] => 1770965928.9482
[end] => 1770965929.0155
[time] => 0.067333936691284
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1770965929.0157
[end] => 1770965929.016
[time] => 0.00032401084899902
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1770965929.016
[end] => 1770965929.0162
[time] => 0.00017690658569336
)
[19] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965929.0163
[end] => 1770965929.0165
[time] => 0.00020194053649902
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965929.0165
[end] => 1770965929.0186
[time] => 0.0020999908447266
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965929.0187
[end] => 1770965929.0308
[time] => 0.012047052383423
)
[22] => Array
(
[query] => select * from match_roster where match_id = '2255'
[start] => 1770965929.031
[end] => 1770965929.0379
[time] => 0.0068628787994385
)
[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 = '2255' group by player_id
[start] => 1770965929.0379
[end] => 1770965929.0807
[time] => 0.042812824249268
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '2255'
[start] => 1770965929.0809
[end] => 1770965929.0813
[time] => 0.00039100646972656
)
[25] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965929.0814
[end] => 1770965929.0816
[time] => 0.00023102760314941
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965929.0816
[end] => 1770965929.0836
[time] => 0.0020291805267334
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965929.0837
[end] => 1770965929.0957
[time] => 0.01204514503479
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1770965929.096
[end] => 1770965929.0962
[time] => 0.00024294853210449
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1770965929.0963
[end] => 1770965929.0969
[time] => 0.0005958080291748
)
[30] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965929.0971
[end] => 1770965929.0973
[time] => 0.00025606155395508
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965929.0974
[end] => 1770965929.0994
[time] => 0.0020408630371094
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965929.0994
[end] => 1770965929.1116
[time] => 0.012120008468628
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '2255'
[start] => 1770965929.1118
[end] => 1770965929.1126
[time] => 0.00078701972961426
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1770965929.1127
[end] => 1770965929.1129
[time] => 0.00017809867858887
)
[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 = '2255' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1770965929.1129
[end] => 1770965929.1131
[time] => 0.00020885467529297
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1770965929.1132
[end] => 1770965929.1133
[time] => 0.00016903877258301
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1770965929.1134
[end] => 1770965929.1136
[time] => 0.00018095970153809
)
[38] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965929.1137
[end] => 1770965929.114
[time] => 0.00021910667419434
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965929.114
[end] => 1770965929.116
[time] => 0.0020158290863037
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965929.1161
[end] => 1770965929.1279
[time] => 0.011859893798828
)
[41] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965929.1282
[end] => 1770965929.1284
[time] => 0.00023007392883301
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965929.1284
[end] => 1770965929.1305
[time] => 0.0020368099212646
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965929.1305
[end] => 1770965929.1424
[time] => 0.011895179748535
)
[44] => Array
(
[query] => select * from match_roster where match_id = '2255'
[start] => 1770965929.1426
[end] => 1770965929.1494
[time] => 0.0067780017852783
)
[45] => Array
(
[query] => select * from point where match_id = '2255' order by point_id ASC
[start] => 1770965929.1494
[end] => 1770965929.2111
[time] => 0.061710119247437
)
[46] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965929.2116
[end] => 1770965929.212
[time] => 0.00035381317138672
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965929.212
[end] => 1770965929.2141
[time] => 0.0020909309387207
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965929.2141
[end] => 1770965929.2261
[time] => 0.011995792388916
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1770965929.2265
[end] => 1770965929.2268
[time] => 0.00028300285339355
)
[50] => Array
(
[query] => select * from matches where match_id = '2255'
[start] => 1770965929.2268
[end] => 1770965929.227
[time] => 0.00021004676818848
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2255'
[start] => 1770965929.2271
[end] => 1770965929.2291
[time] => 0.0020160675048828
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2255'
[start] => 1770965929.2291
[end] => 1770965929.241
[time] => 0.011883974075317
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770965929.2437
[end] => 1770965929.2441
[time] => 0.00043702125549316
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770965929.2449
[end] => 1770965929.2451
[time] => 0.00023603439331055
)
)