Company Listings • Stacey English • Victoria BC Real Estate

Page 1 of 11, showing listings 1-24 of 250.

A - 609 Trutch St Victoria - Vi Fairfield West

$449,900

1 Bed | 1 Bath | 695 SqFt

More Detail

507 - 250 Douglas St Victoria - Vi James Bay

$559,000

2 Bed | 1 Bath | 1,050 SqFt

More Detail

4188 Clinton Pl Saanich West - SW Northridge

$989,900

4 Bed | 3 Bath | 2,506 SqFt

More Detail

2830 Scott St Victoria - Vi Oaklands

$1,199,000

4 Bed | 3 Bath | 1,867 SqFt

More Detail

335 Moss St Victoria - Vi Fairfield West

$1,775,000

4 Bed | 4 Bath | 2,737 SqFt

More Detail

312 - 3010 Washington Ave Victoria - Vi Burnside

$490,000

2 Bed | 2 Bath | 970 SqFt

More Detail

75 - 5838 Blythwood Rd Sooke - Sk Saseenos

$449,900

2 Bed | 2 Bath | 1,400 SqFt

More Detail

104 - 2510 Alexander St Duncan - Du East Duncan

$395,000

2 Bed | 2 Bath | 984 SqFt

More Detail

306 - 1258 Esquimalt Rd Esquimalt - Es Rockheights

$525,000

2 Bed | 1 Bath | 1,129 SqFt

More Detail

139 - 3640 Propeller Pl Colwood - Co Royal Bay

$849,900

3 Bed | 3 Bath | 1,757 SqFt

More Detail

1368 Rafiki Pl Central Saanich - CS Brentwood Bay

$1,295,000

4 Bed | 3 Bath | 2,277 SqFt

More Detail

301 - 2823 Jacklin Rd Langford - La Langford Proper

$519,900

2 Bed | 2 Bath | 1,023 SqFt

More Detail

1051 GOLDEN SPIRE Cres Langford - La Olympic View

$1,649,900

7 Bed | 4 Bath | 3,418 SqFt

More Detail

106 - 1964 John Rd North Saanich - NS McDonald Park

$899,900

3 Bed | 3 Bath | 1,760 SqFt

More Detail

105 - 1710 Fort St Victoria - Vi Jubilee

$500,000

2 Bed | 2 Bath | 906 SqFt

More Detail

117 St. Lawrence St Victoria - Vi James Bay

$1,000,000

3 Bed | 4 Bath | 1,846 SqFt

More Detail

2103 Townsend Rd Sooke - Sk Sooke Vill Core

$599,900

2 Bed | 1 Bath | 1,196 SqFt

More Detail

3160 Metchosin Rd Colwood - Co Wishart North

$649,000

3 Bed | 1 Bath | 1,585 SqFt

More Detail

210 - 521 Courtney St Victoria - Vi Downtown

$1,299,000

1 Bed | 2 Bath | 825 SqFt

More Detail

1410 Simon Rd Saanich East - SE Mt Doug

$1,399,000

5 Bed | 3 Bath | 2,466 SqFt

More Detail

7252 Early Pl Central Saanich - CS Brentwood Bay

$999,000

4 Bed | 3 Bath | 2,758 SqFt

More Detail

6 - 416 Dallas Rd Victoria - Vi James Bay

$1,499,900

3 Bed | 3 Bath | 2,268 SqFt

More Detail

403 - 280 Island Hwy View Royal - VR View Royal

$509,900

0 Bed | 0 Bath | 597 SqFt

More Detail

3769 Ascot Dr Saanich East - SE Cedar Hill

$1,295,000

3 Bed | 3 Bath | 2,465 SqFt

More Detail

1 2 3 4 5 6 7 8 9NextLast

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

Cake Params
- pluginpages
- controllerpages
- actionview
- named(empty)
- pass(empty)
- pathlistings/company-listings
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys
  0path
- options
  path(?!administration|caching|content_blocks|custom_fields|debug_kit|email_forms|galleries|install|linking|media|metas|navigation|pages|plugin_tools|prototype|publishing|re_captcha|search|settings|sitemap|tiny_mce|tree_sort|url_cache|users|versioning|vreb_listings|wizard|admin|items|images)(.*)
- defaults
  pluginpages
  controllerpages
  actionview
- template/:path
====

Sql Log

Sql Logs

default

Total Time: 196 ms
Total Queries: 219 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`id` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 18 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (18)	0	0	5	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (18)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`published` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`plugin` = '' AND `Page`.`lft` <= 9 AND `Page`.`rght` >= 10 AND `Page`.`deleted` = '0' ORDER BY `Page`.`lft` asc	2	2	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` IN (17, 18)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` IN (17, 18)	8	8	1	maybe slow
SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `staceyengdb`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC	4	4	1	maybe slow
SELECT `AttachmentVersion`.`id`, `AttachmentVersion`.`created`, `AttachmentVersion`.`modified`, `AttachmentVersion`.`model`, `AttachmentVersion`.`foreign_key`, `AttachmentVersion`.`group`, `AttachmentVersion`.`name`, `AttachmentVersion`.`type`, `AttachmentVersion`.`convert`, `AttachmentVersion`.`width`, `AttachmentVersion`.`height`, `AttachmentVersion`.`bgcolour`, `AttachmentVersion`.`gravity`, `AttachmentVersion`.`deleted`, `AttachmentVersion`.`deleted_date` FROM `staceyengdb`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0'	34	34	1
SELECT `Setting`.`key`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` LIKE 'Site.Contact.%' AND `Setting`.`value` != ''	10	10	1	maybe slow
SELECT `ContentBlock`.`id`, `ContentBlock`.`name` FROM `staceyengdb`.`content_blocks` AS `ContentBlock` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ContentBlock`.`id` AND `PublishingInformation`.`model` = 'ContentBlock') WHERE `ContentBlock`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-01-21 07:22:39' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:39'))	0	0	1	maybe slow
SELECT `EmailForm`.`id`, `EmailForm`.`name` FROM `staceyengdb`.`email_forms` AS `EmailForm` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `EmailForm`.`id` AND `PublishingInformation`.`model` = 'EmailForm') WHERE `EmailForm`.`super_admin` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-01-21 07:22:39' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:39')) AND `EmailForm`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	3	3	1	maybe slow
SELECT `Gallery`.`id`, `Gallery`.`name` FROM `staceyengdb`.`galleries` AS `Gallery` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-01-21 07:22:39' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:39')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	0	0	1	maybe slow
SELECT `VrebListingFeed`.`id`, `VrebListingFeed`.`name` FROM `staceyengdb`.`vreb_listing_feeds` AS `VrebListingFeed` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `VrebListingFeed`.`id` AND `PublishingInformation`.`model` = 'VrebListingFeed') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-01-21 07:22:39' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:39')) AND `VrebListingFeed`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	5	5	1	maybe slow
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `staceyengdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0'	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	1	maybe slow
SELECT `VrebListingFeed`.`id`, `VrebListingFeed`.`name`, `VrebListingFeed`.`description`, `VrebListingFeed`.`type`, `VrebListingFeed`.`order_one`, `VrebListingFeed`.`order_two`, `VrebListingFeed`.`order_three`, `VrebListingFeed`.`order_one_dir`, `VrebListingFeed`.`order_two_dir`, `VrebListingFeed`.`order_three_dir`, `VrebListingFeed`.`feature_top`, `VrebListingFeed`.`id_limit_type`, `VrebListingFeed`.`id_limit_val`, `VrebListingFeed`.`conditions`, `VrebListingFeed`.`query`, `VrebListingFeed`.`return_limit`, `VrebListingFeed`.`random_order`, `VrebListingFeed`.`paginate`, `VrebListingFeed`.`borrowed`, `VrebListingFeed`.`created`, `VrebListingFeed`.`modified`, `VrebListingFeed`.`deleted`, `VrebListingFeed`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `staceyengdb`.`vreb_listing_feeds` AS `VrebListingFeed` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `VrebListingFeed`.`id` AND `PublishingInformation`.`model` = 'VrebListingFeed') WHERE `VrebListingFeed`.`id` = 2 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-01-21 07:22:39' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:39')) AND `VrebListingFeed`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'VrebListing' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` IN (892104, 891960, 892071, 892207, 892274, 892351, 892380, 892399, 892469, 892470, 892485, 892520, 892571, 892581, 892590, 892591, 892604, 892612, 892625, 892630, 892645, 892661, 892665, 892667) ORDER BY `Document`.`rank` ASC, `Document`.`id` ASC	0	0	1	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'VrebListing' AND `Image`.`group` = 'Image' AND `Image`.`deleted` = '0' AND `Image`.`foreign_key` IN (892104, 891960, 892071, 892207, 892274, 892351, 892380, 892399, 892469, 892470, 892485, 892520, 892571, 892581, 892590, 892591, 892604, 892612, 892625, 892630, 892645, 892661, 892665, 892667) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`link`, `Link`.`vreb_listing_id`, `Link`.`created`, `Link`.`modified`, `Link`.`rank` FROM `staceyengdb`.`vreb_listing_links` AS `Link` WHERE `Link`.`vreb_listing_id` IN (892104, 891960, 892071, 892207, 892274, 892351, 892380, 892399, 892469, 892470, 892485, 892520, 892571, 892581, 892590, 892591, 892604, 892612, 892625, 892630, 892645, 892661, 892665, 892667) ORDER BY `Link`.`rank` ASC	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` IN (892104, 891960, 892071, 892207, 892274, 892351, 892380, 892399, 892469, 892470, 892485, 892520, 892571, 892581, 892590, 892591, 892604, 892612, 892625, 892630, 892645, 892661, 892665, 892667)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` IN (892104, 891960, 892071, 892207, 892274, 892351, 892380, 892399, 892469, 892470, 892485, 892520, 892571, 892581, 892590, 892591, 892604, 892612, 892625, 892630, 892645, 892661, 892665, 892667)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892104)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892104)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (891960)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (891960)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892071)	0	0	2	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892071)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892207)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892207)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892274)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892274)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892351)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892351)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892380)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892380)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892399)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892399)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892469)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892469)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892470)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892470)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892485)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892485)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892520)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892520)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892571)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892571)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892581)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892581)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892590)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892590)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892591)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892591)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892604)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892604)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892612)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892612)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892625)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892625)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892630)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892630)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892645)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892645)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892661)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892661)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892665)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892665)	0	0	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (892667)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (892667)	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.gtm_association_code' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (20) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (20) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`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 `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'ReCaptcha.invisible' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (41) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (41) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (1) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `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 `staceyengdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `staceyengdb`.`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` <= '2022-01-21 07:22:42' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:42')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	14	14	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 `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 17 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (17)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (17)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 17 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (17)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (17)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 18 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (18)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (18)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 18 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (18)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (18)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 19 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`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 `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (19)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 19 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`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 `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (19)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 20 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (20)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (20)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 20 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`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 `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (20)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 22 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (22)	0	0	1	maybe slow
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (22)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 22 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (22)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (22)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 23 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`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 `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (23)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 23 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`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 `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (23)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	1	1	1
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 11 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	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 `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 21 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (21)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (21)	4	4	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 41 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `staceyengdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (41)	0	0	1	maybe slow
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `staceyengdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 37 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	1
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 21 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (21)	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (21)	4	4	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 41 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `staceyengdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (41)	0	0	1	maybe slow
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `staceyengdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 37 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	0
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `staceyengdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 1 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	4	4	1	maybe slow
SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	4	4	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 42 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `staceyengdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (42)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `staceyengdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 38 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 `staceyengdb`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	1
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `staceyengdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	4	4	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `staceyengdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 42 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `staceyengdb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (42)	0	0	1	maybe slow
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `staceyengdb`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 38 ORDER BY `CustomField`.`rank` ASC 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 `staceyengdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`id` = 2 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC LIMIT 1	1	1	1
SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `staceyengdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `staceyengdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`lft` > 4 AND `NavigationMenuItem`.`rght` < 11 AND `NavigationMenuItem`.`navigation_menu_id` = 1 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-01-21 07:22:42' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:42')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	3	3	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (1) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.phone' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (15) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (15) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.toll_free' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`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	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (16) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.fax' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (17) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (17) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.email' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (18) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (18) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.email' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (18) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	0
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (18) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.address' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (10) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (10) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.city' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`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	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (11) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.province_state' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (12) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (12) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.postal_zip' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (13) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (13) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.SocialMedia.facebook' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (23) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (23) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.SocialMedia.facebook' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (23) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (23) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.SocialMedia.instagram' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (25) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (25) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.SocialMedia.instagram' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (25) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (25) ORDER BY `Document`.`rank` ASC	0	0	2	maybe slow
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `staceyengdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Footer.industry_identifier' ORDER BY `Setting`.`rank` ASC LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `staceyengdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (27) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `staceyengdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (27) ORDER BY `Document`.`rank` ASC	0	0	1	maybe slow

Query Explain:

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

vreb_rets

Total Time: 256 ms
Total Queries: 77 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha` FROM `vrebradarhilldb`.`rets_agents` AS `VrebAgent` INNER JOIN `vrebradarhilldb`.`rets_offices` AS `Office` ON (`Office`.`office_ID` = `VrebAgent`.`office_ID` AND `Office`.`vreb_idx_opt_in` = 1) WHERE `VrebAgent`.`agent_ID` = ('3078')	1	1	1
SELECT `BootstrapVrebInstance`.`id`, `BootstrapVrebInstance`.`name`, `BootstrapVrebInstance`.`slug` FROM `vrebradarhilldb`.`prototype_instances` AS `BootstrapVrebInstance` WHERE `id` IN (1, 2)	2	2	0
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`status` = ('Current') AND `VrebListing`.`id` NOT IN (344857, 353701, 347210, 358710, 349122, 364819, 338307, 348419, 335502, 362478, 364819, 368615, 362478, 335055, 330996, 356915, 387043, 374742, 356498, 346721, 345596) 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) AND (`PublishingInformation`.`start` <= '2022-01-21 07:22:39') AND (((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:39')))))) ORDER BY `VrebListing`.`date_list` DESC LIMIT 24	24	24	165	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 `vrebradarhilldb`.`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 (892104, 891960, 892071, 892207, 892274, 892351, 892380, 892399, 892469, 892470, 892485, 892520, 892571, 892581, 892590, 892591, 892604, 892612, 892625, 892630, 892645, 892661, 892665, 892667) ORDER BY `OpenHouse`.`from_date` ASC	0	0	1	maybe slow
SELECT COUNT(*) AS `count` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`status` = ('Current') AND `VrebListing`.`id` NOT IN (344857, 353701, 347210, 358710, 349122, 364819, 338307, 348419, 335502, 362478, 364819, 368615, 362478, 335055, 330996, 356915, 387043, 374742, 356498, 346721, 345596) 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) AND (`PublishingInformation`.`start` <= '2022-01-21 07:22:39') AND (((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-01-21 07:22:39')))))) LIMIT 250	1	1	43	maybe slow
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892104', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	1	1	1
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892104', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	1	1	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('891960', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('891960', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892071', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892071', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892207', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892207', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892274', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892274', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892351', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892351', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892380', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892380', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892399', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892399', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892469', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892469', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892470', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892470', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892485', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892485', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892520', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892520', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892571', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892571', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892581', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892581', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892590', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892590', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892591', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892591', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892604', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892604', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892612', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892612', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892625', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892625', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892630', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892630', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892645', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892645', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892661', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892661', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892665', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892665', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_listing_views (listing_id, summary) VALUES ('892667', 1) ON DUPLICATE KEY UPDATE summary = summary + 1	2	2	0
INSERT INTO vrebradarhilldb.rets_summary_view_times (listing_id, year_week, count) VALUES ('892667', '2022_03', 1) ON DUPLICATE KEY UPDATE count = count + 1	2	2	0
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892104 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 891960 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892071 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892207 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892274 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892351 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892380 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892399 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892469 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892470 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892485 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892520 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892571 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892581 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892590 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892591 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892604 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892612 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892625 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892630 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892645 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892661 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892665 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow
SELECT `VrebListing`.`bedrooms`, `VrebListing`.`class`, `VrebListing`.`date_entered`, `VrebListing`.`date_list`, `VrebListing`.`date_mod_date_time`, `VrebListing`.`date_p_mod_date_time`, `VrebListing`.`district`, `VrebListing`.`id`, `VrebListing`.`LA_agent_ID`, `VrebListing`.`LA_office_ID`, `VrebListing`.`LACO1_agent_ID`, `VrebListing`.`LACO1_office_ID`, `VrebListing`.`LACO2_agent_ID`, `VrebListing`.`LACO2_office_ID`, `VrebListing`.`lot_size_acres`, `VrebListing`.`lot_size_sqft`, `VrebListing`.`map_area`, `VrebListing`.`matrix_unique_ID`, `VrebListing`.`PermitReciprocityYN`, `VrebListing`.`postal_code`, `VrebListing`.`price_list`, `VrebListing`.`price_list_sqft`, `VrebListing`.`status`, `VrebListing`.`street`, `VrebListing`.`street_no`, `VrebListing`.`street_suffix`, `VrebListing`.`tot_sqft_finished`, `VrebListing`.`tot_sqft_unfinished`, `VrebListing`.`total_baths`, `VrebListing`.`trans_type`, `VrebListing`.`unit_no`, `VrebListing`.`listing_subtype`, `VrebListing`.`LA_firm_MUI`, `VrebListing`.`LACO1_firm_MUI`, `VrebListing`.`LACO2_firm_MUI`, `VrebListing`.`views`, `VrebListing`.`year_built`, `VrebListing`.`reciprocity`, `VrebListing`.`latitude`, `VrebListing`.`longitude`, `VrebListing`.`created`, `VrebListing`.`modified`, `VrebListing`.`date_sold`, `VrebListing`.`price_selling`, `VrebListing`.`SA_agent_ID`, `VrebListing`.`SA_office_ID`, `VrebListing`.`SACO1_agent_ID`, `VrebListing`.`SACO1_office_ID`, `VrebListing`.`SACO2_agent_ID`, `VrebListing`.`SACO2_office_ID`, `VrebListing`.`SA_firm_MUI`, `VrebListing`.`SACO1_firm_MUI`, `VrebListing`.`SACO2_firm_MUI`, `VrebListing`.`listing_type`, `VrebListing`.`lot_features`, `VrebListing`.`lot_features_COMM`, `VrebListing`.`agr_land_reserve`, `VrebListing`.`building_features`, `VrebListing`.`shared_amenities_feature`, `VrebListing`.`exterior_finish_feature_COMM`, `VrebListing`.`heating_feature_COMM`, `VrebListing`.`exterior_features_COMM`, `VrebListing`.`location_features`, `VrebListing`.`Waste_feature`, `VrebListing`.`services_available_feature`, `VrebListing`.`interior_features`, `VrebListing`.`exterior_finish_feature`, `VrebListing`.`roof_feature`, `VrebListing`.`heating_feature`, `VrebListing`.`exterior_features`, `VrebListing`.`parking_type_feature`, `VrebListing`.`age_youngest_allowed`, `VrebListing`.`ListingId`, `VrebListing`.`ListingKeyNumeric`, `VrebListing`.`internet_remarks`, (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` FROM `vrebradarhilldb`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `staceyengdb`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 892667 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	2	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 56.79 MB

Message	Memory use
Component initialization	12.15 MB
Controller action start	14.61 MB
Controller render start	25.47 MB
View render complete	34.40 MB

Timers

Total Request Time: 4540 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	318.69
Component initialization and startup	59.00
Controller action	60.98
Render Controller Action	2844.96
» Rendering View	2842.05
» » Rendering APP/Plugin/Pages/CorePlugin/View/Pages/view.ctp	2343.96
» » » Rendering APP/Plugin/VrebListings/CorePlugin/View/Elements/vreb_listing_feed.ctp	1932.00
» » » » Rendering APP/Plugin/VrebListings/CorePlugin/View/Elements/vreb_listing_feed_1.ctp	1881.31
» » » » » Rendering APP/Plugin/VrebListings/CorePlugin/View/Elements/pagination/top.ctp	10.28
» » » » » Rendering APP/Plugin/VrebListings/CorePlugin/View/Elements/pagination/bottom.ctp	12.42
» » Rendering APP/View/Layouts/listings.ctp	379.11
» » » Rendering APP/View/Elements/layout/header.ctp	213.90
» » » » Rendering APP/Plugin/VrebListings/CorePlugin/View/Elements/header_scripts.ctp	1.24
» » » » Rendering APP/View/Elements/gtm_head.ctp	0.95
» » » » Rendering APP/View/Elements/metas.ctp	0.67
» » » » Rendering APP/View/Elements/gtm_body.ctp	0.63
» » » Rendering APP/View/Elements/layout/footer.ctp	93.85

====

Log
+

Logs

logins

Time Message
2022-01-21 07:22:39 Array ( [successful_login] => false 54.80.252.84 )

2022-01-21 07:22:39 Array ( [successful_login] => false 54.80.252.84 )

====
Variables
+
View Variables
- metas
  descriptionQuality real estate & homes for sale in Greater Victoria BC, featured by Royal LePage. Including Oak Bay, Saanich, Esquimalt, Langford, Colwood, & more
  application-name
  robots
  og:image
- layoutlistings
- extraFooterCode
- extraHeaderCode
- pageIntro
- pageHeadingCompany Listings
- titleTagCompany Listings • Stacey English • Victoria BC Real Estate
- paginationLimit24
- paginationOptions
  024
  148
  296
- page
  Page
  id18
  created2019-08-29 12:13:15
  modified2020-01-07 13:31:26
  internal_name
  titleCompany Listings
  page_headingCompany Listings
  content<div class="block VrebListingFeed">{{block type="VrebListingFeed" id="2"}}</div>
  slugcompany-listings
  pathlistings/company-listings
  parent_id17
  lft9
  rght10
  layoutlistings
  plugin
  controller
  action
  extra
  protected(false)
  exclude_sitemap(false)
  deleted(false)
  deleted_date(null)
  password
  published(true)
  extra_header_code
  extra_footer_code
  override_title_format(false)
  super_admin(false)
  action_map
  Image
  0
  id3
  modelPage
  foreign_key18
  dirnameimg
  basenamestacey_listings_5.jpg
  checksumb6118a1a8b087741e4482dc58f442c2c
  alternative
  groupImage
  created2019-10-23 15:29:48
  modified2020-01-07 13:31:26
  rank3
  deleted(false)
  deleted_date(null)
  pathimg/stacey_listings_5.jpg
  CustomFieldValue(empty)
  MetaValue
  1
  id25
  created2019-08-29 12:13:15
  modified2020-01-07 13:31:26
  modelPage
  foreign_key18
  meta_key_id1
  valQuality real estate & homes for sale in Greater Victoria BC, featured by Royal LePage. Including Oak Bay, Saanich, Esquimalt, Langford, Colwood, & more
  2
  id26
  created2019-08-29 12:13:15
  modified2020-01-07 13:31:26
  modelPage
  foreign_key18
  meta_key_id2
  val
  3
  id27
  created2019-08-29 12:13:15
  modified2020-01-07 13:31:26
  modelPage
  foreign_key18
  meta_key_id3
  val
  4
  id28
  created2019-08-29 12:13:15
  modified2020-01-07 13:31:26
  modelPage
  foreign_key18
  meta_key_id4
  val
- banner
  Image
  0
  id3
  modelPage
  foreign_key18
  dirnameimg
  basenamestacey_listings_5.jpg
  checksumb6118a1a8b087741e4482dc58f442c2c
  alternative
  groupImage
  created2019-10-23 15:29:48
  modified2020-01-07 13:31:26
  rank3
  deleted(false)
  deleted_date(null)
  pathimg/stacey_listings_5.jpg
- loggedIn(false)
- superAdmin(false)
- admin(false)
- $request->data(empty)
- $this->validationErrors
  CmsPlugin(empty)
  Setting(empty)
  BootstrapInstance(empty)
  VrebAgent(empty)
  PrototypeInstance(empty)
  PublishingInformation(empty)
  MetaValue(empty)
  PrototypeCategory(empty)
  CustomFieldValue(empty)
  PrototypeItem(empty)
  BootstrapVrebInstance(empty)
  EmailFormSubmission(empty)
  EmailForm(empty)
  User(empty)
  Country(empty)
  Permission(empty)
  LoginToken(empty)
  Group(empty)
  GroupsPermission(empty)
  Page(empty)
  Image(empty)
  MetaKey(empty)
- Loaded Helpers
  0Html
  1Form
  2Session
  3Cms
  4Copyright
  5GoogleMap
  6SocialMedia
  7ReCaptcha
  8Pages
  9Settings
  10AdminLink
  11AdminNav
  12AdminTab
  13ContentBlock
  14CustomField
  15EmailForm
  16EmailFormBlock
  17GalleryBlock
  18ModelLink
  19ModelLoad
  20MediaVersion
  21Media
  22Meta
  23Navigation
  24Prototype
  25PrototypeLink
  26Publishing
  27TinyMce
  28Users
  29Versioning
  30Property
  31Vreb
  32VrebListingFeedBlock
  33VrebSideCar
  34Toolbar
  35Number
  36SimpleGraph
  37Paginator
  38HtmlToolbar
====
Include
+
Included Files

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

Time	Message
2022-01-21 07:22:39	Array ( [successful_login] => false 54.80.252.84 )
2022-01-21 07:22:39	Array ( [successful_login] => false 54.80.252.84 )

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 196 ms Total Queries: 219 queries

Query Explain:

vreb_rets

Total Time: 256 ms Total Queries: 77 queries

Query Explain:

Memory

Timers

Logs

logins

View Variables

Included Files

Include Paths

Included Files

Total Time: 196 ms
Total Queries: 219 queries

Total Time: 256 ms
Total Queries: 77 queries