Time ms | SQL Query | Rows |
0.501 |
SET NAMES 'utf8mb4'
.../app/model/PagesModel.php:31 |
0 |
4.083 |
SHOW FULL TABLES
.../app/model/PagesModel.php:31 |
156 |
1.543 |
SHOW FULL COLUMNS
FROM `bs_Charakteristika`
.../app/model/PagesModel.php:31 |
4 |
1.044 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.576 |
SHOW FULL COLUMNS
FROM `bs_Counter`
.../app/model/PagesModel.php:31 |
4 |
0.905 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.472 |
SHOW FULL COLUMNS
FROM `bs_Destinace`
.../app/model/PagesModel.php:31 |
3 |
0.830 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.760 |
SHOW FULL COLUMNS
FROM `bs_Hotel`
.../app/model/PagesModel.php:31 |
8 |
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 = '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.496 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiDetail`
.../app/model/PagesModel.php:31 |
6 |
0.784 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.369 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiFotka`
.../app/model/PagesModel.php:31 |
6 |
0.769 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 |
1.233 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiVazbaCharakteristika`
.../app/model/PagesModel.php:31 |
4 |
0.760 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.449 |
SHOW FULL COLUMNS
FROM `bs_HotelObdobiVazbaCharakteristika2`
.../app/model/PagesModel.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 =
'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.185 |
SHOW FULL COLUMNS
FROM `bs_Oblast`
.../app/model/PagesModel.php:31 |
3 |
0.770 explain
|
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME = '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.501 |
SHOW FULL COLUMNS
FROM `bs_Zajezd`
.../app/model/PagesModel.php:31 |
10 |
0.701 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.439 |
SHOW FULL COLUMNS
FROM `bs_Zajezd2`
.../app/model/PagesModel.php:31 |
10 |
0.772 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.198 |
SHOW FULL COLUMNS
FROM `bs_ZajezdVazbaCharakteristika`
.../app/model/PagesModel.php:31 |
4 |
0.706 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.144 |
SHOW FULL COLUMNS
FROM `bs_ZajezdVazbaCharakteristika2`
.../app/model/PagesModel.php:31 |
4 |
0.690 explain
|
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'bs_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 |
2.006 |
SHOW FULL COLUMNS
FROM `exim_Hotel`
.../app/model/PagesModel.php:31 |
21 |
0.952 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.318 |
SHOW FULL COLUMNS
FROM `exim_Photo`
.../app/model/PagesModel.php:31 |
4 |
0.894 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.901 |
SHOW FULL COLUMNS
FROM `exim_PriceType`
.../app/model/PagesModel.php:31 |
3 |
0.865 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.538 |
SHOW FULL COLUMNS
FROM `exim_Update`
.../app/model/PagesModel.php:31 |
6 |
0.806 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.478 |
SHOW FULL COLUMNS
FROM `fti_cenik`
.../app/model/PagesModel.php:31 |
4 |
0.760 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.992 |
SHOW FULL COLUMNS
FROM `kovotour_cena_pokoj`
.../app/model/PagesModel.php:31 |
5 |
2.925 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 |
3.766 |
SHOW FULL COLUMNS
FROM `kovotour_ceny_zajezdu`
.../app/model/PagesModel.php:31 |
9 |
0.997 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.929 |
SHOW FULL COLUMNS
FROM `kovotour_destinace`
.../app/model/PagesModel.php:31 |
3 |
1.039 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 |
2.105 |
SHOW FULL COLUMNS
FROM `kovotour_dopravy_zajezdu`
.../app/model/PagesModel.php:31 |
3 |
0.983 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 |
1.984 |
SHOW FULL COLUMNS
FROM `kovotour_pokoje`
.../app/model/PagesModel.php:31 |
8 |
0.889 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.800 |
SHOW FULL COLUMNS
FROM `kovotour_stanice_zajezdu`
.../app/model/PagesModel.php:31 |
3 |
0.838 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.471 |
SHOW FULL COLUMNS
FROM `kovotour_stravy_zajezdu`
.../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_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 |
16.444 |
SHOW FULL COLUMNS
FROM `kovotour_terminy_zajezdu`
.../app/model/PagesModel.php:31 |
6 |
1.158 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 |
16.003 |
SHOW FULL COLUMNS
FROM `kovotour_zajezdy_detaily`
.../app/model/PagesModel.php:31 |
10 |
0.912 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 |
15.691 |
SHOW FULL COLUMNS
FROM `kovotour_zajezdy_foto`
.../app/model/PagesModel.php:31 |
3 |
1.556 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 |
15.644 |
SHOW FULL COLUMNS
FROM `kovotour_zajezdy_prehled`
.../app/model/PagesModel.php:31 |
4 |
0.879 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 |
16.307 |
SHOW FULL COLUMNS
FROM `kt_Cena`
.../app/model/PagesModel.php:31 |
38 |
0.987 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.567 |
SHOW FULL COLUMNS
FROM `kt_CenaPolozky`
.../app/model/PagesModel.php:31 |
17 |
1.072 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.751 |
SHOW FULL COLUMNS
FROM `kt_Destinace`
.../app/model/PagesModel.php:31 |
5 |
1.099 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.502 |
SHOW FULL COLUMNS
FROM `kt_Doprava`
.../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_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.327 |
SHOW FULL COLUMNS
FROM `kt_DopravyCenikovychPolozek`
.../app/model/PagesModel.php:31 |
4 |
1.046 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.318 |
SHOW FULL COLUMNS
FROM `kt_Fotografie`
.../app/model/PagesModel.php:31 |
5 |
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_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 |
1.267 |
SHOW FULL COLUMNS
FROM `kt_Katalog`
.../app/model/PagesModel.php:31 |
4 |
0.747 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 |
2.338 |
SHOW FULL COLUMNS
FROM `kt_Pokoj`
.../app/model/PagesModel.php:31 |
8 |
0.772 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 |
1.544 |
SHOW FULL COLUMNS
FROM `kt_PokojeCenikovychPolozek`
.../app/model/PagesModel.php:31 |
4 |
0.727 explain
|
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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 |
1.576 |
SHOW FULL COLUMNS
FROM `kt_Popis`
.../app/model/PagesModel.php:31 |
5 |
0.706 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.410 |
SHOW FULL COLUMNS
FROM `kt_PopisZajezdu`
.../app/model/PagesModel.php:31 |
6 |
0.699 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.433 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciCenaPokoj`
.../app/model/PagesModel.php:31 |
4 |
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 =
'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.490 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciDestinacePopis`
.../app/model/PagesModel.php:31 |
4 |
0.697 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.529 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciTypyProduktuZajezd`
.../app/model/PagesModel.php:31 |
4 |
0.739 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.544 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdDestinace`
.../app/model/PagesModel.php:31 |
5 |
0.737 explain
|
SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL AND TABLE_NAME =
'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.507 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdDoprava`
.../app/model/PagesModel.php:31 |
4 |
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 =
'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.610 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdKatalog`
.../app/model/PagesModel.php:31 |
4 |
0.916 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.673 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdStanice`
.../app/model/PagesModel.php:31 |
4 |
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 =
'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.464 |
SHOW FULL COLUMNS
FROM `kt_SpojovaciZajezdStrava`
.../app/model/PagesModel.php:31 |
5 |
0.679 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 |
1.669 |
SHOW FULL COLUMNS
FROM `kt_Stanice`
.../app/model/PagesModel.php:31 |
4 |