Find Real Estate in Greater Victoria BC

Show Search Criteria

Notice (8): Undefined variable: marker [APP/View/Helper/GoogleMapHelper.php, line 328]Code Context                $markerIcon = $this->webroot . IMAGES_URL . '/' . $markerIcon;
            }
            $marker .= "newMarker = new google.maps.LatLng($latitude, $longitude);\n";
$mapId = 'listing_map'
$id = 'listing_944115'
$position = array(
	'latitude' => '48.430476',
	'longitude' => '-123.402832'
)
$options = array(
	'infoWindow' => true,
	'windowText' => '<div class="infoWindow"><strong><a href="/property/944115">908 Carlton Terr</a></strong><div class="price">$3,988,000</div><div class="infoWindowDetails"> Beds |  Baths |  SqFt</div>MLS: 944115<br><a href="/property/944115" class="btn">More Detail</a></div>',
	'markerTitle' => 'Title',
	'markerIcon' => 'https://maps.google.com/mapfiles/marker.png',
	'markerShadow' => 'https://maps.google.com/mapfiles/shadow50.png',
	'noScript' => false
)
$geolocation = false
$latitude = '48.430476'
$longitude = '-123.402832'
$infoWindow = true
$windowText = '<div class="infoWindow"><strong><a href="/property/944115">908 Carlton Terr</a></strong><div class="price">$3,988,000</div><div class="infoWindowDetails"> Beds |  Baths |  SqFt</div>MLS: 944115<br><a href="/property/944115" class="btn">More Detail</a></div>'
$markerTitle = 'Title'
$markerIcon = 'https://maps.google.com/mapfiles/marker.png'
$markerShadow = 'https://maps.google.com/mapfiles/shadow50.png'
$noScript = false
$marker = null
GoogleMapHelper::addMarker() - APP/View/Helper/GoogleMapHelper.php, line 328
include - APP/Plugin/VrebListings/View/Elements/vreb_listing_map.ctp, line 27
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::_renderElement() - /usr/local/share/pyramidcms/Cake/View/View.php, line 1227
View::element() - /usr/local/share/pyramidcms/Cake/View/View.php, line 415
DebugView::element() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 63
include - APP/Plugin/VrebListings/View/VrebListings/search.ctp, line 45
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 472
DebugView::render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 82
Controller::render() - /usr/local/share/pyramidcms/Cake/Controller/Controller.php, line 952
Dispatcher::_invoke() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 194
Dispatcher::dispatch() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 103

Notice (8): Undefined variable: marker [APP/View/Helper/GoogleMapHelper.php, line 328]Code Context                $markerIcon = $this->webroot . IMAGES_URL . '/' . $markerIcon;
            }
            $marker .= "newMarker = new google.maps.LatLng($latitude, $longitude);\n";
$mapId = 'listing_map'
$id = 'listing_938447'
$position = array(
	'latitude' => '48.435122',
	'longitude' => '-123.396192'
)
$options = array(
	'infoWindow' => true,
	'windowText' => '<div class="infoWindow"><strong><a href="/property/938447">10 - 831 Devonshire Rd</a></strong><div class="price"></div><div class="infoWindowDetails"> Beds |  Baths |  SqFt</div>MLS: 938447<br><a href="/property/938447" class="btn">More Detail</a></div>',
	'markerTitle' => 'Title',
	'markerIcon' => 'https://maps.google.com/mapfiles/marker.png',
	'markerShadow' => 'https://maps.google.com/mapfiles/shadow50.png',
	'noScript' => false
)
$geolocation = false
$latitude = '48.435122'
$longitude = '-123.396192'
$infoWindow = true
$windowText = '<div class="infoWindow"><strong><a href="/property/938447">10 - 831 Devonshire Rd</a></strong><div class="price"></div><div class="infoWindowDetails"> Beds |  Baths |  SqFt</div>MLS: 938447<br><a href="/property/938447" class="btn">More Detail</a></div>'
$markerTitle = 'Title'
$markerIcon = 'https://maps.google.com/mapfiles/marker.png'
$markerShadow = 'https://maps.google.com/mapfiles/shadow50.png'
$noScript = false
$marker = null
GoogleMapHelper::addMarker() - APP/View/Helper/GoogleMapHelper.php, line 328
include - APP/Plugin/VrebListings/View/Elements/vreb_listing_map.ctp, line 27
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::_renderElement() - /usr/local/share/pyramidcms/Cake/View/View.php, line 1227
View::element() - /usr/local/share/pyramidcms/Cake/View/View.php, line 415
DebugView::element() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 63
include - APP/Plugin/VrebListings/View/VrebListings/search.ctp, line 45
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 472
DebugView::render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 82
Controller::render() - /usr/local/share/pyramidcms/Cake/Controller/Controller.php, line 952
Dispatcher::_invoke() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 194
Dispatcher::dispatch() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 103

Notice (8): Undefined variable: marker [APP/View/Helper/GoogleMapHelper.php, line 328]Code Context                $markerIcon = $this->webroot . IMAGES_URL . '/' . $markerIcon;
            }
            $marker .= "newMarker = new google.maps.LatLng($latitude, $longitude);\n";
$mapId = 'listing_map'
$id = 'listing_935832'
$position = array(
	'latitude' => '48.429907',
	'longitude' => '-123.407167'
)
$options = array(
	'infoWindow' => true,
	'windowText' => '<div class="infoWindow"><strong><a href="/property/935832">B305 - 1102 Esquimalt Rd</a></strong><div class="price">$509,900</div><div class="infoWindowDetails">1 Beds | 1 Baths | 602 SqFt</div>MLS: 935832<br><a href="/property/935832" class="btn">More Detail</a></div>',
	'markerTitle' => 'Title',
	'markerIcon' => 'https://maps.google.com/mapfiles/marker.png',
	'markerShadow' => 'https://maps.google.com/mapfiles/shadow50.png',
	'noScript' => false
)
$geolocation = false
$latitude = '48.429907'
$longitude = '-123.407167'
$infoWindow = true
$windowText = '<div class="infoWindow"><strong><a href="/property/935832">B305 - 1102 Esquimalt Rd</a></strong><div class="price">$509,900</div><div class="infoWindowDetails">1 Beds | 1 Baths | 602 SqFt</div>MLS: 935832<br><a href="/property/935832" class="btn">More Detail</a></div>'
$markerTitle = 'Title'
$markerIcon = 'https://maps.google.com/mapfiles/marker.png'
$markerShadow = 'https://maps.google.com/mapfiles/shadow50.png'
$noScript = false
$marker = null
GoogleMapHelper::addMarker() - APP/View/Helper/GoogleMapHelper.php, line 328
include - APP/Plugin/VrebListings/View/Elements/vreb_listing_map.ctp, line 27
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::_renderElement() - /usr/local/share/pyramidcms/Cake/View/View.php, line 1227
View::element() - /usr/local/share/pyramidcms/Cake/View/View.php, line 415
DebugView::element() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 63
include - APP/Plugin/VrebListings/View/VrebListings/search.ctp, line 45
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 472
DebugView::render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 82
Controller::render() - /usr/local/share/pyramidcms/Cake/Controller/Controller.php, line 952
Dispatcher::_invoke() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 194
Dispatcher::dispatch() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 103

Notice (8): Undefined variable: marker [APP/View/Helper/GoogleMapHelper.php, line 328]Code Context                $markerIcon = $this->webroot . IMAGES_URL . '/' . $markerIcon;
            }
            $marker .= "newMarker = new google.maps.LatLng($latitude, $longitude);\n";
$mapId = 'listing_map'
$id = 'listing_871686'
$position = array(
	'latitude' => '48.445912',
	'longitude' => '-123.400354'
)
$options = array(
	'infoWindow' => true,
	'windowText' => '<div class="infoWindow"><strong><a href="/property/871686">101 - 1085 Tillicum Rd</a></strong><div class="price">$549,888</div><div class="infoWindowDetails">2 Beds | 2 Baths | 1,178 SqFt</div>MLS: 871686<br><a href="/property/871686" class="btn">More Detail</a></div>',
	'markerTitle' => 'Title',
	'markerIcon' => 'https://maps.google.com/mapfiles/marker.png',
	'markerShadow' => 'https://maps.google.com/mapfiles/shadow50.png',
	'noScript' => false
)
$geolocation = false
$latitude = '48.445912'
$longitude = '-123.400354'
$infoWindow = true
$windowText = '<div class="infoWindow"><strong><a href="/property/871686">101 - 1085 Tillicum Rd</a></strong><div class="price">$549,888</div><div class="infoWindowDetails">2 Beds | 2 Baths | 1,178 SqFt</div>MLS: 871686<br><a href="/property/871686" class="btn">More Detail</a></div>'
$markerTitle = 'Title'
$markerIcon = 'https://maps.google.com/mapfiles/marker.png'
$markerShadow = 'https://maps.google.com/mapfiles/shadow50.png'
$noScript = false
$marker = null
GoogleMapHelper::addMarker() - APP/View/Helper/GoogleMapHelper.php, line 328
include - APP/Plugin/VrebListings/View/Elements/vreb_listing_map.ctp, line 27
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::_renderElement() - /usr/local/share/pyramidcms/Cake/View/View.php, line 1227
View::element() - /usr/local/share/pyramidcms/Cake/View/View.php, line 415
DebugView::element() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 63
include - APP/Plugin/VrebListings/View/VrebListings/search.ctp, line 45
View::_evaluate() - /usr/local/share/pyramidcms/Cake/View/View.php, line 946
View::_render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 908
DebugView::_render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 43
View::render() - /usr/local/share/pyramidcms/Cake/View/View.php, line 472
DebugView::render() - /usr/local/share/pyramidcms/V1/lib/Cms/Plugin/DebugKit/View/DebugView.php, line 82
Controller::render() - /usr/local/share/pyramidcms/Cake/Controller/Controller.php, line 952
Dispatcher::_invoke() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 194
Dispatcher::dispatch() - /usr/local/share/pyramidcms/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 103

Page 4 of 4, showing listings 73-76 of 76 using the following criteria:

District
- Esquimalt

Page 4 of 4, showing listings 73-76 of 76.

908 Carlton Terr Esquimalt - Es Esquimalt

$3,988,000

Listed with DFH Real Estate - Sidney

More Detail

10 - 831 Devonshire Rd Esquimalt - Es Old Esquimalt

$19.00/ SqFt

Listed with Firm Management Corporation

More Detail

B305 - 1102 Esquimalt Rd Esquimalt - Es Saxe Point

$509,900

1 Bed | 1 Bath | 602 SqFt

Listed with Coldwell Banker Oceanside Real Estate

More Detail

101 - 1085 Tillicum Rd Esquimalt - Es Kinsmen Park

$549,888

2 Bed | 2 Bath | 1,178 SqFt

Listed with My Move Realty

More Detail

First Previous 1 2 3 4 Next

NOTE: MLS® property information is provided under copyright© by the Victoria Real Estate Board. The information is from sources deemed reliable, but should not be relied upon without independent verification.

Query	Affected	Num. rows	Took (ms)	Actions
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` = 'VrebListing' AND `MetaValue`.`foreign_key` = (938447)	0	0	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` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (935832)	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` = 'VrebListing' AND `MetaValue`.`foreign_key` = (935832)	0	0	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` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (871686)	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` = 'VrebListing' AND `MetaValue`.`foreign_key` = (871686)	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 `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 `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 `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 `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` = 'VrebListings.Reciprocity.Disclaimers.summary' ORDER BY `Setting`.`rank` ASC LIMIT 1	0	0	0
SELECT `EmailForm`.`id`, `EmailForm`.`name`, `EmailForm`.`created`, `EmailForm`.`modified`, `EmailForm`.`recipient`, `EmailForm`.`use_recipient_list`, `EmailForm`.`recipient_list_label`, `EmailForm`.`subject_template`, `EmailForm`.`content_template`, `EmailForm`.`auto_response_enabled`, `EmailForm`.`auto_response_subject_template`, `EmailForm`.`auto_response_content_template`, `EmailForm`.`attach_file`, `EmailForm`.`math_captcha`, `EmailForm`.`success_text`, `EmailForm`.`success_title`, `EmailForm`.`submit_button_text`, `EmailForm`.`cc`, `EmailForm`.`bcc`, `EmailForm`.`super_admin`, `EmailForm`.`deleted`, `EmailForm`.`deleted_date`, `EmailForm`.`submit_button_onclick`, `EmailForm`.`redirect_page_id`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `madsenlanglois_db`.`email_forms` AS `EmailForm` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `EmailForm`.`id` AND `PublishingInformation`.`model` = 'EmailForm') WHERE `EmailForm`.`id` = 6 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-18 22:29:20' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:29:20')) AND `EmailForm`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `EmailFormGroup`.`id`, `EmailFormGroup`.`name`, `EmailFormGroup`.`email_form_id`, `EmailFormGroup`.`rank` FROM `madsenlanglois_db`.`email_form_groups` AS `EmailFormGroup` WHERE `EmailFormGroup`.`email_form_id` = (6) ORDER BY `EmailFormGroup`.`rank` ASC	1	1	0
SELECT `EmailFormField`.`id`, `EmailFormField`.`name`, `EmailFormField`.`default`, `EmailFormField`.`type`, `EmailFormField`.`required`, `EmailFormField`.`validate`, `EmailFormField`.`label`, `EmailFormField`.`validate_message`, `EmailFormField`.`rank`, `EmailFormField`.`options`, `EmailFormField`.`foreign_key`, `EmailFormField`.`model`, `EmailFormField`.`display_label`, `EmailFormField`.`group`, `EmailFormField`.`placeholder`, `EmailFormField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `EmailFormField` WHERE `EmailFormField`.`model` = 'EmailFormGroup' AND `EmailFormField`.`foreign_key` = (12) ORDER BY `EmailFormField`.`rank` ASC, `EmailFormField`.`id` ASC	3	3	0
SELECT `EmailFormRecipient`.`id`, `EmailFormRecipient`.`email_form_id`, `EmailFormRecipient`.`name`, `EmailFormRecipient`.`email_address`, `EmailFormRecipient`.`rank` FROM `madsenlanglois_db`.`email_form_recipients` AS `EmailFormRecipient` WHERE `EmailFormRecipient`.`email_form_id` = (6) ORDER BY `EmailFormRecipient`.`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.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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `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:29:20' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:29:20')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	21	21	1
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `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	1	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` = '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	1	maybe slow
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `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`.`id` = 2 AND `NavigationMenuItem`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `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`.`parent_id` = 2 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-18 22:29:20' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-18 22:29:20')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	4	4	1	maybe slow
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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	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	0
SELECT `BootstrapVrebInstance`.`id`, `BootstrapVrebInstance`.`name`, `BootstrapVrebInstance`.`slug` FROM `vrebradarhill_vreb_database`.`prototype_instances` AS `BootstrapVrebInstance` WHERE `id` IN (1, 2)	2	2	0
SELECT `VrebAgent`.`agent_ID`, `VrebAgent`.`office_ID` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` WHERE `VrebAgent`.`agent_ID` = '3742' LIMIT 1	1	1	0
SELECT `VrebOffice`.`firm_MUI` FROM `vrebradarhill_vreb_database`.`rets_offices` AS `VrebOffice` WHERE `VrebOffice`.`office_ID` = 292 LIMIT 1	1	1	0
SELECT `VrebOffice`.`firm_MUI` FROM `vrebradarhill_vreb_database`.`rets_offices` AS `VrebOffice` WHERE `VrebOffice`.`office_ID` = 292 LIMIT 1	1	1	0
SELECT `VrebOffice`.`firm_MUI` FROM `vrebradarhill_vreb_database`.`rets_offices` AS `VrebOffice` WHERE `VrebOffice`.`office_ID` = 292 LIMIT 1	1	1	0
SELECT `VrebOffice`.`firm_MUI` FROM `vrebradarhill_vreb_database`.`rets_offices` AS `VrebOffice` WHERE `VrebOffice`.`office_ID` = 292 LIMIT 1	1	1	0
SELECT `VrebOffice`.`firm_MUI` FROM `vrebradarhill_vreb_database`.`rets_offices` AS `VrebOffice` WHERE `VrebOffice`.`office_ID` = 292 LIMIT 1	1	1	0
SELECT `VrebOffice`.`firm_MUI` FROM `vrebradarhill_vreb_database`.`rets_offices` AS `VrebOffice` WHERE `VrebOffice`.`office_ID` = 292 LIMIT 1	1	1	0
SELECT `VrebListing`., `PublishingInformation`., `ListOffice`.`firm_MUI`, `ListOffice`.`matrix_unique_ID`, `ListOffice`.`office_ID`, `ListOffice`.`name`, (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `ListOffice` ON (`VrebListing`.`LA_office_ID` = `ListOffice`.`office_ID`) WHERE `VrebListing`.`district` = 'Esquimalt' AND ((`VrebListing`.`reciprocity` = '1') OR (((`VrebListing`.`LA_agent_ID` = '3742') OR (`VrebListing`.`LACO1_agent_ID` = '3742') OR (`VrebListing`.`LACO2_agent_ID` = '3742') OR (`VrebListing`.`SA_agent_ID` = '3742') OR (`VrebListing`.`SACO1_agent_ID` = '3742') OR (`VrebListing`.`SACO2_agent_ID` = '3742'))) OR (((`VrebListing`.`LA_firm_MUI` = '292') OR (`VrebListing`.`LACO1_firm_MUI` = '292') OR (`VrebListing`.`LACO2_firm_MUI` = '292') OR (`VrebListing`.`SA_firm_MUI` = '292') OR (`VrebListing`.`SACO1_firm_MUI` = '292') OR (`VrebListing`.`SACO2_firm_MUI` = '292')))) AND `VrebListing`.`status` = 'Current' AND `VrebListing`.`id` > 250000 AND `VrebListing`.`LA_agent_ID` NOT IN ('3053', '749', '1669', '4457', '1033', '3738', '682', '1994', '3766', '4248') AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) AND ((`PublishingInformation`.`published` IS NULL) OR (`PublishingInformation`.`published` = '1')) ORDER BY IFNULL(`PublishingInformation`.`featured`, 0) DESC, `VrebListing`.`date_list` DESC LIMIT 72, 24	4	4	1117	maybe slow
SELECT `OpenHouse`.`description`, `OpenHouse`.`foodtype`, `OpenHouse`.`from_date`, `OpenHouse`.`from_time`, `OpenHouse`.`is_active`, `OpenHouse`.`listing_ID`, `OpenHouse`.`matrix_unique_ID`, `OpenHouse`.`mod_date_time`, `OpenHouse`.`openhousetype`, `OpenHouse`.`table_MUI`, `OpenHouse`.`to_date`, `OpenHouse`.`to_time`, `OpenHouse`.`VirtualOpenHouseURL`, `OpenHouse`.`id`, `OpenHouse`.`ListingId` FROM `vrebradarhill_vreb_database`.`rets_open_houses` AS `OpenHouse` WHERE `OpenHouse`.`is_active` = '1' AND `OpenHouse`.`to_date` >= CURDATE() AND `OpenHouse`.`openhousetype` = 'Licensees & Public' AND `OpenHouse`.`listing_ID` IN (944115, 938447, 935832, 871686) ORDER BY `OpenHouse`.`from_date` ASC	0	0	0
SELECT `VrebListing`., `PublishingInformation`., (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `ListOffice` ON (`VrebListing`.`LA_office_ID` = `ListOffice`.`office_ID`) WHERE `VrebListing`.`district` = 'Esquimalt' AND ((`VrebListing`.`reciprocity` = '1') OR (((`VrebListing`.`LA_agent_ID` = '3742') OR (`VrebListing`.`LACO1_agent_ID` = '3742') OR (`VrebListing`.`LACO2_agent_ID` = '3742') OR (`VrebListing`.`SA_agent_ID` = '3742') OR (`VrebListing`.`SACO1_agent_ID` = '3742') OR (`VrebListing`.`SACO2_agent_ID` = '3742'))) OR (((`VrebListing`.`LA_firm_MUI` = '292') OR (`VrebListing`.`LACO1_firm_MUI` = '292') OR (`VrebListing`.`LACO2_firm_MUI` = '292') OR (`VrebListing`.`SA_firm_MUI` = '292') OR (`VrebListing`.`SACO1_firm_MUI` = '292') OR (`VrebListing`.`SACO2_firm_MUI` = '292')))) AND `VrebListing`.`status` = 'Current' AND `VrebListing`.`id` > 250000 AND `VrebListing`.`LA_agent_ID` NOT IN ('3053', '749', '1669', '4457', '1033', '3738', '682', '1994', '3766', '4248') AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) AND ((`PublishingInformation`.`published` IS NULL) OR (`PublishingInformation`.`published` = '1')) LIMIT 250	76	76	1180	maybe slow
SELECT `OpenHouse`.`description`, `OpenHouse`.`foodtype`, `OpenHouse`.`from_date`, `OpenHouse`.`from_time`, `OpenHouse`.`is_active`, `OpenHouse`.`listing_ID`, `OpenHouse`.`matrix_unique_ID`, `OpenHouse`.`mod_date_time`, `OpenHouse`.`openhousetype`, `OpenHouse`.`table_MUI`, `OpenHouse`.`to_date`, `OpenHouse`.`to_time`, `OpenHouse`.`VirtualOpenHouseURL`, `OpenHouse`.`id`, `OpenHouse`.`ListingId` FROM `vrebradarhill_vreb_database`.`rets_open_houses` AS `OpenHouse` WHERE `OpenHouse`.`is_active` = '1' AND `OpenHouse`.`to_date` >= CURDATE() AND `OpenHouse`.`openhousetype` = 'Licensees & Public' AND `OpenHouse`.`listing_ID` IN (871686, 935832, 938447, 943451, 944099, 944115, 946724, 948579, 948676, 948677, 949742, 949995, 950011, 950434, 950458, 950946, 951200, 951519, 951569, 951650, 951722, 953077, 953141, 953418, 953718, 953802, 954439, 954677, 954947, 954948, 955069, 955195, 955304, 955359, 955400, 955584, 955645, 955765, 955802, 956314, 956337, 956570, 956599, 956629, 956632, 956633, 956814, 956898, 956904, 956914, 957042, 957064, 957645, 957783, 957862, 957901, 958042, 958116, 958214, 959266, 959280, 959409, 959605, 959732, 959827, 959883, 959997, 960124, 960142, 960191, 960454, 960535, 960682, 960683, 960716, 960767) ORDER BY `OpenHouse`.`from_date` ASC	0	0	0
SELECT `VrebListing`., `PublishingInformation`., (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 944115 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1
SELECT `VrebListing`., `PublishingInformation`., (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 938447 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1
SELECT `VrebListing`., `PublishingInformation`., (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 935832 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`., `PublishingInformation`., (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 871686 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1

Message	Memory use
Component initialization	14.49 MB
Controller action start	16.97 MB
Controller render start	20.18 MB
View render complete	28.95 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	99.75
Component initialization and startup	18.60
Controller action	6478.37
Render Controller Action	542.96
» Rendering View	541.99
» » Rendering APP/Plugin/VrebListings/View/VrebListings/search.ctp	296.13
» » » Rendering CORE/V1/lib/Cms/Plugin/VrebListings/View/Elements/search/map.ctp	10.41
» » » Rendering CORE/V1/lib/Cms/Plugin/VrebListings/View/Elements/search/form.ctp	7.76
» » » Rendering APP/Plugin/VrebListings/View/Elements/vreb_listing_map.ctp	258.74
» » » » Rendering APP/Plugin/VrebListings/View/Elements/vreb_listing_feed_1.ctp	9.79
» » » » » Rendering APP/Plugin/VrebListings/View/Elements/pagination/top.ctp	0.67
» » » » » Rendering CORE/V1/lib/Cms/Plugin/VrebListings/View/Elements/pagination/bottom.ctp	0.89
» » » » Rendering CORE/V1/lib/Cms/Plugin/EmailForms/View/Elements/email_form.ctp	4.54
» » » » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp	0.21
» » » » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #2	0.18
» » » » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #3	0.21
» » » » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #4	0.18
» » » » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #5	0.23
» » Rendering APP/View/Layouts/single-column.ctp	205.65
» » » Rendering APP/View/Elements/layout/header.ctp	149.26
» » » » Rendering CORE/V1/lib/Cms/Plugin/VrebListings/View/Elements/header_scripts.ctp	0.46
» » » » Rendering APP/View/Elements/gtm_head.ctp	0.36
» » » » Rendering APP/Plugin/VrebListings/View/Elements/metas.ctp	0.36
» » » » Rendering APP/View/Elements/gtm_body.ctp	0.29
» » » Rendering APP/View/Elements/layout/footer.ctp	32.84

Find Real Estate in Greater Victoria BC

default

Total Time: 30 ms
Total Queries: 247 queries

Query Explain:

vreb_user

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

Query Explain:

vreb_rets

Total Time: 2302 ms
Total Queries: 17 queries

Query Explain:

Memory

Timers

Find Real Estate in Greater Victoria BC

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 30 ms Total Queries: 247 queries

Query Explain:

vreb_user

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

Query Explain:

vreb_rets

Total Time: 2302 ms Total Queries: 17 queries

Query Explain:

Memory

Timers

Logs

View Variables

Included Files

Include Paths

Included Files

Total Time: 30 ms
Total Queries: 247 queries

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

Total Time: 2302 ms
Total Queries: 17 queries