Time | Duration | Type | Duplicated | Query |
---|---|---|---|---|
11:02:06.480 | 256.1 ms | SELECT | 1 | SELECT * FROM `landings` WHERE `publish`=TRUE |
11:02:06.736 | 7.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `landings` |
11:02:06.745 | 1.7 ms | SELECT | 1 | 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.783 | 7.0 ms | SELECT | 1 | 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.790 | 1.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `cities` |
11:02:06.792 | 1.2 ms | SELECT | 1 | 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.795 | 2.3 ms | SELECT | 1 | 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.798 | 1.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `countries` |
11:02:06.799 | 1.2 ms | SELECT | 1 | 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.801 | 0.9 ms | SELECT | 1 | 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') |