Queries: 13, time: 56.351 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.226
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.145
explain

SELECT `id`, `name` 
FROM `category` 
WHERE (`public` = 1) AND (`show_in_post` = 1) AND (`category`.`id` = '287')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	category	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

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

53.279
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_category` ON `post`.`id` = `post_2_category`.`post_id` AND
(`post_2_category`.`category_id` = '287') 
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_category`.`category_id` = '287') 
ORDER BY `publish_date` DESC 
LIMIT 9 
OFFSET 144

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	17		11314	Using where
1	PRIMARY	post_2_category	eq_ref	PRIMARY,category_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

0.490
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018129)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.295
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018123)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.255
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018112)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.283
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018071)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.249
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018061)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.239
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018051)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.307
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018039)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.294
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018010)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

0.215
explain

SELECT `post`.*, `test_dev_nhlcz_s6_esports_cz`.`user`.`name` AS `userName`,
`test_dev_nhlcz_s6_esports_cz`.`user`.`surname` AS `userSurname` 
FROM `post` 
LEFT JOIN `test_dev_nhlcz_s6_esports_cz`.`user` ON `post`.`user_id` =
`test_dev_nhlcz_s6_esports_cz`.`user`.`id` 
WHERE (`post`.`id` = 5018003)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1
1	SIMPLE	user	const	PRIMARY,id_UNIQUE	PRIMARY	4	const	1

/var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/model/Post/PostService.php:69

¤ ×

Front:Article:Archive:category

https://test.nhlcz.s6.esports.cz/archiv-clanku/rubrika/287?page=17

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:category id = 287 page = 17`
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::actionCategory() in /var/home/www/nhlcz.s6.esports.cz/subdomains/test/app/Front/Article/presenters/ArchivePresenter.php:71

¤ ×

NHL.cz na Facebooku

Archív článků

Gól dne: Sharks předvedli skvělou kombinaci do prázdné brány

Gól dne: Andrew Mangiapane a jeho bekhendová trefa z těžké pozice

Gól dne: Paráda svátečního střelce Savarda

Gól dne: Pearsonovo sólo přes celé hřiště

Gól dne: Kane znovu udeřil

Gól dne: Johnson vystřelil Avs výhru v prodloužení proti Winnipegu

Gól dne: Kaneova bekhendová paráda

Gól dne: parádní otočka kapitána Columbusu

Gól dne: Austin Wagner a jeho bleskurychlá útočná akce

NHL.cz

Projekty

Organizace

Sociální sítě

Queries: 13, time: 56.351 ms, default

Front:Article:Archive:category