Homepage:default

http://telco-trutnov.cz/nabidka/specialni-informacni-technologie/jednotny-cas/

Matched?	Class	Mask	Defaults	Request
no	`Route`	`index.php`	`presenter = Homepage action = default`
yes	`Route`	`[<lang=cs [a-z]{2}>/][<prom1>/][<prom2>/][<prom3>/]`	`presenter = Homepage action = default prom3 = NULL prom2 = NULL prom1 = NULL lang = cs`	`Homepage:default prom1 = nabidka prom2 = specialni-informacni-technologie prom3 = jednotny-cas lang = cs`
may	`Route`	`[<prom1>/][<prom2>/][<prom3>/]`	`presenter = Homepage action = default prom3 = NULL prom2 = NULL prom1 = NULL`	`Homepage:default prom1 = nabidka prom2 = specialni-informacni-technologie prom3 = jednotny-cas`

App\Presenters\HomepagePresenter::actionDefault() in .../app/presenters/HomepagePresenter.php:39

¤ ×

Queries: 13, time: 2.430 ms, default

Time ms

SQL Query

Rows

0.229
explain

SELECT `id` 
FROM `language` 
WHERE (`show` = 1) AND (`deleted` = 0) AND (`shortcut` = 'cs')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	language	ALL					2	Using where

.../app/model/Language.php:14

0.448
explain

SELECT `menu`.`id` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu_t`.`value` = 'nabidka') AND
(`menu`.`menu_id` IS NULL)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx				14	Using where
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1	Using where

.../app/presenters/HomepagePresenter.php:50

0.125
explain

SELECT `menu`.`id` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu_t`.`value` = 'specialni-informacni-technologie') AND
(`menu`.`menu_id` = 8)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx				14	Using where
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1	Using where

.../app/presenters/HomepagePresenter.php:65

0.152
explain

SELECT `menu_t`.`name`, `menu_t`.`title`, `menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`id` = 12)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	menu_t	const	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	const,const	1

.../app/presenters/HomepagePresenter.php:66

0.135
explain

SELECT `text_t`.`name`, `text_t`.`title`, `text_t`.`value` 
FROM `text` 
LEFT JOIN `text_t` ON `text`.`id` = `text_t`.`text_id` 
WHERE (`text`.`show` = 1) AND (`text_t`.`language_id` = 1) AND (`text_t`.`value` = 'jednotny-cas')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	text	ALL	PRIMARY				35	Using where
1	SIMPLE	text_t	eq_ref	text_id_UNIQUE,fk_texttranslation_text1_idx,fk_texttranslation_language1_idx	text_id_UNIQUE	8	c1p_telco.text.id,const	1	Using where

.../app/presenters/HomepagePresenter.php:69

0.179
explain

SELECT `menu_t`.`name`, `menu_t`.`value`, `menu_t`.`title` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`id` = 8)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	menu_t	const	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	const,const	1

.../app/presenters/HomepagePresenter.php:74

0.137
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_type_id` = 1) AND
(`menu`.`menu_id` IS NULL) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx,fk_menu_menu_type1_idx				14	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:79

0.136
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 2) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ref	PRIMARY,fk_menu_menu1_idx	fk_menu_menu1_idx	5	const	1	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

0.148
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 8) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx				14	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

0.121
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 7) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ref	PRIMARY,fk_menu_menu1_idx	fk_menu_menu1_idx	5	const	1	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

0.122
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 6) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ref	PRIMARY,fk_menu_menu1_idx	fk_menu_menu1_idx	5	const	1	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

0.201
explain

SELECT `text`.`id`, `text_t`.`name`, `text_t`.`description` 
FROM `text` 
LEFT JOIN `text_t` ON `text`.`id` = `text_t`.`text_id` 
WHERE (`text`.`show` = 1) AND (`text_t`.`language_id` = 1) AND (`text_t`.`value` = 'jednotny-cas')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	text	ALL	PRIMARY				35	Using where
1	SIMPLE	text_t	eq_ref	text_id_UNIQUE,fk_texttranslation_text1_idx,fk_texttranslation_language1_idx	text_id_UNIQUE	8	c1p_telco.text.id,const	1	Using where

.../app/presenters/HomepagePresenter.php:153

0.297
explain

SELECT `link`.`id`, `link`.`link`, `link_t`.`name`,`link_t`.`description` 
FROM `link` 
LEFT JOIN `link_t` ON `link`.`id` = `link_t`.`link_id` 
WHERE (`link`.`show` = 1) AND (`link`.`deleted` = 0) AND (`link_t`.`language_id` = 1) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	link	ALL	PRIMARY				3	Using where; Using temporary; Using filesort
1	SIMPLE	link_t	ALL	link_id_UNIQUE,fk_linktranslation_link1_idx,fk_linktranslation_language1_idx				3	Using where; Using join buffer (flat, BNL join)

.../temp/cache/latte/client1-web14-web-prod-app-templates-layout-latte-bbd3755071b07989de7c2bcfda78f860.php:168

¤ ×

Unlogged

no identity

¤ ×

Homepage:default

http://telco-trutnov.cz/nabidka/specialni-informacni-technologie/jednotny-cas

Matched?	Class	Mask	Defaults	Request
no	`Route`	`index.php`	`presenter = Homepage action = default`
yes	`Route`	`[<lang=cs [a-z]{2}>/][<prom1>/][<prom2>/][<prom3>/]`	`presenter = Homepage action = default prom3 = NULL prom2 = NULL prom1 = NULL lang = cs`	`Homepage:default prom1 = nabidka prom2 = specialni-informacni-technologie prom3 = jednotny-cas lang = cs`
may	`Route`	`[<prom1>/][<prom2>/][<prom3>/]`	`presenter = Homepage action = default prom3 = NULL prom2 = NULL prom1 = NULL`	`Homepage:default prom1 = nabidka prom2 = specialni-informacni-technologie prom3 = jednotny-cas`

App\Presenters\HomepagePresenter::actionDefault() in .../app/presenters/HomepagePresenter.php:39

¤ ×

Queries: 11, time: 1.867 ms, default

Time ms

SQL Query

Rows

0.333
explain

SELECT `id` 
FROM `language` 
WHERE (`show` = 1) AND (`deleted` = 0) AND (`shortcut` = 'cs')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	language	ALL					2	Using where

.../app/model/Language.php:14

0.134
explain

SELECT `menu`.`id` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu_t`.`value` = 'nabidka') AND
(`menu`.`menu_id` IS NULL)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx				14	Using where
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1	Using where

.../app/presenters/HomepagePresenter.php:50

0.157
explain

SELECT `menu`.`id` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu_t`.`value` = 'specialni-informacni-technologie') AND
(`menu`.`menu_id` = 8)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx				14	Using where
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1	Using where

.../app/presenters/HomepagePresenter.php:65

0.161
explain

SELECT `menu_t`.`name`, `menu_t`.`title`, `menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`id` = 12)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	menu_t	const	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	const,const	1

.../app/presenters/HomepagePresenter.php:66

0.215
explain

SELECT `text_t`.`name`, `text_t`.`title`, `text_t`.`value` 
FROM `text` 
LEFT JOIN `text_t` ON `text`.`id` = `text_t`.`text_id` 
WHERE (`text`.`show` = 1) AND (`text_t`.`language_id` = 1) AND (`text_t`.`value` = 'jednotny-cas')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	text	ALL	PRIMARY				35	Using where
1	SIMPLE	text_t	eq_ref	text_id_UNIQUE,fk_texttranslation_text1_idx,fk_texttranslation_language1_idx	text_id_UNIQUE	8	c1p_telco.text.id,const	1	Using where

.../app/presenters/HomepagePresenter.php:69

0.183
explain

SELECT `menu_t`.`name`, `menu_t`.`value`, `menu_t`.`title` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`id` = 8)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	menu_t	const	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	const,const	1

.../app/presenters/HomepagePresenter.php:74

0.156
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_type_id` = 1) AND
(`menu`.`menu_id` IS NULL) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx,fk_menu_menu_type1_idx				14	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:79

0.128
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 2) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ref	PRIMARY,fk_menu_menu1_idx	fk_menu_menu1_idx	5	const	1	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

0.138
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 8) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ALL	PRIMARY,fk_menu_menu1_idx				14	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

0.122
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 7) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ref	PRIMARY,fk_menu_menu1_idx	fk_menu_menu1_idx	5	const	1	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

0.140
explain

SELECT `menu`.`id`, `menu_t`.`name`,`menu_t`.`value` 
FROM `menu` 
LEFT JOIN `menu_t` ON `menu`.`id` = `menu_t`.`menu_id` 
WHERE (`menu`.`show` = 1) AND (`menu_t`.`language_id` = 1) AND (`menu`.`menu_id` = 6) 
ORDER BY `order`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	menu	ref	PRIMARY,fk_menu_menu1_idx	fk_menu_menu1_idx	5	const	1	Using where; Using filesort
1	SIMPLE	menu_t	eq_ref	menu_id_UNIQUE,fk_menutranslation_menu1_idx,fk_menutranslation_language1_idx	menu_id_UNIQUE	8	c1p_telco.menu.id,const	1

.../app/presenters/HomepagePresenter.php:80

¤ ×

Unlogged

no identity

¤ ×

Tracy
242.4 ms
7.73 MB
Homepage:default
13 queries / 2.4 ms

previous
194.5 ms
6.01 MB
Homepage:default
11 queries / 1.9 ms
×

Jednotný čas

Homepage:default

Queries: 13, time: 2.430 ms, default

Unlogged

Homepage:default

Queries: 11, time: 1.867 ms, default

Unlogged