Queries: 6, time: 6.471 ms, default

Time ms

SQL Query

Rows

0.082

SET NAMES 'utf8'

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

0.071
explain

SELECT `id`, `parent_id`, `name`, `slug`, `public`, `show_in_post` 
FROM `category` 
ORDER BY `name`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	category	ALL					17	Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/TreeHelper.php:39

0.611
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
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_logo` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_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_club`.`id` = '2005')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_club	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_club_name	ref	stats_club_id	stats_club_id	5	const	2
1	PRIMARY	stats_club_logo	ref	stats_club_id	stats_club_id	5	const	2
3	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
2	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

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArchivePresenter.php:93

5.203
explain

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

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

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArchivePresenter.php:237

0.089
explain

SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode` 
FROM `zone` 
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id` 
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id` 
WHERE (`zone_template`.`code` = 'default')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zone_template	ref	PRIMARY,code	code	302	const	1	Using where; Using index
1	SIMPLE	zone	ref	zone_template_id_zone_position_id,zone_template_id	zone_template_id_zone_position_id	4	test_dev_nhlcz_s6_esports_cz.zone_template.id	17
1	SIMPLE	zone_position	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.zone.zone_position_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:182

0.415
explain

SELECT `zone`.*, `zone_template`.`code` AS `templateCode`, `zone_position`.`code` AS `positionCode` 
FROM `zone` 
LEFT JOIN `zone_template` ON `zone`.`zone_template_id` = `zone_template`.`id` 
LEFT JOIN `zone_position` ON `zone`.`zone_position_id` = `zone_position`.`id` 
WHERE (`zone_template`.`code` = 'post')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zone_template	ref	PRIMARY,code	code	302	const	1	Using where; Using index
1	SIMPLE	zone	ref	zone_template_id_zone_position_id,zone_template_id	zone_template_id_zone_position_id	4	test_dev_nhlcz_s6_esports_cz.zone_template.id	17
1	SIMPLE	zone_position	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.zone.zone_position_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Zone/ZoneService.php:185

¤ ×

Unlogged

no identity

¤ ×

Front:Article:Archive:club

https://test.nhlcz.s6.esports.cz/archiv-clanku/klub/2005

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`
yes	`Route`	`/archiv-clanku[/<action>][/<id \d+>]`	`module = Article presenter = Archive action = default id = NULL`	`Front`	`Front:Article:Archive:club id = 2005`
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`
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\Article\ArchivePresenter::actionClub() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArchivePresenter.php:91

¤ ×

Queries: 4, time: 1.777 ms, default

Time ms

SQL Query

Rows

0.075

SET NAMES 'utf8'

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

0.292
explain

SELECT `id`, `parent_id`, `name`, `slug`, `public`, `show_in_post` 
FROM `category` 
ORDER BY `name`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	category	ALL					17	Using filesort

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/classes/TreeHelper.php:39

0.740
explain

SELECT `test_dev_nhlcz_s6_esports_cz`.`stats_club_name`.`name` `club_name`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club_logo`.`path` `club_logo`,
`test_dev_nhlcz_s6_esports_cz`.`stats_club`.* 
FROM `test_dev_nhlcz_s6_esports_cz`.`stats_club` 
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_logo` ON
`test_dev_nhlcz_s6_esports_cz`.`stats_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_club`.`id` = '2005')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	stats_club	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	stats_club_name	ref	stats_club_id	stats_club_id	5	const	2
1	PRIMARY	stats_club_logo	ref	stats_club_id	stats_club_id	5	const	2
3	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
2	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

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArchivePresenter.php:93

0.670
explain

SELECT `post`.*, IFNULL(get_post_title(`post`.`id`, `post`.`rotate_title`), `post`.`name`) AS
`nameTitle`, IF(`post`.`photo_id` IS NOT NULL, (
SELECT `photo`.`url` 
FROM `photo` 
WHERE `photo`.`id`=`post`.`photo_id`), IF(`post`.`file_id` IS NOT NULL, (
SELECT CONCAT('/static/files/', `file`.`path`, `file`.`filename`, ".", `file`.`extension`) AS `url` 
FROM `file` 
WHERE `file`.`id`=`post`.`file_id`), NULL)) AS `photoUrl` 
FROM `post` FORCE INDEX (`post_article_base_index`) 
LEFT JOIN `post_2_stats_club` ON `post`.`id` = `post_2_stats_club`.`post_id` 
WHERE (`post`.`post_type_id` = 2) AND (`post`.`post_state_id` = 3) AND (`post`.`publish_date` <=
NOW()) AND (`post`.`unpublish_date` IS NULL OR (`post`.`unpublish_date` IS NOT NULL AND
`post`.`unpublish_date` >= NOW())) AND (`post_2_stats_club`.`stats_club_id` = '2005') AND
(`post`.`publish_date` >= '2025-03-06 16:09:25') 
ORDER BY `publish_date` DESC 
LIMIT 9

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	post	range	post_article_base_index	post_article_base_index	26		1	Using where
1	PRIMARY	post_2_stats_club	eq_ref	PRIMARY,stats_team_id	PRIMARY	8	test_dev_nhlcz_s6_esports_cz.post.id,const	1	Using where; Using index
3	DEPENDENT SUBQUERY	file	eq_ref	PRIMARY,id_UNIQUE	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.file_id	1
2	DEPENDENT SUBQUERY	photo	eq_ref	PRIMARY	PRIMARY	4	test_dev_nhlcz_s6_esports_cz.post.photo_id	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArchivePresenter.php:237

¤ ×

Unlogged

no identity

¤ ×

Front:Article:Archive:club dateFilter-filter!

https://test.nhlcz.s6.esports.cz/archiv-clanku/klub/2005?dateFilter-filter=lastWeek&do=dateFilter-filter

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`
yes	`Route`	`/archiv-clanku[/<action>][/<id \d+>]`	`module = Article presenter = Archive action = default id = NULL`	`Front`	`Front:Article:Archive:club id = 2005 dateFilter-filter = lastWeek do = dateFilter-filter`
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`
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\Article\ArchivePresenter in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArchivePresenter.php:7

¤ ×

previous
351.9 ms
34.63 MB
4 queries / 1.8 ms
Front:Article:Archive:club dateFilter-filter!
×

NHL.cz na Facebooku

Archív článků

Chychrun stále touží po výměně! Sezónu však začne v Arizoně

Preview: Cíl Arizony? Získat jedničku následujícího draftu

Smolař Jaškin. V Arizoně se trápil, teď jej vyřadil ošklivý faul

Musíme víc střílet, hlásí Jaškin. A chválí Vejmelku

Žalostné výkony Kojotů neberou konce. Podaří se jim zvednout?

“Zelenina“ první hvězdou. Byl fenomenální, smekl před Vejmelkou trenér

PREVIEW: Kapitán odešel, je tu přestavba! Jak si povede Arizona i s českými posilami?

Husarský kousek! Nadšení Coyotes se těší na Guenthera

Kam přestěhovat Kojoty? Hlavně ne do Texasu, vzkazují Stars

NHL.cz

Projekty

Organizace

Sociální sítě

Queries: 6, time: 6.471 ms, default

Unlogged

Front:Article:Archive:club

Queries: 4, time: 1.777 ms, default

Unlogged

Front:Article:Archive:club dateFilter-filter!