Home

Latest news

Analyst and Investor Central European briefing: 19 June 2008

IPF included in FTSE4Good Index: 06 June 2008

Interim Management Statement: 19 May 2008

View all news

Our Company

For Journalists

Media centre

Corporate Responsibility

Investor tools

78 queries took 187 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `pages`	26	26	5
2	DESCRIBE `images`	13	13	4
3	DESCRIBE `categories`	9	9	3
4	DESCRIBE `administrators`	14	14	4
5	DESCRIBE `administrator_groups`	10	10	3
6	DESCRIBE `administrator_permissions`	7	7	3
7	DESCRIBE `territories`	16	16	3
8	DESCRIBE `countries`	2	2	3
9	DESCRIBE `password_history`	4	4	2
10	DESCRIBE `image_types`	7	7	3
11	DESCRIBE `image_type_versions`	11	11	3
12	DESCRIBE `image_translations`	9	9	4
13	DESCRIBE `layout_blocks`	4	4	2
14	DESCRIBE `layout_block_types`	8	8	4
15	DESCRIBE `containers`	4	4	2
16	DESCRIBE `modules`	5	5	3
17	DESCRIBE `module_types`	15	15	3
18	DESCRIBE `layout_block_type_containers`	9	9	4
19	DESCRIBE `sidebar_modules`	10	10	3
20	SELECT `Territory`.`id`, `Territory`.`name`, `Territory`.`domain`, `Territory`.`locale`, `Territory`.`territory_home_page_id`, `Territory`.`tertiary_parent_page_id`, `Territory`.`media_request_page_id`, `Territory`.`error_page_id`, `Territory`.`date_format`, `Territory`.`country_id`, `Territory`.`general_contact_form_subject_root_category_id`, `Territory`.`status`, `Territory`.`created`, `Territory`.`created_by`, `Territory`.`modified`, `Territory`.`modified_by` FROM `territories` AS `Territory` WHERE `Territory`.`domain` LIKE 'uk.%' AND `Territory`.`status` = 'Enabled' LIMIT 1	1	1	2
21	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = '9' AND `Page`.`status` = 'Enabled' ORDER BY `Page`.`order` ASC	4	4	2
22	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = '29' AND `Page`.`status` = 'Enabled' ORDER BY `Page`.`order` ASC	6	6	3
23	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`id` = 9 LIMIT 1	1	1	3
24	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'home' AND `Page`.`territory_id` = 1 LIMIT 1	1	1	3
25	SELECT `LayoutBlock`.`id`, `LayoutBlock`.`page_id`, `LayoutBlock`.`order`, `LayoutBlock`.`layout_block_type_id` FROM `layout_blocks` AS `LayoutBlock` WHERE `LayoutBlock`.`page_id` IN (9) ORDER BY `LayoutBlock`.`order` ASC	2	2	1
26	SELECT `LayoutBlockType`.`id`, `LayoutBlockType`.`name`, `LayoutBlockType`.`class`, `LayoutBlockType`.`status`, `LayoutBlockType`.`created`, `LayoutBlockType`.`created_by`, `LayoutBlockType`.`modified`, `LayoutBlockType`.`modified_by` FROM `layout_block_types` AS `LayoutBlockType` WHERE `LayoutBlockType`.`id` = 5	1	1	2
27	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` IN (168) ORDER BY `Container`.`order` ASC	3	3	1
28	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` IN (298) ORDER BY `Module`.`order` ASC	1	1	2
29	SELECT `ModuleType`.`id`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`editable`, `ModuleType`.`browse_url`, `ModuleType`.`model`, `ModuleType`.`class`, `ModuleType`.`model_has_class_name`, `ModuleType`.`allowed_in_sidebar`, `ModuleType`.`image_type_id`, `ModuleType`.`status`, `ModuleType`.`created`, `ModuleType`.`created_by`, `ModuleType`.`modified`, `ModuleType`.`modified_by` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`id` = 8	1	1	1
30	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` IN (299) ORDER BY `Module`.`order` ASC	1	1	1
31	SELECT `ModuleType`.`id`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`editable`, `ModuleType`.`browse_url`, `ModuleType`.`model`, `ModuleType`.`class`, `ModuleType`.`model_has_class_name`, `ModuleType`.`allowed_in_sidebar`, `ModuleType`.`image_type_id`, `ModuleType`.`status`, `ModuleType`.`created`, `ModuleType`.`created_by`, `ModuleType`.`modified`, `ModuleType`.`modified_by` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`id` = 6	1	1	2
32	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` IN (300) ORDER BY `Module`.`order` ASC	1	1	1
33	SELECT `ModuleType`.`id`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`editable`, `ModuleType`.`browse_url`, `ModuleType`.`model`, `ModuleType`.`class`, `ModuleType`.`model_has_class_name`, `ModuleType`.`allowed_in_sidebar`, `ModuleType`.`image_type_id`, `ModuleType`.`status`, `ModuleType`.`created`, `ModuleType`.`created_by`, `ModuleType`.`modified`, `ModuleType`.`modified_by` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`id` = 5	1	1	2
34	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` IN (1156) ORDER BY `Container`.`order` ASC	3	3	1
35	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` IN (1930) ORDER BY `Module`.`order` ASC	1	1	2
36	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` IN (1931) ORDER BY `Module`.`order` ASC	1	1	1
37	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` IN (1932) ORDER BY `Module`.`order` ASC	1	1	2
38	SELECT `ModuleType`.`id`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`editable`, `ModuleType`.`browse_url`, `ModuleType`.`model`, `ModuleType`.`class`, `ModuleType`.`model_has_class_name`, `ModuleType`.`allowed_in_sidebar`, `ModuleType`.`image_type_id`, `ModuleType`.`status`, `ModuleType`.`created`, `ModuleType`.`created_by`, `ModuleType`.`modified`, `ModuleType`.`modified_by` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`id` = 9	1	1	1
39	DESCRIBE `promo_modules`	8	8	3
40	DESCRIBE `link_types`	11	11	4
41	DESCRIBE `arbitrary_spotlight_links`	6	6	2
42	DESCRIBE `arbitrary_spotlights`	5	5	3
43	SELECT `PromoModule`.`id`, `PromoModule`.`title`, `PromoModule`.`description`, `PromoModule`.`link_type_id`, `PromoModule`.`subid`, `PromoModule`.`image_id`, `PromoModule`.`link_text`, `PromoModule`.`class_name`, `LinkType`.`id`, `LinkType`.`name`, `LinkType`.`model`, `LinkType`.`class`, `LinkType`.`editable`, `LinkType`.`browse_url`, `LinkType`.`status`, `LinkType`.`created`, `LinkType`.`created_by`, `LinkType`.`modified`, `LinkType`.`modified_by`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`territory_id`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `promo_modules` AS `PromoModule` LEFT JOIN `link_types` AS `LinkType` ON (`PromoModule`.`link_type_id` = `LinkType`.`id`) LEFT JOIN `images` AS `Image` ON (`PromoModule`.`image_id` = `Image`.`id`) WHERE `PromoModule`.`id` = 93 LIMIT 1	1	1	3
44	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`id` = 10 LIMIT 1	1	1	2
45	DESCRIBE `dynamic_modules`	11	11	3
46	SELECT `DynamicModule`.`id`, `DynamicModule`.`name`, `DynamicModule`.`description`, `DynamicModule`.`url`, `DynamicModule`.`class`, `DynamicModule`.`allowed_in_sidebar`, `DynamicModule`.`status`, `DynamicModule`.`created`, `DynamicModule`.`created_by`, `DynamicModule`.`modified`, `DynamicModule`.`modified_by` FROM `dynamic_modules` AS `DynamicModule` WHERE `DynamicModule`.`id` = 3 LIMIT 1	1	1	2
47	DESCRIBE `static_modules`	11	11	3
48	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`allowed_in_sidebar`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = 6 LIMIT 1	1	1	2
49	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`allowed_in_sidebar`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = 8 LIMIT 1	1	1	1
50	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`allowed_in_sidebar`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = 30 LIMIT 1	1	1	2
51	DESCRIBE `link_modules`	4	4	2
52	DESCRIBE `link_module_links`	6	6	3
53	SELECT `LinkModule`.`id`, `LinkModule`.`title`, `LinkModule`.`image_id`, `LinkModule`.`category_id`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`territory_id`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`parent_id`, `Category`.`order`, `Category`.`status`, `Category`.`created`, `Category`.`created_by`, `Category`.`modified`, `Category`.`modified_by` FROM `link_modules` AS `LinkModule` LEFT JOIN `images` AS `Image` ON (`LinkModule`.`image_id` = `Image`.`id`) LEFT JOIN `categories` AS `Category` ON (`LinkModule`.`category_id` = `Category`.`id`) WHERE `LinkModule`.`id` = 32 LIMIT 1	1	1	3
54	SELECT `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`territory_id`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `images` AS `Image` WHERE `Image`.`id` = 173	1	1	1
55	SELECT `ImageTranslation`.`id`, `ImageTranslation`.`image_id`, `ImageTranslation`.`territory_id`, `ImageTranslation`.`alt`, `ImageTranslation`.`caption`, `ImageTranslation`.`created`, `ImageTranslation`.`created_by`, `ImageTranslation`.`modified`, `ImageTranslation`.`modified_by` FROM `image_translations` AS `ImageTranslation` WHERE `ImageTranslation`.`image_id` = 173	0	0	2
56	SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id`, `Category`.`order`, `Category`.`status`, `Category`.`created`, `Category`.`created_by`, `Category`.`modified`, `Category`.`modified_by` FROM `categories` AS `Category` WHERE `Category`.`id` = 11	1	1	1
57	SELECT `LinkModuleLink`.`id`, `LinkModuleLink`.`link_module_id`, `LinkModuleLink`.`order`, `LinkModuleLink`.`link_type_id`, `LinkModuleLink`.`subid`, `LinkModuleLink`.`new_window` FROM `link_module_links` AS `LinkModuleLink` WHERE `LinkModuleLink`.`link_module_id` IN (32) ORDER BY `LinkModuleLink`.`order` ASC	4	4	2
58	SELECT `LinkType`.`id`, `LinkType`.`name`, `LinkType`.`model`, `LinkType`.`class`, `LinkType`.`editable`, `LinkType`.`browse_url`, `LinkType`.`status`, `LinkType`.`created`, `LinkType`.`created_by`, `LinkType`.`modified`, `LinkType`.`modified_by` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1	1	1	1
59	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`id` = 51 LIMIT 1	1	1	2
60	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`id` = 52 LIMIT 1	1	1	2
61	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`id` = 64 LIMIT 1	1	1	1
62	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`id` = 60 LIMIT 1	1	1	2
63	DESCRIBE `news_articles`	13	13	4
64	DESCRIBE `downloads`	12	12	3
65	SELECT `NewsArticle`.`id`, `NewsArticle`.`title`, `NewsArticle`.`summary`, `NewsArticle`.`body`, `NewsArticle`.`publish_date`, `NewsArticle`.`download_id`, `NewsArticle`.`territory_id`, `NewsArticle`.`image_id`, `NewsArticle`.`status`, `NewsArticle`.`created`, `NewsArticle`.`created_by`, `NewsArticle`.`modified`, `NewsArticle`.`modified_by` FROM `news_articles` AS `NewsArticle` WHERE `NewsArticle`.`territory_id` = 1 AND `NewsArticle`.`status` = 'Enabled' AND `NewsArticle`.`publish_date` <= '2010-03-10' ORDER BY `NewsArticle`.`publish_date` DESC LIMIT 3	3	3	4
66	SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`territory_id` = 1 AND `Page`.`type` = 'Dynamic' AND `Page`.`url` = 'news_articles/index' LIMIT 1	1	1	2
67	SELECT `Page`.`parent_id`, `Page`.`type`, `Page`.`order` FROM `pages` AS `Page` WHERE `Page`.`id` = 9 LIMIT 1	1	1	2
68	SELECT `Page`.`parent_id`, `Page`.`type`, `Page`.`order` FROM `pages` AS `Page` WHERE `Page`.`id` = 1 LIMIT 1	1	1	2
69	DESCRIBE `translation_identifiers`	8	8	3
70	DESCRIBE `translations`	9	9	4
71	SELECT `TranslationIdentifier`.`id`, `TranslationIdentifier`.`identifier`, `TranslationIdentifier`.`parameters`, `TranslationIdentifier`.`status`, `TranslationIdentifier`.`created`, `TranslationIdentifier`.`created_by`, `TranslationIdentifier`.`modified`, `TranslationIdentifier`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`last_password_change`, `CreatedBy`.`failed_attempts`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`territory_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`last_password_change`, `ModifiedBy`.`failed_attempts`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`territory_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `translation_identifiers` AS `TranslationIdentifier` LEFT JOIN `administrators` AS `CreatedBy` ON (`TranslationIdentifier`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `administrators` AS `ModifiedBy` ON (`TranslationIdentifier`.`modified_by` = `ModifiedBy`.`id`) WHERE `TranslationIdentifier`.`identifier` = 'Jump to the main menu' LIMIT 1	1	1	2
72	SELECT `Translation`.`id`, `Translation`.`translation_identifier_id`, `Translation`.`translation`, `Translation`.`territory_id`, `Translation`.`status`, `Translation`.`created`, `Translation`.`created_by`, `Translation`.`modified`, `Translation`.`modified_by` FROM `translations` AS `Translation` WHERE `Translation`.`translation_identifier_id` IN (256)	0	0	2
73	SELECT `TranslationIdentifier`.`id`, `TranslationIdentifier`.`identifier`, `TranslationIdentifier`.`parameters`, `TranslationIdentifier`.`status`, `TranslationIdentifier`.`created`, `TranslationIdentifier`.`created_by`, `TranslationIdentifier`.`modified`, `TranslationIdentifier`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`last_password_change`, `CreatedBy`.`failed_attempts`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`territory_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`last_password_change`, `ModifiedBy`.`failed_attempts`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`territory_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `translation_identifiers` AS `TranslationIdentifier` LEFT JOIN `administrators` AS `CreatedBy` ON (`TranslationIdentifier`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `administrators` AS `ModifiedBy` ON (`TranslationIdentifier`.`modified_by` = `ModifiedBy`.`id`) WHERE `TranslationIdentifier`.`identifier` = 'Jump to the main content of the page' LIMIT 1	1	1	2
74	SELECT `Translation`.`id`, `Translation`.`translation_identifier_id`, `Translation`.`translation`, `Translation`.`territory_id`, `Translation`.`status`, `Translation`.`created`, `Translation`.`created_by`, `Translation`.`modified`, `Translation`.`modified_by` FROM `translations` AS `Translation` WHERE `Translation`.`translation_identifier_id` IN (257)	0	0	2
75	SELECT `TranslationIdentifier`.`id`, `TranslationIdentifier`.`identifier`, `TranslationIdentifier`.`parameters`, `TranslationIdentifier`.`status`, `TranslationIdentifier`.`created`, `TranslationIdentifier`.`created_by`, `TranslationIdentifier`.`modified`, `TranslationIdentifier`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`last_password_change`, `CreatedBy`.`failed_attempts`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`territory_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`last_password_change`, `ModifiedBy`.`failed_attempts`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`territory_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `translation_identifiers` AS `TranslationIdentifier` LEFT JOIN `administrators` AS `CreatedBy` ON (`TranslationIdentifier`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `administrators` AS `ModifiedBy` ON (`TranslationIdentifier`.`modified_by` = `ModifiedBy`.`id`) WHERE `TranslationIdentifier`.`identifier` = 'Jump to the top of the page' LIMIT 1	1	1	2
76	SELECT `Translation`.`id`, `Translation`.`translation_identifier_id`, `Translation`.`translation`, `Translation`.`territory_id`, `Translation`.`status`, `Translation`.`created`, `Translation`.`created_by`, `Translation`.`modified`, `Translation`.`modified_by` FROM `translations` AS `Translation` WHERE `Translation`.`translation_identifier_id` IN (258)	0	0	2
77	SELECT `TranslationIdentifier`.`id`, `TranslationIdentifier`.`identifier`, `TranslationIdentifier`.`parameters`, `TranslationIdentifier`.`status`, `TranslationIdentifier`.`created`, `TranslationIdentifier`.`created_by`, `TranslationIdentifier`.`modified`, `TranslationIdentifier`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`last_password_change`, `CreatedBy`.`failed_attempts`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`territory_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`last_password_change`, `ModifiedBy`.`failed_attempts`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`territory_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `translation_identifiers` AS `TranslationIdentifier` LEFT JOIN `administrators` AS `CreatedBy` ON (`TranslationIdentifier`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `administrators` AS `ModifiedBy` ON (`TranslationIdentifier`.`modified_by` = `ModifiedBy`.`id`) WHERE `TranslationIdentifier`.`identifier` = 'Home' LIMIT 1	1	1	3
78	SELECT `Translation`.`id`, `Translation`.`translation_identifier_id`, `Translation`.`translation`, `Translation`.`territory_id`, `Translation`.`status`, `Translation`.`created`, `Translation`.`created_by`, `Translation`.`modified`, `Translation`.`modified_by` FROM `translations` AS `Translation` WHERE `Translation`.`translation_identifier_id` IN (243)	0	0	2

78 queries took 187 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `pages`

DESCRIBE `images`

DESCRIBE `categories`

DESCRIBE `administrators`

DESCRIBE `administrator_groups`

DESCRIBE `administrator_permissions`

DESCRIBE `territories`

DESCRIBE `countries`

DESCRIBE `password_history`

DESCRIBE `image_types`

DESCRIBE `image_type_versions`

DESCRIBE `image_translations`

DESCRIBE `layout_blocks`

DESCRIBE `layout_block_types`

DESCRIBE `containers`

DESCRIBE `modules`

DESCRIBE `module_types`

DESCRIBE `layout_block_type_containers`

DESCRIBE `sidebar_modules`

SELECT `Territory`.`id`, `Territory`.`name`, `Territory`.`domain`, `Territory`.`locale`, `Territory`.`territory_home_page_id`, `Territory`.`tertiary_parent_page_id`, `Territory`.`media_request_page_id`, `Territory`.`error_page_id`, `Territory`.`date_format`, `Territory`.`country_id`, `Territory`.`general_contact_form_subject_root_category_id`, `Territory`.`status`, `Territory`.`created`, `Territory`.`created_by`, `Territory`.`modified`, `Territory`.`modified_by` FROM `territories` AS `Territory` WHERE `Territory`.`domain` LIKE 'uk.%' AND `Territory`.`status` = 'Enabled' LIMIT 1

SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = '9' AND `Page`.`status` = 'Enabled' ORDER BY `Page`.`order` ASC

SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = '29' AND `Page`.`status` = 'Enabled' ORDER BY `Page`.`order` ASC

SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'home' AND `Page`.`territory_id` = 1 LIMIT 1

SELECT `LayoutBlock`.`id`, `LayoutBlock`.`page_id`, `LayoutBlock`.`order`, `LayoutBlock`.`layout_block_type_id` FROM `layout_blocks` AS `LayoutBlock` WHERE `LayoutBlock`.`page_id` IN (9) ORDER BY `LayoutBlock`.`order` ASC

SELECT `LayoutBlockType`.`id`, `LayoutBlockType`.`name`, `LayoutBlockType`.`class`, `LayoutBlockType`.`status`, `LayoutBlockType`.`created`, `LayoutBlockType`.`created_by`, `LayoutBlockType`.`modified`, `LayoutBlockType`.`modified_by` FROM `layout_block_types` AS `LayoutBlockType` WHERE `LayoutBlockType`.`id` = 5

SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` IN (168) ORDER BY `Container`.`order` ASC

SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` IN (298) ORDER BY `Module`.`order` ASC

SELECT `ModuleType`.`id`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`editable`, `ModuleType`.`browse_url`, `ModuleType`.`model`, `ModuleType`.`class`, `ModuleType`.`model_has_class_name`, `ModuleType`.`allowed_in_sidebar`, `ModuleType`.`image_type_id`, `ModuleType`.`status`, `ModuleType`.`created`, `ModuleType`.`created_by`, `ModuleType`.`modified`, `ModuleType`.`modified_by` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`id` = 8

DESCRIBE `promo_modules`

DESCRIBE `link_types`

DESCRIBE `arbitrary_spotlight_links`

DESCRIBE `arbitrary_spotlights`

SELECT `PromoModule`.`id`, `PromoModule`.`title`, `PromoModule`.`description`, `PromoModule`.`link_type_id`, `PromoModule`.`subid`, `PromoModule`.`image_id`, `PromoModule`.`link_text`, `PromoModule`.`class_name`, `LinkType`.`id`, `LinkType`.`name`, `LinkType`.`model`, `LinkType`.`class`, `LinkType`.`editable`, `LinkType`.`browse_url`, `LinkType`.`status`, `LinkType`.`created`, `LinkType`.`created_by`, `LinkType`.`modified`, `LinkType`.`modified_by`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`territory_id`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `promo_modules` AS `PromoModule` LEFT JOIN `link_types` AS `LinkType` ON (`PromoModule`.`link_type_id` = `LinkType`.`id`) LEFT JOIN `images` AS `Image` ON (`PromoModule`.`image_id` = `Image`.`id`) WHERE `PromoModule`.`id` = 93 LIMIT 1

DESCRIBE `dynamic_modules`

SELECT `DynamicModule`.`id`, `DynamicModule`.`name`, `DynamicModule`.`description`, `DynamicModule`.`url`, `DynamicModule`.`class`, `DynamicModule`.`allowed_in_sidebar`, `DynamicModule`.`status`, `DynamicModule`.`created`, `DynamicModule`.`created_by`, `DynamicModule`.`modified`, `DynamicModule`.`modified_by` FROM `dynamic_modules` AS `DynamicModule` WHERE `DynamicModule`.`id` = 3 LIMIT 1

DESCRIBE `static_modules`

SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`allowed_in_sidebar`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = 6 LIMIT 1

DESCRIBE `link_modules`

DESCRIBE `link_module_links`

SELECT `LinkModule`.`id`, `LinkModule`.`title`, `LinkModule`.`image_id`, `LinkModule`.`category_id`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`territory_id`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`parent_id`, `Category`.`order`, `Category`.`status`, `Category`.`created`, `Category`.`created_by`, `Category`.`modified`, `Category`.`modified_by` FROM `link_modules` AS `LinkModule` LEFT JOIN `images` AS `Image` ON (`LinkModule`.`image_id` = `Image`.`id`) LEFT JOIN `categories` AS `Category` ON (`LinkModule`.`category_id` = `Category`.`id`) WHERE `LinkModule`.`id` = 32 LIMIT 1

SELECT `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`territory_id`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `images` AS `Image` WHERE `Image`.`id` = 173

SELECT `ImageTranslation`.`id`, `ImageTranslation`.`image_id`, `ImageTranslation`.`territory_id`, `ImageTranslation`.`alt`, `ImageTranslation`.`caption`, `ImageTranslation`.`created`, `ImageTranslation`.`created_by`, `ImageTranslation`.`modified`, `ImageTranslation`.`modified_by` FROM `image_translations` AS `ImageTranslation` WHERE `ImageTranslation`.`image_id` = 173

SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent_id`, `Category`.`order`, `Category`.`status`, `Category`.`created`, `Category`.`created_by`, `Category`.`modified`, `Category`.`modified_by` FROM `categories` AS `Category` WHERE `Category`.`id` = 11

SELECT `LinkModuleLink`.`id`, `LinkModuleLink`.`link_module_id`, `LinkModuleLink`.`order`, `LinkModuleLink`.`link_type_id`, `LinkModuleLink`.`subid`, `LinkModuleLink`.`new_window` FROM `link_module_links` AS `LinkModuleLink` WHERE `LinkModuleLink`.`link_module_id` IN (32) ORDER BY `LinkModuleLink`.`order` ASC

SELECT `LinkType`.`id`, `LinkType`.`name`, `LinkType`.`model`, `LinkType`.`class`, `LinkType`.`editable`, `LinkType`.`browse_url`, `LinkType`.`status`, `LinkType`.`created`, `LinkType`.`created_by`, `LinkType`.`modified`, `LinkType`.`modified_by` FROM `link_types` AS `LinkType` WHERE `LinkType`.`id` = 1

DESCRIBE `news_articles`

DESCRIBE `downloads`

SELECT `NewsArticle`.`id`, `NewsArticle`.`title`, `NewsArticle`.`summary`, `NewsArticle`.`body`, `NewsArticle`.`publish_date`, `NewsArticle`.`download_id`, `NewsArticle`.`territory_id`, `NewsArticle`.`image_id`, `NewsArticle`.`status`, `NewsArticle`.`created`, `NewsArticle`.`created_by`, `NewsArticle`.`modified`, `NewsArticle`.`modified_by` FROM `news_articles` AS `NewsArticle` WHERE `NewsArticle`.`territory_id` = 1 AND `NewsArticle`.`status` = 'Enabled' AND `NewsArticle`.`publish_date` <= '2010-03-10' ORDER BY `NewsArticle`.`publish_date` DESC LIMIT 3

SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`sub_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`cms_description`, `Page`.`has_secondary_navigation`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`class`, `Page`.`territory_id`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`territory_id` = 1 AND `Page`.`type` = 'Dynamic' AND `Page`.`url` = 'news_articles/index' LIMIT 1

SELECT `Page`.`parent_id`, `Page`.`type`, `Page`.`order` FROM `pages` AS `Page` WHERE `Page`.`id` = 9 LIMIT 1

SELECT `Page`.`parent_id`, `Page`.`type`, `Page`.`order` FROM `pages` AS `Page` WHERE `Page`.`id` = 1 LIMIT 1

DESCRIBE `translation_identifiers`

DESCRIBE `translations`

SELECT `TranslationIdentifier`.`id`, `TranslationIdentifier`.`identifier`, `TranslationIdentifier`.`parameters`, `TranslationIdentifier`.`status`, `TranslationIdentifier`.`created`, `TranslationIdentifier`.`created_by`, `TranslationIdentifier`.`modified`, `TranslationIdentifier`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`last_password_change`, `CreatedBy`.`failed_attempts`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`territory_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`last_password_change`, `ModifiedBy`.`failed_attempts`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`territory_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `translation_identifiers` AS `TranslationIdentifier` LEFT JOIN `administrators` AS `CreatedBy` ON (`TranslationIdentifier`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `administrators` AS `ModifiedBy` ON (`TranslationIdentifier`.`modified_by` = `ModifiedBy`.`id`) WHERE `TranslationIdentifier`.`identifier` = 'Jump to the main menu' LIMIT 1

SELECT `Translation`.`id`, `Translation`.`translation_identifier_id`, `Translation`.`translation`, `Translation`.`territory_id`, `Translation`.`status`, `Translation`.`created`, `Translation`.`created_by`, `Translation`.`modified`, `Translation`.`modified_by` FROM `translations` AS `Translation` WHERE `Translation`.`translation_identifier_id` IN (256)