DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Spartak
Driphit
Data e Luogo
Campionato
Torneo Start Girone Gold
Giornata: 4
Data e Luogo
04-04-2025 18:30 - Frassati
Arbitri
Primo Arbitro
Ghirardi Luigi
Secondo Arbitro
Catellani Giacomo
Sorteggio
Sorteggio Vinto Da
Spartak
Annotazioni
Refertista:Marco Antonucci
Total Queries: 55
Total Time: 0.74333715438843
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1766078458.3762
[end] => 1766078458.3769
[time] => 0.00073003768920898
)
[1] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.3833
[end] => 1766078458.3835
[time] => 0.00021982192993164
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.3835
[end] => 1766078458.3858
[time] => 0.0022709369659424
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.3859
[end] => 1766078458.4351
[time] => 0.049230098724365
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.4355
[end] => 1766078458.4374
[time] => 0.0019729137420654
)
[5] => 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' ORDER BY lastname,firstname ASC
[start] => 1766078458.4378
[end] => 1766078458.4512
[time] => 0.013408899307251
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1766078458.4564
[end] => 1766078458.457
[time] => 0.00052595138549805
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1766078458.4574
[end] => 1766078458.459
[time] => 0.0016050338745117
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1766078458.4591
[end] => 1766078458.4598
[time] => 0.00076889991760254
)
[9] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.4603
[end] => 1766078458.4605
[time] => 0.00024795532226562
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.4606
[end] => 1766078458.4645
[time] => 0.0039260387420654
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.4646
[end] => 1766078458.4881
[time] => 0.023583889007568
)
[12] => Array
(
[query] => select * from match_roster where match_id = '3870'
[start] => 1766078458.4884
[end] => 1766078458.5007
[time] => 0.0123131275177
)
[13] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.5009
[end] => 1766078458.503
[time] => 0.0020570755004883
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.503
[end] => 1766078458.5069
[time] => 0.0038878917694092
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.507
[end] => 1766078458.5311
[time] => 0.024112939834595
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3870' and (point.point = 'P' or point.point = 'E')
[start] => 1766078458.533
[end] => 1766078458.7011
[time] => 0.16801404953003
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1766078458.7012
[end] => 1766078458.7022
[time] => 0.001007080078125
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1766078458.7023
[end] => 1766078458.7027
[time] => 0.00041985511779785
)
[19] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.7028
[end] => 1766078458.703
[time] => 0.00020408630371094
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.7031
[end] => 1766078458.7071
[time] => 0.0040240287780762
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.7071
[end] => 1766078458.7348
[time] => 0.027652025222778
)
[22] => Array
(
[query] => select * from match_roster where match_id = '3870'
[start] => 1766078458.7351
[end] => 1766078458.7478
[time] => 0.01271390914917
)
[23] => 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 = '3870' group by player_id
[start] => 1766078458.7478
[end] => 1766078458.8273
[time] => 0.079426050186157
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '3870'
[start] => 1766078458.8274
[end] => 1766078458.8286
[time] => 0.001168966293335
)
[25] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.8287
[end] => 1766078458.8289
[time] => 0.00021004676818848
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.8289
[end] => 1766078458.8338
[time] => 0.0048999786376953
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.8339
[end] => 1766078458.8574
[time] => 0.023507118225098
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1766078458.8578
[end] => 1766078458.858
[time] => 0.00022292137145996
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1766078458.8581
[end] => 1766078458.861
[time] => 0.0028278827667236
)
[30] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.8612
[end] => 1766078458.8614
[time] => 0.00023102760314941
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.8614
[end] => 1766078458.8633
[time] => 0.0018439292907715
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.8633
[end] => 1766078458.8875
[time] => 0.024120092391968
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '3870'
[start] => 1766078458.8877
[end] => 1766078458.8891
[time] => 0.0013580322265625
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1766078458.8892
[end] => 1766078458.8894
[time] => 0.00019693374633789
)
[35] => 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 = '3870' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1766078458.8895
[end] => 1766078458.891
[time] => 0.0015139579772949
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1766078458.8911
[end] => 1766078458.8912
[time] => 0.00018596649169922
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1766078458.8913
[end] => 1766078458.8915
[time] => 0.00015902519226074
)
[38] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.8916
[end] => 1766078458.8919
[time] => 0.00023698806762695
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.8919
[end] => 1766078458.8957
[time] => 0.0038402080535889
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.8958
[end] => 1766078458.9198
[time] => 0.024005174636841
)
[41] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078458.9201
[end] => 1766078458.9218
[time] => 0.0016639232635498
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078458.9218
[end] => 1766078458.9237
[time] => 0.0018689632415771
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078458.9238
[end] => 1766078458.9465
[time] => 0.022748947143555
)
[44] => Array
(
[query] => select * from match_roster where match_id = '3870'
[start] => 1766078458.9468
[end] => 1766078458.963
[time] => 0.016223907470703
)
[45] => Array
(
[query] => select * from point where match_id = '3870' order by point_id ASC
[start] => 1766078458.9631
[end] => 1766078459.0794
[time] => 0.11630988121033
)
[46] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078459.08
[end] => 1766078459.082
[time] => 0.0019969940185547
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078459.082
[end] => 1766078459.0855
[time] => 0.0035419464111328
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078459.0856
[end] => 1766078459.1086
[time] => 0.022941827774048
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1766078459.1091
[end] => 1766078459.1093
[time] => 0.00028204917907715
)
[50] => Array
(
[query] => select * from matches where match_id = '3870'
[start] => 1766078459.1094
[end] => 1766078459.1109
[time] => 0.0014739036560059
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3870'
[start] => 1766078459.1109
[end] => 1766078459.1139
[time] => 0.0029740333557129
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3870'
[start] => 1766078459.1139
[end] => 1766078459.1354
[time] => 0.021409034729004
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1766078459.1378
[end] => 1766078459.1411
[time] => 0.0033018589019775
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1766078459.1419
[end] => 1766078459.1436
[time] => 0.0017490386962891
)
)
