Zvolená destinace není k dispozici.

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

System info

Execution time1 630.0 ms
Peak of allocated memory6.66 MB
Included files130
Classes + interfaces + traits283 + 44 + 0
Your IP216.73.216.238
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: 568.258 ms, default

Time msSQL QueryRows
0.715
SET NAMES 'utf8mb4'
.../app/model/DestinationsModel.php:31
0
5.301
SHOW FULL TABLES
.../app/model/DestinationsModel.php:31
156
1.975
SHOW FULL COLUMNS 
FROM `bs_Charakteristika`
.../app/model/DestinationsModel.php:31
4
1.346
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
2.649
SHOW FULL COLUMNS 
FROM `bs_Counter`
.../app/model/DestinationsModel.php:31
4
1.391
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
2.034
SHOW FULL COLUMNS 
FROM `bs_Destinace`
.../app/model/DestinationsModel.php:31
3
1.328
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
2.004
SHOW FULL COLUMNS 
FROM `bs_Hotel`
.../app/model/DestinationsModel.php:31
8
1.220
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.635
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiDetail`
.../app/model/DestinationsModel.php:31
6
1.058
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.946
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiFotka`
.../app/model/DestinationsModel.php:31
6
1.222
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.383
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika`
.../app/model/DestinationsModel.php:31
4
1.450
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.385
SHOW FULL COLUMNS 
FROM `bs_HotelObdobiVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31
4
3.150
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.972
SHOW FULL COLUMNS 
FROM `bs_Oblast`
.../app/model/DestinationsModel.php:31
3
1.134
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.217
SHOW FULL COLUMNS 
FROM `bs_Zajezd`
.../app/model/DestinationsModel.php:31
10
5.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_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
2.740
SHOW FULL COLUMNS 
FROM `bs_Zajezd2`
.../app/model/DestinationsModel.php:31
10
1.885
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
2.300
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika`
.../app/model/DestinationsModel.php:31
4
2.100
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
2.187
SHOW FULL COLUMNS 
FROM `bs_ZajezdVazbaCharakteristika2`
.../app/model/DestinationsModel.php:31
4
1.096
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.731
SHOW FULL COLUMNS 
FROM `exim_Hotel`
.../app/model/DestinationsModel.php:31
21
1.031
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.964
SHOW FULL COLUMNS 
FROM `exim_Photo`
.../app/model/DestinationsModel.php:31
4
2.982
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.775
SHOW FULL COLUMNS 
FROM `exim_PriceType`
.../app/model/DestinationsModel.php:31
3
1.548
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.969
SHOW FULL COLUMNS 
FROM `exim_Update`
.../app/model/DestinationsModel.php:31
6
1.222
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.972
SHOW FULL COLUMNS 
FROM `fti_cenik`
.../app/model/DestinationsModel.php:31
4
1.201
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
2.129
SHOW FULL COLUMNS 
FROM `kovotour_cena_pokoj`
.../app/model/DestinationsModel.php:31
5
1.183
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.949
SHOW FULL COLUMNS 
FROM `kovotour_ceny_zajezdu`
.../app/model/DestinationsModel.php:31
9
0.931
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.789
SHOW FULL COLUMNS 
FROM `kovotour_destinace`
.../app/model/DestinationsModel.php:31
3
0.877
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.656
SHOW FULL COLUMNS 
FROM `kovotour_dopravy_zajezdu`
.../app/model/DestinationsModel.php:31
3
1.452
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
2.293
SHOW FULL COLUMNS 
FROM `kovotour_pokoje`
.../app/model/DestinationsModel.php:31
8
0.992
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.967
SHOW FULL COLUMNS 
FROM `kovotour_stanice_zajezdu`
.../app/model/DestinationsModel.php:31
3
1.579
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.550
SHOW FULL COLUMNS 
FROM `kovotour_stravy_zajezdu`
.../app/model/DestinationsModel.php:31
3
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 =
'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
2.756
SHOW FULL COLUMNS 
FROM `kovotour_terminy_zajezdu`
.../app/model/DestinationsModel.php:31
6
2.298
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
3.677
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_detaily`
.../app/model/DestinationsModel.php:31
10
8.165
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.971
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_foto`
.../app/model/DestinationsModel.php:31
3
1.543
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
4.476
SHOW FULL COLUMNS 
FROM `kovotour_zajezdy_prehled`
.../app/model/DestinationsModel.php:31
4
1.216
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
5.608
SHOW FULL COLUMNS 
FROM `kt_Cena`
.../app/model/DestinationsModel.php:31
38
1.081
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
4.204
SHOW FULL COLUMNS 
FROM `kt_CenaPolozky`
.../app/model/DestinationsModel.php:31
17
1.273
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
3.061
SHOW FULL COLUMNS 
FROM `kt_Destinace`
.../app/model/DestinationsModel.php:31
5
0.901
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.679
SHOW FULL COLUMNS 
FROM `kt_Doprava`
.../app/model/DestinationsModel.php:31
4
1.085
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.965
SHOW FULL COLUMNS 
FROM `kt_DopravyCenikovychPolozek`
.../app/model/DestinationsModel.php:31
4
1.463
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
3.212
SHOW FULL COLUMNS 
FROM `kt_Fotografie`
.../app/model/DestinationsModel.php:31
5
3.113
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.863
SHOW FULL COLUMNS 
FROM `kt_Katalog`
.../app/model/DestinationsModel.php:31
4
1.883
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
3.278
SHOW FULL COLUMNS 
FROM `kt_Pokoj`
.../app/model/DestinationsModel.php:31
8
1.185
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
2.001
SHOW FULL COLUMNS 
FROM `kt_PokojeCenikovychPolozek`
.../app/model/DestinationsModel.php:31
4
1.315
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
2.244
SHOW FULL COLUMNS 
FROM `kt_Popis`
.../app/model/DestinationsModel.php:31
5
1.080
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
2.146
SHOW FULL COLUMNS 
FROM `kt_PopisZajezdu`
.../app/model/DestinationsModel.php:31
6
1.734
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
2.133
SHOW FULL COLUMNS 
FROM `kt_SpojovaciCenaPokoj`
.../app/model/DestinationsModel.php:31
4
1.483
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
2.105
SHOW FULL COLUMNS 
FROM `kt_SpojovaciDestinacePopis`
.../app/model/DestinationsModel.php:31
4
1.281
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.903
SHOW FULL COLUMNS 
FROM `kt_SpojovaciTypyProduktuZajezd`
.../app/model/DestinationsModel.php:31
4
1.179
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.631
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDestinace`
.../app/model/DestinationsModel.php:31
5
1.027
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
2.048
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdDoprava`
.../app/model/DestinationsModel.php:31
4
0.934
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.923
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdKatalog`
.../app/model/DestinationsModel.php:31
4
1.094
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
2.078
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStanice`
.../app/model/DestinationsModel.php:31
4
1.281
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
2.196
SHOW FULL COLUMNS 
FROM `kt_SpojovaciZajezdStrava`
.../app/model/DestinationsModel.php:31
5
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 =
'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.834
SHOW FULL COLUMNS 
FROM `kt_Stanice`
.../app/model/DestinationsModel.php:31
4

...and more

¤ ×

Unlogged

no identity

¤ ×