Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `PageElement`.`id`, `PageElement`.`parent_id`, `PageElement`.`user_id`, `PageElement`.`name`, `PageElement`.`description`, `PageElement`.`path`, `PageElement`.`html`, `PageElement`.`status`, `PageElement`.`hidden`, `PageElement`.`active`, `PageElement`.`created`, `PageElement`.`modified` FROM `u706517901_creekside`.`cms_page_elements` AS `PageElement` WHERE `PageElement`.`status` = 'publish' ORDER BY `PageElement`.`name` asc | 5 | 5 | 0 | |
SELECT `Setting`.`id`, `Setting`.`group`, `Setting`.`key`, `Setting`.`value`, `Setting`.`boolean`, `Setting`.`data` FROM `u706517901_creekside`.`cms_settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`group` ASC | 53 | 53 | 0 | |
SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`url`, `Page`.`type` FROM `u706517901_creekside`.`cms_pages` AS `Page` WHERE `status` = 'publish' ORDER BY `parent_id` ASC, `order` ASC | 5 | 5 | 0 | |
SELECT `Page`.`id` FROM `u706517901_creekside`.`cms_pages` AS `Page` WHERE `url` = 'history' AND `status` = 'publish' AND `active` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id`, `Page`.`user_id`, `Page`.`name`, `Page`.`title`, `Page`.`url`, `Page`.`description`, `Page`.`keywords`, `Page`.`seo_rating`, `Page`.`content`, `Page`.`template`, `Page`.`menu_title`, `Page`.`parent_id`, `Page`.`in_nav`, `Page`.`is_index`, `Page`.`order`, `Page`.`status`, `Page`.`type`, `Page`.`active`, `Page`.`page_scripts`, `Page`.`created`, `Page`.`modified`, (`Page`.`url`) AS `Page__short_url`, (IF(`Page`.`target` <=> "" or `Page`.`target` <=> null, "_self", `Page`.`target`)) AS `Page__target` FROM `u706517901_creekside`.`cms_pages` AS `Page` WHERE `Page`.`id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id`, `Page`.`user_id`, `Page`.`name`, `Page`.`title`, `Page`.`url`, `Page`.`description`, `Page`.`keywords`, `Page`.`seo_rating`, `Page`.`content`, `Page`.`template`, `Page`.`menu_title`, `Page`.`parent_id`, `Page`.`in_nav`, `Page`.`is_index`, `Page`.`order`, `Page`.`status`, `Page`.`type`, `Page`.`active`, `Page`.`page_scripts`, `Page`.`created`, `Page`.`modified`, (`Page`.`url`) AS `Page__short_url`, (IF(`Page`.`target` <=> "" or `Page`.`target` <=> null, "_self", `Page`.`target`)) AS `Page__target` FROM `u706517901_creekside`.`cms_pages` AS `Page` WHERE `Page`.`active` = 1 AND `Page`.`parent_id` != 0 AND ((`Page`.`parent_id` = 9) OR (`Page`.`parent_id` = 0)) | 0 | 0 | 0 | |
SELECT `PageElement`.`id`, `PageElement`.`parent_id`, `PageElement`.`user_id`, `PageElement`.`name`, `PageElement`.`description`, `PageElement`.`path`, `PageElement`.`html`, `PageElement`.`status`, `PageElement`.`hidden`, `PageElement`.`active`, `PageElement`.`created`, `PageElement`.`modified` FROM `u706517901_creekside`.`cms_page_elements` AS `PageElement` WHERE `PageElement`.`status` = 'publish' ORDER BY `PageElement`.`name` asc | 5 | 5 | 0 | |
SELECT `Setting`.`id`, `Setting`.`group`, `Setting`.`key`, `Setting`.`value`, `Setting`.`boolean`, `Setting`.`data` FROM `u706517901_creekside`.`cms_settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`group` ASC | 53 | 53 | 0 | |
SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`type`, `Page`.`name`, `Page`.`title`, `Page`.`order`, `Page`.`active`, `Page`.`in_nav`, `Page`.`url`, (IF(`Page`.`target` <=> "" or `Page`.`target` <=> null, "_self", `Page`.`target`)) AS `Page__target` FROM `u706517901_creekside`.`cms_pages` AS `Page` WHERE `Page`.`in_nav` = '1' AND `Page`.`status` = 'publish' AND `Page`.`active` = 1 ORDER BY `Page`.`parent_id` ASC, `Page`.`order` ASC | 5 | 5 | 0 | |
SELECT COUNT(*) AS `count` FROM `u706517901_creekside`.`cms_pages` AS `Page` WHERE `Page`.`url` = 'hero_images' AND `Page`.`status` = 'publish' AND `Page`.`active` = 1 | 1 | 1 | 0 | |
SELECT `PageElement`.`id`, `PageElement`.`parent_id`, `PageElement`.`user_id`, `PageElement`.`name`, `PageElement`.`description`, `PageElement`.`path`, `PageElement`.`html`, `PageElement`.`status`, `PageElement`.`hidden`, `PageElement`.`active`, `PageElement`.`created`, `PageElement`.`modified` FROM `u706517901_creekside`.`cms_page_elements` AS `PageElement` WHERE `PageElement`.`status` = 'publish' ORDER BY `PageElement`.`name` asc | 5 | 5 | 0 | |
SELECT `Setting`.`id`, `Setting`.`group`, `Setting`.`key`, `Setting`.`value`, `Setting`.`boolean`, `Setting`.`data` FROM `u706517901_creekside`.`cms_settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`group` ASC | 53 | 53 | 0 | |
SELECT COUNT(*) AS `count` FROM `u706517901_creekside`.`hero_manager_hero_page_settings` AS `HeroPageSetting` WHERE `page_id` = 9 AND `key` = 'slider' AND `value` IN ('1', 'true') | 1 | 1 | 0 | |
SELECT `Page`.`id`, `Page`.`user_id`, `Page`.`name`, `Page`.`title`, `Page`.`url`, `Page`.`description`, `Page`.`keywords`, `Page`.`seo_rating`, `Page`.`content`, `Page`.`template`, `Page`.`menu_title`, `Page`.`parent_id`, `Page`.`in_nav`, `Page`.`is_index`, `Page`.`order`, `Page`.`status`, `Page`.`type`, `Page`.`active`, `Page`.`page_scripts`, `Page`.`created`, `Page`.`modified`, (`Page`.`url`) AS `Page__short_url`, (IF(`Page`.`target` <=> "" or `Page`.`target` <=> null, "_self", `Page`.`target`)) AS `Page__target` FROM `u706517901_creekside`.`cms_pages` AS `Page` WHERE `Page`.`id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `u706517901_creekside`.`hero_manager_hero_page_settings` AS `HeroPageSetting` WHERE `page_id` = 9 AND `key` = 'slider' AND `value` IN ('1', 'true') | 1 | 1 | 0 | |
SELECT `HeroImagesPage`.`id`, `HeroImagesPage`.`page_id`, `HeroImagesPage`.`hero_image_id`, `HeroImage`.`id`, `HeroImage`.`name`, `HeroImage`.`filename`, `HeroImage`.`type`, `HeroImage`.`size`, `HeroImage`.`title`, `HeroImage`.`content`, `HeroImage`.`link`, `HeroImage`.`primary`, `HeroImage`.`default`, `HeroImage`.`status`, `HeroImage`.`created`, `HeroImage`.`modified`, (LPAD(`HeroImage`.`id`, 6, "0")) AS `HeroImage___dir`, `Page`.`id`, `Page`.`user_id`, `Page`.`name`, `Page`.`title`, `Page`.`url`, `Page`.`description`, `Page`.`keywords`, `Page`.`seo_rating`, `Page`.`content`, `Page`.`template`, `Page`.`menu_title`, `Page`.`parent_id`, `Page`.`in_nav`, `Page`.`is_index`, `Page`.`order`, `Page`.`status`, `Page`.`type`, `Page`.`active`, `Page`.`page_scripts`, `Page`.`created`, `Page`.`modified`, (`Page`.`url`) AS `Page__short_url`, (IF(`Page`.`target` <=> "" or `Page`.`target` <=> null, "_self", `Page`.`target`)) AS `Page__target` FROM `u706517901_creekside`.`hero_manager_hero_images_pages` AS `HeroImagesPage` LEFT JOIN `u706517901_creekside`.`hero_manager_hero_images` AS `HeroImage` ON (`HeroImagesPage`.`hero_image_id` = `HeroImage`.`id`) LEFT JOIN `u706517901_creekside`.`cms_pages` AS `Page` ON (`HeroImagesPage`.`page_id` = `Page`.`id`) WHERE `page_id` = 9 LIMIT 1 | 1 | 1 | 0 | |