Referto Partita: Pazzeschi vs Red Devils
Pazzeschi
Red Devils
RISULTATO FINALE
77
97
1° Tempo
27
42
2° Tempo
20
30
3° Tempo
30
25
INVASIONI A MURO
1
3
Data e Luogo
Campionato
Campionato Eccellenza 2025/2026 A1
Giornata: 16
Giornata: 16
Data e Luogo
20-03-2026 21:00 - HitBall Arena
Arbitri
Primo Arbitro
Specchiulli Pier Paolo
Secondo Arbitro
Specchiulli Pier Paolo
Refertista
ASD Polaris
Sorteggio
Sorteggio Vinto Da
Red Devils
Scelta Sorteggio
Palla
Annotazioni
Refertista: Capitolo Sabrina
Progresso
Punteggi Individuali
Pazzeschi
-
Giacomo GarzaroTot.13
5
x21
x3
0
x AUTOHIT -
Andrea RigoniTot.24
6
x24
x3
0
x AUTOHIT -
Giuseppe MirraTot.13
5
x21
x3
0
x AUTOHIT -
Danilo SacchettoTot.5
1
x21
x3
0
x AUTOHIT -
Luca AmbrosinoTot.4
2
x20
x3
0
x AUTOHIT -
Antonio De RosaTot.18
6
x22
x3
1
x AUTOHIT
Red Devils
-
Mattia Vazzoler
3
x20
x3
0
x AUTOHITTot.6
Gabriel Alessandro Delgrosso
2
x23
x3
0
x AUTOHITTot.13
Daniele Gennaro
2
x23
x3
0
x AUTOHITTot.13
Andrea Belcastro
8
x22
x3
0
x AUTOHITTot.22
Riccardo Simini
3
x22
x3
0
x AUTOHITTot.12
Federico Garrone
9
x20
x3
0
x AUTOHITTot.18
Davide Salvaggio
3
x22
x3
0
x AUTOHITTot.12
Total Queries: 55
Total Time: 0.38149094581604
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786249287.3747
[end] => 1786249287.375
[time] => 0.00034999847412109
)
[1] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.3773
[end] => 1786249287.3776
[time] => 0.00029897689819336
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.3777
[end] => 1786249287.3801
[time] => 0.0024020671844482
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.3802
[end] => 1786249287.3932
[time] => 0.013036966323853
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.3936
[end] => 1786249287.3961
[time] => 0.0024919509887695
)
[5] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.3962
[end] => 1786249287.3965
[time] => 0.00023198127746582
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.3965
[end] => 1786249287.3989
[time] => 0.0024240016937256
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.399
[end] => 1786249287.4118
[time] => 0.012819051742554
)
[8] => 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' AND team_id in (18,21) ORDER BY lastname,firstname ASC
[start] => 1786249287.4123
[end] => 1786249287.4133
[time] => 0.0010550022125244
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786249287.4142
[end] => 1786249287.4146
[time] => 0.00041389465332031
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786249287.4151
[end] => 1786249287.4153
[time] => 0.00025677680969238
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786249287.4154
[end] => 1786249287.416
[time] => 0.00062012672424316
)
[12] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.4165
[end] => 1786249287.4168
[time] => 0.00030303001403809
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.4168
[end] => 1786249287.4192
[time] => 0.0024018287658691
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.4193
[end] => 1786249287.432
[time] => 0.012765884399414
)
[15] => Array
(
[query] => select * from match_roster where match_id = '4032'
[start] => 1786249287.4323
[end] => 1786249287.4405
[time] => 0.0081119537353516
)
[16] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.4406
[end] => 1786249287.4408
[time] => 0.00023913383483887
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.4408
[end] => 1786249287.4433
[time] => 0.0024058818817139
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.4433
[end] => 1786249287.456
[time] => 0.012693166732788
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4032' and (point.point = 'P' or point.point = 'E')
[start] => 1786249287.4585
[end] => 1786249287.5338
[time] => 0.075249910354614
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786249287.5339
[end] => 1786249287.5342
[time] => 0.00032711029052734
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786249287.5343
[end] => 1786249287.5346
[time] => 0.00026106834411621
)
[22] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.5346
[end] => 1786249287.5349
[time] => 0.00023508071899414
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.5349
[end] => 1786249287.5375
[time] => 0.0025689601898193
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.5376
[end] => 1786249287.5504
[time] => 0.012810945510864
)
[25] => Array
(
[query] => select * from match_roster where match_id = '4032'
[start] => 1786249287.5507
[end] => 1786249287.5588
[time] => 0.0080850124359131
)
[26] => 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 = '4032' group by player_id
[start] => 1786249287.5588
[end] => 1786249287.6064
[time] => 0.04756498336792
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '4032'
[start] => 1786249287.6065
[end] => 1786249287.6069
[time] => 0.00040507316589355
)
[28] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.607
[end] => 1786249287.6072
[time] => 0.0001981258392334
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.6072
[end] => 1786249287.6096
[time] => 0.0023770332336426
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.6096
[end] => 1786249287.6225
[time] => 0.012809991836548
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786249287.6228
[end] => 1786249287.623
[time] => 0.00024008750915527
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786249287.6231
[end] => 1786249287.6237
[time] => 0.00054097175598145
)
[33] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.6239
[end] => 1786249287.6241
[time] => 0.00020885467529297
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.6241
[end] => 1786249287.6265
[time] => 0.0023829936981201
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.6265
[end] => 1786249287.6395
[time] => 0.013027906417847
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '4032'
[start] => 1786249287.6398
[end] => 1786249287.6409
[time] => 0.0010600090026855
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786249287.641
[end] => 1786249287.6412
[time] => 0.00016403198242188
)
[38] => 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 = '4032' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786249287.6412
[end] => 1786249287.6414
[time] => 0.00020813941955566
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786249287.6415
[end] => 1786249287.6416
[time] => 0.00017499923706055
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786249287.6417
[end] => 1786249287.6419
[time] => 0.0001521110534668
)
[41] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.642
[end] => 1786249287.6422
[time] => 0.00017809867858887
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.6422
[end] => 1786249287.6446
[time] => 0.002371072769165
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.6446
[end] => 1786249287.6574
[time] => 0.012797832489014
)
[44] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.6578
[end] => 1786249287.6581
[time] => 0.00026392936706543
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.6581
[end] => 1786249287.6605
[time] => 0.0023670196533203
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.6605
[end] => 1786249287.6733
[time] => 0.012802124023438
)
[47] => Array
(
[query] => select * from match_roster where match_id = '4032'
[start] => 1786249287.6736
[end] => 1786249287.6816
[time] => 0.0080440044403076
)
[48] => Array
(
[query] => select * from point where match_id = '4032' order by point_id ASC
[start] => 1786249287.6817
[end] => 1786249287.7515
[time] => 0.069827795028687
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786249287.7523
[end] => 1786249287.7526
[time] => 0.00034809112548828
)
[50] => Array
(
[query] => select * from matches where match_id = '4032'
[start] => 1786249287.7527
[end] => 1786249287.7529
[time] => 0.00022506713867188
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4032'
[start] => 1786249287.7529
[end] => 1786249287.7553
[time] => 0.0024139881134033
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4032'
[start] => 1786249287.7554
[end] => 1786249287.7681
[time] => 0.012761831283569
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786249287.7708
[end] => 1786249287.7712
[time] => 0.0004580020904541
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786249287.7721
[end] => 1786249287.7723
[time] => 0.00025701522827148
)
)