	soutěž	klub	z	g	a	b	+/-	-	tm	gv	gp	go
1965-1966	NHL	Boston Bruins	3	0	0	0	0	0	0	0	0	0
Stanley Cup	Boston Bruins	0	0	0	0	0	0	0	0	0	0
1967-1968	NHL	St. Louis Blues	73	9	20	29	9	0	10	1	0	1
Stanley Cup	St. Louis Blues	18	1	5	6	0	0	6	0	0	0
1968-1969	NHL	St. Louis Blues	57	6	9	15	8	0	14	0	1	1
Stanley Cup	St. Louis Blues	12	3	4	7	0	0	20	2	0	0
1969-1970	NHL	St. Louis Blues	26	5	6	11	0	0	2	1	0	0
Stanley Cup	St. Louis Blues	16	2	3	5	0	0	2	0	1	0
1970-1971	NHL	St. Louis Blues	54	5	11	16	3	0	13	0	0	1
Stanley Cup	St. Louis Blues	6	1	0	1	0	0	2	0	0	0
1971-1972	NHL	St. Louis Blues	75	13	18	31	7	0	12	3	1	6
Stanley Cup	St. Louis Blues	11	1	3	4	0	0	2	0	0	0
1972-1973	NHL	New York Islanders	54	4	16	20	-22	0	6	0	0	1
NHL	Philadelphia Flyers	12	1	5	6	4	0	2	0	0	0
NHL	Celkem	66	5	21	26	-18	0	8	0	0	1
Stanley Cup	Philadelphia Flyers	11	3	2	5	0	0	2	0	1	0
1973-1974	NHL	Philadelphia Flyers	71	10	21	31	12	0	28	3	1	2
Stanley Cup	Philadelphia Flyers	17	2	2	4	0	0	4	1	0	1
1974-1975	NHL	Philadelphia Flyers	71	8	19	27	11	0	20	1	0	1
Stanley Cup	Philadelphia Flyers	9	2	4	6	0	0	0	0	0	0
1975-1976	NHL	Philadelphia Flyers	38	6	9	15	6	0	28	1	1	0
Stanley Cup	Philadelphia Flyers	10	0	5	5	0	0	2	0	0	0
1976-1977	NHL	Philadelphia Flyers	2	0	0	0	0	0	0	0	0	0
Stanley Cup	Philadelphia Flyers	0	0	0	0	0	0	0	0	0	0
Vše	NHL	4 klub	646	82	162	244	38	0	175	13	6	14

Queries: 105, time: 43.506 ms, default

Time ms

SQL Query

Rows

0.072

SET NAMES 'utf8'

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerRepository.php:17

0.074
explain

SELECT `id`, `name`, `surname`, `country_id`, `photo`, `date_of_birth`, `height`, `weight`,
`position`, `stick` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.290
explain

SELECT `id`, `name`, `surname` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.127
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.750
explain

SELECT `competition`.`id` AS `competition_id`, `competition`.`name`, `competition`.`league_id`,
`sea`.`name` AS `season`, `lea`.`code` AS `leagueCode`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`league_id` = `league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `lea` ON `competition`.`league_id` =
`lea`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') 
ORDER BY .`stats_competition`.`season` DESC, IFNULL(.`league`.`rank`, 9223372036854775807),
.`stats_competition`.`priority` DESC 
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1	stats_player_id	5	const	45	Using where; Using temporary; Using filesort
1	SIMPLE	stats_competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_competition.league_id	1
1	SIMPLE	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1
1	SIMPLE	sea	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.season	1
1	SIMPLE	lea	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:59

0.277
explain

SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '312765') AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` < NOW()) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` > NOW() OR
UNIX_TIMESTAMP(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to`) <= 0 OR
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` IS NULL) 
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player_2_team	ref	fk_stats_player_2_team_stats_player1	fk_stats_player_2_team_stats_player1	5	const	1	Using where; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268

0.305
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`, `club`.`id` `clubId` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IS NULL AND FALSE)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY								Impossible WHERE
4	DEPENDENT SUBQUERY	nameTable	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id	1	Using where; Using filesort
3	DEPENDENT SUBQUERY	nameTable	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id	1	Using where; Using filesort
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/GtmPageDef.php:133

0.061
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.072
explain

SELECT `id`, `code`, `name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`country` 
WHERE (`id` IN (4))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	country	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/app-Front-Player-templates-Overview-default-latte-f9f4e0ca40eb66803765d76f0f9a91f6.php:37

0.059
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.307
explain

SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '312765') AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` < NOW()) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` > NOW() OR
UNIX_TIMESTAMP(`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to`) <= 0 OR
`test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`to` IS NULL) 
ORDER BY `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team`.`from` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player_2_team	ref	fk_stats_player_2_team_stats_player1	fk_stats_player_2_team_stats_player1	5	const	1	Using where; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Team/TeamFacade.php:268

0.318
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team`.*, `club`.`nickname` AS `nickname`,
`club`.`shortcut` AS `shortcut`, `club`.`info` AS `info`, `club`.`contacts` AS `contacts`,
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club` AS `club` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`stats_club_id` = `club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` ON `club`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo` `nameTable` 
WHERE `nameTable`.`stats_club_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`stats_club_id`
ORDER BY IFNULL(NOW() BETWEEN `nameTable`.`from` AND `nameTable`.`to`, 0) DESC, (`nameTable`.`from`
IS NULL AND NOW() <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND NOW() >=
`nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_team`.`id` IS NULL AND FALSE)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY								Impossible WHERE
4	DEPENDENT SUBQUERY	nameTable	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.stats_club_logo.stats_club_id	1	Using where; Using filesort
3	DEPENDENT SUBQUERY	nameTable	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.stats_club_name.stats_club_id	1	Using where; Using filesort
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/components/Stats.php:87

0.717
explain

SELECT DISTINCT `sea`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`repre` = 0) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) 
ORDER BY `sea`.`year` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	5	const	45	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	sea	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.season	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:89

0.061
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.059
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.059
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.035
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.043
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.041
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.037
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.033
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.034
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.055
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.056
explain

SELECT `id`, `position` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player` 
WHERE (`test_dev_nhlcz_s6_esports_cz`.`stats_player`.`id` = '312765')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_player	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Player/PlayerService.php:33

0.433
explain

SELECT DISTINCT `sea`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`season` AS `sea` ON `competition`.`season` = `sea`.`year` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`repre` = 1) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) 
ORDER BY `sea`.`year` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	5	const	45	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	sea	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.season	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerStats.php:113

0.977
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1965) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	3	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.502
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5279)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.533
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2370) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5279)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.258
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5279) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.611
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5280)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.526
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2370) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5280)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.310
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5280) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.408
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1967) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	3	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.502
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5283)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.592
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5283)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.345
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5283) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.678
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5284)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.548
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5284)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.233
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5284) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.462
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1968) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	4	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.562
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5285)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.516
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5285)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.319
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5285) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.592
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5286)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.509
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5286)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.600
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5286) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.486
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1969) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	4	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.542
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5287)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.614
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5287)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.396
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5287) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.619
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5288)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.501
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5288)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.270
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5288) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.426
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1970) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	7	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.526
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5289)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.551
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5289)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.343
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5289) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.563
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5290)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.469
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5290)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.255
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5290) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.414
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1971) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	4	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.492
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5291)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.505
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5291)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.285
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5291) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.457
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5292)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.622
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2396) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5292)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.257
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5292) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.421
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1972) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	7	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.812
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5293)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	index_merge	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	fk_stats_players_stats_player1,fk_stats_players_stats_competition1	5,5		1	Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_competition1); Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.503
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5293)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.491
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5293)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.482
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5293) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	index_merge	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	fk_stats_players_stats_player1,fk_stats_players_stats_competition1	5,5		1	Using intersect(fk_stats_players_stats_player1,fk_stats_players_stats_competition1); Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.619
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5294)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.477
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5294)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.404
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5294) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.387
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1973) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	4	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.473
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5295)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.442
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5295)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.262
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5295) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.447
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5296)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.498
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5296)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.400
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5296) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.365
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1974) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	4	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.520
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5297)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.431
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5297)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.353
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5297) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.472
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5298)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.568
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5298)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.232
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5298) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.343
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1975) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	4	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.531
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5299)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.448
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5299)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.304
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5299) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.644
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5300)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.563
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5300)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

0.340
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`) AS `score`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`) AS `points`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`) AS `points_plus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`) AS `points_minus`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`) AS `penalties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`) AS `goals_winning`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`) AS `goals_power_play`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`) AS `goals_short_handed`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index`) AS `radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5300) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:219

0.488
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_league` AS `league` ON `competition`.`league_id` =
`league`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`competition`.`season` = 1976) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	2	Using where; Using temporary; Using filesort
1	SIMPLE	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:107

0.570
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`stats_competition_id` = 5301)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	10	const,const	2	Using where
1	PRIMARY	competition	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_team_id	1
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.team.id	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:157

0.596
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_players`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`score`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_plus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`points_minus`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`penalties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_winning`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_power_play`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`goals_short_handed`,
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`radegast_index` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_players` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_team_id` = `team`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_players`.`stats_competition_id` = `competition`.`id` AND
(`competition`.`id` IS NOT NULL) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree` ON `competition`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_previous_competition_id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` ON `team`.`id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id` AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`id` = (
SELECT `id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_team_name` `nameTable` 
WHERE `nameTable`.`stats_team_id` = `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`stats_team_id`
ORDER BY IFNULL(DATE(CONCAT(`competition`.`season`, '-12-31')) BETWEEN `nameTable`.`from` AND
`nameTable`.`to`, 0) DESC, (`nameTable`.`from` IS NULL AND DATE(CONCAT(`competition`.`season`,
'-12-31')) <= `nameTable`.`to`) DESC, (`nameTable`.`to` IS NULL AND
DATE(CONCAT(`competition`.`season`, '-12-31')) >= `nameTable`.`from`) DESC 
LIMIT 1)) 
WHERE (`summary` = 0) AND (`stats_player_id` = '312765') AND (`team`.`id` = 2380) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5301)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition1,fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition1	5	const	1	Using where
1	PRIMARY	stats_players	ref	stats_player_id,fk_stats_players_stats_team1,fk_stats_players_stats_player1,fk_stats_players_stats_competition1	stats_player_id	16	const,test_dev_nhlcz_s6_esports_cz.stats_competition_tree.stats_previous_competition_id,const,const	1	Using where
1	PRIMARY	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_players.stats_competition_id	1	Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	const	1
2	DEPENDENT SUBQUERY	nameTable	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_team_name.stats_team_id	1	Using where; Using temporary; Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Stats/PlayerStats/PlayerSeasonStats.php:193

...and more

¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default

https://test.nhlcz.s6.esports.cz/hrac/312765?stats-section=club

Matched?	Class	Mask	Defaults	Module	Request
no	`Route`	`test/<presenter>/<action>[/<id>]`	`module = Test id = NULL`	`Test`
no	`Route`	`<module (xml.*\|rss)>/<presenter [a-zA-Z0-9_-]+>[/<param1>][/<param2>][/<param3>]`	`action = default param1 = NULL param2 = NULL param3 = NULL`	`Export`
no	`Route`	`admin/<module>/<presenter>/<action>[/<id>]`	`module = Dashboard presenter = Homepage action = default id = NULL`	`Admin`
yes	`Route`	`hrac/<id [0-9]+>[/<presenter>]`	`module = Player presenter = Overview action = default`	`Front`	`Front:Player:Overview:default id = 312765 stats-section = club`
no	`Route`	`klub/<id [0-9]+>[/<presenter>]`	`module = Club presenter = Overview action = default id = NULL`	`Front`
no	`Route`	`/clanky`	`module = Home presenter = Article action = default`	`Front`
no	`Route`	`/priklepy`	`module = News presenter = News action = default`	`Front`
no	`Route`	`/vyhledavani`	`module = Search presenter = Search action = default`	`Front`
no	`Route`	`/archiv-clanku[/<action>][/<id \d+>]`	`module = Article presenter = Archive action = default id = NULL`	`Front`
no	`Route`	`zapas/<id \d+>[/<presenter>][/<action>]`	`module = Match presenter = Overview action = default`	`Front`
no	`Route`	`/`	`module = Home presenter = Homepage action = default`	`Front`
may	`ArticleRoute`	`<slug [a-zA-Z-0-9\-]+>/<id \d+>`	`module = Article presenter = Article action = default`	`Front`	`Front:Article:Article:default slug = hrac id = 312765 stats-section = club`
no	`ArticleCompatRoute`	`<slug [a-zA-Z-0-9\-]+>`	`module = Article presenter = Article action = default`	`Front`
no	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>]`	`module = League presenter = Page action = default leagueId = NULL`	`Front`
no	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+>`	`module = MinorLeague presenter = Section action = default`	`Front`
no	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>]`	`module = League presenter = Overview action = default id = NULL leagueId = NULL`	`Front`
no	`Route`	`<module>/<presenter>/<action>[/<id>]`	`id = NULL`	`Front`

Front\Player\OverviewPresenter::renderDefault() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:22

¤ ×

NHL.cz na Facebooku

TERRY CRISP

narozen

věk

post

hůl

Stanley Cup 1976-1977

Celá kariéra

NHL.cz

Projekty

Organizace

Sociální sítě

Queries: 105, time: 43.506 ms, default

Unlogged

Front:Player:Overview:default