Referto Partita: Sapore di Mara vs Smaronne
Sapore di Mara
Smaronne
RISULTATO FINALE
54
97
1° Tempo
19
32
2° Tempo
22
33
3° Tempo
13
32
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Torneo Femminile 2023
Giornata: 6
Giornata: 6
Data e Luogo
30-05-2023 20:45 - Frassati
Arbitri
Primo Arbitro
Riccio Roberto
Secondo Arbitro
Riccio Roberto
Refertista
ASD Sinombre
Sorteggio
Sorteggio Vinto Da
Sapore di Mara
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Sapore di Mara
-
Carola Casassa VignaTot.17
7
x21
x3
1
x AUTOHIT -
Laura MongiTot.0
0
x20
x3
0
x AUTOHIT -
Alessia VisintinTot.
18
9
x20
x3
0
x AUTOHIT -
SIlvia PetitiTot.6
3
x20
x3
0
x AUTOHIT -
Mara FerrarisTot.13
5
x21
x3
0
x AUTOHIT
Smaronne
-
Federica Nardacchione
2
x22
x3
0
x AUTOHITTot.10
Julie Carpinelli
6
x20
x3
0
x AUTOHITTot.12
Adina Catalina Ghimpu
1
x21
x3
0
x AUTOHITTot.5
Patrizia Cascino
11
x24
x3
0
x AUTOHITTot.34
Martina Lupo
2
x21
x3
0
x AUTOHITTot.7
Cristina Vaudagna
2
x22
x3
0
x AUTOHITTot.10
Carlotta Amodeo
9
x20
x3
0
x AUTOHITTot.18
Total Queries: 55
Total Time: 3.6499576568604
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776062071.0617
[end] => 1776062071.0673
[time] => 0.0055460929870605
)
[1] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062071.0696
[end] => 1776062071.0719
[time] => 0.0022568702697754
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062071.0719
[end] => 1776062071.0918
[time] => 0.019906044006348
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062071.0919
[end] => 1776062071.2412
[time] => 0.14923501014709
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062071.2415
[end] => 1776062071.2436
[time] => 0.0021600723266602
)
[5] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062071.2437
[end] => 1776062071.2583
[time] => 0.014511108398438
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062071.2583
[end] => 1776062071.2774
[time] => 0.019139051437378
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062071.2775
[end] => 1776062071.4027
[time] => 0.12524795532227
)
[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 (52,51) ORDER BY lastname,firstname ASC
[start] => 1776062071.4031
[end] => 1776062071.4056
[time] => 0.0025010108947754
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062071.407
[end] => 1776062071.4221
[time] => 0.01512598991394
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062071.4225
[end] => 1776062071.4228
[time] => 0.00030207633972168
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1776062071.4229
[end] => 1776062071.4236
[time] => 0.00071215629577637
)
[12] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062071.4241
[end] => 1776062071.4257
[time] => 0.0015881061553955
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062071.4258
[end] => 1776062071.4347
[time] => 0.0089600086212158
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062071.4348
[end] => 1776062071.5376
[time] => 0.1027979850769
)
[15] => Array
(
[query] => select * from match_roster where match_id = '2857'
[start] => 1776062071.5379
[end] => 1776062071.5869
[time] => 0.049017190933228
)
[16] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062071.587
[end] => 1776062071.5872
[time] => 0.00022411346435547
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062071.5872
[end] => 1776062071.6004
[time] => 0.013174057006836
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062071.6005
[end] => 1776062071.7984
[time] => 0.19789004325867
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2857' and (point.point = 'P' or point.point = 'E')
[start] => 1776062071.8006
[end] => 1776062072.7747
[time] => 0.97416687011719
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1776062072.7748
[end] => 1776062072.7988
[time] => 0.023996829986572
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1776062072.7989
[end] => 1776062072.7991
[time] => 0.00019288063049316
)
[22] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062072.7992
[end] => 1776062072.7994
[time] => 0.00018906593322754
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062072.7994
[end] => 1776062072.8196
[time] => 0.020151853561401
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062072.8196
[end] => 1776062072.9948
[time] => 0.17512798309326
)
[25] => Array
(
[query] => select * from match_roster where match_id = '2857'
[start] => 1776062072.995
[end] => 1776062073.0903
[time] => 0.095340967178345
)
[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 = '2857' group by player_id
[start] => 1776062073.0904
[end] => 1776062073.3775
[time] => 0.28712797164917
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '2857'
[start] => 1776062073.3777
[end] => 1776062073.3817
[time] => 0.004025936126709
)
[28] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062073.3818
[end] => 1776062073.3839
[time] => 0.0021181106567383
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062073.384
[end] => 1776062073.3981
[time] => 0.014116048812866
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062073.3982
[end] => 1776062073.4968
[time] => 0.098596096038818
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1776062073.4971
[end] => 1776062073.507
[time] => 0.0099492073059082
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1776062073.5072
[end] => 1776062073.5153
[time] => 0.0081717967987061
)
[33] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062073.5156
[end] => 1776062073.5169
[time] => 0.0013151168823242
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062073.5169
[end] => 1776062073.5379
[time] => 0.020931959152222
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062073.538
[end] => 1776062073.6365
[time] => 0.098566055297852
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '2857'
[start] => 1776062073.6368
[end] => 1776062073.6526
[time] => 0.015739917755127
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1776062073.6527
[end] => 1776062073.6569
[time] => 0.0042150020599365
)
[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 = '2857' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1776062073.657
[end] => 1776062073.659
[time] => 0.0020289421081543
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1776062073.6591
[end] => 1776062073.6679
[time] => 0.0088489055633545
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1776062073.6681
[end] => 1776062073.6699
[time] => 0.001784086227417
)
[41] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062073.67
[end] => 1776062073.6719
[time] => 0.0018301010131836
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062073.6719
[end] => 1776062073.6757
[time] => 0.0038371086120605
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062073.6758
[end] => 1776062073.8345
[time] => 0.15869498252869
)
[44] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062073.8348
[end] => 1776062073.8357
[time] => 0.00091695785522461
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062073.8358
[end] => 1776062073.8639
[time] => 0.028100967407227
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062073.8639
[end] => 1776062074.0217
[time] => 0.15774583816528
)
[47] => Array
(
[query] => select * from match_roster where match_id = '2857'
[start] => 1776062074.0219
[end] => 1776062074.0743
[time] => 0.052316904067993
)
[48] => Array
(
[query] => select * from point where match_id = '2857' order by point_id ASC
[start] => 1776062074.0743
[end] => 1776062074.6163
[time] => 0.54201602935791
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1776062074.617
[end] => 1776062074.6187
[time] => 0.0017430782318115
)
[50] => Array
(
[query] => select * from matches where match_id = '2857'
[start] => 1776062074.6188
[end] => 1776062074.619
[time] => 0.0002140998840332
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2857'
[start] => 1776062074.6191
[end] => 1776062074.6315
[time] => 0.012464046478271
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2857'
[start] => 1776062074.6316
[end] => 1776062074.7171
[time] => 0.08548903465271
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062074.7206
[end] => 1776062074.7235
[time] => 0.0029239654541016
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062074.7243
[end] => 1776062074.729
[time] => 0.0046679973602295
)
)