Chorvatsko - Střední Dalmácie

Resnik bungalov - all inclusive - BUS * *

Resnik bungalov - all inclusive - BUS
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 26 27 28 29 30 31 32 33 34 35 36 37 38
Informace:
Termíny:

Kód nabídky: z9909

Nezávazná poptávka

Nachází se v západní části Kaštelanské riviéry, asi 8 km od Trogiru. Komplex je rozsáhlý, příjemný, celý obklopen zelení. Ubytování zde najdeme v atriovém, jednopatrovém pavilonu a v samostatně stojících zděných bungalovech.

Bungalovy jsou buď typu STUDIO (1/2+2 růžové - jedna místnost se 4 lůžky, 24 m2, bez kuchyňského koutu) nebo SUITE (1/4 žluté - dvě dvoulůžkové ložnice + denní místnost, v denní místnosti kuchyňský kout s lednicí a dvouplotýnkovým vařičem, nádobí doporučujeme vzít si vlastní – je tu minimální vybavenost,  28 m2. Všechny bungalovy mají vlastní sociální zařízení, terasu. Některé BGW SUITE jsou s klimatizací viz cenová tabulka.

Pokoje v pavilonu (jiná šnůra zájezdů) jsou dvoulůžkové (velikost 19 m2) s francouzským lůžkem a možností jedné přistýlky pro dítě do 12 let, klimatizované dvoulůžkové pokoje mají 2 oddělená lůžka nebo jednolůžkové (velikost cca 14 m2); mají balkon, sociální zařízení, telefon (přímá linka – zpoplatněná). Klimatizace v pokojích v pavilonech je možná na předchozí vyžádání za příplatek.

Všechny společné prostory jsou klimatizované (recepce, restaurace). Dále hosté mají k dispozici restauraci á la carte (8:00-22:00), plážový bar (8:00-24:00), terasu, parkoviště. Parkovat lze i v blízkosti bungalovů (ale zde je jen omezený počet míst). Obchod s potravinami a základním zbožím se nachází v blízkosti (otevřeno každý den 7:30-20:30 hodin). WI-FI připojení k internetu je zdarma pouze v okolí recepce a v televizní místnosti, heslo je vyvěšeno v recepci. Recepce je v provozu od 7 do 21 hodin.

Pláže jsou částečně betonové, částečně oblázkové a s hrubým pískem s pozvolným vstupem, vzdálené cca 50 m od střediska. V některých místech jsou kamínky a písek ve vodě jemnější. Lehátka a slunečníky na pláži za poplatek (cca 20-30 KN/den podle sezóny). V sezóně také možnost masáží na pláži (placené).

Ke sportovnímu vyžití slouží 5 tenisových dvorců, multifunkční travnaté hřiště, stolní tenis. Na pláži se nachází škola potápění. 

Autobusová zastávka je vzdálená cca 200 m. Autobus jezdí směr Trogir nebo směr Split, a to zhruba každých 30 minut.
Ideální pro rodinnou dovolenou s dětmi. Pokoje i všechny vnitřní prostory jsou nekuřácké. 

Služby all inclusive začínají v den nástupu ve 14:00 hod. (klienti obdrží náramek) a končí v den odjezdu ve 14:00 hod., poté platí již jiná barva náramku (ubytování je ale třeba opustit již do 10 hodin). Nápoje v rámci služeb all inclusive jsou k dispozici pouze v restauraci (konzumovat je lze i na terase), do restaurace nelze chodit z pláže přes terasu, ale pouze hlavním vchodem přes recepci.

Poskytovatel služeb: 101 CK Zemek

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

System info

Execution time1 484.3 ms
Peak of allocated memory6.85 MB
Included files133
Classes + interfaces + traits291 + 44 + 0
Your IP3.134.109.116
Server IP93.185.104.18
PHP5.5.38
Tracy2.3.2
ServerApache
¤ ×

Detail:default

http://www.settour.cz/detail/z9909-resnik-bungalov-all-inclusive-bus

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 = z9909-resnik-bungalov-all-inclusive-bus
type = 
NULL
no Route sitemap.xml presenter = Sitemap
action = default
may Route <presenter>/<action>[/<id>] presenter = Homepage
action = default
id = 
NULL
Detail:z9909ResnikBungalovAllInclusiveBus
id = 
NULL

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

¤ ×

Queries: 315, time: 551.785 ms, default

Time msSQL QueryRows
0.597
SET NAMES 'utf8mb4'
.../app/model/ZemekModel.php:428
0
3.589
SHOW FULL TABLES
.../app/model/ZemekModel.php:428
156
8.141
SHOW FULL COLUMNS 
FROM `bs_Charakteristika`
.../app/model/ZemekModel.php:428
4
0.915
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
8.198
SHOW FULL COLUMNS 
FROM `bs_Counter`
.../app/model/ZemekModel.php:428
4
0.958
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
7.226
SHOW FULL COLUMNS 
FROM `bs_Destinace`
.../app/model/ZemekModel.php:428
3
0.854
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
7.714
SHOW FULL COLUMNS 
FROM `bs_Hotel`
.../app/model/ZemekModel.php:428
8
0.866
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
7.472
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiDetail`
.../app/model/ZemekModel.php:428
6
0.943
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
7.087
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiFotka`
.../app/model/ZemekModel.php:428
6
0.838
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
7.402
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika`
.../app/model/ZemekModel.php:428
4
0.848
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
7.573
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika2`
.../app/model/ZemekModel.php:428
4
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 =
'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
7.479
SHOW FULL COLUMNS 
FROM `bs_Oblast`
.../app/model/ZemekModel.php:428
3
1.666
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
13.831
SHOW FULL COLUMNS 
FROM `bs_Zajezd`
.../app/model/ZemekModel.php:428
10
6.054
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.152
SHOW FULL COLUMNS 
FROM `bs_Zajezd2`
.../app/model/ZemekModel.php:428
10
0.954
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.733
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika`
.../app/model/ZemekModel.php:428
4
0.824
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
3.895
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika2`
.../app/model/ZemekModel.php:428
4
0.988
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
2.870
SHOW FULL COLUMNS 
FROM `exim_Hotel`
.../app/model/ZemekModel.php:428
21
0.980
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
2.301
SHOW FULL COLUMNS 
FROM `exim_Photo`
.../app/model/ZemekModel.php:428
4
0.849
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.768
SHOW FULL COLUMNS 
FROM `exim_PriceType`
.../app/model/ZemekModel.php:428
3
0.824
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
2.013
SHOW FULL COLUMNS 
FROM `exim_Update`
.../app/model/ZemekModel.php:428
6
0.926
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
2.058
SHOW FULL COLUMNS 
FROM `fti_cenik`
.../app/model/ZemekModel.php:428
4
0.847
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
3.627
SHOW FULL COLUMNS 
FROM `kovotour_cena_pokoj`
.../app/model/ZemekModel.php:428
5
0.814
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
2.267
SHOW FULL COLUMNS 
FROM `kovotour_ceny_zajezdu`
.../app/model/ZemekModel.php:428
9
0.748
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.517
SHOW FULL COLUMNS 
FROM `kovotour_destinace`
.../app/model/ZemekModel.php:428
3
0.733
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.976
SHOW FULL COLUMNS 
FROM `kovotour_dopravy_zajezdu`
.../app/model/ZemekModel.php:428
3
0.825
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.892
SHOW FULL COLUMNS 
FROM `kovotour_pokoje`
.../app/model/ZemekModel.php:428
8
0.725
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.912
SHOW FULL COLUMNS 
FROM `kovotour_stanice_zajezdu`
.../app/model/ZemekModel.php:428
3
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 =
'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
3.176
SHOW FULL COLUMNS 
FROM `kovotour_stravy_zajezdu`
.../app/model/ZemekModel.php:428
3
0.772
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.431
SHOW FULL COLUMNS 
FROM `kovotour_terminy_zajezdu`
.../app/model/ZemekModel.php:428
6
0.732
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.852
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_detaily`
.../app/model/ZemekModel.php:428
10
0.824
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.970
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_foto`
.../app/model/ZemekModel.php:428
3
0.818
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.829
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_prehled`
.../app/model/ZemekModel.php:428
4
0.762
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.961
SHOW FULL COLUMNS 
FROM `kt_Cena`
.../app/model/ZemekModel.php:428
38
1.264
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.861
SHOW FULL COLUMNS 
FROM `kt_CenaPolozky`
.../app/model/ZemekModel.php:428
17
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_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.453
SHOW FULL COLUMNS 
FROM `kt_Destinace`
.../app/model/ZemekModel.php:428
5
0.717
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.412
SHOW FULL COLUMNS 
FROM `kt_Doprava`
.../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_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.448
SHOW FULL COLUMNS 
FROM `kt_DopravyCenikovychPolozek`
.../app/model/ZemekModel.php:428
4
0.742
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.524
SHOW FULL COLUMNS 
FROM `kt_Fotografie`
.../app/model/ZemekModel.php:428
5
0.736
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.333
SHOW FULL COLUMNS 
FROM `kt_Katalog`
.../app/model/ZemekModel.php:428
4
0.669
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
7.456
SHOW FULL COLUMNS 
FROM `kt_Pokoj`
.../app/model/ZemekModel.php:428
8
1.021
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.594
SHOW FULL COLUMNS 
FROM `kt_PokojeCenikovychPolozek`
.../app/model/ZemekModel.php:428
4
0.750
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.419
SHOW FULL COLUMNS 
FROM `kt_Popis`
.../app/model/ZemekModel.php:428
5
0.699
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.474
SHOW FULL COLUMNS 
FROM `kt_PopisZajezdu`
.../app/model/ZemekModel.php:428
6
0.756
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.303
SHOW FULL COLUMNS 
FROM `kt_SpojovaciCenaPokoj`
.../app/model/ZemekModel.php:428
4
0.669
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.568
SHOW FULL COLUMNS 
FROM `kt_SpojovaciDestinacePopis`
.../app/model/ZemekModel.php:428
4
0.750
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
3.368
SHOW FULL COLUMNS 
FROM `kt_SpojovaciTypyProduktuZajezd`
.../app/model/ZemekModel.php:428
4
1.198
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.602
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDestinace`
.../app/model/ZemekModel.php:428
5
0.875
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.525
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDoprava`
.../app/model/ZemekModel.php:428
4
0.766
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.411
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdKatalog`
.../app/model/ZemekModel.php:428
4
0.708
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.513
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStanice`
.../app/model/ZemekModel.php:428
4
0.722
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.610
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStrava`
.../app/model/ZemekModel.php:428
5
0.757
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.503
SHOW FULL COLUMNS 
FROM `kt_Stanice`
.../app/model/ZemekModel.php:428
4

...and more

¤ ×

Unlogged

no identity

¤ ×