Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = 'use' LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (33) | 5 | 5 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (33) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 1 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id`, `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`countries_languages` AS `CountryLanguage` LEFT JOIN `score-1`.`languages` AS `Language` ON (`CountryLanguage`.`language_id` = `Language`.`id`) WHERE `CountryLanguage`.`country_id` = 33 | 3 | 3 | 0 | |
SELECT `Country`.`url_param`, `Country`.`name`, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`in_menu` = '1' AND `Country`.`is_published` = '1' ORDER BY `Country`.`weight` ASC | 9 | 9 | 0 | |
SELECT Country.id,Country.keywords,Country.description,Country.name,Country.title,Country.logos,Country.data_translations,Country.show_pages,Country.parent_id,Country.svg_map, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE ((`Country`.`id` IS NULL) OR (`Country`.`url_param` = 'use')) LIMIT 1 | 1 | 1 | 0 | |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (33) | 5 | 5 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (33) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 1 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards`, `Source`.`id`, `Source`.`url`, `Source`.`html`, `Source`.`source`, `Source`.`name`, `Source`.`type`, (url) AS `Source__source_path` FROM `score-1`.`datasets` AS `Dataset` LEFT JOIN `score-1`.`sources` AS `Source` ON (`Dataset`.`source_id` = `Source`.`id`) WHERE `country` = 33 AND `Source`.`type` = 'data_translations' ORDER BY `Source`.`id` DESC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Country`.`id`, `Country`.`name`, `Country`.`url_param`, `Country`.`parent_id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`parent_id` = 33 | 2 | 2 | 0 | |
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = 'use' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (33) | 5 | 5 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (33) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 1 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 0 | |
SELECT `SimplePage`.`id`, `SimplePage`.`country_id`, `SimplePage`.`code`, `SimplePage`.`title`, `SimplePage`.`key`, `SimplePage`.`content`, `SimplePage`.`created`, `SimplePage`.`modified`, `SimplePage`.`is_active`, `SimplePage`.`keywords`, `SimplePage`.`description`, (`I18n__contentTranslation`.`content`) AS `SimplePage__i18n_contentTranslation`, (`I18n__titleTranslation`.`content`) AS `SimplePage__i18n_titleTranslation`, (`I18n__keywordsTranslation`.`content`) AS `SimplePage__i18n_keywordsTranslation`, (`I18n__descriptionTranslation`.`content`) AS `SimplePage__i18n_descriptionTranslation`, `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`simple_pages` AS `SimplePage` LEFT JOIN `score-1`.`countries` AS `Country` ON (`SimplePage`.`country_id` = `Country`.`id`) INNER JOIN `score-1`.`i18n` AS `I18n__contentTranslation` ON (`SimplePage`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'SimplePage' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__titleTranslation` ON (`SimplePage`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'SimplePage' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__keywordsTranslation` ON (`SimplePage`.`id` = `I18n__keywordsTranslation`.`foreign_key` AND `I18n__keywordsTranslation`.`model` = 'SimplePage' AND `I18n__keywordsTranslation`.`field` = 'keywords' AND `I18n__keywordsTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__descriptionTranslation` ON (`SimplePage`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'SimplePage' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'en') WHERE `SimplePage`.`code` = 'contact' AND `SimplePage`.`country_id` = 33 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `score-1`.`i18n` AS `contentTranslation` WHERE `model` = 'SimplePage' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (46) | 3 | 3 | 0 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `score-1`.`i18n` AS `titleTranslation` WHERE `model` = 'SimplePage' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (46) | 3 | 3 | 0 | |
SELECT `keywordsTranslation`.`id`, `keywordsTranslation`.`locale`, `keywordsTranslation`.`model`, `keywordsTranslation`.`foreign_key`, `keywordsTranslation`.`field`, `keywordsTranslation`.`content` FROM `score-1`.`i18n` AS `keywordsTranslation` WHERE `model` = 'SimplePage' AND `field` = 'keywords' AND `keywordsTranslation`.`foreign_key` = (46) | 3 | 3 | 0 | |
SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `score-1`.`i18n` AS `descriptionTranslation` WHERE `model` = 'SimplePage' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (46) | 3 | 3 | 0 | |