DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Otto Bhit
Valdocco Champions
Data e Luogo
Campionato
Torneo giovanile U14 Centro
Giornata: 1
Data e Luogo
14-03-2026 09:40 - Valdocco
Arbitri
Primo Arbitro
1-2 Arbitro Tornei Open
Sorteggio
Sorteggio Vinto Da
Otto Bhit
Total Queries: 55
Total Time: 0.38879895210266
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781154242.2118
[end] => 1781154242.2121
[time] => 0.00033402442932129
)
[1] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.2145
[end] => 1781154242.2147
[time] => 0.00027918815612793
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.2148
[end] => 1781154242.2172
[time] => 0.0024518966674805
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.2173
[end] => 1781154242.232
[time] => 0.014677047729492
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.2324
[end] => 1781154242.2352
[time] => 0.0027811527252197
)
[5] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.2354
[end] => 1781154242.2364
[time] => 0.0010249614715576
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.2365
[end] => 1781154242.2391
[time] => 0.0026018619537354
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.2391
[end] => 1781154242.2538
[time] => 0.014734029769897
)
[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 (68,76) ORDER BY lastname,firstname ASC
[start] => 1781154242.2544
[end] => 1781154242.2554
[time] => 0.0010559558868408
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781154242.2564
[end] => 1781154242.2569
[time] => 0.00050210952758789
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781154242.2573
[end] => 1781154242.2576
[time] => 0.00029182434082031
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781154242.2578
[end] => 1781154242.2584
[time] => 0.00066208839416504
)
[12] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.2591
[end] => 1781154242.2593
[time] => 0.00022292137145996
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.2593
[end] => 1781154242.2618
[time] => 0.0024371147155762
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.2618
[end] => 1781154242.276
[time] => 0.01416015625
)
[15] => Array
(
[query] => select * from match_roster where match_id = '4710'
[start] => 1781154242.2763
[end] => 1781154242.2845
[time] => 0.0081608295440674
)
[16] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.2846
[end] => 1781154242.2849
[time] => 0.00030398368835449
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.285
[end] => 1781154242.2873
[time] => 0.0023741722106934
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.2874
[end] => 1781154242.3003
[time] => 0.012882947921753
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4710' and (point.point = 'P' or point.point = 'E')
[start] => 1781154242.3027
[end] => 1781154242.3778
[time] => 0.075030088424683
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781154242.3779
[end] => 1781154242.3783
[time] => 0.00034308433532715
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781154242.3783
[end] => 1781154242.3785
[time] => 0.00018501281738281
)
[22] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.3786
[end] => 1781154242.3788
[time] => 0.00023198127746582
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.3788
[end] => 1781154242.3813
[time] => 0.0024261474609375
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.3813
[end] => 1781154242.3943
[time] => 0.012969017028809
)
[25] => Array
(
[query] => select * from match_roster where match_id = '4710'
[start] => 1781154242.3946
[end] => 1781154242.4027
[time] => 0.0081629753112793
)
[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 = '4710' group by player_id
[start] => 1781154242.4028
[end] => 1781154242.4504
[time] => 0.047646045684814
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '4710'
[start] => 1781154242.4506
[end] => 1781154242.451
[time] => 0.00039315223693848
)
[28] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.4511
[end] => 1781154242.4513
[time] => 0.00021815299987793
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.4513
[end] => 1781154242.4537
[time] => 0.0024080276489258
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.4538
[end] => 1781154242.4668
[time] => 0.012978076934814
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781154242.4671
[end] => 1781154242.4674
[time] => 0.00031185150146484
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781154242.4675
[end] => 1781154242.4681
[time] => 0.00060510635375977
)
[33] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.4683
[end] => 1781154242.4685
[time] => 0.00022196769714355
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.4686
[end] => 1781154242.4709
[time] => 0.0023629665374756
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.471
[end] => 1781154242.4839
[time] => 0.012878894805908
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '4710'
[start] => 1781154242.4841
[end] => 1781154242.4852
[time] => 0.0010180473327637
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781154242.4853
[end] => 1781154242.4854
[time] => 0.00017189979553223
)
[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 = '4710' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781154242.4854
[end] => 1781154242.4857
[time] => 0.00020599365234375
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781154242.4857
[end] => 1781154242.4859
[time] => 0.00016021728515625
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781154242.4859
[end] => 1781154242.4861
[time] => 0.00012516975402832
)
[41] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.4862
[end] => 1781154242.4864
[time] => 0.0001828670501709
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.4864
[end] => 1781154242.4888
[time] => 0.0023999214172363
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.4889
[end] => 1781154242.5017
[time] => 0.012873888015747
)
[44] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.5021
[end] => 1781154242.5023
[time] => 0.00025391578674316
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.5023
[end] => 1781154242.5047
[time] => 0.002406120300293
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.5048
[end] => 1781154242.5176
[time] => 0.012818098068237
)
[47] => Array
(
[query] => select * from match_roster where match_id = '4710'
[start] => 1781154242.5179
[end] => 1781154242.5259
[time] => 0.0080170631408691
)
[48] => Array
(
[query] => select * from point where match_id = '4710' order by point_id ASC
[start] => 1781154242.526
[end] => 1781154242.5962
[time] => 0.070250034332275
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781154242.5969
[end] => 1781154242.5972
[time] => 0.00032496452331543
)
[50] => Array
(
[query] => select * from matches where match_id = '4710'
[start] => 1781154242.5973
[end] => 1781154242.5975
[time] => 0.00020885467529297
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4710'
[start] => 1781154242.5975
[end] => 1781154242.5999
[time] => 0.002377986907959
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4710'
[start] => 1781154242.5999
[end] => 1781154242.6129
[time] => 0.012953996658325
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781154242.6155
[end] => 1781154242.616
[time] => 0.00047707557678223
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781154242.6168
[end] => 1781154242.6171
[time] => 0.00026202201843262
)
)
