DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
On Fire
Plus
Data e Luogo
Campionato
Torneo giovanile U14 Nord
Giornata: 2
Data e Luogo
06-05-2026 18:40 - Venaria
Arbitri
Primo Arbitro
1-2 Arbitro Tornei Open
Refertista
ASD PolisportivaVenaria
Sorteggio
Sorteggio Vinto Da
On Fire
Annotazioni
Refertista di società: Polisportiva Venaria
Total Queries: 55
Total Time: 0.38149380683899
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786252900.876
[end] => 1786252900.8763
[time] => 0.00028610229492188
)
[1] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252900.8786
[end] => 1786252900.8789
[time] => 0.00030398368835449
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252900.8789
[end] => 1786252900.8813
[time] => 0.0023899078369141
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252900.8814
[end] => 1786252900.8942
[time] => 0.012822151184082
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252900.8946
[end] => 1786252900.8971
[time] => 0.0024781227111816
)
[5] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252900.8972
[end] => 1786252900.8975
[time] => 0.00027894973754883
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252900.8975
[end] => 1786252900.8999
[time] => 0.0023770332336426
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252900.8999
[end] => 1786252900.9127
[time] => 0.01280403137207
)
[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 (82,86) ORDER BY lastname,firstname ASC
[start] => 1786252900.9131
[end] => 1786252900.9141
[time] => 0.0010061264038086
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786252900.915
[end] => 1786252900.9154
[time] => 0.00041294097900391
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786252900.9158
[end] => 1786252900.916
[time] => 0.00025105476379395
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786252900.9161
[end] => 1786252900.9167
[time] => 0.00061392784118652
)
[12] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252900.9172
[end] => 1786252900.9174
[time] => 0.00023007392883301
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252900.9174
[end] => 1786252900.9198
[time] => 0.0023889541625977
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252900.9199
[end] => 1786252900.9327
[time] => 0.012848854064941
)
[15] => Array
(
[query] => select * from match_roster where match_id = '4735'
[start] => 1786252900.933
[end] => 1786252900.941
[time] => 0.0079798698425293
)
[16] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252900.9411
[end] => 1786252900.9413
[time] => 0.00023984909057617
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252900.9413
[end] => 1786252900.9437
[time] => 0.002418041229248
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252900.9438
[end] => 1786252900.9566
[time] => 0.012848138809204
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4735' and (point.point = 'P' or point.point = 'E')
[start] => 1786252900.9593
[end] => 1786252901.0338
[time] => 0.074495077133179
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786252901.0339
[end] => 1786252901.0342
[time] => 0.0003199577331543
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786252901.0343
[end] => 1786252901.0344
[time] => 0.00017404556274414
)
[22] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252901.0345
[end] => 1786252901.0347
[time] => 0.00020408630371094
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252901.0347
[end] => 1786252901.0371
[time] => 0.002363920211792
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252901.0372
[end] => 1786252901.0499
[time] => 0.012793779373169
)
[25] => Array
(
[query] => select * from match_roster where match_id = '4735'
[start] => 1786252901.0502
[end] => 1786252901.0582
[time] => 0.0080218315124512
)
[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 = '4735' group by player_id
[start] => 1786252901.0583
[end] => 1786252901.1075
[time] => 0.049240827560425
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '4735'
[start] => 1786252901.1076
[end] => 1786252901.108
[time] => 0.00035285949707031
)
[28] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252901.1081
[end] => 1786252901.1082
[time] => 0.0001838207244873
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252901.1083
[end] => 1786252901.1107
[time] => 0.0023961067199707
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252901.1107
[end] => 1786252901.1235
[time] => 0.012795925140381
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786252901.124
[end] => 1786252901.1242
[time] => 0.0002131462097168
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786252901.1242
[end] => 1786252901.1248
[time] => 0.00055384635925293
)
[33] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252901.125
[end] => 1786252901.1252
[time] => 0.00020313262939453
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252901.1252
[end] => 1786252901.1276
[time] => 0.0023720264434814
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252901.1276
[end] => 1786252901.1404
[time] => 0.012766122817993
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '4735'
[start] => 1786252901.1406
[end] => 1786252901.1417
[time] => 0.0010199546813965
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786252901.1418
[end] => 1786252901.1419
[time] => 0.00017499923706055
)
[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 = '4735' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786252901.142
[end] => 1786252901.1422
[time] => 0.00021004676818848
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786252901.1422
[end] => 1786252901.1424
[time] => 0.00015807151794434
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786252901.1424
[end] => 1786252901.1426
[time] => 0.00014305114746094
)
[41] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252901.1428
[end] => 1786252901.1429
[time] => 0.00017714500427246
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252901.1429
[end] => 1786252901.1453
[time] => 0.0023629665374756
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252901.1454
[end] => 1786252901.1582
[time] => 0.012806177139282
)
[44] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252901.1585
[end] => 1786252901.1588
[time] => 0.00030398368835449
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252901.1588
[end] => 1786252901.1612
[time] => 0.002371072769165
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252901.1612
[end] => 1786252901.1741
[time] => 0.01284384727478
)
[47] => Array
(
[query] => select * from match_roster where match_id = '4735'
[start] => 1786252901.1743
[end] => 1786252901.1823
[time] => 0.0079848766326904
)
[48] => Array
(
[query] => select * from point where match_id = '4735' order by point_id ASC
[start] => 1786252901.1823
[end] => 1786252901.2525
[time] => 0.070122957229614
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786252901.2531
[end] => 1786252901.2534
[time] => 0.00033998489379883
)
[50] => Array
(
[query] => select * from matches where match_id = '4735'
[start] => 1786252901.2535
[end] => 1786252901.2537
[time] => 0.00019502639770508
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4735'
[start] => 1786252901.2537
[end] => 1786252901.2561
[time] => 0.0023679733276367
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4735'
[start] => 1786252901.2561
[end] => 1786252901.2688
[time] => 0.012683868408203
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786252901.2715
[end] => 1786252901.272
[time] => 0.00050115585327148
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786252901.2728
[end] => 1786252901.2731
[time] => 0.00029802322387695
)
)
