Referto Partita: Lab To Hit vs Red Devils
Lab To Hit
Red Devils
RISULTATO FINALE
79
84
1° Tempo
24
25
2° Tempo
19
33
3° Tempo
36
26
INVASIONI A MURO
0
0
Data e Luogo
Evento
Playoff 2022
Data e Luogo
31-05-2022 20:30 - Palazzeschi
Arbitri
Primo Arbitro
Spina Gabriele
Secondo Arbitro
Calvo Stefano
Refertista
Da Re Francesca
Sorteggio
Sorteggio Vinto Da
Red Devils
Scelta Sorteggio
Campo
Progresso
Punteggi Individuali
Lab To Hit
-
Mattia RizzonTot.13
2
x23
x3
0
x AUTOHIT -
Alessandro VerdeTot.9
3
x21
x3
0
x AUTOHIT -
Federico D'OriaTot.7
2
x21
x3
0
x AUTOHIT -
Alessandro RigardoTot.2
1
x20
x3
0
x AUTOHIT -
Luca CardinaliTot.16
2
x24
x3
0
x AUTOHIT -
Marco PotenzaTot.10
2
x22
x3
0
x AUTOHIT -
Federico PistiddaTot.21
0
x27
x3
0
x AUTOHIT
Red Devils
-
Mattia Vazzoler
1
x21
x3
0
x AUTOHITTot.5
Alessio Casali
5
x21
x3
0
x AUTOHITTot.13
Stefano Benedetto
7
x21
x3
0
x AUTOHITTot.17
Andrea Belcastro
0
x21
x3
0
x AUTOHITTot.3
Antonio Mirco Santarsia
2
x21
x3
1
x AUTOHITTot.7
Marco Virgilio
0
x20
x3
0
x AUTOHITTot.0
Andrea Suman
3
x20
x3
0
x AUTOHITTot.6
Michele Messina
1
x22
x3
0
x AUTOHITTot.8
Riccardo Simini
8
x23
x3
0
x AUTOHITTot.25
Total Queries: 55 Total Time: 0.38320708274841 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1781155355.3718 [end] => 1781155355.3722 [time] => 0.00038290023803711 ) [1] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.3746 [end] => 1781155355.375 [time] => 0.00031495094299316 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.375 [end] => 1781155355.3774 [time] => 0.0024631023406982 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.3776 [end] => 1781155355.3905 [time] => 0.012985944747925 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.3909 [end] => 1781155355.3934 [time] => 0.0025038719177246 ) [5] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.3935 [end] => 1781155355.3938 [time] => 0.00024914741516113 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.3938 [end] => 1781155355.3962 [time] => 0.002373218536377 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.3962 [end] => 1781155355.4091 [time] => 0.01283597946167 ) [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 (17,21) ORDER BY lastname,firstname ASC [start] => 1781155355.4094 [end] => 1781155355.4105 [time] => 0.0010650157928467 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781155355.4114 [end] => 1781155355.4119 [time] => 0.00042390823364258 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781155355.4123 [end] => 1781155355.4126 [time] => 0.0002601146697998 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1781155355.4126 [end] => 1781155355.4132 [time] => 0.00059914588928223 ) [12] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.4137 [end] => 1781155355.4139 [time] => 0.00021219253540039 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.414 [end] => 1781155355.4163 [time] => 0.002371072769165 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.4164 [end] => 1781155355.4292 [time] => 0.012830018997192 ) [15] => Array ( [query] => select * from match_roster where match_id = '2247' [start] => 1781155355.4294 [end] => 1781155355.4376 [time] => 0.0081510543823242 ) [16] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.4377 [end] => 1781155355.438 [time] => 0.0002589225769043 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.438 [end] => 1781155355.4404 [time] => 0.0024080276489258 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.4405 [end] => 1781155355.4533 [time] => 0.012800931930542 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2247' and (point.point = 'P' or point.point = 'E') [start] => 1781155355.4557 [end] => 1781155355.5319 [time] => 0.076174974441528 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1781155355.5321 [end] => 1781155355.5324 [time] => 0.0003349781036377 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1781155355.5325 [end] => 1781155355.5326 [time] => 0.00018095970153809 ) [22] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.5327 [end] => 1781155355.5329 [time] => 0.00020098686218262 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.533 [end] => 1781155355.5353 [time] => 0.0023548603057861 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.5354 [end] => 1781155355.5482 [time] => 0.012845039367676 ) [25] => Array ( [query] => select * from match_roster where match_id = '2247' [start] => 1781155355.5484 [end] => 1781155355.5568 [time] => 0.0083999633789062 ) [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 = '2247' group by player_id [start] => 1781155355.5569 [end] => 1781155355.6045 [time] => 0.047554016113281 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2247' [start] => 1781155355.6046 [end] => 1781155355.605 [time] => 0.00039887428283691 ) [28] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.6051 [end] => 1781155355.6053 [time] => 0.00019216537475586 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.6053 [end] => 1781155355.6076 [time] => 0.0023560523986816 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.6077 [end] => 1781155355.6206 [time] => 0.012874841690063 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1781155355.6209 [end] => 1781155355.6212 [time] => 0.00023388862609863 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1781155355.6212 [end] => 1781155355.6218 [time] => 0.00054407119750977 ) [33] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.622 [end] => 1781155355.6222 [time] => 0.0001990795135498 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.6222 [end] => 1781155355.6246 [time] => 0.0023760795593262 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.6246 [end] => 1781155355.6374 [time] => 0.012789964675903 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2247' [start] => 1781155355.6376 [end] => 1781155355.6387 [time] => 0.0010290145874023 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1781155355.6388 [end] => 1781155355.639 [time] => 0.00017118453979492 ) [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 = '2247' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1781155355.639 [end] => 1781155355.6392 [time] => 0.00020790100097656 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1781155355.6393 [end] => 1781155355.6394 [time] => 0.00015807151794434 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1781155355.6395 [end] => 1781155355.6396 [time] => 0.00014400482177734 ) [41] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.6398 [end] => 1781155355.64 [time] => 0.00018191337585449 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.64 [end] => 1781155355.6424 [time] => 0.0023770332336426 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.6424 [end] => 1781155355.6552 [time] => 0.012789011001587 ) [44] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.6555 [end] => 1781155355.6558 [time] => 0.00029897689819336 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.6558 [end] => 1781155355.6582 [time] => 0.0023899078369141 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.6582 [end] => 1781155355.6712 [time] => 0.012956857681274 ) [47] => Array ( [query] => select * from match_roster where match_id = '2247' [start] => 1781155355.6714 [end] => 1781155355.6795 [time] => 0.0081131458282471 ) [48] => Array ( [query] => select * from point where match_id = '2247' order by point_id ASC [start] => 1781155355.6796 [end] => 1781155355.7498 [time] => 0.07020092010498 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1781155355.7505 [end] => 1781155355.7508 [time] => 0.00036096572875977 ) [50] => Array ( [query] => select * from matches where match_id = '2247' [start] => 1781155355.7509 [end] => 1781155355.7511 [time] => 0.00022602081298828 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2247' [start] => 1781155355.7511 [end] => 1781155355.7535 [time] => 0.0023970603942871 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2247' [start] => 1781155355.7536 [end] => 1781155355.7665 [time] => 0.012866973876953 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781155355.7691 [end] => 1781155355.7696 [time] => 0.00048589706420898 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781155355.7705 [end] => 1781155355.7708 [time] => 0.00035190582275391 ) )