Referto Partita: Sheet vs Together Hit
Sheet
Together Hit
RISULTATO FINALE
91
62
1° Tempo
23
17
2° Tempo
33
13
3° Tempo
35
32
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 A2
Giornata: 4
Giornata: 4
Data e Luogo
25-11-2021 21:45 - Palazzeschi
Arbitri
Primo Arbitro
Spina Gabriele
Secondo Arbitro
Principato Lucrezia
Refertista
Principato Lucrezia
Sorteggio
Sorteggio Vinto Da
Sheet
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Sheet
-
Andrea LavalleTot.22
8
x22
x3
0
x AUTOHIT -
Massimiliano TaglianettiTot.11
4
x21
x3
0
x AUTOHIT -
Stefano BenedettiTot.29
13
x21
x3
0
x AUTOHIT -
Filippo VenturiniTot.10
2
x22
x3
0
x AUTOHIT -
Davide SalvaggioTot.19
8
x21
x3
0
x AUTOHIT
Together Hit
-
Francesco De Gaetano
7
x23
x3
0
x AUTOHITTot.23
Gabriele Gazzetta
5
x24
x3
0
x AUTOHITTot.22
Fabrizio Alberto
4
x20
x3
0
x AUTOHITTot.8
Sergio Laganà
2
x20
x3
0
x AUTOHITTot.4
Carlotta Amodeo
1
x21
x3
0
x AUTOHITTot.5
Total Queries: 55
Total Time: 0.55603933334351
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770978189.219
[end] => 1770978189.2194
[time] => 0.00033116340637207
)
[1] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.2216
[end] => 1770978189.2219
[time] => 0.00031685829162598
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.2219
[end] => 1770978189.2241
[time] => 0.0021259784698486
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.2241
[end] => 1770978189.2363
[time] => 0.01216721534729
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.2366
[end] => 1770978189.2389
[time] => 0.0022170543670654
)
[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] => 1770978189.2391
[end] => 1770978189.2458
[time] => 0.0067460536956787
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978189.2495
[end] => 1770978189.25
[time] => 0.00042390823364258
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978189.2504
[end] => 1770978189.2506
[time] => 0.00023508071899414
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770978189.2507
[end] => 1770978189.2514
[time] => 0.00071096420288086
)
[9] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.2519
[end] => 1770978189.2521
[time] => 0.00022506713867188
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.2521
[end] => 1770978189.2542
[time] => 0.0021028518676758
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.2543
[end] => 1770978189.2664
[time] => 0.012084007263184
)
[12] => Array
(
[query] => select * from match_roster where match_id = '2063'
[start] => 1770978189.2666
[end] => 1770978189.2742
[time] => 0.0075831413269043
)
[13] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.2744
[end] => 1770978189.2746
[time] => 0.00023293495178223
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.2747
[end] => 1770978189.2769
[time] => 0.0022108554840088
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.277
[end] => 1770978189.2968
[time] => 0.01980996131897
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2063' and (point.point = 'P' or point.point = 'E')
[start] => 1770978189.303
[end] => 1770978189.3829
[time] => 0.079890966415405
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1770978189.383
[end] => 1770978189.3832
[time] => 0.00026702880859375
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1770978189.3833
[end] => 1770978189.3859
[time] => 0.0025660991668701
)
[19] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.386
[end] => 1770978189.3862
[time] => 0.0001981258392334
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.3862
[end] => 1770978189.3882
[time] => 0.0020101070404053
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.3882
[end] => 1770978189.4099
[time] => 0.021672964096069
)
[22] => Array
(
[query] => select * from match_roster where match_id = '2063'
[start] => 1770978189.4101
[end] => 1770978189.4238
[time] => 0.013643980026245
)
[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 = '2063' group by player_id
[start] => 1770978189.4238
[end] => 1770978189.5097
[time] => 0.085914134979248
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '2063'
[start] => 1770978189.5098
[end] => 1770978189.5119
[time] => 0.0020689964294434
)
[25] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.512
[end] => 1770978189.5122
[time] => 0.00017619132995605
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.5122
[end] => 1770978189.5158
[time] => 0.0036411285400391
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.5159
[end] => 1770978189.5378
[time] => 0.021888017654419
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1770978189.538
[end] => 1770978189.5399
[time] => 0.0018839836120605
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1770978189.54
[end] => 1770978189.5406
[time] => 0.00060915946960449
)
[30] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.5408
[end] => 1770978189.5411
[time] => 0.00023293495178223
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.5411
[end] => 1770978189.5435
[time] => 0.0024690628051758
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.5436
[end] => 1770978189.5698
[time] => 0.026165962219238
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '2063'
[start] => 1770978189.57
[end] => 1770978189.5745
[time] => 0.0044879913330078
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1770978189.5746
[end] => 1770978189.5748
[time] => 0.00024914741516113
)
[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 = '2063' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1770978189.5748
[end] => 1770978189.5751
[time] => 0.00023388862609863
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1770978189.5752
[end] => 1770978189.5754
[time] => 0.00020098686218262
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1770978189.5754
[end] => 1770978189.5756
[time] => 0.00018715858459473
)
[38] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.5758
[end] => 1770978189.576
[time] => 0.0001981258392334
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.576
[end] => 1770978189.5811
[time] => 0.0051097869873047
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.5812
[end] => 1770978189.6005
[time] => 0.019321918487549
)
[41] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.6008
[end] => 1770978189.6029
[time] => 0.0021109580993652
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.6029
[end] => 1770978189.6062
[time] => 0.0032689571380615
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.6062
[end] => 1770978189.6291
[time] => 0.022838830947876
)
[44] => Array
(
[query] => select * from match_roster where match_id = '2063'
[start] => 1770978189.6293
[end] => 1770978189.6442
[time] => 0.014965057373047
)
[45] => Array
(
[query] => select * from point where match_id = '2063' order by point_id ASC
[start] => 1770978189.6443
[end] => 1770978189.7274
[time] => 0.083111047744751
)
[46] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.7279
[end] => 1770978189.7287
[time] => 0.00072407722473145
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.7287
[end] => 1770978189.7357
[time] => 0.0070209503173828
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.7358
[end] => 1770978189.7574
[time] => 0.021669864654541
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1770978189.7579
[end] => 1770978189.7608
[time] => 0.0028951168060303
)
[50] => Array
(
[query] => select * from matches where match_id = '2063'
[start] => 1770978189.7609
[end] => 1770978189.761
[time] => 0.00019097328186035
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2063'
[start] => 1770978189.7611
[end] => 1770978189.7652
[time] => 0.0041308403015137
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2063'
[start] => 1770978189.7652
[end] => 1770978189.7892
[time] => 0.023910045623779
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770978189.7916
[end] => 1770978189.792
[time] => 0.00041079521179199
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770978189.7927
[end] => 1770978189.7967
[time] => 0.0039808750152588
)
)