Time ms | SQL Query | Rows |
0.386 explain
|
SELECT `id`, `action`, `presenter`, `url_id`
FROM `router`
WHERE (`url` = 'soucasnost')
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
const |
url |
url |
767 |
const |
1 |
|
/var/www/hosting/zlenice.cz/www/index.php:5 |
1 |
0.331 explain
|
SELECT `name`, `value`
FROM `settings`
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
settings |
ALL |
|
|
|
|
7 |
|
.../app/FrontModule/presenters/BasePresenter.php:48 |
7 |
0.282 explain
|
SELECT `id`, `link`, `text`
FROM `footer_links`
ORDER BY `priority` DESC
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
footer_links |
ALL |
|
|
|
|
14 |
Using filesort |
.../app/FrontModule/presenters/BasePresenter.php:54 |
14 |
0.245 explain
|
SELECT `id`, `element`, `val`
FROM `css`
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
css |
ALL |
|
|
|
|
22 |
|
.../app/FrontModule/presenters/BasePresenter.php:62 |
22 |
0.453 explain
|
SELECT `articles_categories_rel`.`id`, `articles_categories_rel`.`article_id`
FROM `articles_categories_rel`
LEFT JOIN `articles` AS `article` ON `articles_categories_rel`.`article_id` = `article`.`id`
WHERE (`category_id` = 23) AND (`article`.`public` = 1) AND (`vip` = 0)
ORDER BY `article`.`priority` DESC, `article`.`id` DESC
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
articles_categories_rel |
ref |
article_id,category_id |
category_id |
4 |
const |
2 |
Using temporary; Using filesort |
1 |
SIMPLE |
article |
eq_ref |
PRIMARY,public_vip |
PRIMARY |
4 |
zlenice001.articles_categories_rel.article_id |
1 |
Using where |
.../FrontModule/presenters/ArticleListPresenter.php:35 |
1 |
0.251 explain
|
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name`
FROM `categories`
WHERE (`id` = 23)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
categories |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
.../FrontModule/presenters/ArticleListPresenter.php:36 |
1 |
0.326 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArticleList') AND (`action` = 'default') AND (`url_id` = 23)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/www/index.php:5 |
1 |
0.316 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'ArticleList') AND (`action` = 'default') AND (`url_id` = 23)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-templates-main-layout-latte-5593e9185dd54e30200b64234aada81b.php:194 |
1 |
0.276 explain
|
SELECT `id`, `action`, `presenter`, `url_id`
FROM `router`
WHERE (`url` = 'soucasnost')
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
const |
url |
url |
767 |
const |
1 |
|
.../FrontModule/components/Breadcrumb/Breadcrumb.php:70 |
1 |
0.261 explain
|
SELECT `id`, `vip`, `text`, `descript`, `kw`, `title`, `heading`, `lft`, `rgt`, `name`
FROM `categories`
WHERE (`id` = 23)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
categories |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
.../FrontModule/components/Breadcrumb/Breadcrumb.php:86 |
1 |
0.263 explain
|
SELECT `id`, `lft`, `rgt`, `name`
FROM `categories`
WHERE (`lft` <= 22) AND (`rgt` >= 33) AND (`depth` = 1)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
categories |
ALL |
|
|
|
|
22 |
Using where |
.../components/Breadcrumb/CategoriesRepository.php:43 |
1 |
0.434 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
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
categories |
ALL |
PRIMARY,vip |
|
|
|
22 |
Using where |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
category_url_id |
5 |
zlenice001.categories.id |
1 |
Using where |
.../components/Breadcrumb/CategoriesRepository.php:33 |
5 |
0.430 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` = 'soucasnost')
ORDER BY RAND()
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
const |
PRIMARY,url |
url |
767 |
const |
1 |
Using index; Using temporary; Using filesort |
1 |
SIMPLE |
banners_route_rel |
ref |
banners_id,router_id |
router_id |
4 |
const |
3 |
|
1 |
SIMPLE |
banners |
ALL |
PRIMARY |
|
|
|
3 |
Using where; Using join buffer (flat, BNL join) |
.../app/FrontModule/components/Banner/Banner.php:51 |
3 |
0.250 explain
|
SELECT *
FROM `banners`
WHERE (`id` IN (4, 3, 6))
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
banners |
ALL |
PRIMARY |
|
|
|
3 |
Using where |
/var/www/hosting/zlenice.cz/temp/cache/latte/cz-app-FrontModule-components-Banner-template-latte-556b5c82c781c1769cf50a54bdecb8af.php:17 |
3 |
0.458 explain
|
SELECT `id`, `hpimg`, `anotationHeading`, `anotationHeading2`
FROM `articles`
WHERE (`public` = 1) AND (`vip` = 0)
ORDER BY RAND()
LIMIT 4
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
articles |
range |
public_vip |
public_vip |
2 |
|
29 |
Using index condition; Using temporary; Using filesort |
.../components/ArticleTips/ArticleRepository.php:22 |
4 |
0.298 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 43)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:26 |
1 |
0.283 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 43)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:31 |
1 |
0.284 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 41)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:38 |
1 |
0.284 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 19)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:38 |
1 |
0.285 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 29)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-ArticleTips-template-latte-36c7fa0e7685075cbf8a39ff5d0f95c5.php:38 |
1 |
1.869 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
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
galery |
ref |
PRIMARY,public_vip |
public_vip |
5 |
const,const |
24 |
Using index; Using temporary; Using filesort |
1 |
SIMPLE |
galeries_images |
ref |
galery_id |
galery_id |
4 |
zlenice001.galery.id |
18 |
|
.../components/GaleryTips/GaleriesImagesRepository.php:25 |
4 |
0.301 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 31)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25 |
1 |
0.292 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 19)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25 |
1 |
0.293 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 37)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25 |
1 |
0.285 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 15)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
presenter_action_url_id |
1539 |
const,const,const |
1 |
Using index condition |
/var/www/hosting/zlenice.cz/temp/cache/latte/FrontModule-components-GaleryTips-template-latte-54a77ad13b13003d8cd9c48372fc7898.php:25 |
1 |
0.352 explain
|
SELECT `id`, `img`, `name`, `start`
FROM `calendar`
WHERE (DATE(`start`) >= DATE(NOW())) AND (`public` = 1)
ORDER BY `start`
LIMIT 10
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
calendar |
ALL |
|
|
|
|
21 |
Using where; Using filesort |
.../components/Calendar/CalendarRepository.php:18 |
0 |
0.302 explain
|
SELECT *
FROM `articles`
WHERE (`id` IN (45))
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
articles |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
/var/www/hosting/zlenice.cz/temp/cache/latte/app-FrontModule-templates-ArticleList-default-latte-c8dc2443772467834f20b72805bed13a.php:52 |
1 |
0.306 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
category_url_id |
5 |
const |
1 |
Using where |
/var/www/hosting/zlenice.cz/temp/cache/latte/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:25 |
1 |
0.295 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 45)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
router |
ref |
presenter_action_url_id,category_url_id |
category_url_id |
5 |
const |
1 |
Using where |
/var/www/hosting/zlenice.cz/temp/cache/latte/app-FrontModule-templates-ArticleList-imglft-latte-3b256f934a54d2814309b23feb064728.php:32 |
1 |