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

Cestování

Formule

 
 

System info

Execution time916.6 ms
Peak of allocated memory5.68 MB
Included files208
Classes + interfaces + traits373 + 49 + 0
Your IP18.119.156.220
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/cestování/?poll-key=4

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 = cestování
poll-key = 4
may Route [<value>/] presenter = Homepage
action = default
value = 
NULL
Homepage:default
value = cestování
poll-key = 4

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

¤ ×

Queries: 20, time: 768.539 ms, default

Time msSQL QueryRows
3.259
explain 
SELECT `id`, `nazev` 
FROM `formule_sekce` 
WHERE (`web` = 'autonoviny') AND (`url` = 'cestování')
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
.../app/presenters/HomepagePresenter.php:22 		1
1.115
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.536
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.494
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
2.611
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
728.988
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 (`id_sekce` = 107) AND (`datum` >= '2023-04-11 01:36:56') 
ORDER BY `datum` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref datum,web,id_sekce,platnost id_sekce 4 const 107 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:138 		2
2.154
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 (`id_sekce` = 107) AND (`datum` >= '2023-04-11 01:36:56') 
ORDER BY `datum` DESC 
LIMIT 24
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky ref datum,web,id_sekce,platnost id_sekce 4 const 107 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:24 		2
5.434
explain 
SELECT * 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`id_sekce` = 107) AND (`datum` >= '2023-04-11 01:36:56') AND
(`formule_clanky`.`id` IN (46833, 46420)) 
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,id_sekce,platnost PRIMARY 4 2 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 		2
4.389
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.365
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.729
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
2.353
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.750
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
3.622
explain 
SELECT `id`, `datum` 
FROM `formule_ankety_log` 
WHERE (`ip` = '18.119.156.220') 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 6 Using index condition; Using where
.../app/model/Poll.php:21 		1
1.376
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.717
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
2.241
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
3.034
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-11 01:36:57') 
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
3.179
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
1.193
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-11 01:36:57') 
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

¤ ×