DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
OrbaHit
Goliath
Data e Luogo
Campionato
Campionato Misto Start
Giornata: 2
Data e Luogo
07-03-2026 15:10 - Orbassano
Arbitri
Primo Arbitro
ASD Polisportiva Oratorio Orbassano
Refertista
Agnelli Filippo
Sorteggio
Sorteggio Vinto Da
Goliath
Annotazioni
Arbitro: Valetti Mattia.
Total Queries: 55
Total Time: 0.69695830345154
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786253033.3198
[end] => 1786253033.3201
[time] => 0.0002288818359375
)
[1] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.3225
[end] => 1786253033.3238
[time] => 0.0012869834899902
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.3238
[end] => 1786253033.3297
[time] => 0.0059149265289307
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.3298
[end] => 1786253033.3588
[time] => 0.028929948806763
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.3591
[end] => 1786253033.3642
[time] => 0.0050568580627441
)
[5] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.3643
[end] => 1786253033.366
[time] => 0.0016458034515381
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.366
[end] => 1786253033.3701
[time] => 0.0041310787200928
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.3702
[end] => 1786253033.3951
[time] => 0.024904012680054
)
[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 (62,58) ORDER BY lastname,firstname ASC
[start] => 1786253033.3955
[end] => 1786253033.399
[time] => 0.0034670829772949
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786253033.3996
[end] => 1786253033.4001
[time] => 0.00045394897460938
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786253033.4005
[end] => 1786253033.4008
[time] => 0.00030517578125
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786253033.4009
[end] => 1786253033.4016
[time] => 0.00074100494384766
)
[12] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.4021
[end] => 1786253033.4023
[time] => 0.00023293495178223
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.4024
[end] => 1786253033.409
[time] => 0.0066871643066406
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.4091
[end] => 1786253033.4345
[time] => 0.025431156158447
)
[15] => Array
(
[query] => select * from match_roster where match_id = '4523'
[start] => 1786253033.4349
[end] => 1786253033.4505
[time] => 0.015610933303833
)
[16] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.4506
[end] => 1786253033.4509
[time] => 0.00027298927307129
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.4509
[end] => 1786253033.4551
[time] => 0.0042169094085693
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.4552
[end] => 1786253033.4813
[time] => 0.026073932647705
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4523' and (point.point = 'P' or point.point = 'E')
[start] => 1786253033.4837
[end] => 1786253033.6343
[time] => 0.1505401134491
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786253033.6344
[end] => 1786253033.637
[time] => 0.0025460720062256
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786253033.637
[end] => 1786253033.6372
[time] => 0.00020813941955566
)
[22] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.6373
[end] => 1786253033.6376
[time] => 0.00026702880859375
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.6376
[end] => 1786253033.6424
[time] => 0.0047821998596191
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.6425
[end] => 1786253033.6667
[time] => 0.024248838424683
)
[25] => Array
(
[query] => select * from match_roster where match_id = '4523'
[start] => 1786253033.667
[end] => 1786253033.6885
[time] => 0.021469831466675
)
[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 = '4523' group by player_id
[start] => 1786253033.6886
[end] => 1786253033.7836
[time] => 0.095061063766479
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '4523'
[start] => 1786253033.7838
[end] => 1786253033.786
[time] => 0.002234935760498
)
[28] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.7861
[end] => 1786253033.7863
[time] => 0.00022292137145996
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.7864
[end] => 1786253033.7908
[time] => 0.0044369697570801
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.7909
[end] => 1786253033.8169
[time] => 0.026088953018188
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786253033.8173
[end] => 1786253033.8176
[time] => 0.00032782554626465
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786253033.8178
[end] => 1786253033.8184
[time] => 0.00055694580078125
)
[33] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.8186
[end] => 1786253033.8199
[time] => 0.0013148784637451
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.8199
[end] => 1786253033.8243
[time] => 0.0044360160827637
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.8244
[end] => 1786253033.8504
[time] => 0.025947093963623
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '4523'
[start] => 1786253033.8507
[end] => 1786253033.8537
[time] => 0.0030701160430908
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786253033.8538
[end] => 1786253033.8559
[time] => 0.0020320415496826
)
[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 = '4523' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786253033.8559
[end] => 1786253033.8561
[time] => 0.00023198127746582
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786253033.8562
[end] => 1786253033.8564
[time] => 0.00017595291137695
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786253033.8564
[end] => 1786253033.8566
[time] => 0.00015711784362793
)
[41] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.8568
[end] => 1786253033.857
[time] => 0.00019001960754395
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.857
[end] => 1786253033.8624
[time] => 0.0054190158843994
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.8625
[end] => 1786253033.8901
[time] => 0.027665853500366
)
[44] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253033.8904
[end] => 1786253033.8937
[time] => 0.0033009052276611
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253033.8938
[end] => 1786253033.8982
[time] => 0.0044019222259521
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253033.8982
[end] => 1786253033.9228
[time] => 0.024607181549072
)
[47] => Array
(
[query] => select * from match_roster where match_id = '4523'
[start] => 1786253033.9231
[end] => 1786253033.9379
[time] => 0.014810085296631
)
[48] => Array
(
[query] => select * from point where match_id = '4523' order by point_id ASC
[start] => 1786253033.9379
[end] => 1786253034.0119
[time] => 0.07394814491272
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786253034.0125
[end] => 1786253034.0129
[time] => 0.00037622451782227
)
[50] => Array
(
[query] => select * from matches where match_id = '4523'
[start] => 1786253034.013
[end] => 1786253034.0132
[time] => 0.0002281665802002
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4523'
[start] => 1786253034.0132
[end] => 1786253034.0157
[time] => 0.0024349689483643
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4523'
[start] => 1786253034.0157
[end] => 1786253034.0286
[time] => 0.012814044952393
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786253034.0313
[end] => 1786253034.0318
[time] => 0.00050210952758789
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786253034.0326
[end] => 1786253034.0329
[time] => 0.00031089782714844
)
)
