DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
Valhalla
Purple Hit
La partita è stata vinta a tavolino.
Data e Luogo
Campionato
Torneo Start Girone Gold
Giornata: 4
Data e Luogo
11-04-2025 18:30 - Frassati
Arbitri
Primo Arbitro
Catellani Giacomo
Secondo Arbitro
Catellani Giacomo
Total Queries: 55
Total Time: 1.8436985015869
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781164563.8074
[end] => 1781164563.8097
[time] => 0.0023839473724365
)
[1] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164563.8173
[end] => 1781164563.8224
[time] => 0.0051100254058838
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164563.8224
[end] => 1781164563.8296
[time] => 0.0071439743041992
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164563.8297
[end] => 1781164563.874
[time] => 0.044245004653931
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164563.8743
[end] => 1781164563.8908
[time] => 0.016520977020264
)
[5] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164563.8909
[end] => 1781164563.8923
[time] => 0.0013201236724854
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164563.8923
[end] => 1781164563.9068
[time] => 0.014532089233398
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164563.9069
[end] => 1781164563.9631
[time] => 0.056197881698608
)
[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 (61,42) ORDER BY lastname,firstname ASC
[start] => 1781164563.9635
[end] => 1781164563.9718
[time] => 0.0082499980926514
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781164563.9733
[end] => 1781164563.9759
[time] => 0.0026230812072754
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781164563.9764
[end] => 1781164563.979
[time] => 0.0026099681854248
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781164563.9791
[end] => 1781164563.9798
[time] => 0.00073599815368652
)
[12] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164563.9803
[end] => 1781164563.9806
[time] => 0.00021791458129883
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164563.9806
[end] => 1781164563.9912
[time] => 0.010625839233398
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164563.9913
[end] => 1781164564.0581
[time] => 0.066801071166992
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3871'
[start] => 1781164564.0584
[end] => 1781164564.0905
[time] => 0.032068014144897
)
[16] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164564.0906
[end] => 1781164564.0929
[time] => 0.002269983291626
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164564.0929
[end] => 1781164564.1036
[time] => 0.010732173919678
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164564.1037
[end] => 1781164564.1755
[time] => 0.071792840957642
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3871' and (point.point = 'P' or point.point = 'E')
[start] => 1781164564.181
[end] => 1781164564.5303
[time] => 0.34927296638489
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781164564.5304
[end] => 1781164564.535
[time] => 0.0045721530914307
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781164564.5351
[end] => 1781164564.5353
[time] => 0.00017905235290527
)
[22] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164564.5353
[end] => 1781164564.5356
[time] => 0.00020694732666016
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164564.5356
[end] => 1781164564.5422
[time] => 0.0066478252410889
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164564.5423
[end] => 1781164564.5818
[time] => 0.039478063583374
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3871'
[start] => 1781164564.582
[end] => 1781164564.6077
[time] => 0.025688171386719
)
[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 = '3871' group by player_id
[start] => 1781164564.6078
[end] => 1781164564.8647
[time] => 0.25692892074585
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3871'
[start] => 1781164564.8648
[end] => 1781164564.8651
[time] => 0.00031900405883789
)
[28] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164564.8652
[end] => 1781164564.8679
[time] => 0.0027339458465576
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164564.8679
[end] => 1781164564.8753
[time] => 0.0073869228363037
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164564.8754
[end] => 1781164564.9497
[time] => 0.074267148971558
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781164564.95
[end] => 1781164564.9504
[time] => 0.0003199577331543
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781164564.9505
[end] => 1781164564.9533
[time] => 0.0028839111328125
)
[33] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164564.9536
[end] => 1781164564.9538
[time] => 0.00025296211242676
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164564.9538
[end] => 1781164564.9663
[time] => 0.012505054473877
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164564.9664
[end] => 1781164565.0376
[time] => 0.07121205329895
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3871'
[start] => 1781164565.0379
[end] => 1781164565.0397
[time] => 0.0017430782318115
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781164565.0398
[end] => 1781164565.0424
[time] => 0.0025849342346191
)
[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 = '3871' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781164565.0424
[end] => 1781164565.044
[time] => 0.0016200542449951
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781164565.0441
[end] => 1781164565.055
[time] => 0.01081395149231
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781164565.0551
[end] => 1781164565.0553
[time] => 0.00020503997802734
)
[41] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164565.0555
[end] => 1781164565.0577
[time] => 0.0022819042205811
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164565.0578
[end] => 1781164565.074
[time] => 0.016209840774536
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164565.0741
[end] => 1781164565.1546
[time] => 0.080588817596436
)
[44] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164565.155
[end] => 1781164565.1627
[time] => 0.0077419281005859
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164565.1628
[end] => 1781164565.1711
[time] => 0.0083091259002686
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164565.1712
[end] => 1781164565.2257
[time] => 0.054498910903931
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3871'
[start] => 1781164565.2259
[end] => 1781164565.2642
[time] => 0.038209915161133
)
[48] => Array
(
[query] => select * from point where match_id = '3871' order by point_id ASC
[start] => 1781164565.2642
[end] => 1781164565.579
[time] => 0.31485795974731
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781164565.5795
[end] => 1781164565.5807
[time] => 0.0012040138244629
)
[50] => Array
(
[query] => select * from matches where match_id = '3871'
[start] => 1781164565.5808
[end] => 1781164565.5829
[time] => 0.0021300315856934
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3871'
[start] => 1781164565.5829
[end] => 1781164565.5957
[time] => 0.012809038162231
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3871'
[start] => 1781164565.5958
[end] => 1781164565.6639
[time] => 0.068115949630737
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781164565.6676
[end] => 1781164565.6714
[time] => 0.0038180351257324
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781164565.6723
[end] => 1781164565.6773
[time] => 0.0049200057983398
)
)
