Archives August 2022

Update on Market Conditions in Greater Victoria and Why It Matters

Posted by Niels Madsen on August 15, 2022
Estimated Read Time: 4 minutes

Being able to provide knowledgeable and effective real estate advice to our clients is a key part of the service we provide, and in order to do that, we need to have an understanding of a wide variety of factors, including market trends and outlooks for the region.

However, it’s not just professionals that can benefit from that knowledge. For homeowners and prospective buyers, knowing what’s happening can help you make informed choices, and guide your decision making process.

With that in mind, here’s why buying and selling at the right time is so important, and what the market conditions in Victoria are telling us about whether now is the right time for you to make your move.

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

Cake Params
- pluginblog
- controllerblog_posts
- actionarchive
- named(empty)
- pass
  02022
  108
- year2022
- month08
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys
  0year
  1month
- options
  pass
  0year
  1month
- defaults
  pluginblog
  controllerblog_posts
  actionarchive
- template/victoria-blog/archive/:year/:month
====

Sql Log

Sql Logs

default

Total Time: 116 ms
Total Queries: 229 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Gallery`.`id`, `Gallery`.`name` FROM `madsenlanglois_db`.`galleries` AS `Gallery` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-18 22:30:58' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:30:58')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	1	1	0
SELECT `VrebListingFeed`.`id`, `VrebListingFeed`.`name` FROM `madsenlanglois_db`.`vreb_listing_feeds` AS `VrebListingFeed` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `VrebListingFeed`.`id` AND `PublishingInformation`.`model` = 'VrebListingFeed') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-18 22:30:58' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:30:58')) AND `VrebListingFeed`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	7	7	0
SELECT * FROM prototype_instances AS PrototypeInstance	2	2	0
SELECT PrototypeItem.val AS testimonial FROM prototype_items INNER JOIN publishing_information ON publishing_information.foreign_key = prototype_items.id AND publishing_information.model = 'PrototypeItem' AND publishing_information.published = 1 AND ( publishing_information.start <= NOW() AND ( publishing_information.end IS NULL OR publishing_information.end > NOW() ) ) LEFT JOIN custom_field_values AS PrototypeItem ON PrototypeItem.foreign_key = prototype_items.id AND PrototypeItem.key = 'testimonial' LEFT JOIN attachments AS Image ON Image.foreign_key = prototype_items.id AND Image.model = 'PrototypeItem' AND Image.group = 'Image' LEFT JOIN attachments AS Document ON Document.foreign_key = prototype_items.id AND Document.model = 'PrototypeItem' AND Document.group = 'Document' WHERE prototype_items.prototype_instance_id = 1 AND prototype_items.featured = 1 AND prototype_items.deleted = 0 ORDER BY RAND() LIMIT 1	1	1	4	maybe slow
SELECT `HeaderSlideshowImage`.`id`, `HeaderSlideshowImage`.`model`, `HeaderSlideshowImage`.`foreign_key`, `HeaderSlideshowImage`.`dirname`, `HeaderSlideshowImage`.`basename`, `HeaderSlideshowImage`.`checksum`, `HeaderSlideshowImage`.`alternative`, `HeaderSlideshowImage`.`group`, `HeaderSlideshowImage`.`created`, `HeaderSlideshowImage`.`modified`, `HeaderSlideshowImage`.`rank`, `HeaderSlideshowImage`.`deleted`, `HeaderSlideshowImage`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `HeaderSlideshowImage__path` FROM `madsenlanglois_db`.`attachments` AS `HeaderSlideshowImage` WHERE `model` = 'InstalledPlugin' AND `foreign_key` = 27 AND `group` = 'Header Slideshow' AND `deleted` = '0' ORDER BY `HeaderSlideshowImage`.`rank` ASC, `HeaderSlideshowImage`.`rank` ASC	8	8	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'HeaderSlideshowImage' AND `CustomFieldValue`.`foreign_key` IN (95, 91, 92, 94, 96, 102, 103, 104)	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.gtm_association_code' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (126) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (126) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`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	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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (20) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Agency.phone' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (75) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (75) 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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	5	5	0
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `madsenlanglois_db`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 1 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-18 22:30:58' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:30:58')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	21	21	6	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	5	5	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 293 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (293)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 48 ORDER BY `CustomField`.`rank` ASC 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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	5	5	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 293 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (293)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 48 ORDER BY `CustomField`.`rank` ASC 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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 19 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (19)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (19)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 19 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (19)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (19)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 20 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (20)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (20)	8	8	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 20 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (20)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (20)	8	8	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 14 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (14)	6	6	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 14 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (14)	6	6	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 45 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (45)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (45)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 45 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (45)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (45)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 41 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (41)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (41)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 41 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (41)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (41)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 24 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (24)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 24 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (24)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 40 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (40)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (40)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 40 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (40)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (40)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 31 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (31)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 31 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (31)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 33 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (33)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (33)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 33 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (33)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (33)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 15 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (15)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 15 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (15)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 12 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 12 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 13 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (13)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 13 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (13)	5	5	0
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `madsenlanglois_db`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 2 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (2)	5	5	0
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 23 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (23)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (23)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 23 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (23)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (23)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 11 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	5	5	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 292 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (292)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 46 ORDER BY `CustomField`.`rank` ASC 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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 11 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	5	5	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 292 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (292)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 46 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	0
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `madsenlanglois_db`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 1 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	5	5	0
SELECT YEAR(`PublishingInformation`.`start`) AS year, MONTH(`PublishingInformation`.`start`) AS month, `BlogPost`.`id` FROM `madsenlanglois_db`.`blog_posts` AS `BlogPost` LEFT JOIN `madsenlanglois_db`.`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` <= '2024-04-18 22:30:58' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:30:58')) GROUP BY year, month ORDER BY `year` DESC, `month` ASC	100	100	8	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (126, 127, 128, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 100, 101, 103, 104, 105, 106, 108, 109, 110, 111, 112, 113, 81, 82, 83, 84, 87, 89, 92, 95, 96, 97, 98, 99, 67, 68, 69, 70, 71, 72, 73, 75, 76, 77, 79, 80, 51, 52, 53, 56, 57, 58, 60, 61, 64, 65, 66, 45, 38, 39, 41, 42, 43, 44, 48, 46, 49, 50, 23, 24, 25, 26, 27, 29, 28, 30, 34, 33, 35, 36, 14, 13, 15, 16, 17, 18, 20, 8, 19, 21, 32, 9, 10, 11, 12)	490	490	1
SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`deleted`, `BlogCategory`.`deleted_date` FROM `madsenlanglois_db`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`deleted` = '0' ORDER BY `BlogCategory`.`lft` ASC	13	13	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 `madsenlanglois_db`.`blog_posts` AS `BlogPost` LEFT JOIN `madsenlanglois_db`.`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` <= '2024-04-18 22:30:58' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:30:58'))	101	101	63	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 30, 32, 33, 34, 35, 36, 38, 39, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 56, 57, 58, 59, 60, 61, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 75, 76, 77, 79, 80, 81, 82, 83, 84, 87, 89, 92, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128)	495	495	1
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 `madsenlanglois_db`.`blog_categories` AS `BlogCategory` JOIN `madsenlanglois_db`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPostCategory`.`blog_post_id` IN (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 30, 32, 33, 34, 35, 36, 38, 39, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 56, 57, 58, 59, 60, 61, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 75, 76, 77, 79, 80, 81, 82, 83, 84, 87, 89, 92, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128) AND `BlogPostCategory`.`blog_category_id` = `BlogCategory`.`id`)	239	239	1
SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date` FROM `madsenlanglois_db`.`blog_tags` AS `BlogTag` WHERE `BlogTag`.`deleted` = '0' ORDER BY `BlogTag`.`name` ASC	47	47	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 `madsenlanglois_db`.`blog_posts` AS `BlogPost` LEFT JOIN `madsenlanglois_db`.`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` <= '2024-04-18 22:30:58' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:30:58'))	101	101	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` IN (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 30, 32, 33, 34, 35, 36, 38, 39, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 56, 57, 58, 59, 60, 61, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 75, 76, 77, 79, 80, 81, 82, 83, 84, 87, 89, 92, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128)	495	495	1
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 `madsenlanglois_db`.`blog_tags` AS `BlogTag` JOIN `madsenlanglois_db`.`blog_post_tags` AS `BlogPostTag` ON (`BlogPostTag`.`blog_post_id` IN (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 30, 32, 33, 34, 35, 36, 38, 39, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 52, 53, 56, 57, 58, 59, 60, 61, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 75, 76, 77, 79, 80, 81, 82, 83, 84, 87, 89, 92, 95, 96, 97, 98, 99, 100, 101, 103, 104, 105, 106, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128) AND `BlogPostTag`.`blog_tag_id` = `BlogTag`.`id`)	398	398	1
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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.facebook' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (70) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (70) 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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.facebook' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (70) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (70) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.linkedin' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (71) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (71) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.instagram' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (127) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (127) 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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.instagram' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (127) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (127) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.youtube' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (72) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (72) 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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.youtube' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (72) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (72) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.twitter' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (119) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (119) 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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.twitter' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (119) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (119) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.phone' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (14) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (14) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Agency.phone' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (75) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (75) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Agency.name' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (73) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (73) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.address' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (9) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (9) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.city' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (10) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (10) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.province_state' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (11) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (11) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.postal_zip' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (12) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (12) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.email' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (16) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (16) 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 `madsenlanglois_db`.`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_user

Total Time: %s ms
Total Queries: %s queries

Query	Affected	Num. rows	Took (ms)	Actions

Query Explain:

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

vreb_rets

Total Time: 3 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`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (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 `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` INNER JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`Office`.`office_ID` = `VrebAgent`.`office_ID` AND `Office`.`vreb_idx_opt_in` = 1) WHERE `VrebAgent`.`agent_ID` = ('3742')	1	1	3	maybe slow
SELECT `BootstrapVrebInstance`.`id`, `BootstrapVrebInstance`.`name`, `BootstrapVrebInstance`.`slug` FROM `vrebradarhill_vreb_database`.`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 36.77 MB

Message	Memory use
Component initialization	13.64 MB
Controller action start	16.15 MB
Controller render start	18.52 MB
View render complete	27.78 MB

Timers

Total Request Time: 938 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	144.37
Component initialization and startup	23.33
Controller action	26.06
Render Controller Action	494.17
» Rendering View	489.24
» » Rendering APP/Plugin/Blog/View/BlogPosts/index.ctp	1.60
» » Rendering APP/View/Layouts/default.ctp	442.29
» » » Rendering APP/View/Elements/layout/header.ctp	97.33
» » » » Rendering CORE/V1/lib/Cms/Plugin/VrebListings/View/Elements/header_scripts.ctp	0.36
» » » » Rendering APP/View/Elements/gtm_head.ctp	0.27
» » » » Rendering APP/Plugin/Blog/View/Elements/metas.ctp	0.24
» » » » Rendering APP/View/Elements/gtm_body.ctp	0.17
» » » Rendering APP/View/Elements/layout/footer.ctp	338.83
» » » » Rendering CORE/V1/lib/Cms/Plugin/Blog/View/Elements/archive_nested_list.ctp	29.73
» » » » Rendering CORE/V1/lib/Cms/Plugin/Blog/View/Elements/categories_list.ctp	164.78
» » » » Rendering CORE/V1/lib/Cms/Plugin/Blog/View/Elements/tag_cloud.ctp	108.44

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- layout
- extraFooterCode
- extraHeaderCode
- pageIntro
- paginationLimit24
- paginationOptions
  024
  148
  296
- pageHeadingArchives August 2022
- titleTagArchives August 2022
- dates
  2022
  0808
- posts
  0
  BlogPost
  id109
  user_id1
  authorNiels Madsen
  titleUpdate on Market Conditions in Greater Victoria and Why It Matters
  slugupdate-on-market-conditions-in-greater-victoria
  url/victoria-blog/posts/update-on-market-conditions-in-greater-victoria
  summary<p dir="ltr">Being able to provide knowledgeable and effective real estate advice to our clients is a key part of the service we provide, and in order to do that, we need to have an understanding of a wide variety of factors, including market trends and outlooks for the region.</p> <p>However, it’s not just professionals that can benefit from that knowledge. For homeowners and prospective buyers, knowing what’s happening can help you make informed choices, and guide your decision making process. </p> <p>With that in mind, here’s why buying and selling at the right time is so important, and what the market conditions in Victoria are telling us about whether now is the right time for you to make your move.   </p>
  body<p dir="ltr">Being able to provide knowledgeable and effective real estate advice to our clients is a key part of the service we provide, and in order to do that, we need to have an understanding of a wide variety of factors, including market trends and outlooks for the region.</p> <p>However, it’s not just professionals that can benefit from that knowledge. For homeowners and prospective buyers, knowing what’s happening can help you make informed choices, and guide your decision making process. </p> <p>With that in mind, here’s why buying and selling at the right time is so important, and what the market conditions in Victoria are telling us about whether now is the right time for you to make your move.   </p> <h2>The Importance Of Buying And Selling At The Right Time </h2> <p>Planning is key when it comes to buying and selling your home. You want to be able to move as seamlessly as possible, as well as make the most of your opportunities to find the best home for you. </p> <p>And understanding the current and future market conditions can be a useful guiding line as you try and plan things out. For example, if you wish to move quickly, you need to be on top of all the important paperwork and preparations. Conversely, if you know you’re going to be waiting, you may want to take the time to make any renovations or cosmetic changes that could increase the value of your home. </p> <p>There’s also the matter of value. For example, if you’re looking to move to a particular neighbourhood or even just to a type of area that’s likely to be popular, as we’re seeing with moves away from built up urban areas currently, it could pay significantly to be ahead of the trend, rather than coming in after prices have risen significantly and demand has taken some of the better options. </p> <h2>Higher Prices Here To Stay</h2> <p>While the initial boom in house prices that took shape during the pandemic has not remained across all markets, in many areas, especially within Victoria, the trends towards higher prices and valuations have remained. </p> <p>In particular, a focus on suburban areas and first time buyers looking to move away from crowded urban areas remains a key trend to keep an eye on as we head towards 2023. </p> <p>Victoria is still seeing prices rising month over month, with the benchmark price for a single family home in Victoria’s core in June coming in at a 23% increase on the same time last year. This could be something that prospective sellers may want to capitalize on sooner rather than later, as many experts expect this slowing of the market to be a short term phenomenon. </p> <h2>MLS Current Statistics</h2> <p><a href="/real-estate-market" target="_blank" rel="noopener">From the VREB newsletter:</a> "<em>The Multiple Listing Service® Home Price Index benchmark value for a single family home in the Victoria Core in July 2021 was ,204,900. The benchmark value for the same home in July 2022 increased by 19 per cent to ,433,800 but was down 2.1 per cent from June's value of ,464,400. </em></p> <p><em>The MLS® HPI benchmark value for a condominium in the Victoria Core area in July 2021 was 2,600, while the benchmark value for the same condominium in July 2022 increased by 27.3 per cent to 9,600, down by 0.5 per cent from the June value of 3,100."</em></p> <p><em>Of course it should be noted that values will rise and fall over time, and historically local real e</em>state values slowly increase over time, which means that despite any month to month variations, if purchasing a home you will have a long term and sound investment. After all, people don’t buy and sell on a month to month basis! </p> <h2>Ongoing Inventory Concerns </h2> <p>One of the most common themes surrounding the real estate market in Victoria is the issue of inventory, with most estimates putting the overall stock as almost half what it would have been a decade ago. </p> <p>The knock on effect is that it’s a far more competitive market for sellers, who can command more leverage and get better value. However, inroads are starting to be made, and especially for first time buyers looking for a more modern home, this can be a fruitful time to be looking for new developments and options. </p> <p>Similarly, the pandemic has contributed to something of a bottleneck when it comes to construction with a number of units awaiting completion. This is why experts are calling for further moves to increase inventory, even as the current listings in Victoria have finally returned to their pre pandemic volume. </p> <h2>Room To Breathe </h2> <p>In addition to these inventory concerns, a market slowdown in terms of activity has been precipitated by the rise in interest rates over the preceding months. However, this does mean that buyers have been able to be more deliberate and selective when it comes to their choices, with a calmer and quieter market providing them with both more time and more options when it comes to finding their dream home. </p> <p>This is also reflected in buyer activity, which is seeing people postpone their summer purchases in lieu of making their decisions and moves in the autumn. This could have a knock on effect if the number of people making this choice reaches a high enough volume. </p> <hr /> <p>No matter what the market looks like, there is no substitute for the value provided by working with experienced and knowledgeable realtors, whether you’re selling or buying. At Madsen Langlois we pride ourselves on knowledge, dedication, and attention to detail. To find out more about how we can help you make the most of your real estate opportunities, contact us today. </p>
  allow_commenting(false)
  sticky(false)
  created2022-08-15 07:49:35
  modified2022-08-15 07:56:28
  deleted(false)
  deleted_date(null)
  rank0
  PublishingInformation
  id184
  created2022-08-15 07:49:36
  modified2022-08-15 07:49:36
  modelBlogPost
  foreign_key109
  start2022-08-15 07:46:23
  end(null)
  published(true)
  Image
  0
  id168
  modelBlogPost
  foreign_key109
  dirnameimg
  basenamehousing_market_trends.png
  checksum7d059478620f1c4cfe0048b1ff46ae3f
  alternativeHousing market trends
  groupImage
  created2022-08-15 07:55:08
  modified2022-08-15 07:56:29
  rank1
  deleted(false)
  deleted_date(null)
  pathimg/housing_market_trends.png
  MetaValue
  1
  id874
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id1
  valHere’s why buying and selling at the right time is so important, and what the market conditions in Victoria are telling us about whether now is the right time for you to make your move.
  2
  id875
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id2
  val
  3
  id876
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id3
  val
  4
  id877
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id4
  val
  5
  id878
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id5
  valhttps://www.madsenlanglois.com/media/attachments/view/img/housing_market_trends/png
- blogPosts
  0
  BlogPost
  id109
  user_id1
  authorNiels Madsen
  titleUpdate on Market Conditions in Greater Victoria and Why It Matters
  slugupdate-on-market-conditions-in-greater-victoria
  url/victoria-blog/posts/update-on-market-conditions-in-greater-victoria
  summary<p dir="ltr">Being able to provide knowledgeable and effective real estate advice to our clients is a key part of the service we provide, and in order to do that, we need to have an understanding of a wide variety of factors, including market trends and outlooks for the region.</p> <p>However, it’s not just professionals that can benefit from that knowledge. For homeowners and prospective buyers, knowing what’s happening can help you make informed choices, and guide your decision making process. </p> <p>With that in mind, here’s why buying and selling at the right time is so important, and what the market conditions in Victoria are telling us about whether now is the right time for you to make your move.   </p>
  body<p dir="ltr">Being able to provide knowledgeable and effective real estate advice to our clients is a key part of the service we provide, and in order to do that, we need to have an understanding of a wide variety of factors, including market trends and outlooks for the region.</p> <p>However, it’s not just professionals that can benefit from that knowledge. For homeowners and prospective buyers, knowing what’s happening can help you make informed choices, and guide your decision making process. </p> <p>With that in mind, here’s why buying and selling at the right time is so important, and what the market conditions in Victoria are telling us about whether now is the right time for you to make your move.   </p> <h2>The Importance Of Buying And Selling At The Right Time </h2> <p>Planning is key when it comes to buying and selling your home. You want to be able to move as seamlessly as possible, as well as make the most of your opportunities to find the best home for you. </p> <p>And understanding the current and future market conditions can be a useful guiding line as you try and plan things out. For example, if you wish to move quickly, you need to be on top of all the important paperwork and preparations. Conversely, if you know you’re going to be waiting, you may want to take the time to make any renovations or cosmetic changes that could increase the value of your home. </p> <p>There’s also the matter of value. For example, if you’re looking to move to a particular neighbourhood or even just to a type of area that’s likely to be popular, as we’re seeing with moves away from built up urban areas currently, it could pay significantly to be ahead of the trend, rather than coming in after prices have risen significantly and demand has taken some of the better options. </p> <h2>Higher Prices Here To Stay</h2> <p>While the initial boom in house prices that took shape during the pandemic has not remained across all markets, in many areas, especially within Victoria, the trends towards higher prices and valuations have remained. </p> <p>In particular, a focus on suburban areas and first time buyers looking to move away from crowded urban areas remains a key trend to keep an eye on as we head towards 2023. </p> <p>Victoria is still seeing prices rising month over month, with the benchmark price for a single family home in Victoria’s core in June coming in at a 23% increase on the same time last year. This could be something that prospective sellers may want to capitalize on sooner rather than later, as many experts expect this slowing of the market to be a short term phenomenon. </p> <h2>MLS Current Statistics</h2> <p><a href="/real-estate-market" target="_blank" rel="noopener">From the VREB newsletter:</a> "<em>The Multiple Listing Service® Home Price Index benchmark value for a single family home in the Victoria Core in July 2021 was ,204,900. The benchmark value for the same home in July 2022 increased by 19 per cent to ,433,800 but was down 2.1 per cent from June's value of ,464,400. </em></p> <p><em>The MLS® HPI benchmark value for a condominium in the Victoria Core area in July 2021 was 2,600, while the benchmark value for the same condominium in July 2022 increased by 27.3 per cent to 9,600, down by 0.5 per cent from the June value of 3,100."</em></p> <p><em>Of course it should be noted that values will rise and fall over time, and historically local real e</em>state values slowly increase over time, which means that despite any month to month variations, if purchasing a home you will have a long term and sound investment. After all, people don’t buy and sell on a month to month basis! </p> <h2>Ongoing Inventory Concerns </h2> <p>One of the most common themes surrounding the real estate market in Victoria is the issue of inventory, with most estimates putting the overall stock as almost half what it would have been a decade ago. </p> <p>The knock on effect is that it’s a far more competitive market for sellers, who can command more leverage and get better value. However, inroads are starting to be made, and especially for first time buyers looking for a more modern home, this can be a fruitful time to be looking for new developments and options. </p> <p>Similarly, the pandemic has contributed to something of a bottleneck when it comes to construction with a number of units awaiting completion. This is why experts are calling for further moves to increase inventory, even as the current listings in Victoria have finally returned to their pre pandemic volume. </p> <h2>Room To Breathe </h2> <p>In addition to these inventory concerns, a market slowdown in terms of activity has been precipitated by the rise in interest rates over the preceding months. However, this does mean that buyers have been able to be more deliberate and selective when it comes to their choices, with a calmer and quieter market providing them with both more time and more options when it comes to finding their dream home. </p> <p>This is also reflected in buyer activity, which is seeing people postpone their summer purchases in lieu of making their decisions and moves in the autumn. This could have a knock on effect if the number of people making this choice reaches a high enough volume. </p> <hr /> <p>No matter what the market looks like, there is no substitute for the value provided by working with experienced and knowledgeable realtors, whether you’re selling or buying. At Madsen Langlois we pride ourselves on knowledge, dedication, and attention to detail. To find out more about how we can help you make the most of your real estate opportunities, contact us today. </p>
  allow_commenting(false)
  sticky(false)
  created2022-08-15 07:49:35
  modified2022-08-15 07:56:28
  deleted(false)
  deleted_date(null)
  rank0
  PublishingInformation
  id184
  created2022-08-15 07:49:36
  modified2022-08-15 07:49:36
  modelBlogPost
  foreign_key109
  start2022-08-15 07:46:23
  end(null)
  published(true)
  Image
  0
  id168
  modelBlogPost
  foreign_key109
  dirnameimg
  basenamehousing_market_trends.png
  checksum7d059478620f1c4cfe0048b1ff46ae3f
  alternativeHousing market trends
  groupImage
  created2022-08-15 07:55:08
  modified2022-08-15 07:56:29
  rank1
  deleted(false)
  deleted_date(null)
  pathimg/housing_market_trends.png
  MetaValue
  1
  id874
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id1
  valHere’s why buying and selling at the right time is so important, and what the market conditions in Victoria are telling us about whether now is the right time for you to make your move.
  2
  id875
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id2
  val
  3
  id876
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id3
  val
  4
  id877
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id4
  val
  5
  id878
  created2022-08-15 07:49:36
  modified2022-08-15 07:56:29
  modelBlogPost
  foreign_key109
  meta_key_id5
  valhttps://www.madsenlanglois.com/media/attachments/view/img/housing_market_trends/png
- requested
  year2022
  monthAugust
  month_number08
  day0
- 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)
  LoginToken(empty)
  Group(empty)
  GroupsPermission(empty)
  BlogPost(empty)
  Image(empty)
  Page(empty)
  MetaKey(empty)
- Loaded Helpers
  0Html
  1Form
  2Session
  3Cms
  4AssetCompress
  5Copyright
  6GoogleMap
  7SocialMedia
  8ReCaptcha
  9Text
  10PageBlock
  11Settings
  12AdminLink
  13AdminNav
  14AdminTab
  15ContentBlock
  16CustomField
  17EmailForm
  18EmailFormBlock
  19GalleryBlock
  20ModelLink
  21ModelLoad
  22MediaVersion
  23Media
  24Meta
  25Navigation
  26Prototype
  27PrototypeLink
  28Publishing
  29Responsive
  30Theme
  31TinyMce
  32Users
  33Versioning
  34Property
  35Vreb
  36VrebListingFeedBlock
  37VrebSideCar
  38HeaderSlideshow
  39Blog
  40Toolbar
  41Number
  42SimpleGraph
  43App
  44HtmlToolbar
====
Include
+
Included Files

Include Paths
- 0/usr/local/share/pyramidcms/V1/lib/Cms/Plugin/Media/Lib/mm/src
- 2/opt/alt/php56/usr/share/pear
- 3/opt/alt/php56/usr/share/php
- 4/usr/local/share/pyramidcms/vendors
- 5-> /home/madsenlanglois/pyramidcms/Cake/
Included Files
- core(empty)
- app
  Behavior
  0APP/Model/Behavior/DynamicValidationBehavior.php
  1APP/Model/Behavior/ValidateHabtmBehavior.php
  2APP/Model/Behavior/SortableBehavior.php
  3APP/Model/Behavior/SluggableBehavior.php
  4APP/Model/Behavior/CopyableBehavior.php
  5APP/Model/Behavior/MultiTreeBehavior.php
  6APP/Model/Behavior/ReCaptchaBehavior.php
  7APP/Model/Behavior/AppTreeBehavior.php
  Component
  0APP/Controller/Component/NotifyComponent.php
  1APP/Controller/Component/AutoPaginateComponent.php
  2APP/Controller/Component/MobileComponent.php
  3APP/Controller/Component/AppPaginatorComponent.php
  4APP/Controller/Component/ControllerToolsComponent.php
  Config
  0APP/Config/core.php
  1APP/Config/pyramid.php
  2APP/Config/bootstrap.php
  3APP/Config/database.php
  4APP/Lib/Configure/JsonReader.php
  5APP/Config/routes.php
  Controller
  0APP/Controller/AppController.php
  Model
  0APP/Model/AppModel.php
  1APP/Model/Token.php
  Other
  0APP/webroot/index.php
- plugins
  Administration
  Config
  0Administration/Config/bootstrap.php
  1Administration/Config/events.php
  2Administration/Config/routes.php
  Plugin
  0Administration/Event/AdministrationEventListener.php
  Component
  0Administration/Controller/Component/AdminComponent.php
  1Administration/Controller/Component/AdminNavComponent.php
  2Administration/Controller/Component/AdminTabComponent.php
  AssetCompress
  Config
  0AssetCompress/Config/bootstrap.php
  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
  Caching
  Config
  0Caching/Config/bootstrap.php
  1Caching/Config/events.php
  2Caching/Config/routes.php
  Plugin
  0Caching/Event/CachingEventListener.php
  Cache
  0Caching/Model/Behavior/CachedBehavior.php
  ContentBlocks
  Config
  0ContentBlocks/Config/bootstrap.php
  1ContentBlocks/Config/events.php
  2ContentBlocks/Config/routes.php
  Plugin
  0ContentBlocks/Event/ContentBlocksEventListener.php
  CustomFields
  Config
  0CustomFields/Config/bootstrap.php
  1CustomFields/Config/events.php
  2CustomFields/Config/routes.php
  Plugin
  0CustomFields/Event/CustomFieldsEventListener.php
  Behavior
  0CustomFields/Model/Behavior/CustomFieldBehavior.php
  1CustomFields/Model/Behavior/ExpandableBehavior.php
  Model
  0CustomFields/Model/CustomFieldValue.php
  1CustomFields/Model/CustomFieldsAppModel.php
  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
  HeaderSlideshow
  Config
  0HeaderSlideshow/Config/bootstrap.php
  1HeaderSlideshow/Config/events.php
  2HeaderSlideshow/Config/routes.php
  Plugin
  0HeaderSlideshow/Event/HeaderSlideshowEventListener.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
  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
  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
  Users
  Config
  0Users/Config/events.php
  1Users/Config/routes.php
  Plugin
  0Users/Event/UsersEventListener.php
  Component
  0Users/Controller/Component/AuthsomeComponent.php
  1Users/Controller/Component/AccessControlComponent.php
  Model
  0Users/Model/User.php
  1Users/Model/UsersAppModel.php
  2Users/Model/Country.php
  3Users/Model/Permission.php
  4Users/Model/LoginToken.php
  5Users/Model/Group.php
  Versioning
  Config
  0Versioning/Config/bootstrap.php
  1Versioning/Config/events.php
  2Versioning/Config/routes.php
  Plugin
  0Versioning/Event/VersioningEventListener.php
  Behavior
  0Versioning/Model/Behavior/SoftDeleteBehavior.php
  1Versioning/Model/Behavior/RevisionBehavior.php
  Component
  0Versioning/Controller/Component/PreviewComponent.php
  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
====

Archives August 2022

Update on Market Conditions in Greater Victoria and Why It Matters

Posted by Niels Madsen on August 15, 2022
Estimated Read Time: 4 minutes

News Archives

Categories

Tags

default

Total Time: 116 ms
Total Queries: 229 queries

Query Explain:

vreb_user

Total Time: %s ms
Total Queries: %s queries

Query Explain:

vreb_rets

Total Time: 3 ms
Total Queries: 2 queries

Query Explain:

Memory

Timers

Archives August 2022

Update on Market Conditions in Greater Victoria and Why It Matters

Posted by Niels Madsen on August 15, 2022 Estimated Read Time: 4 minutes

News Archives

Categories

Tags

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 116 ms Total Queries: 229 queries

Query Explain:

vreb_user

Total Time: %s ms Total Queries: %s queries

Query Explain:

vreb_rets

Total Time: 3 ms Total Queries: 2 queries

Query Explain:

Memory

Timers

Logs

View Variables

Included Files

Include Paths

Included Files

Posted by Niels Madsen on August 15, 2022
Estimated Read Time: 4 minutes

Total Time: 116 ms
Total Queries: 229 queries

Total Time: %s ms
Total Queries: %s queries

Total Time: 3 ms
Total Queries: 2 queries