Poř.	Jméno	Tým	P	Z	Min.	IG	Z	SP	V	P	Prům.	%Ú	A	TM	SO
1	Corey Crawford	Chicago Blackhawks	B	7	451	19	186	205	3	4	2.53	90.73	0	2	0

Queries: 5, time: 2.128 ms, default

Time ms

SQL Query

Rows

0.070

SET NAMES 'utf8'

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Country/CountryRepository.php:13

0.054
explain

SELECT `id`, `code`, `name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`country` 
ORDER BY `name`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	country	ALL					41	Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/PlayerStats/PlayerFilter/PlayerBaseFilter.php:134

0.049
explain

SELECT `id`, `code`, `name` 
FROM `test_dev_nhlcz_s6_esports_cz`.`country` 
ORDER BY `name`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	country	ALL					41	Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/PlayerStats/PlayerFilter/PlayerBaseFilter.php:134

1.043
explain

SELECT `player`.`date_of_birth`, `goals`, `assistances`, `player`.`id` AS `player_id`,
`player`.`name`, `player`.`surname`, `player`.`photo`, `player`.`position`,
`player`.`date_of_birth`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `team`.`stats_club_id` `club_id`,
`team`.`id` `team_id`, `club`.`shortcut`, `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`, `minutes_played`, `saves`,
`lost_goals`, `shots_against`, `matches_initial`, `wins`, `losses`, `clear_scores`, `average`,
`saves_percentage`, `penalties`, `assistances`, `goals`, `matches` 
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_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(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 `team`.`stats_club_id` =
`club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `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_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)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`summary` = 1) AND (`stats_competition_id` = '5810') AND (`matches`>0) AND (`team`.`id` =
'2388')

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_goalkeepers	index_merge	fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	5,5		1	Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1); Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id	1
1	PRIMARY	club	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_club_name	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.club.id	1
1	PRIMARY	stats_club_logo	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.club.id	1
1	PRIMARY	player	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_player_id	1
1	PRIMARY	country	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.player.country_id	1
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/components/PlayerStats/BaseFactory.php:44

0.912
explain

SELECT `player`.`date_of_birth`, `goals`, `assistances`, `player`.`id` AS `player_id`,
`player`.`name`, `player`.`surname`, `player`.`photo`, `player`.`position`,
`player`.`date_of_birth`, `test_dev_nhlcz_s6_esports_cz`.`country`.`name` AS `country`,
`test_dev_nhlcz_s6_esports_cz`.`country`.`code` AS `country_code`, `team`.`stats_club_id` `club_id`,
`team`.`id` `team_id`, `club`.`shortcut`, `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`, `minutes_played`, `saves`,
`lost_goals`, `shots_against`, `matches_initial`, `wins`, `losses`, `clear_scores`, `average`,
`saves_percentage`, `penalties`, `assistances`, `goals`, `matches` 
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_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(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 `team`.`stats_club_id` =
`club`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_club_name` ON `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_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)) 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_player` AS `player` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_goalkeepers`.`stats_player_id` = `player`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`country` ON `player`.`country_id` =
`test_dev_nhlcz_s6_esports_cz`.`country`.`id` 
WHERE (`summary` = 1) AND (`stats_competition_id` = '5810') AND (`matches`>0) AND (`team`.`id` =
'2388') 
ORDER BY `is_upper` DESC, `saves_percentage` DESC, `matches` ASC 
LIMIT 40

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	team	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	PRIMARY	stats_goalkeepers	index_merge	fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1	5,5		1	Using intersect(fk_stats_goalkeepers_stats_competition1,fk_stats_goalkeepers_stats_team1); Using where
1	PRIMARY	stats_team_name	ref	stats_team_id	stats_team_id	5	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_team_id	1
1	PRIMARY	club	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_club_name	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.club.id	1
1	PRIMARY	stats_club_logo	ref	stats_club_id	stats_club_id	5	test_dev_nhlcz_s6_esports_cz.club.id	1
1	PRIMARY	player	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.stats_goalkeepers.stats_player_id	1
1	PRIMARY	country	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.player.country_id	1
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/temp/cache/latte/components-PlayerStats-Goalkeeper-columns-latte-053cf96a18f10b491ee5576a15d1eb67.php:45

¤ ×

Unlogged

no identity

¤ ×

Front:League:PlayerStats:detailed

https://test.nhlcz.s6.esports.cz/sezona/player-stats/detailni?stats-filter-season=2015&stats-filter-competition=5810&stats-filter-team=2388&stats-menu-section=goalkeeper

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`
no	`Route`	`hrac/<id [0-9]+>[/<presenter>]`	`module = Player presenter = Overview action = default`	`Front`
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`
no	`ArticleRoute`	`<slug [a-zA-Z-0-9\-]+>/<id \d+>`	`module = Article presenter = Article action = default`	`Front`
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`
yes	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>]`	`module = League presenter = Overview action = default id = NULL leagueId = NULL`	`Front`	`Front:League:PlayerStats:detailed id = 1 leagueId = NULL stats-filter-season = 2015 stats-filter-competition = 5810 stats-filter-team = 2388 stats-menu-section = goalkeeper`
may	`Route`	`<module>/<presenter>/<action>[/<id>]`	`id = NULL`	`Front`	`Front:Sezona:PlayerStats:detailni id = NULL stats-filter-season = 2015 stats-filter-competition = 5810 stats-filter-team = 2388 stats-menu-section = goalkeeper`

Front\League\PlayerStatsPresenter::actionDetailed() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/League/presenters/PlayerStatsPresenter.php:13

¤ ×

Queries: 2, time: 0.517 ms, default

Time ms

SQL Query

Rows

0.086

SET NAMES 'utf8'

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Competition/CompetitionRepository.php:27

0.431
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_competition`.*, `phase`.`name` AS `phase_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_category`.`type` AS `type` 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_competition` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_phase` AS `phase` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`phase` = `phase`.`id` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`stats_category` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`stats_category_id` =
`test_dev_nhlcz_s6_esports_cz`.`stats_category`.`id` 
WHERE (`league_id` = 29) AND (`test_dev_nhlcz_s6_esports_cz`.`stats_competition`.`id` = '5810')

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	stats_competition	const	PRIMARY,league_id	PRIMARY	4	const	1
1	SIMPLE	phase	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	stats_category	const	PRIMARY	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/components/PlayerStats/Filter/Filter.php:284

¤ ×

Unlogged

no identity

¤ ×

Front:League:PlayerStats:detailed

https://test.nhlcz.s6.esports.cz/sezona/player-stats/detailni?competition=5810&section=goalkeeper&teamId=2388

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`
no	`Route`	`hrac/<id [0-9]+>[/<presenter>]`	`module = Player presenter = Overview action = default`	`Front`
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`
no	`ArticleRoute`	`<slug [a-zA-Z-0-9\-]+>/<id \d+>`	`module = Article presenter = Article action = default`	`Front`
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`
yes	`LeagueRoute`	`<id [a-zA-Z-0-9\-]+>[/<presenter>][/<action>][/<leagueId \d+>]`	`module = League presenter = Overview action = default id = NULL leagueId = NULL`	`Front`	`Front:League:PlayerStats:detailed id = 1 leagueId = NULL competition = 5810 section = goalkeeper teamId = 2388`
may	`Route`	`<module>/<presenter>/<action>[/<id>]`	`id = NULL`	`Front`	`Front:Sezona:PlayerStats:detailni id = NULL competition = 5810 section = goalkeeper teamId = 2388`

Front\League\PlayerStatsPresenter::actionDetailed() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/League/presenters/PlayerStatsPresenter.php:13

¤ ×

NHL.cz na Facebooku

Zápasy a statistiky

NHL.cz

Projekty

Organizace

Sociální sítě

Queries: 5, time: 2.128 ms, default

Unlogged

Front:League:PlayerStats:detailed

Queries: 2, time: 0.517 ms, default

Unlogged

Front:League:PlayerStats:detailed