LOGIN
 

Queries: 34, time: 15.773 ms, default

Time msSQL QueryRows
0.584
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.528
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.334
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.520
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.471
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.405
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.409
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.341
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.431
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.757
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.788
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.402
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.438
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.387
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.314
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.458
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.413
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.299
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.543
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.343
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.379
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 13)
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.322
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.447
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.302
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.324
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 10)
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.347
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.339
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.343
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 22)
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.291
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.258
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.280
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.284
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.252 ms, default

Time msSQL QueryRows
0.864
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.586
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.381
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.349
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.559
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.383
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.312
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.400
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.550
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.868
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

¤ ×