0002: SHOW DATABASES LIKE 'ao-destinations'
0.001s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0107s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0044s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0007: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."GoogleAnalytics", "SiteConfig"."FacebookPixel", "SiteConfig"."TwitterPixel", "SiteConfig"."SnapPixel", "SiteConfig"."TwitterAccountName", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."CMSLogoID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0016s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."FacebookPageType", "Page_Live"."FacebookPageTitle", "Page_Live"."FacebookPageDescription", "Page_Live"."TwitterPageTitle", "Page_Live"."TwitterPageDescription", "Page_Live"."FocusKeyword", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0032s
0009: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."TwitterAccountName", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member"
WHERE ("Member"."ID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0045s
0010: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0008s
0011: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0022s
0012: SELECT DISTINCT "IntegrationConfigSetting"."ClassName", "IntegrationConfigSetting"."LastEdited", "IntegrationConfigSetting"."Created", "IntegrationConfigSetting"."UseGTM", "IntegrationConfigSetting"."GTMHeadCode", "IntegrationConfigSetting"."GTMBodyCode", "IntegrationConfigSetting"."UseGA", "IntegrationConfigSetting"."GACode", "IntegrationConfigSetting"."UseHubSpot", "IntegrationConfigSetting"."HubSpotAccountID", "IntegrationConfigSetting"."ID",
CASE WHEN "IntegrationConfigSetting"."ClassName" IS NOT NULL THEN "IntegrationConfigSetting"."ClassName"
ELSE 'Dynamic\\IntegrationConfig\\Model\\IntegrationConfigSetting' END AS "RecordClassName"
FROM "IntegrationConfigSetting"
LIMIT 1
0.0008s
0013: SELECT DISTINCT "IntegrationConfigSetting"."ClassName", "IntegrationConfigSetting"."LastEdited", "IntegrationConfigSetting"."Created", "IntegrationConfigSetting"."UseGTM", "IntegrationConfigSetting"."GTMHeadCode", "IntegrationConfigSetting"."GTMBodyCode", "IntegrationConfigSetting"."UseGA", "IntegrationConfigSetting"."GACode", "IntegrationConfigSetting"."UseHubSpot", "IntegrationConfigSetting"."HubSpotAccountID", "IntegrationConfigSetting"."ID",
CASE WHEN "IntegrationConfigSetting"."ClassName" IS NOT NULL THEN "IntegrationConfigSetting"."ClassName"
ELSE 'Dynamic\\IntegrationConfig\\Model\\IntegrationConfigSetting' END AS "RecordClassName"
FROM "IntegrationConfigSetting"
LIMIT 1
0.0025s
0014: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0023s
0015: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" INNER JOIN "TemplateConfigSetting_UtilityLinks" ON "TemplateConfigSetting_UtilityLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("TemplateConfigSetting_UtilityLinks"."TemplateConfigSettingID" = ?)
0.0011s
0016: SELECT DISTINCT "IntegrationConfigSetting"."ClassName", "IntegrationConfigSetting"."LastEdited", "IntegrationConfigSetting"."Created", "IntegrationConfigSetting"."UseGTM", "IntegrationConfigSetting"."GTMHeadCode", "IntegrationConfigSetting"."GTMBodyCode", "IntegrationConfigSetting"."UseGA", "IntegrationConfigSetting"."GACode", "IntegrationConfigSetting"."UseHubSpot", "IntegrationConfigSetting"."HubSpotAccountID", "IntegrationConfigSetting"."ID",
CASE WHEN "IntegrationConfigSetting"."ClassName" IS NOT NULL THEN "IntegrationConfigSetting"."ClassName"
ELSE 'Dynamic\\IntegrationConfig\\Model\\IntegrationConfigSetting' END AS "RecordClassName"
FROM "IntegrationConfigSetting"
LIMIT 1
0.0017s
0017: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0026s
0018: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.0028s
0019: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0027s
0020: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.0006s
0021: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0003s
0022: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.0024s
0023: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0003s
0024: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.0031s
0025: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0005s
0026: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.0005s
0027: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0018s
0028: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.0005s
0029: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0006s
0030: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" INNER JOIN "TemplateConfigSetting_UtilityLinks" ON "TemplateConfigSetting_UtilityLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("TemplateConfigSetting_UtilityLinks"."TemplateConfigSettingID" = ?)
0.0031s
0031: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0037s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0021s
0035: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0035s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0024s
0038: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0031s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0031s
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0029s
0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0032s
0048: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0004s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0032s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0015s
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0048s
0052: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" INNER JOIN "Destination_Images" ON "Destination_Images"."ImageID" = "File_Live"."ID"
WHERE ("Destination_Images"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0027s
0053: SELECT DISTINCT "Destination_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" INNER JOIN "Destination_Images" ON "Destination_Images"."ImageID" = "File_Live"."ID"
WHERE ("Destination_Images"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
0.0015s
0054: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" INNER JOIN "Destination_Images" ON "Destination_Images"."ImageID" = "File_Live"."ID"
WHERE ("Destination_Images"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0028s
0055: SELECT DISTINCT "Destination_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" INNER JOIN "Destination_Images" ON "Destination_Images"."ImageID" = "File_Live"."ID"
WHERE ("Destination_Images"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
0.0047s
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Destination_Live"."PreviewTitle", "Destination_Live"."Abstract", "Destination_Live"."Address", "Destination_Live"."Address2", "Destination_Live"."City", "Destination_Live"."State", "Destination_Live"."PostalCode", "Destination_Live"."Country", "Destination_Live"."Lat", "Destination_Live"."Lng", "Destination_Live"."Description", "Destination_Live"."Guests", "Destination_Live"."Bedrooms", "Destination_Live"."Bathrooms", "Destination_Live"."SquareFeet", "Destination_Live"."AdditionalFeatures", "Destination_Live"."IndoorFeatures", "Destination_Live"."OutdoorFeatures", "Destination_Live"."SharedFeatures", "Destination_Live"."Price", "Destination_Live"."PreviewImageID", "Destination_Live"."ElementalAreaID", "Destination_Live"."FloorPlanID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", -1 AS Distance, "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Destination_Live" ON "Destination_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0057: SELECT DISTINCT count(DISTINCT "PropertyFeature"."ID") AS "Count"
FROM "PropertyFeature" INNER JOIN "Destination_Features" ON "Destination_Features"."PropertyFeatureID" = "PropertyFeature"."ID"
WHERE ("Destination_Features"."DestinationID" = ?)
0.0249s
0058: SELECT DISTINCT count(DISTINCT "PropertyFeature"."ID") AS "Count"
FROM "PropertyFeature" INNER JOIN "Destination_Features" ON "Destination_Features"."PropertyFeatureID" = "PropertyFeature"."ID"
WHERE ("Destination_Features"."DestinationID" = ?)
0.0022s
0059: SELECT DISTINCT "Destination_Features"."SortOrder", "PropertyFeature"."ClassName", "PropertyFeature"."LastEdited", "PropertyFeature"."Created", "PropertyFeature"."Title", "PropertyFeature"."Icon", "PropertyFeature"."ID",
CASE WHEN "PropertyFeature"."ClassName" IS NOT NULL THEN "PropertyFeature"."ClassName"
ELSE 'Dynamic\\AODestinations\\Model\\PropertyFeature' END AS "RecordClassName"
FROM "PropertyFeature" INNER JOIN "Destination_Features" ON "Destination_Features"."PropertyFeatureID" = "PropertyFeature"."ID"
WHERE ("Destination_Features"."DestinationID" = ?)
0.0012s
0060: SELECT DISTINCT count(DISTINCT "SleepingArrangement"."ID") AS "Count"
FROM "SleepingArrangement"
WHERE ("SleepingArrangement"."DestinationID" = ?)
0.0118s
0061: SELECT DISTINCT count(DISTINCT "SleepingArrangement"."ID") AS "Count"
FROM "SleepingArrangement"
WHERE ("SleepingArrangement"."DestinationID" = ?)
0.0084s
0062: SELECT DISTINCT "SleepingArrangement"."ClassName", "SleepingArrangement"."LastEdited", "SleepingArrangement"."Created", "SleepingArrangement"."Title", "SleepingArrangement"."Description", "SleepingArrangement"."SortOrder", "SleepingArrangement"."DestinationID", "SleepingArrangement"."ID",
CASE WHEN "SleepingArrangement"."ClassName" IS NOT NULL THEN "SleepingArrangement"."ClassName"
ELSE 'Dynamic\\AODestinations\\Model\\SleepingArrangement' END AS "RecordClassName"
FROM "SleepingArrangement"
WHERE ("SleepingArrangement"."DestinationID" = ?)
0.0007s
0063: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" INNER JOIN "Destination_FloorPlans" ON "Destination_FloorPlans"."ImageID" = "File_Live"."ID"
WHERE ("Destination_FloorPlans"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0023s
0064: SELECT DISTINCT count(DISTINCT "File_Live"."ID") AS "Count"
FROM "File_Live" INNER JOIN "Destination_FloorPlans" ON "Destination_FloorPlans"."ImageID" = "File_Live"."ID"
WHERE ("Destination_FloorPlans"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
0.0033s
0065: SELECT DISTINCT "Destination_FloorPlans"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" INNER JOIN "Destination_FloorPlans" ON "Destination_FloorPlans"."ImageID" = "File_Live"."ID"
WHERE ("Destination_FloorPlans"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
0.0016s
0066: SELECT DISTINCT "Destination_FloorPlans"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" INNER JOIN "Destination_FloorPlans" ON "Destination_FloorPlans"."ImageID" = "File_Live"."ID"
WHERE ("Destination_FloorPlans"."DestinationID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "SortOrder" ASC
0.0011s
0067: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0141s
0068: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."AvailableGlobally", "Element_Live"."TitleLineColor", "Element_Live"."AOS", "Element_Live"."Disable", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName"
FROM "Element_Live"
WHERE ("Element_Live"."ParentID" = ?)
ORDER BY "Element_Live"."Sort" ASC
0.0082s
0069: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0006s
0070: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."FacebookPageType", "Page_Live"."FacebookPageTitle", "Page_Live"."FacebookPageDescription", "Page_Live"."TwitterPageTitle", "Page_Live"."TwitterPageDescription", "Page_Live"."FocusKeyword", "Page_Live"."FacebookPageImageID", "Page_Live"."TwitterPageImageID", "Page_Live"."CreatorID", "Destination_Live"."PreviewTitle", "Destination_Live"."Abstract", "Destination_Live"."Address", "Destination_Live"."Address2", "Destination_Live"."City", "Destination_Live"."State", "Destination_Live"."PostalCode", "Destination_Live"."Country", "Destination_Live"."Lat", "Destination_Live"."Lng", "Destination_Live"."Description", "Destination_Live"."Guests", "Destination_Live"."Bedrooms", "Destination_Live"."Bathrooms", "Destination_Live"."SquareFeet", "Destination_Live"."AdditionalFeatures", "Destination_Live"."IndoorFeatures", "Destination_Live"."OutdoorFeatures", "Destination_Live"."SharedFeatures", "Destination_Live"."Price", "Destination_Live"."PreviewImageID", "Destination_Live"."ElementalAreaID", "Destination_Live"."FloorPlanID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", -1 AS Distance
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Destination_Live" ON "Destination_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("Destination_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0032s
0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0072: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0108s
0073: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID",
CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName"
FROM "ElementalArea_Live"
WHERE ("ElementalArea_Live"."ID" = ?)
LIMIT 1
0.0009s
0074: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementRelatedAttractions_Live"."Content", "ElementRelatedAttractions_Live"."DestinationSource", "ElementRelatedAttractions_Live"."DestinationID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementRelatedAttractions_Live" ON "ElementRelatedAttractions_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0029s
0075: SELECT DISTINCT count(DISTINCT "Activity"."ID") AS "Count"
FROM "Activity" INNER JOIN "Destination_Attractions" ON "Destination_Attractions"."ActivityID" = "Activity"."ID"
WHERE ("Destination_Attractions"."DestinationID" = ?)
0.0087s
0076: SELECT DISTINCT "Destination_Attractions"."SortOrder", "Activity"."ClassName", "Activity"."LastEdited", "Activity"."Created", "Activity"."Address", "Activity"."Address2", "Activity"."City", "Activity"."State", "Activity"."PostalCode", "Activity"."Country", "Activity"."Lat", "Activity"."Lng", "Activity"."Title", "Activity"."Content", "Activity"."Phone", "Activity"."ImageID", "Activity"."AttractionLinkID", "Activity"."ID",
CASE WHEN "Activity"."ClassName" IS NOT NULL THEN "Activity"."ClassName"
ELSE 'Dynamic\\AODestinations\\Model\\Attraction' END AS "RecordClassName", -1 AS Distance
FROM "Activity" INNER JOIN "Destination_Attractions" ON "Destination_Attractions"."ActivityID" = "Activity"."ID"
WHERE ("Destination_Attractions"."DestinationID" = ?)
ORDER BY "SortOrder" ASC
0.0106s
0077: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0053s
0078: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.0249s
0079: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0142s
0080: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.0037s
0081: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0119s
0082: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.02s
0083: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0078s
0084: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.0018s
0085: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0006s
0086: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.026s
0087: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0058s
0088: SELECT DISTINCT "LinkableLink"."ClassName", "LinkableLink"."LastEdited", "LinkableLink"."Created", "LinkableLink"."Anchor", "LinkableLink"."Title", "LinkableLink"."Type", "LinkableLink"."URL", "LinkableLink"."Email", "LinkableLink"."Phone", "LinkableLink"."OpenInNewWindow", "LinkableLink"."Template", "LinkableLink"."SiteTreeID", "LinkableLink"."FileID", "LinkableLink"."ID",
CASE WHEN "LinkableLink"."ClassName" IS NOT NULL THEN "LinkableLink"."ClassName"
ELSE 'Sheadawson\\Linkable\\Models\\Link' END AS "RecordClassName"
FROM "LinkableLink"
WHERE ("LinkableLink"."ID" = ?)
LIMIT 1
0.0168s
0089: SELECT DISTINCT "Reservation"."ClassName", "Reservation"."LastEdited", "Reservation"."Created", "Reservation"."Arrival", "Reservation"."Departure", "Reservation"."Status", "Reservation"."Name", "Reservation"."Company", "Reservation"."AOID", "Reservation"."Email", "Reservation"."Phone", "Reservation"."PropertyID", "Reservation"."ID",
CASE WHEN "Reservation"."ClassName" IS NOT NULL THEN "Reservation"."ClassName"
ELSE 'Dynamic\\AODestinations\\Model\\Reservation' END AS "RecordClassName"
FROM "Reservation"
WHERE ("Reservation"."PropertyID" = ?)
AND ("Reservation"."Status" = ?)
0.0013s
0090: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0113s
0091: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0004s
0092: SELECT DISTINCT count(DISTINCT "SocialLink"."ID") AS "Count"
FROM "SocialLink"
WHERE ("SocialLink"."GlobalConfigID" = ?)
0.0108s
0093: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0075s
0094: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.002s
0095: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0193s
0096: SELECT DISTINCT "Location_Live"."ClassName", "Location_Live"."LastEdited", "Location_Live"."Created", "Location_Live"."Version", "Location_Live"."Address", "Location_Live"."Address2", "Location_Live"."City", "Location_Live"."State", "Location_Live"."PostalCode", "Location_Live"."Country", "Location_Live"."Lat", "Location_Live"."Lng", "Location_Live"."IsPrimary", "Location_Live"."Title", "Location_Live"."Featured", "Location_Live"."Website", "Location_Live"."Phone", "Location_Live"."Email", "Location_Live"."Fax", "Location_Live"."Import_ID", "Location_Live"."ID",
CASE WHEN "Location_Live"."ClassName" IS NOT NULL THEN "Location_Live"."ClassName"
ELSE 'Dynamic\\Locator\\Location' END AS "RecordClassName", -1 AS Distance
FROM "Location_Live"
ORDER BY "Location_Live"."IsPrimary" DESC
LIMIT 1
0.015s
0097: SELECT DISTINCT "TemplateConfigSetting"."ClassName", "TemplateConfigSetting"."LastEdited", "TemplateConfigSetting"."Created", "TemplateConfigSetting"."TitleLogo", "TemplateConfigSetting"."Title", "TemplateConfigSetting"."Tagline", "TemplateConfigSetting"."LogoID", "TemplateConfigSetting"."LogoRetinaID", "TemplateConfigSetting"."FooterLogoID", "TemplateConfigSetting"."FooterLogoRetinaID", "TemplateConfigSetting"."FavIconID", "TemplateConfigSetting"."AppleTouchIcon180ID", "TemplateConfigSetting"."AppleTouchIcon152ID", "TemplateConfigSetting"."AppleTouchIcon114ID", "TemplateConfigSetting"."AppleTouchIcon72ID", "TemplateConfigSetting"."AppleTouchIcon57ID", "TemplateConfigSetting"."ID",
CASE WHEN "TemplateConfigSetting"."ClassName" IS NOT NULL THEN "TemplateConfigSetting"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\TemplateConfigSetting' END AS "RecordClassName"
FROM "TemplateConfigSetting"
LIMIT 1
0.0074s
0098: SELECT DISTINCT count(DISTINCT "NavigationColumn"."ID") AS "Count"
FROM "NavigationColumn"
WHERE ("NavigationColumn"."GlobalConfigID" = ?)
0.015s
0099: SELECT DISTINCT "NavigationColumn"."ClassName", "NavigationColumn"."LastEdited", "NavigationColumn"."Created", "NavigationColumn"."Title", "NavigationColumn"."SortOrder", "NavigationColumn"."GlobalConfigID", "NavigationColumn"."ID",
CASE WHEN "NavigationColumn"."ClassName" IS NOT NULL THEN "NavigationColumn"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\NavigationColumn' END AS "RecordClassName"
FROM "NavigationColumn"
WHERE ("NavigationColumn"."GlobalConfigID" = ?)
ORDER BY "NavigationColumn"."SortOrder" ASC
LIMIT 1
0.0077s
0100: SELECT DISTINCT "NavigationGroup"."ClassName", "NavigationGroup"."LastEdited", "NavigationGroup"."Created", "NavigationGroup"."Title", "NavigationGroup"."SortOrder", "NavigationGroup"."NavigationColumnID", "NavigationGroup"."ID",
CASE WHEN "NavigationGroup"."ClassName" IS NOT NULL THEN "NavigationGroup"."ClassName"
ELSE 'Dynamic\\TemplateConfig\\Model\\NavigationGroup' END AS "RecordClassName"
FROM "NavigationGroup"
WHERE ("NavigationGroup"."NavigationColumnID" = ?)
0.0032s
0101: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" INNER JOIN "NavigationGroup_NavigationLinks" ON "NavigationGroup_NavigationLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("NavigationGroup_NavigationLinks"."NavigationGroupID" = ?)
0.0024s
0102: SELECT DISTINCT "NavigationGroup_NavigationLinks"."SortOrder", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" INNER JOIN "NavigationGroup_NavigationLinks" ON "NavigationGroup_NavigationLinks"."SiteTreeID" = "SiteTree_Live"."ID"
WHERE ("NavigationGroup_NavigationLinks"."NavigationGroupID" = ?)
ORDER BY "SortOrder" ASC
0.0146s
0103: SELECT DISTINCT "CompanyConfigSetting"."ClassName", "CompanyConfigSetting"."LastEdited", "CompanyConfigSetting"."Created", "CompanyConfigSetting"."CompanyName", "CompanyConfigSetting"."ID",
CASE WHEN "CompanyConfigSetting"."ClassName" IS NOT NULL THEN "CompanyConfigSetting"."ClassName"
ELSE 'Dynamic\\CompanyConfig\\Model\\CompanyConfigSetting' END AS "RecordClassName"
FROM "CompanyConfigSetting"
LIMIT 1
0.0006s
0104: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0158s
0105: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0054s
0106: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."HideOnSitemap", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree"
WHERE ("SiteTree"."ID" = ?)
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0109s
0107: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0075s
0108: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."HideOnSitemap", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0088s
0109: SELECT DISTINCT "IntegrationConfigSetting"."ClassName", "IntegrationConfigSetting"."LastEdited", "IntegrationConfigSetting"."Created", "IntegrationConfigSetting"."UseGTM", "IntegrationConfigSetting"."GTMHeadCode", "IntegrationConfigSetting"."GTMBodyCode", "IntegrationConfigSetting"."UseGA", "IntegrationConfigSetting"."GACode", "IntegrationConfigSetting"."UseHubSpot", "IntegrationConfigSetting"."HubSpotAccountID", "IntegrationConfigSetting"."ID",
CASE WHEN "IntegrationConfigSetting"."ClassName" IS NOT NULL THEN "IntegrationConfigSetting"."ClassName"
ELSE 'Dynamic\\IntegrationConfig\\Model\\IntegrationConfigSetting' END AS "RecordClassName"
FROM "IntegrationConfigSetting"
LIMIT 1
0.0017s
ZMO Condo | American Orthodontics
ZMO Condo
Sheboygan, Wisconsin
5 Guests
5 Bedrooms
3 Bathrooms
2019 sq ft
Experience the charms of modern design on the newly renovated 3rd floor of one of Sheboygan’s historic downtown buildings. Enjoy private elevator access to the 3rd floor for luxurious accommodations with views of downtown Sheboygan and Lake Michigan. The ZMO condo pays homage to Zaegel’s Magic Oil, or ZMO, a salve containing great healing qualities created by pharmacist Max Zaegel in 1903.
Conveniently located, the spacious ZMO Condo graciously accommodates 5-10 guests with 5 Queen bedded rooms and 3 bathrooms. Offering a full kitchen, gathering space, dining area, and fireplace, ZMO is a wonderful location for entertainment and exploration. Within walking distance of dozens of restaurants, shops, and the beautiful Sheboygan Riverfront, guests can easily discover Sheboygan County.
Check Availability
AvailableUnavailable
Property Features
Downtown Location
Heat and A/C
Non-Smoking and No Pets
WiFi & Cable Available
No Daily Housekeeping
Additional Features
Elevator Access
Modest Kitchen
Stainless Steel Refrigerator/Freezer
Granite Countertops
Gas Stove
Microwave
Gourment Cookware
Coffee Maker
Gathering Space with Fireplace
Clean Linens and Towels Provided
Amenities
Indoor Features
Contemporary Appointments
Fireplace
WiFi
Individual Wardrobes
Outdoor Features
2 Reserved Parking Spaces
Central Downtown Location
Within walking distance of local dining and entertainment
