Please Login

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

Cake Params
- named(empty)
- pass(empty)
- pluginusers
- controllerusers
- actionlogin
- url
  exthtml
  urllogin
- form(empty)
- isAjax(false)
$_GET
- urllogin
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults
  pluginusers
  controllerusers
  actionlogin
- template/login
- _greedy(false)
- _compiledRoute#^/login[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Plugin`.`id`, `Plugin`.`name` FROM `plugins` AS `Plugin` WHERE `active` = 1	14	14	0	Explain
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
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
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
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
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
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
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
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
SELECT `EmailForm`.`id`, `EmailForm`.`slug` FROM `email_forms` AS `EmailForm` WHERE 1 = 1	1	1	0	Explain
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
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
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
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 `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` = 'users' AND `action` = 'login' 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` = (3) 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` = (3) 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` = (3) ORDER BY `FeatureImage`.`rank` ASC, `FeatureImage`.`id` ASC	0	0	0	Explain
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	0	Explain
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 08:35:34' AND ((`PrototypeItem`.`end_publishing` IS NULL) OR (`PrototypeItem`.`end_publishing` > '2021-08-01 08:35:34')) 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 `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 26.62 MB

Message	Memory use
Component intitailization	16.79 MB
Controller action start	18.43 MB
Controller render start	20.63 MB
View render complete	24.08 MB

Timers

Total Request Time: 641 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	90.38
Component initialization and startup	36.15
Controller action	24.60
Render Controller Action	14.93
» Rendering View	13.89
» » Rendering CORE/cms/plugins/users/views/users/login.ctp	10.53
» » » Rendering CORE/cms/plugins/users/views/elements/login_form.ctp	2.24
» » Rendering APP/views/layouts/login.ctp #2	3.12
» » » Rendering APP/views/elements/common_layout/footer.ctp	1.55

====

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
- pageTopGallery(empty)
- pageBottomGallery(empty)
- pageFeatureImage(empty)
- titleTagLogin - Topgate Farm - Discover the Art of Western Canada
- pageHeadingPlease Login
- 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
- layoutlogin
- 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-login
- bodyClass plugin-users
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1javascript
  2htmlToolbar
  3toolbar
  4tinyMce
  5postDisplay
  6productDisplay
  7number
  8ecommerce
  9productLink
  10itemDisplay
  11prototypeLink
  12navigation
  13minify
  14emailFormLink
  15attachment
  16pageLink
  17partialPage
  18modelLoad
  19rssReader
  20paginator
  21text
  22tree
  23copyright
  24time
  25session
  26jqueryEngine
  27form
  28html
  29js
  30htmla
====

Top Gate Farm

Discover the Art of Western Canada

Please Login

August 1, 2021

default

Query Explain:

Memory

Timers

error.log

debug.log

Top Gate Farm

Discover the Art of Western Canada

Please Login

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