LOGIN
 

Queries: 32, time: 11.729 ms, default

Time msSQL QueryRows
0.378
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.422
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.285
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.277
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.388
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.315
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.329
explain
SELECT `id`, `hpimg`, `name` 
FROM `articles` 
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `id` DESC 
LIMIT 2 
OFFSET 4
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
2
0.381
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.333
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.146
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.461
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.253
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.294
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.254
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 42)
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:108
1
0.270
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 42)
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:111
1
0.269
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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:108
1
0.342
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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:111
1
0.302
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.276
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.283
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.312
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 11)
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.326
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 31)
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.265
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.341
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 31)
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.309
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.259
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.266
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.278
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.311
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.268
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.253
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.283
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/?p=2&strana=3

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
vp-itemsPerPage = 2
vp-page = 3
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
p = 2
strana = 3

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

¤ ×