Referto Partita: Evolution vs Genova Hit Ball
Evolution
Genova Hit Ball
RISULTATO FINALE
99
100
1° Tempo
36
27
2° Tempo
35
36
3° Tempo
28
37
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2024/2025 A1
Giornata: 11
Giornata: 11
Data e Luogo
17-11-2024 12:00 - Verolengo
Arbitri
Primo Arbitro
Bargelli Francesca
Secondo Arbitro
Bargelli Francesca
Refertista
ASD Polaris
Sorteggio
Sorteggio Vinto Da
Evolution
Scelta Sorteggio
Campo
Annotazioni
Refertista: Lisa Portarulo
Progresso
Punteggi Individuali
Evolution
-
Gaspare GuarratoTot.10
5
x20
x3
0
x AUTOHIT -
Antonio Mirco SantarsiaTot.17
4
x23
x3
0
x AUTOHIT -
Davide BrunelloTot.7
2
x21
x3
0
x AUTOHIT -
Davide GiordanoTot.6
3
x20
x3
0
x AUTOHIT -
Giulio NaggiTot.29
7
x25
x3
0
x AUTOHIT -
Raffaele MaurelliTot.2
1
x20
x3
0
x AUTOHIT -
Amedeo BiglinoTot.28
5
x26
x3
0
x AUTOHIT
Genova Hit Ball
-
Dario Ravera
12
x20
x3
0
x AUTOHITTot.24
Luca Siciliano
5
x20
x3
0
x AUTOHITTot.10
Leonardo Farina
3
x20
x3
0
x AUTOHITTot.6
Davide Ciancio
0
x22
x3
0
x AUTOHITTot.6
Luca Fagherazzi
12
x26
x3
0
x AUTOHITTot.42
Giorgio Recalcati
3
x22
x3
0
x AUTOHITTot.12
Leonardo Chiarella
0
x20
x3
0
x AUTOHITTot.0
Total Queries: 55
Total Time: 1.1452887058258
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781155297.7238
[end] => 1781155297.7267
[time] => 0.0029079914093018
)
[1] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155297.7311
[end] => 1781155297.733
[time] => 0.0018601417541504
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155297.733
[end] => 1781155297.7412
[time] => 0.0081689357757568
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155297.7413
[end] => 1781155297.7843
[time] => 0.042972087860107
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155297.7846
[end] => 1781155297.7911
[time] => 0.0064480304718018
)
[5] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155297.7912
[end] => 1781155297.7939
[time] => 0.0027079582214355
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155297.7939
[end] => 1781155297.7985
[time] => 0.004580020904541
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155297.7985
[end] => 1781155297.8626
[time] => 0.064085006713867
)
[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 (16,38) ORDER BY lastname,firstname ASC
[start] => 1781155297.8631
[end] => 1781155297.8677
[time] => 0.0046098232269287
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155297.8686
[end] => 1781155297.8758
[time] => 0.0072150230407715
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155297.8763
[end] => 1781155297.88
[time] => 0.0036702156066895
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781155297.8801
[end] => 1781155297.886
[time] => 0.0058498382568359
)
[12] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155297.8865
[end] => 1781155297.8868
[time] => 0.00031495094299316
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155297.8868
[end] => 1781155297.8943
[time] => 0.0074789524078369
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155297.8943
[end] => 1781155297.951
[time] => 0.056697130203247
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3471'
[start] => 1781155297.9513
[end] => 1781155297.994
[time] => 0.042688846588135
)
[16] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155297.9941
[end] => 1781155297.995
[time] => 0.00086498260498047
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155297.995
[end] => 1781155298.0096
[time] => 0.014554977416992
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155298.0096
[end] => 1781155298.0548
[time] => 0.045193195343018
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3471' and (point.point = 'P' or point.point = 'E')
[start] => 1781155298.0588
[end] => 1781155298.2308
[time] => 0.17193102836609
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781155298.2309
[end] => 1781155298.233
[time] => 0.0020420551300049
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781155298.233
[end] => 1781155298.2332
[time] => 0.00018692016601562
)
[22] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155298.2333
[end] => 1781155298.2335
[time] => 0.0002131462097168
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155298.2335
[end] => 1781155298.2425
[time] => 0.0089819431304932
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155298.2426
[end] => 1781155298.2772
[time] => 0.03456711769104
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3471'
[start] => 1781155298.2774
[end] => 1781155298.2938
[time] => 0.016329050064087
)
[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 = '3471' group by player_id
[start] => 1781155298.2938
[end] => 1781155298.3567
[time] => 0.062828063964844
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3471'
[start] => 1781155298.3568
[end] => 1781155298.3627
[time] => 0.0059030055999756
)
[28] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155298.3628
[end] => 1781155298.3631
[time] => 0.0002751350402832
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155298.3631
[end] => 1781155298.3721
[time] => 0.0090210437774658
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155298.3722
[end] => 1781155298.4085
[time] => 0.03624701499939
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781155298.4088
[end] => 1781155298.4123
[time] => 0.0035080909729004
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781155298.4124
[end] => 1781155298.413
[time] => 0.0005650520324707
)
[33] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155298.4132
[end] => 1781155298.4169
[time] => 0.0037589073181152
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155298.417
[end] => 1781155298.4234
[time] => 0.0064291954040527
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155298.4235
[end] => 1781155298.4634
[time] => 0.039929866790771
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3471'
[start] => 1781155298.4637
[end] => 1781155298.4667
[time] => 0.0030069351196289
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781155298.4668
[end] => 1781155298.4719
[time] => 0.0050511360168457
)
[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 = '3471' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781155298.4719
[end] => 1781155298.4722
[time] => 0.00027894973754883
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781155298.4723
[end] => 1781155298.4725
[time] => 0.00019383430480957
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781155298.4725
[end] => 1781155298.4727
[time] => 0.00020408630371094
)
[41] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155298.4729
[end] => 1781155298.4747
[time] => 0.0018229484558105
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155298.4748
[end] => 1781155298.4831
[time] => 0.0083260536193848
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155298.4832
[end] => 1781155298.5333
[time] => 0.050132989883423
)
[44] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155298.5336
[end] => 1781155298.5388
[time] => 0.0051670074462891
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155298.5388
[end] => 1781155298.5433
[time] => 0.0045289993286133
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155298.5434
[end] => 1781155298.5871
[time] => 0.043710947036743
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3471'
[start] => 1781155298.5874
[end] => 1781155298.6119
[time] => 0.024526119232178
)
[48] => Array
(
[query] => select * from point where match_id = '3471' order by point_id ASC
[start] => 1781155298.612
[end] => 1781155298.8305
[time] => 0.21848893165588
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781155298.8312
[end] => 1781155298.8337
[time] => 0.0025310516357422
)
[50] => Array
(
[query] => select * from matches where match_id = '3471'
[start] => 1781155298.8338
[end] => 1781155298.8359
[time] => 0.0020890235900879
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3471'
[start] => 1781155298.8359
[end] => 1781155298.8425
[time] => 0.006580114364624
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3471'
[start] => 1781155298.8426
[end] => 1781155298.8846
[time] => 0.041998863220215
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155298.8889
[end] => 1781155298.8894
[time] => 0.00048995018005371
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155298.8903
[end] => 1781155298.8908
[time] => 0.00057601928710938
)
)