Time ms | SQL Query | Rows |
0.363 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.354 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.229 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.252 explain
|
SELECT `id`, `link`, `path`
FROM `sliders`
WHERE (`type` = 'default')
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
sliders |
ALL |
|
|
|
|
3 |
Using where |
.../app/FrontModule/presenters/HomepagePresenter.php:49 |
3 |
0.418 explain
|
SELECT `id`, `mimg`, `anotationHeading`, `anotationTextHead`, `anotationText`
FROM `articles`
WHERE (`mainHomepage` = 1) AND (`public` = 1) AND (`vip` = 0)
ORDER BY `id` DESC
LIMIT 1
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
articles |
ref |
mainHomepage,public_vip |
mainHomepage |
1 |
const |
1 |
Using where |
.../app/FrontModule/presenters/HomepagePresenter.php:62 |
1 |
0.295 explain
|
SELECT `id`, `hpimg`, `name`
FROM `articles`
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
articles |
ref |
listHomepage,public_vip |
listHomepage |
1 |
const |
6 |
Using where |
.../app/FrontModule/presenters/HomepagePresenter.php:65 |
6 |
0.385 explain
|
SELECT `id`, `hpimg`, `name`
FROM `articles`
WHERE (`listHomepage` = 1) AND (`public` = 1) AND (`vip` = 0)
ORDER BY `id` DESC
LIMIT 3
OFFSET 3
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
articles |
ref |
listHomepage,public_vip |
listHomepage |
1 |
const |
6 |
Using where |
.../app/FrontModule/presenters/HomepagePresenter.php:67 |
3 |
0.401 explain
|
SELECT `id`, `anotationHeading`
FROM `articles`
WHERE (`donateHomepage` = 1) AND (`public` = 1) AND (`vip` = 0)
ORDER BY `priority` DESC
LIMIT 5
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
articles |
ref |
donateHomepage,public_vip |
donateHomepage |
1 |
const |
6 |
Using where; Using filesort |
.../app/FrontModule/presenters/HomepagePresenter.php:68 |
5 |
0.372 explain
|
SELECT `id`, `img`, `name`, `start`
FROM `calendar`
WHERE (DATE(`start`) >= DATE(NOW())) AND (`public` = 1)
ORDER BY `start`
LIMIT 5
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
calendar |
ALL |
|
|
|
|
21 |
Using where; Using filesort |
.../app/FrontModule/models/CalendarRepository.php:18 |
0 |
2.145 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 10
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 |
|
.../FrontModule/models/GaleriesImagesRepository.php:35 |
10 |
0.695 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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:68 |
1 |
0.331 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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:71 |
1 |
0.266 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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:78 |
1 |
0.323 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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:108 |
1 |
0.390 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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:111 |
1 |
0.376 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 42)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:108 |
1 |
0.330 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 42)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:111 |
1 |
0.355 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 25)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:108 |
1 |
0.420 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 25)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:111 |
1 |
0.299 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 36)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.317 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 26)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.355 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 25)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.368 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') 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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.329 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 27)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.310 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 16)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.378 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 27)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.311 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 32)
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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.321 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 22)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.280 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Galery') AND (`action` = 'default') AND (`url_id` = 16)
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-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:150 |
1 |
0.299 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 50)
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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 |
1 |
0.313 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 35)
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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 |
1 |
0.307 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') 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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 |
1 |
0.345 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 39)
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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 |
1 |
0.247 explain
|
SELECT `id`, `url`
FROM `router`
WHERE (`presenter` = 'Article') AND (`action` = 'default') AND (`url_id` = 38)
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/cz-app-FrontModule-templates-Homepage-default-latte-6138e55ef8652934515efb452e14c9d3.php:166 |
1 |