LOGIN
 

Queries: 34, time: 13.479 ms, default

Time msSQL QueryRows
0.363
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.354
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.229
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.252
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.418
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.295
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.385
explain
SELECT `id`, `hpimg`, `name` 
FROM `articles` 
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0) 
ORDER BY `id` DESC 
LIMIT 3 
OFFSET 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.401
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.372
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.145
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.695
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.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:71
1
0.266
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.323
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 43)
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.390
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 43)
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.376
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.330
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.355
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.420
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.299
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.317
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 26)
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.355
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.368
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.329
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.310
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.378
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.311
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.321
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.280
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.299
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.313
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.307
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.345
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.247
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/?strana=2

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-page = 2
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
strana = 2

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

¤ ×