	soutěž	klub	Č	Gob.	Zás.	SP	Z	ZZ	V	P	R	Pr.	SO	Z%	T
1991-1992	NHL	New Jersey Devils	178	10	75	85	4	0	2	1	0	3.37	0	88.24	0
Stanley Cup	New Jersey Devils	32	3	12	15	1	0	0	1	0	5.62	0	80.00	0
1993-1994	Stanley Cup	New Jersey Devils	1170	38	493	531	17	0	8	9	0	1.95	1	92.84	0
NHL	New Jersey Devils	2625	105	1133	1238	47	0	27	11	8	2.40	3	91.52	0
1994-1995	NHL	New Jersey Devils	2184	89	819	908	40	0	19	11	6	2.45	3	90.20	0
Stanley Cup	New Jersey Devils	1221	34	429	463	20	0	16	4	0	1.67	3	92.66	0
1995-1996	NHL	New Jersey Devils	4433	173	1781	1954	77	0	34	30	12	2.34	6	91.15	0
Stanley Cup	New Jersey Devils	0	0	0	0	0	0	0	0	0	0.00	0	0.00	0
1996-1997	NHL	New Jersey Devils	3838	120	1513	1633	67	0	37	14	13	1.88	10	92.65	0
Stanley Cup	New Jersey Devils	659	19	249	268	10	0	5	5	0	1.73	2	92.91	0
1997-1998	NHL	New Jersey Devils	4128	130	1439	1569	70	0	43	17	8	1.89	10	91.71	0
Stanley Cup	New Jersey Devils	366	12	152	164	6	0	2	4	0	1.97	0	92.68	0
1998-1999	Stanley Cup	New Jersey Devils	424	20	119	139	7	0	3	4	0	2.83	0	85.61	0
NHL	New Jersey Devils	4238	162	1566	1728	70	0	39	21	10	2.29	4	90.62	0
1999-2000	Stanley Cup	New Jersey Devils	1450	39	498	537	23	0	16	7	0	1.61	2	92.74	0
NHL	New Jersey Devils	4311	161	1636	1797	72	0	43	20	8	2.24	6	91.04	0
2000-2001	Stanley Cup	New Jersey Devils	1504	52	455	507	25	0	15	10	0	2.07	4	89.74	0
NHL	New Jersey Devils	4296	166	1596	1762	72	0	42	17	11	2.32	9	90.58	0
2001-2002	Stanley Cup	New Jersey Devils	381	9	136	145	6	0	2	4	0	1.42	1	93.79	0
NHL	New Jersey Devils	4347	156	1499	1655	73	0	38	26	9	2.15	4	90.57	0
2002-2003	Stanley Cup	New Jersey Devils	1490	41	581	622	24	0	16	8	0	1.65	7	93.41	0
NHL	New Jersey Devils	4374	147	1559	1706	73	0	41	23	9	2.02	9	91.38	0
2003-2004	Stanley Cup	New Jersey Devils	297	13	120	133	5	0	1	4	0	2.63	0	90.23	0
NHL	New Jersey Devils	4554	154	1691	1845	75	0	38	26	11	2.03	11	91.65	0
2005-2006	Stanley Cup	New Jersey Devils	532	20	241	261	9	0	5	4	0	2.26	1	92.34	0
NHL	New Jersey Devils	4364	187	1918	2105	73	0	43	30	0	2.57	5	91.12	0
2006-2007	Stanley Cup	New Jersey Devils	688	28	304	332	11	0	5	6	0	2.44	1	91.57	0
NHL	New Jersey Devils	4696	171	2011	2182	78	0	48	30	0	2.18	12	92.16	0
2007-2008	Stanley Cup	New Jersey Devils	300	16	131	147	5	0	1	4	0	3.20	0	89.12	0
NHL	New Jersey Devils	4635	168	1921	2089	77	0	44	33	0	2.17	4	91.96	0
2008-2009	Stanley Cup	New Jersey Devils	426	17	222	239	7	0	3	4	0	2.39	1	92.89	0
NHL	New Jersey Devils	1813	73	797	870	31	0	19	12	0	2.42	5	91.61	0
2009-2010	Stanley Cup	New Jersey Devils	298	15	111	126	5	0	1	4	0	3.02	0	88.10	0
NHL	New Jersey Devils	4499	168	1836	2004	77	0	45	31	0	2.24	9	91.62	0
2010-2011	NHL	New Jersey Devils	3116	127	1186	1313	56	0	23	29	0	2.45	6	90.33	0
2011-2012	Stanley Cup	New Jersey Devils	1470	52	577	629	24	0	14	9	0	2.12	1	91.73	0
NHL	New Jersey Devils	3392	136	1336	1472	59	0	31	25	0	2.41	3	90.76	0
2012-2013	NHL	New Jersey Devils	1757	65	589	654	29	0	13	16	0	2.22	2	90.06	0
2013-2014	NHL	New Jersey Devils	2297	96	875	971	39	0	19	20	0	2.51	3	90.11	0
2014-2015	NHL	St. Louis Blues	357	17	152	169	7	7	3	4	0	2.86	1	89.94	0
Vše	NHL	2 klub	87140	3209	33758	36967	1471	7	804	538	105	2.21	149	91.32	0

	soutěž	klub	Č	Gob.	Zás.	SP	Z	ZZ	V	P	R	Pr.	SO	Z%	T
2001-2002	Reprezentace A	Kanada	300	9	100	109	5	5	4	0	1	1.80	0	91.74	0
OH - 2002	Kanada	300	9	100	109	5	5	4	0	1	1.80	0	91.74	0
Vše	Reprezentační zápasy mužů		300	9	100	109	5	5	4	0	1	1.80	0	91.74	0

Queries: 185, time: 97.732 ms, default

Time ms

SQL Query

Rows

0.062

SET NAMES 'utf8'

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

2.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` = '1622417')

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

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

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

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

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.916
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` = '1622417') 
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	87	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.300
explain

SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '1622417') 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	2	Using where; Using filesort

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

0.433
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.063
explain

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

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

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

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

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

0.059
explain

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

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

SELECT `id`, `stats_team_id` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_player_2_team` 
WHERE (`stats_player_id` = '1622417') 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	2	Using where; Using filesort

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

0.394
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.910
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` = '1622417') 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	87	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.065
explain

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.059
explain

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.059
explain

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

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

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

0.059
explain

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

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.679
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` = '1622417') 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	87	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.047
explain

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

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.539
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` = '1622417') AND (`competition`.`season` = 1991) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	5	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.652
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` = '1622417') AND (`stats_competition_id` = 5331)

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.666
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5331)

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.475
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` = '1622417') AND (`stats_competition_id` = 5331) 
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.638
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` = '1622417') AND (`stats_competition_id` = 5332)

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.616
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5332)

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.400
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` = '1622417') AND (`stats_competition_id` = 5332) 
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.503
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` = '1622417') AND (`competition`.`season` = 1993) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	6	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.503
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_team_name`.`name` `team_name`, `team`.`stats_club_id`
AS `club_id`, `team`.`id` AS `team_id`, `competition`.`league_id`, `competition`.`id`
`competition_id`, `competition`.`name`, `test_dev_nhlcz_s6_esports_cz`.`stats_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` = '1622417') AND (`stats_competition_id` = 5336)

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.462
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5336)

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.303
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` = '1622417') AND (`stats_competition_id` = 5336) 
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.662
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` = '1622417') AND (`stats_competition_id` = 5335)

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.451
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5335)

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.383
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` = '1622417') AND (`stats_competition_id` = 5335) 
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.448
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` = '1622417') AND (`competition`.`season` = 1994) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	5	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.616
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` = '1622417') AND (`stats_competition_id` = 5337)

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.543
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5337)

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.326
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` = '1622417') AND (`stats_competition_id` = 5337) 
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.656
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` = '1622417') AND (`stats_competition_id` = 5338)

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.484
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5338)

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.328
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` = '1622417') AND (`stats_competition_id` = 5338) 
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.546
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` = '1622417') AND (`competition`.`season` = 1995) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	5	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.595
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` = '1622417') AND (`stats_competition_id` = 5339)

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.446
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5339)

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.375
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` = '1622417') AND (`stats_competition_id` = 5339) 
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.465
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` = '1622417') AND (`stats_competition_id` = 5340)

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.478
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5340)

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.394
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` = '1622417') AND (`stats_competition_id` = 5340) 
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

6.099
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` = '1622417') AND (`competition`.`season` = 1996) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	5	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.679
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` = '1622417') AND (`stats_competition_id` = 5341)

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.655
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5341)

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.463
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` = '1622417') AND (`stats_competition_id` = 5341) 
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

1.416
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` = '1622417') AND (`stats_competition_id` = 5342)

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.522
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5342)

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.372
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` = '1622417') AND (`stats_competition_id` = 5342) 
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.437
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` = '1622417') AND (`competition`.`season` = 1997) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	5	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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

4.361
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` = '1622417') AND (`stats_competition_id` = 5343)

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.547
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5343)

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.472
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` = '1622417') AND (`stats_competition_id` = 5343) 
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.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` = '1622417') AND (`stats_competition_id` = 5344)

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.569
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5344)

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.363
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` = '1622417') AND (`stats_competition_id` = 5344) 
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.457
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` = '1622417') AND (`competition`.`season` = 1998) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	5	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.643
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` = '1622417') AND (`stats_competition_id` = 5346)

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.567
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5346)

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.452
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` = '1622417') AND (`stats_competition_id` = 5346) 
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.506
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` = '1622417') AND (`stats_competition_id` = 5345)

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.518
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5345)

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.380
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` = '1622417') AND (`stats_competition_id` = 5345) 
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.595
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` = '1622417') AND (`competition`.`season` = 1999) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	40	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.532
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` = '1622417') AND (`stats_competition_id` = 5348)

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.496
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5348)

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.375
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` = '1622417') AND (`stats_competition_id` = 5348) 
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.494
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` = '1622417') AND (`stats_competition_id` = 5347)

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.521
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5347)

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.371
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` = '1622417') AND (`stats_competition_id` = 5347) 
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.522
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` = '1622417') AND (`competition`.`season` = 2000) AND
(`competition`.`statistics_visible` = 1) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` IS NULL) AND
(`competition`.`repre` = 0) 
ORDER BY `league`.`rank` ASC, `isBarage`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	competition	ref	PRIMARY,sezona	sezona	4	const	44	Using where; Using temporary; Using filesort
1	SIMPLE	stats_goalkeepers	ref	stats_player_id,fk_stats_goalkeepers_stats_player1,fk_stats_goalkeepers_stats_competition1	stats_player_id	10	const,test_dev_nhlcz_s6_esports_cz.competition.id	1	Using where; Using index
1	SIMPLE	stats_competition_tree	ref	fk_stats_competition_tree_stats_competition2	fk_stats_competition_tree_stats_competition2	5	test_dev_nhlcz_s6_esports_cz.stats_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.474
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` = '1622417') AND (`stats_competition_id` = 5350)

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.480
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5350)

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.292
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` = '1622417') AND (`stats_competition_id` = 5350) 
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.510
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` = '1622417') AND (`stats_competition_id` = 5349)

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.459
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` = '1622417') AND (`team`.`id` = 2368) AND
(`test_dev_nhlcz_s6_esports_cz`.`stats_competition_tree`.`stats_competition_id` = 5349)

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

...and more

¤ ×

Front:Player:Overview:default

https://test.nhlcz.s6.esports.cz/hrac/1622417?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 = 1622417 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 = 1622417 stats-section = club`
no	`ArticleCompatRoute`	`<slug [a-zA-Z-0-9\-]+>`	`module = Article presenter = Article action = default`	`Front`
no	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>/stranka[/<leagueId \d+>]/<sectionId \d+>[/<presenter>]`	`module = League presenter = Page action = default leagueId = NULL`	`Front`
no	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>/sekce/<sectionId \d+>`	`module = MinorLeague presenter = Section action = default`	`Front`
no	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>]`	`module = League presenter = Overview action = default id = NULL leagueId = NULL`	`Front`
no	`Route`	`<module>/<presenter>/<action>[/<id>]`	`id = NULL`	`Front`

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

¤ ×

NHL.cz na Facebooku

MARTIN BRODEUR

narozen

výška

věk

váha

post

hůl

NHL 2014-2015

Celá kariéra

Reprezentační kariéra

Články

Tento den v historii: Martin Brodeur zapsal rekordní čisté konto v play-off

Petr Adler: brankáři nejsou ze železa, ale každý z nich je jiný

Petr Adler: brankář je také jenom člověk

Petr Adler: kanadská juniorka se zdráhá pustit hráče na olympiádu

NHL.cz

Projekty

Organizace

Sociální sítě

Queries: 185, time: 97.732 ms, default

Front:Player:Overview:default