Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.539 explain |
SELECT `id`, `action`, `presenter`, `url_id`
FROM `router`
WHERE (`url` = 'hrad-zlenice-v-mediich')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.310 explain |
SELECT `name`, `value` FROM `settings`
|
7 | ||||||||||||||||||||||||||||||||||||||||
0.316 explain |
SELECT `id`, `link`, `text` FROM `footer_links` ORDER BY `priority` DESC
|
14 | ||||||||||||||||||||||||||||||||||||||||
0.301 explain |
SELECT `id`, `element`, `val` FROM `css`
|
22 | ||||||||||||||||||||||||||||||||||||||||
0.383 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Documents') AND (`action` = 'default') AND (`url_id` = 56)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.236 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.466 explain |
SELECT * FROM `documents` WHERE (`category_id` = 56) ORDER BY `priority` DESC
|
24 | ||||||||||||||||||||||||||||||||||||||||
0.321 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Documents') AND (`action` = 'default') AND (`url_id` = 56)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.275 explain |
SELECT `id`, `action`, `presenter`, `url_id`
FROM `router`
WHERE (`url` = 'hrad-zlenice-v-mediich')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.349 explain |
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` FROM `categories` WHERE (`id` = 56)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.245 explain |
SELECT `id`, `lft`, `rgt`, `name` FROM `categories` WHERE (`lft` <= 31) AND (`rgt` >= 32) AND (`depth` = 1)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.511 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.589 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.267 explain |
SELECT * FROM `banners` WHERE (`id` IN (4, 3))
|
2 | ||||||||||||||||||||||||||||||||||||||||
0.497 explain |
SELECT `id`, `hpimg`, `anotationHeading`, `anotationHeading2` FROM `articles` WHERE (`public` = 1) AND (`vip` = 0) ORDER BY RAND() LIMIT 4
|
4 | ||||||||||||||||||||||||||||||||||||||||
0.266 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 38)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.245 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 38)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.395 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 16)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.300 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 35)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.293 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 15)
|
1 | ||||||||||||||||||||||||||||||||||||||||
2.322 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.334 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 12)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.290 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 32)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.279 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 29)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.271 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 19)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.309 explain |
SELECT `id`, `img`, `name`, `start` FROM `calendar` WHERE (DATE(`start`) >= DATE(NOW())) AND (`public` = 1) ORDER BY `start` LIMIT 10
|
0 |
http://www.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