Referto Partita: Decepticon vs Get To Hit
Decepticon
Get To Hit
RISULTATO FINALE
84
76
1° Tempo
23
32
2° Tempo
38
32
3° Tempo
23
12
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2022/2023 B1
Giornata: 3
Giornata: 3
Data e Luogo
19-11-2022 16:40 - Enaip
Arbitri
Primo Arbitro
Petrosino Alessio
Secondo Arbitro
Principato Lucrezia
Refertista
Principato Lucrezia
Sorteggio
Sorteggio Vinto Da
Decepticon
Scelta Sorteggio
Campo
Progresso
Punteggi Individuali
Decepticon
-
Enrico TestaTot.41
10
x27
x3
1
x AUTOHIT -
Daniele UrsidaTot.0
0
x20
x3
0
x AUTOHIT -
Riccardo ToppanTot.16
2
x24
x3
0
x AUTOHIT -
Giuseppe ArmannoTot.19
8
x21
x3
0
x AUTOHIT -
Simone GuglielmettoTot.3
0
x21
x3
0
x AUTOHIT -
Luca CavagliàTot.3
0
x21
x3
0
x AUTOHIT -
Daniele BarbatoTot.2
1
x20
x3
0
x AUTOHIT
Get To Hit
-
Francesco Mongiovì
3
x20
x3
0
x AUTOHITTot.6
Federico Perno
5
x21
x3
0
x AUTOHITTot.13
Tommaso Baudi Di Vesme Gabutti
5
x20
x3
0
x AUTOHITTot.10
Andrea De Blasio
7
x20
x3
0
x AUTOHITTot.14
Andrea Vitale
5
x20
x3
0
x AUTOHITTot.10
Gabriele Lepore
3
x20
x3
0
x AUTOHITTot.6
Simone Gasbarroni
0
x20
x3
0
x AUTOHITTot.0
Fabio Ingrassia
8
x20
x3
0
x AUTOHITTot.16
Andrea Tapella
0
x20
x3
0
x AUTOHITTot.0
Total Queries: 55 Total Time: 0.38647985458374 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1781155810.3299 [end] => 1781155810.3302 [time] => 0.00028610229492188 ) [1] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.3325 [end] => 1781155810.3328 [time] => 0.00024104118347168 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.3328 [end] => 1781155810.3352 [time] => 0.0023910999298096 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.3353 [end] => 1781155810.3481 [time] => 0.012866020202637 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.3484 [end] => 1781155810.3509 [time] => 0.0024878978729248 ) [5] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.351 [end] => 1781155810.3512 [time] => 0.00022506713867188 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.3513 [end] => 1781155810.3536 [time] => 0.0023758411407471 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.3537 [end] => 1781155810.3665 [time] => 0.012837886810303 ) [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 (5,37) ORDER BY lastname,firstname ASC [start] => 1781155810.3669 [end] => 1781155810.368 [time] => 0.0010960102081299 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781155810.3697 [end] => 1781155810.3702 [time] => 0.00046586990356445 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781155810.3706 [end] => 1781155810.3708 [time] => 0.00025701522827148 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1781155810.3709 [end] => 1781155810.3715 [time] => 0.00060486793518066 ) [12] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.372 [end] => 1781155810.3722 [time] => 0.00019979476928711 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.3722 [end] => 1781155810.3746 [time] => 0.0023589134216309 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.3746 [end] => 1781155810.3874 [time] => 0.01279091835022 ) [15] => Array ( [query] => select * from match_roster where match_id = '2538' [start] => 1781155810.3876 [end] => 1781155810.3957 [time] => 0.0080230236053467 ) [16] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.3958 [end] => 1781155810.396 [time] => 0.00023698806762695 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.396 [end] => 1781155810.3984 [time] => 0.0023491382598877 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.3984 [end] => 1781155810.4113 [time] => 0.012848854064941 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2538' and (point.point = 'P' or point.point = 'E') [start] => 1781155810.4137 [end] => 1781155810.4882 [time] => 0.074490785598755 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1781155810.4884 [end] => 1781155810.4887 [time] => 0.0003509521484375 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1781155810.4888 [end] => 1781155810.4889 [time] => 0.00016999244689941 ) [22] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.489 [end] => 1781155810.4892 [time] => 0.00020599365234375 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.4892 [end] => 1781155810.4916 [time] => 0.0023760795593262 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.4917 [end] => 1781155810.5046 [time] => 0.012831926345825 ) [25] => Array ( [query] => select * from match_roster where match_id = '2538' [start] => 1781155810.5048 [end] => 1781155810.5129 [time] => 0.0080490112304688 ) [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 = '2538' group by player_id [start] => 1781155810.5129 [end] => 1781155810.5605 [time] => 0.04764199256897 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2538' [start] => 1781155810.5607 [end] => 1781155810.5612 [time] => 0.00050187110900879 ) [28] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.5613 [end] => 1781155810.5615 [time] => 0.00019288063049316 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.5615 [end] => 1781155810.5639 [time] => 0.0023460388183594 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.5639 [end] => 1781155810.5767 [time] => 0.012814998626709 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1781155810.577 [end] => 1781155810.5772 [time] => 0.00021600723266602 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1781155810.5773 [end] => 1781155810.5778 [time] => 0.00054693222045898 ) [33] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.578 [end] => 1781155810.5782 [time] => 0.0002291202545166 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.5783 [end] => 1781155810.5807 [time] => 0.0024008750915527 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.5807 [end] => 1781155810.5935 [time] => 0.012773990631104 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2538' [start] => 1781155810.5937 [end] => 1781155810.5947 [time] => 0.00092315673828125 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1781155810.5948 [end] => 1781155810.5949 [time] => 0.00016689300537109 ) [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 = '2538' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1781155810.595 [end] => 1781155810.5954 [time] => 0.00044989585876465 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1781155810.5955 [end] => 1781155810.5958 [time] => 0.00026488304138184 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1781155810.5959 [end] => 1781155810.5964 [time] => 0.00057601928710938 ) [41] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.5968 [end] => 1781155810.5972 [time] => 0.00043916702270508 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.5973 [end] => 1781155810.6001 [time] => 0.0028748512268066 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.6002 [end] => 1781155810.6156 [time] => 0.015435934066772 ) [44] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.616 [end] => 1781155810.6163 [time] => 0.0002598762512207 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.6163 [end] => 1781155810.6187 [time] => 0.0024311542510986 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.6188 [end] => 1781155810.6322 [time] => 0.013354063034058 ) [47] => Array ( [query] => select * from match_roster where match_id = '2538' [start] => 1781155810.6324 [end] => 1781155810.6415 [time] => 0.0091509819030762 ) [48] => Array ( [query] => select * from point where match_id = '2538' order by point_id ASC [start] => 1781155810.6416 [end] => 1781155810.7122 [time] => 0.070552110671997 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1781155810.7129 [end] => 1781155810.7132 [time] => 0.00032591819763184 ) [50] => Array ( [query] => select * from matches where match_id = '2538' [start] => 1781155810.7133 [end] => 1781155810.7135 [time] => 0.0002131462097168 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2538' [start] => 1781155810.7135 [end] => 1781155810.7159 [time] => 0.0024318695068359 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2538' [start] => 1781155810.716 [end] => 1781155810.7287 [time] => 0.012753963470459 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781155810.7313 [end] => 1781155810.7318 [time] => 0.00051999092102051 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781155810.7326 [end] => 1781155810.7329 [time] => 0.0002741813659668 ) )