Referto Partita: Hitbusters vs Nomadi Venaria
Hitbusters
Nomadi Venaria
RISULTATO FINALE
85
86
1° Tempo
17
23
2° Tempo
36
32
3° Tempo
32
31
INVASIONI A MURO
3
1
Data e Luogo
Campionato
Campionato Eccellenza 2024/2025 B1
Giornata: 16
Giornata: 16
Data e Luogo
01-04-2025 21:35 - Frassati
Arbitri
Primo Arbitro
Botosso Daniele
Secondo Arbitro
Specchiulli Pier Paolo
Refertista
ASD Sinombre
Sorteggio
Sorteggio Vinto Da
Nomadi Venaria
Scelta Sorteggio
Palla
Annotazioni
Refertista: Filippo Venturini
Progresso
Punteggi Individuali
Hitbusters
-
Simone GasbarroniTot.20
7
x22
x3
0
x AUTOHIT -
Alessandro CaivanoTot.7
2
x21
x3
2
x AUTOHIT -
Luca Maria MercurioTot.17
4
x23
x3
0
x AUTOHIT -
Justin OssaiTot.21
6
x23
x3
0
x AUTOHIT -
Riccardo AjassaTot.0
0
x20
x3
0
x AUTOHIT -
Noemi CastelluccioTot.0
0
x20
x3
0
x AUTOHIT -
Daniele TessarinTot.20
7
x22
x3
0
x AUTOHIT
Nomadi Venaria
-
Paolo Mellano
6
x20
x3
0
x AUTOHITTot.12
Martina Bracesco
1
x20
x3
0
x AUTOHITTot.2
Gabriele Cappero
10
x21
x3
0
x AUTOHITTot.23
Sabrina Zanfretta
1
x20
x3
0
x AUTOHITTot.2
Federico Zoccarato
4
x26
x3
0
x AUTOHITTot.26
Lorenzo Zezza
8
x21
x3
0
x AUTOHITTot.19
Total Queries: 55
Total Time: 1.6879262924194
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781160979.5505
[end] => 1781160979.5587
[time] => 0.0082550048828125
)
[1] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160979.5683
[end] => 1781160979.5729
[time] => 0.0046219825744629
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160979.5729
[end] => 1781160979.5815
[time] => 0.008552074432373
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160979.5816
[end] => 1781160979.6316
[time] => 0.050001859664917
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160979.632
[end] => 1781160979.6481
[time] => 0.016111850738525
)
[5] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160979.6482
[end] => 1781160979.6484
[time] => 0.00021982192993164
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160979.6484
[end] => 1781160979.6554
[time] => 0.0069770812988281
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160979.6554
[end] => 1781160979.7118
[time] => 0.05634593963623
)
[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 (13,47) ORDER BY lastname,firstname ASC
[start] => 1781160979.7122
[end] => 1781160979.7132
[time] => 0.0010371208190918
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781160979.7171
[end] => 1781160979.7221
[time] => 0.0050539970397949
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781160979.7226
[end] => 1781160979.7259
[time] => 0.0033469200134277
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781160979.726
[end] => 1781160979.734
[time] => 0.0079860687255859
)
[12] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160979.7344
[end] => 1781160979.7371
[time] => 0.0026369094848633
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160979.7371
[end] => 1781160979.7485
[time] => 0.011457920074463
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160979.7486
[end] => 1781160979.7944
[time] => 0.045785903930664
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3824'
[start] => 1781160979.7947
[end] => 1781160979.8301
[time] => 0.03542685508728
)
[16] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160979.8302
[end] => 1781160979.8305
[time] => 0.00024580955505371
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160979.8305
[end] => 1781160979.8384
[time] => 0.0078959465026855
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160979.8385
[end] => 1781160979.8916
[time] => 0.053115844726562
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3824' and (point.point = 'P' or point.point = 'E')
[start] => 1781160979.8941
[end] => 1781160980.3124
[time] => 0.41835594177246
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781160980.3125
[end] => 1781160980.3128
[time] => 0.00028300285339355
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781160980.3129
[end] => 1781160980.3131
[time] => 0.00020003318786621
)
[22] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160980.3132
[end] => 1781160980.3134
[time] => 0.00022006034851074
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160980.3134
[end] => 1781160980.3242
[time] => 0.010808944702148
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160980.3243
[end] => 1781160980.3747
[time] => 0.050408124923706
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3824'
[start] => 1781160980.375
[end] => 1781160980.4139
[time] => 0.038941860198975
)
[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 = '3824' group by player_id
[start] => 1781160980.414
[end] => 1781160980.6151
[time] => 0.20109391212463
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3824'
[start] => 1781160980.6152
[end] => 1781160980.6155
[time] => 0.00031590461730957
)
[28] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160980.6156
[end] => 1781160980.6159
[time] => 0.00024104118347168
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160980.6159
[end] => 1781160980.6242
[time] => 0.0082969665527344
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160980.6242
[end] => 1781160980.6859
[time] => 0.061666965484619
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781160980.6863
[end] => 1781160980.6898
[time] => 0.0034909248352051
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781160980.6899
[end] => 1781160980.6943
[time] => 0.0044479370117188
)
[33] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160980.6946
[end] => 1781160980.6948
[time] => 0.00028109550476074
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160980.6949
[end] => 1781160980.7034
[time] => 0.0085220336914062
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160980.7035
[end] => 1781160980.7595
[time] => 0.056088924407959
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3824'
[start] => 1781160980.7598
[end] => 1781160980.7649
[time] => 0.0050928592681885
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781160980.7651
[end] => 1781160980.7689
[time] => 0.0038068294525146
)
[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 = '3824' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781160980.7689
[end] => 1781160980.7691
[time] => 0.00023198127746582
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781160980.7692
[end] => 1781160980.7696
[time] => 0.0003659725189209
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781160980.7696
[end] => 1781160980.7717
[time] => 0.0020768642425537
)
[41] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160980.7719
[end] => 1781160980.7749
[time] => 0.0029959678649902
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160980.7749
[end] => 1781160980.7836
[time] => 0.0086209774017334
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160980.7836
[end] => 1781160980.8388
[time] => 0.055145025253296
)
[44] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160980.8391
[end] => 1781160980.8439
[time] => 0.0047540664672852
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160980.8439
[end] => 1781160980.8507
[time] => 0.0068449974060059
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160980.8508
[end] => 1781160980.8883
[time] => 0.037467956542969
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3824'
[start] => 1781160980.8885
[end] => 1781160980.9186
[time] => 0.030066967010498
)
[48] => Array
(
[query] => select * from point where match_id = '3824' order by point_id ASC
[start] => 1781160980.9187
[end] => 1781160981.1988
[time] => 0.28014898300171
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781160981.1994
[end] => 1781160981.2027
[time] => 0.0033621788024902
)
[50] => Array
(
[query] => select * from matches where match_id = '3824'
[start] => 1781160981.2028
[end] => 1781160981.203
[time] => 0.00020289421081543
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3824'
[start] => 1781160981.203
[end] => 1781160981.2084
[time] => 0.0053250789642334
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3824'
[start] => 1781160981.2084
[end] => 1781160981.2518
[time] => 0.043352127075195
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781160981.2565
[end] => 1781160981.2581
[time] => 0.001643180847168
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781160981.259
[end] => 1781160981.2667
[time] => 0.0076828002929688
)
)