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: 0.38524198532104
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786257071.9391
[end] => 1786257071.9398
[time] => 0.00077581405639648
)
[1] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257071.9425
[end] => 1786257071.9427
[time] => 0.00025486946105957
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257071.9428
[end] => 1786257071.9455
[time] => 0.0027589797973633
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257071.9456
[end] => 1786257071.9607
[time] => 0.015098094940186
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257071.9611
[end] => 1786257071.9636
[time] => 0.0024981498718262
)
[5] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257071.9637
[end] => 1786257071.9639
[time] => 0.00024580955505371
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257071.9639
[end] => 1786257071.9663
[time] => 0.0023870468139648
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257071.9664
[end] => 1786257071.9794
[time] => 0.013050079345703
)
[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] => 1786257071.9799
[end] => 1786257071.9811
[time] => 0.0012238025665283
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786257071.9831
[end] => 1786257071.9836
[time] => 0.00045418739318848
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786257071.9841
[end] => 1786257071.9843
[time] => 0.00028395652770996
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786257071.9844
[end] => 1786257071.9852
[time] => 0.00073599815368652
)
[12] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257071.9857
[end] => 1786257071.9859
[time] => 0.00027298927307129
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257071.986
[end] => 1786257071.9884
[time] => 0.0023901462554932
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257071.9884
[end] => 1786257072.0012
[time] => 0.012801170349121
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3750'
[start] => 1786257072.0015
[end] => 1786257072.0095
[time] => 0.0080411434173584
)
[16] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257072.0097
[end] => 1786257072.0099
[time] => 0.00028491020202637
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257072.01
[end] => 1786257072.0124
[time] => 0.0024271011352539
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257072.0125
[end] => 1786257072.0253
[time] => 0.01282811164856
)
[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] => 1786257072.0278
[end] => 1786257072.1035
[time] => 0.075711011886597
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786257072.1036
[end] => 1786257072.104
[time] => 0.00033998489379883
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786257072.104
[end] => 1786257072.1042
[time] => 0.0001680850982666
)
[22] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257072.1043
[end] => 1786257072.1045
[time] => 0.00019407272338867
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257072.1045
[end] => 1786257072.1069
[time] => 0.0024509429931641
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257072.107
[end] => 1786257072.1199
[time] => 0.012862920761108
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3750'
[start] => 1786257072.1202
[end] => 1786257072.1282
[time] => 0.0079619884490967
)
[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] => 1786257072.1282
[end] => 1786257072.1759
[time] => 0.047654151916504
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3750'
[start] => 1786257072.176
[end] => 1786257072.1764
[time] => 0.00036311149597168
)
[28] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257072.1765
[end] => 1786257072.1767
[time] => 0.00019001960754395
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257072.1767
[end] => 1786257072.1791
[time] => 0.002418041229248
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257072.1792
[end] => 1786257072.1919
[time] => 0.012773036956787
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786257072.1922
[end] => 1786257072.1925
[time] => 0.00023293495178223
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786257072.1925
[end] => 1786257072.1931
[time] => 0.00055503845214844
)
[33] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257072.1933
[end] => 1786257072.1935
[time] => 0.00020503997802734
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257072.1935
[end] => 1786257072.1959
[time] => 0.0023689270019531
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257072.196
[end] => 1786257072.2087
[time] => 0.012753963470459
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3750'
[start] => 1786257072.209
[end] => 1786257072.21
[time] => 0.0010099411010742
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786257072.2101
[end] => 1786257072.2102
[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 = '3750' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786257072.2103
[end] => 1786257072.2105
[time] => 0.00020718574523926
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786257072.2105
[end] => 1786257072.2107
[time] => 0.00017213821411133
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786257072.2108
[end] => 1786257072.2109
[time] => 0.00012683868408203
)
[41] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257072.211
[end] => 1786257072.2112
[time] => 0.00017595291137695
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257072.2112
[end] => 1786257072.2136
[time] => 0.0023610591888428
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257072.2136
[end] => 1786257072.2263
[time] => 0.012712955474854
)
[44] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257072.2266
[end] => 1786257072.2268
[time] => 0.00020623207092285
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257072.2269
[end] => 1786257072.2292
[time] => 0.002338171005249
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257072.2293
[end] => 1786257072.2429
[time] => 0.013661861419678
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3750'
[start] => 1786257072.2433
[end] => 1786257072.2512
[time] => 0.0079441070556641
)
[48] => Array
(
[query] => select * from point where match_id = '3750' order by point_id ASC
[start] => 1786257072.2513
[end] => 1786257072.321
[time] => 0.069730997085571
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786257072.3218
[end] => 1786257072.3221
[time] => 0.00030994415283203
)
[50] => Array
(
[query] => select * from matches where match_id = '3750'
[start] => 1786257072.3221
[end] => 1786257072.3223
[time] => 0.00021100044250488
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3750'
[start] => 1786257072.3224
[end] => 1786257072.3248
[time] => 0.0024001598358154
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3750'
[start] => 1786257072.3248
[end] => 1786257072.3376
[time] => 0.012752771377563
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786257072.3401
[end] => 1786257072.3406
[time] => 0.00047183036804199
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786257072.3414
[end] => 1786257072.3417
[time] => 0.00026917457580566
)
)