DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Orba In Black
Giasthit
Data e Luogo
Campionato
Campionato Misto Start
Giornata: 5
Data e Luogo
22-02-2026 10:05 - Orbassano
Arbitri
Primo Arbitro
ASD Polisportiva Oratorio Orbassano
Refertista
Agnelli Filippo
Sorteggio
Sorteggio Vinto Da
Giasthit
Total Queries: 55
Total Time: 0.91484069824219
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781155394.7904
[end] => 1781155394.7908
[time] => 0.00044608116149902
)
[1] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155394.7938
[end] => 1781155394.7944
[time] => 0.00067400932312012
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155394.7944
[end] => 1781155394.8009
[time] => 0.0064258575439453
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155394.801
[end] => 1781155394.8261
[time] => 0.025079965591431
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155394.8264
[end] => 1781155394.8333
[time] => 0.0068800449371338
)
[5] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155394.8334
[end] => 1781155394.8336
[time] => 0.00023007392883301
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155394.8336
[end] => 1781155394.8381
[time] => 0.0045180320739746
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155394.8382
[end] => 1781155394.8669
[time] => 0.028702974319458
)
[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 (64,57) ORDER BY lastname,firstname ASC
[start] => 1781155394.8673
[end] => 1781155394.8709
[time] => 0.0036449432373047
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155394.8715
[end] => 1781155394.8728
[time] => 0.0012710094451904
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155394.8732
[end] => 1781155394.8749
[time] => 0.001694917678833
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781155394.875
[end] => 1781155394.8757
[time] => 0.00072598457336426
)
[12] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155394.8763
[end] => 1781155394.8777
[time] => 0.0014801025390625
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155394.8778
[end] => 1781155394.8832
[time] => 0.005443811416626
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155394.8832
[end] => 1781155394.9076
[time] => 0.024372100830078
)
[15] => Array
(
[query] => select * from match_roster where match_id = '4536'
[start] => 1781155394.9079
[end] => 1781155394.9258
[time] => 0.017934083938599
)
[16] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155394.926
[end] => 1781155394.9262
[time] => 0.00027084350585938
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155394.9263
[end] => 1781155394.9307
[time] => 0.0044598579406738
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155394.9308
[end] => 1781155394.9753
[time] => 0.044501066207886
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4536' and (point.point = 'P' or point.point = 'E')
[start] => 1781155394.9807
[end] => 1781155395.1916
[time] => 0.2109260559082
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781155395.1917
[end] => 1781155395.192
[time] => 0.0002281665802002
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781155395.192
[end] => 1781155395.1937
[time] => 0.0016729831695557
)
[22] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155395.1938
[end] => 1781155395.194
[time] => 0.00023913383483887
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155395.1941
[end] => 1781155395.2002
[time] => 0.006119966506958
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155395.2003
[end] => 1781155395.231
[time] => 0.030707836151123
)
[25] => Array
(
[query] => select * from match_roster where match_id = '4536'
[start] => 1781155395.2312
[end] => 1781155395.2415
[time] => 0.010267019271851
)
[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 = '4536' group by player_id
[start] => 1781155395.2416
[end] => 1781155395.345
[time] => 0.10344195365906
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '4536'
[start] => 1781155395.3451
[end] => 1781155395.346
[time] => 0.00085616111755371
)
[28] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155395.3461
[end] => 1781155395.3463
[time] => 0.00020003318786621
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155395.3463
[end] => 1781155395.351
[time] => 0.0047450065612793
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155395.3511
[end] => 1781155395.3799
[time] => 0.02878999710083
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781155395.3802
[end] => 1781155395.3817
[time] => 0.0014879703521729
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781155395.3818
[end] => 1781155395.3829
[time] => 0.0010960102081299
)
[33] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155395.3831
[end] => 1781155395.3833
[time] => 0.00020909309387207
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155395.3833
[end] => 1781155395.3878
[time] => 0.0044081211090088
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155395.3878
[end] => 1781155395.4148
[time] => 0.027036905288696
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '4536'
[start] => 1781155395.4151
[end] => 1781155395.4176
[time] => 0.0025179386138916
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781155395.4177
[end] => 1781155395.4179
[time] => 0.0001978874206543
)
[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 = '4536' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781155395.418
[end] => 1781155395.4182
[time] => 0.00020980834960938
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781155395.4183
[end] => 1781155395.4184
[time] => 0.00018882751464844
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781155395.4185
[end] => 1781155395.4187
[time] => 0.00021004676818848
)
[41] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155395.4189
[end] => 1781155395.4191
[time] => 0.00020694732666016
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155395.4191
[end] => 1781155395.4251
[time] => 0.0059928894042969
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155395.4252
[end] => 1781155395.4504
[time] => 0.025174140930176
)
[44] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155395.4507
[end] => 1781155395.4529
[time] => 0.0022311210632324
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155395.4529
[end] => 1781155395.4573
[time] => 0.0044281482696533
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155395.4574
[end] => 1781155395.483
[time] => 0.025560140609741
)
[47] => Array
(
[query] => select * from match_roster where match_id = '4536'
[start] => 1781155395.4833
[end] => 1781155395.4998
[time] => 0.016473054885864
)
[48] => Array
(
[query] => select * from point where match_id = '4536' order by point_id ASC
[start] => 1781155395.4998
[end] => 1781155395.6753
[time] => 0.17551684379578
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781155395.6759
[end] => 1781155395.6763
[time] => 0.00035285949707031
)
[50] => Array
(
[query] => select * from matches where match_id = '4536'
[start] => 1781155395.6764
[end] => 1781155395.6769
[time] => 0.00051999092102051
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4536'
[start] => 1781155395.6769
[end] => 1781155395.6821
[time] => 0.0051670074462891
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4536'
[start] => 1781155395.6821
[end] => 1781155395.7175
[time] => 0.035336971282959
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155395.7211
[end] => 1781155395.7241
[time] => 0.0030980110168457
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155395.725
[end] => 1781155395.7253
[time] => 0.00026988983154297
)
)
