LOGIN
 

Queries: 34, time: 19.932 ms, default

Time msSQL QueryRows
0.612
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.488
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.384
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.358
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.457
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.534
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.442
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.505
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.486
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
3.822
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.767
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.579
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.582
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.659
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.529
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.475
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.487
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.490
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.404
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.474
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.421
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') 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:150 		1
0.421
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 16)
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.379
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 24)
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:150 		1
0.378
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 32)
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:150 		1
0.416
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 36)
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.433
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.454
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.603
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.548
explain 
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 15)
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.632
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.392
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.478
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.445
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.398
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: 7.529 ms, default

Time msSQL QueryRows
0.598
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.414
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.353
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.352
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.486
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.404
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.356
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.349
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
3.879
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

¤ ×