Time ms | SQL Query | Rows | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.533 explain |
SELECT `id`, `action`, `presenter`, `url_id` FROM `router` WHERE (`url` = 'archeologie')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.266 explain |
SELECT `name`, `value` FROM `settings`
|
7 | ||||||||||||||||||||||||||||||||||||||||
0.301 explain |
SELECT `id`, `link`, `text` FROM `footer_links` ORDER BY `priority` DESC
|
14 | ||||||||||||||||||||||||||||||||||||||||
0.253 explain |
SELECT `id`, `element`, `val` FROM `css`
|
22 | ||||||||||||||||||||||||||||||||||||||||
0.325 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.324 explain |
SELECT * FROM `documents` WHERE (`category_id` = 13) ORDER BY `priority` DESC
|
13 | ||||||||||||||||||||||||||||||||||||||||
0.327 explain |
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArchaeologicalArchive') AND (`action` = 'default') AND (`url_id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.363 explain |
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArchaeologicalArchive') AND (`action` = 'default') AND (`url_id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.355 explain |
SELECT `id`, `action`, `presenter`, `url_id` FROM `router` WHERE (`url` = 'archeologie')
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.281 explain |
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name` FROM `categories` WHERE (`id` = 13)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.287 explain |
SELECT `id`, `lft`, `rgt`, `name` FROM `categories` WHERE (`lft` <= 4) AND (`rgt` >= 7) AND (`depth` = 1)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.490 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.641 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.275 explain |
SELECT * FROM `banners` WHERE (`id` IN (4))
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.584 explain |
SELECT `id`, `hpimg`, `anotationHeading`, `anotationHeading2` FROM `articles` WHERE (`public` = 1) AND (`vip` = 0) ORDER BY RAND() LIMIT 4
|
4 | ||||||||||||||||||||||||||||||||||||||||
0.316 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.320 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.294 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 29)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.290 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 26)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.354 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 15)
|
1 | ||||||||||||||||||||||||||||||||||||||||
2.567 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.281 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 29)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.314 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 19)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.337 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 10)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.307 explain |
SELECT `id`, `url` FROM `router` WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 17)
|
1 | ||||||||||||||||||||||||||||||||||||||||
0.410 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/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