Kód nabídky: z10363
Hotel Delfin v Poreči se nachází na slunečném poloostrově, nejblíže k otevřenému moři z hotelů ve středisku Zelena Laguna. Jedná se v podstatě o malé samostatné městečko, neboť má 793 pokojů, tj. cca 1600 lůžek. Centrem hotelu je v přízemí rozlehlá recepční část s odpočinkovými prostory a s prostory pro zavazadla, sociálním zařízením, kadeřnickým salonem, prodejnou suvenýrů, trafikou a rozlehlým novým Cafe barem s terasou. V 1. patře jsou 3 velké restaurace. V suterenu pak taneční kavárna, konferenční sál a místnost pro možná cvičení a relaxaxi. Na tuto centrální část navazuje ubytovací část hotelu a to šesti křídly, navzájem propojenými. Každé křídlo má svůj samostaný výtah.
Pokoje jsou jednolůžkové a dvoulůžkové s možností přistýlky, všechny s balkonem a telefonem. Přistýlka je vždy skládací lůžko, neboť pokoje jsou menší. Jsou však v současné době všechny renovovány – nové podlahy, okna, nový nábytek, závěsy. Koupelny jsou renovovány jen částečně ( bez nových obkladů). Hotel má i dostatečné množství rodinných pokojů 1/4 (dva dvoulůžkové pokoje propojené vnitřními dveřmi). Rodinné pokoje jsou větší a mají všechna 4 lůžka řádná. Upozorňujeme, že z některých pokojů na mořskou stranu není vidět na moře (platí obecně pro celé Chorvatsko - vzrostlé stromy, přízemí atd.).
Pláže jsou oblázkové, kamenité a betonová plata s pozvolným vstupem do vody. Pro děti je zde vybudovaná ohrazená pláž s pískem. Jsou zde velké upravené prostory na slunění, také se dá ležet v borovicovém háji ve stínu, vzdálené cca 100 m od hotelu. Pláž má svoje sprchy, sociální zařízení i převlékací kabinu. Na pláži je jedna větší restaurace , Beach bar a Sport Laguna Delfin. Součástí tohoto sportu je stolní tenis, střelba, minigolf, vodní sporty. Hotel má venkovní bazén s mořskou vodou (z části i pod střechou) a terasou. Na této terase je nově otevřen snack bar. V roce 2018 byl vytvořen dětský bazénový komplex se skluzavkami a dalšími vodními atrakcemi. Pod bazénem je vybudováno nové dětské hřiště. K širšímu sportovnímu vyžití je k dispozici řada dalších aktivit dle popisu společných pro celou Zelenou Lagunu.
Klienti mohou využít bezplatné WI-FI připojení k internetu v hale hotelu.
Kompletní informace o hotelu Delfin** - Zelena Laguna - Poreč
Základní informace
• 5 km od Poreče
• Pater: 6
• 50 metrů vzdálen od pláže
Vybavení
V hotelu
• Klimatizovaná restaurace
• Směnárna
• Na recepci sejf za poplatek
• Aperitiv bar, bar uz bazénu
• Taneční kavárna
• Tv místnost
• Obchod se suvenýry/novinski kiosk
• Kadeřnictví
• Konferenční sál: 400 míst
• Prostor pro uložení kol
• Masážní salón
• Check in: od 14 h
• Check out: do 10 h
V blízkosti
• Dětské hřiště
• Různé restaurace, bary a obchody
• Sportovní centrum
• Centrální parkoviště (za příplatek)
Strava
• Snídaně 7-10 h - švédský stůl (v ceně)
• Oběd 12-14 h - švédský stůl (za příplatek, den předem možno vyžádat obědový balíček sebou)
• Večeře 18:30-21 h - švédský stůl (v ceně)
• Vhodné i pro vegetariány
Vybavení pokojů
• 794 pokojů
• Telefon s přímou volbou
• Sprcha
• Park strana / mořská strana
• Balkon (ne u všech pokojů)
• Dodatečné lůžko (skládací, za příplatek)
• Dětská postýlka (na vyžádání, za příplatek)
Jednolůžkové pokoje
• Plocha: od cca. 11 m2 do 13 m2
Dvoulůžkové pokoje
• Plocha: od cca. 13 m2 do cca. 17 m2
Rodinné pokoje
• Plocha: cca. 32 m2
Bazén
• Venkovní bazén s mořskou vodou (plocha: 314 m2; objem: cca. 475 m3)
• Lehátka
Pláž
• 50 m vzdálena od hotelu
• Betonová plata, oblázková, travnatá, skalnatá; postupný vstup
• Lehátka a slunečníky (za doplatek)
• Sprchy na pláži
• Mezinárodní ocenění Modrá vlajka
• Restaurace a bary
Sport
• Za doplatek: tenis, stolní tenis, mini golf, boća, košíková, volejbal, vodní lyže, plachtění, skútr, kola, fotbal, windsurfing, kánoe, potápění, projížďky na koni, squash, tobogán
• Bez doplatku: plážový volejbal
Animace v sezóně
Program pro děti
• Mini club (4 – 12 let) denně kromě soboty,ráno a odpoloedne cca 2 hodiny (kreativní dílny, hry, sporty aj.)
• Dětské večerní programy (4 – 12 let) denně kromě soboty
Program pro dospělé
• Ranní gymnastika nebo aquaerobic – každodenně kromě soboty
• Sportovní turnaje: plážový volejbal, plážový fotbal, fotbal, košíková, stolní tenis, mini golf
Večerní program
• Živá hudba
• Animační program (společenský program)
Spojení s městem (během hlavní sezóny)
• Turistický vláček; každých 30 min.
• Loď; každých 60 min.
Další informace
• Domácí zvířata povolena (za příplatek)
• 5 km k nemocnici a lékárně
• 300 m od ambulance
Poskytovatel služeb: 101 CK Zemek
Execution time | 1 146.8 ms |
Peak of allocated memory | 6.86 MB |
Included files | 133 |
Classes + interfaces + traits | 291 + 44 + 0 |
Your IP | 216.73.216.13 |
Server IP | 93.185.104.18 |
PHP | 5.5.38 |
Tracy | 2.3.2 |
Server | Apache |
http://www.settour.cz/detail/z10363
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | Route |
sprava/<presenter>/<action>/<id> |
module = Sprava |
|
|
no | Route |
|
presenter = Homepage |
|
|
no | Route |
leto |
presenter = Homepage |
|
|
no | Route |
zima/ |
presenter = Homepage |
|
|
no | Route |
page/<id> |
presenter = Page |
|
|
no | Route |
aktivity/<id> |
presenter = Aktivity |
|
|
no | Route |
destinace/<id> |
presenter = Destinace |
|
|
no | Route |
hledani/<id> |
presenter = Destinace |
|
|
no | Route |
termin/<id> |
presenter = Termin |
|
|
yes | Route |
detail/<id>[/<type>] |
presenter = Detail |
|
Detail:default |
no | Route |
sitemap.xml |
presenter = Sitemap |
|
|
may | Route |
<presenter>/<action>[/<id>] |
presenter = Homepage |
|
Detail:z10363 |
App\Presenters\DetailPresenter::actionDefault() in .../app/presenters/DetailPresenter.php:14
Time ms | SQL Query | Rows | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.453 | SET NAMES 'utf8mb4'.../app/model/ZemekModel.php:428 |
0 | ||||||||||||||||||||
3.584 | SHOW FULL TABLES.../app/model/ZemekModel.php:428 |
156 | ||||||||||||||||||||
1.521 | SHOW FULL COLUMNS FROM `bs_Charakteristika`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.695 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_Charakteristika'
|
0 | ||||||||||||||||||||
1.144 | SHOW FULL COLUMNS FROM `bs_Counter`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.624 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_Counter'
|
0 | ||||||||||||||||||||
1.155 | SHOW FULL COLUMNS FROM `bs_Destinace`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
0.712 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_Destinace'
|
0 | ||||||||||||||||||||
1.229 | SHOW FULL COLUMNS FROM `bs_Hotel`.../app/model/ZemekModel.php:428 |
8 | ||||||||||||||||||||
0.607 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_Hotel'
|
0 | ||||||||||||||||||||
1.129 | SHOW FULL COLUMNS FROM `bs_HotelObdobiDetail`.../app/model/ZemekModel.php:428 |
6 | ||||||||||||||||||||
0.700 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_HotelObdobiDetail'
|
0 | ||||||||||||||||||||
1.195 | SHOW FULL COLUMNS FROM `bs_HotelObdobiFotka`.../app/model/ZemekModel.php:428 |
6 | ||||||||||||||||||||
0.615 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_HotelObdobiFotka'
|
0 | ||||||||||||||||||||
1.237 | SHOW FULL COLUMNS FROM `bs_HotelObdobiVazbaCharakteristika`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.627 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_HotelObdobiVazbaCharakteristika'
|
0 | ||||||||||||||||||||
1.075 | SHOW FULL COLUMNS FROM `bs_HotelObdobiVazbaCharakteristika2`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.615 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_HotelObdobiVazbaCharakteristika2'
|
0 | ||||||||||||||||||||
1.290 | SHOW FULL COLUMNS FROM `bs_Oblast`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
0.614 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_Oblast'
|
0 | ||||||||||||||||||||
1.290 | SHOW FULL COLUMNS FROM `bs_Zajezd`.../app/model/ZemekModel.php:428 |
10 | ||||||||||||||||||||
0.604 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_Zajezd'
|
0 | ||||||||||||||||||||
2.163 | SHOW FULL COLUMNS FROM `bs_Zajezd2`.../app/model/ZemekModel.php:428 |
10 | ||||||||||||||||||||
0.661 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_Zajezd2'
|
0 | ||||||||||||||||||||
1.071 | SHOW FULL COLUMNS FROM `bs_ZajezdVazbaCharakteristika`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.619 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_ZajezdVazbaCharakteristika'
|
0 | ||||||||||||||||||||
1.251 | SHOW FULL COLUMNS FROM `bs_ZajezdVazbaCharakteristika2`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.673 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'bs_ZajezdVazbaCharakteristika2'
|
0 | ||||||||||||||||||||
1.786 | SHOW FULL COLUMNS FROM `exim_Hotel`.../app/model/ZemekModel.php:428 |
21 | ||||||||||||||||||||
0.778 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'exim_Hotel'
|
0 | ||||||||||||||||||||
1.240 | SHOW FULL COLUMNS FROM `exim_Photo`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.608 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'exim_Photo'
|
0 | ||||||||||||||||||||
1.088 | SHOW FULL COLUMNS FROM `exim_PriceType`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
0.591 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'exim_PriceType'
|
0 | ||||||||||||||||||||
1.164 | SHOW FULL COLUMNS FROM `exim_Update`.../app/model/ZemekModel.php:428 |
6 | ||||||||||||||||||||
0.610 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'exim_Update'
|
0 | ||||||||||||||||||||
1.151 | SHOW FULL COLUMNS FROM `fti_cenik`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.907 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'fti_cenik'
|
0 | ||||||||||||||||||||
1.180 | SHOW FULL COLUMNS FROM `kovotour_cena_pokoj`.../app/model/ZemekModel.php:428 |
5 | ||||||||||||||||||||
0.785 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_cena_pokoj'
|
0 | ||||||||||||||||||||
1.216 | SHOW FULL COLUMNS FROM `kovotour_ceny_zajezdu`.../app/model/ZemekModel.php:428 |
9 | ||||||||||||||||||||
0.601 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_ceny_zajezdu'
|
0 | ||||||||||||||||||||
1.102 | SHOW FULL COLUMNS FROM `kovotour_destinace`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
0.628 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_destinace'
|
0 | ||||||||||||||||||||
1.068 | SHOW FULL COLUMNS FROM `kovotour_dopravy_zajezdu`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
0.689 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_dopravy_zajezdu'
|
0 | ||||||||||||||||||||
1.613 | SHOW FULL COLUMNS FROM `kovotour_pokoje`.../app/model/ZemekModel.php:428 |
8 | ||||||||||||||||||||
0.677 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_pokoje'
|
0 | ||||||||||||||||||||
1.219 | SHOW FULL COLUMNS FROM `kovotour_stanice_zajezdu`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
1.633 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_stanice_zajezdu'
|
0 | ||||||||||||||||||||
1.233 | SHOW FULL COLUMNS FROM `kovotour_stravy_zajezdu`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
0.607 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_stravy_zajezdu'
|
0 | ||||||||||||||||||||
1.220 | SHOW FULL COLUMNS FROM `kovotour_terminy_zajezdu`.../app/model/ZemekModel.php:428 |
6 | ||||||||||||||||||||
0.779 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_terminy_zajezdu'
|
0 | ||||||||||||||||||||
1.338 | SHOW FULL COLUMNS FROM `kovotour_zajezdy_detaily`.../app/model/ZemekModel.php:428 |
10 | ||||||||||||||||||||
0.622 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_zajezdy_detaily'
|
0 | ||||||||||||||||||||
1.091 | SHOW FULL COLUMNS FROM `kovotour_zajezdy_foto`.../app/model/ZemekModel.php:428 |
3 | ||||||||||||||||||||
0.648 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_zajezdy_foto'
|
0 | ||||||||||||||||||||
1.062 | SHOW FULL COLUMNS FROM `kovotour_zajezdy_prehled`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.617 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kovotour_zajezdy_prehled'
|
0 | ||||||||||||||||||||
2.722 | SHOW FULL COLUMNS FROM `kt_Cena`.../app/model/ZemekModel.php:428 |
38 | ||||||||||||||||||||
0.784 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_Cena'
|
0 | ||||||||||||||||||||
1.691 | SHOW FULL COLUMNS FROM `kt_CenaPolozky`.../app/model/ZemekModel.php:428 |
17 | ||||||||||||||||||||
0.686 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_CenaPolozky'
|
0 | ||||||||||||||||||||
1.215 | SHOW FULL COLUMNS FROM `kt_Destinace`.../app/model/ZemekModel.php:428 |
5 | ||||||||||||||||||||
0.618 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_Destinace'
|
0 | ||||||||||||||||||||
1.439 | SHOW FULL COLUMNS FROM `kt_Doprava`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.759 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_Doprava'
|
0 | ||||||||||||||||||||
1.234 | SHOW FULL COLUMNS FROM `kt_DopravyCenikovychPolozek`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.763 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_DopravyCenikovychPolozek'
|
0 | ||||||||||||||||||||
1.204 | SHOW FULL COLUMNS FROM `kt_Fotografie`.../app/model/ZemekModel.php:428 |
5 | ||||||||||||||||||||
0.616 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_Fotografie'
|
0 | ||||||||||||||||||||
1.193 | SHOW FULL COLUMNS FROM `kt_Katalog`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.739 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_Katalog'
|
0 | ||||||||||||||||||||
1.381 | SHOW FULL COLUMNS FROM `kt_Pokoj`.../app/model/ZemekModel.php:428 |
8 | ||||||||||||||||||||
0.651 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_Pokoj'
|
0 | ||||||||||||||||||||
1.126 | SHOW FULL COLUMNS FROM `kt_PokojeCenikovychPolozek`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.629 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_PokojeCenikovychPolozek'
|
0 | ||||||||||||||||||||
1.116 | SHOW FULL COLUMNS FROM `kt_Popis`.../app/model/ZemekModel.php:428 |
5 | ||||||||||||||||||||
0.611 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_Popis'
|
0 | ||||||||||||||||||||
1.124 | SHOW FULL COLUMNS FROM `kt_PopisZajezdu`.../app/model/ZemekModel.php:428 |
6 | ||||||||||||||||||||
0.671 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_PopisZajezdu'
|
0 | ||||||||||||||||||||
1.309 | SHOW FULL COLUMNS FROM `kt_SpojovaciCenaPokoj`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.714 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciCenaPokoj'
|
0 | ||||||||||||||||||||
1.422 | SHOW FULL COLUMNS FROM `kt_SpojovaciDestinacePopis`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.783 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciDestinacePopis'
|
0 | ||||||||||||||||||||
1.441 | SHOW FULL COLUMNS FROM `kt_SpojovaciTypyProduktuZajezd`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.761 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciTypyProduktuZajezd'
|
0 | ||||||||||||||||||||
1.573 | SHOW FULL COLUMNS FROM `kt_SpojovaciZajezdDestinace`.../app/model/ZemekModel.php:428 |
5 | ||||||||||||||||||||
0.795 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciZajezdDestinace'
|
0 | ||||||||||||||||||||
1.684 | SHOW FULL COLUMNS FROM `kt_SpojovaciZajezdDoprava`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
3.256 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciZajezdDoprava'
|
0 | ||||||||||||||||||||
1.524 | SHOW FULL COLUMNS FROM `kt_SpojovaciZajezdKatalog`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.648 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciZajezdKatalog'
|
0 | ||||||||||||||||||||
1.174 | SHOW FULL COLUMNS FROM `kt_SpojovaciZajezdStanice`.../app/model/ZemekModel.php:428 |
4 | ||||||||||||||||||||
0.726 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciZajezdStanice'
|
0 | ||||||||||||||||||||
1.801 | SHOW FULL COLUMNS FROM `kt_SpojovaciZajezdStrava`.../app/model/ZemekModel.php:428 |
5 | ||||||||||||||||||||
0.737 explain |
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = 'kt_SpojovaciZajezdStrava'
|
0 | ||||||||||||||||||||
1.557 | SHOW FULL COLUMNS FROM `kt_Stanice`.../app/model/ZemekModel.php:428 |
4 |
...and more
no identity