Homepage:default

http://telco-trutnov.cz/nabidka/zemni-prace/inzenyrske-site/

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 = zemni-prace prom3 = inzenyrske-site lang = cs`
may	`Route`	`[<prom1>/][<prom2>/][<prom3>/]`	`presenter = Homepage action = default prom3 = NULL prom2 = NULL prom1 = NULL`	`Homepage:default prom1 = nabidka prom2 = zemni-prace prom3 = inzenyrske-site`

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

¤ ×

Queries: 13, time: 2.718 ms, default

Time ms

SQL Query

Rows

0.268
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.116
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.120
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` = 'zemni-prace')
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.145
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` = 13)

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.184
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` =
'inzenyrske-site')

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.137
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.163
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.159
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.198
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.157
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.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` = 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.606
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` =
'inzenyrske-site')

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.329
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/zemni-prace/inzenyrske-site

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 = zemni-prace prom3 = inzenyrske-site lang = cs`
may	`Route`	`[<prom1>/][<prom2>/][<prom3>/]`	`presenter = Homepage action = default prom3 = NULL prom2 = NULL prom1 = NULL`	`Homepage:default prom1 = nabidka prom2 = zemni-prace prom3 = inzenyrske-site`

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

¤ ×

Queries: 11, time: 3.105 ms, default

Time ms

SQL Query

Rows

0.314
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.170
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.148
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` = 'zemni-prace')
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.177
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` = 13)

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.614
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` =
'inzenyrske-site')

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.528
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.163
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.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` = 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.546
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.130
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.175
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
274.8 ms
7.73 MB
Homepage:default
13 queries / 2.7 ms

previous
222.7 ms
6.01 MB
Homepage:default
11 queries / 3.1 ms
×

Inženýrské sítě

Homepage:default

Queries: 13, time: 2.718 ms, default

Unlogged

Homepage:default

Queries: 11, time: 3.105 ms, default

Unlogged