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` = 'nepal' LIMIT 1 | 1 | 1 | 2 | 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` = (16) | 1 | 1 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (16) | 1 | 1 | 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` = (16) ORDER BY `Dataset`.`year` DESC | 9 | 9 | 2 | maybe slow |
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` = 16 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 1 | 1 | 1 | |
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` = 16 | 1 | 1 | 0 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`languages` AS `Language` WHERE 1 = 1 | 6 | 6 | 0 | |
SELECT `Language`.`code`, `Language`.`name` FROM `score-1`.`languages` AS `Language` WHERE 1 = 1 | 6 | 6 | 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 | 4 | maybe slow |
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` = 'nepal')) 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` = (16) | 1 | 1 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (16) | 1 | 1 | 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` = (16) ORDER BY `Dataset`.`year` DESC | 9 | 9 | 0 | |
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` = 16 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 1 | 1 | 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` = 16 AND `Source`.`type` = 'data_translations' ORDER BY `Source`.`id` DESC LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `Country`.`id`, `Country`.`name`, `Country`.`url_param`, `Country`.`parent_id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`parent_id` = 16 | 0 | 0 | 0 | |
SELECT `Country`.`id`, `Country`.`name` FROM `score-1`.`countries` AS `Country` WHERE 1 = 1 | 18 | 18 | 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` = 'nepal' 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` = (16) | 1 | 1 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (16) | 1 | 1 | 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` = (16) ORDER BY `Dataset`.`year` DESC | 9 | 9 | 0 | |
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` = 16 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 1 | 1 | 0 | |
SELECT `Country`.`id`, `Country`.`name` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`in_menu` = "1" AND `Country`.`is_published` = "1" | 9 | 9 | 0 | |
SELECT `Publication`.`id`, `Publication`.`country_id`, `Publication`.`year`, `Publication`.`group_id`, `Publication`.`type_id`, `Publication`.`dir`, `Publication`.`pub_file`, `Publication`.`pub_thumb`, `Publication`.`language_code`, `Publication`.`created`, `Publication`.`modified`, `Publication`.`is_published`, `Publication`.`title`, `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`.`publications` AS `Publication` LEFT JOIN `score-1`.`countries` AS `Country` ON (`Publication`.`country_id` = `Country`.`id`) WHERE `Publication`.`is_published` = 1 AND `Publication`.`language_code` = "en" AND ((`Publication`.`country_id` = "16") OR (`Publication`.`country_id` IS NULL)) ORDER BY `Publication`.`year` desc, `Publication`.`created` desc LIMIT 1000 | 8 | 8 | 1 | maybe slow |