Current Residential Property Development

History
+

Request History

No previous requests logged.

====
Session
+
Session
- Config
  userAgent
  time1601269849
  countdown10
- Users
  User(empty)
====
Request
+
Request

Cake Params
- pluginprototype
- controllerprototype_categories
- actionview
- named(empty)
- pass(empty)
- instancedevelopments
- categorycurrent-residential-property-development
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys
  0instance
  1category
- options
  instancedevelopments|features
  categoryuncategorized-1|residential|commercial|past-residential-property-development|current-residential-property-development|past-commercial-property-development|current-commercial-property-development
- defaults
  pluginprototype
  controllerprototype_categories
  actionview
- template/:instance/:category/*
====

Sql Log

Sql Logs

default

Total Time: 170 ms
Total Queries: 509 queries

Query	Affected	Num. rows	Took (ms)	Actions
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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 12 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (12)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	0	0	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '12' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`slug` = 'developments' AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	0	0	1	maybe slow
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 `parhargroupdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 1 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2020-09-27 18:10:50' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2020-09-27 18:10:50')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	13	13	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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 1 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	0	0	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 1 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	0	0	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 1 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	0	0	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 1 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	0	0	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	0	0	1	maybe slow
SELECT `RentalCategory`.`id`, `RentalCategory`.`created`, `RentalCategory`.`modified`, `RentalCategory`.`name`, `RentalCategory`.`rank`, `RentalCategory`.`description`, `RentalCategory`.`slug`, `RentalCategory`.`deleted_date`, `RentalCategory`.`deleted`, `RentalCategory`.`lft`, `RentalCategory`.`rght`, `RentalCategory`.`building_count`, `RentalCategory`.`parent_id`, `RentalCategory`.`head_title` FROM `parhargroupdb`.`rental_categories` AS `RentalCategory` WHERE `RentalCategory`.`id` = 1 AND `RentalCategory`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'RentalCategory' AND `MetaValue`.`foreign_key` = (1)	4	4	0
SELECT `RentalCategory`.`id`, `RentalCategory`.`created`, `RentalCategory`.`modified`, `RentalCategory`.`name`, `RentalCategory`.`rank`, `RentalCategory`.`description`, `RentalCategory`.`slug`, `RentalCategory`.`deleted_date`, `RentalCategory`.`deleted`, `RentalCategory`.`lft`, `RentalCategory`.`rght`, `RentalCategory`.`building_count`, `RentalCategory`.`parent_id`, `RentalCategory`.`head_title` FROM `parhargroupdb`.`rental_categories` AS `RentalCategory` WHERE `RentalCategory`.`id` = 2 AND `RentalCategory`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'RentalCategory' AND `MetaValue`.`foreign_key` = (2)	4	4	0
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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 1 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	0	0	1	maybe slow
SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`name`, `PrototypeCategory`.`rank`, `PrototypeCategory`.`created`, `PrototypeCategory`.`modified`, `PrototypeCategory`.`slug`, `PrototypeCategory`.`prototype_instance_id`, `PrototypeCategory`.`parent_id`, `PrototypeCategory`.`lft`, `PrototypeCategory`.`rght`, `PrototypeCategory`.`deleted`, `PrototypeCategory`.`deleted_date`, `PrototypeCategory`.`head_title`, `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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_categories` AS `PrototypeCategory` LEFT JOIN `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeCategory`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeCategory`.`id` AND `PublishingInformation`.`model` = 'PrototypeCategory') WHERE `PrototypeCategory`.`id` = 4 AND `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`rank` ASC LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'PrototypeCategory' AND `CustomFieldValue`.`foreign_key` = (4)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeCategory' AND `MetaValue`.`foreign_key` = (4)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 41 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (41)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	0
SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`name`, `PrototypeCategory`.`rank`, `PrototypeCategory`.`created`, `PrototypeCategory`.`modified`, `PrototypeCategory`.`slug`, `PrototypeCategory`.`prototype_instance_id`, `PrototypeCategory`.`parent_id`, `PrototypeCategory`.`lft`, `PrototypeCategory`.`rght`, `PrototypeCategory`.`deleted`, `PrototypeCategory`.`deleted_date`, `PrototypeCategory`.`head_title`, `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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_categories` AS `PrototypeCategory` LEFT JOIN `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeCategory`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeCategory`.`id` AND `PublishingInformation`.`model` = 'PrototypeCategory') WHERE `PrototypeCategory`.`id` = 5 AND `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`rank` ASC LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'PrototypeCategory' AND `CustomFieldValue`.`foreign_key` = (5)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeCategory' AND `MetaValue`.`foreign_key` = (5)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 42 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (42)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	0
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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 1 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 1 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 44 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (44)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 15 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 44 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (44)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 15 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 12 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (12)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	0	0	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '12' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 12 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (12)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	0	0	1	maybe slow
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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '12' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 44 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (44)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 15 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 44 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (44)	0	0	1	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 15 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 44 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (44)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 15 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 44 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (44)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 15 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 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 `parhargroupdb`.`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 `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `parhargroupdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 43 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 `parhargroupdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (43)	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`, `CustomField`.`description` FROM `parhargroupdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 14 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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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 `parhargroupdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' 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 `parhargroupdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (1) 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 `parhargroupdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) 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 `parhargroupdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.address' 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 `parhargroupdb`.`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	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 `parhargroupdb`.`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 `parhargroupdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.city' 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 `parhargroupdb`.`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 `parhargroupdb`.`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 `parhargroupdb`.`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 `parhargroupdb`.`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	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 `parhargroupdb`.`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 `parhargroupdb`.`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 `parhargroupdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (13) 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 `parhargroupdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (13) 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 `parhargroupdb`.`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 `parhargroupdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (15) 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 `parhargroupdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (15) 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 `parhargroupdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.fax' 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 `parhargroupdb`.`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 `parhargroupdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (17) 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 `parhargroupdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.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 `parhargroupdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (18) 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 `parhargroupdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (18) 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 `parhargroupdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.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 `parhargroupdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (18) 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 `parhargroupdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (18) 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 `parhargroupdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Footer.industry_identifier' 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 `parhargroupdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (27) 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 `parhargroupdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (27) ORDER BY `Document`.`rank` ASC	0	0	0
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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`slug` = 'developments' AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	0	0	0
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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`slug` = 'developments' AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`slug` = 'developments' AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`slug` = 'developments' AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	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`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `parhargroupdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `parhargroupdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`slug` = 'developments' AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `parhargroupdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `parhargroupdb`.`permissions` AS `Permission` WHERE `plugin` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1	0	0	1	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 23.43 MB

Message	Memory use
Component initialization	13.86 MB
Controller action start	15.84 MB
Controller render start	17.24 MB
View render complete	21.67 MB

Timers

Total Request Time: 2228 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	1249.91
Component initialization and startup	31.62
Controller action	86.57
Render Controller Action	535.47
» Rendering View	533.67
» » Rendering APP/Plugin/Prototype/View/developments/PrototypeCategories/view.ctp	0.40
» » Rendering APP/View/Layouts/development.ctp	493.20
» » » Rendering APP/View/Elements/layout/header.ctp	296.23
» » » » Rendering APP/View/Elements/gtm_head.ctp	0.41
» » » » Rendering APP/View/Elements/metas.ctp	0.33
» » » » Rendering APP/View/Elements/gtm_body.ctp	0.28
» » » Rendering APP/View/Elements/layout/footer.ctp	184.97

====

Log
+

Logs

logins

Time Message
2020-09-27 18:10:49 Array ( [successful_login] => false 3.228.10.17 )

====
Variables
+
View Variables
- metas
 application-name
 robots
 og:image
- layout
- extraFooterCode
- extraHeaderCode
- pageIntro
- breadcrumbs
 Developments
 pluginprototype
 controllerprototype_instances
 actionview
 instancedevelopments
 admin(false)
 Residential Property Development
 pluginprototype
 controllerprototype_categories
 actionview
 instancedevelopments
 categoryresidential
 admin(false)
 Current Residential Property Development
 pluginprototype
 controllerprototype_categories
 actionview
 instancedevelopments
 categorycurrent-residential-property-development
 admin(false)
- paginationLimit24
- paginationOptions
 024
 148
 296
- prototypeCategory
 PrototypeCategory
 id8
 nameCurrent Residential Property Development
 rank8
 created2020-08-06 16:36:31
 modified2020-08-12 09:39:26
 slugcurrent-residential-property-development
 prototype_instance_id1
 parent_id4
 lft3
 rght4
 deleted(false)
 deleted_date(null)
 head_titleCurrent Residential Property Development
 description
 PublishingInformation
 id48
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 start2020-08-06 16:36:31
 end(null)
 published(true)
 Image(empty)
 Document(empty)
 CategoryBannerImage(empty)
 PrototypeCategories(empty)
 CustomFieldValue
 0
 id48
 foreign_key8
 modelPrototypeCategory
 custom_field_id9
 keydescription
 val
 typestring
 MetaValue
 1
 id1141
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id1
 val
 2
 id1142
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id2
 val
 3
 id1143
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id3
 val
 4
 id1144
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id4
 val
- prototypeItems(empty)
- category
 PrototypeCategory
 id8
 nameCurrent Residential Property Development
 rank8
 created2020-08-06 16:36:31
 modified2020-08-12 09:39:26
 slugcurrent-residential-property-development
 prototype_instance_id1
 parent_id4
 lft3
 rght4
 deleted(false)
 deleted_date(null)
 head_titleCurrent Residential Property Development
 description
 PublishingInformation
 id48
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 start2020-08-06 16:36:31
 end(null)
 published(true)
 Image(empty)
 Document(empty)
 CategoryBannerImage(empty)
 PrototypeCategories(empty)
 CustomFieldValue
 0
 id48
 foreign_key8
 modelPrototypeCategory
 custom_field_id9
 keydescription
 val
 typestring
 MetaValue
 1
 id1141
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id1
 val
 2
 id1142
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id2
 val
 3
 id1143
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id3
 val
 4
 id1144
 created2020-08-06 16:36:31
 modified2020-08-06 16:36:31
 modelPrototypeCategory
 foreign_key8
 meta_key_id4
 val
- customFields
 0
 CustomField
 id9
 namedescription
 default
 typewysiwyg
 required(false)
 validatenotEmpty
 labelDescription
 validate_messageThis field is required.
 rank8
 options
 foreign_key1
 modelPrototypeInstance
 display_label(true)
 groupPrototypeCategory
 placeholder
 description
- items
 0
 PrototypeItem
 id1
 namePark Estates
 rank0
 created2019-10-24 14:41:13
 modified2020-09-15 13:35:05
 slugpark-estates
 prototype_instance_id1
 featured(true)
 deleted(false)
 deleted_date(null)
 head_titlePark Estates
 description3 beautiful homes coming in 3 phases. A few different floor plans to suit every lifestyle. Modern finishes, such as quartz countertops, engineered hardwood floors. Homes back on to green space and the Trans-Canada trail system, close to transit and hospital. View the full <a href="http://parkestates.ca/index.shtml" title="Park Estates" target="_blank" rel="noopener">ParkEstates.ca website</a>.
 subtitleResidential Development, Duncan BC
 summary3 beautiful homes coming in 3 phases. A few different floor plans to suit every lifestyle. Modern finishes, such as quartz countertops, engineered hardwood floors. Homes back on to green space and the Trans-Canada trail system, close to transit and hospital.
 PublishingInformation
 id4
 created2019-10-24 14:41:13
 modified2019-10-24 14:41:13
 modelPrototypeItem
 foreign_key1
 start2020-07-16 14:55:57
 end(null)
 published(true)
 Image
 0
 id9
 modelPrototypeItem
 foreign_key1
 dirnameimg
 basenamesimilar_homes_7.jpg
 checksum44525d2154a9b41473ee5c55b435f678
 alternativeBackyard
 groupImage
 created2019-11-06 15:37:04
 modified2020-09-15 13:35:05
 rank1
 deleted(false)
 deleted_date(null)
 pathimg/similar_homes_7.jpg
 1
 id97
 modelPrototypeItem
 foreign_key1
 dirnameimg
 basenamesite_plan_phase3_08_04.jpg
 checksum74559c8012f4d78167a120679bcec516
 alternativeSite plan
 groupImage
 created2020-09-15 13:18:56
 modified2020-09-15 13:35:05
 rank2
 deleted(false)
 deleted_date(null)
 pathimg/site_plan_phase3_08_04.jpg
 2
 id5
 modelPrototypeItem
 foreign_key1
 dirnameimg
 basenamesimilar_homes_3.jpg
 checksum9a7db4fe2ec44db641dfb1c584c24226
 alternativeFront of house
 groupImage
 created2019-11-06 15:34:11
 modified2020-09-15 13:35:06
 rank3
 deleted(false)
 deleted_date(null)
 pathimg/similar_homes_3.jpg
 3
 id8
 modelPrototypeItem
 foreign_key1
 dirnameimg
 basenamesimilar_homes_6_2.jpg
 checksum365a0240eb7867d0f86a4c8dcc7ec3d4
 alternativeKitchen
 groupImage
 created2019-11-06 15:36:58
 modified2020-09-15 13:35:06
 rank4
 deleted(false)
 deleted_date(null)
 pathimg/similar_homes_6_2.jpg
 4
 id7
 modelPrototypeItem
 foreign_key1
 dirnameimg
 basenamesimilar_homes_5.jpg
 checksum8c7a2df885c6b3e11636ece5244b32ac
 alternativeDen
 groupImage
 created2019-11-06 15:34:29
 modified2020-09-15 13:35:06
 rank5
 deleted(false)
 deleted_date(null)
 pathimg/similar_homes_5.jpg
 5
 id6
 modelPrototypeItem
 foreign_key1
 dirnameimg
 basenamesimilar_homes_4.jpg
 checksume8428bee3d054b2830de807c058261bd
 alternativeMaster washroom
 groupImage
 created2019-11-06 15:34:22
 modified2020-09-15 13:35:06
 rank6
 deleted(false)
 deleted_date(null)
 pathimg/similar_homes_4.jpg
 Document
 0
 id90
 modelPrototypeItem
 foreign_key1
 dirnamedoc
 basenamesite_plan.pdf
 checksumd670458bb013a9d8287552c1a95aac80
 alternativePark Estates Site Plan
 groupDocument
 created2020-08-05 16:08:35
 modified2020-09-15 13:35:06
 rank1
 deleted(false)
 deleted_date(null)
 pathdoc/site_plan.pdf
 1
 id98
 modelPrototypeItem
 foreign_key1
 dirnamedoc
 basenamedisclosure_amendment_phase_2_and_3_march_12_2019.pdf
 checksum5be6a8f6f5d744cc69aa004ba5ba684c
 alternativeDisclosure Amendment Phase 2 and 3 March 12 2019
 groupDocument
 created2020-09-15 13:20:41
 modified2020-09-15 13:35:06
 rank2
 deleted(false)
 deleted_date(null)
 pathdoc/disclosure_amendment_phase_2_and_3_march_12_2019.pdf
 CustomFieldValue
 0
 id1
 foreign_key1
 modelPrototypeItem
 custom_field_id4
 keydescription
 val3 beautiful homes coming in 3 phases. A few different floor plans to suit every lifestyle. Modern finishes, such as quartz countertops, engineered hardwood floors. Homes back on to green space and the Trans-Canada trail system, close to transit and hospital. View the full <a href="http://parkestates.ca/index.shtml" title="Park Estates" target="_blank" rel="noopener">ParkEstates.ca website</a>.
 typestring
 1
 id5
 foreign_key1
 modelPrototypeItem
 custom_field_id6
 keysubtitle
 valResidential Development, Duncan BC
 typestring
 2
 id6
 foreign_key1
 modelPrototypeItem
 custom_field_id7
 keysummary
 val3 beautiful homes coming in 3 phases. A few different floor plans to suit every lifestyle. Modern finishes, such as quartz countertops, engineered hardwood floors. Homes back on to green space and the Trans-Canada trail system, close to transit and hospital.
 typestring
 MetaValue
 1
 id1133
 created2020-08-06 16:30:45
 modified2020-08-06 16:37:53
 modelPrototypeItem
 foreign_key1
 meta_key_id1
 val
 2
 id1134
 created2020-08-06 16:30:45
 modified2020-08-06 16:37:53
 modelPrototypeItem
 foreign_key1
 meta_key_id2
 val
 3
 id1135
 created2020-08-06 16:30:45
 modified2020-08-06 16:37:53
 modelPrototypeItem
 foreign_key1
 meta_key_id3
 val
 4
 id1136
 created2020-08-06 16:30:45
 modified2020-08-06 16:37:53
 modelPrototypeItem
 foreign_key1
 meta_key_id4
 val
 PrototypeCategory
 0
 id4
 nameResidential Property Development
 rank4
 created2019-11-06 15:38:53
 modified2020-08-12 09:39:26
 slugresidential
 prototype_instance_id1
 parent_id(null)
 lft2
 rght7
 deleted(false)
 deleted_date(null)
 head_titleResidential Developments
 PrototypeCategoriesPrototypeItem
 id213
 prototype_category_id4
 prototype_item_id1
 1
 id8
 nameCurrent Residential Property Development
 rank8
 created2020-08-06 16:36:31
 modified2020-08-12 09:39:26
 slugcurrent-residential-property-development
 prototype_instance_id1
 parent_id4
 lft3
 rght4
 deleted(false)
 deleted_date(null)
 head_titleCurrent Residential Property Development
 PrototypeCategoriesPrototypeItem
 id214
 prototype_category_id8
 prototype_item_id1
- paginatedItems(false)
- pageHeadingCurrent Residential Property Development
- titleTagCurrent Residential Property Development • The Parhar Group • Vancouver Island Real Estate
- loggedIn(false)
- superAdmin(false)
- admin(false)
- _instance
 PrototypeInstance
 id1
 nameDevelopments
 description<h2>Put your property development in the hands of someone you can trust.</h2> The Parhar Group are proven experts when it comes to property development, with a reputation for quality and integrity. When it comes to developing your property, we will make sure your vision is what matters, using the resources and connections we’ve developed over three decades in the sector. With an eye for detail and a dedication to going above and beyond, we ensure our projects are finished on time, on budget, and to a high standard.
 slugdevelopments
 created2019-10-24 14:39:13
 modified2020-08-06 16:44:51
 use_categories(true)
 public(true)
 footer_text
 layoutdevelopment
 item_orderPrototypeItem.rank ASC
 allow_instance_view(true)
 allow_category_views(true)
 allow_item_views(true)
 item_image_typemultiple
 item_document_typemultiple
 category_image_typesingle
 category_document_typenone
 item_summary_pagination(false)
 item_summary_pagination_limit(null)
 use_featured_items(true)
 all_items_featured(false)
 number_of_featured_items1
 autoload_featured_items_in_layoutshome
 deleted(false)
 deleted_date(null)
 name_field_labelName
 head_titleDevelopments
 category_changefreq
 use_page_banner_images(false)
 fallback_to_instance_banner_image(false)
 use_page_banner_image_categories(false)
 use_page_banner_image_items(false)
 item_changefreq
 controllers
 categorydevelopments_categories
 itemDevelopments_items
 models
 categoryDevelopmentsCategory
 itemDevelopmentsItem
 PublishingInformation
 id3
 created2019-10-24 14:39:13
 modified2019-10-24 14:39:13
 modelPrototypeInstance
 foreign_key1
 start2019-10-24 14:39:13
 end(null)
 published(true)
 Image(empty)
 MetaValue
 1
 id1125
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id1
 val
 2
 id1126
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id2
 val
 3
 id1127
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id3
 val
 4
 id1128
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id4
 val
 Group
 Group
 00
- instance
 PrototypeInstance
 id1
 nameDevelopments
 description<h2>Put your property development in the hands of someone you can trust.</h2> The Parhar Group are proven experts when it comes to property development, with a reputation for quality and integrity. When it comes to developing your property, we will make sure your vision is what matters, using the resources and connections we’ve developed over three decades in the sector. With an eye for detail and a dedication to going above and beyond, we ensure our projects are finished on time, on budget, and to a high standard.
 slugdevelopments
 created2019-10-24 14:39:13
 modified2020-08-06 16:44:51
 use_categories(true)
 public(true)
 footer_text
 layoutdevelopment
 item_orderPrototypeItem.rank ASC
 allow_instance_view(true)
 allow_category_views(true)
 allow_item_views(true)
 item_image_typemultiple
 item_document_typemultiple
 category_image_typesingle
 category_document_typenone
 item_summary_pagination(false)
 item_summary_pagination_limit(null)
 use_featured_items(true)
 all_items_featured(false)
 number_of_featured_items1
 autoload_featured_items_in_layoutshome
 deleted(false)
 deleted_date(null)
 name_field_labelName
 head_titleDevelopments
 category_changefreq
 use_page_banner_images(false)
 fallback_to_instance_banner_image(false)
 use_page_banner_image_categories(false)
 use_page_banner_image_items(false)
 item_changefreq
 controllers
 categorydevelopments_categories
 itemDevelopments_items
 models
 categoryDevelopmentsCategory
 itemDevelopmentsItem
 PublishingInformation
 id3
 created2019-10-24 14:39:13
 modified2019-10-24 14:39:13
 modelPrototypeInstance
 foreign_key1
 start2019-10-24 14:39:13
 end(null)
 published(true)
 Image(empty)
 MetaValue
 1
 id1125
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id1
 val
 2
 id1126
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id2
 val
 3
 id1127
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id3
 val
 4
 id1128
 created2020-08-06 16:30:23
 modified2020-08-06 16:44:51
 modelPrototypeInstance
 foreign_key1
 meta_key_id4
 val
 Group
 Group
 00
- $request->data(empty)
- $this->validationErrors
 CmsPlugin(empty)
 Setting(empty)
 BootstrapInstance(empty)
 PrototypeInstance(empty)
 PublishingInformation(empty)
 MetaValue(empty)
 Permission(empty)
 Group(empty)
 GroupsPermission(empty)
 PrototypeCategory(empty)
 CustomFieldValue(empty)
 Attachment(empty)
 CustomField(empty)
 PrototypeItem(empty)
 EmailFormSubmission(empty)
 EmailForm(empty)
 User(empty)
 Country(empty)
 Image(empty)
 LoginToken(empty)
 PrototypeCategories(empty)
 Document(empty)
 CategoryBannerImage(empty)
 PrototypeCategoriesPrototypeItem(empty)
 Page(empty)
 MetaKey(empty)
- Loaded Helpers
 0Html
 1Form
 2Session
 3Cms
 4Copyright
 5GoogleMap
 6SocialMedia
 7ReCaptcha
 8Settings
 9AdminLink
 10AdminNav
 11AdminTab
 12ContentBlock
 13CustomField
 14EmailForm
 15EmailFormBlock
 16GalleryBlock
 17ModelLink
 18ModelLoad
 19MediaVersion
 20Media
 21Meta
 22Navigation
 23Prototype
 24PrototypeLink
 25Publishing
 26TinyMce
 27Users
 28Versioning
 29Toolbar
 30Number
 31SimpleGraph
 32HtmlToolbar
====
Include
+
Included Files

Include Paths
- 0/home/pyramidcms/2_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/2_0/Cake/
Included Files
- core(empty)
- app
  Behavior
  0APP/Model/Behavior/DynamicValidationBehavior.php
  1APP/CoreFiles/Model/Behavior/CmsDynamicValidationBehavior.php
  2APP/Model/Behavior/ValidateHabtmBehavior.php
  3APP/CoreFiles/Model/Behavior/CmsValidateHabtmBehavior.php
  4APP/Model/Behavior/SortableBehavior.php
  5APP/CoreFiles/Model/Behavior/CmsSortableBehavior.php
  6APP/Model/Behavior/SluggableBehavior.php
  7APP/CoreFiles/Model/Behavior/CmsSluggableBehavior.php
  8APP/Model/Behavior/CopyableBehavior.php
  9APP/CoreFiles/Model/Behavior/CmsCopyableBehavior.php
  10APP/Model/Behavior/MultiTreeBehavior.php
  11APP/CoreFiles/Model/Behavior/CmsMultiTreeBehavior.php
  12APP/Model/Behavior/ReCaptchaBehavior.php
  13APP/CoreFiles/Model/Behavior/CmsReCaptchaBehavior.php
  14APP/Model/Behavior/AppTreeBehavior.php
  15APP/CoreFiles/Model/Behavior/CmsAppTreeBehavior.php
  Cache
  0APP/CoreFiles/Lib/AppCache.php
  Component
  0APP/Controller/Component/NotifyComponent.php
  1APP/CoreFiles/Controller/Component/CmsNotifyComponent.php
  2APP/Controller/Component/AutoPaginateComponent.php
  3APP/CoreFiles/Controller/Component/CmsAutoPaginateComponent.php
  4APP/Controller/Component/MobileComponent.php
  5APP/CoreFiles/Controller/Component/CmsMobileComponent.php
  6APP/Controller/Component/AppPaginatorComponent.php
  7APP/CoreFiles/Controller/Component/CmsAppPaginatorComponent.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
  1APP/CoreFiles/Controller/CmsAppController.php
  Model
  0APP/Model/AppModel.php
  1APP/CoreFiles/Model/CmsAppModel.php
  2APP/Model/Token.php
  3APP/CoreFiles/Model/CmsToken.php
  Other
  0APP/webroot/index.php
  1APP/CoreFiles/Lib/CmsBootstrap.php
  2APP/CoreFiles/Event/CmsEventManager.php
  3APP/CoreFiles/Event/CmsEventListener.php
  Routing
  0APP/CoreFiles/Routing/Filter/CmsAssetDispatcher.php
  View
  0APP/CoreFiles/View/CmsView.php
- plugins
  Administration
  Config
  0Administration/Config/bootstrap.php
  1Administration/Config/events.php
  2Administration/Config/routes.php
  Plugin
  0Administration/Event/AdministrationEventListener.php
  1Administration/CorePlugin/Event/CmsAdministrationEventListener.php
  Component
  0Administration/Controller/Component/AdminComponent.php
  1Administration/CorePlugin/Controller/Component/CmsAdminComponent.php
  2Administration/Controller/Component/AdminNavComponent.php
  3Administration/CorePlugin/Controller/Component/CmsAdminNavComponent.php
  4Administration/Controller/Component/AdminTabComponent.php
  5Administration/CorePlugin/Controller/Component/CmsAdminTabComponent.php
  Caching
  Config
  0Caching/Config/bootstrap.php
  1Caching/Config/events.php
  2Caching/Config/routes.php
  Plugin
  0Caching/Event/CachingEventListener.php
  1Caching/CorePlugin/Event/CmsCachingEventListener.php
  Cache
  0Caching/Model/Behavior/CachedBehavior.php
  1Caching/CorePlugin/Model/Behavior/CmsCachedBehavior.php
  ContentBlocks
  Config
  0ContentBlocks/Config/bootstrap.php
  1ContentBlocks/Config/events.php
  2ContentBlocks/Config/routes.php
  Plugin
  0ContentBlocks/Event/ContentBlocksEventListener.php
  1ContentBlocks/CorePlugin/Event/CmsContentBlocksEventListener.php
  CustomFields
  Config
  0CustomFields/Config/bootstrap.php
  1CustomFields/Config/events.php
  2CustomFields/Config/routes.php
  Plugin
  0CustomFields/Event/CustomFieldsEventListener.php
  1CustomFields/CorePlugin/Event/CmsCustomFieldsEventListener.php
  Behavior
  0CustomFields/Model/Behavior/CustomFieldBehavior.php
  1CustomFields/CorePlugin/Model/Behavior/CmsCustomFieldBehavior.php
  2CustomFields/Model/Behavior/ExpandableBehavior.php
  3CustomFields/CorePlugin/Model/Behavior/CmsExpandableBehavior.php
  Model
  0CustomFields/Model/CustomFieldValue.php
  1CustomFields/CorePlugin/Model/CmsCustomFieldValue.php
  2CustomFields/Model/CustomFieldsAppModel.php
  3CustomFields/CorePlugin/Model/CmsCustomFieldsAppModel.php
  4CustomFields/Model/CustomField.php
  5CustomFields/CorePlugin/Model/CmsCustomField.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
  1EmailForms/CorePlugin/Event/CmsEmailFormsEventListener.php
  Component
  0EmailForms/Controller/Component/EmailFormsComponent.php
  1EmailForms/CorePlugin/Controller/Component/CmsEmailFormsComponent.php
  Model
  0EmailForms/Model/EmailFormSubmission.php
  1EmailForms/CorePlugin/Model/CmsEmailFormSubmission.php
  2EmailForms/Model/EmailFormsAppModel.php
  3EmailForms/CorePlugin/Model/CmsEmailFormsAppModel.php
  4EmailForms/Model/EmailForm.php
  5EmailForms/CorePlugin/Model/CmsEmailForm.php
  Galleries
  Config
  0Galleries/Config/bootstrap.php
  1Galleries/Config/events.php
  2Galleries/Config/routes.php
  Plugin
  0Galleries/Event/GalleriesEventListener.php
  1Galleries/CorePlugin/Event/CmsGalleriesEventListener.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
  1Linking/CorePlugin/Event/CmsLinkingEventListener.php
  Behavior
  0Linking/Model/Behavior/LinkableBehavior.php
  1Linking/CorePlugin/Model/Behavior/CmsLinkableBehavior.php
  Media
  Config
  0Media/Config/bootstrap.php
  1Media/Config/events.php
  2Media/Config/routes.php
  Plugin
  0Media/Event/MediaEventListener.php
  1Media/CorePlugin/Event/CmsMediaEventListener.php
  2Media/CorePlugin/Lib/MediaValidation.php
  3Media/CorePlugin/Lib/TransferValidation.php
  Model
  0Media/Model/Attachment.php
  1Media/CorePlugin/Model/CmsAttachment.php
  2Media/Model/MediaAppModel.php
  3Media/CorePlugin/Model/CmsMediaAppModel.php
  Behavior
  0Media/Model/Behavior/TransferBehavior.php
  1Media/CorePlugin/Model/Behavior/CmsTransferBehavior.php
  2Media/Model/Behavior/GeneratorBehavior.php
  3Media/CorePlugin/Model/Behavior/CmsGeneratorBehavior.php
  4Media/Model/Behavior/PolymorphicBehavior.php
  5Media/CorePlugin/Model/Behavior/CmsPolymorphicBehavior.php
  6Media/Model/Behavior/CouplerBehavior.php
  7Media/CorePlugin/Model/Behavior/CmsCouplerBehavior.php
  8Media/Model/Behavior/MetaBehavior.php
  9Media/CorePlugin/Model/Behavior/CmsMetaBehavior.php
  Metas
  Config
  0Metas/Config/bootstrap.php
  1Metas/Config/events.php
  2Metas/Config/routes.php
  Plugin
  0Metas/Event/MetasEventListener.php
  1Metas/CorePlugin/Event/CmsMetasEventListener.php
  Behavior
  0Metas/Model/Behavior/MetaTagBehavior.php
  1Metas/CorePlugin/Model/Behavior/CmsMetaTagBehavior.php
  Model
  0Metas/Model/MetaValue.php
  1Metas/CorePlugin/Model/CmsMetaValue.php
  2Metas/Model/MetaKey.php
  3Metas/CorePlugin/Model/CmsMetaKey.php
  Component
  0Metas/Controller/Component/MetaComponent.php
  1Metas/CorePlugin/Controller/Component/CmsMetaComponent.php
  Navigation
  Config
  0Navigation/Config/bootstrap.php
  1Navigation/Config/events.php
  2Navigation/Config/routes.php
  Plugin
  0Navigation/Event/NavigationEventListener.php
  1Navigation/CorePlugin/Event/CmsNavigationEventListener.php
  Pages
  Config
  0Pages/Config/bootstrap.php
  1Pages/Config/events.php
  2Pages/Config/routes.php
  Plugin
  0Pages/Event/PagesEventListener.php
  1Pages/CorePlugin/Event/CmsPagesEventListener.php
  Component
  0Pages/Controller/Component/PageSettingsComponent.php
  1Pages/CorePlugin/Controller/Component/CmsPageSettingsComponent.php
  Model
  0Pages/Model/Page.php
  1Pages/CorePlugin/Model/CmsPage.php
  2Pages/Model/PagesAppModel.php
  3Pages/CorePlugin/Model/CmsPagesAppModel.php
  PluginTools
  Config
  0PluginTools/Config/events.php
  1PluginTools/Config/routes.php
  Plugin
  0PluginTools/Event/PluginToolsEventListener.php
  Prototype
  Config
  0Prototype/Config/bootstrap.php
  1Prototype/Config/events.php
  2Prototype/Config/routes.php
  Plugin
  0Prototype/Event/PrototypeEventListener.php
  1Prototype/CorePlugin/Event/CmsPrototypeEventListener.php
  Model
  0Prototype/Model/PrototypeInstance.php
  1Prototype/CorePlugin/Model/CmsPrototypeInstance.php
  2Prototype/Model/PrototypeAppModel.php
  3Prototype/CorePlugin/Model/CmsPrototypeAppModel.php
  4Prototype/Model/PrototypeCategory.php
  5Prototype/CorePlugin/Model/CmsPrototypeCategory.php
  6Prototype/Model/PrototypeItem.php
  7Prototype/CorePlugin/Model/CmsPrototypeItem.php
  Controller
  0Prototype/Controller/PrototypeCategoriesController.php
  1Prototype/CorePlugin/Controller/CmsPrototypeCategoriesController.php
  2Prototype/Controller/PrototypeAppController.php
  3Prototype/CorePlugin/Controller/CmsPrototypeAppController.php
  Component
  0Prototype/Controller/Component/PrototypeBreadcrumbsComponent.php
  1Prototype/CorePlugin/Controller/Component/CmsPrototypeBreadcrumbsComponent.php
  Publishing
  Config
  0Publishing/Config/bootstrap.php
  1Publishing/Config/events.php
  2Publishing/Config/routes.php
  Plugin
  0Publishing/Event/PublishingEventListener.php
  1Publishing/CorePlugin/Event/CmsPublishingEventListener.php
  Behavior
  0Publishing/Model/Behavior/PublishableBehavior.php
  1Publishing/CorePlugin/Model/Behavior/CmsPublishableBehavior.php
  Model
  0Publishing/Model/PublishingInformation.php
  1Publishing/CorePlugin/Model/CmsPublishingInformation.php
  2Publishing/Model/PublishingAppModel.php
  3Publishing/CorePlugin/Model/CmsPublishingAppModel.php
  ReCaptcha
  Config
  0ReCaptcha/Config/bootstrap.php
  1ReCaptcha/Config/events.php
  2ReCaptcha/Config/routes.php
  Plugin
  0ReCaptcha/Event/ReCaptchaEventListener.php
  1ReCaptcha/CorePlugin/Event/CmsReCaptchaEventListener.php
  Rentals
  Config
  0Rentals/Config/bootstrap.php
  1Rentals/Config/events.php
  2Rentals/Config/routes.php
  Plugin
  0Rentals/Event/RentalsEventListener.php
  Search
  Behavior
  0Search/Model/Behavior/SearchableBehavior.php
  Settings
  Config
  0Settings/Config/bootstrap.php
  1Settings/Config/events.php
  2Settings/Config/routes.php
  Model
  0Settings/Model/Setting.php
  1Settings/CorePlugin/Model/CmsSetting.php
  2Settings/Model/SettingsAppModel.php
  3Settings/CorePlugin/Model/CmsSettingsAppModel.php
  Plugin
  0Settings/Event/SettingsEventListener.php
  1Settings/CorePlugin/Event/CmsSettingsEventListener.php
  Sitemap
  Config
  0Sitemap/Config/bootstrap.php
  1Sitemap/Config/events.php
  2Sitemap/Config/routes.php
  Plugin
  0Sitemap/Event/SitemapEventListener.php
  1Sitemap/CorePlugin/Event/CmsSitemapEventListener.php
  TinyMce
  Config
  0TinyMce/Config/bootstrap.php
  1TinyMce/Config/events.php
  2TinyMce/Config/routes.php
  Plugin
  0TinyMce/Event/TinyMceEventListener.php
  1TinyMce/CorePlugin/Event/CmsTinyMceEventListener.php
  TreeSort
  Behavior
  0TreeSort/Model/Behavior/TreeSortBehavior.php
  1TreeSort/CorePlugin/Model/Behavior/CmsTreeSortBehavior.php
  Component
  0TreeSort/Controller/Component/TreeSortComponent.php
  1TreeSort/CorePlugin/Controller/Component/CmsTreeSortComponent.php
  UrlCache
  Cache
  0UrlCache/Config/bootstrap.php
  Users
  Config
  0Users/Config/events.php
  1Users/Config/routes.php
  Plugin
  0Users/Event/UsersEventListener.php
  1Users/CorePlugin/Event/CmsUsersEventListener.php
  Behavior
  0Users/Model/Behavior/LockableBehavior.php
  1Users/CorePlugin/Model/Behavior/CmsLockableBehavior.php
  2Users/Model/Behavior/LockableChildBehavior.php
  3Users/CorePlugin/Model/Behavior/CmsLockableChildBehavior.php
  Model
  0Users/Model/Permission.php
  1Users/CorePlugin/Model/CmsPermission.php
  2Users/Model/UsersAppModel.php
  3Users/CorePlugin/Model/CmsUsersAppModel.php
  4Users/Model/Group.php
  5Users/CorePlugin/Model/CmsGroup.php
  6Users/Model/User.php
  7Users/CorePlugin/Model/CmsUser.php
  8Users/Model/Country.php
  9Users/CorePlugin/Model/CmsCountry.php
  10Users/Model/LoginToken.php
  11Users/CorePlugin/Model/CmsLoginToken.php
  Component
  0Users/Controller/Component/AuthsomeComponent.php
  1Users/CorePlugin/Controller/Component/CmsAuthsomeComponent.php
  2Users/Controller/Component/AccessControlComponent.php
  3Users/CorePlugin/Controller/Component/CmsAccessControlComponent.php
  Versioning
  Config
  0Versioning/Config/bootstrap.php
  1Versioning/Config/events.php
  2Versioning/Config/routes.php
  Plugin
  0Versioning/Event/VersioningEventListener.php
  1Versioning/CorePlugin/Event/CmsVersioningEventListener.php
  Behavior
  0Versioning/Model/Behavior/SoftDeleteBehavior.php
  1Versioning/CorePlugin/Model/Behavior/CmsSoftDeleteBehavior.php
  2Versioning/Model/Behavior/RevisionBehavior.php
  3Versioning/CorePlugin/Model/Behavior/CmsRevisionBehavior.php
  Component
  0Versioning/Controller/Component/PreviewComponent.php
  1Versioning/CorePlugin/Controller/Component/CmsPreviewComponent.php
====

Current Residential Property Development

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 170 ms Total Queries: 509 queries

Query Explain:

Memory

Timers

Logs

logins

View Variables

Included Files

Include Paths

Included Files

Total Time: 170 ms
Total Queries: 509 queries