Tweed Purse R711466

$169.00

Made from 100% wool and genuine leather, this compact cross body bag is a stylish and classic addition to any collection.

Style code: R711 466

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgent
  time1596688111
  countdown10
- Users
  User
  Group
  4Unregistered
  Permission(null)
  User
  id(null)
====
Request
+
Request

Cake Params
- pluginproducts
- controllerproducts
- actionview
- named(empty)
- pass(empty)
- id560
- slugtweed-purse-r711466
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- Users
  User:2 weeks
Current Route
- keys
  0id
  1slug
- options
  id[0-9]+
  slug[a-z0-9_-]+
- defaults
  pluginproducts
  controllerproducts
  actionview
- template/products/view/:id-:slug
====

Sql Log

Sql Logs

default

Total Time: 96 ms
Total Queries: 274 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder` FROM `outofireland2`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	7	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 914 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `outofireland2`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (914)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder` FROM `outofireland2`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	11	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 915 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `outofireland2`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (915)	0	0	3	maybe slow
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder` FROM `outofireland2`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 916 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `outofireland2`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (916)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder` FROM `outofireland2`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 917 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `outofireland2`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (917)	0	0	3	maybe slow
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder` FROM `outofireland2`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	0
SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `outofireland2`.`permissions` AS `Permission` WHERE `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC	74	74	1
SELECT `LoginToken`.`id` FROM `outofireland2`.`login_tokens` AS `LoginToken` WHERE expires < "2020-08-05 17:28:31"	0	0	0
SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `outofireland2`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1	1	1	0
SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name`, `GroupsPermission`.`id`, `GroupsPermission`.`group_id`, `GroupsPermission`.`permission_id` FROM `outofireland2`.`permissions` AS `Permission` JOIN `outofireland2`.`groups_permissions` AS `GroupsPermission` ON (`GroupsPermission`.`group_id` = 4 AND `GroupsPermission`.`permission_id` = `Permission`.`id`)	0	0	0
SELECT `Product`.`id`, `Product`.`rank`, `Product`.`created`, `Product`.`modified`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`featured_description`, `Product`.`price`, `Product`.`product_number`, `Product`.`count`, `Product`.`view_count`, `Product`.`additional_shipping`, `Product`.`featured`, `Product`.`deleted`, `Product`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`products` AS `Product` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Product`.`id` AND `PublishingInformation`.`model` = 'Product') WHERE `Product`.`id` = 560 AND `Product`.`slug` = 'tweed-purse-r711466' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:31' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:31')) AND `Product`.`deleted` = '0' ORDER BY `Product`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Product' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (560) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	1	1	1
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Product' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (560) ORDER BY `Document`.`rank` ASC, `Document`.`id` ASC	0	0	0
SELECT `Option`.`id`, `Option`.`name`, `Option`.`default`, `Option`.`type`, `Option`.`required`, `Option`.`validate`, `Option`.`label`, `Option`.`validate_message`, `Option`.`rank`, `Option`.`options`, `Option`.`foreign_key`, `Option`.`model`, `Option`.`display_label`, `Option`.`group`, `Option`.`placeholder` FROM `outofireland2`.`custom_fields` AS `Option` WHERE `Option`.`model` = 'Product' AND `Option`.`group` = 'Option' AND `Option`.`foreign_key` = (560) ORDER BY `Option`.`rank` ASC, `Option`.`id` ASC	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Product' AND `CustomFieldValue`.`foreign_key` = (560)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Product' AND `MetaValue`.`foreign_key` = (560)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `outofireland2`.`product_categories` AS `ProductCategory` JOIN `outofireland2`.`product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` = 560 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`)	1	1	1
SELECT COUNT(*) AS `count` FROM `outofireland2`.`products` AS `Product` WHERE `Product`.`id` = 560	1	1	0
SELECT COUNT(*) AS `count` FROM `outofireland2`.`products` AS `Product` WHERE `Product`.`id` = 560	1	1	0
UPDATE `outofireland2`.`products` SET `view_count` = 77, `modified` = '2020-08-05 17:28:31' WHERE `outofireland2`.`products`.`id` = '560'	1	1	1
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `controller` = 'products' AND `action` = 'view' AND `extra` = 'tweed-purse-r711466' AND `Page`.`deleted` = '0' LIMIT 1	0	0	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `controller` = 'products' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1	0	0	1	maybe slow
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`id` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 30 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (30)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (30)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 21 AND `ProductCategory`.`rght` >= 22 AND `ProductCategory`.`deleted` = '0' ORDER BY `ProductCategory`.`lft` asc	2	2	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` IN (52, 30)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` IN (52, 30)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 52 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (52)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (52)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 30 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (30)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (30)	0	0	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `controller` = 'products' AND `action` = 'view' AND `extra` = 'tweed-purse-r711466' AND `Page`.`deleted` = '0' LIMIT 1	0	0	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `controller` = 'products' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1	0	0	1	maybe slow
SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `outofireland2`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC	5	5	1	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:31' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:31')) AND `ProductCategory`.`deleted` = '0' ORDER BY `ProductCategory`.`lft` ASC	25	25	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` IN (13, 20, 21, 4, 22, 23, 10, 52, 26, 30, 27, 45, 25, 46, 47, 18, 56, 57, 43, 35, 3, 28, 54, 55, 19)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` IN (13, 20, 21, 4, 22, 23, 10, 52, 26, 30, 27, 45, 25, 46, 47, 18, 56, 57, 43, 35, 3, 28, 54, 55, 19)	5	5	1	maybe slow
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `outofireland2`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	1
SELECT `AttachmentVersion`.`id`, `AttachmentVersion`.`created`, `AttachmentVersion`.`modified`, `AttachmentVersion`.`model`, `AttachmentVersion`.`foreign_key`, `AttachmentVersion`.`group`, `AttachmentVersion`.`name`, `AttachmentVersion`.`type`, `AttachmentVersion`.`convert`, `AttachmentVersion`.`width`, `AttachmentVersion`.`height`, `AttachmentVersion`.`deleted`, `AttachmentVersion`.`deleted_date`, `AttachmentVersion`.`gravity`, `AttachmentVersion`.`bgcolour` FROM `outofireland2`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0'	22	22	1
SELECT `Setting`.`key`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` LIKE 'Site.Contact.%' AND `Setting`.`value` != ''	9	9	1	maybe slow
SELECT `ContentBlock`.`id`, `ContentBlock`.`name` FROM `outofireland2`.`content_blocks` AS `ContentBlock` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ContentBlock`.`id` AND `PublishingInformation`.`model` = 'ContentBlock') WHERE `ContentBlock`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:32' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:32'))	1	1	1
SELECT `EmailForm`.`id`, `EmailForm`.`name` FROM `outofireland2`.`email_forms` AS `EmailForm` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `EmailForm`.`id` AND `PublishingInformation`.`model` = 'EmailForm') WHERE `EmailForm`.`super_admin` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:32' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:32')) AND `EmailForm`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	1	1	1
SELECT `Gallery`.`id`, `Gallery`.`name` FROM `outofireland2`.`galleries` AS `Gallery` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:32' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:32')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	0	0	1	maybe slow
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0'	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	5	5	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `outofireland2`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.gtm_association_code' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (50) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (50) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.verification_code' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (17) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (17) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (19) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (19) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 28 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (28)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (28)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 28 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (28)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (28)	5	5	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `outofireland2`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 4 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:32' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:32')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	28	28	1
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 13 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (13)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (13)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 20 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (20)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (20)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 21 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (21)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (21)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 4 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (4)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (4)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 22 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (22)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (22)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 23 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (23)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (23)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 10 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (10)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (10)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 25 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (25)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (25)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 46 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (46)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (46)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 47 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (47)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (47)	5	5	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 26 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (26)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (26)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 27 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (27)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (27)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 45 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (45)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (45)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 18 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (18)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (18)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 56 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (56)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (56)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 57 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (57)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (57)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 43 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (43)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (43)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 35 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (35)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (35)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 3 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (3)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (3)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 28 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (28)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (28)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 54 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (54)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (54)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 55 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (55)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (55)	0	0	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`description`, `ProductCategory`.`rank`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`slug`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`parent_id`, `ProductCategory`.`deleted`, `ProductCategory`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`product_categories` AS `ProductCategory` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ProductCategory`.`id` AND `PublishingInformation`.`model` = 'ProductCategory') WHERE `ProductCategory`.`id` = 19 AND `ProductCategory`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'ProductCategory' AND `CustomFieldValue`.`foreign_key` = (19)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'ProductCategory' AND `MetaValue`.`foreign_key` = (19)	0	0	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 30 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (30)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (30)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 30 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (30)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (30)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 10 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (10)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (10)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 10 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (10)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (10)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	5	5	0
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`id` = 63 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC LIMIT 1	1	1	1
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`lft` > 2 AND `NavigationMenuItem`.`rght` < 59 AND `NavigationMenuItem`.`navigation_menu_id` = 4 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:33')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	25	25	2	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.toll_free' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (32) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (32) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`id` = 63 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC LIMIT 1	1	1	1
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `outofireland2`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `outofireland2`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`parent_id` = 63 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-08-05 17:28:33' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-08-05 17:28:33')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	6	6	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 40 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (40)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (40)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `outofireland2`.`pages` AS `Page` WHERE `Page`.`id` = 40 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `outofireland2`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (40)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `outofireland2`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (40)	5	5	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `outofireland2`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	1
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.address' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (9) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (9) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.city' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (10) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (10) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.province_state' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (11) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (11) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.postal_zip' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (12) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (12) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.phone' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (14) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (14) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.toll_free' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (32) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (32) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.contact_email' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (33) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (33) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `outofireland2`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.contact_email' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `outofireland2`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (33) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `outofireland2`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (33) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `outofireland2`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `outofireland2`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 36.54 MB

Message	Memory use
Component initialization	13.44 MB
Controller action start	15.94 MB
Controller render start	19.52 MB
View render complete	25.70 MB

Timers

Total Request Time: 3037 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	648.68
Component initialization and startup	353.84
Controller action	244.55
Render Controller Action	1370.86
» Rendering View	1362.56
» » Rendering APP/Plugin/Products/View/Products/view.ctp	78.45
» » » Rendering CORE/working/lib/Cms/Plugin/Products/View/Elements/breadcrumbs.ctp	1.23
» » » Rendering APP/Plugin/Products/View/Elements/products/add_to_cart_form.ctp	55.05
» » Rendering APP/View/Layouts/default.ctp	868.19
» » » Rendering APP/View/Elements/layout/header.ctp	712.39
» » » » Rendering APP/View/Elements/gtm_head.ctp	0.50
» » » » Rendering APP/View/Elements/gtm_body.ctp	0.32
» » » » Rendering APP/View/Elements/header-notice.ctp	46.81
» » » Rendering APP/View/Elements/layout/footer.ctp	149.65
» » » » Rendering APP/Plugin/Products/View/Elements/search/simple.ctp	0.85

====

Log
+

Logs

logins

Time Message
2020-08-05 17:28:31 Array ( [successful_login] => false 3.216.134.176 )

====
Variables
+
View Variables
- metas
  descriptionMade from 100% wool and genuine leather, this compact cross body bag is a stylish and classic addition to any collection. Style code: R711 466
- layout
- extraFooterCode
- extraHeaderCode
- pageIntro
- breadcrumbs
  Products
  pluginproducts
  controllerproducts
  actionindex
  Accessories
  pluginproducts
  controllerproduct_categories
  actionview
  categoryaccessories
  id52
  admin(false)
  Bags
  pluginproducts
  controllerproduct_categories
  actionview
  categorybags
  id30
  admin(false)
- paginationLimit20
- paginationOptions
  024
  148
  296
- product
  Product
  id560
  rank0
  created2017-11-07 16:20:54
  modified2020-08-05 15:40:24
  nameTweed Purse R711466
  slugtweed-purse-r711466
  description<p>Made from 100% wool and genuine leather, this compact cross body bag is a stylish and classic addition to any collection.</p> <p>Style code: R711 466</p>
  featured_description(null)
  price169
  product_number(null)
  count0
  view_count76
  additional_shipping0.00
  featured(false)
  deleted(false)
  deleted_date(null)
  raw_price169.00
  categoriesBags
  PublishingInformation
  id1098
  created(null)
  modified(null)
  modelProduct
  foreign_key560
  start2019-11-16 11:02:16
  end(null)
  published(true)
  Image
  0
  id2656
  modelProduct
  foreign_key560
  dirnameimg
  basenamer711_466_web.jpg
  checksum
  alternativeR711 466
  groupImage
  created2017-11-07 16:22:07
  modified2019-11-16 11:02:37
  rank1
  deleted(false)
  deleted_date(null)
  pathimg/r711_466_web.jpg
  Document(empty)
  Option(empty)
  CustomFieldValue(empty)
  MetaValue(empty)
  ProductCategory
  0
  id30
  nameBags
  description(null)
  rank0
  created2013-11-13 11:49:38
  modified2017-05-02 16:04:49
  slugbags
  lft21
  rght22
  parent_id52
  deleted(false)
  deleted_date(null)
  ProductCategoriesProduct
  id515
  product_id560
  product_category_id30
- pageHeadingTweed Purse R711466
- titleTagTweed Purse R711466 : Out of Ireland : Irish & Scottish Clothing, Gifts & Jewellery
- loggedIn(true)
- superAdmin(false)
- admin(false)
- $request->data(empty)
- $this->validationErrors
  CmsPlugin(empty)
  Setting(empty)
  BootstrapInstance(empty)
  PrototypeInstance(empty)
  PublishingInformation(empty)
  MetaValue(empty)
  PrototypeCategory(empty)
  CustomFieldValue(empty)
  Attachment(empty)
  CustomField(empty)
  PrototypeItem(empty)
  EmailFormSubmission(empty)
  EmailForm(empty)
  User(empty)
  Country(empty)
  Permission(empty)
  LoginToken(empty)
  Group(empty)
  GroupsPermission(empty)
  Product(empty)
  Image(empty)
  Document(empty)
  ProductCategory(empty)
  Parent(empty)
  Option(empty)
  ProductCategoriesProduct(empty)
  Page(empty)
  MetaKey(empty)
- Loaded Helpers
  0Html
  1Form
  2Session
  3Cms
  4AssetCompress
  5Copyright
  6GoogleMap
  7SocialMedia
  8ReCaptcha
  9Settings
  10AdminLink
  11AdminNav
  12AdminTab
  13ContentBlock
  14CustomField
  15EmailForm
  16EmailFormBlock
  17GalleryBlock
  18ModelLink
  19ModelLoad
  20MediaVersion
  21Media
  22Meta
  23Navigation
  24Prototype
  25PrototypeLink
  26Publishing
  27Theme
  28TinyMce
  29Users
  30Versioning
  31Responsive
  32Moneris
  33Payment
  34Products
  35ShoppingCart
  36Toolbar
  37Number
  38SimpleGraph
  39HtmlToolbar
====
Include
+
Included Files

Include Paths
- 0/home/pyramidcms/1_0/working/lib/Cms/Plugin/Media/Lib/mm/src
- 2/usr/local/lib/php
- 3/usr/local/php5/lib/pear
- 4/home/pyramidcms/1_0/vendors
- 5-> /home/pyramidcms/1_0/Cake/
Included Files
- core
  Behavior
  0CORE/Model/BehaviorCollection.php
  1CORE/Model/Behavior/ContainableBehavior.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/Behavior/TreeBehavior.php
  Cache
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  3CORE/Routing/Filter/CacheDispatcher.php
  Component
  0CORE/Controller/ComponentCollection.php
  1CORE/Controller/Component.php
  2CORE/Controller/Component/SessionComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/CookieComponent.php
  5CORE/Controller/Component/PaginatorComponent.php
  Config
  0CORE/Core/Configure.php
  1CORE/Configure/PhpReader.php
  2CORE/Configure/ConfigReaderInterface.php
  3CORE/Config/routes.php
  Controller
  0CORE/Controller/Controller.php
  Datasource
  0CORE/Model/Datasource/Database/Mysql.php
  1CORE/Model/Datasource/DboSource.php
  2CORE/Model/Datasource/DataSource.php
  3CORE/Model/Datasource/CakeSession.php
  Error
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log
  0CORE/Log/CakeLogInterface.php
  1CORE/Log/CakeLog.php
  2CORE/Log/LogEngineCollection.php
  3CORE/Log/Engine/FileLog.php
  4CORE/Log/Engine/BaseLog.php
  Model
  0CORE/Model/Model.php
  1CORE/Model/ConnectionManager.php
  Network
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Object.php
  4CORE/Event/CakeEventListener.php
  5CORE/Event/CakeEvent.php
  6CORE/Event/CakeEventManager.php
  Plugin
  0CORE/Core/CakePlugin.php
  1CORE/Routing/Route/PluginShortRoute.php
  Routing
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Router.php
  4CORE/Routing/Route/CakeRoute.php
  Utility
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ClassRegistry.php
  3CORE/Utility/ObjectCollection.php
  4CORE/Utility/Set.php
  5CORE/Utility/String.php
  6CORE/Utility/File.php
  7CORE/Utility/Folder.php
  8CORE/Utility/Debugger.php
  9CORE/Utility/Validation.php
  10CORE/Utility/Security.php
  View
  0CORE/View/View.php
  1CORE/View/HelperCollection.php
- app
  Behavior
  0APP/Model/Behavior/DynamicValidationBehavior.php
  1APP/Model/Behavior/ValidateHabtmBehavior.php
  2APP/Model/Behavior/SortableBehavior.php
  3APP/Model/Behavior/SluggableBehavior.php
  4APP/Model/Behavior/CopyableBehavior.php
  5APP/Model/Behavior/MultiTreeBehavior.php
  6APP/Model/Behavior/ReCaptchaBehavior.php
  7APP/Model/Behavior/AppTreeBehavior.php
  Component
  0APP/Controller/Component/NotifyComponent.php
  1APP/Controller/Component/AutoPaginateComponent.php
  2APP/Controller/Component/MobileComponent.php
  3APP/Controller/Component/AppPaginatorComponent.php
  Config
  0APP/Config/core.php
  1APP/Config/pyramid.php
  2APP/Config/bootstrap.php
  3APP/Config/database.php
  4APP/Lib/Configure/JsonReader.php
  5APP/Config/routes.php
  Controller
  0APP/Controller/AppController.php
  Model
  0APP/Model/AppModel.php
  1APP/Model/Token.php
  Other
  0APP/webroot/index.php
- plugins
  Administration
  Config
  0Administration/Config/bootstrap.php
  1Administration/Config/events.php
  2Administration/Config/routes.php
  Plugin
  0Administration/Event/AdministrationEventListener.php
  Component
  0Administration/Controller/Component/AdminComponent.php
  1Administration/Controller/Component/AdminNavComponent.php
  2Administration/Controller/Component/AdminTabComponent.php
  AssetCompress
  Config
  0AssetCompress/Config/bootstrap.php
  Caching
  Config
  0Caching/Config/bootstrap.php
  1Caching/Config/events.php
  2Caching/Config/routes.php
  Plugin
  0Caching/Event/CachingEventListener.php
  Cache
  0Caching/Model/Behavior/CachedBehavior.php
  ContentBlocks
  Config
  0ContentBlocks/Config/bootstrap.php
  1ContentBlocks/Config/events.php
  2ContentBlocks/Config/routes.php
  Plugin
  0ContentBlocks/Event/ContentBlocksEventListener.php
  CustomFields
  Config
  0CustomFields/Config/bootstrap.php
  1CustomFields/Config/events.php
  2CustomFields/Config/routes.php
  Plugin
  0CustomFields/Event/CustomFieldsEventListener.php
  Behavior
  0CustomFields/Model/Behavior/CustomFieldBehavior.php
  1CustomFields/Model/Behavior/ExpandableBehavior.php
  Model
  0CustomFields/Model/CustomFieldValue.php
  1CustomFields/Model/CustomFieldsAppModel.php
  2CustomFields/Model/CustomField.php
  DebugKit
  Component
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/DebugTimer.php
  EmailForms
  Config
  0EmailForms/Config/bootstrap.php
  1EmailForms/Config/events.php
  2EmailForms/Config/routes.php
  Plugin
  0EmailForms/Event/EmailFormsEventListener.php
  Component
  0EmailForms/Controller/Component/EmailFormsComponent.php
  Model
  0EmailForms/Model/EmailFormSubmission.php
  1EmailForms/Model/EmailFormsAppModel.php
  2EmailForms/Model/EmailForm.php
  Galleries
  Config
  0Galleries/Config/bootstrap.php
  1Galleries/Config/events.php
  2Galleries/Config/routes.php
  Plugin
  0Galleries/Event/GalleriesEventListener.php
  Install
  Config
  0Install/Config/bootstrap.php
  1Install/Config/routes.php
  Linking
  Config
  0Linking/Config/bootstrap.php
  1Linking/Config/events.php
  Plugin
  0Linking/Event/LinkingEventListener.php
  Behavior
  0Linking/Model/Behavior/LinkableBehavior.php
  MathCaptcha
  Config
  0MathCaptcha/Config/bootstrap.php
  1MathCaptcha/Config/events.php
  2MathCaptcha/Config/routes.php
  Plugin
  0MathCaptcha/Event/MathCaptchaEventListener.php
  Behavior
  0MathCaptcha/Model/Behavior/MathCaptchaBehavior.php
  Media
  Config
  0Media/Config/bootstrap.php
  1Media/Config/events.php
  2Media/Config/routes.php
  Plugin
  0Media/Event/MediaEventListener.php
  Model
  0Media/Model/Attachment.php
  1Media/Model/MediaAppModel.php
  Behavior
  0Media/Model/Behavior/TransferBehavior.php
  1Media/Model/Behavior/GeneratorBehavior.php
  2Media/Model/Behavior/PolymorphicBehavior.php
  3Media/Model/Behavior/CouplerBehavior.php
  4Media/Model/Behavior/MetaBehavior.php
  Metas
  Config
  0Metas/Config/bootstrap.php
  1Metas/Config/events.php
  2Metas/Config/routes.php
  Plugin
  0Metas/Event/MetasEventListener.php
  Behavior
  0Metas/Model/Behavior/MetaTagBehavior.php
  Model
  0Metas/Model/MetaValue.php
  1Metas/Model/MetaKey.php
  Component
  0Metas/Controller/Component/MetaComponent.php
  Navigation
  Config
  0Navigation/Config/bootstrap.php
  1Navigation/Config/events.php
  2Navigation/Config/routes.php
  Plugin
  0Navigation/Event/NavigationEventListener.php
  Pages
  Config
  0Pages/Config/bootstrap.php
  1Pages/Config/events.php
  2Pages/Config/routes.php
  Plugin
  0Pages/Event/PagesEventListener.php
  Component
  0Pages/Controller/Component/PageSettingsComponent.php
  Model
  0Pages/Model/Page.php
  1Pages/Model/PagesAppModel.php
  PluginTools
  Config
  0PluginTools/Config/events.php
  1PluginTools/Config/routes.php
  Plugin
  0PluginTools/Event/PluginToolsEventListener.php
  Products
  Config
  0Products/Config/bootstrap.php
  1Products/Config/events.php
  2Products/Config/routes.php
  Plugin
  0Products/Event/ProductsEventListener.php
  Controller
  0Products/Controller/ProductsController.php
  1Products/Controller/ProductsAppController.php
  Component
  0Products/Controller/Component/ProductBreadcrumbsComponent.php
  Model
  0Products/Model/Product.php
  1Products/Model/ProductsAppModel.php
  2Products/Model/ProductCategory.php
  Prototype
  Config
  0Prototype/Config/bootstrap.php
  1Prototype/Config/events.php
  2Prototype/Config/routes.php
  Plugin
  0Prototype/Event/PrototypeEventListener.php
  Model
  0Prototype/Model/PrototypeInstance.php
  1Prototype/Model/PrototypeAppModel.php
  2Prototype/Model/PrototypeCategory.php
  3Prototype/Model/PrototypeItem.php
  Publishing
  Config
  0Publishing/Config/bootstrap.php
  1Publishing/Config/events.php
  2Publishing/Config/routes.php
  Plugin
  0Publishing/Event/PublishingEventListener.php
  Behavior
  0Publishing/Model/Behavior/PublishableBehavior.php
  Model
  0Publishing/Model/PublishingInformation.php
  1Publishing/Model/PublishingAppModel.php
  ReCaptcha
  Config
  0ReCaptcha/Config/bootstrap.php
  1ReCaptcha/Config/events.php
  2ReCaptcha/Config/routes.php
  Plugin
  0ReCaptcha/Event/ReCaptchaEventListener.php
  Responsive
  Config
  0Responsive/Config/bootstrap.php
  1Responsive/Config/events.php
  2Responsive/Config/routes.php
  Plugin
  0Responsive/Event/ResponsiveEventListener.php
  Component
  0Responsive/Controller/Component/ResponsiveComponent.php
  Search
  Behavior
  0Search/Model/Behavior/SearchableBehavior.php
  Component
  0Search/Controller/Component/PrgComponent.php
  Settings
  Config
  0Settings/Config/bootstrap.php
  1Settings/Config/events.php
  2Settings/Config/routes.php
  Model
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  Plugin
  0Settings/Event/SettingsEventListener.php
  Sitemap
  Config
  0Sitemap/Config/bootstrap.php
  1Sitemap/Config/events.php
  2Sitemap/Config/routes.php
  Plugin
  0Sitemap/Event/SitemapEventListener.php
  Theming
  Config
  0Theming/Config/bootstrap.php
  1Theming/Config/events.php
  2Theming/Config/routes.php
  Plugin
  0Theming/Event/ThemingEventListener.php
  Behavior
  0Theming/Model/Behavior/ThemedBehavior.php
  Component
  0Theming/Controller/Component/ThemingComponent.php
  TinyMce
  Config
  0TinyMce/Config/bootstrap.php
  1TinyMce/Config/events.php
  2TinyMce/Config/routes.php
  Plugin
  0TinyMce/Event/TinyMceEventListener.php
  TreeSort
  Behavior
  0TreeSort/Model/Behavior/TreeSortBehavior.php
  UrlCache
  Cache
  0UrlCache/Config/bootstrap.php
  Users
  Config
  0Users/Config/events.php
  1Users/Config/routes.php
  Plugin
  0Users/Event/UsersEventListener.php
  Component
  0Users/Controller/Component/AuthsomeComponent.php
  1Users/Controller/Component/AccessControlComponent.php
  Model
  0Users/Model/User.php
  1Users/Model/UsersAppModel.php
  2Users/Model/Country.php
  3Users/Model/Permission.php
  4Users/Model/LoginToken.php
  5Users/Model/Group.php
  Versioning
  Config
  0Versioning/Config/bootstrap.php
  1Versioning/Config/events.php
  2Versioning/Config/routes.php
  Plugin
  0Versioning/Event/VersioningEventListener.php
  Behavior
  0Versioning/Model/Behavior/SoftDeleteBehavior.php
  1Versioning/Model/Behavior/RevisionBehavior.php
  Component
  0Versioning/Controller/Component/PreviewComponent.php
====

Tweed Purse R711466

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 96 ms Total Queries: 274 queries

Query Explain:

Memory

Timers

Logs

logins

View Variables

Included Files

Include Paths

Included Files

Total Time: 96 ms
Total Queries: 274 queries