LOGIN

PODPORA ZÁCHRANY HRADU ZLENICE

Už jste četli?
Studie na záchranu a rehabilitaci hradní zříceniny Zlenice a jejího přírodního prostředí [2010] > Výzkum v roce 2001
> Obdarujte své blízké dárkem od nás
> Podpořte záchranu hradu Zlenice finančním darem
Už jste viděli?
 

Queries: 41, time: 16.309 ms, default

Time msSQL QueryRows
0.435
explain
SELECT `id`, `action`, `presenter`, `url_id` 
FROM `router` 
WHERE (`url` = 'podpora')
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router const url url 767 const 1
/var/www/hosting/zlenice.cz/www/index.php:5
1
0.286
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.314
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.252
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.497
explain
SELECT `articles_categories_rel`.`id`, `articles_categories_rel`.`article_id` 
FROM `articles_categories_rel` 
LEFT JOIN `articles` AS `article` ON `articles_categories_rel`.`article_id` = `article`.`id` 
WHERE (`category_id` = 36) AND (`article`.`public` = 1) AND (`vip` = 0) 
ORDER BY `article`.`priority` DESC, `article`.`id` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles_categories_rel ref article_id,category_id category_id 4 const 7 Using temporary; Using filesort
1 SIMPLE article eq_ref PRIMARY,public_vip PRIMARY 4 zlenice001.articles_categories_rel.article_id 1 Using where
.../FrontModule/presenters/ArticleListPresenter.php:35
7
0.291
explain
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` 
FROM `categories` 
WHERE (`id` = 36)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE categories const PRIMARY PRIMARY 4 const 1
.../FrontModule/presenters/ArticleListPresenter.php:36
1
0.351
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'ArticleList') 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/www/index.php:5
1
0.593
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'ArticleList') 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-main-layout-latte-5593e9185dd54e30200b64234aada81b.php:194
1
0.361
explain
SELECT `id`, `action`, `presenter`, `url_id` 
FROM `router` 
WHERE (`url` = 'podpora')
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router const url url 767 const 1
.../FrontModule/components/Breadcrumb/Breadcrumb.php:70
1
0.372
explain
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` 
FROM `categories` 
WHERE (`id` = 36)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE categories const PRIMARY PRIMARY 4 const 1
.../FrontModule/components/Breadcrumb/Breadcrumb.php:86
1
0.290
explain
SELECT `id`, `lft`, `rgt`, `name` 
FROM `categories` 
WHERE (`lft` <= 40) AND (`rgt` >= 41) AND (`depth` = 1)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE categories ALL 22 Using where
.../components/Breadcrumb/CategoriesRepository.php:43
1
0.480
explain
SELECT categories.*, router.url 
FROM categories 
 JOIN router ON router.url_id = categories.id
WHERE lft > 40 AND rgt < 41 AND presenter != "article" AND presenter != "galery" AND vip = 0
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE categories ALL PRIMARY,vip 22 Using where
1 SIMPLE router ref presenter_action_url_id,category_url_id category_url_id 5 zlenice001.categories.id 1 Using where
.../components/Breadcrumb/CategoriesRepository.php:33
0
0.536
explain
SELECT `banners_route_rel`.`id`, `banners_route_rel`.`banners_id` 
FROM `banners_route_rel` 
LEFT JOIN `banners` ON `banners_route_rel`.`banners_id` = `banners`.`id` 
LEFT JOIN `router` ON `banners_route_rel`.`router_id` = `router`.`id` 
WHERE (`banners`.`position` = 'leftBlock') AND (`router`.`url` = 'podpora') 
ORDER BY RAND()
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE router const PRIMARY,url url 767 const 1 Using index; Using temporary; Using filesort
1 SIMPLE banners_route_rel ref banners_id,router_id router_id 4 const 2
1 SIMPLE banners ALL PRIMARY 3 Using where; Using join buffer (flat, BNL join)
.../app/FrontModule/components/Banner/Banner.php:51
2
0.339
explain
SELECT * 
FROM `banners` 
WHERE (`id` IN (4, 3))
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE banners range PRIMARY PRIMARY 4 2 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-components-Banner-template-latte-556b5c82c781c1769cf50a54bdecb8af.php:17
2
0.540
explain
SELECT `id`, `hpimg`, `anotationHeading`, `anotationHeading2` 
FROM `articles` 
WHERE (`public` = 1) AND (`vip` = 0) 
ORDER BY RAND() 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles range public_vip public_vip 2 29 Using index condition; Using temporary; Using filesort
.../components/ArticleTips/ArticleRepository.php:22
4
0.320
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 47)
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/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:26
1
0.379
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 47)
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/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:31
1
0.314
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:38
1
0.357
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:38
1
0.337
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/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:38
1
2.020
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 4
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
.../components/GaleryTips/GaleriesImagesRepository.php:25
4
0.335
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/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25
1
0.369
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/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25
1
0.306
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/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25
1
0.356
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/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25
1
0.357
explain
SELECT `id`, `img`, `name`, `start` 
FROM `calendar` 
WHERE (DATE(`start`) >= DATE(NOW())) AND (`public` = 1) 
ORDER BY `start` 
LIMIT 10
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE calendar ALL 21 Using where; Using filesort
.../components/Calendar/CalendarRepository.php:18
0
0.399
explain
SELECT * 
FROM `articles` 
WHERE (`id` IN (50, 35, 36, 37, 39, 31, 38))
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE articles range PRIMARY PRIMARY 4 7 Using where
/var/www/hosting/zlenice.cz/temp/cache/latte/app-FrontModule-templates-ArticleList-default-latte-c8dc2443772467834f20b72805bed13a.php:52
7
0.378
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25
1
0.402
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32
1
0.383
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32
1
0.260
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25
1
0.326
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32
1
0.294
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25
1
0.258
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32
1
0.264
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32
1
0.436
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25
1
0.317
explain
SELECT `id`, `url` 
FROM `router` 
WHERE (`presenter` = 'Article') 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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32
1
0.273
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25
1
0.340
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/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32
1
¤ ×

Front:articleList:default

http://zlenice.cz/podpora

Matched? Class Mask Defaults Module Request
no Route administrace/<presenter>/<action> presenter = Default
action = default
Admin
no Route ? strana=<vp-page> ? p=<vp-itemsPerPage> presenter = Homepage
action = default
Front
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
yes DBRoute Front Front:articleList:default
urlId = 
36
id = 
NULL

FrontModule\ArticleListPresenter::actionDefault() in .../FrontModule/presenters/ArticleListPresenter.php:24

¤ ×