DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Fantastici 14
Vagabondi Venaria
Data e Luogo
Campionato
Torneo giovanile U14 Nord
Giornata: 4
Data e Luogo
12-04-2026 12:10 - HitBall Arena
Arbitri
Primo Arbitro
1-2 Arbitro Tornei Open
Sorteggio
Sorteggio Vinto Da
Vagabondi Venaria
Total Queries: 55
Total Time: 1.3979563713074
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786249280.7802
[end] => 1786249280.7804
[time] => 0.00023913383483887
)
[1] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249280.7893
[end] => 1786249280.7924
[time] => 0.0030889511108398
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249280.7925
[end] => 1786249280.8009
[time] => 0.0084221363067627
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249280.801
[end] => 1786249280.8435
[time] => 0.042521953582764
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249280.8439
[end] => 1786249280.8559
[time] => 0.011941909790039
)
[5] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249280.856
[end] => 1786249280.8579
[time] => 0.0019080638885498
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249280.8579
[end] => 1786249280.8616
[time] => 0.0036780834197998
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249280.8616
[end] => 1786249280.8874
[time] => 0.025743007659912
)
[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 (79,89) ORDER BY lastname,firstname ASC
[start] => 1786249280.8879
[end] => 1786249280.8906
[time] => 0.0027780532836914
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786249280.8916
[end] => 1786249280.8928
[time] => 0.001183032989502
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786249280.8932
[end] => 1786249280.895
[time] => 0.0017142295837402
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786249280.8951
[end] => 1786249280.8958
[time] => 0.00069999694824219
)
[12] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249280.8962
[end] => 1786249280.8969
[time] => 0.00068092346191406
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249280.8969
[end] => 1786249280.9019
[time] => 0.0049469470977783
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249280.9019
[end] => 1786249280.9289
[time] => 0.026960849761963
)
[15] => Array
(
[query] => select * from match_roster where match_id = '4741'
[start] => 1786249280.9292
[end] => 1786249280.9586
[time] => 0.029433965682983
)
[16] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249280.9588
[end] => 1786249280.9609
[time] => 0.0021960735321045
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249280.961
[end] => 1786249280.9654
[time] => 0.0044138431549072
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249280.9655
[end] => 1786249281.0047
[time] => 0.039189100265503
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4741' and (point.point = 'P' or point.point = 'E')
[start] => 1786249281.0081
[end] => 1786249281.2099
[time] => 0.20171999931335
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786249281.21
[end] => 1786249281.2119
[time] => 0.0019600391387939
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786249281.212
[end] => 1786249281.2122
[time] => 0.00020384788513184
)
[22] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249281.2123
[end] => 1786249281.2125
[time] => 0.00022315979003906
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249281.2126
[end] => 1786249281.2221
[time] => 0.0095329284667969
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249281.2222
[end] => 1786249281.2706
[time] => 0.048475980758667
)
[25] => Array
(
[query] => select * from match_roster where match_id = '4741'
[start] => 1786249281.2709
[end] => 1786249281.3118
[time] => 0.040850877761841
)
[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 = '4741' group by player_id
[start] => 1786249281.3118
[end] => 1786249281.5827
[time] => 0.27087807655334
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '4741'
[start] => 1786249281.5829
[end] => 1786249281.5913
[time] => 0.0084121227264404
)
[28] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249281.5914
[end] => 1786249281.5916
[time] => 0.00022101402282715
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249281.5916
[end] => 1786249281.6021
[time] => 0.010479927062988
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249281.6022
[end] => 1786249281.6751
[time] => 0.07296895980835
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786249281.6755
[end] => 1786249281.6764
[time] => 0.00092220306396484
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786249281.6765
[end] => 1786249281.677
[time] => 0.00056695938110352
)
[33] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249281.6772
[end] => 1786249281.6807
[time] => 0.0035238265991211
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249281.6808
[end] => 1786249281.6862
[time] => 0.0054500102996826
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249281.6863
[end] => 1786249281.7249
[time] => 0.038609027862549
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '4741'
[start] => 1786249281.7252
[end] => 1786249281.7291
[time] => 0.0039200782775879
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786249281.7292
[end] => 1786249281.7309
[time] => 0.0016851425170898
)
[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 = '4741' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786249281.7309
[end] => 1786249281.7311
[time] => 0.00025606155395508
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786249281.7312
[end] => 1786249281.7314
[time] => 0.0001988410949707
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786249281.7315
[end] => 1786249281.7316
[time] => 0.00017595291137695
)
[41] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249281.7318
[end] => 1786249281.7337
[time] => 0.0019159317016602
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249281.7338
[end] => 1786249281.7405
[time] => 0.0067059993743896
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249281.7405
[end] => 1786249281.7889
[time] => 0.048350811004639
)
[44] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249281.7892
[end] => 1786249281.794
[time] => 0.004828929901123
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249281.7941
[end] => 1786249281.8017
[time] => 0.0076048374176025
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249281.8017
[end] => 1786249281.8599
[time] => 0.058164834976196
)
[47] => Array
(
[query] => select * from match_roster where match_id = '4741'
[start] => 1786249281.8602
[end] => 1786249281.8916
[time] => 0.031389951705933
)
[48] => Array
(
[query] => select * from point where match_id = '4741' order by point_id ASC
[start] => 1786249281.8916
[end] => 1786249282.1265
[time] => 0.23490595817566
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786249282.127
[end] => 1786249282.1309
[time] => 0.0038940906524658
)
[50] => Array
(
[query] => select * from matches where match_id = '4741'
[start] => 1786249282.131
[end] => 1786249282.1337
[time] => 0.0027198791503906
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4741'
[start] => 1786249282.1338
[end] => 1786249282.1406
[time] => 0.0068919658660889
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4741'
[start] => 1786249282.1407
[end] => 1786249282.1955
[time] => 0.054830074310303
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786249282.1996
[end] => 1786249282.2018
[time] => 0.0022659301757812
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786249282.2026
[end] => 1786249282.2032
[time] => 0.00051188468933105
)
)
