Database Queries

Всього 10 записів.
TimeDurationTypeDuplicatedQuery
   
11:02:06.480256.1 msSELECT1
SELECT * FROM `landings` WHERE `publish`=TRUE

11:02:06.7367.4 msSHOW1
SHOW FULL COLUMNS FROM `landings`
11:02:06.7451.7 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'landings' AND kcu.table_name = 'landings'

11:02:06.7837.0 msSELECT1
SELECT * FROM `cities` WHERE `code` IN ('ALC', 'BCN', 'BUS', 'CTA', 'LCA', 'NAP', 'ODS', 'PMI', 'TAT', 'SOF', 'TBS', 'TCI', 'RMI', 'HRK', 'FAO', 'EVN', 'BOJ', 'VAR', 'PAR', 'NCE', 'PUY', 'KUT', 'IEV', 'LIS', 'PED', 'TRN', 'PRG', 'TLV', 'LWO', 'OZH', 'SZG', 'IST', 'DXB', 'ZNZ', 'ASR', 'BER', 'CMB', 'TAS', 'CPH', 'BTS', 'STR', 'DUS', 'HAM', 'FMM', 'BRQ', 'OSR', 'MLA', 'HAJ', 'LCJ', 'KTW', 'MRS', 'ALA', 'BEG', 'TIA', 'HER', 'RHO', 'AMM', 'TIV', 'DBV', 'SKG', 'FNC', 'MAD', 'DMM', 'JED', 'RUH', 'SPU', 'RKT', 'CFU', 'ATH', 'BAK', 'VNO', 'ROM', 'ZTH', 'BAH', 'KGS', 'MCT', 'VLC', 'MIR', 'VIE', 'BJV', 'KWI', 'SUF', 'DLM', 'LYS', 'AGP', 'MUC', 'BGY')

11:02:06.7901.5 msSHOW1
SHOW FULL COLUMNS FROM `cities`
11:02:06.7921.2 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'cities' AND kcu.table_name = 'cities'

11:02:06.7952.3 msSELECT1
SELECT * FROM `countries` WHERE `code` IN ('ES', 'GE', 'IT', 'CY', 'UA', 'SK', 'BG', 'PT', 'AM', 'FR', 'HR', 'AE', 'CZ', 'AT', 'IL', 'TR', 'TZ', 'DE', 'LK', 'UZ', 'DK', 'MT', 'PL', 'KZ', 'RS', 'AL', 'GR', 'JO', 'ME', 'SA', 'AZ', 'LT', 'BH', 'OM', 'TN', 'KW')

11:02:06.7981.4 msSHOW1
SHOW FULL COLUMNS FROM `countries`
11:02:06.7991.2 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'countries' AND kcu.table_name = 'countries'

11:02:06.8010.9 msSELECT1
SELECT * FROM `cities` WHERE `code` IN ('IEV', 'ODS', 'OZH', 'LWO', 'ALA', 'HRK', 'IST', 'DMM', 'LCJ', 'PRG', 'JED', 'RUH', 'BUS', 'BCN', 'EVN', 'ALC', 'TBS', 'LIS', 'DXB', 'PAR', 'TLV', 'TAS', 'MAD', 'LCA', 'SOF', 'RKT', 'TAT', 'NAP', 'BGY', 'AGP', 'ATH')