Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.523 explain |
SELECT `id`, `action`, `presenter`, `url_id`
FROM `router`
WHERE (`url` = 'hrad-zlenice-v-mediich')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.474 explain |
SELECT `name`, `value` FROM `settings`
|
7 | ||||||||||||||||||||||||||||||||||||||||
0.299 explain |
SELECT `id`, `link`, `text` FROM `footer_links` ORDER BY `priority` DESC
|
14 | ||||||||||||||||||||||||||||||||||||||||
0.368 explain |
SELECT `id`, `element`, `val` FROM `css`
|
22 | ||||||||||||||||||||||||||||||||||||||||
0.536 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Documents') AND (`action` = 'default') AND (`url_id` = 56)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.358 explain |
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` FROM `categories` WHERE (`id` = 56)
|
1 | ||||||||||||||||||||||||||||||||||||||||
ERROR | SELECT `id`, `link`, `name`, `file`, `file_extension`, `data`-`date` FROM `documents` WHERE (`category_id` = 56) ORDER BY `priority` DESC.../app/FrontModule/presenters/DocumentsPresenter.php:27 |
|||||||||||||||||||||||||||||||||||||||||
0.673 explain |
SELECT * FROM `documents` WHERE (`category_id` = 56) ORDER BY `priority` DESC
|
24 | ||||||||||||||||||||||||||||||||||||||||
0.708 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Documents') AND (`action` = 'default') AND (`url_id` = 56)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.469 explain |
SELECT `id`, `action`, `presenter`, `url_id`
FROM `router`
WHERE (`url` = 'hrad-zlenice-v-mediich')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.342 explain |
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` FROM `categories` WHERE (`id` = 56)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.391 explain |
SELECT `id`, `lft`, `rgt`, `name` FROM `categories` WHERE (`lft` <= 31) AND (`rgt` >= 32) AND (`depth` = 1)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.693 explain |
SELECT categories.*, router.url FROM categories JOIN router ON router.url_id = categories.id WHERE lft > 22 AND rgt < 33 AND presenter != "article" AND presenter != "galery" AND vip = 0
|
5 | ||||||||||||||||||||||||||||||||||||||||
0.884 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` = 'hrad-zlenice-v-mediich')
ORDER BY RAND()
|
2 | ||||||||||||||||||||||||||||||||||||||||
0.362 explain |
SELECT * FROM `banners` WHERE (`id` IN (4, 3))
|
2 | ||||||||||||||||||||||||||||||||||||||||
0.744 explain |
SELECT `id`, `hpimg`, `anotationHeading`, `anotationHeading2` FROM `articles` WHERE (`public` = 1) AND (`vip` = 0) ORDER BY RAND() LIMIT 4
|
4 | ||||||||||||||||||||||||||||||||||||||||
0.595 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 14)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.424 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 14)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.382 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 12)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.426 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 35)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.401 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 43)
|
1 | ||||||||||||||||||||||||||||||||||||||||
3.603 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
|
4 | ||||||||||||||||||||||||||||||||||||||||
0.464 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 27)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.429 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 10)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.405 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 32)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.418 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 12)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.467 explain |
SELECT `id`, `img`, `name`, `start` FROM `calendar` WHERE (DATE(`start`) >= DATE(NOW())) AND (`public` = 1) ORDER BY `start` LIMIT 10
|
0 |
http://zlenice.cz/hrad-zlenice-v-mediich
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
administrace/<presenter>/<action> |
presenter = Default |
Admin |
|
no | Route |
? strana=<vp-page> ? p=<vp-itemsPerPage> |
presenter = Homepage |
Front |
|
no | Route |
prihlaseni |
presenter = Auth |
Front |
|
no | Route |
registrace |
presenter = Auth |
Front |
|
no | Route |
zapomenute-heslo |
presenter = Auth |
Front |
|
no | Route |
nove-heslo |
presenter = Auth |
Front |
|
no | Route |
hledat-<kw> |
presenter = Search |
Front |
|
yes | DBRoute |
|
|
Front |
Front:documents:default |
FrontModule\DocumentsPresenter::renderDefault() in .../app/FrontModule/presenters/DocumentsPresenter.php:18