Referto Partita: Pazzeschi vs Rdj
Pazzeschi
Rdj
RISULTATO FINALE
77
63
1° Tempo
23
21
2° Tempo
25
17
3° Tempo
29
25
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 A1
Giornata: 18
Giornata: 18
Data e Luogo
15-05-2022 15:45 - Palazzeschi
Arbitri
Primo Arbitro
Rovai Filippo
Secondo Arbitro
Zanetti Gianluca
Refertista
Petrosino Alessio
Sorteggio
Sorteggio Vinto Da
Rdj
Scelta Sorteggio
Campo
Progresso
Punteggi Individuali
Pazzeschi
-
Maurizio CalassiTot.18
9
x20
x3
0
x AUTOHIT -
Riccardo Del BocaTot.19
8
x21
x3
1
x AUTOHIT -
Giuseppe MirraTot.5
1
x21
x3
0
x AUTOHIT -
Danilo SacchettoTot.18
6
x22
x3
0
x AUTOHIT -
Sergio FilecciaTot.6
3
x20
x3
0
x AUTOHIT -
Antonio De RosaTot.11
4
x21
x3
0
x AUTOHIT
Rdj
-
Daniele Agnello
6
x22
x3
0
x AUTOHITTot.18
Stefano Calvo
4
x21
x3
0
x AUTOHITTot.11
Dylan Dominino
2
x22
x3
0
x AUTOHITTot.10
Andrea Rigoni
5
x21
x3
0
x AUTOHITTot.13
Gabriele Spina
3
x20
x3
0
x AUTOHITTot.6
Marco Barrasso
2
x20
x3
0
x AUTOHITTot.4
Total Queries: 55
Total Time: 0.35650539398193
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770971407.2255
[end] => 1770971407.2258
[time] => 0.00030183792114258
)
[1] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.2282
[end] => 1770971407.2284
[time] => 0.00025200843811035
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.2284
[end] => 1770971407.2306
[time] => 0.0021119117736816
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.2307
[end] => 1770971407.2449
[time] => 0.014267206192017
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.2453
[end] => 1770971407.2473
[time] => 0.002061128616333
)
[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] => 1770971407.2475
[end] => 1770971407.2546
[time] => 0.0070369243621826
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770971407.2584
[end] => 1770971407.2588
[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] => 1770971407.2592
[end] => 1770971407.2594
[time] => 0.00024199485778809
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770971407.2595
[end] => 1770971407.2602
[time] => 0.00066995620727539
)
[9] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.2607
[end] => 1770971407.261
[time] => 0.00030398368835449
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.2611
[end] => 1770971407.2632
[time] => 0.0021629333496094
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.2633
[end] => 1770971407.2754
[time] => 0.012113094329834
)
[12] => Array
(
[query] => select * from match_roster where match_id = '2194'
[start] => 1770971407.2757
[end] => 1770971407.2827
[time] => 0.007033109664917
)
[13] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.2828
[end] => 1770971407.2831
[time] => 0.00023794174194336
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.2831
[end] => 1770971407.2852
[time] => 0.002147912979126
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.2853
[end] => 1770971407.2974
[time] => 0.0120849609375
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2194' and (point.point = 'P' or point.point = 'E')
[start] => 1770971407.2995
[end] => 1770971407.3664
[time] => 0.066914081573486
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1770971407.3666
[end] => 1770971407.3669
[time] => 0.00030303001403809
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1770971407.367
[end] => 1770971407.3671
[time] => 0.00018000602722168
)
[19] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.3672
[end] => 1770971407.3674
[time] => 0.00020289421081543
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.3674
[end] => 1770971407.3695
[time] => 0.0020620822906494
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.3696
[end] => 1770971407.3817
[time] => 0.0120849609375
)
[22] => Array
(
[query] => select * from match_roster where match_id = '2194'
[start] => 1770971407.3819
[end] => 1770971407.389
[time] => 0.0070228576660156
)
[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 = '2194' group by player_id
[start] => 1770971407.389
[end] => 1770971407.4324
[time] => 0.04339599609375
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '2194'
[start] => 1770971407.4326
[end] => 1770971407.4329
[time] => 0.00031304359436035
)
[25] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.4329
[end] => 1770971407.4331
[time] => 0.00018906593322754
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.4332
[end] => 1770971407.4353
[time] => 0.0021340847015381
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.4354
[end] => 1770971407.4488
[time] => 0.013411045074463
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1770971407.4491
[end] => 1770971407.4494
[time] => 0.00031900405883789
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1770971407.4495
[end] => 1770971407.4502
[time] => 0.00068211555480957
)
[30] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.4504
[end] => 1770971407.4506
[time] => 0.00022006034851074
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.4506
[end] => 1770971407.4527
[time] => 0.0020308494567871
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.4528
[end] => 1770971407.4649
[time] => 0.012135028839111
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '2194'
[start] => 1770971407.4652
[end] => 1770971407.466
[time] => 0.00084304809570312
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1770971407.4661
[end] => 1770971407.4663
[time] => 0.00018310546875
)
[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 = '2194' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1770971407.4663
[end] => 1770971407.4665
[time] => 0.00020885467529297
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1770971407.4666
[end] => 1770971407.4668
[time] => 0.0002138614654541
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1770971407.4669
[end] => 1770971407.4671
[time] => 0.00016283988952637
)
[38] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.4672
[end] => 1770971407.4674
[time] => 0.00021004676818848
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.4675
[end] => 1770971407.4696
[time] => 0.0021109580993652
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.4696
[end] => 1770971407.4817
[time] => 0.012089014053345
)
[41] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.482
[end] => 1770971407.4823
[time] => 0.00023913383483887
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.4823
[end] => 1770971407.4843
[time] => 0.0020589828491211
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.4844
[end] => 1770971407.4964
[time] => 0.012002229690552
)
[44] => Array
(
[query] => select * from match_roster where match_id = '2194'
[start] => 1770971407.4966
[end] => 1770971407.5036
[time] => 0.0069489479064941
)
[45] => Array
(
[query] => select * from point where match_id = '2194' order by point_id ASC
[start] => 1770971407.5036
[end] => 1770971407.5656
[time] => 0.062027931213379
)
[46] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.5662
[end] => 1770971407.5665
[time] => 0.0003058910369873
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.5665
[end] => 1770971407.5686
[time] => 0.0020768642425537
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.5687
[end] => 1770971407.5811
[time] => 0.012377023696899
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1770971407.5816
[end] => 1770971407.5819
[time] => 0.00029587745666504
)
[50] => Array
(
[query] => select * from matches where match_id = '2194'
[start] => 1770971407.5819
[end] => 1770971407.5821
[time] => 0.00019407272338867
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2194'
[start] => 1770971407.5821
[end] => 1770971407.5842
[time] => 0.0020351409912109
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2194'
[start] => 1770971407.5842
[end] => 1770971407.5963
[time] => 0.01209282875061
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770971407.5989
[end] => 1770971407.5994
[time] => 0.00049090385437012
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770971407.6002
[end] => 1770971407.6005
[time] => 0.00028586387634277
)
)