Zvolená destinace není k dispozici.

Doporučujeme:
Informace
Pro zákazníky, prodejce, agentury
Kontakty
Dokumenty ke stažení
Katalogy
Nejlepší prodejci v ČR
Kurz € | Leták
Platby
Zpracování osobních údajů (GDPR)
Kontakty
Nejlepší ceny a last-minute - přihlášení
Partneři
 

System info

Execution time1 313.3 ms
Peak of allocated memory6.64 MB
Included files130
Classes + interfaces + traits283 + 44 + 0
Your IP3.144.39.8
Server IP93.185.104.18
PHP5.5.38
Tracy2.3.2
ServerApache
¤ ×

Destinace:default

http://www.settour.cz/destinace/evropa_metropole

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
yes Route destinace/<id> presenter = Destinace
action = default
 Destinace:default
id = evropa_metropole
no Route hledani/<id> presenter = Destinace
action = default
no Route termin/<id> presenter = Termin
action = default
no Route detail/<id>[/<type>] presenter = Detail
action = default
type = 
NULL
no Route sitemap.xml presenter = Sitemap
action = default
no Route <presenter>/<action>[/<id>] presenter = Homepage
action = default
id = 
NULL

App\Presenters\DestinacePresenter::actionDefault() in .../app/presenters/DestinacePresenter.php:13

¤ ×

Queries: 313, time: 408.127 ms, default

Time msSQL QueryRows
0.308 
SET NAMES 'utf8mb4'
.../app/model/DestinationsModel.php:31 		0
4.864 
SHOW FULL TABLES
.../app/model/DestinationsModel.php:31 		156
1.651 
SHOW FULL COLUMNS 
FROM `bs_Charakteristika`
.../app/model/DestinationsModel.php:31 		4
0.966
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/DestinationsModel.php:31 		0
1.332 
SHOW FULL COLUMNS 
FROM `bs_Counter`
.../app/model/DestinationsModel.php:31 		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_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/DestinationsModel.php:31 		0
1.022 
SHOW FULL COLUMNS 
FROM `bs_Destinace`
.../app/model/DestinationsModel.php:31 		3
0.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 =
'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/DestinationsModel.php:31 		0
1.322 
SHOW FULL COLUMNS 
FROM `bs_Hotel`
.../app/model/DestinationsModel.php:31 		8
0.731
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/DestinationsModel.php:31 		0
2.612 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiDetail`
.../app/model/DestinationsModel.php:31 		6
0.764
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/DestinationsModel.php:31 		0
2.608 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiFotka`
.../app/model/DestinationsModel.php:31 		6
0.727
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/DestinationsModel.php:31 		0
2.681 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika`
.../app/model/DestinationsModel.php:31 		4
0.758
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/DestinationsModel.php:31 		0
2.820 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31 		4
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 =
'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/DestinationsModel.php:31 		0
2.747 
SHOW FULL COLUMNS 
FROM `bs_Oblast`
.../app/model/DestinationsModel.php:31 		3
0.888
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/DestinationsModel.php:31 		0
2.707 
SHOW FULL COLUMNS 
FROM `bs_Zajezd`
.../app/model/DestinationsModel.php:31 		10
0.721
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/DestinationsModel.php:31 		0
1.380 
SHOW FULL COLUMNS 
FROM `bs_Zajezd2`
.../app/model/DestinationsModel.php:31 		10
0.690
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/DestinationsModel.php:31 		0
1.161 
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika`
.../app/model/DestinationsModel.php:31 		4
0.641
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/DestinationsModel.php:31 		0
1.825 
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31 		4
0.716
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/DestinationsModel.php:31 		0
1.794 
SHOW FULL COLUMNS 
FROM `exim_Hotel`
.../app/model/DestinationsModel.php:31 		21
0.720
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/DestinationsModel.php:31 		0
2.353 
SHOW FULL COLUMNS 
FROM `exim_Photo`
.../app/model/DestinationsModel.php:31 		4
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 = '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/DestinationsModel.php:31 		0
2.356 
SHOW FULL COLUMNS 
FROM `exim_PriceType`
.../app/model/DestinationsModel.php:31 		3
1.188
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/DestinationsModel.php:31 		0
1.345 
SHOW FULL COLUMNS 
FROM `exim_Update`
.../app/model/DestinationsModel.php:31 		6
0.713
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/DestinationsModel.php:31 		0
1.521 
SHOW FULL COLUMNS 
FROM `fti_cenik`
.../app/model/DestinationsModel.php:31 		4
0.735
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/DestinationsModel.php:31 		0
1.279 
SHOW FULL COLUMNS 
FROM `kovotour_cena_pokoj`
.../app/model/DestinationsModel.php:31 		5
0.730
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/DestinationsModel.php:31 		0
1.873 
SHOW FULL COLUMNS 
FROM `kovotour_ceny_zajezdu`
.../app/model/DestinationsModel.php:31 		9
0.770
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/DestinationsModel.php:31 		0
1.292 
SHOW FULL COLUMNS 
FROM `kovotour_destinace`
.../app/model/DestinationsModel.php:31 		3
1.670
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/DestinationsModel.php:31 		0
1.254 
SHOW FULL COLUMNS 
FROM `kovotour_dopravy_zajezdu`
.../app/model/DestinationsModel.php:31 		3
0.662
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/DestinationsModel.php:31 		0
1.200 
SHOW FULL COLUMNS 
FROM `kovotour_pokoje`
.../app/model/DestinationsModel.php:31 		8
0.684
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/DestinationsModel.php:31 		0
1.117 
SHOW FULL COLUMNS 
FROM `kovotour_stanice_zajezdu`
.../app/model/DestinationsModel.php:31 		3
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 =
'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/DestinationsModel.php:31 		0
1.074 
SHOW FULL COLUMNS 
FROM `kovotour_stravy_zajezdu`
.../app/model/DestinationsModel.php:31 		3
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 =
'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/DestinationsModel.php:31 		0
1.302 
SHOW FULL COLUMNS 
FROM `kovotour_terminy_zajezdu`
.../app/model/DestinationsModel.php:31 		6
0.844
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/DestinationsModel.php:31 		0
1.379 
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_detaily`
.../app/model/DestinationsModel.php:31 		10
0.672
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/DestinationsModel.php:31 		0
1.315 
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_foto`
.../app/model/DestinationsModel.php:31 		3
0.675
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/DestinationsModel.php:31 		0
1.106 
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_prehled`
.../app/model/DestinationsModel.php:31 		4
0.662
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/DestinationsModel.php:31 		0
2.184 
SHOW FULL COLUMNS 
FROM `kt_Cena`
.../app/model/DestinationsModel.php:31 		38
1.003
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/DestinationsModel.php:31 		0
1.569 
SHOW FULL COLUMNS 
FROM `kt_CenaPolozky`
.../app/model/DestinationsModel.php:31 		17
0.694
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/DestinationsModel.php:31 		0
1.191 
SHOW FULL COLUMNS 
FROM `kt_Destinace`
.../app/model/DestinationsModel.php:31 		5
0.770
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/DestinationsModel.php:31 		0
1.143 
SHOW FULL COLUMNS 
FROM `kt_Doprava`
.../app/model/DestinationsModel.php:31 		4
0.754
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/DestinationsModel.php:31 		0
1.173 
SHOW FULL COLUMNS 
FROM `kt_DopravyCenikovychPolozek`
.../app/model/DestinationsModel.php:31 		4
0.685
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/DestinationsModel.php:31 		0
1.284 
SHOW FULL COLUMNS 
FROM `kt_Fotografie`
.../app/model/DestinationsModel.php:31 		5
0.670
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/DestinationsModel.php:31 		0
1.429 
SHOW FULL COLUMNS 
FROM `kt_Katalog`
.../app/model/DestinationsModel.php:31 		4
0.680
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/DestinationsModel.php:31 		0
1.549 
SHOW FULL COLUMNS 
FROM `kt_Pokoj`
.../app/model/DestinationsModel.php:31 		8
0.745
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/DestinationsModel.php:31 		0
1.239 
SHOW FULL COLUMNS 
FROM `kt_PokojeCenikovychPolozek`
.../app/model/DestinationsModel.php:31 		4
0.828
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/DestinationsModel.php:31 		0
1.454 
SHOW FULL COLUMNS 
FROM `kt_Popis`
.../app/model/DestinationsModel.php:31 		5
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_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/DestinationsModel.php:31 		0
1.478 
SHOW FULL COLUMNS 
FROM `kt_PopisZajezdu`
.../app/model/DestinationsModel.php:31 		6
0.884
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/DestinationsModel.php:31 		0
1.328 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciCenaPokoj`
.../app/model/DestinationsModel.php:31 		4
0.687
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/DestinationsModel.php:31 		0
1.249 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciDestinacePopis`
.../app/model/DestinationsModel.php:31 		4
0.623
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/DestinationsModel.php:31 		0
1.410 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciTypyProduktuZajezd`
.../app/model/DestinationsModel.php:31 		4
0.660
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/DestinationsModel.php:31 		0
1.181 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDestinace`
.../app/model/DestinationsModel.php:31 		5
0.858
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/DestinationsModel.php:31 		0
1.724 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDoprava`
.../app/model/DestinationsModel.php:31 		4
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 =
'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/DestinationsModel.php:31 		0
1.347 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdKatalog`
.../app/model/DestinationsModel.php:31 		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_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/DestinationsModel.php:31 		0
1.430 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStanice`
.../app/model/DestinationsModel.php:31 		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_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/DestinationsModel.php:31 		0
1.493 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStrava`
.../app/model/DestinationsModel.php:31 		5
0.690
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/DestinationsModel.php:31 		0
1.186 
SHOW FULL COLUMNS 
FROM `kt_Stanice`
.../app/model/DestinationsModel.php:31 		4

...and more

¤ ×

Unlogged

no identity

¤ ×