Total Queries: 30
Total Time: 0.4157509803772
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1766034195.9766
[end] => 1766034195.9769
[time] => 0.00029516220092773
)
[1] => Array
(
[query] => select * from championship where championship_id = '38'
[start] => 1766034195.9791
[end] => 1766034195.9794
[time] => 0.00023412704467773
)
[2] => Array
(
[query] => select * from team_to_championship where championship_id = '38'
[start] => 1766034195.9795
[end] => 1766034195.9798
[time] => 0.00030112266540527
)
[3] => Array
(
[query] => select * from matches where championship_id = '38' ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1766034195.9799
[end] => 1766034195.9824
[time] => 0.0025119781494141
)
[4] => Array
(
[query] => select * from match_time where match_id in (3892,3893,3894,3895,3896,3897,3899,3898,3900,3901,3902,3903,3904,3905,3907,3906,3908,3909,3911,3910) order by id ASC
[start] => 1766034195.9826
[end] => 1766034195.9851
[time] => 0.0025398731231689
)
[5] => Array
(
[query] => SELECT * FROM match_data where match_id IN (3892,3893,3894,3895,3896,3897,3899,3898,3900,3901,3902,3903,3904,3905,3907,3906,3908,3909,3911,3910)
[start] => 1766034196.0156
[end] => 1766034196.0277
[time] => 0.012081861495972
)
[6] => Array
(
[query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
left join team_to_club on (team.team_id = team_to_club.team_id) where deleted = '0' AND (start = 0 OR start <= 1766034196 OR start >= 1766034196) AND (end >= 1766034196 OR end = 0) AND (start < 1766034196) ORDER BY name ASC
[start] => 1766034196.0342
[end] => 1766034196.0352
[time] => 0.00091195106506348
)
[7] => Array
(
[query] => select * from championship where championship_id = '38'
[start] => 1766034196.0352
[end] => 1766034196.0355
[time] => 0.00024008750915527
)
[8] => Array
(
[query] => select * from team_to_championship where championship_id = '38'
[start] => 1766034196.0356
[end] => 1766034196.0358
[time] => 0.00024700164794922
)
[9] => Array
(
[query] => select * from matches where championship_id = '38' ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1766034196.0359
[end] => 1766034196.0384
[time] => 0.0024948120117188
)
[10] => Array
(
[query] => select * from match_time where match_id in (3892,3893,3894,3895,3896,3897,3899,3898,3900,3901,3902,3903,3904,3905,3907,3906,3908,3909,3911,3910) order by id ASC
[start] => 1766034196.0386
[end] => 1766034196.0411
[time] => 0.0025088787078857
)
[11] => Array
(
[query] => select * from team_to_championship where championship_id = '38'
[start] => 1766034196.0713
[end] => 1766034196.0717
[time] => 0.00039100646972656
)
[12] => Array
(
[query] => select * from championship where championship_id = '38'
[start] => 1766034196.0721
[end] => 1766034196.0724
[time] => 0.00021696090698242
)
[13] => Array
(
[query] => select * from team_to_championship where championship_id = '38'
[start] => 1766034196.0725
[end] => 1766034196.0727
[time] => 0.00024700164794922
)
[14] => Array
(
[query] => select * from team_to_championship where championship_id = '38'
[start] => 1766034196.0727
[end] => 1766034196.0729
[time] => 0.00018000602722168
)
[15] => 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 player.gender = 'male' AND deleted = '0' AND (start = 0 OR start <= 1739711397 OR start >= 1739711397) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (55,50,63,52,51) ORDER BY lastname,firstname ASC
[start] => 1766034196.073
[end] => 1766034196.0739
[time] => 0.00093698501586914
)
[16] => Array
(
[query] => SELECT player_id, COUNT(player_id) as attendance FROM match_roster where match_id IN (select match_id from matches where championship_id = '38') AND match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id
[start] => 1766034196.0741
[end] => 1766034196.086
[time] => 0.011887073516846
)
[17] => Array
(
[query] => SELECT
player_id,
SUM(
CASE
WHEN point != 'A' THEN point
END
) as total,
SUM(
CASE
WHEN point = 'A' THEN 1
WHEN point != 'A' THEN 0
END
) as autohit,
SUM(
CASE
WHEN point = '3' THEN 1
WHEN point != '3' THEN 0
END
) as defense,
SUM(
CASE
WHEN point = '2' THEN 1
WHEN point != '2' THEN 0
END
) as attack,
SUM(
CASE
WHEN point = 'P' THEN 1
WHEN point != 'P' THEN 0
END
) as admonitions,
SUM(
CASE
WHEN point = 'E' THEN 1
WHEN point != 'E' THEN 0
END
) as expulsions
FROM point WHERE match_id IN (select match_id from matches where championship_id = '38') and player_id in (select player_id from player where gender = 'male') group by player_id order by total DESC
[start] => 1766034196.0861
[end] => 1766034196.2771
[time] => 0.19100713729858
)
[18] => Array
(
[query] => select * from championship where championship_id = '38'
[start] => 1766034196.2773
[end] => 1766034196.2776
[time] => 0.00033307075500488
)
[19] => Array
(
[query] => select * from team_to_championship where championship_id = '38'
[start] => 1766034196.2777
[end] => 1766034196.278
[time] => 0.00022983551025391
)
[20] => Array
(
[query] => select * from team_to_championship where championship_id = '38'
[start] => 1766034196.278
[end] => 1766034196.2782
[time] => 0.00018310546875
)
[21] => 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 player.gender = 'female' AND deleted = '0' AND (start = 0 OR start <= 1739711397 OR start >= 1739711397) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (55,50,63,52,51) ORDER BY lastname,firstname ASC
[start] => 1766034196.2782
[end] => 1766034196.2793
[time] => 0.0010209083557129
)
[22] => Array
(
[query] => SELECT player_id, COUNT(player_id) as attendance FROM match_roster where match_id IN (select match_id from matches where championship_id = '38') AND match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id
[start] => 1766034196.2795
[end] => 1766034196.2912
[time] => 0.011688947677612
)
[23] => Array
(
[query] => SELECT
player_id,
SUM(
CASE
WHEN point != 'A' THEN point
END
) as total,
SUM(
CASE
WHEN point = 'A' THEN 1
WHEN point != 'A' THEN 0
END
) as autohit,
SUM(
CASE
WHEN point = '3' THEN 1
WHEN point != '3' THEN 0
END
) as defense,
SUM(
CASE
WHEN point = '2' THEN 1
WHEN point != '2' THEN 0
END
) as attack,
SUM(
CASE
WHEN point = 'P' THEN 1
WHEN point != 'P' THEN 0
END
) as admonitions,
SUM(
CASE
WHEN point = 'E' THEN 1
WHEN point != 'E' THEN 0
END
) as expulsions
FROM point WHERE match_id IN (select match_id from matches where championship_id = '38') and player_id in (select player_id from player where gender = 'female') group by player_id order by total DESC
[start] => 1766034196.2914
[end] => 1766034196.4585
[time] => 0.16707587242126
)
[24] => 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 (start = 0 OR start <= 1739711397 OR start >= 1739711397) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) ORDER BY lastname,firstname ASC
[start] => 1766034196.4591
[end] => 1766034196.4626
[time] => 0.0035440921783447
)
[25] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1766034196.4647
[end] => 1766034196.4655
[time] => 0.00076389312744141
)
[26] => Array
(
[query] => select * from location where deleted = '0'
[start] => 1766034196.466
[end] => 1766034196.4663
[time] => 0.00026798248291016
)
[27] => Array
(
[query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
left join team_to_club on (team.team_id = team_to_club.team_id) where deleted = '0' AND (start = 0 OR start <= 1766034196 OR start >= 1766034196) AND (end >= 1766034196 OR end = 0) AND (start < 1766034196) ORDER BY name ASC
[start] => 1766034196.4664
[end] => 1766034196.4671
[time] => 0.00076603889465332
)
[28] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1766034196.4691
[end] => 1766034196.4695
[time] => 0.00042819976806641
)
[29] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1766034196.4702
[end] => 1766034196.4705
[time] => 0.00021600723266602
)
)
