Legal

46 queries took 94 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24244
2DESCRIBE `images`12122
3DESCRIBE `categories`992
4DESCRIBE `administrators`11111
5DESCRIBE `administrator_groups`10102
6DESCRIBE `administrator_permissions`772
7DESCRIBE `image_types`772
8DESCRIBE `image_type_versions`11111
9DESCRIBE `layout_blocks`441
10DESCRIBE `layout_block_types`882
11DESCRIBE `containers`442
12DESCRIBE `modules`551
13DESCRIBE `module_types`13131
14DESCRIBE `layout_block_type_containers`992
15DESCRIBE `sidebar_modules`10101
16DESCRIBE `wp_users`10102
17DESCRIBE `account_profiles`46463
18DESCRIBE `marinas`15151
19DESCRIBE `wp_terms`441
20DESCRIBE `wp_term_taxonomy`662
21DESCRIBE `wp_posts`24242
22DESCRIBE `news_events`17172
23DESCRIBE `downloads`11112
24DESCRIBE `special_offers`16162
25DESCRIBE `berthing_charges`11112
26DESCRIBE `account_types`331
27DESCRIBE `account_members`661
28SELECT `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`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = '1' AND `Page`.`status` = 'Enabled' ORDER BY `Page`.`order` ASC 772
29SELECT `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`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE (`Page`.`slug` = 'premier_legal') AND ( `Page`.`status` != 'Deleted') LIMIT 1115
30DESCRIBE `redirects`882
31SELECT `Redirect`.`id`, `Redirect`.`source_url`, `Redirect`.`destination_url`, `Redirect`.`status`, `Redirect`.`created`, `Redirect`.`created_by`, `Redirect`.`modified`, `Redirect`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`administrator_group_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`.`administrator_group_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `redirects` AS `Redirect` LEFT JOIN `administrators` AS `CreatedBy` ON `Redirect`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Redirect`.`modified_by` = `ModifiedBy`.`id` WHERE (`Redirect`.`source_url` = '/pages/premier_legal') AND (`Redirect`.`status` = 'Enabled') LIMIT 1002
32SELECT `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`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE (`Page`.`id` = '539') LIMIT 1112
33SELECT `LayoutBlock`.`id`, `LayoutBlock`.`page_id`, `LayoutBlock`.`order`, `LayoutBlock`.`layout_block_type_id` FROM `layout_blocks` AS `LayoutBlock` WHERE `LayoutBlock`.`page_id` = '539' ORDER BY `LayoutBlock`.`order` ASC112
34SELECT `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` = '1'111
35SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '1432' ORDER BY `Container`.`order` ASC112
36SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '2334' ORDER BY `Module`.`order` ASC112
37SELECT `ModuleType`.`id`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`editable`, `ModuleType`.`browse_url`, `ModuleType`.`model`, `ModuleType`.`class`, `ModuleType`.`section`, `ModuleType`.`status`, `ModuleType`.`created`, `ModuleType`.`created_by`, `ModuleType`.`modified`, `ModuleType`.`modified_by` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`id` = '1'111
38DESCRIBE `text_modules`553
39SELECT `TextModule`.`id`, `TextModule`.`content`, `TextModule`.`image_id`, `TextModule`.`alignment`, `TextModule`.`alt`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `text_modules` AS `TextModule` LEFT JOIN `images` AS `Image` ON `TextModule`.`image_id` = `Image`.`id` WHERE `TextModule`.`id` = '1039' LIMIT 1111
40SELECT `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`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Parent`.`id`, `Parent`.`slug`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`menu_text`, `Parent`.`meta_title`, `Parent`.`meta_description`, `Parent`.`meta_keywords`, `Parent`.`page_heading`, `Parent`.`spotlight_title`, `Parent`.`spotlight_text`, `Parent`.`spotlight_image_id`, `Parent`.`type`, `Parent`.`has_menu`, `Parent`.`content_managed_sidebar`, `Parent`.`simulated_page_id`, `Parent`.`url`, `Parent`.`body_class`, `Parent`.`navigation_style`, `Parent`.`status`, `Parent`.`created`, `Parent`.`created_by`, `Parent`.`modified`, `Parent`.`modified_by` , `SpotlightImage`.`id`, `SpotlightImage`.`name`, `SpotlightImage`.`caption`, `SpotlightImage`.`alt`, `SpotlightImage`.`category_id`, `SpotlightImage`.`image_type_id`, `SpotlightImage`.`extension`, `SpotlightImage`.`status`, `SpotlightImage`.`created`, `SpotlightImage`.`created_by`, `SpotlightImage`.`modified`, `SpotlightImage`.`modified_by`, `SimulatedPage`.`id`, `SimulatedPage`.`slug`, `SimulatedPage`.`parent_id`, `SimulatedPage`.`order`, `SimulatedPage`.`menu_text`, `SimulatedPage`.`meta_title`, `SimulatedPage`.`meta_description`, `SimulatedPage`.`meta_keywords`, `SimulatedPage`.`page_heading`, `SimulatedPage`.`spotlight_title`, `SimulatedPage`.`spotlight_text`, `SimulatedPage`.`spotlight_image_id`, `SimulatedPage`.`type`, `SimulatedPage`.`has_menu`, `SimulatedPage`.`content_managed_sidebar`, `SimulatedPage`.`simulated_page_id`, `SimulatedPage`.`url`, `SimulatedPage`.`body_class`, `SimulatedPage`.`navigation_style`, `SimulatedPage`.`status`, `SimulatedPage`.`created`, `SimulatedPage`.`created_by`, `SimulatedPage`.`modified`, `SimulatedPage`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`administrator_group_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`.`administrator_group_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` LEFT JOIN `images` AS `SpotlightImage` ON `Page`.`spotlight_image_id` = `SpotlightImage`.`id` LEFT JOIN `pages` AS `SimulatedPage` ON `Page`.`simulated_page_id` = `SimulatedPage`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Page`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Page`.`modified_by` = `ModifiedBy`.`id` WHERE (`Page`.`id` = '539') AND ( `Page`.`status` != 'Deleted') LIMIT 1114
41SELECT `Child`.`id`, `Child`.`slug`, `Child`.`parent_id`, `Child`.`order`, `Child`.`menu_text`, `Child`.`meta_title`, `Child`.`meta_description`, `Child`.`meta_keywords`, `Child`.`page_heading`, `Child`.`spotlight_title`, `Child`.`spotlight_text`, `Child`.`spotlight_image_id`, `Child`.`type`, `Child`.`has_menu`, `Child`.`content_managed_sidebar`, `Child`.`simulated_page_id`, `Child`.`url`, `Child`.`body_class`, `Child`.`navigation_style`, `Child`.`status`, `Child`.`created`, `Child`.`created_by`, `Child`.`modified`, `Child`.`modified_by` FROM `pages` AS `Child` WHERE `Child`.`status` <> 'Deleted' AND `Child`.`parent_id` = '539' ORDER BY `Child`.`order` ASC557
42SELECT `SidebarModule`.`id`, `SidebarModule`.`page_id`, `SidebarModule`.`order`, `SidebarModule`.`module_type_id`, `SidebarModule`.`subid`, `SidebarModule`.`status`, `SidebarModule`.`created`, `SidebarModule`.`created_by`, `SidebarModule`.`modified`, `SidebarModule`.`modified_by` FROM `sidebar_modules` AS `SidebarModule` WHERE `SidebarModule`.`page_id` = '539' ORDER BY `SidebarModule`.`order` ASC002
43SELECT `Page`.`navigation_style` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` LEFT JOIN `images` AS `SpotlightImage` ON `Page`.`spotlight_image_id` = `SpotlightImage`.`id` LEFT JOIN `pages` AS `SimulatedPage` ON `Page`.`simulated_page_id` = `SimulatedPage`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Page`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Page`.`modified_by` = `ModifiedBy`.`id` WHERE (`Page`.`id` = '539') LIMIT 1111
44SELECT `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`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Parent`.`id`, `Parent`.`slug`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`menu_text`, `Parent`.`meta_title`, `Parent`.`meta_description`, `Parent`.`meta_keywords`, `Parent`.`page_heading`, `Parent`.`spotlight_title`, `Parent`.`spotlight_text`, `Parent`.`spotlight_image_id`, `Parent`.`type`, `Parent`.`has_menu`, `Parent`.`content_managed_sidebar`, `Parent`.`simulated_page_id`, `Parent`.`url`, `Parent`.`body_class`, `Parent`.`navigation_style`, `Parent`.`status`, `Parent`.`created`, `Parent`.`created_by`, `Parent`.`modified`, `Parent`.`modified_by` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` WHERE (`Page`.`id` = '539') LIMIT 1111
45SELECT `Child`.`id`, `Child`.`slug`, `Child`.`parent_id`, `Child`.`order`, `Child`.`menu_text`, `Child`.`meta_title`, `Child`.`meta_description`, `Child`.`meta_keywords`, `Child`.`page_heading`, `Child`.`spotlight_title`, `Child`.`spotlight_text`, `Child`.`spotlight_image_id`, `Child`.`type`, `Child`.`has_menu`, `Child`.`content_managed_sidebar`, `Child`.`simulated_page_id`, `Child`.`url`, `Child`.`body_class`, `Child`.`navigation_style`, `Child`.`status`, `Child`.`created`, `Child`.`created_by`, `Child`.`modified`, `Child`.`modified_by` FROM `pages` AS `Child` WHERE `Child`.`simulated_page_id` = 0 AND `Child`.`status` = 'Enabled' AND `Child`.`parent_id` = '539' ORDER BY `Child`.`order` ASC556
46SELECT `SidebarModule`.`id`, `SidebarModule`.`page_id`, `SidebarModule`.`order`, `SidebarModule`.`module_type_id`, `SidebarModule`.`subid`, `SidebarModule`.`status`, `SidebarModule`.`created`, `SidebarModule`.`created_by`, `SidebarModule`.`modified`, `SidebarModule`.`modified_by` FROM `sidebar_modules` AS `SidebarModule` WHERE `SidebarModule`.`status` = 'Enabled' AND `SidebarModule`.`page_id` = '539' ORDER BY `SidebarModule`.`order` ASC001