	soutěž	klub	Č	Gob.	Zás.	SP	Z	V	P	R	Pr.	SO	Z%	T
2003-2004	NHL	New York Islanders	104	3	47	50	2	1	0	1	1.73	0	94.00	0
Stanley Cup	New York Islanders	0	0	0	0	0	0	0	0	0.00	0	0.00	0
2005-2006	NHL	New York Islanders	310	15	130	145	7	2	3	0	2.90	0	89.66	0
Stanley Cup	New York Islanders	0	0	0	0	0	0	0	0	0.00	0	0.00	0
2006-2007	NHL	New York Islanders	378	13	185	198	8	4	1	0	2.06	0	93.43	0
Stanley Cup	New York Islanders	59	4	31	35	1	0	1	0	4.07	0	88.57	0
2007-2008	NHL	New York Islanders	1132	51	576	627	20	9	10	0	2.70	0	91.87	0
Stanley Cup	New York Islanders	0	0	0	0	0	0	0	0	0.00	0	0.00	0
2008-2009	NHL	Columbus Blue Jackets	168	10	67	77	3	1	2	0	3.57	0	87.01	0
2009-2010	NHL	Minnesota Wild	100	5	29	34	3	1	1	0	3.00	0	85.29	0
Vše	NHL	3 klub	2251	101	1065	1166	44	18	18	1	2.69	0	91.34	0

Queries: 59, time: 22.040 ms, default

Time ms

SQL Query

Rows

0.077

SET NAMES 'utf8'

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

0.079
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` = '315798')

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.179
explain

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

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.157
explain

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

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.575
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') 
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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1	stats_player_id	5	const	20	Using where; Using temporary; Using filesort
1	SIMPLE	stats_competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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.305
explain

SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '315798') 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.385
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.036
explain

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

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.057
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.077
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') 
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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1	stats_player_id	5	const	20	Using where; Using temporary; Using filesort
1	SIMPLE	stats_competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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.037
explain

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

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.272
explain

SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '315798') 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.299
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.410
explain

SELECT DISTINCT `sea`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') 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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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.036
explain

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

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` = '315798')

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` = '315798')

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` = '315798')

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.080
explain

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

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.040
explain

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

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.341
explain

SELECT DISTINCT `sea`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') 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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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.383
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') AND (`competition`.`season` = 2003) 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	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY,sezona	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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.489
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5355)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.432
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5355)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.263
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5355) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.456
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5356)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.435
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5356)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5356) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.368
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') AND (`competition`.`season` = 2005) 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	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY,sezona	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5359)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.392
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5359)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.263
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5359) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5360)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.438
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5360)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.266
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5360) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.348
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') AND (`competition`.`season` = 2006) 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	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY,sezona	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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

2.692
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5361)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.421
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5361)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.241
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5361) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.438
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5362)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.427
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5362)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.382
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5362) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.380
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') AND (`competition`.`season` = 2007) 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	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY,sezona	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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.549
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5363)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.537
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5363)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.280
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5363) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.463
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5364)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.490
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2377) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5364)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.279
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5364) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.458
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') AND (`competition`.`season` = 2008) 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	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY,sezona	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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.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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5365)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.453
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2373) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5365)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.287
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5365) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.458
explain

SELECT DISTINCT `competition`.`id`, `competition`.`name`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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` = '315798') AND (`competition`.`season` = 2009) 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	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY,sezona	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`stats_competition_id` = 5433)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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_goalkeepers.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.486
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_goalkeepers`.`saves`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`,
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_goalkeepers`.`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` = '315798') AND (`team`.`id` = 2393) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5433)

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_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	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_goalkeepers.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.311
explain

SELECT SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`) AS `saves`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`stats_competition_id` = 5433) 
GROUP BY `stats_competition_id` 
HAVING COUNT(*) > 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_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.776
explain

SELECT `competition`.`name` AS `competition`, `competition`.`league_id`, COUNT(DISTINCT
`team`.`stats_club_id`) AS `clubs`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)
AS `saves`, SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`lost_goals`) AS `lost_goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`) AS `shots_against`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`minutes_played`) AS `minutes_played`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches`) AS `matches`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`matches_initial`) AS `matches_initial`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`wins`) AS `wins`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`losses`) AS `losses`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`ties`) AS `ties`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`clear_scores`) AS `clear_scores`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`average`) AS `average`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves_percentage`) AS `saves_percentage`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`goals`) AS `goals`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`assistances`) AS `assistances`,
SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`penalties`) AS `penalties`,
IF(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`),ROUND(SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`saves`)/SUM(`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`shots_against`)*100,2),0)
AS `saves_percentage`,
IF(SUM(`minutes_played`),ROUND(SUM(`lost_goals`)/(SUM(`minutes_played`)/60),2),0) AS `average`,
`league`.`name` AS `league`, `category`.`type` = 'barg' AS `isBarage` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_competition` AS `competition` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`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_category` AS `category` ON
`competition`.`stats_category_id` = `category`.`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_team` AS `team` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_team_id` = `team`.`id` 
WHERE (`summary` = 0) AND (`stats_player_id` = '315798') AND (`competition`.`statistics_visible` =
1) AND (`competition`.`league_id` IS NOT NULL) AND (`competition`.`repre` = 0) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) 
GROUP BY `competition`.`league_id`, `category`.`type` = 'barg' 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	5	const	20	Using where; Using temporary; Using filesort
1	SIMPLE	competition	eq_ref	PRIMARY,league_id	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.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_goalkeepers.stats_competition_id	1	Using where
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.stats_category_id	1
1	SIMPLE	league	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.competition.league_id	1
1	SIMPLE	team	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-Player-components-stats-latte-ff3adcf960ce4b422889acb793ea93d0.php:136

0.905
explain

SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS
`nameTitle`, IF(`post`.`photo_id` IS NOT NULL, (
SELECT `photo`.`url` 
FROM `photo` 
WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, (
SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` 
FROM `file` 
WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` 
FROM `post` 
LEFT JOIN `post_2_stats_player` ON `post`.`id` = `post_2_stats_player`.`post_id` 
WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <=
NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND
`post`.`unpublish_date` >= NOW())) AND (`post_2_stats_player`.`stats_player_id` = '315798') 
ORDER BY `publish_date` DESC 
LIMIT 4

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post_2_stats_player	ref	PRIMARY,stats_player_id	stats_player_id	4	const	1	Using where; Using index; Using temporary; Using filesort
1	PRIMARY	post	eq_ref	PRIMARY,id_UNIQUE,fk_post_post_state,fk_post_post_type,publish_date,unpublish_date,post_article_base_index	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post_2_stats_player.post_id	1	Using where
3	DEPENDENT SUBQUERY	file	eq_ref	PRIMARY,id_UNIQUE	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.file_id	1
2	DEPENDENT SUBQUERY	photo	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.photo_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/temp/cache/latte/test-app-Front-templates-blocks-articles-latte-e8402771c740c09b2165a479ad74b8b0.php:39

¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default

https://test.nhlcz.s6.esports.cz/hrac/315798?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 = 315798 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 = 315798 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

¤ ×

Queries: 2, time: 0.267 ms, default

Time ms

SQL Query

Rows

0.071

SET NAMES 'utf8'

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

0.196
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` = '317902')

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

¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default stats-section!

https://test.nhlcz.s6.esports.cz/hrac/317902?do=stats-section&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 = 317902 do = stats-section 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 = 317902 do = stats-section 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 in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:8

¤ ×

Queries: 2, time: 0.336 ms, default

Time ms

SQL Query

Rows

0.085

SET NAMES 'utf8'

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

0.251
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` = '312288')

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

¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default stats-section!

https://test.nhlcz.s6.esports.cz/hrac/312288?do=stats-section&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 = 312288 do = stats-section 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 = 312288 do = stats-section 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 in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:8

¤ ×

Queries: 2, time: 0.345 ms, default

Time ms

SQL Query

Rows

0.083

SET NAMES 'utf8'

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

0.262
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` = '315798')

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

¤ ×

Unlogged

no identity

¤ ×

Front:Player:Overview:default stats-section!

https://test.nhlcz.s6.esports.cz/hrac/315798?do=stats-section&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 = 315798 do = stats-section 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 = 315798 do = stats-section 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 in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Player/presenters/OverviewPresenter.php:8

¤ ×

previous
245.7 ms
37.03 MB
2 queries / 0.3 ms
Front:Player:Overview:default stats-section!

previous
208.6 ms
37.01 MB
2 queries / 0.3 ms
Front:Player:Overview:default stats-section!

previous
228.6 ms
36.98 MB
2 queries / 0.3 ms
Front:Player:Overview:default stats-section!
×

NHL.cz na Facebooku

WADE DUBIELEWICZ

narozen

výška

věk

váha

post

hůl

NHL 2009-2010

Celá kariéra

NHL.cz

Projekty

Organizace

Sociální sítě

Queries: 59, time: 22.040 ms, default

Unlogged

Front:Player:Overview:default

Queries: 2, time: 0.267 ms, default

Unlogged

Front:Player:Overview:default stats-section!

Queries: 2, time: 0.336 ms, default

Unlogged

Front:Player:Overview:default stats-section!

Queries: 2, time: 0.345 ms, default

Unlogged

Front:Player:Overview:default stats-section!