0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0035s
0004: SHOW FULL FIELDS IN "Fluent_Domain"
0.0017s
0005: SHOW COLLATION LIKE 'utf8mb4_unicode_ci'
0.0011s
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.0005s
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.0006s
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.0012s
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.0065s
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.0014s
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.0009s
GET /blog/category/route-planning?showqueries=1&start=249878842
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.0014s
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.0009s
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.0011s
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