0002: SHOW DATABASES LIKE 'vivaexp\_silverstripe\_ss5'
0.0002s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0006s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0004s
0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0002s
0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0002s
0007: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."APIKey", "SiteConfig"."DisableSearchEngineVisibility", "SiteConfig"."TwitterUsername", "SiteConfig"."FacebookAdmin", "SiteConfig"."FacebookAppID", "SiteConfig"."HeadScripts", "SiteConfig"."BodyStartScripts", "SiteConfig"."BodyEndScripts", "SiteConfig"."RobotsTXT", "SiteConfig"."RobotsPublishedPagesOnly", "SiteConfig"."DefaultMetaTitle", "SiteConfig"."SupportedBrowser", "SiteConfig"."ContactEmail", "SiteConfig"."ContactPhone", "SiteConfig"."ContactAddress", "SiteConfig"."HeadTagCode", "SiteConfig"."OpenBodyTagCode", "SiteConfig"."CloseBodyTagCode", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."GlobalSocialSharingImageID", "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.0001s
0008: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlogPost_Live"."FeaturedToursLimit", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "BlogPost_Live"."AuthorImageID", "BlogPost_Live"."BannerImageID", "BlogPost_Live"."TourRegionID", "BlogPost_Live"."FeaturedImageID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2025-08-14 09:06:58')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0002s
0009: SELECT DISTINCT "SEO_variable"."ClassName", "SEO_variable"."LastEdited", "SEO_variable"."Created", "SEO_variable"."Name", "SEO_variable"."Value", "SEO_variable"."ID",
CASE WHEN "SEO_variable"."ClassName" IS NOT NULL THEN "SEO_variable"."ClassName"
ELSE 'SilverStripers\\SEO\\Model\\Variable' END AS "RecordClassName"
FROM "SEO_variable"
ORDER BY "SEO_variable"."Name" ASC
0.0001s
0010: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "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", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."PreviewImageID", "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" INNER JOIN "BlogPost_Live" ON "SiteTree_Live"."ID" = "BlogPost_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0012: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "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", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0013: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0014: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0015: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0016: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0002s
0017: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0018: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0019: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0020: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0021: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0005s
0022: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0023: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0024: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0025: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0026: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0027: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0028: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0029: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0030: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
ORDER BY "VivaTourCategoryObject_Live"."SortOrder" ASC
0.0004s
0031: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0032: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0033: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0003s
0034: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0004s
0035: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0036: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0037: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0005s
0038: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0039: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0040: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0041: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0042: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "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", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0043: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID",
CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName"
ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName"
FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID"
WHERE ("BlogPost_Categories"."BlogPostID" = ?)
LIMIT 1
0.0002s
0044: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "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"."StaffProfileID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0003s
0045: SELECT DISTINCT "StaffMember"."ClassName", "StaffMember"."LastEdited", "StaffMember"."Created", "StaffMember"."FirstName", "StaffMember"."Surname", "StaffMember"."Position", "StaffMember"."Email", "StaffMember"."Description", "StaffMember"."SortOrder", "StaffMember"."ProfileImageID", "StaffMember"."BannerImageID", "StaffMember"."ID",
CASE WHEN "StaffMember"."ClassName" IS NOT NULL THEN "StaffMember"."ClassName"
ELSE 'StaffMember' END AS "RecordClassName"
FROM "StaffMember"
WHERE ("StaffMember"."ID" = ?)
LIMIT 1
0.0001s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0047: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "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", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0048: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "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"."StaffProfileID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0003s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0002s
0050: SELECT CASE WHEN EXISTS(SELECT *
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "BlogPost_Images" ON "BlogPost_Images"."ImageID" = "File_Live"."ID"
WHERE ("BlogPost_Images"."BlogPostID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))) THEN 1 ELSE 0 END
0.0002s
0051: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0052: SELECT DISTINCT MAX("VivaStaticSpecial"."LastEdited")
FROM "VivaStaticSpecial"
0.0001s
0053: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count"
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0054: SELECT DISTINCT "StaffMember"."ClassName", "StaffMember"."LastEdited", "StaffMember"."Created", "StaffMember"."FirstName", "StaffMember"."Surname", "StaffMember"."Position", "StaffMember"."Email", "StaffMember"."Description", "StaffMember"."SortOrder", "StaffMember"."ProfileImageID", "StaffMember"."BannerImageID", "StaffMember"."ID",
CASE WHEN "StaffMember"."ClassName" IS NOT NULL THEN "StaffMember"."ClassName"
ELSE 'StaffMember' END AS "RecordClassName"
FROM "StaffMember"
WHERE ("StaffMember"."ID" = ?)
LIMIT 1
0.0001s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0056: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "ContactPage_Live"."MainContactEmail", "ContactPage_Live"."MainContactSkype", "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 "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ContactPage_Live" ON "ContactPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0057: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "OurStoryPage_Live"."Subtitle", "OurStoryPage_Live"."Tagline", "OurStoryPage_Live"."OperationsText", "OurStoryPage_Live"."PersonalisedItinerariesText", "OurStoryPage_Live"."LittleThingsTitle", "OurStoryPage_Live"."LittleThingsText", "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 "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "OurStoryPage_Live" ON "OurStoryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0058: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0001s
0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0002s
0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0001s
0061: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0001s
0062: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."FocusKeyword", "SiteTree"."MetaKeywords", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."FacebookTitle", "SiteTree"."FacebookDescription", "SiteTree"."TwitterTitle", "SiteTree"."TwitterDescription", "SiteTree"."MetaRobotsFollow", "SiteTree"."MetaRobotsIndex", "SiteTree"."CanonicalURL", "SiteTree"."TrackingCodes", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."FacebookImageID", "SiteTree"."TwitterImageID", "SiteTree"."MetaTitleTemplateID", "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.0002s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0002s
0064: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "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.0002s
Peru Trekking Guide by Viva Expeditions | Viva Expeditions
Discover breathtaking world of high peaks, mysterious ancient sites and unforgettable landscapes
Explore the high Andes on your own steam with our Peru Trekking Guide, and discover breathtaking world of high peaks, mysterious ancient sites and unforgettable landscapes.
A country renowned for being a trekker’s dream playground, Peruboasts one of the most scenic sections of the mighty Andes Mountains, with Machu Picchu – the famed Lost City of the Incas – acting as the ultimate enticement to giddy-on-up.
So don’t forget to pack the hiking boots and an extra sweater when you visit Peru (the breathtaking views are well worth the chilly temps) and come discover all the amazing trekking options this small but unrivalled South American country has to offer. Due to the high-altitude nature of all the hikes, you’ll need to leave all preconceived notions – in regards to how much you can walk – at home. These are the high Andes, where even a mere kilometre can seem to last forever.
And with views like these…who on earth would mind?
Peru Trekking Tour
Classic Inca Trail to Machu Picchu – 4 days, 43km
The most famous trek in the country is the Classic Inca Trail that retraces the steps of the ancient Incas. History and culture aside, this is a truly sensational hike, one that will see you traverse an eclectic mix of high-altitude passes, verdant valleys and even a section of rainforest, before culminating at sunrise, on the 4th day, at the revered Sun Gate ofMachu Picchu. This trek is both difficult and unmissable (don’t let names like Dead Woman’s Pass throw you off the scent!) and is so popular that trail passes are sold out months in advance. The Andean scenery on this multi-day hike is magnificent to say the least and the way it is organized with local porters (who carry camping gear and prepare sumptuous meals in the most unimaginable places) it makes this a once-in-a-lifetime bucket-list worthy trek indeed.
Check out our Inca Trail Trek to Machu Picchu tour to get an idea of how best to plan this hike around a stay in Cusco, in order to take in the sites and allow for acclimatization at these high altitudes.
Classic Inca Trail to Machu Picchu
Short Inca Trail to Machu Picchu– 2 days, 16km
This softer version of the Inca Trail to Machu Picchu is by no means any less spectacular, but it is a lot easier, for obvious reasons. Tackled across two days (one overnight stay) and starting with an early morning train-ride from Ollantaytambo to km104 of the Inca Trail, the Short Inca Trail is ideal for trekkers who still want to reach Sun Gate under their own steam, or simply don’t have the desire nor time to prepare and tackle the longer route. In many ways, this synthesized version is a more intense experience, as you still visit what is often considered the most sensational site of the Inca Trail (the stunning ruins of Wiñay Wayna) and will have a lot more energy for exploring Machu Picchu, which you’ll reach on Day 2. Include a hike up Huayna Picchu for an even more comprehensive experience.
Short Inca Trail to Machu Picchu
Salkantay Trek to Machu Picchu– 4 days, 42km
A stellar alternative to the Inca Trail, the Salkantay Trek is – along with the Classic Inca Trail – named by National Geographic as one of the world’s 25 best treks. Once here, you’ll have no problems understanding the accolades. Some of this trek affords the most spectacular mountains scenery of all the treks and we’d find it hard to disagree. Serene, splendidly beautiful and gloriously scenic, the Salkantay is favoured by return visitors to Peru who love the region around the Inca Trail – and still want to visit Machu Picchu – but wish to hike with fewer fellow tourists in tow. The most sensational aspect of this trek is that it starts among glaciers and, after a series of awe-inspiring ascents and descents, ends in the heart of a jungle. The Salkantay Trek will see you reach Aguas Caliente, the base town of Machu Picchu, from where you can either hike up to Machu Picchu (1.5hrs) or take the bus instead. Throughout this trek, you’ll hike past lesser-visited but equally striking Inca ruins and will traverse a kaleidoscope of landscapes, including the Salkantay Pass at 4600masl, cloud forests, valleys covered with wildflowers as well as waterfalls and glacial lakes.
Salkantay Trek to Machu Picchu
Lodge-to-lodge to Machu Picchu Trek
The Mountain Lodges of Peru is one of the most popular options for discerning trekkers who wish to be active whilst visiting Peru but still don’t want to compromise on comfort and luxury. Because, let’s be honest, ending a full day of high-altitude trekking sipping a Pisco sour whilst soaking in a steaming Jacuzzi wouldn’t be a travesty now, would it? Consider this the softer version of the Salkantay Trek, where you trek during the day (sometimes, you’ll also have the option to take road transport or horseback ride), ending every day in one of the glorious mountain lodges scattered along the route. Our Luxury Trekking to Machu Picchu tour offers you the best of the Vilcabamba Cordillera and the Salkantay mountains. But be under no illusion: the trekking is still breathtakingly intense. At least you’ll have your happy place with a Pisco sour and Jacuzzi to retreat to, at least mentally, during the hardest slog.
Lares Trek to Machu Picchu – 3 days, 33km
The most remote trek to Machu Picchu and the one that presents more logistical challenges, the Lares is swiftly gaining recognition among avoid hikers due to its uniqueness. Shorter in distance but higher in altitude, the Lares Trek is a wonderful ‘cultural’ experience as well as nature-filled one and takes you way off the well-trodden path of the Sacred Valley and onto the Lares Valley instead. With an initial breathtaking ascent of 1300m, the Lares Trek requires optimal acclimatisation and is the only one that sees hikers pass local towns brimming with curious locals. This gifts a wonderful insight into the authentic Andean lifestyle of some of the most remote inhabitants in the country. Moreover, the Lares offers more options in terms of side-excursions so caters to avid and casual trekkers alike. With this option, Machu Picchu is reached on Day 3. Do note that a Lodge-to-lodge Lares Trek option is also available for those who wish to tackle the Lares Trek.
Choquequirao Trek to Machu Picchu – 5 days, 64km
The BIG mama of the lot, the Choquequirao Trek is not for the faint of heart and can easily be described as the most adventurous trek on this list. Combining several sweat-inducing high-altitude switchbacks and steep ascents that take you past the superlative ruins of Choquequirao. An Inca stronghold that is bigger and in many ways even more sensational than Machu Picchu, Choquequirao is a visual feast of untold proportion. Partly reclaimed by jungle and as remote as it can possibly be, this site is a salivating enticement for anyone who wants to feel like an old-world explorer. It’s difficult to even imagine a site, and a trek, that can seriously take the WOW shine off Machu Picchu. But this one is it. Two of Peru’s most remarkable ancient sites in one totally heart-stopping adventure. This 5-day trek ends in Ollantaytambo, where you can stay overnight, visiting Machu Picchu on Day 6.
Choquequirao Trek to Machu Picchu
Rainbow Mountain Trek – 1 day, 10km
The Vinicunca hike, otherwise known as the Rainbow Mountain Trek, is surprisingly challenging, despite it advertised as a ‘1-day trip’ from Cusco. The only attraction that could ever divert your attention from Machu Picchu in this region, the by-now world- famous Rainbow Mountain is one of the most recognizable highlights of the country. With variable weather and lack of major infrastructure, the Rainbow Mountain Trek makes for a very long day, starting with departure from Cusco in the very early hours of the morning. Rainbow Mountain is about a 3-hour drive from Cusco and the start of the trek, at the base of the peak, is best reached at first light. From beginning to end, this trek can take up to 12 hours, although many hikers manage just 8 or so. A fabulous horse-taxi option is also on offer, for those who find the altitude a little too arduous. The day-long trek may be challenging – you will reach 4450masl – but the vistas throughout the day are out of this world. You’ll come across endemic wildlife and, hopefully, will have startling weather when you reach the peak so you can capture the splendour of this multihued mountain. The all-encompassing view atop Rainbow Mountain is one of the most spectacular you’ll ever experience.
Rainbow Mountain Trek
All the treks are designed to satisfy the needs and desires of most visitors. However, changes can be made for visitors on tailor-made tours who wish to hike with their own group alone. Treks can be lengthened and combined, accommodation options changed and comfort levels increased. Given enough time to arrange, there really isn’t much that can’t be organised in this magnificent trekking paradise. So if you know of an option that isn’t listed here or envisage a hybrid trek that combines some parts of some hikes…contact us. Let us know. We’ll endeavour to plan a bespoke walking tour that will meet and exceed your expectations.
Laura Pattara writes for Viva Expeditions with a special love for all things Latin America. She had guided overland tours across the continent, reached Machu Picchu five times on foot, and even dressed up as a giant toucan for Carnaval. With a degree in languages and two decades of global travel experience behind her, Laura has a long-standing love for the Andes, soaring condors, and a truly delicious empanada.