Referto Partita: Hammers vs Sporting Team Furious
Hammers
Sporting Team Furious
RISULTATO FINALE
78
68
1° Tempo
10
17
2° Tempo
27
28
3° Tempo
41
23
INVASIONI A MURO
0
3
Data e Luogo
Campionato
Campionato Eccellenza 2024/2025 B1
Giornata: 1
Giornata: 1
Data e Luogo
15-10-2024 21:35 - Frassati
Arbitri
Primo Arbitro
Botosso Daniele
Secondo Arbitro
Antonucci Marco
Refertista
ASD Sinombre
Sorteggio
Sorteggio Vinto Da
Hammers
Scelta Sorteggio
Palla
Annotazioni
Refertista: Lisa portarulo
Progresso
Punteggi Individuali
Hammers
-
Sabrina CapitoloTot.4
2
x20
x3
0
x AUTOHIT -
Davide CentinTot.18
6
x22
x3
0
x AUTOHIT -
Gabriele SalernoTot.20
7
x22
x3
0
x AUTOHIT -
Ivan RussoTot.8
4
x20
x3
0
x AUTOHIT -
Giovanni MarinoTot.25
11
x21
x3
0
x AUTOHIT -
Massimo SbanoTot.2
1
x20
x3
0
x AUTOHIT
Sporting Team Furious
-
Carlo Del console
4
x20
x3
0
x AUTOHITTot.8
Matteo Barberis
7
x21
x3
0
x AUTOHITTot.17
Stefano Falvo
5
x23
x3
0
x AUTOHITTot.19
Andrea Giannitti
6
x22
x3
1
x AUTOHITTot.18
Vincenzo Padula
1
x20
x3
0
x AUTOHITTot.2
Arianna Vismara
2
x20
x3
0
x AUTOHITTot.4
Total Queries: 55
Total Time: 1.1710629463196
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781164659.1614
[end] => 1781164659.1668
[time] => 0.0053451061248779
)
[1] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.1734
[end] => 1781164659.1751
[time] => 0.0016732215881348
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.1751
[end] => 1781164659.182
[time] => 0.0068151950836182
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.182
[end] => 1781164659.2258
[time] => 0.043723106384277
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.2262
[end] => 1781164659.2442
[time] => 0.018010854721069
)
[5] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.2443
[end] => 1781164659.2449
[time] => 0.00058102607727051
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.2449
[end] => 1781164659.2508
[time] => 0.005950927734375
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.2509
[end] => 1781164659.2744
[time] => 0.023445844650269
)
[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 (34,4) ORDER BY lastname,firstname ASC
[start] => 1781164659.2748
[end] => 1781164659.2789
[time] => 0.004065990447998
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781164659.2842
[end] => 1781164659.2863
[time] => 0.0020828247070312
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781164659.2868
[end] => 1781164659.2898
[time] => 0.0030062198638916
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781164659.2899
[end] => 1781164659.2914
[time] => 0.0015029907226562
)
[12] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.2919
[end] => 1781164659.2927
[time] => 0.00085282325744629
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.2928
[end] => 1781164659.2982
[time] => 0.0054030418395996
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.2982
[end] => 1781164659.3256
[time] => 0.027405023574829
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3750'
[start] => 1781164659.3259
[end] => 1781164659.3594
[time] => 0.033458948135376
)
[16] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.3595
[end] => 1781164659.3619
[time] => 0.0024318695068359
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.3619
[end] => 1781164659.3692
[time] => 0.0072300434112549
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.3693
[end] => 1781164659.407
[time] => 0.037749052047729
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3750' and (point.point = 'P' or point.point = 'E')
[start] => 1781164659.4104
[end] => 1781164659.6277
[time] => 0.21728897094727
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781164659.6278
[end] => 1781164659.631
[time] => 0.0031900405883789
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781164659.6311
[end] => 1781164659.6317
[time] => 0.00062894821166992
)
[22] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.6318
[end] => 1781164659.6339
[time] => 0.0020670890808105
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.6339
[end] => 1781164659.6404
[time] => 0.0064570903778076
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.6405
[end] => 1781164659.6761
[time] => 0.035613059997559
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3750'
[start] => 1781164659.6764
[end] => 1781164659.7049
[time] => 0.028511047363281
)
[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 = '3750' group by player_id
[start] => 1781164659.7049
[end] => 1781164659.8499
[time] => 0.14498114585876
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3750'
[start] => 1781164659.85
[end] => 1781164659.8503
[time] => 0.00028395652770996
)
[28] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.8504
[end] => 1781164659.8508
[time] => 0.0004270076751709
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.8508
[end] => 1781164659.8588
[time] => 0.0079309940338135
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.8588
[end] => 1781164659.8996
[time] => 0.040814161300659
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781164659.9
[end] => 1781164659.9003
[time] => 0.00027990341186523
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781164659.9004
[end] => 1781164659.903
[time] => 0.0025889873504639
)
[33] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.9032
[end] => 1781164659.9069
[time] => 0.0037009716033936
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.9069
[end] => 1781164659.9113
[time] => 0.0044329166412354
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.9114
[end] => 1781164659.9464
[time] => 0.03502893447876
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3750'
[start] => 1781164659.9468
[end] => 1781164659.9521
[time] => 0.0053808689117432
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781164659.9522
[end] => 1781164659.9525
[time] => 0.00024104118347168
)
[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 = '3750' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781164659.9525
[end] => 1781164659.9528
[time] => 0.0002598762512207
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781164659.9529
[end] => 1781164659.9549
[time] => 0.002011775970459
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781164659.9549
[end] => 1781164659.9551
[time] => 0.00020503997802734
)
[41] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164659.9553
[end] => 1781164659.9556
[time] => 0.00022697448730469
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164659.9556
[end] => 1781164659.9624
[time] => 0.0068061351776123
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164659.9625
[end] => 1781164660.0019
[time] => 0.039422035217285
)
[44] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164660.0022
[end] => 1781164660.0063
[time] => 0.0041170120239258
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164660.0063
[end] => 1781164660.0107
[time] => 0.0043880939483643
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164660.0108
[end] => 1781164660.0512
[time] => 0.040454149246216
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3750'
[start] => 1781164660.0515
[end] => 1781164660.0778
[time] => 0.026257991790771
)
[48] => Array
(
[query] => select * from point where match_id = '3750' order by point_id ASC
[start] => 1781164660.0779
[end] => 1781164660.2964
[time] => 0.21857404708862
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781164660.297
[end] => 1781164660.299
[time] => 0.0019528865814209
)
[50] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1781164660.2991
[end] => 1781164660.3009
[time] => 0.0017929077148438
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1781164660.3009
[end] => 1781164660.3091
[time] => 0.0082578659057617
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1781164660.3092
[end] => 1781164660.3468
[time] => 0.037622928619385
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781164660.3504
[end] => 1781164660.3546
[time] => 0.0042788982391357
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781164660.3578
[end] => 1781164660.3616
[time] => 0.0038530826568604
)
)