Kevin Sing

Victoria BC Real Estate Professional

Kevin's Real Estate Blog

DFH Cares - Sponsoring Clothing Drive for Our Place Society

Posted by Kevin Sing on March 25, 2015

Please bring in your donations of clean, used clothing, new clothing & socks, new toiletries (soap, shampoo, toothpaste, toothbrushes, combs, hair brushes, etc.), and any other items that would be useful to Our Place...

DFH Real Estate Ltd. Named Ambassadors of the BC Cancer Foundation

Posted by Kevin Sing on December 19, 2014

DFH Real Estate Ltd. announcement: DFH named ambassadors of the BC Cancer Foundation...

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgent
  time1506262624
  countdown10
- Users
  User(empty)
====
Request
+
Request

Cake Params
- pluginblog
- controllerblog_posts
- actionindex
- named(empty)
- pass(empty)
- isAjax(false)
- paging
  BlogPost
  page1
  current2
  count2
  prevPage(false)
  nextPage(false)
  pageCount1
  order
  BlogPost.stickydesc
  PublishingInformation.startDESC
  limit10
  options(empty)
  paramTypenamed
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults
  pluginblog
  controllerblog_posts
  actionindex
- template/blog/*
====

Sql Log

Sql Logs

default

Total Time: 220 ms
Total Queries: 163 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `active` = '1'	28	28	1
SELECT `Setting`.`key`, `Setting`.`value` FROM `kevinsingdb`.`settings` AS `Setting` WHERE 1 = 1	89	89	1
SELECT `BootstrapInstance`.`id`, `BootstrapInstance`.`name`, `BootstrapInstance`.`slug` FROM `kevinsingdb`.`prototype_instances` AS `BootstrapInstance` WHERE 1 = 1	0	0	0
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`slug` FROM `kevinsingdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0'	0	0	0
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`slug` FROM `kevinsingdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`allow_instance_view` = '1' AND `PrototypeInstance`.`deleted` = '0'	0	0	0
SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`slug` FROM `kevinsingdb`.`prototype_categories` AS `PrototypeCategory` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeCategory`.`id` AND `PublishingInformation`.`model` = 'PrototypeCategory') WHERE `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`rank` ASC	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 `kevinsingdb`.`permissions` AS `Permission` WHERE `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC	74	74	1
SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `kevinsingdb`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1	0	0	0
SELECT `BlogPost`.`id`, `BlogPost`.`user_id`, `BlogPost`.`author`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`url`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`allow_commenting`, `BlogPost`.`sticky`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`deleted`, `BlogPost`.`deleted_date`, `BlogPost`.`rank`, `User`.`id`, `User`.`email_address`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`company_name`, `User`.`address`, `User`.`address_two`, `User`.`city`, `User`.`province_state`, `User`.`postal_zip`, `User`.`phone`, `User`.`fax`, `User`.`website`, `User`.`country_id`, `User`.`last_login`, `User`.`admin_menu_order`, `User`.`deleted`, `User`.`deleted_date`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`blog_posts` AS `BlogPost` LEFT JOIN `kevinsingdb`.`users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `BlogPost`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:04' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:04')) ORDER BY `BlogPost`.`sticky` desc, `PublishingInformation`.`start` DESC LIMIT 10	2	2	23	maybe slow
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 `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'BlogPost' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` IN (7, 6) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (7, 6)	8	8	0
SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`deleted`, `BlogCategory`.`deleted_date`, `BlogPostCategory`.`id`, `BlogPostCategory`.`blog_category_id`, `BlogPostCategory`.`blog_post_id` FROM `kevinsingdb`.`blog_categories` AS `BlogCategory` JOIN `kevinsingdb`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPostCategory`.`blog_post_id` IN (7, 6) AND `BlogPostCategory`.`blog_category_id` = `BlogCategory`.`id`)	2	2	21	maybe slow
SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date`, `BlogPostTag`.`id`, `BlogPostTag`.`blog_tag_id`, `BlogPostTag`.`blog_post_id` FROM `kevinsingdb`.`blog_tags` AS `BlogTag` JOIN `kevinsingdb`.`blog_post_tags` AS `BlogPostTag` ON (`BlogPostTag`.`blog_post_id` IN (7, 6) AND `BlogPostTag`.`blog_tag_id` = `BlogTag`.`id`)	0	0	102	maybe slow
SELECT COUNT(*) AS `count` FROM `kevinsingdb`.`blog_posts` AS `BlogPost` LEFT JOIN `kevinsingdb`.`users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `BlogPost`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:05' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:05'))	1	1	1
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `kevinsingdb`.`pages` AS `Page` WHERE `controller` = 'blog_posts' AND `action` = 'index' 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (31)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (31)	4	4	0
SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `kevinsingdb`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC	5	5	0
SELECT `MetaKey`.`id`, `MetaKey`.`created`, `MetaKey`.`modified`, `MetaKey`.`name`, `MetaKey`.`type`, `MetaKey`.`default`, `MetaKey`.`rank`, `MetaKey`.`allow_default` FROM `kevinsingdb`.`meta_keys` AS `MetaKey` WHERE `MetaKey`.`name` = 'og:image' ORDER BY `MetaKey`.`rank` ASC LIMIT 1	1	1	14	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `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 `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Blog.commenting_disabled' LIMIT 1	1	1	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `AttachmentVersion`.`id`, `AttachmentVersion`.`created`, `AttachmentVersion`.`modified`, `AttachmentVersion`.`model`, `AttachmentVersion`.`foreign_key`, `AttachmentVersion`.`group`, `AttachmentVersion`.`name`, `AttachmentVersion`.`type`, `AttachmentVersion`.`convert`, `AttachmentVersion`.`width`, `AttachmentVersion`.`height`, `AttachmentVersion`.`deleted`, `AttachmentVersion`.`deleted_date` FROM `kevinsingdb`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0'	16	16	0
SELECT `Setting`.`key`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` LIKE 'Site.Contact.%' AND `Setting`.`value` != ''	9	9	1	maybe slow
SELECT `ContentBlock`.`id`, `ContentBlock`.`name` FROM `kevinsingdb`.`content_blocks` AS `ContentBlock` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ContentBlock`.`id` AND `PublishingInformation`.`model` = 'ContentBlock') WHERE `ContentBlock`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:05' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:05'))	3	3	1	maybe slow
SELECT `EmailForm`.`id`, `EmailForm`.`name` FROM `kevinsingdb`.`email_forms` AS `EmailForm` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `EmailForm`.`id` AND `PublishingInformation`.`model` = 'EmailForm') WHERE `EmailForm`.`super_admin` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:05' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:05')) AND `EmailForm`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	3	3	1	maybe slow
SELECT `Gallery`.`id`, `Gallery`.`name` FROM `kevinsingdb`.`galleries` AS `Gallery` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:05' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:05')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	0	0	0
SELECT `VrebListingFeed`.`id`, `VrebListingFeed`.`name` FROM `kevinsingdb`.`vreb_listing_feeds` AS `VrebListingFeed` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `VrebListingFeed`.`id` AND `PublishingInformation`.`model` = 'VrebListingFeed') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:05' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:05')) AND `VrebListingFeed`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	6	6	1	maybe slow
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0'	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `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 `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' 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 `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (20) 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 `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (20) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `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 `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.analytics_code' 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 `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (19) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (19) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `kevinsingdb`.`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 `kevinsingdb`.`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 `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	4	4	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 `kevinsingdb`.`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 `kevinsingdb`.`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 `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	4	4	0
SELECT `Setting`.`id`, `Setting`.`created`, `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 `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' 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 `kevinsingdb`.`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 `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 1 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	19	19	1	maybe slow
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 1 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 2 LIMIT 1	1	1	1
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `kevinsingdb`.`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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	4	4	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 `kevinsingdb`.`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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 29 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (29)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (29)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 29 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (29)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (29)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 24 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (24)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (24)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 24 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (24)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (24)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 18 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (18)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (18)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 18 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (18)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (18)	4	4	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 8 LIMIT 1	1	1	1
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 16 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 9 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 10 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 3 LIMIT 1	1	1	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 `kevinsingdb`.`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 `kevinsingdb`.`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 `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	4	4	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 `kevinsingdb`.`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 `kevinsingdb`.`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 `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 27 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (27)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (27)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 27 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (27)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (27)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 26 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (26)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (26)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 26 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (26)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (26)	4	4	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 13 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 12 LIMIT 1	1	1	1
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 11 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 4 LIMIT 1	1	1	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 13 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (13)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (13)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 13 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (13)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (13)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 28 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (28)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (28)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 28 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (28)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (28)	4	4	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 15 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 14 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 5 LIMIT 1	1	1	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 14 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (14)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (14)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 14 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (14)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (14)	4	4	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 6 LIMIT 1	1	1	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 30 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (30)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (30)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 30 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (30)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (30)	4	4	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 `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 15 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (15)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (15)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 15 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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (15)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (15)	5	5	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 17 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 18 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 19 LIMIT 1	1	1	0
SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 7 LIMIT 1	1	1	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 `kevinsingdb`.`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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	4	4	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 `kevinsingdb`.`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 `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	4	4	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`id` = 6 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC LIMIT 1	1	1	1
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`parent_id` = 6 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	3	3	1	maybe slow
SELECT `ContentBlock`.`id`, `ContentBlock`.`name`, `ContentBlock`.`content`, `ContentBlock`.`rank`, `ContentBlock`.`created`, `ContentBlock`.`modified`, `ContentBlock`.`deleted`, `ContentBlock`.`deleted_date`, `ContentBlock`.`super_admin`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`content_blocks` AS `ContentBlock` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ContentBlock`.`id` AND `PublishingInformation`.`model` = 'ContentBlock') WHERE `ContentBlock`.`id` = 1 AND `ContentBlock`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:06' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:06')) LIMIT 1	1	1	1
SELECT YEAR(`PublishingInformation`.`start`) AS year, MONTH(`PublishingInformation`.`start`) AS month, `BlogPost`.`id` FROM `kevinsingdb`.`blog_posts` AS `BlogPost` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `BlogPost`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:06' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:06')) GROUP BY year, month ORDER BY `year` DESC, `month` ASC	2	2	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (7, 6)	8	8	1	maybe slow
SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`deleted`, `BlogCategory`.`deleted_date` FROM `kevinsingdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`deleted` = '0' ORDER BY `BlogCategory`.`lft` ASC	1	1	0
SELECT `BlogPost`.`id`, `BlogPost`.`user_id`, `BlogPost`.`author`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`url`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`allow_commenting`, `BlogPost`.`sticky`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`deleted`, `BlogPost`.`deleted_date`, `BlogPost`.`rank`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`blog_posts` AS `BlogPost` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `BlogPost`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:06' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:06'))	2	2	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (6, 7)	8	8	0
SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`deleted`, `BlogCategory`.`deleted_date`, `BlogPostCategory`.`id`, `BlogPostCategory`.`blog_category_id`, `BlogPostCategory`.`blog_post_id` FROM `kevinsingdb`.`blog_categories` AS `BlogCategory` JOIN `kevinsingdb`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPostCategory`.`blog_post_id` IN (6, 7) AND `BlogPostCategory`.`blog_category_id` = `BlogCategory`.`id`)	2	2	0
SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date` FROM `kevinsingdb`.`blog_tags` AS `BlogTag` WHERE `BlogTag`.`deleted` = '0' ORDER BY `BlogTag`.`name` ASC	0	0	0
SELECT `BlogPost`.`id`, `BlogPost`.`user_id`, `BlogPost`.`author`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`url`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`allow_commenting`, `BlogPost`.`sticky`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`deleted`, `BlogPost`.`deleted_date`, `BlogPost`.`rank`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`blog_posts` AS `BlogPost` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `BlogPost`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:17:06' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:17:06'))	2	2	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (6, 7)	8	8	0
SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date`, `BlogPostTag`.`id`, `BlogPostTag`.`blog_tag_id`, `BlogPostTag`.`blog_post_id` FROM `kevinsingdb`.`blog_tags` AS `BlogTag` JOIN `kevinsingdb`.`blog_post_tags` AS `BlogPostTag` ON (`BlogPostTag`.`blog_post_id` IN (6, 7) AND `BlogPostTag`.`blog_tag_id` = `BlogTag`.`id`)	0	0	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `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 `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' 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 `kevinsingdb`.`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	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 `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0

Query Explain:

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

vreb_rets

Total Time: 1 ms
Total Queries: 2 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha` FROM `vrebradarhilldb`.`rets_agents` AS `VrebAgent` INNER JOIN `vrebradarhilldb`.`rets_offices` AS `Office` ON (`Office`.`office_ID` = `VrebAgent`.`office_ID` AND `Office`.`vreb_idx_opt_in` = 1) WHERE `VrebAgent`.`agent_ID` = ('3195')	1	1	1
SELECT `BootstrapVrebInstance`.`id`, `BootstrapVrebInstance`.`name`, `BootstrapVrebInstance`.`slug` FROM `vrebradarhilldb`.`prototype_instances` AS `BootstrapVrebInstance` WHERE `id` IN (1, 2)	2	2	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 45.91 MB

Message	Memory use
Component initialization	13.24 MB
Controller action start	15.37 MB
Controller render start	23.14 MB
View render complete	30.87 MB

Timers

Total Request Time: 2488 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	373.44
Component initialization and startup	88.49
Controller action	611.20
Render Controller Action	962.82
» Rendering View	844.82
» » Rendering APP/Plugin/Blog/View/BlogPosts/index.ctp	68.01
» » Rendering APP/View/Layouts/blog.ctp	523.50
» » » Rendering APP/View/Elements/layout/header.ctp	455.29
» » » » Rendering CORE/working/lib/Cms/Plugin/VrebListings/View/Elements/header_scripts.ctp	0.66
» » » » Rendering CORE/working/lib/Cms/View/Elements/clear_float.ctp	1.19
» » » » Rendering CORE/working/lib/Cms/View/Elements/clear_float.ctp #2	1.27
» » » Rendering APP/Plugin/Blog/View/Elements/archive_nested_list.ctp	37.00
» » » Rendering APP/Plugin/Blog/View/Elements/categories_list.ctp	5.71
» » » Rendering APP/Plugin/Blog/View/Elements/tag_cloud.ctp	5.26
» » » Rendering APP/View/Elements/layout/footer.ctp	5.80
» » » » Rendering CORE/working/lib/Cms/View/Elements/clear_float.ctp #3	1.08

====

Log
+

Logs

logins

Time Message
2017-09-24 03:17:04 Array ( [successful_login] => false )

====
Variables
+
View Variables
- metas
 application-name
 authorKevin Sing
 robotsNOODP
- layoutblog
- extraFooterCode
- extraHeaderCode
- pageIntro
- pageHeadingKevin's Real Estate Blog
- _page
 Page
 id31
 created2015-04-28 15:50:46
 modified2015-04-29 10:04:38
 internal_name
 titleBlog Posts
 page_headingKevin's Real Estate Blog
 content
 slugblog-posts
 path
 parent_id(null)
 lft38
 rght39
 layoutblog
 pluginblog
 controllerblog_posts
 actionindex
 extra
 protected(true)
 exclude_sitemap(false)
 deleted(false)
 deleted_date(null)
 password
 published(true)
 extra_header_code
 extra_footer_code
 override_title_format(false)
 super_admin(false)
 action_mapblog/blog_posts/index
 CustomFieldValue(empty)
 MetaValue
 1
 id137
 created2015-04-28 15:57:06
 modified2015-04-29 10:04:38
 modelPage
 foreign_key31
 meta_key_id1
 val
 2
 id138
 created2015-04-28 15:57:06
 modified2015-04-29 10:04:38
 modelPage
 foreign_key31
 meta_key_id2
 val
 3
 id139
 created2015-04-28 15:57:06
 modified2015-04-29 10:04:38
 modelPage
 foreign_key31
 meta_key_id3
 val
 4
 id140
 created2015-04-28 15:57:06
 modified2015-04-29 10:04:38
 modelPage
 foreign_key31
 meta_key_id4
 val
- paginationLimit25
- paginationOptions
 01
 15
 210
 325
 450
 5100
 6200
 7400
- blogPosts
 0
 BlogPost
 id7
 user_id1
 authorKevin Sing
 titleDFH Cares - Sponsoring Clothing Drive for Our Place Society
 slugdfh-cares-sponsoring-clothing-drive-for-our-place
 url/blog/posts/dfh-cares-sponsoring-clothing-drive-for-our-place
 summaryPlease bring in your donations of clean, used clothing, new clothing & socks, new toiletries (soap, shampoo, toothpaste, toothbrushes, combs, hair brushes, etc.), and any other items that would be useful to Our Place...
 body<h2>DFH Cares</h2> Clothing Drive for “Our Place Society” This is the official drop off site for the clothing drive. Please bring in your donations of clean, used clothing, new clothing & socks, new toiletries (soap, shampoo, toothpaste, toothbrushes, combs, hair brushes, etc.), and any other items that would be useful to Our Place. During the first week of May, DFH will gather all the donations and drop them off at Our Place. This is your opportunity to clean out your closet and donate all that clothing that you no longer wear! Also, Our Place always has a shortage of socks to give out to their patrons. On average, the Society gives out 100 pairs of socks a day, which translates to over 36,500 pairs of socks per year! If you have a way of providing a bulk donation of socks it would be very much appreciated. If you have any questions about this, please see Dave Philps or Ally Guevin. Thanks in advance for your support of this project.
 allow_commenting(false)
 sticky(false)
 created2015-04-29 09:20:35
 modified2015-04-29 09:20:48
 deleted(false)
 deleted_date(null)
 rank0
 User
 id1
 email_addressandrea
 passworde00fd470656796fabeacd739dad6547424b38cd6
 active(true)
 created2015-04-17 16:52:53
 modified2015-04-17 20:44:41
 first_nameRadar
 last_nameHill
 company_name(null)
 address(null)
 address_two(null)
 city(null)
 province_state(null)
 postal_zip(null)
 phone(null)
 fax(null)
 website(null)
 country_id1
 last_login2017-09-06 13:47:22
 admin_menu_order(null)
 deleted(false)
 deleted_date(null)
 full_nameRadar Hill
 PublishingInformation
 id38
 created2015-04-29 09:20:35
 modified2015-04-29 09:20:35
 modelBlogPost
 foreign_key7
 start2015-03-25 09:18:05
 end(null)
 published(true)
 Image(empty)
 MetaValue
 1
 id145
 created2015-04-29 09:20:35
 modified2015-04-29 09:20:48
 modelBlogPost
 foreign_key7
 meta_key_id1
 val
 2
 id146
 created2015-04-29 09:20:35
 modified2015-04-29 09:20:48
 modelBlogPost
 foreign_key7
 meta_key_id2
 val
 3
 id147
 created2015-04-29 09:20:35
 modified2015-04-29 09:20:48
 modelBlogPost
 foreign_key7
 meta_key_id3
 val
 4
 id148
 created2015-04-29 09:20:35
 modified2015-04-29 09:20:48
 modelBlogPost
 foreign_key7
 meta_key_id4
 val
 BlogCategory
 0
 id1
 parent_id(null)
 lft1
 rght2
 nameUncategorized
 sluguncategorized
 created2015-04-28 15:50:46
 modified2015-04-28 15:50:46
 deleted(false)
 deleted_date(null)
 BlogPostCategory
 id10
 blog_category_id1
 blog_post_id7
 url/blog/categories/uncategorized
 BlogTag(empty)
 1
 BlogPost
 id6
 user_id1
 authorKevin Sing
 titleDFH Real Estate Ltd. Named Ambassadors of the BC Cancer Foundation
 slugdfh-real-estate-ltd-named-ambassadors-of-the-bc-ca
 url/blog/posts/dfh-real-estate-ltd-named-ambassadors-of-the-bc-ca
 summaryDFH Real Estate Ltd. announcement: DFH named ambassadors of the BC Cancer Foundation...
 body<img src="/app/webroot/uploads/DFH_and_BC_Cancer_Society.jpg" alt="DFH and BC Cancer Foundation" title="DFH and BC Cancer Foundation" height="611" width="1231" />
 allow_commenting(false)
 sticky(false)
 created2015-04-29 09:15:10
 modified2015-04-29 09:17:52
 deleted(false)
 deleted_date(null)
 rank0
 User
 id1
 email_addressandrea
 passworde00fd470656796fabeacd739dad6547424b38cd6
 active(true)
 created2015-04-17 16:52:53
 modified2015-04-17 20:44:41
 first_nameRadar
 last_nameHill
 company_name(null)
 address(null)
 address_two(null)
 city(null)
 province_state(null)
 postal_zip(null)
 phone(null)
 fax(null)
 website(null)
 country_id1
 last_login2017-09-06 13:47:22
 admin_menu_order(null)
 deleted(false)
 deleted_date(null)
 full_nameRadar Hill
 PublishingInformation
 id37
 created2015-04-29 09:15:10
 modified2015-04-29 09:15:10
 modelBlogPost
 foreign_key6
 start2014-12-19 09:11:45
 end(null)
 published(true)
 Image(empty)
 MetaValue
 1
 id141
 created2015-04-29 09:15:10
 modified2015-04-29 09:17:52
 modelBlogPost
 foreign_key6
 meta_key_id1
 val
 2
 id142
 created2015-04-29 09:15:10
 modified2015-04-29 09:17:52
 modelBlogPost
 foreign_key6
 meta_key_id2
 val
 3
 id143
 created2015-04-29 09:15:10
 modified2015-04-29 09:17:52
 modelBlogPost
 foreign_key6
 meta_key_id3
 val
 4
 id144
 created2015-04-29 09:15:10
 modified2015-04-29 09:17:52
 modelBlogPost
 foreign_key6
 meta_key_id4
 val
 BlogCategory
 0
 id1
 parent_id(null)
 lft1
 rght2
 nameUncategorized
 sluguncategorized
 created2015-04-28 15:50:46
 modified2015-04-28 15:50:46
 deleted(false)
 deleted_date(null)
 BlogPostCategory
 id8
 blog_category_id1
 blog_post_id6
 url/blog/categories/uncategorized
 BlogTag(empty)
- titleTagBlog • Kevin Sing • Real Estate in Victoria, BC
- loggedIn(false)
- superAdmin(false)
- admin(false)
- $request->data(empty)
- $this->validationErrors
 CmsPlugin(empty)
 Setting(empty)
 BootstrapInstance(empty)
 VrebAgent(empty)
 PrototypeInstance(empty)
 PublishingInformation(empty)
 MetaValue(empty)
 PrototypeCategory(empty)
 CustomFieldValue(empty)
 PrototypeItem(empty)
 BootstrapVrebInstance(empty)
 EmailFormSubmission(empty)
 EmailForm(empty)
 User(empty)
 Country(empty)
 Permission(empty)
 Group(empty)
 GroupsPermission(empty)
 BlogPost(empty)
 BlogCategory(empty)
 Image(empty)
 BlogTag(empty)
 BlogPostCategory(empty)
 BlogPostTag(empty)
 Page(empty)
 MetaKey(empty)
- Loaded Helpers
 0Html
 1Form
 2Session
 3Cms
 4AssetCompress
 5Copyright
 6GoogleMap
 7SocialMedia
 8ReCaptcha
 9Text
 10Settings
 11AdminLink
 12AdminNav
 13AdminTab
 14ContentBlock
 15CustomField
 16EmailForm
 17EmailFormBlock
 18GalleryBlock
 19ModelLink
 20ModelLoad
 21MediaVersion
 22Media
 23Meta
 24Navigation
 25Prototype
 26PrototypeLink
 27Publishing
 28Responsive
 29Theme
 30TinyMce
 31Users
 32Versioning
 33Property
 34Vreb
 35VrebListingFeedBlock
 36VrebSideCar
 37Blog
 38Toolbar
 39Number
 40SimpleGraph
 41Paginator
 42HtmlToolbar
====
Include
+
Included Files

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

Kevin's Real Estate Blog

DFH Cares - Sponsoring Clothing Drive for Our Place Society

Posted by Kevin Sing on March 25, 2015

DFH Real Estate Ltd. Named Ambassadors of the BC Cancer Foundation

Posted by Kevin Sing on December 19, 2014

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 220 ms Total Queries: 163 queries

Query Explain:

vreb_rets

Total Time: 1 ms Total Queries: 2 queries

Query Explain:

Memory

Timers

Logs

logins

View Variables

Included Files

Include Paths

Included Files

Total Time: 220 ms
Total Queries: 163 queries

Total Time: 1 ms
Total Queries: 2 queries