Sitemap

Main Navigation

History
Request History
4 previous requests available
====
Session
Session
- Config
  userAgent
  time1627836826
  timeout10
- Users
  User
  Group
  3Guest
  Permission(empty)
  User
  id(null)
====
Request
Request

Cake Params
- named(empty)
- pass(empty)
- pluginsitemap
- controllersitemap
- actionindex
- url
  exthtml
  urlsitemap
- form(empty)
- isAjax(false)
$_GET
- urlsitemap
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults
  pluginsitemap
  controllersitemap
  actionindex
- template/sitemap
- _greedy(false)
- _compiledRoute#^/sitemap[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
DESCRIBE `plugins`	4	4	0
SELECT `Plugin`.`id`, `Plugin`.`name` FROM `plugins` AS `Plugin` WHERE `active` = 1	14	14	0	Explain
DESCRIBE `pages_settings`	9	9	0
SELECT `PagesSetting`.`id`, `PagesSetting`.`name`, `PagesSetting`.`value`, `PagesSetting`.`description`, `PagesSetting`.`category`, `PagesSetting`.`input_type`, `PagesSetting`.`allow_markup`, `PagesSetting`.`super_admin`, `PagesSetting`.`options` FROM `pages_settings` AS `PagesSetting` WHERE 1 = 1	17	17	0	Explain
DESCRIBE `users_settings`	8	8	0
SELECT `UsersSetting`.`id`, `UsersSetting`.`name`, `UsersSetting`.`value`, `UsersSetting`.`description`, `UsersSetting`.`category`, `UsersSetting`.`input_type`, `UsersSetting`.`super_admin`, `UsersSetting`.`options` FROM `users_settings` AS `UsersSetting` WHERE 1 = 1	2	2	0	Explain
DESCRIBE `site_settings`	8	8	0
SELECT `SiteSetting`.`id`, `SiteSetting`.`name`, `SiteSetting`.`value`, `SiteSetting`.`description`, `SiteSetting`.`category`, `SiteSetting`.`input_type`, `SiteSetting`.`super_admin`, `SiteSetting`.`options` FROM `site_settings` AS `SiteSetting` WHERE 1 = 1	23	23	0	Explain
DESCRIBE `email_forms_settings`	8	8	0
SELECT `EmailFormsSetting`.`id`, `EmailFormsSetting`.`name`, `EmailFormsSetting`.`value`, `EmailFormsSetting`.`description`, `EmailFormsSetting`.`category`, `EmailFormsSetting`.`input_type`, `EmailFormsSetting`.`super_admin`, `EmailFormsSetting`.`options` FROM `email_forms_settings` AS `EmailFormsSetting` WHERE 1 = 1	3	3	0	Explain
DESCRIBE `navigation_settings`	8	8	0
SELECT `NavigationSetting`.`id`, `NavigationSetting`.`name`, `NavigationSetting`.`value`, `NavigationSetting`.`description`, `NavigationSetting`.`category`, `NavigationSetting`.`input_type`, `NavigationSetting`.`super_admin`, `NavigationSetting`.`options` FROM `navigation_settings` AS `NavigationSetting` WHERE 1 = 1	2	2	0	Explain
DESCRIBE `prototype_settings`	8	8	0
SELECT `PrototypeSetting`.`id`, `PrototypeSetting`.`name`, `PrototypeSetting`.`value`, `PrototypeSetting`.`description`, `PrototypeSetting`.`category`, `PrototypeSetting`.`input_type`, `PrototypeSetting`.`super_admin`, `PrototypeSetting`.`options` FROM `prototype_settings` AS `PrototypeSetting` WHERE 1 = 1	4	4	0	Explain
DESCRIBE `products_settings`	9	9	0
SELECT `ProductsSetting`.`id`, `ProductsSetting`.`name`, `ProductsSetting`.`value`, `ProductsSetting`.`description`, `ProductsSetting`.`category`, `ProductsSetting`.`input_type`, `ProductsSetting`.`allow_markup`, `ProductsSetting`.`super_admin`, `ProductsSetting`.`options` FROM `products_settings` AS `ProductsSetting` WHERE 1 = 1	36	36	0	Explain
DESCRIBE `blog_settings`	8	8	0
SELECT `BlogSetting`.`id`, `BlogSetting`.`name`, `BlogSetting`.`value`, `BlogSetting`.`description`, `BlogSetting`.`category`, `BlogSetting`.`input_type`, `BlogSetting`.`super_admin`, `BlogSetting`.`options` FROM `blog_settings` AS `BlogSetting` WHERE 1 = 1	12	12	0	Explain
DESCRIBE `email_forms`	22	22	0
SELECT `EmailForm`.`id`, `EmailForm`.`slug` FROM `email_forms` AS `EmailForm` WHERE 1 = 1	1	1	0	Explain
DESCRIBE `prototype_categories`	13	13	0
SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`slug` FROM `prototype_categories` AS `PrototypeCategory` WHERE 1 = 1 ORDER BY `PrototypeCategory`.`rank` ASC, `PrototypeCategory`.`name` ASC	13	13	0	Explain
DESCRIBE `prototype_instances`	17	17	0
DESCRIBE `linked_prototype_instances`	3	3	0
SELECT `PrototypeInstance`.`slug` FROM `prototype_instances` AS `PrototypeInstance` WHERE 1 = 1	3	3	0	Explain
DESCRIBE `nav_items`	13	13	0
DESCRIBE `nav_lists`	9	9	0
SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id`, `NavList`.`id`, `NavList`.`created`, `NavList`.`modified`, `NavList`.`name`, `NavList`.`rank`, `NavList`.`comments`, `NavList`.`created_by_user_id`, `NavList`.`modified_by_user_id`, `NavList`.`sitemap` FROM `nav_items` AS `NavItem` LEFT JOIN `nav_lists` AS `NavList` ON (`NavItem`.`nav_list_id` = `NavList`.`id`) WHERE `nav_list_id` = 1 ORDER BY `NavItem`.`lft` ASC	9	9	0	Explain
DESCRIBE `users`	21	21	0
DESCRIBE `groups`	7	7	0
DESCRIBE `permissions`	7	7	0
DESCRIBE `groups_permissions`	3	3	0
DESCRIBE `groups_users`	3	3	0
DESCRIBE `groups_groups`	3	3	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`created_by_user_id`, `Group`.`modified_by_user_id`, `Group`.`login_redirect` FROM `groups` AS `Group` WHERE `Group`.`name` = 'Guest' LIMIT 1	1	1	0	Explain
SELECT `Permission`.`id`, `Permission`.`name`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`universal`, `Permission`.`created_by_user_id`, `Permission`.`modified_by_user_id`, `GroupsPermission`.`id`, `GroupsPermission`.`group_id`, `GroupsPermission`.`permission_id` FROM `permissions` AS `Permission` JOIN `groups_permissions` AS `GroupsPermission` ON (`GroupsPermission`.`group_id` = 3 AND `GroupsPermission`.`permission_id` = `Permission`.`id`)	0	0	0	Explain
DESCRIBE `product_categories`	13	13	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 ORDER BY `ProductCategory`.`lft` ASC	15	15	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 1 AND `ProductCategory`.`rght` >= 2 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 25 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 3 AND `ProductCategory`.`rght` >= 4 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 18 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 5 AND `ProductCategory`.`rght` >= 6 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 17 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 7 AND `ProductCategory`.`rght` >= 8 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 19 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 9 AND `ProductCategory`.`rght` >= 10 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 14 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 11 AND `ProductCategory`.`rght` >= 12 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 24 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 13 AND `ProductCategory`.`rght` >= 14 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 16 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 15 AND `ProductCategory`.`rght` >= 16 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 23 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 17 AND `ProductCategory`.`rght` >= 18 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 20 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 19 AND `ProductCategory`.`rght` >= 20 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 13 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 21 AND `ProductCategory`.`rght` >= 22 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 21 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 23 AND `ProductCategory`.`rght` >= 24 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 15 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 25 AND `ProductCategory`.`rght` >= 26 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 22 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 27 AND `ProductCategory`.`rght` >= 28 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 26 ORDER BY `ProductCategory`.`lft` ASC LIMIT 1	1	1	0	Explain
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`published`, `ProductCategory`.`begin_publishing`, `ProductCategory`.`end_publishing` FROM `product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 29 AND `ProductCategory`.`rght` >= 30 ORDER BY `ProductCategory`.`lft` asc	1	1	0	Explain
SELECT `NavList`.`id`, `NavList`.`name` FROM `nav_lists` AS `NavList` WHERE `NavList`.`sitemap` = 1	1	1	0	Explain
DESCRIBE `pages`	26	26	0
DESCRIBE `uploader_attachments`	19	19	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`title`, `Page`.`content`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`status`, `Page`.`begin_publishing`, `Page`.`end_publishing`, `Page`.`layout`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`full_page`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`plugin`, `Page`.`exclude_sitemap`, `Page`.`created_by_user_id`, `Page`.`modified_by_user_id` FROM `pages` AS `Page` WHERE `controller` = 'sitemap' AND `action` = 'index' LIMIT 1	1	1	0	Explain
SELECT `TopImage`.`id`, `TopImage`.`created`, `TopImage`.`modified`, `TopImage`.`foreign_model`, `TopImage`.`foreign_key`, `TopImage`.`rank`, `TopImage`.`filename`, `TopImage`.`caption`, `TopImage`.`type`, `TopImage`.`size`, `TopImage`.`group`, `TopImage`.`path`, `TopImage`.`thumbname`, `TopImage`.`begin_publishing`, `TopImage`.`end_publishing`, `TopImage`.`published`, `TopImage`.`created_by_user_id`, `TopImage`.`modified_by_user_id`, `TopImage`.`alt_tag` FROM `uploader_attachments` AS `TopImage` WHERE `TopImage`.`foreign_model` = 'Page' AND `TopImage`.`group` = 'top_image' AND `TopImage`.`foreign_key` = (9) ORDER BY `TopImage`.`rank` ASC, `TopImage`.`id` ASC	0	0	0	Explain
SELECT `BottomImage`.`id`, `BottomImage`.`created`, `BottomImage`.`modified`, `BottomImage`.`foreign_model`, `BottomImage`.`foreign_key`, `BottomImage`.`rank`, `BottomImage`.`filename`, `BottomImage`.`caption`, `BottomImage`.`type`, `BottomImage`.`size`, `BottomImage`.`group`, `BottomImage`.`path`, `BottomImage`.`thumbname`, `BottomImage`.`begin_publishing`, `BottomImage`.`end_publishing`, `BottomImage`.`published`, `BottomImage`.`created_by_user_id`, `BottomImage`.`modified_by_user_id`, `BottomImage`.`alt_tag` FROM `uploader_attachments` AS `BottomImage` WHERE `BottomImage`.`foreign_model` = 'Page' AND `BottomImage`.`group` = 'bottom_image' AND `BottomImage`.`foreign_key` = (9) ORDER BY `BottomImage`.`rank` ASC, `BottomImage`.`id` ASC	0	0	0	Explain
SELECT `FeatureImage`.`id`, `FeatureImage`.`created`, `FeatureImage`.`modified`, `FeatureImage`.`foreign_model`, `FeatureImage`.`foreign_key`, `FeatureImage`.`rank`, `FeatureImage`.`filename`, `FeatureImage`.`caption`, `FeatureImage`.`type`, `FeatureImage`.`size`, `FeatureImage`.`group`, `FeatureImage`.`path`, `FeatureImage`.`thumbname`, `FeatureImage`.`begin_publishing`, `FeatureImage`.`end_publishing`, `FeatureImage`.`published`, `FeatureImage`.`created_by_user_id`, `FeatureImage`.`modified_by_user_id`, `FeatureImage`.`alt_tag` FROM `uploader_attachments` AS `FeatureImage` WHERE `FeatureImage`.`foreign_model` = 'Page' AND `FeatureImage`.`group` = 'feature_image' AND `FeatureImage`.`foreign_key` = (9) ORDER BY `FeatureImage`.`rank` ASC, `FeatureImage`.`id` ASC	0	0	0	Explain
DESCRIBE `extra_fields`	6	6	0
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`rank`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_tags`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`rss_feed`, `PrototypeInstance`.`rss_order`, `PrototypeInstance`.`rss_name`, `PrototypeInstance`.`rss_amount`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order` FROM `prototype_instances` AS `PrototypeInstance` WHERE 1 = 1	3	3	0	Explain
SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key`, `ExtraField`.`key`, `ExtraField`.`val`, `ExtraField`.`type`, `ExtraField`.`foreign_model` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`foreign_model` = 'PrototypeInstance' AND `ExtraField`.`foreign_key` IN (1, 3, 4)	57	57	1	Explain
SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`key` = 'load as slideshow' AND `ExtraField`.`val` = '1' AND `ExtraField`.`foreign_model` = 'PrototypeItem'	1	1	1	Explain
DESCRIBE `prototype_items`	13	13	0
DESCRIBE `linked_prototype_items`	3	3	0
SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`description`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`prototype_category_id`, `PrototypeItem`.`published`, `PrototypeItem`.`begin_publishing`, `PrototypeItem`.`end_publishing`, `PrototypeItem`.`featured`, `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`rank`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_tags`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`rss_feed`, `PrototypeInstance`.`rss_order`, `PrototypeInstance`.`rss_name`, `PrototypeInstance`.`rss_amount`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order` FROM `prototype_items` AS `PrototypeItem` LEFT JOIN `prototype_instances` AS `PrototypeInstance` ON (`PrototypeItem`.`prototype_instance_id` = `PrototypeInstance`.`id`) WHERE `PrototypeItem`.`id` = (5) AND `PrototypeItem`.`published` = 1 AND `PrototypeItem`.`begin_publishing` <= '2021-08-01 06:53:46' AND ((`PrototypeItem`.`end_publishing` IS NULL) OR (`PrototypeItem`.`end_publishing` > '2021-08-01 06:53:46')) ORDER BY `PrototypeItem`.`rank` ASC, `PrototypeItem`.`rank` ASC, `PrototypeItem`.`name` ASC	1	1	0	Explain
SELECT `Gallery`.`id`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`foreign_model`, `Gallery`.`foreign_key`, `Gallery`.`rank`, `Gallery`.`filename`, `Gallery`.`caption`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`group`, `Gallery`.`path`, `Gallery`.`thumbname`, `Gallery`.`begin_publishing`, `Gallery`.`end_publishing`, `Gallery`.`published`, `Gallery`.`created_by_user_id`, `Gallery`.`modified_by_user_id`, `Gallery`.`alt_tag` FROM `uploader_attachments` AS `Gallery` WHERE `Gallery`.`foreign_model` = 'Prototype.PrototypeItem' AND `Gallery`.`group` = 'gallery' AND `Gallery`.`foreign_key` = (5) ORDER BY `Gallery`.`rank` ASC	1	1	0	Explain
SELECT `ExtraField`.`id`, `ExtraField`.`foreign_key`, `ExtraField`.`key`, `ExtraField`.`val`, `ExtraField`.`type`, `ExtraField`.`foreign_model` FROM `extra_fields` AS `ExtraField` WHERE `ExtraField`.`foreign_model` = 'PrototypeItem' AND `ExtraField`.`foreign_key` = (5)	2	2	0	Explain
SELECT `NavList`.`id` FROM `nav_lists` AS `NavList` WHERE `NavList`.`name` = 'Main Navigation' LIMIT 1	1	1	0	Explain
SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`nav_list_id` = 1 ORDER BY `NavItem`.`lft` ASC	9	9	0	Explain
SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`nav_list_id` = 1 ORDER BY `NavItem`.`lft` ASC	9	9	0	Explain
SELECT `NavList`.`id` FROM `nav_lists` AS `NavList` WHERE `NavList`.`name` = 'Main Navigation' LIMIT 1	1	1	0	Explain
SELECT `NavItem`.`id`, `NavItem`.`created`, `NavItem`.`modified`, `NavItem`.`name`, `NavItem`.`parent_id`, `NavItem`.`lft`, `NavItem`.`rght`, `NavItem`.`nav_list_id`, `NavItem`.`url`, `NavItem`.`target_page`, `NavItem`.`rank`, `NavItem`.`created_by_user_id`, `NavItem`.`modified_by_user_id` FROM `nav_items` AS `NavItem` WHERE `NavItem`.`nav_list_id` = 1 AND `NavItem`.`parent_id` IS NULL ORDER BY `NavItem`.`lft` ASC	6	6	0	Explain

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 29.70 MB

Message	Memory use
Component intitailization	16.46 MB
Controller action start	18.77 MB
Controller render start	20.62 MB
View render complete	24.58 MB

Timers

Total Request Time: 369 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	153.51
Component initialization and startup	45.77
Controller action	28.49
Render Controller Action	17.08
» Rendering View	16.66
» » Rendering CORE/cms/plugins/sitemap/views/sitemap/index.ctp	12.90
» » Rendering APP/views/layouts/default.ctp	3.23
» » » Rendering APP/views/elements/common_layout/header.ctp	1.50
» » » » Rendering CORE/cms/views/elements/js/lightbox.ctp	0.12
» » » Rendering APP/views/elements/common_layout/footer.ctp	1.40

====

Log

Logs

error.log

There were no log entries made this request

debug.log

There were no log entries made this request

====
Variables
View Variables
- mainNavigation
  0
  NavItem
  id1
  created2011-03-18 10:05:40
  modified2011-09-23 10:56:55
  nameHome
  parent_id(null)
  lft1
  rght2
  nav_list_id1
  url/
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  1
  NavItem
  id2
  created2011-03-18 10:06:57
  modified2011-03-18 10:06:57
  nameThe Farm
  parent_id(null)
  lft3
  rght4
  nav_list_id1
  url/the-farm
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  2
  NavItem
  id3
  created2011-03-18 10:07:12
  modified2011-03-18 10:24:46
  nameThe Artists
  parent_id(null)
  lft5
  rght6
  nav_list_id1
  url/artists
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  3
  NavItem
  id4
  created2011-03-18 10:07:26
  modified2011-03-18 10:08:08
  nameThe Gallery
  parent_id(null)
  lft7
  rght8
  nav_list_id1
  url/the-gallery
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  4
  NavItem
  id5
  created2011-03-18 10:07:39
  modified2011-03-18 10:08:21
  nameThe Shop
  parent_id(null)
  lft9
  rght16
  nav_list_id1
  url/the-shop
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  5
  NavItem
  id11
  created2011-05-06 15:16:30
  modified2011-05-06 16:03:37
  nameArt Cards
  parent_id5
  lft10
  rght11
  nav_list_id1
  url/the-shop/category/art-cards-1
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  6
  NavItem
  id13
  created2011-05-06 15:17:15
  modified2013-02-18 18:12:01
  namePrints
  parent_id5
  lft12
  rght13
  nav_list_id1
  url/the-shop/category/prints-26
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  7
  NavItem
  id16
  created2011-05-06 15:18:13
  modified2011-05-06 16:05:57
  nameOrdering Info
  parent_id5
  lft14
  rght15
  nav_list_id1
  url/ordering-shipping-information
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
  8
  NavItem
  id6
  created2011-03-18 10:08:35
  modified2011-03-18 10:08:35
  nameContact
  parent_id(null)
  lft17
  rght18
  nav_list_id1
  url/contact-us
  target_page(null)
  rank0
  created_by_user_id(null)
  modified_by_user_id(null)
  NavList
  id1
  created(null)
  modified(null)
  nameMain Navigation
  rank0
  commentsThe main navigation list for the website.
  created_by_user_id(null)
  modified_by_user_id(null)
  sitemap1
- paginationOptions
  01
  15
  210
  325
  450
  5100
  6200
  7400
- paginationLimit25
- loggedIn(true)
- superAdmin(false)
- admin(false)
- productTreeNavigation
  0
  NavItem
  nameArt Cards
  url/products/product_categories/view/categories:/art-cards
  1
  NavItem
  nameSeasonal
  url/products/product_categories/view/categories:/seasonal
  2
  NavItem
  nameNote Cards
  url/products/product_categories/view/categories:/note-cards
  3
  NavItem
  nameBoxed Art Cards
  url/products/product_categories/view/categories:/boxed-art-cards
  4
  NavItem
  nameBoxed Note Cards
  url/products/product_categories/view/categories:/boxed-note-cards
  5
  NavItem
  nameCoastal
  url/products/product_categories/view/categories:/coastal
  6
  NavItem
  nameCows
  url/products/product_categories/view/categories:/cows
  7
  NavItem
  nameCritters
  url/products/product_categories/view/categories:/critters
  8
  NavItem
  nameFlora & Fauna
  url/products/product_categories/view/categories:/flora-fauna
  9
  NavItem
  nameForests
  url/products/product_categories/view/categories:/forests
  10
  NavItem
  nameTrains
  url/products/product_categories/view/categories:/trains
  11
  NavItem
  nameVancouver Island
  url/products/product_categories/view/categories:/vancouver-island
  12
  NavItem
  nameWestern Landscapes
  url/products/product_categories/view/categories:/western-landscapes
  13
  NavItem
  nameWhimsy
  url/products/product_categories/view/categories:/whimsy
  14
  NavItem
  namePrints
  url/products/product_categories/view/categories:/prints
  15
  NavItem
  nameView All Products
  url/products/product_categories/view/categories:all
- navLists
  1Main Navigation
- pageTopGallery(empty)
- pageBottomGallery(empty)
- pageFeatureImage(empty)
- titleTagSitemap - Topgate Farm - Discover the Art of Western Canada
- pageHeadingSitemap
- pageIntro
- metaKeywordsTopgate farm, top gate farm, art gallery, art store, prints, canadian art, western canada, pioneer life, farm art, ranch art, train art, prairies art, landscape art, paintings, oil and canvas, watercolour, victoria, colwood, highlands, saanich, langford, esquimalt, view royal, oak bay, sooke, metchosin, sidney, malahat, greater victoria area, GVA, greater victoria region, GVR, vancouver island, british columbia, bc, canada, Alberta, Rocky Mountain foothills
- metaDescriptionFocusing on the imagery of Western Canada, Topgate Farm offers a view of our world through the eyes of select Canadian artists. Our goals are to offer an online gallery for Canadian artists to showcase their work and to produce quality, hand printed reproductions in the form of art cards, note cards, art prints, and gifts.
- extraHeaderCode
- extraFooterCode
- layoutdefault
- googleAnalytics<script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-2222379-58', 'auto'); ga('require', 'displayfeatures'); ga('require', 'linkid', 'linkid.js'); ga('send', 'pageview'); </script>
- googleVerificationAg91HBpR1mesM32b9pK5i7O0HaksTEgUi3PZ6rgEiNs
- bodyIdbody-sitemap
- bodyClass plugin-sitemap
- gatePhotoSlideshow
  PrototypeItem
  id5
  nameGate Photo
  description
  rank3
  created2011-03-24 10:56:47
  modified2011-09-20 12:15:53
  sluggate-photo-1
  prototype_instance_id3
  prototype_category_id0
  published1
  begin_publishing2011-03-24 10:56:00
  end_publishing(null)
  featured1
  load as slideshow1
  slideshow layoutshome,default
  PrototypeInstance
  id3
  nameHome Page Photo
  description<p>This has no visible function on this website.</p>
  rank0
  slughome-page-photo
  created2011-03-24 10:54:24
  modified2013-06-14 10:07:19
  use_tags0
  use_categories0
  public1
  rss_feed1
  rss_orderbegin_publishing DESC
  rss_name
  rss_amount10
  footer_text
  layoutdefault
  item_orderrank ASC
  Gallery
  0
  id6
  created2011-03-24 10:57:37
  modified2011-09-20 12:15:57
  foreign_modelPrototype.PrototypeItem
  foreign_key5
  rank0
  filename5_6.jpg
  captionGate Photo
  typeimage/jpeg
  size248205
  groupgallery
  pathuploads/prototypeitem/
  thumbname5_6_thumb.jpg
  begin_publishing(null)
  end_publishing(null)
  published1
  created_by_user_id(null)
  modified_by_user_id(null)
  alt_tag
  full_imageuploads/prototypeitem/5_6.jpg
  full_largeuploads/prototypeitem/5_6_large.jpg
  full_thumbuploads/prototypeitem/5_6_thumb.jpg
  ExtraField
  0
  id42
  foreign_key5
  keyload as slideshow
  val1
  typestring
  foreign_modelPrototypeItem
  1
  id43
  foreign_key5
  keyslideshow layouts
  valhome,default
  typestring
  foreign_modelPrototypeItem
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1htmlToolbar
  2toolbar
  3tinyMce
  4postDisplay
  5productDisplay
  6number
  7ecommerce
  8productLink
  9itemDisplay
  10prototypeLink
  11navigation
  12minify
  13emailFormLink
  14attachment
  15pageLink
  16partialPage
  17modelLoad
  18rssReader
  19paginator
  20text
  21tree
  22copyright
  23session
  24jqueryEngine
  25form
  26html
  27js
  28htmla
  29cache
  30javascript
  31xml
  32time
====

Top Gate Farm

Discover the Art of Western Canada

Sitemap

Main Navigation

August 1, 2021

default

Query Explain:

Memory

Timers

error.log

debug.log

Top Gate Farm

Discover the Art of Western Canada

Sitemap

Main Navigation

August 1, 2021

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

error.log

debug.log

View Variables