Risultato Live Partita: Pellegrini Venaria vs Bioghettyson
Pellegrini Venaria
Bioghettyson
° Tempo
0
0
Progresso
Dettagli Partita
Data e Luogo
Campionato
Campionato Eccellenza 2025/2026 A2
Giornata: 10
Data e Luogo
21-01-2026 20:30 - Venaria
Arbitri
Primo ArbitroWarning: Undefined array key 0 in /www/wwwroot/plvhitball.it/develop/public/view/theme/default/template/match/live/live.tpl on line 482Warning: Trying to access array offset on value of type null in /www/wwwroot/plvhitball.it/develop/public/view/theme/default/template/match/live/live.tpl on line 482Warning: Undefined array key 0 in /www/wwwroot/plvhitball.it/develop/public/view/theme/default/template/match/live/live.tpl on line 482Warning: Trying to access array offset on value of type null in /www/wwwroot/plvhitball.it/develop/public/view/theme/default/template/match/live/live.tpl on line 482
Total Queries: 56
Total Time: 0.96893000602722
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1766077341.5795
[end] => 1766077341.5808
[time] => 0.0012979507446289
)
[1] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077341.5873
[end] => 1766077341.5878
[time] => 0.00042009353637695
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077341.5878
[end] => 1766077341.5902
[time] => 0.002377986907959
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077341.5903
[end] => 1766077341.6113
[time] => 0.021005868911743
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077341.6116
[end] => 1766077341.6232
[time] => 0.011583089828491
)
[5] => Array
(
[query] => select * from match_time where match_id = '4181' order by id DESC limit 1
[start] => 1766077341.6233
[end] => 1766077341.6292
[time] => 0.005836009979248
)
[6] => 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] => 1766077341.6295
[end] => 1766077341.6453
[time] => 0.015799045562744
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1766077341.6538
[end] => 1766077341.6541
[time] => 0.00037693977355957
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1766077341.6546
[end] => 1766077341.6548
[time] => 0.0002589225769043
)
[9] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1766077341.6549
[end] => 1766077341.6563
[time] => 0.0014140605926514
)
[10] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077341.6569
[end] => 1766077341.6574
[time] => 0.00053286552429199
)
[11] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077341.6574
[end] => 1766077341.6597
[time] => 0.0022778511047363
)
[12] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077341.6598
[end] => 1766077341.686
[time] => 0.026172161102295
)
[13] => Array
(
[query] => select * from match_roster where match_id = '4181'
[start] => 1766077341.6862
[end] => 1766077341.7007
[time] => 0.01449990272522
)
[14] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077341.7008
[end] => 1766077341.7028
[time] => 0.0019130706787109
)
[15] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077341.7028
[end] => 1766077341.7047
[time] => 0.0018839836120605
)
[16] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077341.7048
[end] => 1766077341.7298
[time] => 0.025057077407837
)
[17] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077341.7303
[end] => 1766077341.7339
[time] => 0.0035738945007324
)
[18] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077341.7339
[end] => 1766077341.7408
[time] => 0.0068778991699219
)
[19] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077341.7417
[end] => 1766077341.7747
[time] => 0.0329270362854
)
[20] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077341.7752
[end] => 1766077341.781
[time] => 0.0057840347290039
)
[21] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077341.781
[end] => 1766077341.786
[time] => 0.0050070285797119
)
[22] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077341.7861
[end] => 1766077341.8326
[time] => 0.046528816223145
)
[23] => Array
(
[query] => select * from match_roster where match_id = '4181'
[start] => 1766077341.8329
[end] => 1766077341.8549
[time] => 0.022053003311157
)
[24] => Array
(
[query] => select * from point where match_id = '4181' order by point_id ASC
[start] => 1766077341.855
[end] => 1766077342.0663
[time] => 0.21129202842712
)
[25] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4181' and (point.point = 'P' or point.point = 'E')
[start] => 1766077342.0666
[end] => 1766077342.3061
[time] => 0.23950791358948
)
[26] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1766077342.3063
[end] => 1766077342.3087
[time] => 0.0024669170379639
)
[27] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1766077342.3088
[end] => 1766077342.309
[time] => 0.00019192695617676
)
[28] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077342.3091
[end] => 1766077342.3109
[time] => 0.00180983543396
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077342.3109
[end] => 1766077342.3144
[time] => 0.003525972366333
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077342.3145
[end] => 1766077342.3372
[time] => 0.022676944732666
)
[31] => Array
(
[query] => select * from match_roster where match_id = '4181'
[start] => 1766077342.3375
[end] => 1766077342.3496
[time] => 0.012164115905762
)
[32] => 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 = '4181' group by player_id
[start] => 1766077342.3497
[end] => 1766077342.4499
[time] => 0.10018396377563
)
[33] => Array
(
[query] => select * from penalty_to_team where match_id = '4181'
[start] => 1766077342.45
[end] => 1766077342.4504
[time] => 0.00035500526428223
)
[34] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077342.4505
[end] => 1766077342.4517
[time] => 0.0012798309326172
)
[35] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077342.4518
[end] => 1766077342.4537
[time] => 0.0019099712371826
)
[36] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077342.4537
[end] => 1766077342.4773
[time] => 0.02352499961853
)
[37] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1766077342.4777
[end] => 1766077342.479
[time] => 0.0012860298156738
)
[38] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1766077342.479
[end] => 1766077342.4796
[time] => 0.00056791305541992
)
[39] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077342.4798
[end] => 1766077342.4807
[time] => 0.00090789794921875
)
[40] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077342.4808
[end] => 1766077342.4826
[time] => 0.0018880367279053
)
[41] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077342.4827
[end] => 1766077342.5071
[time] => 0.02435302734375
)
[42] => Array
(
[query] => select * from match_staff_roster where match_id = '4181'
[start] => 1766077342.5074
[end] => 1766077342.5094
[time] => 0.0020370483398438
)
[43] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1766077342.5095
[end] => 1766077342.5097
[time] => 0.00018906593322754
)
[44] => 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 = '4181' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1766077342.5097
[end] => 1766077342.5099
[time] => 0.0001988410949707
)
[45] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1766077342.51
[end] => 1766077342.5101
[time] => 0.00015592575073242
)
[46] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1766077342.5102
[end] => 1766077342.5118
[time] => 0.0016579627990723
)
[47] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077342.5119
[end] => 1766077342.5121
[time] => 0.00018501281738281
)
[48] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077342.5121
[end] => 1766077342.516
[time] => 0.0038771629333496
)
[49] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077342.516
[end] => 1766077342.54
[time] => 0.023988008499146
)
[50] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1766077342.5405
[end] => 1766077342.5417
[time] => 0.0012550354003906
)
[51] => Array
(
[query] => select * from matches where match_id = '4181'
[start] => 1766077342.5418
[end] => 1766077342.542
[time] => 0.00021100044250488
)
[52] => Array
(
[query] => select time,closed from match_time where match_id = '4181'
[start] => 1766077342.542
[end] => 1766077342.5461
[time] => 0.0040628910064697
)
[53] => Array
(
[query] => SELECT * FROM match_data where match_id = '4181'
[start] => 1766077342.5462
[end] => 1766077342.57
[time] => 0.023838996887207
)
[54] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1766077342.5744
[end] => 1766077342.5761
[time] => 0.0016820430755615
)
[55] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1766077342.5769
[end] => 1766077342.5771
[time] => 0.00024008750915527
)
)
