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

Nejlépe do šumavského hotelu

  • Marek Chvála
  • čas21.07. 2020
Nejlépe do šumavského hotelu
  • Autor Marek Chvála
  • čas21.07. 2020

Češi vybírají dovolenou podle lokality

Devět z deseti Čechů letos plánuje trávit dovolenou v tuzemsku. Nejžádanější lokalitou je Šumava, vedou pobyty v hotelech a penzionech. Vyplývá to z průzkumu iniciativy Zachraňme turismus, zpracovaného výzkumnou agenturou STEM/MARK a projektem Česko v datech.

„Nejoblíbenější formou jsou poznávací výlety. Kromě respondentů starších šedesáti let míří našinci velmi rádi také k vodě," uvedl Tomáš Odstrčil z Česka v datech.

Češi letos místo exotické ciziny objevují krásy své vlasti

Při výběru je podle 83 procent dotázaných zásadní region. Na druhém místě se umístila kvalita stravování, následovaná možnostmi aktivit a zážitků. Až za nimi najdeme v žebříčku cenu ubytování či recenze.

Po hotelech a penzionech jsou nejvíce preferovány kempy a karavany, zejména u nejmladší věkové skupiny. Naopak citelně opadl zájem o sdílené služby typu Airbnb, ubytovny či hostely.

Související články

 

Komentáře ke článku

 

System info

Execution time240.5 ms
Peak of allocated memory5.59 MB
Included files214
Classes + interfaces + traits369 + 49 + 0
Your IP3.134.111.219
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)
¤ ×

Articles:detail poll-vote!

https://www.autonoviny.cz/clanek/42165-nejlepe-do-sumavskeho-hotelu/poll-vote?poll-key=0

Matched? Class Mask Defaults Module Request
yes Route clanek[/<id>][-<value>][/<do=comments-react>] presenter = Articles
action = detail
do = comments-react
value = 
NULL
id = 
NULL
Articles:detail
id = 42165
value = nejlepe-do-sumavskeho-hotelu
do = poll-vote
poll-key = 0
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
no Route [<value>/] ? page=<articles-visualPaginator-page>&do=<articles-visualPaginator-showPage> presenter = Homepage
action = default
value = 
NULL
no Route [<value>/] presenter = Homepage
action = default
value = 
NULL

App\Presenters\ArticlesPresenter in .../app/presenters/ArticlesPresenter.php:12

¤ ×

Queries: 27, time: 125.740 ms, default

Time msSQL QueryRows
6.869
explain 
SELECT * 
FROM `formule_clanky` 
WHERE (`platnost` = 1) AND (`web` = 'autonoviny' OR `id` IN (
SELECT `clanek` 
FROM `formule_clanky_dalsiweby` 
WHERE `web` = 'autonoviny')) AND (`formule_clanky`.`id` = '42165')
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY formule_clanky const PRIMARY,web,platnost PRIMARY 4 const 1
2 DEPENDENT SUBQUERY formule_clanky_dalsiweby unique_subquery PRIMARY PRIMARY 54 func,const 1 Using index; Using where
.../app/model/Article.php:38 		1
3.694 
UPDATE `formule_clanky` 
SET `counter`=3831 
WHERE (`id` = 42165)
.../app/presenters/ArticlesPresenter.php:45 		1
1.898
explain 
SELECT * 
FROM `formule_clanky` 
WHERE (`id` = 42165)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky const PRIMARY PRIMARY 4 const 1
.../app/presenters/ArticlesPresenter.php:45 		1
2.426
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
2.277
explain 
SELECT `id`, `datum` 
FROM `formule_ankety_log` 
WHERE (`ip` = '3.134.111.219') 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 		2
2.412 
UPDATE `formule_ankety` 
SET `vysledky`='303146:299409:298425:290503:291452:285786:279210:2719:1:1:2:1:1:1:1:1:1:1:1:1:1:1:1:1:1:1:1:1:1:1:1…' 
WHERE (`id` = 341)
.../app/components/Polls/Poll.php:41 		1
1.152
explain 
SELECT * 
FROM `formule_ankety` 
WHERE (`id` = 341)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_ankety const PRIMARY PRIMARY 4 const 1
.../app/components/Polls/Poll.php:41 		1
2.977
explain 
SELECT `id`, `tries` 
FROM `formule_ankety_log` 
WHERE (`ip` = '3.134.111.219') 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 		2
1.875 
UPDATE `formule_ankety_log` 
SET `tries`=2, `datum`='2025-04-12 23:08:12' 
WHERE (`id` = 5143843)
.../app/components/Polls/Poll.php:47 		1
0.165
explain 
SELECT * 
FROM `formule_ankety_log` 
WHERE (`id` = 5143843)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_ankety_log const PRIMARY PRIMARY 4 const 1
.../app/components/Polls/Poll.php:47 		1
4.369
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
2.632
explain 
SELECT `id`, `nazev`, `url` 
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.097
explain 
SELECT `id`, `jmeno` 
FROM `formule_autori` 
WHERE (`formule_autori`.`id` = 80)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_autori const PRIMARY PRIMARY 4 const 1
.../app/model/Author.php:17 		1
4.824
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
3.309
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
58.951
explain 
SELECT *, ( (MATCH(`klicova_slova`) AGAINST ('cestování' IN BOOLEAN MODE) ) ) AS relevance
FROM `formule_clanky`
WHERE (`platnost` = 1) AND (`id` <> 42165) AND (`klicova_slova` LIKE "%cestování%") AND
web='autonoviny'
ORDER BY relevance DESC, `datum` DESC
LIMIT 8
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE formule_clanky ref PRIMARY,web,platnost web 50 const 2172 Using index condition; Using where; Using temporary; Using filesort
.../app/model/Article.php:63 		8
0.356
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.603
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
6.690
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.677
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 36 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
6.052
explain 
SELECT `id`, `datum` 
FROM `formule_ankety_log` 
WHERE (`ip` = '3.134.111.219') 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 		2
1.101
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
6.733
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.456
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 7 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
1.176
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-12 23:08:12') 
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 168 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.913
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.055
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-12 23:08:12') 
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 168 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

¤ ×