Novinky

  • 25.04.2023 Bad Policisté zjistili 2800 přestupků během akce, při které se zaměřili na dodržování rychlosti.

  • 23.04.2023 Good Soud v USA rozhodl, že autopilot automobilky Tesla při nehodě v roce 2019 neselhal.

  • 14.02.2023 Bad Ve věku 97 let zemřel čestný předseda společnosti Toyota Motor Corporation Dr.Soichiro Toyoda, který byl synem zakladatele společnosti.

  • 25.04.2023 Bad Policisté zjistili 2800 přestupků během akce, při které se zaměřili na dodržování rychlosti.

  • 23.04.2023 Good Soud v USA rozhodl, že autopilot automobilky Tesla při nehodě v roce 2019 neselhal.

Facebook Instagram

Aktuální zpravodajství

Aktuality

Představení

Testy

Trendy

Lifestyle

Osobnosti

Cestování

Poradna

Historie

Užitkové vozy

Příslušenství

Motorsport

Formule

 
 

System info

Execution time270.6 ms
Peak of allocated memory6.70 MB
Included files210
Classes + interfaces + traits375 + 49 + 0
Your IP18.217.134.107
Server IP217.198.122.198
PHP 5.6.40-77+0~20240606.85+debian10~1.gbpd4d5eb
Tracy2.3.4
ServerApache/2.4.59 (Debian)
Nette Framework 2.3.5 (released on 2015-08-23)
¤ ×

Homepage:default

https://www.autonoviny.cz/?page=7

Matched? Class Mask Defaults Module Request
no Route clanek[/<id>][-<value>][/<do=comments-react>] presenter = Articles
action = detail
do = comments-react
value = 
NULL
id = 
NULL
no Route clanky/sekce[/<value>] presenter = Articles
action = section
value = 
NULL
no Route rubrika[/<value>] presenter = Articles
action = part
value = 
NULL
no Route pg/[<value .+>] presenter = Pages
action = file
value = 
NULL
no Route page/[<value .+>] presenter = Pages
action = file
value = 
NULL
no Route autonoviny/index<? \.html?|\.php|> presenter = Articles
action = redirect
no Route redir/index<? \.html?|\.php|> presenter = Articles
action = redirect
no Route sekce presenter = Articles
action = sections
no Route rubriky presenter = Articles
action = parts
no Route hledat presenter = Articles
action = find
yes Route [<value>/] ? page=<articles-visualPaginator-page>&do=<articles-visualPaginator-showPage> presenter = Homepage
action = default
value = 
NULL
Homepage:default
value = 
NULL
articles-visualPaginator-page = 7
may Route [<value>/] presenter = Homepage
action = default
value = 
NULL
Homepage:default
value = 
NULL
page = 7

App\Presenters\HomepagePresenter::actionDefault() in .../app/presenters/HomepagePresenter.php:19

¤ ×

Queries: 46, time: 113.351 ms, default

Time msSQL QueryRows
0.167
explain 
SELECT * 
FROM `formule_menu` 
WHERE (`poradi` != 0) AND (`web` = 'autonoviny') 
ORDER BY `poradi`
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_menu ref web web 50 const 16 Using index condition; Using where; Using filesort
.../app/presenters/BasePresenter.php:50 		15
0.455
explain 
SELECT fotka,datum,nadpis,url 
FROM formule_clanky JOIN formule_topbanners ON formule_topbanners.id_clanku=formule_clanky.id 
ORDER BY datum 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_topbanners index clanky clanky 4 4 Using index; Using temporary; Using filesort
1 SIMPLE formule_clanky eq_ref PRIMARY PRIMARY 4 formule.formule_topbanners.id_clanku 1 Using index condition
.../app/components/News/News.php:17 		4
0.120
explain 
SELECT `id`, `datum`, `sipka`, `novinka` 
FROM `formule_novinky` 
WHERE (`web` = 'autonoviny') 
ORDER BY `datum` DESC 
LIMIT 3
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_novinky ref web web 50 const 639 Using index condition; Using where; Using filesort
.../temp/cache/latte/app-components-BreakingNews-breakingNews-latte-Templated71ccc46b6971ba17f0d18555bf5c6b5.php:24 		3
9.747
explain 
SELECT `id` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`topstory` = 1) 
ORDER BY `datum` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky index_merge topstory,web,platnost topstory,web 1,50 137 Using intersect(topstory,web); Using where; Using filesort
.../app/components/Articles/Articles.php:114 		511
19.975
explain 
SELECT `id` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`semitopstory` = 1) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky index_merge web,semitopstory,platnost semitopstory,web 1,50 78 Using intersect(semitopstory,web); Using where; Using filesort
.../app/components/Articles/Articles.php:115 		4
21.425
explain 
SELECT `id` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`datum` >= '2023-04-10 23:43:57') AND (`id` <> 46340) AND (`id`
NOT IN (46340, 47601, 46422, 46425)) 
ORDER BY `datum` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky range PRIMARY,datum,web,platnost datum 6 1906 Using where
2 MATERIALIZED formule_clanky_dalsiweby index PRIMARY PRIMARY 54 852 Using where; Using index
.../app/components/Articles/Articles.php:138 		124
16.961
explain 
SELECT `id` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`datum` >= '2023-04-10 23:43:57') AND (`id` <> 46340) AND (`id`
NOT IN (46340, 47601, 46422, 46425)) 
ORDER BY `datum` DESC 
LIMIT 20 
OFFSET 120
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky range PRIMARY,datum,web,platnost datum 6 1906 Using where
2 MATERIALIZED formule_clanky_dalsiweby index PRIMARY PRIMARY 54 852 Using where; Using index
.../temp/cache/latte/autonoviny-app-components-Articles-articles-latte-Template5c57c88e0f29c0cca6bb8653e5fd9a81.php:24 		4
0.937
explain 
SELECT * 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`datum` >= '2023-04-10 23:43:57') AND (`id` <> 46340) AND (`id`
NOT IN (46340, 47601, 46422, 46425)) AND (`formule_clanky`.`id` IN (46327, 46324, 46323, 46321)) 
ORDER BY `datum` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky range PRIMARY,datum,web,platnost PRIMARY 4 4 Using index condition; Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../temp/cache/latte/autonoviny-app-components-Articles-articles-latte-Template5c57c88e0f29c0cca6bb8653e5fd9a81.php:51 		4
0.091
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`web` = 'autonoviny')
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce ref web web 50 const 15 Using index condition
.../temp/cache/latte/autonoviny-app-components-Articles-articles-latte-Template5c57c88e0f29c0cca6bb8653e5fd9a81.php:62 		15
0.082
explain 
SELECT `id` 
FROM `formule_sekce` 
WHERE (`web` = 'autonoviny') AND (`position` != 0) 
ORDER BY `position` ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce ref web web 50 const 15 Using index condition; Using where; Using filesort
.../temp/cache/latte/autonoviny-app-templates-Homepage-default-latte-Template020da8e73253bbd60a291d09f2816160.php:79 		12
0.053
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 101)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
14.608
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 101) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky index_merge web,id_sekce,platnost id_sekce,web 4,50 74 Using intersect(id_sekce,web); Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
2.000
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 102)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
3.614
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 102) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky index_merge web,id_sekce,platnost id_sekce,web 4,50 19 Using intersect(id_sekce,web); Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
5.708
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 103)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
1.230
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 103) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 53 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.093
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 104)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
3.717
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 104) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky index_merge web,id_sekce,platnost id_sekce,web 4,50 16 Using intersect(id_sekce,web); Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.113
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 105)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
1.139
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 105) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 216 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.097
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 106)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
0.557
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 106) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 62 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.091
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 107)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
0.714
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 107) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 107 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.076
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 108)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
0.981
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 108) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 96 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.081
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 109)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
1.307
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 109) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 133 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.076
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 110)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
0.577
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 110) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 60 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.187
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 111)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
0.522
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 111) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref web,id_sekce,platnost id_sekce 4 const 65 Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.093
explain 
SELECT `id`, `url`, `nazev` 
FROM `formule_sekce` 
WHERE (`formule_sekce`.`id` = 114)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_sekce const PRIMARY PRIMARY 1 const 1
.../app/model/Section.php:21 		1
4.145
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny') AND (`id_sekce` = 114) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky index_merge web,id_sekce,platnost id_sekce,web 4,50 23 Using intersect(id_sekce,web); Using where; Using filesort
.../temp/cache/latte/app-components-SliderArticles-slider-latte-Template39158d3a4e94723a48f57704114af668.php:30 		4
0.367
explain 
SELECT * 
FROM `formule_odpocet` 
WHERE (`datum_konani` >= DATE_SUB(NOW(), INTERVAL 2 HOUR)) 
ORDER BY `datum_konani`
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_odpocet ALL 14 Using where; Using filesort
.../app/components/Countdown/Countdown.php:48 		0
0.094
explain 
SELECT `id`, `fotka`, `url`, `nadpis` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`id_rubrika` = 66) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref web,id_rubrika,platnost id_rubrika 4 const 12 Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../app/components/Articles/Articles.php:83 		4
0.098
explain 
SELECT `id`, `fotka`, `url`, `nadpis` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`id_rubrika` = 58) 
ORDER BY `ts` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref web,id_rubrika,platnost id_rubrika 4 const 277 Using where; Using filesort
2 MATERIALIZED formule_clanky_dalsiweby index PRIMARY PRIMARY 54 852 Using where; Using index
.../app/components/Articles/Articles.php:83 		4
0.108
explain 
SELECT `id`, `fotka`, `url`, `nadpis` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`id_rubrika` = 60) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref web,id_rubrika,platnost id_rubrika 4 const 35 Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../app/components/Articles/Articles.php:83 		4
0.114
explain 
SELECT `id`, `separate`, `odpovede`, `vysledky`, `otazka` 
FROM `formule_ankety` 
WHERE (`web` = 'autonoviny') 
ORDER BY `id` DESC 
LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_ankety ref web web 50 const 11 Using index condition; Using where; Using filesort
.../app/model/Poll.php:17 		1
0.135
explain 
SELECT `id`, `datum` 
FROM `formule_ankety_log` 
WHERE (`ip` = '18.217.134.107') AND (`anketa_id`)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_ankety_log ref ip ip 17 const 5 Using index condition; Using where
.../app/model/Poll.php:21 		1
0.131
explain 
SELECT `id`, `fotka`, `url`, `nadpis` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`id_rubrika` = 68) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref web,id_rubrika,platnost id_rubrika 4 const 159 Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../app/components/Articles/Articles.php:83 		4
0.130
explain 
SELECT `id`, `fotka`, `url`, `nadpis` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`id_rubrika` = 67) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref web,id_rubrika,platnost id_rubrika 4 const 44 Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../app/components/Articles/Articles.php:83 		4
0.126
explain 
SELECT `id`, `fotka`, `url`, `nadpis` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`id_rubrika` = 57) 
ORDER BY `datum` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref web,id_rubrika,platnost id_rubrika 4 const 6 Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../app/components/Articles/Articles.php:83 		4
0.094
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`datum` > '2025-03-10 23:43:58') 
ORDER BY `counter` DESC 
LIMIT 4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky range datum,web,platnost datum 6 90 Using index condition; Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../temp/cache/latte/autonoviny-app-components-Articles-top-latte-Template25aa3e9b1e0ce824f55470a7ead134db.php:28 		4
0.122
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) 
ORDER BY `datum` DESC 
LIMIT 3
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky index web,platnost datum 6 3 Using where
2 MATERIALIZED formule_clanky_dalsiweby index PRIMARY PRIMARY 54 852 Using where; Using index
.../temp/cache/latte/autonoviny-app-components-Articles-news-latte-Templated9a67368c469b33521fd9ead29bdd394.php:22 		3
0.093
explain 
SELECT `id`, `url`, `nadpis`, `fotka`, `datum` 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`datum` > '2025-03-10 23:43:58') 
ORDER BY `counter` DESC 
LIMIT 3
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky range datum,web,platnost datum 6 90 Using index condition; Using where; Using filesort
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../temp/cache/latte/autonoviny-app-components-Articles-mostRead-latte-Template3baca11b87e33b4b82be24c7442a7118.php:22 		3
¤ ×

Unlogged

no identity

¤ ×