Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.428 explain |
SELECT `id`, `action`, `presenter`, `url_id` FROM `router` WHERE (`url` = 'archeologie')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.289 explain |
SELECT `name`, `value` FROM `settings`
|
7 | ||||||||||||||||||||||||||||||||||||||||
0.295 explain |
SELECT `id`, `link`, `text` FROM `footer_links` ORDER BY `priority` DESC
|
14 | ||||||||||||||||||||||||||||||||||||||||
0.254 explain |
SELECT `id`, `element`, `val` FROM `css`
|
22 | ||||||||||||||||||||||||||||||||||||||||
0.268 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.409 explain |
SELECT * FROM `documents` WHERE (`category_id` = 13) ORDER BY `priority` DESC
|
13 | ||||||||||||||||||||||||||||||||||||||||
0.331 explain |
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArchaeologicalArchive') AND (`action` = 'default') AND (`url_id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.352 explain |
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArchaeologicalArchive') AND (`action` = 'default') AND (`url_id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.275 explain |
SELECT `id`, `action`, `presenter`, `url_id` FROM `router` WHERE (`url` = 'archeologie')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.246 explain |
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` FROM `categories` WHERE (`id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.255 explain |
SELECT `id`, `lft`, `rgt`, `name` FROM `categories` WHERE (`lft` <= 4) AND (`rgt` >= 7) AND (`depth` = 1)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.479 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.419 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.215 explain |
SELECT * FROM `banners` WHERE (`id` IN (4))
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.517 explain |
SELECT `id`, `hpimg`, `anotationHeading`, `anotationHeading2` FROM `articles` WHERE (`public` = 1) AND (`vip` = 0) ORDER BY RAND() LIMIT 4
|
4 | ||||||||||||||||||||||||||||||||||||||||
0.280 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 18)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.304 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 18)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.356 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 36)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.297 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 17)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.316 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 29)
|
1 | ||||||||||||||||||||||||||||||||||||||||
1.970 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` = 32)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.358 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 29)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.331 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 22)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.299 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 17)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.453 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