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 058.6 ms
Peak of allocated memory6.64 MB
Included files130
Classes + interfaces + traits283 + 44 + 0
Your IP18.117.168.137
Server IP93.185.104.18
PHP5.5.38
Tracy2.3.2
ServerApache
¤ ×

Destinace:default

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

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 = tunisko
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
may Route <presenter>/<action>[/<id>] presenter = Homepage
action = default
id = 
NULL
Destinace:tunisko
id = 
NULL

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

¤ ×

Queries: 313, time: 320.956 ms, default

Time msSQL QueryRows
0.462 
SET NAMES 'utf8mb4'
.../app/model/DestinationsModel.php:31 		0
4.172 
SHOW FULL TABLES
.../app/model/DestinationsModel.php:31 		156
1.697 
SHOW FULL COLUMNS 
FROM `bs_Charakteristika`
.../app/model/DestinationsModel.php:31 		4
0.886
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.127 
SHOW FULL COLUMNS 
FROM `bs_Counter`
.../app/model/DestinationsModel.php:31 		4
0.592
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.034 
SHOW FULL COLUMNS 
FROM `bs_Destinace`
.../app/model/DestinationsModel.php:31 		3
0.606
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.615 
SHOW FULL COLUMNS 
FROM `bs_Hotel`
.../app/model/DestinationsModel.php:31 		8
0.801
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
1.411 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiDetail`
.../app/model/DestinationsModel.php:31 		6
0.767
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
1.359 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiFotka`
.../app/model/DestinationsModel.php:31 		6
0.710
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
1.403 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika`
.../app/model/DestinationsModel.php:31 		4
0.711
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
1.089 
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31 		4
0.681
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
1.108 
SHOW FULL COLUMNS 
FROM `bs_Oblast`
.../app/model/DestinationsModel.php:31 		3
0.647
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
1.344 
SHOW FULL COLUMNS 
FROM `bs_Zajezd`
.../app/model/DestinationsModel.php:31 		10
0.668
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.694 
SHOW FULL COLUMNS 
FROM `bs_Zajezd2`
.../app/model/DestinationsModel.php:31 		10
0.837
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.280 
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika`
.../app/model/DestinationsModel.php:31 		4
0.576
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
0.950 
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31 		4
0.664
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.889 
SHOW FULL COLUMNS 
FROM `exim_Hotel`
.../app/model/DestinationsModel.php:31 		21
0.545
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
1.048 
SHOW FULL COLUMNS 
FROM `exim_Photo`
.../app/model/DestinationsModel.php:31 		4
0.840
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
1.391 
SHOW FULL COLUMNS 
FROM `exim_PriceType`
.../app/model/DestinationsModel.php:31 		3
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 =
'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.370 
SHOW FULL COLUMNS 
FROM `exim_Update`
.../app/model/DestinationsModel.php:31 		6
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 = '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.312 
SHOW FULL COLUMNS 
FROM `fti_cenik`
.../app/model/DestinationsModel.php:31 		4
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 = '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.294 
SHOW FULL COLUMNS 
FROM `kovotour_cena_pokoj`
.../app/model/DestinationsModel.php:31 		5
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 =
'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.314 
SHOW FULL COLUMNS 
FROM `kovotour_ceny_zajezdu`
.../app/model/DestinationsModel.php:31 		9
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 =
'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.183 
SHOW FULL COLUMNS 
FROM `kovotour_destinace`
.../app/model/DestinationsModel.php:31 		3
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 =
'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.189 
SHOW FULL COLUMNS 
FROM `kovotour_dopravy_zajezdu`
.../app/model/DestinationsModel.php:31 		3
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_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.455 
SHOW FULL COLUMNS 
FROM `kovotour_pokoje`
.../app/model/DestinationsModel.php:31 		8
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 =
'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.241 
SHOW FULL COLUMNS 
FROM `kovotour_stanice_zajezdu`
.../app/model/DestinationsModel.php:31 		3
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 =
'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.210 
SHOW FULL COLUMNS 
FROM `kovotour_stravy_zajezdu`
.../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 =
'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.332 
SHOW FULL COLUMNS 
FROM `kovotour_terminy_zajezdu`
.../app/model/DestinationsModel.php:31 		6
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 =
'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.526 
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_detaily`
.../app/model/DestinationsModel.php:31 		10
1.304
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.364 
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_foto`
.../app/model/DestinationsModel.php:31 		3
0.668
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.324 
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_prehled`
.../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 =
'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.551 
SHOW FULL COLUMNS 
FROM `kt_Cena`
.../app/model/DestinationsModel.php:31 		38
0.688
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.792 
SHOW FULL COLUMNS 
FROM `kt_CenaPolozky`
.../app/model/DestinationsModel.php:31 		17
0.984
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.324 
SHOW FULL COLUMNS 
FROM `kt_Destinace`
.../app/model/DestinationsModel.php:31 		5
0.644
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.553 
SHOW FULL COLUMNS 
FROM `kt_Doprava`
.../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_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.294 
SHOW FULL COLUMNS 
FROM `kt_DopravyCenikovychPolozek`
.../app/model/DestinationsModel.php:31 		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/DestinationsModel.php:31 		0
1.234 
SHOW FULL COLUMNS 
FROM `kt_Fotografie`
.../app/model/DestinationsModel.php:31 		5
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_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.231 
SHOW FULL COLUMNS 
FROM `kt_Katalog`
.../app/model/DestinationsModel.php:31 		4
0.807
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.485 
SHOW FULL COLUMNS 
FROM `kt_Pokoj`
.../app/model/DestinationsModel.php:31 		8
0.867
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.413 
SHOW FULL COLUMNS 
FROM `kt_PokojeCenikovychPolozek`
.../app/model/DestinationsModel.php:31 		4
0.640
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.243 
SHOW FULL COLUMNS 
FROM `kt_Popis`
.../app/model/DestinationsModel.php:31 		5
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_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.391 
SHOW FULL COLUMNS 
FROM `kt_PopisZajezdu`
.../app/model/DestinationsModel.php:31 		6
0.782
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.267 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciCenaPokoj`
.../app/model/DestinationsModel.php:31 		4
0.645
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.503 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciDestinacePopis`
.../app/model/DestinationsModel.php:31 		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 =
'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.295 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciTypyProduktuZajezd`
.../app/model/DestinationsModel.php:31 		4
0.767
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.386 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDestinace`
.../app/model/DestinationsModel.php:31 		5
0.794
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.304 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDoprava`
.../app/model/DestinationsModel.php:31 		4
0.857
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.568 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdKatalog`
.../app/model/DestinationsModel.php:31 		4
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 =
'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.137 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStanice`
.../app/model/DestinationsModel.php:31 		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_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.198 
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStrava`
.../app/model/DestinationsModel.php:31 		5
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 =
'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.277 
SHOW FULL COLUMNS 
FROM `kt_Stanice`
.../app/model/DestinationsModel.php:31 		4

...and more

¤ ×

Unlogged

no identity

¤ ×