Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.386 explain |
SELECT `id`, `action`, `presenter`, `url_id` FROM `router` WHERE (`url` = 'archeologie')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.242 explain |
SELECT `name`, `value` FROM `settings`
|
7 | ||||||||||||||||||||||||||||||||||||||||
0.248 explain |
SELECT `id`, `link`, `text` FROM `footer_links` ORDER BY `priority` DESC
|
14 | ||||||||||||||||||||||||||||||||||||||||
0.208 explain |
SELECT `id`, `element`, `val` FROM `css`
|
22 | ||||||||||||||||||||||||||||||||||||||||
0.224 explain |
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` FROM `categories` WHERE (`id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
ERROR | SELECT `id`, `link`, `name`, `file`, `file_extension`, `data`-`date` FROM `documents` WHERE (`category_id` = 13) ORDER BY `priority` DESC.../presenters/ArchaeologicalArchivePresenter.php:27 |
|||||||||||||||||||||||||||||||||||||||||
0.391 explain |
SELECT * FROM `documents` WHERE (`category_id` = 13) ORDER BY `priority` DESC
|
13 | ||||||||||||||||||||||||||||||||||||||||
0.374 explain |
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArchaeologicalArchive') AND (`action` = 'default') AND (`url_id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.307 explain |
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArchaeologicalArchive') AND (`action` = 'default') AND (`url_id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.274 explain |
SELECT `id`, `action`, `presenter`, `url_id` FROM `router` WHERE (`url` = 'archeologie')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.251 explain |
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` FROM `categories` WHERE (`id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.276 explain |
SELECT `id`, `lft`, `rgt`, `name` FROM `categories` WHERE (`lft` <= 4) AND (`rgt` >= 7) AND (`depth` = 1)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.414 explain |
SELECT categories.*, router.url FROM categories JOIN router ON router.url_id = categories.id WHERE lft > 4 AND rgt < 7 AND presenter != "article" AND presenter != "galery" AND vip = 0
|
2 | ||||||||||||||||||||||||||||||||||||||||
0.437 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` = 'archeologie') ORDER BY RAND()
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.243 explain |
SELECT * FROM `banners` WHERE (`id` IN (4))
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.407 explain |
SELECT `id`, `hpimg`, `anotationHeading`, `anotationHeading2` FROM `articles` WHERE (`public` = 1) AND (`vip` = 0) ORDER BY RAND() LIMIT 4
|
4 | ||||||||||||||||||||||||||||||||||||||||
0.294 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 40)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.267 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 40)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.243 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.229 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 51)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.306 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 50)
|
1 | ||||||||||||||||||||||||||||||||||||||||
1.949 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.343 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 16)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.310 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 14)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.236 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 14)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.224 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 17)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.299 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/archeologie
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:archaeologicalArchive:default |
FrontModule\ArchaeologicalArchivePresenter::actionDefault() in .../presenters/ArchaeologicalArchivePresenter.php:24