DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Killer Hit
Invincibili
Data e Luogo
Campionato
Torneo giovanile U10
Giornata: 3
Data e Luogo
22-03-2026 16:40 - HitBall Arena
Arbitri
Primo Arbitro
1-2 Arbitro Tornei Open
Sorteggio
Sorteggio Vinto Da
Killer Hit
Total Queries: 55
Total Time: 2.043788433075
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786249780.4324
[end] => 1786249780.4326
[time] => 0.00021696090698242
)
[1] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249780.4401
[end] => 1786249780.4444
[time] => 0.0043120384216309
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249780.4444
[end] => 1786249780.4544
[time] => 0.010024070739746
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249780.4545
[end] => 1786249780.5092
[time] => 0.054666996002197
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249780.5096
[end] => 1786249780.5305
[time] => 0.020963191986084
)
[5] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249780.5307
[end] => 1786249780.5339
[time] => 0.0032069683074951
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249780.5339
[end] => 1786249780.548
[time] => 0.014101028442383
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249780.5481
[end] => 1786249780.6133
[time] => 0.065189123153687
)
[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 (93,94) ORDER BY lastname,firstname ASC
[start] => 1786249780.6137
[end] => 1786249780.623
[time] => 0.0092298984527588
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786249780.6239
[end] => 1786249780.637
[time] => 0.013052940368652
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786249780.6374
[end] => 1786249780.6591
[time] => 0.021720886230469
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786249780.6593
[end] => 1786249780.6631
[time] => 0.0038430690765381
)
[12] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249780.6636
[end] => 1786249780.6763
[time] => 0.012753009796143
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249780.6764
[end] => 1786249780.6946
[time] => 0.018257856369019
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249780.6947
[end] => 1786249780.7995
[time] => 0.10474991798401
)
[15] => Array
(
[query] => select * from match_roster where match_id = '4762'
[start] => 1786249780.7998
[end] => 1786249780.8456
[time] => 0.045853137969971
)
[16] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249780.8457
[end] => 1786249780.8473
[time] => 0.0015151500701904
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249780.8473
[end] => 1786249780.8651
[time] => 0.017818927764893
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249780.8652
[end] => 1786249780.9311
[time] => 0.065932989120483
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4762' and (point.point = 'P' or point.point = 'E')
[start] => 1786249780.9335
[end] => 1786249781.3166
[time] => 0.38313102722168
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786249781.3167
[end] => 1786249781.3169
[time] => 0.00022315979003906
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786249781.317
[end] => 1786249781.3172
[time] => 0.00019192695617676
)
[22] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249781.3173
[end] => 1786249781.3189
[time] => 0.0015890598297119
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249781.3189
[end] => 1786249781.3277
[time] => 0.0088441371917725
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249781.3278
[end] => 1786249781.3963
[time] => 0.068547010421753
)
[25] => Array
(
[query] => select * from match_roster where match_id = '4762'
[start] => 1786249781.3966
[end] => 1786249781.4366
[time] => 0.040061950683594
)
[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 = '4762' group by player_id
[start] => 1786249781.4367
[end] => 1786249781.6731
[time] => 0.23638606071472
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '4762'
[start] => 1786249781.6732
[end] => 1786249781.676
[time] => 0.0027508735656738
)
[28] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249781.6761
[end] => 1786249781.6826
[time] => 0.006566047668457
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249781.6826
[end] => 1786249781.6934
[time] => 0.010807037353516
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249781.6935
[end] => 1786249781.7538
[time] => 0.060226202011108
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786249781.7541
[end] => 1786249781.7562
[time] => 0.002112865447998
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786249781.7563
[end] => 1786249781.7599
[time] => 0.0036609172821045
)
[33] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249781.7601
[end] => 1786249781.7608
[time] => 0.0006098747253418
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249781.7608
[end] => 1786249781.7736
[time] => 0.01286506652832
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249781.7737
[end] => 1786249781.8469
[time] => 0.07314395904541
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '4762'
[start] => 1786249781.8471
[end] => 1786249781.8481
[time] => 0.00099420547485352
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786249781.8482
[end] => 1786249781.8497
[time] => 0.001507043838501
)
[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 = '4762' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786249781.8497
[end] => 1786249781.8553
[time] => 0.0055580139160156
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786249781.8554
[end] => 1786249781.8556
[time] => 0.00020408630371094
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786249781.8557
[end] => 1786249781.8559
[time] => 0.0002140998840332
)
[41] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249781.856
[end] => 1786249781.8563
[time] => 0.00021719932556152
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249781.8563
[end] => 1786249781.8621
[time] => 0.0058209896087646
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249781.8622
[end] => 1786249781.924
[time] => 0.061853885650635
)
[44] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249781.9243
[end] => 1786249781.9283
[time] => 0.0039420127868652
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249781.9283
[end] => 1786249781.9393
[time] => 0.011025905609131
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249781.9394
[end] => 1786249782.0018
[time] => 0.062388896942139
)
[47] => Array
(
[query] => select * from match_roster where match_id = '4762'
[start] => 1786249782.002
[end] => 1786249782.0424
[time] => 0.04032301902771
)
[48] => Array
(
[query] => select * from point where match_id = '4762' order by point_id ASC
[start] => 1786249782.0424
[end] => 1786249782.3949
[time] => 0.35248589515686
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786249782.3953
[end] => 1786249782.4056
[time] => 0.010354995727539
)
[50] => Array
(
[query] => select * from matches where match_id = '4762'
[start] => 1786249782.4058
[end] => 1786249782.406
[time] => 0.00021505355834961
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4762'
[start] => 1786249782.406
[end] => 1786249782.4135
[time] => 0.0074760913848877
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4762'
[start] => 1786249782.4136
[end] => 1786249782.4861
[time] => 0.072552919387817
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786249782.4925
[end] => 1786249782.4958
[time] => 0.0033128261566162
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786249782.4966
[end] => 1786249782.5009
[time] => 0.0042159557342529
)
)
