Time ms | SQL Query | Rows |
0.481 |
SET NAMES 'utf8mb4'
.../app/model/PagesModel.php:31 |
0 |
4.208 |
SHOW FULL TABLES
.../app/model/PagesModel.php:31 |
156 |
2.000 |
SHOW FULL COLUMNS
FROM `bs_Charakteristika`
.../app/model/PagesModel.php:31 |
4 |
0.850 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/PagesModel.php:31 |
0 |
1.516 |
SHOW FULL COLUMNS
FROM `bs_Counter`
.../app/model/PagesModel.php:31 |
4 |
0.774 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/PagesModel.php:31 |
0 |
1.080 |
SHOW FULL COLUMNS
FROM `bs_Destinace`
.../app/model/PagesModel.php:31 |
3 |
0.597 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/PagesModel.php:31 |
0 |
1.173 |
SHOW FULL COLUMNS
FROM `bs_Hotel`
.../app/model/PagesModel.php:31 |
8 |
0.482 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/PagesModel.php:31 |
0 |
1.706 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiDetail`
.../app/model/PagesModel.php:31 |
6 |
0.766 explain
|
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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/PagesModel.php:31 |
0 |
1.328 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiFotka`
.../app/model/PagesModel.php:31 |
6 |
0.719 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/PagesModel.php:31 |
0 |
2.317 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiVazbaCharakteristika`
.../app/model/PagesModel.php:31 |
4 |
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 =
'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/PagesModel.php:31 |
0 |
1.389 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiVazbaCharakteristika2`
.../app/model/PagesModel.php:31 |
4 |
0.655 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/PagesModel.php:31 |
0 |
1.288 |
SHOW FULL COLUMNS
FROM `bs_Oblast`
.../app/model/PagesModel.php:31 |
3 |
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 = '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/PagesModel.php:31 |
0 |
1.413 |
SHOW FULL COLUMNS
FROM `bs_Zajezd`
.../app/model/PagesModel.php:31 |
10 |
0.564 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/PagesModel.php:31 |
0 |
1.382 |
SHOW FULL COLUMNS
FROM `bs_Zajezd2`
.../app/model/PagesModel.php:31 |
10 |
0.474 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/PagesModel.php:31 |
0 |
1.177 |
SHOW FULL COLUMNS
FROM `bs_ZajezdVazbaCharakteristika`
.../app/model/PagesModel.php:31 |
4 |
0.455 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/PagesModel.php:31 |
0 |
1.388 |
SHOW FULL COLUMNS
FROM `bs_ZajezdVazbaCharakteristika2`
.../app/model/PagesModel.php:31 |
4 |
0.580 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/PagesModel.php:31 |
0 |
1.633 |
SHOW FULL COLUMNS
FROM `exim_Hotel`
.../app/model/PagesModel.php:31 |
21 |
0.550 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/PagesModel.php:31 |
0 |
1.348 |
SHOW FULL COLUMNS
FROM `exim_Photo`
.../app/model/PagesModel.php:31 |
4 |
0.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 = '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/PagesModel.php:31 |
0 |
1.526 |
SHOW FULL COLUMNS
FROM `exim_PriceType`
.../app/model/PagesModel.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 =
'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/PagesModel.php:31 |
0 |
1.314 |
SHOW FULL COLUMNS
FROM `exim_Update`
.../app/model/PagesModel.php:31 |
6 |
0.702 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/PagesModel.php:31 |
0 |
1.345 |
SHOW FULL COLUMNS
FROM `fti_cenik`
.../app/model/PagesModel.php:31 |
4 |
0.565 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/PagesModel.php:31 |
0 |
1.577 |
SHOW FULL COLUMNS
FROM `kovotour_cena_pokoj`
.../app/model/PagesModel.php:31 |
5 |
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 =
'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/PagesModel.php:31 |
0 |
1.633 |
SHOW FULL COLUMNS
FROM `kovotour_ceny_zajezdu`
.../app/model/PagesModel.php:31 |
9 |
1.001 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/PagesModel.php:31 |
0 |
1.983 |
SHOW FULL COLUMNS
FROM `kovotour_destinace`
.../app/model/PagesModel.php:31 |
3 |
1.110 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/PagesModel.php:31 |
0 |
1.349 |
SHOW FULL COLUMNS
FROM `kovotour_dopravy_zajezdu`
.../app/model/PagesModel.php:31 |
3 |
1.426 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/PagesModel.php:31 |
0 |
2.188 |
SHOW FULL COLUMNS
FROM `kovotour_pokoje`
.../app/model/PagesModel.php:31 |
8 |
0.789 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/PagesModel.php:31 |
0 |
1.213 |
SHOW FULL COLUMNS
FROM `kovotour_stanice_zajezdu`
.../app/model/PagesModel.php:31 |
3 |
0.843 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/PagesModel.php:31 |
0 |
1.475 |
SHOW FULL COLUMNS
FROM `kovotour_stravy_zajezdu`
.../app/model/PagesModel.php:31 |
3 |
1.069 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/PagesModel.php:31 |
0 |
1.767 |
SHOW FULL COLUMNS
FROM `kovotour_terminy_zajezdu`
.../app/model/PagesModel.php:31 |
6 |
0.870 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/PagesModel.php:31 |
0 |
1.930 |
SHOW FULL COLUMNS
FROM `kovotour_zajezdy_detaily`
.../app/model/PagesModel.php:31 |
10 |
1.117 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/PagesModel.php:31 |
0 |
1.676 |
SHOW FULL COLUMNS
FROM `kovotour_zajezdy_foto`
.../app/model/PagesModel.php:31 |
3 |
0.941 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/PagesModel.php:31 |
0 |
1.465 |
SHOW FULL COLUMNS
FROM `kovotour_zajezdy_prehled`
.../app/model/PagesModel.php:31 |
4 |
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 =
'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/PagesModel.php:31 |
0 |
2.974 |
SHOW FULL COLUMNS
FROM `kt_Cena`
.../app/model/PagesModel.php:31 |
38 |
1.000 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/PagesModel.php:31 |
0 |
2.389 |
SHOW FULL COLUMNS
FROM `kt_CenaPolozky`
.../app/model/PagesModel.php:31 |
17 |
0.994 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/PagesModel.php:31 |
0 |
1.952 |
SHOW FULL COLUMNS
FROM `kt_Destinace`
.../app/model/PagesModel.php:31 |
5 |
0.977 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/PagesModel.php:31 |
0 |
1.652 |
SHOW FULL COLUMNS
FROM `kt_Doprava`
.../app/model/PagesModel.php:31 |
4 |
0.820 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/PagesModel.php:31 |
0 |
1.684 |
SHOW FULL COLUMNS
FROM `kt_DopravyCenikovychPolozek`
.../app/model/PagesModel.php:31 |
4 |
0.810 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/PagesModel.php:31 |
0 |
1.896 |
SHOW FULL COLUMNS
FROM `kt_Fotografie`
.../app/model/PagesModel.php:31 |
5 |
0.805 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/PagesModel.php:31 |
0 |
2.081 |
SHOW FULL COLUMNS
FROM `kt_Katalog`
.../app/model/PagesModel.php:31 |
4 |
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 = '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/PagesModel.php:31 |
0 |
1.950 |
SHOW FULL COLUMNS
FROM `kt_Pokoj`
.../app/model/PagesModel.php:31 |
8 |
0.693 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/PagesModel.php:31 |
0 |
2.145 |
SHOW FULL COLUMNS
FROM `kt_PokojeCenikovychPolozek`
.../app/model/PagesModel.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_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/PagesModel.php:31 |
0 |
2.115 |
SHOW FULL COLUMNS
FROM `kt_Popis`
.../app/model/PagesModel.php:31 |
5 |
0.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_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/PagesModel.php:31 |
0 |
1.920 |
SHOW FULL COLUMNS
FROM `kt_PopisZajezdu`
.../app/model/PagesModel.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/PagesModel.php:31 |
0 |
1.512 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciCenaPokoj`
.../app/model/PagesModel.php:31 |
4 |
0.815 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/PagesModel.php:31 |
0 |
1.375 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciDestinacePopis`
.../app/model/PagesModel.php:31 |
4 |
0.789 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/PagesModel.php:31 |
0 |
1.325 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciTypyProduktuZajezd`
.../app/model/PagesModel.php:31 |
4 |
0.765 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/PagesModel.php:31 |
0 |
1.498 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdDestinace`
.../app/model/PagesModel.php:31 |
5 |
0.719 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/PagesModel.php:31 |
0 |
1.540 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdDoprava`
.../app/model/PagesModel.php:31 |
4 |
0.682 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/PagesModel.php:31 |
0 |
1.406 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdKatalog`
.../app/model/PagesModel.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 =
'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/PagesModel.php:31 |
0 |
1.383 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdStanice`
.../app/model/PagesModel.php:31 |
4 |
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_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/PagesModel.php:31 |
0 |
1.366 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdStrava`
.../app/model/PagesModel.php:31 |
5 |
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 =
'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/PagesModel.php:31 |
0 |
10.923 |
SHOW FULL COLUMNS
FROM `kt_Stanice`
.../app/model/PagesModel.php:31 |
4 |