Zvolená destinace není k dispozici.

Doporučujeme:
Informace
Pro zákazníky, prodejce, agentury
Kontakty
 

System info

Execution time1 131.4 ms
Peak of allocated memory6.66 MB
Included files130
Classes + interfaces + traits283 + 44 + 0
Your IP18.117.121.16
Server IP93.185.104.18
PHP5.5.38
Tracy2.3.2
ServerApache
¤ ×

Destinace:default

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

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 = slovinsko
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:slovinsko
id = 
NULL

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

¤ ×

Queries: 313, time: 339.977 ms, default

Time msSQL QueryRows
0.740
SET NAMES 'utf8mb4'
.../app/model/DestinationsModel.php:31
0
4.718
SHOW FULL TABLES
.../app/model/DestinationsModel.php:31
156
1.833
SHOW FULL COLUMNS 
FROM `bs_Charakteristika`
.../app/model/DestinationsModel.php:31
4
0.882
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.619
SHOW FULL COLUMNS 
FROM `bs_Counter`
.../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 = '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.207
SHOW FULL COLUMNS 
FROM `bs_Destinace`
.../app/model/DestinationsModel.php:31
3
0.929
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.626
SHOW FULL COLUMNS 
FROM `bs_Hotel`
.../app/model/DestinationsModel.php:31
8
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_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.732
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiDetail`
.../app/model/DestinationsModel.php:31
6
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 =
'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.428
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiFotka`
.../app/model/DestinationsModel.php:31
6
0.793
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.452
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika`
.../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 =
'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.327
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31
4
0.819
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.290
SHOW FULL COLUMNS 
FROM `bs_Oblast`
.../app/model/DestinationsModel.php:31
3
0.741
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.548
SHOW FULL COLUMNS 
FROM `bs_Zajezd`
.../app/model/DestinationsModel.php:31
10
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 = '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.626
SHOW FULL COLUMNS 
FROM `bs_Zajezd2`
.../app/model/DestinationsModel.php:31
10
0.942
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.339
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika`
.../app/model/DestinationsModel.php:31
4
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 =
'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.497
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31
4
0.920
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
2.120
SHOW FULL COLUMNS 
FROM `exim_Hotel`
.../app/model/DestinationsModel.php:31
21
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 = '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.293
SHOW FULL COLUMNS 
FROM `exim_Photo`
.../app/model/DestinationsModel.php:31
4
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 = '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.251
SHOW FULL COLUMNS 
FROM `exim_PriceType`
.../app/model/DestinationsModel.php:31
3
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 =
'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.314
SHOW FULL COLUMNS 
FROM `exim_Update`
.../app/model/DestinationsModel.php:31
6
0.903
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.401
SHOW FULL COLUMNS 
FROM `fti_cenik`
.../app/model/DestinationsModel.php:31
4
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 = '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.389
SHOW FULL COLUMNS 
FROM `kovotour_cena_pokoj`
.../app/model/DestinationsModel.php:31
5
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 =
'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.531
SHOW FULL COLUMNS 
FROM `kovotour_ceny_zajezdu`
.../app/model/DestinationsModel.php:31
9
0.678
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.099
SHOW FULL COLUMNS 
FROM `kovotour_destinace`
.../app/model/DestinationsModel.php:31
3
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 =
'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.122
SHOW FULL COLUMNS 
FROM `kovotour_dopravy_zajezdu`
.../app/model/DestinationsModel.php:31
3
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 =
'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.284
SHOW FULL COLUMNS 
FROM `kovotour_pokoje`
.../app/model/DestinationsModel.php:31
8
0.703
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.111
SHOW FULL COLUMNS 
FROM `kovotour_stanice_zajezdu`
.../app/model/DestinationsModel.php:31
3
0.678
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.066
SHOW FULL COLUMNS 
FROM `kovotour_stravy_zajezdu`
.../app/model/DestinationsModel.php:31
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_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.334
SHOW FULL COLUMNS 
FROM `kovotour_terminy_zajezdu`
.../app/model/DestinationsModel.php:31
6
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_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.301
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_detaily`
.../app/model/DestinationsModel.php:31
10
0.892
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.294
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_foto`
.../app/model/DestinationsModel.php:31
3
0.676
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.326
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_prehled`
.../app/model/DestinationsModel.php:31
4
0.799
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.477
SHOW FULL COLUMNS 
FROM `kt_Cena`
.../app/model/DestinationsModel.php:31
38
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 = '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.625
SHOW FULL COLUMNS 
FROM `kt_CenaPolozky`
.../app/model/DestinationsModel.php:31
17
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 =
'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.212
SHOW FULL COLUMNS 
FROM `kt_Destinace`
.../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_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.292
SHOW FULL COLUMNS 
FROM `kt_Doprava`
.../app/model/DestinationsModel.php:31
4
0.678
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.159
SHOW FULL COLUMNS 
FROM `kt_DopravyCenikovychPolozek`
.../app/model/DestinationsModel.php:31
4
0.656
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.172
SHOW FULL COLUMNS 
FROM `kt_Fotografie`
.../app/model/DestinationsModel.php:31
5
0.705
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.181
SHOW FULL COLUMNS 
FROM `kt_Katalog`
.../app/model/DestinationsModel.php:31
4
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 = '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.406
SHOW FULL COLUMNS 
FROM `kt_Pokoj`
.../app/model/DestinationsModel.php:31
8
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 = '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.232
SHOW FULL COLUMNS 
FROM `kt_PokojeCenikovychPolozek`
.../app/model/DestinationsModel.php:31
4
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_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.440
SHOW FULL COLUMNS 
FROM `kt_Popis`
.../app/model/DestinationsModel.php:31
5
0.851
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.393
SHOW FULL COLUMNS 
FROM `kt_PopisZajezdu`
.../app/model/DestinationsModel.php:31
6
0.771
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.489
SHOW FULL COLUMNS 
FROM `kt_SpojovaciCenaPokoj`
.../app/model/DestinationsModel.php:31
4
0.791
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.342
SHOW FULL COLUMNS 
FROM `kt_SpojovaciDestinacePopis`
.../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 =
'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.299
SHOW FULL COLUMNS 
FROM `kt_SpojovaciTypyProduktuZajezd`
.../app/model/DestinationsModel.php:31
4
0.914
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.459
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDestinace`
.../app/model/DestinationsModel.php:31
5
0.744
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.526
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDoprava`
.../app/model/DestinationsModel.php:31
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_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.282
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdKatalog`
.../app/model/DestinationsModel.php:31
4
0.898
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.511
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStanice`
.../app/model/DestinationsModel.php:31
4
0.800
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.341
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStrava`
.../app/model/DestinationsModel.php:31
5
0.729
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.267
SHOW FULL COLUMNS 
FROM `kt_Stanice`
.../app/model/DestinationsModel.php:31
4

...and more

¤ ×

Unlogged

no identity

¤ ×