LOGIN
 

Queries: 34, time: 12.827 ms, default

Time msSQL QueryRows
0.527
explain 
SELECT `name`, `value` 
FROM `settings`
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE settings ALL 7
.../app/FrontModule/presenters/BasePresenter.php:48 		7
0.304
explain 
SELECT `id`, `link`, `text` 
FROM `footer_links` 
ORDER BY `priority` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE footer_links ALL 14 Using filesort
.../app/FrontModule/presenters/BasePresenter.php:54 		14
0.280
explain 
SELECT `id`, `element`, `val` 
FROM `css`
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE css ALL 22
.../app/FrontModule/presenters/BasePresenter.php:62 		22
0.328
explain 
SELECT `id`, `link`, `path` 
FROM `sliders` 
WHERE (`type` = 'default')
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sliders ALL 3 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:49 		3
0.380
explain 
SELECT `id`, `mimg`, `anotationHeading`, `anotationTextHead`, `anotationText` 
FROM `articles` 
WHERE (`mainHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `id` DESC 
LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref mainHomepage,public_vip mainHomepage 1 const 1 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:62 		1
0.363
explain 
SELECT `id`, `hpimg`, `name` 
FROM `articles` 
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref listHomepage,public_vip listHomepage 1 const 6 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:65 		6
0.282
explain 
SELECT `id`, `hpimg`, `name` 
FROM `articles` 
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `id` DESC 
LIMIT 3
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref listHomepage,public_vip listHomepage 1 const 6 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:67 		3
0.338
explain 
SELECT `id`, `anotationHeading` 
FROM `articles` 
WHERE (`donateHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `priority` DESC 
LIMIT 5
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref donateHomepage,public_vip donateHomepage 1 const 6 Using where; Using filesort
.../app/FrontModule/presenters/HomepagePresenter.php:68 		5
0.318
explain 
SELECT `id`, `img`, `name`, `start` 
FROM `calendar` 
WHERE (DATE(`start`) >= DATE(NOW())) AND (`public` = 1) 
ORDER BY `start` 
LIMIT 5
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE calendar ALL 21 Using where; Using filesort
.../app/FrontModule/models/CalendarRepository.php:18 		0
2.217
explain 
SELECT `galeries_images`.`id`, `galeries_images`.`galery_id`, `galeries_images`.`path` 
FROM `galeries_images` 
LEFT JOIN `galeries` AS `galery` ON `galeries_images`.`galery_id` = `galery`.`id` 
WHERE (`galery`.`public` = 1) AND (`vip` = 0) 
ORDER BY RAND() 
LIMIT 10
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE galery ref PRIMARY,public_vip public_vip 5 const,const 24 Using index; Using temporary; Using filesort
1 SIMPLE galeries_images ref galery_id galery_id 4 zlenice001.galery.id 18
.../FrontModule/models/GaleriesImagesRepository.php:35 		10
0.448
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:68 		1
0.316
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:71 		1
0.286
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:78 		1
0.317
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 51)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:108 		1
0.266
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 51)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:111 		1
0.331
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:108 		1
0.268
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:111 		1
0.314
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 44)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:108 		1
0.271
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 44)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:111 		1
0.288
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 14)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.263
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 12)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.442
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 27)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.387
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 17)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.307
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 25)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.305
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 19)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.301
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 18)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.304
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 29)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.279
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 29)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.284
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 27)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 		1
0.319
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 50)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 		1
0.290
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 35)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 		1
0.287
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 37)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id presenter_action_url_id 1539 const,const,const 1 Using index condition
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 		1
0.335
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 39)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 		1
0.282
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 38)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 const 1 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 		1
¤ ×

Front:Homepage:default

http://zlenice.cz/

Matched? Class Mask Defaults Module Request
no Route administrace/<presenter>/<action> presenter = Default
action = default
 Admin
yes Route ? strana=<vp-page> ? p=<vp-itemsPerPage> presenter = Homepage
action = default
 Front Front:Homepage:default
no Route prihlaseni presenter = Auth
action = logIn
 Front
no Route registrace presenter = Auth
action = register
 Front
no Route zapomenute-heslo presenter = Auth
action = lostPw
 Front
no Route nove-heslo presenter = Auth
action = createNewPW
 Front
no Route hledat-<kw> presenter = Search
action = default
 Front
may DBRoute Front Front::default
urlId = 
NULL
id = 
NULL

FrontModule\HomepagePresenter::actionDefault() in .../app/FrontModule/presenters/HomepagePresenter.php:45

¤ ×

Unlogged

no identity

¤ ×

Queries: 10, time: 6.358 ms, default

Time msSQL QueryRows
0.661
explain 
SELECT `name`, `value` 
FROM `settings`
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE settings ALL 7
.../app/FrontModule/presenters/BasePresenter.php:48 		7
0.348
explain 
SELECT `id`, `link`, `text` 
FROM `footer_links` 
ORDER BY `priority` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE footer_links ALL 14 Using filesort
.../app/FrontModule/presenters/BasePresenter.php:54 		14
0.306
explain 
SELECT `id`, `element`, `val` 
FROM `css`
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE css ALL 22
.../app/FrontModule/presenters/BasePresenter.php:62 		22
0.405
explain 
SELECT `id`, `link`, `path` 
FROM `sliders` 
WHERE (`type` = 'default')
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sliders ALL 3 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:49 		3
0.700
explain 
SELECT `id`, `mimg`, `anotationHeading`, `anotationTextHead`, `anotationText` 
FROM `articles` 
WHERE (`mainHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `id` DESC 
LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref mainHomepage,public_vip mainHomepage 1 const 1 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:62 		1
0.479
explain 
SELECT `id`, `hpimg`, `name` 
FROM `articles` 
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref listHomepage,public_vip listHomepage 1 const 6 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:65 		6
0.257
explain 
SELECT `id`, `hpimg`, `name` 
FROM `articles` 
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `id` DESC 
LIMIT 3
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref listHomepage,public_vip listHomepage 1 const 6 Using where
.../app/FrontModule/presenters/HomepagePresenter.php:67 		3
0.397
explain 
SELECT `id`, `anotationHeading` 
FROM `articles` 
WHERE (`donateHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `priority` DESC 
LIMIT 5
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles ref donateHomepage,public_vip donateHomepage 1 const 6 Using where; Using filesort
.../app/FrontModule/presenters/HomepagePresenter.php:68 		5
0.441
explain 
SELECT `id`, `img`, `name`, `start` 
FROM `calendar` 
WHERE (DATE(`start`) >= DATE(NOW())) AND (`public` = 1) 
ORDER BY `start` 
LIMIT 5
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE calendar ALL 21 Using where; Using filesort
.../app/FrontModule/models/CalendarRepository.php:18 		0
2.364
explain 
SELECT `galeries_images`.`id`, `galeries_images`.`galery_id`, `galeries_images`.`path` 
FROM `galeries_images` 
LEFT JOIN `galeries` AS `galery` ON `galeries_images`.`galery_id` = `galery`.`id` 
WHERE (`galery`.`public` = 1) AND (`vip` = 0) 
ORDER BY RAND() 
LIMIT 10
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE galery ref PRIMARY,public_vip public_vip 5 const,const 24 Using index; Using temporary; Using filesort
1 SIMPLE galeries_images ref galery_id galery_id 4 zlenice001.galery.id 18
.../FrontModule/models/GaleriesImagesRepository.php:35 		10
¤ ×

Front:Homepage:default

https://zlenice.cz/

Matched? Class Mask Defaults Module Request
no Route administrace/<presenter>/<action> presenter = Default
action = default
 Admin
yes Route ? strana=<vp-page> ? p=<vp-itemsPerPage> presenter = Homepage
action = default
 Front Front:Homepage:default
no Route prihlaseni presenter = Auth
action = logIn
 Front
no Route registrace presenter = Auth
action = register
 Front
no Route zapomenute-heslo presenter = Auth
action = lostPw
 Front
no Route nove-heslo presenter = Auth
action = createNewPW
 Front
no Route hledat-<kw> presenter = Search
action = default
 Front
may DBRoute Front Front::default
urlId = 
NULL
id = 
NULL

FrontModule\HomepagePresenter::actionDefault() in .../app/FrontModule/presenters/HomepagePresenter.php:45

¤ ×

Unlogged

no identity

¤ ×