Time ms | SQL Query | Rows |
1.728 |
SELECT `pages_modules`.`id`
FROM `pages_modules`
LEFT JOIN `pages` ON `pages_modules`.`pages_id` = `pages`.`id`
WHERE (`modules_id` = 3) AND (`pages_modules`.`position` = 1) AND (`pages`.`highlight` = 0)
.../www/clients/client3/web46/web/app/bootstrap.php:52 |
0 |
0.764 |
SELECT `id`
FROM `languages`
.../www/clients/client3/web46/web/app/bootstrap.php:58 |
0 |
1.502 |
SELECT DISTINCT `locale` as locale
FROM `translations`
.../cache/Nette.Configurator/Container_f4c07d7b75.php:3289 |
1 |
0.746 |
SELECT `id`
FROM `settings`
.../client3/web46/web/app/forms/VoucherFormFactory.php:43 |
1 |
0.270 |
SELECT `id`
FROM `settings`
.../client3/web46/web/app/forms/BookingFormFactory.php:43 |
1 |
0.220 |
SELECT `id`
FROM `settings`
.../client3/web46/web/app/forms/ContactFormFactory.php:43 |
1 |
0.391 |
SELECT `id`, `title_editors`, `webmasterToolsVerification`, `analyticsUID`, `analyticsURL`,
`addthisActive`, `smartsuppActive`, `title_articles`
FROM `settings`
.../web/app/modules/Base/presenters/BasePresenter.php:73 |
1 |
0.340 |
SELECT `id`
FROM `pages`
WHERE (`url` = 'novinky' OR `url` = 'novinky')
.../web/app/modules/Front/presenters/PagePresenter.php:150 |
1 |
0.412 |
SELECT *, `title` AS `title`, `description` AS `description`, `keywords` AS `keywords`
FROM `pages`
WHERE (`url` = 'novinky' OR `url` = 'novinky') AND (`pid` = 0)
ORDER BY `pid` ASC
.../web/app/modules/Front/presenters/PagePresenter.php:167 |
1 |
0.278 |
SELECT `id`
FROM `pages`
WHERE (`pid` = 8)
ORDER BY `position` ASC
.../web/app/modules/Front/presenters/PagePresenter.php:116 |
0 |
0.845 |
SELECT `id`, `visibility`
FROM `articles`
WHERE (`id` = '62' OR `pid` = '62')
ORDER BY `created` DESC
.../app/modules/Front/presenters/ArticlesPresenter.php:101 |
1 |
0.207 |
SELECT `id`
FROM `pages`
WHERE (`url` = 'novinky' OR `url` = 'novinky')
.../web/app/modules/Front/presenters/PagePresenter.php:150 |
1 |
11.110 |
SELECT `key` AS `key`, `locale` AS `locale`, `message` AS `message`
FROM `translations`
WHERE (`locale` = 'cs')
.../web/app/modules/Front/presenters/PagePresenter.php:126 |
1026 |
0.928 |
SELECT `updated_at` AS `updated_at`
FROM `translations`
WHERE (`locale` = 'cs')
ORDER BY `updated_at` DESC
LIMIT 1
.../web/app/modules/Front/presenters/PagePresenter.php:126 |
1 |
0.230 |
SELECT `id`
FROM `languages`
WHERE (`highlight` = 1)
.../client3/web46/web/app/components/MenuControl.php:115 |
0 |
0.226 |
SELECT `id`
FROM `pages_modules`
WHERE (`modules_id` = 3) AND (`pages_id` != 1)
.../client3/web46/web/app/components/MenuControl.php:115 |
0 |
0.416 |
SELECT `id`, `highlight`, `url`, `link`, `name`, `pid`
FROM `pages`
WHERE (`pid` = 0) AND (`visibility` = 1) AND (`menu` = 0 OR `menu` = 0)
ORDER BY `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-menu-latte-Template611cca1ae02bc0e0eb5a57cf8a921a36.php:76 |
5 |
0.253 |
SELECT `id`, `modules_id`
FROM `pages_modules`
WHERE (`pages_id` = 1)
.../client3/web46/web/app/components/MenuControl.php:77 |
1 |
0.330 |
SELECT `id`
FROM `pages`
WHERE (`pid` = 1) AND (`visibility` = 1) AND (`menu` = 0 OR `menu` = 0)
ORDER BY `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-menu-latte-Template611cca1ae02bc0e0eb5a57cf8a921a36.php:47 |
0 |
0.269 |
SELECT `id`, `modules_id`
FROM `pages_modules`
WHERE (`pages_id` = 8)
.../client3/web46/web/app/components/MenuControl.php:77 |
1 |
0.320 |
SELECT `id`
FROM `pages`
WHERE (`pid` = 8) AND (`visibility` = 1) AND (`menu` = 0 OR `menu` = 0)
ORDER BY `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-menu-latte-Template611cca1ae02bc0e0eb5a57cf8a921a36.php:47 |
0 |
0.250 |
SELECT `id`, `modules_id`
FROM `pages_modules`
WHERE (`pages_id` = 2)
.../client3/web46/web/app/components/MenuControl.php:77 |
1 |
0.295 |
SELECT `id`
FROM `pages`
WHERE (`pid` = 2) AND (`visibility` = 1) AND (`menu` = 0 OR `menu` = 0)
ORDER BY `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-menu-latte-Template611cca1ae02bc0e0eb5a57cf8a921a36.php:47 |
0 |
0.260 |
SELECT `id`, `modules_id`
FROM `pages_modules`
WHERE (`pages_id` = 5)
.../client3/web46/web/app/components/MenuControl.php:77 |
1 |
0.294 |
SELECT `id`
FROM `pages`
WHERE (`pid` = 5) AND (`visibility` = 1) AND (`menu` = 0 OR `menu` = 0)
ORDER BY `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-menu-latte-Template611cca1ae02bc0e0eb5a57cf8a921a36.php:47 |
0 |
0.262 |
SELECT `id`, `modules_id`
FROM `pages_modules`
WHERE (`pages_id` = 7)
.../client3/web46/web/app/components/MenuControl.php:77 |
1 |
0.287 |
SELECT `id`
FROM `pages`
WHERE (`pid` = 7) AND (`visibility` = 1) AND (`menu` = 0 OR `menu` = 0)
ORDER BY `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-menu-latte-Template611cca1ae02bc0e0eb5a57cf8a921a36.php:47 |
0 |
0.945 |
SELECT `id`, `articles_id`
FROM `articles_pages`
.../client3/web46/web/app/components/SliderControl.php:58 |
27 |
0.313 |
SELECT `id`, `articles_id`
FROM `articles_pages`
WHERE (`aid` = '62')
.../client3/web46/web/app/components/SliderControl.php:76 |
0 |
1.425 |
SELECT `id`, `dimension`
FROM `sections_thumbs`
WHERE (`sections_id` = 2) AND (`place` IN (0, 0))
ORDER BY `place` DESC
.../client3/web46/web/app/components/SliderControl.php:115 |
1 |
0.482 |
SELECT `id`, `galleries_id`, `link`
FROM `articles`
WHERE (`sections_id` = 2) AND (`visibility` = 1) AND (`id` NOT IN (1, 12, 13, 14, 15, 16, 17, 18,
19, 41, 64, 67, 70, 73, 76, 78, 82, 84, 85, 86, 95, 101, 102, 103, 109, 110, 148) OR `id` IS NULL
AND FALSE)
ORDER BY `highlight` DESC, `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-slider-latte-Templatefc147002f5aaa8156053a83ef9b04346.php:20 |
2 |
1.160 |
SELECT `id`, `name`, `title`
FROM `galleries_images`
WHERE (`galleries_id` = 169) AND (`visibility` = 1)
ORDER BY `highlight` DESC, `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-slider-latte-Templatefc147002f5aaa8156053a83ef9b04346.php:26 |
0 |
0.523 |
SELECT `id`, `name`, `title`
FROM `galleries_images`
WHERE (`galleries_id` = 177) AND (`visibility` = 1)
ORDER BY `highlight` DESC, `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/web46-web-app-components-templates-slider-latte-Templatefc147002f5aaa8156053a83ef9b04346.php:26 |
0 |
0.333 |
SELECT `id`, `visibility`, `name`
FROM `pages`
WHERE (`url` = 'novinky') AND (`pid` = 0)
.../web46/web/app/components/BreadcrumbControl.php:106 |
1 |
0.315 |
SELECT `id`, `modules_id`, `sections_id`, `highlight`, `order`, `direction`, `lmt`, `layout`,
`cols`, `menu`, `paginator`, `heading_level`, `contact_form`, `detail`
FROM `pages_modules`
WHERE (`pages_id` = 8) AND (`position` = 1)
.../web/app/modules/Front/presenters/PagePresenter.php:203 |
1 |
0.265 |
SELECT `id`
FROM `articles`
WHERE (`articles`.`id` = '62')
.../app/modules/Front/presenters/ArticlesPresenter.php:225 |
1 |
1.057 |
SELECT `id`, `articles_id`
FROM `articles_categories`
WHERE (`articles_categories`.`articles_id` IN (62))
.../app/modules/Front/presenters/ArticlesPresenter.php:225 |
0 |
0.557 |
SELECT `id`, `visibility`, `sections_id`, `galleries_id`, `filestores_id`
FROM `articles`
WHERE (`id` = '62' OR `pid` = '62')
ORDER BY `created` DESC
.../app/modules/Front/presenters/ArticlesPresenter.php:101 |
1 |
0.249 |
SELECT `id`
FROM `pages`
WHERE (`url` = 'novinky' OR `url` = 'novinky')
.../web/app/modules/Front/presenters/PagePresenter.php:150 |
1 |
0.682 |
SELECT `id`, `pages_modules_id`
FROM `pages_modules_categories`
WHERE (`pages_modules_categories`.`pages_modules_id` IN (8))
.../app/modules/Front/presenters/ArticlesPresenter.php:46 |
0 |
0.766 |
SELECT `id`
FROM `editors`
WHERE (`pages_modules_id` = 8)
.../app/modules/Front/presenters/ArticlesPresenter.php:266 |
1 |
0.799 |
SELECT `id`, `visName`, `date`, `description`, `text`, `gallery`, `files`, `posts`
FROM `sections`
WHERE (`id` IN (5))
/var/www/clients/client3/web46/web/temp/cache/latte/presenters-templates-Modules-Module2-detail1-latte-Templateebef51d2eced29d445d0f324cc2f64cc.php:34 |
1 |
0.339 |
SELECT `id`, `dimension`
FROM `sections_thumbs`
WHERE (`sections_id` = 5) AND (`place` IN (0, 2))
ORDER BY `place` DESC
/var/www/clients/client3/web46/web/temp/cache/latte/presenters-templates-Modules-Module2-detail1-latte-Templateebef51d2eced29d445d0f324cc2f64cc.php:61 |
1 |
0.507 |
SELECT `id`, `galleries_id`, `name`, `title`
FROM `galleries_images`
WHERE (`galleries_id` = 72) AND (`visibility` = 1) AND (`position` != 0)
ORDER BY `highlight` DESC, `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/presenters-templates-Modules-Module2-detail1-latte-Templateebef51d2eced29d445d0f324cc2f64cc.php:63 |
0 |
0.791 |
SELECT `id`, `paginator`
FROM `galleries`
WHERE (`id` IN (72))
/var/www/clients/client3/web46/web/temp/cache/latte/presenters-templates-Modules-Module2-detail1-latte-Templateebef51d2eced29d445d0f324cc2f64cc.php:80 |
1 |
0.709 |
SELECT `id`
FROM `filestores`
WHERE (`id` IN (71))
.../app/modules/Front/presenters/ArticlesPresenter.php:187 |
1 |
0.709 |
SELECT `id`, `filestores_id`, `name`, `title`
FROM `filestores_files`
WHERE (`filestores_files`.`filestores_id` IN (71)) AND (`visibility` = 1)
ORDER BY `filestores_files`.`filestores_id`, `highlight` DESC, `position` ASC
/var/www/clients/client3/web46/web/temp/cache/latte/presenters-templates-Modules-Module2-detail1-latte-Templateebef51d2eced29d445d0f324cc2f64cc.php:86 |
0 |