Chorvatsko - Istrie

Delfin hotel . * *

Delfin hotel .
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Informace:
Termíny:

Kód nabídky: z10363

Nezávazná poptávka

 

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

pdf
stáhnout jako PDF
Informace
Pro zákazníky, prodejce, agentury
Kontakty
 

System info

Execution time1 146.8 ms
Peak of allocated memory6.86 MB
Included files133
Classes + interfaces + traits291 + 44 + 0
Your IP216.73.216.13
Server IP93.185.104.18
PHP5.5.38
Tracy2.3.2
ServerApache
¤ ×

Detail:default

http://www.settour.cz/detail/z10363

Matched? Class Mask Defaults Module Request
no Route sprava/<presenter>/<action>/<id> module = Sprava
presenter = Dashboard
action = default
id = 
NULL
no Route presenter = Homepage
action = leto
no Route leto presenter = Homepage
action = leto
no Route zima/ presenter = Homepage
action = zima
no Route page/<id> presenter = Page
action = default
no Route aktivity/<id> presenter = Aktivity
action = default
no Route destinace/<id> presenter = Destinace
action = default
no Route hledani/<id> presenter = Destinace
action = default
no Route termin/<id> presenter = Termin
action = default
yes Route detail/<id>[/<type>] presenter = Detail
action = default
type = 
NULL
Detail:default
id = z10363
type = 
NULL
no Route sitemap.xml presenter = Sitemap
action = default
may Route <presenter>/<action>[/<id>] presenter = Homepage
action = default
id = 
NULL
Detail:z10363
id = 
NULL

App\Presenters\DetailPresenter::actionDefault() in .../app/presenters/DetailPresenter.php:14

¤ ×

Queries: 315, time: 345.880 ms, default

Time msSQL QueryRows
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
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'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE KEY_COLUMN_USAGE ALL TABLE_SCHEMA,TABLE_NAME Using where; Open_full_table; Scanned 0 databases
.../app/model/ZemekModel.php:428
0
1.557
SHOW FULL COLUMNS 
FROM `kt_Stanice`
.../app/model/ZemekModel.php:428
4

...and more

¤ ×

Unlogged

no identity

¤ ×