Referto Partita: Krakens Chivasso vs Legio X
Krakens Chivasso
Legio X
RISULTATO FINALE
66
38
1° Tempo
19
17
2° Tempo
20
7
3° Tempo
27
14
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2022/2023 B2
Giornata: 6
Giornata: 6
Data e Luogo
15-01-2023 16:40 - Maritano
Arbitri
Primo Arbitro
Centin Davide
Secondo Arbitro
Da Re Francesca
Refertista
Da Re Francesca
Sorteggio
Sorteggio Vinto Da
Legio X
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Krakens Chivasso
-
Davide MartiniTot.15
6
x21
x3
0
x AUTOHIT -
Paolo CapomollaTot.14
4
x22
x3
0
x AUTOHIT -
Emanuele PretiTot.8
4
x20
x3
0
x AUTOHIT -
Adriano Paribello GrassoTot.6
3
x20
x3
0
x AUTOHIT -
Francesco GhioTot.2
1
x20
x3
0
x AUTOHIT -
Alessio ArganoTot.20
10
x20
x3
0
x AUTOHIT
Legio X
-
Alessio Noto
2
x20
x3
0
x AUTOHITTot.4
Leonardo Specchiulli
0
x20
x3
0
x AUTOHITTot.0
Edoardo Di Noia
2
x20
x3
1
x AUTOHITTot.4
Pier Paolo Specchiulli
1
x20
x3
0
x AUTOHITTot.2
Simone Basano
1
x23
x3
0
x AUTOHITTot.11
Justin Ossai
3
x21
x3
0
x AUTOHITTot.9
Lorenzo Marchitelli
1
x20
x3
0
x AUTOHITTot.2
Valerio Ianniello
1
x20
x3
0
x AUTOHITTot.2
Marco Antonucci
2
x20
x3
0
x AUTOHITTot.4
Total Queries: 55 Total Time: 0.87341070175171 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1776067895.2267 [end] => 1776067895.227 [time] => 0.00030088424682617 ) [1] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.2314 [end] => 1776067895.233 [time] => 0.0015830993652344 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.233 [end] => 1776067895.2391 [time] => 0.0061469078063965 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.2393 [end] => 1776067895.2768 [time] => 0.037518978118896 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.2771 [end] => 1776067895.2878 [time] => 0.010643005371094 ) [5] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.2879 [end] => 1776067895.2884 [time] => 0.00052499771118164 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.2885 [end] => 1776067895.2906 [time] => 0.0021038055419922 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.2906 [end] => 1776067895.3437 [time] => 0.053102016448975 ) [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 (9,40) ORDER BY lastname,firstname ASC [start] => 1776067895.3442 [end] => 1776067895.3469 [time] => 0.0026938915252686 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776067895.3499 [end] => 1776067895.3511 [time] => 0.0012259483337402 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776067895.3515 [end] => 1776067895.3529 [time] => 0.0014348030090332 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1776067895.353 [end] => 1776067895.3536 [time] => 0.00062108039855957 ) [12] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.3541 [end] => 1776067895.3547 [time] => 0.00066399574279785 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.3548 [end] => 1776067895.3598 [time] => 0.0050208568572998 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.3599 [end] => 1776067895.3935 [time] => 0.033648014068604 ) [15] => Array ( [query] => select * from match_roster where match_id = '2640' [start] => 1776067895.3938 [end] => 1776067895.4088 [time] => 0.014956951141357 ) [16] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.4089 [end] => 1776067895.4097 [time] => 0.00082707405090332 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.4098 [end] => 1776067895.4148 [time] => 0.005094051361084 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.4149 [end] => 1776067895.4475 [time] => 0.032557964324951 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2640' and (point.point = 'P' or point.point = 'E') [start] => 1776067895.4509 [end] => 1776067895.6616 [time] => 0.21065998077393 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1776067895.6617 [end] => 1776067895.662 [time] => 0.00024104118347168 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1776067895.662 [end] => 1776067895.6622 [time] => 0.0001828670501709 ) [22] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.6623 [end] => 1776067895.6625 [time] => 0.0002439022064209 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.6626 [end] => 1776067895.665 [time] => 0.0024380683898926 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.665 [end] => 1776067895.7059 [time] => 0.040810823440552 ) [25] => Array ( [query] => select * from match_roster where match_id = '2640' [start] => 1776067895.7061 [end] => 1776067895.7251 [time] => 0.018957853317261 ) [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 = '2640' group by player_id [start] => 1776067895.7251 [end] => 1776067895.8195 [time] => 0.094403982162476 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2640' [start] => 1776067895.8197 [end] => 1776067895.822 [time] => 0.0022909641265869 ) [28] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.822 [end] => 1776067895.8222 [time] => 0.00020194053649902 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.8223 [end] => 1776067895.8263 [time] => 0.00406813621521 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.8264 [end] => 1776067895.8473 [time] => 0.020898103713989 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1776067895.8476 [end] => 1776067895.8501 [time] => 0.002518892288208 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1776067895.8502 [end] => 1776067895.8532 [time] => 0.0030708312988281 ) [33] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.8534 [end] => 1776067895.8547 [time] => 0.0012898445129395 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.8548 [end] => 1776067895.8569 [time] => 0.0020999908447266 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.8569 [end] => 1776067895.883 [time] => 0.026100158691406 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2640' [start] => 1776067895.8832 [end] => 1776067895.8847 [time] => 0.00148606300354 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1776067895.8848 [end] => 1776067895.885 [time] => 0.00017404556274414 ) [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 = '2640' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1776067895.885 [end] => 1776067895.8869 [time] => 0.0018899440765381 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1776067895.887 [end] => 1776067895.8872 [time] => 0.00018501281738281 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1776067895.8872 [end] => 1776067895.8874 [time] => 0.00017595291137695 ) [41] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.8876 [end] => 1776067895.8879 [time] => 0.00029397010803223 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.8879 [end] => 1776067895.89 [time] => 0.0020818710327148 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.89 [end] => 1776067895.9137 [time] => 0.023650884628296 ) [44] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067895.914 [end] => 1776067895.9159 [time] => 0.0019519329071045 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067895.9159 [end] => 1776067895.92 [time] => 0.0040850639343262 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067895.9201 [end] => 1776067895.9442 [time] => 0.024164199829102 ) [47] => Array ( [query] => select * from match_roster where match_id = '2640' [start] => 1776067895.9445 [end] => 1776067895.9576 [time] => 0.013091087341309 ) [48] => Array ( [query] => select * from point where match_id = '2640' order by point_id ASC [start] => 1776067895.9576 [end] => 1776067896.0858 [time] => 0.1282069683075 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1776067896.0864 [end] => 1776067896.089 [time] => 0.0025620460510254 ) [50] => Array ( [query] => select * from matches where match_id = '2640' [start] => 1776067896.0891 [end] => 1776067896.0901 [time] => 0.0010001659393311 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2640' [start] => 1776067896.0901 [end] => 1776067896.0954 [time] => 0.0052869319915771 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2640' [start] => 1776067896.0954 [end] => 1776067896.1167 [time] => 0.02129602432251 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776067896.1227 [end] => 1776067896.1231 [time] => 0.0004119873046875 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776067896.124 [end] => 1776067896.1242 [time] => 0.00027084350585938 ) )