0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0066s
0004: SHOW FULL FIELDS IN "Fluent_Domain"
0.0015s
0005: SHOW COLLATION LIKE 'utf8mb4_unicode_ci'
0.0009s
0006: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0004s
0007: SHOW FULL FIELDS IN "Fluent_Locale"
0.0014s
0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0005s
0009: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0016s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Fallback"
ELSE "SiteTree_Live"."Fallback" END
AS "Fallback", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."FallbackLink"
ELSE "SiteTree_Live"."FallbackLink" END
AS "FallbackLink", "SiteTree_Live"."FallbackResponseCode", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterSite"
ELSE "SiteTree_Live"."TwitterSite" END
AS "TwitterSite", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCreator"
ELSE "SiteTree_Live"."TwitterCreator" END
AS "TwitterCreator", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterTitle"
ELSE "SiteTree_Live"."TwitterTitle" END
AS "TwitterTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterCardType"
ELSE "SiteTree_Live"."TwitterCardType" END
AS "TwitterCardType", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."TwitterDescription"
ELSE "SiteTree_Live"."TwitterDescription" END
AS "TwitterDescription", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."VanityMappingID", "SiteTree_Live"."TwitterImageID", "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", 'en_US' AS "Locale", CASE WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE (COALESCE("SiteTree_Localised_en_US"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0018s
0011: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."CanonicalDomain", "SiteConfig"."Fallback", "SiteConfig"."FallbackLink", "SiteConfig"."FallbackResponseCode", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerTitle"
ELSE "SiteConfig"."BlogBannerTitle" END
AS "BlogBannerTitle", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerCheckbox1"
ELSE "SiteConfig"."BlogBannerCheckbox1" END
AS "BlogBannerCheckbox1", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerCheckbox2"
ELSE "SiteConfig"."BlogBannerCheckbox2" END
AS "BlogBannerCheckbox2", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerCheckbox3"
ELSE "SiteConfig"."BlogBannerCheckbox3" END
AS "BlogBannerCheckbox3", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerOrangeNumber"
ELSE "SiteConfig"."BlogBannerOrangeNumber" END
AS "BlogBannerOrangeNumber", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerTextNextToNumber"
ELSE "SiteConfig"."BlogBannerTextNextToNumber" END
AS "BlogBannerTextNextToNumber", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerButtonText"
ELSE "SiteConfig"."BlogBannerButtonText" END
AS "BlogBannerButtonText", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."BlogBannerURL"
ELSE "SiteConfig"."BlogBannerURL" END
AS "BlogBannerURL", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TwitterURL"
ELSE "SiteConfig"."TwitterURL" END
AS "TwitterURL", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FacebookURL"
ELSE "SiteConfig"."FacebookURL" END
AS "FacebookURL", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."YoutubeURL"
ELSE "SiteConfig"."YoutubeURL" END
AS "YoutubeURL", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."LinkedInURL"
ELSE "SiteConfig"."LinkedInURL" END
AS "LinkedInURL", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."GooglePlayURL"
ELSE "SiteConfig"."GooglePlayURL" END
AS "GooglePlayURL", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."CrossLinkCarouselTitle"
ELSE "SiteConfig"."CrossLinkCarouselTitle" END
AS "CrossLinkCarouselTitle", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."CrossLinkCarouselText"
ELSE "SiteConfig"."CrossLinkCarouselText" END
AS "CrossLinkCarouselText", "SiteConfig"."SiteSchemaExtra", CASE
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterCopyright"
ELSE "SiteConfig"."FooterCopyright" END
AS "FooterCopyright", "SiteConfig"."DefaultTwitterHandle", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."BlogBannerImageID", "SiteConfig"."TopLogoID", "SiteConfig"."DefaultTwitterImageID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'en_US' AS "Locale", CASE WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_US" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_US"."RecordID" AND "SiteConfig_Localised_en_US"."Locale" = ?
LIMIT 1
0.0018s
0012: 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"
WHERE ("BlogCategory"."BlogID" = ?)
AND ("BlogCategory"."URLSegment" = ?)
LIMIT 1
0.001s
GET /blog/category/route-planning?flush=all&showqueries=1&start=249905260
0013: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID",
CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName"
ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName"
FROM "LinkMapping"
WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com'))
AND ("LinkMapping"."LinkType" = ?)
ORDER BY "LinkMapping"."ID" DESC
0.001s
0014: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID",
CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName"
ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName"
FROM "LinkMapping"
WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com'))
AND ((LinkType = 'Simple') AND (((IncludesHostname = 0) AND ((MappedLink = 'blog/category/route-planning') OR (MappedLink LIKE 'blog/category/route-planning?%'))) OR ((IncludesHostname = 1) AND ((MappedLink = 'www.track-pod.com/blog/category/route-planning') OR (MappedLink LIKE 'www.track-pod.com/blog/category/route-planning?%')))))
ORDER BY "LinkMapping"."ID" DESC
0.0007s
0015: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID",
CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName"
ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName"
FROM "LinkMapping"
WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com'))
AND ("LinkMapping"."LinkType" = ?)
ORDER BY "LinkMapping"."ID" DESC
0.0009s
0016: SELECT DISTINCT "LinkMapping"."ClassName", "LinkMapping"."LastEdited", "LinkMapping"."Created", "LinkMapping"."LinkType", "LinkMapping"."MappedLink", "LinkMapping"."IncludesHostname", "LinkMapping"."Priority", "LinkMapping"."RedirectType", "LinkMapping"."RedirectLink", "LinkMapping"."RedirectPageID", "LinkMapping"."ResponseCode", "LinkMapping"."HostnameRestriction", "LinkMapping"."ID",
CASE WHEN "LinkMapping"."ClassName" IS NOT NULL THEN "LinkMapping"."ClassName"
ELSE 'nglasl\\misdirection\\LinkMapping' END AS "RecordClassName"
FROM "LinkMapping"
WHERE ((HostnameRestriction IS NULL) OR (HostnameRestriction = 'www.track-pod.com'))
AND ((LinkType = 'Simple') AND (((IncludesHostname = 0) AND ((MappedLink = 'blog/category/route-planning') OR (MappedLink LIKE 'blog/category/route-planning?%'))) OR ((IncludesHostname = 1) AND ((MappedLink = 'www.track-pod.com/blog/category/route-planning') OR (MappedLink LIKE 'www.track-pod.com/blog/category/route-planning?%')))))
ORDER BY "LinkMapping"."ID" DESC
0.0009s