0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0027s
0004: SHOW FULL FIELDS IN "Fluent_Domain"
0.0014s
0005: SHOW COLLATION LIKE 'utf8mb4_unicode_ci'
0.0008s
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.0296s
0007: SHOW FULL FIELDS IN "Fluent_Locale"
0.0009s
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.0003s
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.0006s
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.0012s
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.0008s
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.0005s
GET /blog/category/route-planning?flush=all&showqueries=1&start=249886666
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 = 'track-pod.com'))
AND ("LinkMapping"."LinkType" = ?)
ORDER BY "LinkMapping"."ID" DESC
0.0008s
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 = '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 = 'track-pod.com/blog/category/route-planning') OR (MappedLink LIKE 'track-pod.com/blog/category/route-planning?%')))))
ORDER BY "LinkMapping"."ID" DESC
0.0004s
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 = 'track-pod.com'))
AND ("LinkMapping"."LinkType" = ?)
ORDER BY "LinkMapping"."ID" DESC
0.0006s
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 = '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 = 'track-pod.com/blog/category/route-planning') OR (MappedLink LIKE 'track-pod.com/blog/category/route-planning?%')))))
ORDER BY "LinkMapping"."ID" DESC
0.0004s