0002: SHOW DATABASES LIKE 'ao-destinations'
0.0006s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0068s
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.001s
0005: SELECT DISTINCT count(DISTINCT "SlideImage_Live"."ID") AS "Count"
FROM "SlideImage_Live"
WHERE ("SlideImage_Live"."PageID" = ?)
0.0008s
0006: 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.0006s
0007: 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.001s
0008: 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
0009: 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.0007s
0010: 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.0007s
0011: 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.0003s
0012: 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.0003s
0013: 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.0005s
0014: 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.0002s
0015: 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.0002s
0016: 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.0007s
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.0002s
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.0003s
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.0002s
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.0003s
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.0002s
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.0003s
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.0002s
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.0003s
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.0002s
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.0003s
0027: 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
0028: 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.0004s
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.0004s
0030: 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.0009s
0031: 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
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"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
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"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
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.0004s
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.0004s
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.0004s
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.0004s
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.0004s
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.0004s
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.0004s
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.0003s
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.0003s
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.0003s
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"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0005s
0045: 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
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"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0005s
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.0004s
0048: 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.0007s
0049: SELECT DISTINCT count(DISTINCT "SlideImage_Live"."ID") AS "Count"
FROM "SlideImage_Live"
WHERE ("SlideImage_Live"."PageID" = ?)
0.0003s
0050: SELECT DISTINCT "GlobalSiteSetting"."ClassName", "GlobalSiteSetting"."LastEdited", "GlobalSiteSetting"."Created", "GlobalSiteSetting"."ReviewContent", "GlobalSiteSetting"."ID",
CASE WHEN "GlobalSiteSetting"."ClassName" IS NOT NULL THEN "GlobalSiteSetting"."ClassName"
ELSE 'Dynamic\\CoreTools\\Model\\GlobalSiteSetting' END AS "RecordClassName"
FROM "GlobalSiteSetting"
LIMIT 1
0.0004s
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlockPage_Live"."Animation", "BlockPage_Live"."Loop", "BlockPage_Live"."Animate", "BlockPage_Live"."ThumbnailNav", "BlockPage_Live"."SliderControlNav", "BlockPage_Live"."SliderDirectionNav", "BlockPage_Live"."CarouselControlNav", "BlockPage_Live"."CarouselDirectionNav", "BlockPage_Live"."CarouselThumbnailCt", "BlockPage_Live"."FlexSliderSpeed", "BlockPage_Live"."SearchContent", "BlockPage_Live"."ElementalAreaID", "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 "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0052: 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
0053: 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.0009s
0054: 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.0004s
0055: 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", "BlockPage_Live"."Animation", "BlockPage_Live"."Loop", "BlockPage_Live"."Animate", "BlockPage_Live"."ThumbnailNav", "BlockPage_Live"."SliderControlNav", "BlockPage_Live"."SliderDirectionNav", "BlockPage_Live"."CarouselControlNav", "BlockPage_Live"."CarouselDirectionNav", "BlockPage_Live"."CarouselThumbnailCt", "BlockPage_Live"."FlexSliderSpeed", "BlockPage_Live"."SearchContent", "BlockPage_Live"."ElementalAreaID", "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" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("BlockPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0056: 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.0004s
0057: 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.0003s
0058: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementRelatedDestinations_Live"."Content", "ElementRelatedDestinations_Live"."DestinationSource", "ElementRelatedDestinations_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 "ElementRelatedDestinations_Live" ON "ElementRelatedDestinations_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0059: 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.0003s
0060: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementFeatures_Live"."Content", "ElementFeatures_Live"."Alternate", "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 "ElementFeatures_Live" ON "ElementFeatures_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0061: 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.0003s
0062: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" LEFT JOIN "FeatureObject_Live" ON "FeatureObject_Live"."ID" = "BaseElementObject_Live"."ID"
WHERE ("FeatureObject_Live"."ElementFeaturesID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0009s
0063: 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.0003s
0064: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementAccordion_Live"."Content", "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 "ElementAccordion_Live" ON "ElementAccordion_Live"."ID" = "Element_Live"."ID"
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0065: SELECT DISTINCT count(DISTINCT "BaseElementObject_Live"."ID") AS "Count"
FROM "BaseElementObject_Live" LEFT JOIN "AccordionPanel_Live" ON "AccordionPanel_Live"."ID" = "BaseElementObject_Live"."ID"
WHERE ("AccordionPanel_Live"."AccordionID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
0.0007s
0066: SELECT DISTINCT "BaseElementObject_Live"."ClassName", "BaseElementObject_Live"."LastEdited", "BaseElementObject_Live"."Created", "BaseElementObject_Live"."Version", "BaseElementObject_Live"."Title", "BaseElementObject_Live"."ShowTitle", "BaseElementObject_Live"."Content", "BaseElementObject_Live"."ImageID", "BaseElementObject_Live"."ElementLinkID", "AccordionPanel_Live"."Sort", "AccordionPanel_Live"."AccordionID", "BaseElementObject_Live"."ID",
CASE WHEN "BaseElementObject_Live"."ClassName" IS NOT NULL THEN "BaseElementObject_Live"."ClassName"
ELSE 'Dynamic\\BaseObject\\Model\\BaseElementObject' END AS "RecordClassName"
FROM "BaseElementObject_Live" LEFT JOIN "AccordionPanel_Live" ON "AccordionPanel_Live"."ID" = "BaseElementObject_Live"."ID"
WHERE ("AccordionPanel_Live"."AccordionID" = ?)
AND ("BaseElementObject_Live"."ClassName" IN (?))
ORDER BY "AccordionPanel_Live"."Sort" ASC
0.0013s
0067: 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
0068: 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
0069: SELECT DISTINCT count(DISTINCT "SocialLink"."ID") AS "Count"
FROM "SocialLink"
WHERE ("SocialLink"."GlobalConfigID" = ?)
0.0005s
0070: 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.0002s
0071: 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.0003s
0072: 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.0002s
0073: 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.0003s
0074: 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.0002s
0075: SELECT DISTINCT count(DISTINCT "NavigationColumn"."ID") AS "Count"
FROM "NavigationColumn"
WHERE ("NavigationColumn"."GlobalConfigID" = ?)
0.0004s
0076: 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.0005s
0077: 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.0005s
0078: 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.0005s
0079: 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.0011s
0080: 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
0081: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0004s
0082: 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.0003s
0083: 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.0008s
0084: 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.0004s
0085: 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.0004s
About | American Orthodontics
AO Destinations is a collection of properties offered through this website exclusively for the use by American Orthodontics Customers and Employees. No other outside parties will be permitted to book the properties through AO Destinations.
For more information fill out a request form under the Contact Tab at the top of the page.
Submit a request on a property page by clicking on “Explore Availability” or fill out a request form under the Contact Tab at the top of the page. Our hospitality and property coordinator will reach out to complete your booking.
Our Sheboygan properties include your property stay, a tour of American Orthodontics and a local group activity. Choose one activity from golf, charter fishing or clay shooting. Activities are based upon availability and dependent upon weather.
AO Destination properties offer access to local concierge, swimming pools, fully equipped kitchens, ample space for entertaining and relaxation, close proximity to world class restaurants, skiing, spas and more, all within a gracious and elegant environment.