Referto Partita: Explichit vs AS Intomatici
Explichit
AS Intomatici
RISULTATO FINALE
62
68
1° Tempo
27
24
2° Tempo
13
22
3° Tempo
22
22
INVASIONI A MURO
0
0
Data e Luogo
Evento
Playout 2022
Data e Luogo
05-06-2022 17:00 - Palazzeschi
Arbitri
Primo Arbitro
Centin Davide
Secondo Arbitro
Sceusi Giuseppe
Refertista
Sceusi Giuseppe
Sorteggio
Sorteggio Vinto Da
AS Intomatici
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Explichit
-
Mattia AllemanoTot.8
4
x20
x3
1
x AUTOHIT -
Claudio BonocoreTot.16
8
x20
x3
0
x AUTOHIT -
Luigi GhirardiTot.9
3
x21
x3
0
x AUTOHIT -
Lisa PortaruloTot.6
3
x20
x3
0
x AUTOHIT -
Samuel RomanazziTot.8
4
x20
x3
0
x AUTOHIT -
Stefano ZorzanTot.2
1
x20
x3
0
x AUTOHIT -
Mattia GizziTot.13
5
x21
x3
0
x AUTOHIT
AS Intomatici
-
Alberto Amoruso
3
x20
x3
0
x AUTOHITTot.6
Giulio Cocirio
10
x20
x3
0
x AUTOHITTot.20
Jacopo Marchitelli
10
x21
x3
0
x AUTOHITTot.23
Edoardo Di Noia
0
x20
x3
0
x AUTOHITTot.0
Francesco Croci
2
x20
x3
0
x AUTOHITTot.4
Justin Ossai
0
x20
x3
0
x AUTOHITTot.0
Pier Paolo Specchiulli
1
x20
x3
0
x AUTOHITTot.2
Davide Rivetti
2
x20
x3
0
x AUTOHITTot.4
Gabriele Di Stefano
4
x20
x3
0
x AUTOHITTot.8
Total Queries: 55 Total Time: 0.34948682785034 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1770971643.5382 [end] => 1770971643.5385 [time] => 0.00034499168395996 ) [1] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.5408 [end] => 1770971643.5411 [time] => 0.00025486946105957 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.5411 [end] => 1770971643.5432 [time] => 0.0020949840545654 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.5433 [end] => 1770971643.5554 [time] => 0.012072086334229 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.5556 [end] => 1770971643.5578 [time] => 0.0021328926086426 ) [5] => 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' ORDER BY lastname,firstname ASC [start] => 1770971643.5579 [end] => 1770971643.5644 [time] => 0.0064091682434082 ) [6] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770971643.5679 [end] => 1770971643.5683 [time] => 0.00042486190795898 ) [7] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770971643.5687 [end] => 1770971643.569 [time] => 0.0002591609954834 ) [8] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1770971643.569 [end] => 1770971643.5697 [time] => 0.00066089630126953 ) [9] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.5702 [end] => 1770971643.5704 [time] => 0.00020098686218262 ) [10] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.5704 [end] => 1770971643.5725 [time] => 0.002100944519043 ) [11] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.5726 [end] => 1770971643.5846 [time] => 0.011990070343018 ) [12] => Array ( [query] => select * from match_roster where match_id = '2262' [start] => 1770971643.5848 [end] => 1770971643.5916 [time] => 0.006821870803833 ) [13] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.5918 [end] => 1770971643.592 [time] => 0.00021600723266602 ) [14] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.5922 [end] => 1770971643.5943 [time] => 0.0020790100097656 ) [15] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.5943 [end] => 1770971643.6063 [time] => 0.011964082717896 ) [16] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2262' and (point.point = 'P' or point.point = 'E') [start] => 1770971643.6085 [end] => 1770971643.6744 [time] => 0.06591010093689 ) [17] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1770971643.6746 [end] => 1770971643.6749 [time] => 0.00034117698669434 ) [18] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1770971643.675 [end] => 1770971643.6752 [time] => 0.00019407272338867 ) [19] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.6752 [end] => 1770971643.6755 [time] => 0.0002448558807373 ) [20] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.6755 [end] => 1770971643.6778 [time] => 0.0023369789123535 ) [21] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.6779 [end] => 1770971643.69 [time] => 0.012058973312378 ) [22] => Array ( [query] => select * from match_roster where match_id = '2262' [start] => 1770971643.6902 [end] => 1770971643.6971 [time] => 0.0068728923797607 ) [23] => 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 = '2262' group by player_id [start] => 1770971643.6971 [end] => 1770971643.7395 [time] => 0.042418003082275 ) [24] => Array ( [query] => select * from penalty_to_team where match_id = '2262' [start] => 1770971643.7397 [end] => 1770971643.7401 [time] => 0.00036001205444336 ) [25] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.7401 [end] => 1770971643.7403 [time] => 0.00020599365234375 ) [26] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.7404 [end] => 1770971643.7424 [time] => 0.002065896987915 ) [27] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.7425 [end] => 1770971643.7545 [time] => 0.011996030807495 ) [28] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1770971643.7548 [end] => 1770971643.755 [time] => 0.00027203559875488 ) [29] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1770971643.7551 [end] => 1770971643.7557 [time] => 0.00058817863464355 ) [30] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.7559 [end] => 1770971643.7561 [time] => 0.00022101402282715 ) [31] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.7561 [end] => 1770971643.7582 [time] => 0.0020830631256104 ) [32] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.7583 [end] => 1770971643.7703 [time] => 0.012012004852295 ) [33] => Array ( [query] => select * from match_staff_roster where match_id = '2262' [start] => 1770971643.7705 [end] => 1770971643.7713 [time] => 0.00079083442687988 ) [34] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1770971643.7714 [end] => 1770971643.7716 [time] => 0.00016999244689941 ) [35] => 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 = '2262' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1770971643.7716 [end] => 1770971643.7718 [time] => 0.00022101402282715 ) [36] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1770971643.7719 [end] => 1770971643.772 [time] => 0.00017213821411133 ) [37] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1770971643.7721 [end] => 1770971643.7722 [time] => 0.00012087821960449 ) [38] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.7723 [end] => 1770971643.7726 [time] => 0.00021505355834961 ) [39] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.7726 [end] => 1770971643.7747 [time] => 0.0020918846130371 ) [40] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.7748 [end] => 1770971643.7867 [time] => 0.011976003646851 ) [41] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.787 [end] => 1770971643.7873 [time] => 0.0002589225769043 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.7873 [end] => 1770971643.7894 [time] => 0.0020608901977539 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.7894 [end] => 1770971643.8016 [time] => 0.012163162231445 ) [44] => Array ( [query] => select * from match_roster where match_id = '2262' [start] => 1770971643.8018 [end] => 1770971643.8087 [time] => 0.0068979263305664 ) [45] => Array ( [query] => select * from point where match_id = '2262' order by point_id ASC [start] => 1770971643.8088 [end] => 1770971643.8708 [time] => 0.062063217163086 ) [46] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.8714 [end] => 1770971643.8717 [time] => 0.00036501884460449 ) [47] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.8718 [end] => 1770971643.8739 [time] => 0.0021169185638428 ) [48] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.8739 [end] => 1770971643.8861 [time] => 0.012176036834717 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1770971643.8865 [end] => 1770971643.8868 [time] => 0.00031304359436035 ) [50] => Array ( [query] => select * from matches where match_id = '2262' [start] => 1770971643.8869 [end] => 1770971643.8871 [time] => 0.00022482872009277 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2262' [start] => 1770971643.8871 [end] => 1770971643.8891 [time] => 0.0020191669464111 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2262' [start] => 1770971643.8892 [end] => 1770971643.9013 [time] => 0.012054920196533 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770971643.9038 [end] => 1770971643.9043 [time] => 0.00049185752868652 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770971643.9051 [end] => 1770971643.9054 [time] => 0.00031495094299316 ) )