Referto Partita: Padawan vs Meatballs
Padawan
Meatballs
RISULTATO FINALE
62
59
1° Tempo
18
25
2° Tempo
20
15
3° Tempo
24
19
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 B2
Giornata: 11
Giornata: 11
Data e Luogo
17-03-2022 21:45 - Palazzeschi
Arbitri
Primo Arbitro
Spina Gabriele
Secondo Arbitro
Da Re Francesca
Refertista
Da Re Francesca
Sorteggio
Sorteggio Vinto Da
Meatballs
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Padawan
-
Marco GramignaTot.4
2
x20
x3
0
x AUTOHIT -
Roberta BinelloTot.11
4
x21
x3
0
x AUTOHIT -
Giovanni AquilaTot.22
5
x24
x3
1
x AUTOHIT -
Elisa GenoveseTot.0
0
x20
x3
1
x AUTOHIT -
Patrick MarzanoTot.8
4
x20
x3
0
x AUTOHIT -
Simone CasaleTot.10
5
x20
x3
0
x AUTOHIT -
Marco MisilmeriTot.6
3
x20
x3
0
x AUTOHIT
Meatballs
-
Federico Listello
1
x20
x3
1
x AUTOHITTot.2
Comportamento scorretto o antisportivo (Minuto: 1 - 4T)Gabriele Bonaldo
5
x20
x3
0
x AUTOHITTot.10
Rossella De Blasio
4
x20
x3
0
x AUTOHITTot.8
Arianna Vismara
6
x20
x3
0
x AUTOHITTot.12
Paolo Guerra
11
x21
x3
0
x AUTOHITTot.25
Mauro Mola
0
x20
x3
0
x AUTOHITTot.0
Sanzioni Disciplinari
Padawan
Meatballs
-
5. Federico ListelloComportamento scorretto o antisportivo (Minuto: 1 - 4T)
Total Queries: 55
Total Time: 0.34441232681274
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776062420.4224
[end] => 1776062420.4227
[time] => 0.0003049373626709
)
[1] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.425
[end] => 1776062420.4252
[time] => 0.0002448558807373
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.4252
[end] => 1776062420.4273
[time] => 0.002094030380249
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.4274
[end] => 1776062420.4396
[time] => 0.012202978134155
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.44
[end] => 1776062420.4422
[time] => 0.0022008419036865
)
[5] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.4423
[end] => 1776062420.4425
[time] => 0.00023698806762695
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.4425
[end] => 1776062420.4446
[time] => 0.0020251274108887
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.4446
[end] => 1776062420.4566
[time] => 0.011992931365967
)
[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 (26,24) ORDER BY lastname,firstname ASC
[start] => 1776062420.457
[end] => 1776062420.4581
[time] => 0.0010650157928467
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062420.4601
[end] => 1776062420.4605
[time] => 0.00041294097900391
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062420.4609
[end] => 1776062420.4612
[time] => 0.00023579597473145
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1776062420.4612
[end] => 1776062420.4618
[time] => 0.00060701370239258
)
[12] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.4623
[end] => 1776062420.4625
[time] => 0.00021219253540039
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.4625
[end] => 1776062420.4646
[time] => 0.00211501121521
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.4647
[end] => 1776062420.4768
[time] => 0.012042999267578
)
[15] => Array
(
[query] => select * from match_roster where match_id = '1986'
[start] => 1776062420.477
[end] => 1776062420.4839
[time] => 0.0068900585174561
)
[16] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.484
[end] => 1776062420.4842
[time] => 0.00023698806762695
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.4843
[end] => 1776062420.4863
[time] => 0.0020430088043213
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.4864
[end] => 1776062420.4984
[time] => 0.012024879455566
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '1986' and (point.point = 'P' or point.point = 'E')
[start] => 1776062420.5005
[end] => 1776062420.5666
[time] => 0.066070079803467
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1776062420.5668
[end] => 1776062420.5671
[time] => 0.00030398368835449
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1776062420.5671
[end] => 1776062420.5673
[time] => 0.00017499923706055
)
[22] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.5674
[end] => 1776062420.5676
[time] => 0.00020718574523926
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.5676
[end] => 1776062420.5697
[time] => 0.002147912979126
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.5698
[end] => 1776062420.582
[time] => 0.012187004089355
)
[25] => Array
(
[query] => select * from match_roster where match_id = '1986'
[start] => 1776062420.5822
[end] => 1776062420.5892
[time] => 0.0070009231567383
)
[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 = '1986' group by player_id
[start] => 1776062420.5892
[end] => 1776062420.6314
[time] => 0.042191028594971
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '1986'
[start] => 1776062420.6316
[end] => 1776062420.6319
[time] => 0.00035905838012695
)
[28] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.632
[end] => 1776062420.6322
[time] => 0.00019407272338867
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.6322
[end] => 1776062420.6344
[time] => 0.0021347999572754
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.6344
[end] => 1776062420.6465
[time] => 0.012091159820557
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1776062420.6469
[end] => 1776062420.6471
[time] => 0.00023603439331055
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1776062420.6472
[end] => 1776062420.6477
[time] => 0.00053215026855469
)
[33] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.6479
[end] => 1776062420.6481
[time] => 0.00025320053100586
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.6482
[end] => 1776062420.6502
[time] => 0.0020430088043213
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.6502
[end] => 1776062420.6623
[time] => 0.012044191360474
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '1986'
[start] => 1776062420.6625
[end] => 1776062420.6633
[time] => 0.00081110000610352
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1776062420.6634
[end] => 1776062420.6636
[time] => 0.0001678466796875
)
[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 = '1986' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1776062420.6636
[end] => 1776062420.6638
[time] => 0.00022482872009277
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1776062420.6639
[end] => 1776062420.6641
[time] => 0.00021886825561523
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1776062420.6642
[end] => 1776062420.6643
[time] => 0.00014114379882812
)
[41] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.6644
[end] => 1776062420.6646
[time] => 0.00016307830810547
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.6646
[end] => 1776062420.6667
[time] => 0.0020411014556885
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.6667
[end] => 1776062420.6788
[time] => 0.012068033218384
)
[44] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.6791
[end] => 1776062420.6794
[time] => 0.00029206275939941
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.6794
[end] => 1776062420.6815
[time] => 0.0021049976348877
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.6816
[end] => 1776062420.6938
[time] => 0.012206077575684
)
[47] => Array
(
[query] => select * from match_roster where match_id = '1986'
[start] => 1776062420.694
[end] => 1776062420.7011
[time] => 0.0070478916168213
)
[48] => Array
(
[query] => select * from point where match_id = '1986' order by point_id ASC
[start] => 1776062420.7011
[end] => 1776062420.7632
[time] => 0.062119960784912
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1776062420.7639
[end] => 1776062420.7643
[time] => 0.00035405158996582
)
[50] => Array
(
[query] => select * from matches where match_id = '1986'
[start] => 1776062420.7643
[end] => 1776062420.7646
[time] => 0.00020599365234375
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '1986'
[start] => 1776062420.7646
[end] => 1776062420.7666
[time] => 0.0020699501037598
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '1986'
[start] => 1776062420.7667
[end] => 1776062420.7788
[time] => 0.012101888656616
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062420.7814
[end] => 1776062420.7818
[time] => 0.00045490264892578
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062420.7826
[end] => 1776062420.7828
[time] => 0.0002591609954834
)
)