Referto Partita: Gunners vs Genova Hit Ball
Gunners
Genova Hit Ball
RISULTATO FINALE
41
88
1° Tempo
9
22
2° Tempo
20
29
3° Tempo
12
37
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2022/2023 A2
Giornata: 4
Giornata: 4
Data e Luogo
27-11-2022 14:30 - Maritano
Arbitri
Primo Arbitro
Riccio Roberto
Secondo Arbitro
Da Re Francesca
Refertista
Da Re Francesca
Sorteggio
Sorteggio Vinto Da
Genova Hit Ball
Scelta Sorteggio
Campo
Progresso
Punteggi Individuali
Gunners
-
Enrico BrunelloTot.0
0
x20
x3
0
x AUTOHIT -
Alessia ScardicchioTot.4
2
x20
x3
0
x AUTOHIT -
Marco BernoccoTot.7
2
x21
x3
0
x AUTOHIT -
Giacomo GuarratoTot.5
1
x21
x3
0
x AUTOHIT -
Davide CastaldoTot.14
4
x22
x3
0
x AUTOHIT -
Davide CentinTot.11
4
x21
x3
0
x AUTOHIT
Genova Hit Ball
-
Luca Siciliano
11
x22
x3
0
x AUTOHITTot.28
Riccardo Merlo
7
x20
x3
0
x AUTOHITTot.14
Davide Ciancio
7
x20
x3
0
x AUTOHITTot.14
Luca Fagherazzi
11
x22
x3
0
x AUTOHITTot.28
Arturo Pero
2
x20
x3
0
x AUTOHITTot.4
Total Queries: 55
Total Time: 0.56245636940002
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786253198.1353
[end] => 1786253198.136
[time] => 0.00065803527832031
)
[1] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.1411
[end] => 1786253198.1413
[time] => 0.00022792816162109
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.1413
[end] => 1786253198.1439
[time] => 0.0025677680969238
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.144
[end] => 1786253198.1705
[time] => 0.02643084526062
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.1708
[end] => 1786253198.1754
[time] => 0.0046498775482178
)
[5] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.1755
[end] => 1786253198.1777
[time] => 0.0021970272064209
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.1778
[end] => 1786253198.1839
[time] => 0.0061671733856201
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.184
[end] => 1786253198.2088
[time] => 0.024847030639648
)
[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 (30,38) ORDER BY lastname,firstname ASC
[start] => 1786253198.2092
[end] => 1786253198.2122
[time] => 0.0029819011688232
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786253198.2132
[end] => 1786253198.2151
[time] => 0.0018608570098877
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786253198.2155
[end] => 1786253198.2161
[time] => 0.00054597854614258
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786253198.2162
[end] => 1786253198.2175
[time] => 0.0013828277587891
)
[12] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.218
[end] => 1786253198.2197
[time] => 0.0017077922821045
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.2198
[end] => 1786253198.2242
[time] => 0.004457950592041
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.2243
[end] => 1786253198.2502
[time] => 0.02588415145874
)
[15] => Array
(
[query] => select * from match_roster where match_id = '2454'
[start] => 1786253198.2504
[end] => 1786253198.2596
[time] => 0.0091531276702881
)
[16] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.2597
[end] => 1786253198.26
[time] => 0.00024795532226562
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.26
[end] => 1786253198.2624
[time] => 0.00242018699646
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.2625
[end] => 1786253198.2758
[time] => 0.013309955596924
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2454' and (point.point = 'P' or point.point = 'E')
[start] => 1786253198.2782
[end] => 1786253198.3552
[time] => 0.076969146728516
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786253198.3553
[end] => 1786253198.3556
[time] => 0.00029802322387695
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786253198.3557
[end] => 1786253198.3559
[time] => 0.00019502639770508
)
[22] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.356
[end] => 1786253198.3562
[time] => 0.00022196769714355
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.3563
[end] => 1786253198.3587
[time] => 0.0024478435516357
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.3588
[end] => 1786253198.3715
[time] => 0.012772798538208
)
[25] => Array
(
[query] => select * from match_roster where match_id = '2454'
[start] => 1786253198.3718
[end] => 1786253198.3829
[time] => 0.011111974716187
)
[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 = '2454' group by player_id
[start] => 1786253198.383
[end] => 1786253198.4624
[time] => 0.079456090927124
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '2454'
[start] => 1786253198.4626
[end] => 1786253198.465
[time] => 0.0024089813232422
)
[28] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.4651
[end] => 1786253198.4653
[time] => 0.00020980834960938
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.4653
[end] => 1786253198.4677
[time] => 0.0024189949035645
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.4678
[end] => 1786253198.4958
[time] => 0.028022050857544
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786253198.4961
[end] => 1786253198.4963
[time] => 0.00023508071899414
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786253198.4964
[end] => 1786253198.497
[time] => 0.00054812431335449
)
[33] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.4971
[end] => 1786253198.4974
[time] => 0.00021100044250488
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.4974
[end] => 1786253198.5028
[time] => 0.0053839683532715
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.5028
[end] => 1786253198.5264
[time] => 0.023530006408691
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '2454'
[start] => 1786253198.5266
[end] => 1786253198.5303
[time] => 0.0037100315093994
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786253198.5304
[end] => 1786253198.5321
[time] => 0.0016870498657227
)
[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 = '2454' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786253198.5321
[end] => 1786253198.5324
[time] => 0.00031208992004395
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786253198.5325
[end] => 1786253198.5327
[time] => 0.00020718574523926
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786253198.5328
[end] => 1786253198.5329
[time] => 0.00015902519226074
)
[41] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.5331
[end] => 1786253198.5333
[time] => 0.00018501281738281
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.5333
[end] => 1786253198.5357
[time] => 0.0024330615997314
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.5358
[end] => 1786253198.5645
[time] => 0.028698921203613
)
[44] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.5648
[end] => 1786253198.5677
[time] => 0.002946138381958
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.5678
[end] => 1786253198.5732
[time] => 0.0054459571838379
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.5733
[end] => 1786253198.5966
[time] => 0.023331165313721
)
[47] => Array
(
[query] => select * from match_roster where match_id = '2454'
[start] => 1786253198.5969
[end] => 1786253198.6126
[time] => 0.015749931335449
)
[48] => Array
(
[query] => select * from point where match_id = '2454' order by point_id ASC
[start] => 1786253198.6127
[end] => 1786253198.6939
[time] => 0.081166982650757
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786253198.6944
[end] => 1786253198.695
[time] => 0.00052785873413086
)
[50] => Array
(
[query] => select * from matches where match_id = '2454'
[start] => 1786253198.695
[end] => 1786253198.6959
[time] => 0.00084781646728516
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2454'
[start] => 1786253198.6959
[end] => 1786253198.6985
[time] => 0.0025699138641357
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2454'
[start] => 1786253198.6985
[end] => 1786253198.7121
[time] => 0.013523817062378
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786253198.7146
[end] => 1786253198.7151
[time] => 0.00050806999206543
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786253198.716
[end] => 1786253198.7163
[time] => 0.00030708312988281
)
)