Total Queries: 30
Total Time: 3.3606293201447
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776056244.348
[end] => 1776056244.3558
[time] => 0.0078220367431641
)
[1] => Array
(
[query] => select * from championship where championship_id = '32'
[start] => 1776056244.3634
[end] => 1776056244.3667
[time] => 0.0033740997314453
)
[2] => Array
(
[query] => select * from team_to_championship where championship_id = '32'
[start] => 1776056244.3669
[end] => 1776056244.3676
[time] => 0.00070905685424805
)
[3] => Array
(
[query] => select * from matches where championship_id = '32' ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1776056244.3678
[end] => 1776056244.3758
[time] => 0.0080139636993408
)
[4] => Array
(
[query] => select * from match_time where match_id in (3849,3850,3851,3852,3853,3854) order by id ASC
[start] => 1776056244.3759
[end] => 1776056244.379
[time] => 0.0031211376190186
)
[5] => Array
(
[query] => SELECT * FROM match_data where match_id IN (3849,3850,3851,3852,3853,3854)
[start] => 1776056244.4212
[end] => 1776056244.4619
[time] => 0.040656089782715
)
[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 <= 1776056244 OR start >= 1776056244) AND (end >= 1776056244 OR end = 0) AND (start < 1776056244) ORDER BY name ASC
[start] => 1776056244.4769
[end] => 1776056244.4789
[time] => 0.0019969940185547
)
[7] => Array
(
[query] => select * from championship where championship_id = '32'
[start] => 1776056244.479
[end] => 1776056244.4898
[time] => 0.010722160339355
)
[8] => Array
(
[query] => select * from team_to_championship where championship_id = '32'
[start] => 1776056244.4899
[end] => 1776056244.4902
[time] => 0.00033998489379883
)
[9] => Array
(
[query] => select * from matches where championship_id = '32' ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1776056244.4904
[end] => 1776056244.4965
[time] => 0.0061039924621582
)
[10] => Array
(
[query] => select * from match_time where match_id in (3849,3850,3851,3852,3853,3854) order by id ASC
[start] => 1776056244.4965
[end] => 1776056244.5023
[time] => 0.0057778358459473
)
[11] => Array
(
[query] => select * from team_to_championship where championship_id = '32'
[start] => 1776056244.565
[end] => 1776056244.5653
[time] => 0.0003049373626709
)
[12] => Array
(
[query] => select * from championship where championship_id = '32'
[start] => 1776056244.5656
[end] => 1776056244.5659
[time] => 0.00023913383483887
)
[13] => Array
(
[query] => select * from team_to_championship where championship_id = '32'
[start] => 1776056244.566
[end] => 1776056244.5662
[time] => 0.00022387504577637
)
[14] => Array
(
[query] => select * from team_to_championship where championship_id = '32'
[start] => 1776056244.5662
[end] => 1776056244.5664
[time] => 0.00020194053649902
)
[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 <= 1734342387 OR start >= 1734342387) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (48,57,61) ORDER BY lastname,firstname ASC
[start] => 1776056244.5665
[end] => 1776056244.5675
[time] => 0.00099396705627441
)
[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 = '32') 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] => 1776056244.5679
[end] => 1776056244.5923
[time] => 0.024451971054077
)
[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 = '32') and player_id in (select player_id from player where gender = 'male') group by player_id order by total DESC
[start] => 1776056244.5924
[end] => 1776056246.146
[time] => 1.5536348819733
)
[18] => Array
(
[query] => select * from championship where championship_id = '32'
[start] => 1776056246.1464
[end] => 1776056246.151
[time] => 0.0046291351318359
)
[19] => Array
(
[query] => select * from team_to_championship where championship_id = '32'
[start] => 1776056246.1511
[end] => 1776056246.153
[time] => 0.0018620491027832
)
[20] => Array
(
[query] => select * from team_to_championship where championship_id = '32'
[start] => 1776056246.153
[end] => 1776056246.159
[time] => 0.0059669017791748
)
[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 <= 1734342387 OR start >= 1734342387) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (48,57,61) ORDER BY lastname,firstname ASC
[start] => 1776056246.1591
[end] => 1776056246.16
[time] => 0.00095200538635254
)
[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 = '32') 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] => 1776056246.1602
[end] => 1776056246.2763
[time] => 0.11608791351318
)
[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 = '32') and player_id in (select player_id from player where gender = 'female') group by player_id order by total DESC
[start] => 1776056246.2764
[end] => 1776056247.8049
[time] => 1.5285110473633
)
[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 <= 1734342387 OR start >= 1734342387) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) ORDER BY lastname,firstname ASC
[start] => 1776056247.8051
[end] => 1776056247.8262
[time] => 0.021126985549927
)
[25] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1776056247.8295
[end] => 1776056247.8303
[time] => 0.00082612037658691
)
[26] => Array
(
[query] => select * from location where deleted = '0'
[start] => 1776056247.8319
[end] => 1776056247.837
[time] => 0.0051271915435791
)
[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 (start = 0 OR start <= 1776056247 OR start >= 1776056247) AND (end >= 1776056247 OR end = 0) AND (start < 1776056247) ORDER BY name ASC
[start] => 1776056247.8371
[end] => 1776056247.8395
[time] => 0.0023469924926758
)
[28] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776056247.8436
[end] => 1776056247.8471
[time] => 0.0035629272460938
)
[29] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776056247.848
[end] => 1776056247.8489
[time] => 0.00094199180603027
)
)
Asti KT
Valhalla