Referto Partita: Hocheti Pokety vs Get To Hit
Hocheti Pokety
Get To Hit
RISULTATO FINALE
81
99
1° Tempo
25
31
2° Tempo
25
25
3° Tempo
31
43
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2022/2023 B1
Giornata: 11
Giornata: 11
Data e Luogo
10-02-2023 21:05 - Enaip
Arbitri
Primo Arbitro
Spina Gabriele
Secondo Arbitro
Principato Lucrezia
Refertista
Principato Lucrezia
Sorteggio
Sorteggio Vinto Da
Get To Hit
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Hocheti Pokety
-
Simone PoserTot.5
1
x21
x3
0
x AUTOHIT -
Edoardo Francesco StefanelliTot.7
2
x21
x3
0
x AUTOHIT -
Ramon RutiglianoTot.34
8
x26
x3
0
x AUTOHIT -
Thomas RovettoTot.0
0
x20
x3
0
x AUTOHIT -
Simone De MeoTot.17
7
x21
x3
0
x AUTOHIT -
Alberto RaccoTot.6
3
x20
x3
0
x AUTOHIT -
Ivan DastrùTot.11
4
x21
x3
0
x AUTOHIT
Get To Hit
-
Francesco Mongiovì
3
x20
x3
0
x AUTOHITTot.6
Federico Perno
7
x20
x3
0
x AUTOHITTot.14
Tommaso Baudi Di Vesme Gabutti
3
x20
x3
0
x AUTOHITTot.6
Andrea De Blasio
4
x21
x3
0
x AUTOHITTot.11
Andrea Vitale
10
x21
x3
0
x AUTOHITTot.23
Gabriele Lepore
1
x21
x3
1
x AUTOHITTot.5
Simone Gasbarroni
1
x20
x3
0
x AUTOHITTot.2
Fabio Ingrassia
8
x21
x3
0
x AUTOHITTot.19
Andrea Tapella
5
x21
x3
0
x AUTOHITTot.13
Total Queries: 55 Total Time: 0.34381866455078 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1776066952.6993 [end] => 1776066952.6996 [time] => 0.00031685829162598 ) [1] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.7019 [end] => 1776066952.7021 [time] => 0.00024700164794922 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.7021 [end] => 1776066952.7042 [time] => 0.0020971298217773 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.7043 [end] => 1776066952.7164 [time] => 0.01213002204895 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.7168 [end] => 1776066952.7189 [time] => 0.0021491050720215 ) [5] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.719 [end] => 1776066952.7192 [time] => 0.00020194053649902 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.7192 [end] => 1776066952.7213 [time] => 0.0020699501037598 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.7214 [end] => 1776066952.7334 [time] => 0.012047052383423 ) [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 (6,37) ORDER BY lastname,firstname ASC [start] => 1776066952.7338 [end] => 1776066952.7348 [time] => 0.00099802017211914 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776066952.7364 [end] => 1776066952.7369 [time] => 0.00043296813964844 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776066952.7372 [end] => 1776066952.7375 [time] => 0.00024795532226562 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1776066952.7376 [end] => 1776066952.7382 [time] => 0.00060892105102539 ) [12] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.7386 [end] => 1776066952.7388 [time] => 0.00022411346435547 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.7388 [end] => 1776066952.7409 [time] => 0.0020911693572998 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.741 [end] => 1776066952.753 [time] => 0.012045860290527 ) [15] => Array ( [query] => select * from match_roster where match_id = '2579' [start] => 1776066952.7533 [end] => 1776066952.7602 [time] => 0.0069611072540283 ) [16] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.7603 [end] => 1776066952.7606 [time] => 0.00026917457580566 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.7606 [end] => 1776066952.7627 [time] => 0.0020480155944824 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.7627 [end] => 1776066952.7748 [time] => 0.012068033218384 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2579' and (point.point = 'P' or point.point = 'E') [start] => 1776066952.777 [end] => 1776066952.843 [time] => 0.066059827804565 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1776066952.8432 [end] => 1776066952.8435 [time] => 0.00033092498779297 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1776066952.8436 [end] => 1776066952.8438 [time] => 0.0001978874206543 ) [22] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.8439 [end] => 1776066952.8441 [time] => 0.00021505355834961 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.8441 [end] => 1776066952.8462 [time] => 0.0020699501037598 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.8463 [end] => 1776066952.8585 [time] => 0.012200117111206 ) [25] => Array ( [query] => select * from match_roster where match_id = '2579' [start] => 1776066952.8588 [end] => 1776066952.8658 [time] => 0.0069799423217773 ) [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 = '2579' group by player_id [start] => 1776066952.8658 [end] => 1776066952.908 [time] => 0.042191982269287 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2579' [start] => 1776066952.9082 [end] => 1776066952.9085 [time] => 0.00034284591674805 ) [28] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.9086 [end] => 1776066952.9088 [time] => 0.00020194053649902 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.9088 [end] => 1776066952.9109 [time] => 0.00205397605896 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.9109 [end] => 1776066952.923 [time] => 0.012112140655518 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1776066952.9233 [end] => 1776066952.9236 [time] => 0.00026607513427734 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1776066952.9237 [end] => 1776066952.9242 [time] => 0.00058484077453613 ) [33] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.9244 [end] => 1776066952.9246 [time] => 0.00020313262939453 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.9246 [end] => 1776066952.9267 [time] => 0.0020501613616943 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.9267 [end] => 1776066952.9388 [time] => 0.012048959732056 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2579' [start] => 1776066952.939 [end] => 1776066952.9399 [time] => 0.0008540153503418 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1776066952.94 [end] => 1776066952.9401 [time] => 0.00017809867858887 ) [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 = '2579' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1776066952.9402 [end] => 1776066952.9404 [time] => 0.00021004676818848 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1776066952.9404 [end] => 1776066952.9406 [time] => 0.00015902519226074 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1776066952.9406 [end] => 1776066952.9408 [time] => 0.00014400482177734 ) [41] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.9409 [end] => 1776066952.9411 [time] => 0.00018405914306641 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.9411 [end] => 1776066952.9432 [time] => 0.002018928527832 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.9432 [end] => 1776066952.9552 [time] => 0.012037038803101 ) [44] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066952.9555 [end] => 1776066952.9558 [time] => 0.00026798248291016 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066952.9558 [end] => 1776066952.9579 [time] => 0.0020871162414551 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066952.9579 [end] => 1776066952.97 [time] => 0.012059211730957 ) [47] => Array ( [query] => select * from match_roster where match_id = '2579' [start] => 1776066952.9702 [end] => 1776066952.9772 [time] => 0.0069880485534668 ) [48] => Array ( [query] => select * from point where match_id = '2579' order by point_id ASC [start] => 1776066952.9773 [end] => 1776066953.0388 [time] => 0.061553955078125 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1776066953.0395 [end] => 1776066953.0399 [time] => 0.00041985511779785 ) [50] => Array ( [query] => select * from matches where match_id = '2579' [start] => 1776066953.04 [end] => 1776066953.0402 [time] => 0.00021696090698242 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2579' [start] => 1776066953.0402 [end] => 1776066953.0423 [time] => 0.0020749568939209 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2579' [start] => 1776066953.0424 [end] => 1776066953.0547 [time] => 0.012279033660889 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776066953.0571 [end] => 1776066953.0576 [time] => 0.00047516822814941 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776066953.0584 [end] => 1776066953.0587 [time] => 0.00024700164794922 ) )