Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Configuration`.`id`, `Configuration`.`created_at`, `Configuration`.`modified_at`, `Configuration`.`module`, `Configuration`.`key`, `Configuration`.`value`, `Configuration`.`description`, `Configuration`.`allowed_values`, `Configuration`.`admin_edit`, (CONCAT(`Configuration`.`module`, ' ', `Configuration`.`key`)) AS `Configuration__module_key` FROM `kewdale_cms_2014`.`pw_configuration` AS `Configuration` WHERE `Configuration`.`key` = 'databaseInstalled' ORDER BY `module` ASC, `key` ASC, `value` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `kewdale_cms_2014`.`pw_content` AS `Content` WHERE `Content`.`id` = 17 | 1 | 1 | 0 | |
SELECT `Content`.`id`, `Content`.`created_at`, `Content`.`modified_at`, `Content`.`content_revision_id`, `Content`.`content_category_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`short_title`, `Content`.`title`, `Content`.`text`, `Content`.`header`, `Content`.`access_level`, `Content`.`date_published`, `Content`.`draft`, `ContentCategory`.`id`, `ContentCategory`.`created_at`, `ContentCategory`.`modified_at`, `ContentCategory`.`title`, `ContentCategory`.`template`, `ContentCategory`.`default`, `ContentCategory`.`initial_category`, `ContentCategory`.`display_info`, `ContentCategory`.`public`, `ContentCategory`.`user_group_id_set` FROM `kewdale_cms_2014`.`pw_content` AS `Content` LEFT JOIN `kewdale_cms_2014`.`pw_content_category` AS `ContentCategory` ON (`Content`.`content_category_id` = `ContentCategory`.`id`) WHERE `Content`.`id` = 17 ORDER BY `Content`.`lft` ASC, `Content`.`title` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `MenuItem`.`id`, `MenuItem`.`created_at`, `MenuItem`.`modified_at`, `MenuItem`.`menu_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`menu_item_type_id`, `MenuItem`.`order`, `MenuItem`.`item_id`, `MenuItem`.`item_class`, `MenuItem`.`item_extras`, `MenuItem`.`access_level`, `MenuItem`.`route_parameters`, `MenuItem`.`route_named`, `MenuItem`.`route_pass`, `MenuItem`.`link_target_id`, `Menu`.`id`, `Menu`.`created_at`, `Menu`.`modified_at`, `Menu`.`title`, `Menu`.`position`, `Menu`.`layout`, `Menu`.`levels`, `MenuItemType`.`id`, `MenuItemType`.`name`, `MenuItemType`.`sort`, `MenuItemType`.`active`, `ParentMenuItem`.`id`, `ParentMenuItem`.`created_at`, `ParentMenuItem`.`modified_at`, `ParentMenuItem`.`menu_id`, `ParentMenuItem`.`parent_id`, `ParentMenuItem`.`lft`, `ParentMenuItem`.`rght`, `ParentMenuItem`.`title`, `ParentMenuItem`.`url`, `ParentMenuItem`.`menu_item_type_id`, `ParentMenuItem`.`order`, `ParentMenuItem`.`item_id`, `ParentMenuItem`.`item_class`, `ParentMenuItem`.`item_extras`, `ParentMenuItem`.`access_level`, `ParentMenuItem`.`route_parameters`, `ParentMenuItem`.`route_named`, `ParentMenuItem`.`route_pass`, `ParentMenuItem`.`link_target_id`, `LinkTarget`.`id`, `LinkTarget`.`created_at`, `LinkTarget`.`modified_at`, `LinkTarget`.`name`, `LinkTarget`.`target`, `LinkTarget`.`sort` FROM `kewdale_cms_2014`.`pw_menu_item` AS `MenuItem` LEFT JOIN `kewdale_cms_2014`.`pw_menu` AS `Menu` ON (`MenuItem`.`menu_id` = `Menu`.`id`) LEFT JOIN `kewdale_cms_2014`.`pw_menu_item_type` AS `MenuItemType` ON (`MenuItem`.`menu_item_type_id` = `MenuItemType`.`id`) LEFT JOIN `kewdale_cms_2014`.`pw_menu_item` AS `ParentMenuItem` ON (`MenuItem`.`parent_id` = `ParentMenuItem`.`id`) LEFT JOIN `kewdale_cms_2014`.`pw_link_target` AS `LinkTarget` ON (`MenuItem`.`link_target_id` = `LinkTarget`.`id`) WHERE `MenuItem`.`route_parameters` = 'a:3:{s:6:\"plugin\";s:7:\"content\";s:10:\"controller\";s:7:\"content\";s:6:\"action\";s:4:\"view\";}' AND `MenuItem`.`route_pass` = 'a:1:{i:0;i:17;}' ORDER BY `Menu`.`position` = 'top' DESC, `Menu`.`position` = 'footer' DESC, `Menu`.`position` = 'utilities' DESC LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `Seo`.`id`, `Seo`.`created_at`, `Seo`.`modified_at`, `Seo`.`plugin`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`action`, `Seo`.`request_uri`, `Seo`.`title`, `Seo`.`seo_attribute_type_id`, `Seo`.`sitemap_show`, `Seo`.`sitemap_change_frequency`, `Seo`.`sitemap_priority`, `SeoAttributeType`.`id`, `SeoAttributeType`.`enum`, `SeoAttributeType`.`name`, `SeoAttributeType`.`sort`, `SeoAttributeType`.`active` FROM `kewdale_cms_2014`.`pw_seo` AS `Seo` LEFT JOIN `kewdale_cms_2014`.`pw_seo_attribute_type` AS `SeoAttributeType` ON (`Seo`.`seo_attribute_type_id` = `SeoAttributeType`.`id`) WHERE `Seo`.`request_uri` = '/content/food-takeaway-menu' LIMIT 1 | 1 | 1 | 1 | |
SELECT `SeoMeta`.`id`, `SeoMeta`.`created_at`, `SeoMeta`.`modified_at`, `SeoMeta`.`key`, `SeoMeta`.`value`, `SeoMeta`.`seo_id` FROM `kewdale_cms_2014`.`pw_seo_meta` AS `SeoMeta` WHERE `SeoMeta`.`seo_id` = (24) | 2 | 2 | 0 | |
SELECT `PageSlideshowImage`.`id`, `PageSlideshowImage`.`created_at`, `PageSlideshowImage`.`modified_at`, `PageSlideshowImage`.`plugin`, `PageSlideshowImage`.`model`, `PageSlideshowImage`.`foreign_key`, `PageSlideshowImage`.`default`, `PageSlideshowImage`.`name`, `PageSlideshowImage`.`caption`, `PageSlideshowImage`.`link`, `PageSlideshowImage`.`link_target`, `PageSlideshowImage`.`image_id`, `PageSlideshowImage`.`thumbnail_image_id`, `PageSlideshowImage`.`sort`, `Image`.`id`, `Image`.`token`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Thumbnail`.`id`, `Thumbnail`.`token`, `Thumbnail`.`size`, `Thumbnail`.`width`, `Thumbnail`.`height` FROM `kewdale_cms_2014`.`pw_page_slideshow_image` AS `PageSlideshowImage` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `Image` ON (`PageSlideshowImage`.`image_id` = `Image`.`id`) LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `Thumbnail` ON (`PageSlideshowImage`.`thumbnail_image_id` = `Thumbnail`.`id`) WHERE `PageSlideshowImage`.`plugin` = 'content' AND `PageSlideshowImage`.`model` = 'content' AND `PageSlideshowImage`.`foreign_key` = 17 ORDER BY `PageSlideshowImage`.`sort` asc | 5 | 5 | 1 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 297) OR (((`ParentImage`.`id` = 297) AND (`Image`.`size` = 'original')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 66 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 297) OR (((`ParentImage`.`id` = 297) AND (`Image`.`size` = 'admin_thumb')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 9 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 300) OR (((`ParentImage`.`id` = 300) AND (`Image`.`size` = 'original')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 60 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 300) OR (((`ParentImage`.`id` = 300) AND (`Image`.`size` = 'admin_thumb')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 8 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 303) OR (((`ParentImage`.`id` = 303) AND (`Image`.`size` = 'original')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 61 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 303) OR (((`ParentImage`.`id` = 303) AND (`Image`.`size` = 'admin_thumb')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 10 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 306) OR (((`ParentImage`.`id` = 306) AND (`Image`.`size` = 'original')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 60 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 306) OR (((`ParentImage`.`id` = 306) AND (`Image`.`size` = 'admin_thumb')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 7 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 309) OR (((`ParentImage`.`id` = 309) AND (`Image`.`size` = 'original')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 73 | maybe slow |
SELECT `Image`.`id`, `Image`.`file_name`, `Image`.`width`, `Image`.`height`, `Image`.`token`, `Image`.`size` FROM `kewdale_cms_2014`.`pw_image` AS `Image` LEFT JOIN `kewdale_cms_2014`.`pw_image` AS `ParentImage` ON (`Image`.`parent_id` = `ParentImage`.`id`) WHERE ((`Image`.`id` = 309) OR (((`ParentImage`.`id` = 309) AND (`Image`.`size` = 'admin_thumb')))) ORDER BY `Image`.`parent_id` DESC LIMIT 1 | 1 | 1 | 8 | maybe slow |
SELECT `ContentExtra`.`id`, `ContentExtra`.`created_at`, `ContentExtra`.`modified_at`, `ContentExtra`.`content_extra_type_id`, `ContentExtra`.`content_id`, `ContentExtra`.`title`, `ContentExtra`.`text`, `ContentExtra`.`sort`, `ContentExtraType`.`id`, `ContentExtraType`.`created_at`, `ContentExtraType`.`modified_at`, `ContentExtraType`.`name`, `ContentExtraType`.`short_title`, `Content`.`id`, `Content`.`created_at`, `Content`.`modified_at`, `Content`.`content_revision_id`, `Content`.`content_category_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`short_title`, `Content`.`title`, `Content`.`text`, `Content`.`header`, `Content`.`access_level`, `Content`.`date_published`, `Content`.`draft` FROM `kewdale_cms_2014`.`pw_content_extra` AS `ContentExtra` LEFT JOIN `kewdale_cms_2014`.`pw_content_extra_type` AS `ContentExtraType` ON (`ContentExtra`.`content_extra_type_id` = `ContentExtraType`.`id`) LEFT JOIN `kewdale_cms_2014`.`pw_content` AS `Content` ON (`ContentExtra`.`content_id` = `Content`.`id`) WHERE `ContentExtraType`.`short_title` = 'sidebar' AND `ContentExtra`.`content_id` = 17 ORDER BY `sort` ASC | 1 | 1 | 2 | maybe slow |