0003: SHOW DATABASES LIKE 'ss\_oap\_web\_production'
0.0003s
0004: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0027s
0005: SHOW FULL FIELDS IN "Fluent_Locale"
0.0005s
0006: SHOW COLLATION LIKE 'utf8mb3_general_ci'
0.0003s
0007: 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"."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"."Locale" ASC
0.0002s
0008: SHOW FULL FIELDS IN "Fluent_Domain"
0.0004s
0009: 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.0001s
0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."URLSegment" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SubTitle", "Page_Live"."MenuHovered", "Page_Live"."ShowInLegalMenu", "Page_Live"."ShowInMobileMenu", "Page_Live"."CrossLinkBadgeLeft", "Page_Live"."CrossLinkBadgeRight", "Page_Live"."CrossLinkBadgeAbsolute", "Page_Live"."CrossLinkTitle", "Page_Live"."CrossLinkContent", "Page_Live"."EnableStaticCache", "Page_Live"."HeaderImageID", "Page_Live"."BadgeImageID", "Page_Live"."CrossLinkImageID", "Page_Live"."CrossLinkBadgeID", "Page_Live"."ContactTeamMemberID", "ErrorPage_Live"."ErrorCode", "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 "ErrorPage_Live" ON "ErrorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."SubTitle", "Page_Live"."MenuHovered", "Page_Live"."ShowInLegalMenu", "Page_Live"."ShowInMobileMenu", "Page_Live"."CrossLinkBadgeLeft", "Page_Live"."CrossLinkBadgeRight", "Page_Live"."CrossLinkBadgeAbsolute", "Page_Live"."CrossLinkTitle", "Page_Live"."CrossLinkContent", "Page_Live"."EnableStaticCache", "Page_Live"."HeaderImageID", "Page_Live"."BadgeImageID", "Page_Live"."CrossLinkImageID", "Page_Live"."CrossLinkBadgeID", "Page_Live"."ContactTeamMemberID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0016: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live" INNER JOIN (SELECT DISTINCT "FileLink"."ClassName", "FileLink"."LastEdited", "FileLink"."Created", "FileLink"."LinkedID", "FileLink"."ParentID", "FileLink"."ParentClass", "FileLink"."ID",
CASE WHEN "FileLink"."ClassName" IS NOT NULL THEN "FileLink"."ClassName"
ELSE 'SilverStripe\\Assets\\Shortcodes\\FileLink' END AS "RecordClassName"
FROM "FileLink"
WHERE ("ParentClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("FileLink"."ParentID" = ?)) AS "FileLink" ON "FileLink"."LinkedID" = "File_Live"."ID"
ORDER BY "_SortColumn0" ASC
0.0005s
0017: SELECT "SiteTree_Live"."ID", "SiteTree_Live"."Sort" AS "_SortColumn0"
FROM "SiteTree_Live" INNER JOIN (SELECT DISTINCT "SiteTreeLink"."ClassName", "SiteTreeLink"."LastEdited", "SiteTreeLink"."Created", "SiteTreeLink"."LinkedID", "SiteTreeLink"."ParentID", "SiteTreeLink"."ParentClass", "SiteTreeLink"."ID",
CASE WHEN "SiteTreeLink"."ClassName" IS NOT NULL THEN "SiteTreeLink"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTreeLink' END AS "RecordClassName"
FROM "SiteTreeLink"
WHERE ("ParentClass" IN ('SilverStripe\\SiteConfig\\SiteConfig'))
AND ("SiteTreeLink"."ParentID" = ?)) AS "SiteTreeLink" ON "SiteTreeLink"."LinkedID" = "SiteTree_Live"."ID"
ORDER BY "_SortColumn0" ASC
0.0004s
0018: SELECT count(*) AS "Count"
FROM "SiteConfig"
WHERE ("ID" = ?)
0.0002s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0004s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0024: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
0.0002s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SubTitle", "Page_Live"."MenuHovered", "Page_Live"."ShowInLegalMenu", "Page_Live"."ShowInMobileMenu", "Page_Live"."CrossLinkBadgeLeft", "Page_Live"."CrossLinkBadgeRight", "Page_Live"."CrossLinkBadgeAbsolute", "Page_Live"."CrossLinkTitle", "Page_Live"."CrossLinkContent", "Page_Live"."EnableStaticCache", "Page_Live"."HeaderImageID", "Page_Live"."BadgeImageID", "Page_Live"."CrossLinkImageID", "Page_Live"."CrossLinkBadgeID", "Page_Live"."ContactTeamMemberID", "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"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0026: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SilverShop_CartPage_Live" ON "SilverShop_CartPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
0.0003s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SubTitle", "Page_Live"."MenuHovered", "Page_Live"."ShowInLegalMenu", "Page_Live"."ShowInMobileMenu", "Page_Live"."CrossLinkBadgeLeft", "Page_Live"."CrossLinkBadgeRight", "Page_Live"."CrossLinkBadgeAbsolute", "Page_Live"."CrossLinkTitle", "Page_Live"."CrossLinkContent", "Page_Live"."EnableStaticCache", "Page_Live"."HeaderImageID", "Page_Live"."BadgeImageID", "Page_Live"."CrossLinkImageID", "Page_Live"."CrossLinkBadgeID", "Page_Live"."ContactTeamMemberID", "SilverShop_CartPage_Live"."CheckoutPageID", "SilverShop_CartPage_Live"."ContinuePageID", "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 "SilverShop_CartPage_Live" ON "SilverShop_CartPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0029: SELECT DISTINCT "TeamMember"."ClassName", "TeamMember"."LastEdited", "TeamMember"."Created", "TeamMember"."Salutation", "TeamMember"."Content", "TeamMember"."Surname", "TeamMember"."Hash", "TeamMember"."ShowInLocale", "TeamMember"."Title", "TeamMember"."Position", "TeamMember"."Phone", "TeamMember"."Mobile", "TeamMember"."Mail", "TeamMember"."Fax", "TeamMember"."Sort", "TeamMember"."URLSegment", "TeamMember"."TeamPageID", "TeamMember"."ImageID", "TeamMember"."ID",
CASE WHEN "TeamMember"."ClassName" IS NOT NULL THEN "TeamMember"."ClassName"
ELSE 'Team\\DataObjects\\TeamMember' END AS "RecordClassName"
FROM "TeamMember"
WHERE ("TeamMember"."ID" = ?)
LIMIT 1
0.0003s
0030: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."Version", "File_Live"."IsTemporary", "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", "File_Live"."ObjectID", "File_Live"."ObjectClass", "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.0003s
0031: SELECT DISTINCT "Room"."ClassName", "Room"."LastEdited", "Room"."Created", "Room"."Title", "Room"."Description", "Room"."Address", "Room"."RoomType", "Room"."ZoomLink", "Room"."ID",
CASE WHEN "Room"."ClassName" IS NOT NULL THEN "Room"."ClassName"
ELSE 'Room' END AS "RecordClassName"
FROM "Room"
WHERE ("Room"."ID" = ?)
LIMIT 1
0.0002s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SubTitle", "Page_Live"."MenuHovered", "Page_Live"."ShowInLegalMenu", "Page_Live"."ShowInMobileMenu", "Page_Live"."CrossLinkBadgeLeft", "Page_Live"."CrossLinkBadgeRight", "Page_Live"."CrossLinkBadgeAbsolute", "Page_Live"."CrossLinkTitle", "Page_Live"."CrossLinkContent", "Page_Live"."EnableStaticCache", "Page_Live"."HeaderImageID", "Page_Live"."BadgeImageID", "Page_Live"."CrossLinkImageID", "Page_Live"."CrossLinkBadgeID", "Page_Live"."ContactTeamMemberID", "TeamPage_Live"."DisableLazyLoading", "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 "TeamPage_Live" ON "TeamPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SilverShop_Product_Live"."Tax", "SilverShop_Product_Live"."InternalItemID", "SilverShop_Product_Live"."Model", "SilverShop_Product_Live"."BasePrice", "SilverShop_Product_Live"."Weight", "SilverShop_Product_Live"."Height", "SilverShop_Product_Live"."Width", "SilverShop_Product_Live"."Depth", "SilverShop_Product_Live"."Featured", "SilverShop_Product_Live"."AllowPurchase", "SilverShop_Product_Live"."Popularity", "SilverShop_Product_Live"."ImageID", "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"."Title"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Title" ASC
LIMIT 1
0.0003s
0034: SELECT CASE WHEN EXISTS(SELECT *
FROM "SeminarInfo"
WHERE ("SeminarInfo"."SeminarID" = ?)) THEN 1 ELSE 0 END
0.0003s
0035: SELECT DISTINCT "SeminarInfo"."ClassName", "SeminarInfo"."LastEdited", "SeminarInfo"."Created", "SeminarInfo"."Sort", "SeminarInfo"."Titel", "SeminarInfo"."Inhalt", "SeminarInfo"."LegacyID", "SeminarInfo"."SeminarID", "SeminarInfo"."VideoPageID", "SeminarInfo"."ID",
CASE WHEN "SeminarInfo"."ClassName" IS NOT NULL THEN "SeminarInfo"."ClassName"
ELSE 'SeminarInfo' END AS "RecordClassName"
FROM "SeminarInfo"
WHERE ("SeminarInfo"."SeminarID" = ?)
0.0003s
0036: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0038: SELECT "SiteTree_Live"."ID", "SiteTree_Live"."Sort" AS "_SortColumn0"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SilverShop_ProductCategory_Live" ON "SilverShop_ProductCategory_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "SilverShop_Product_ProductCategories" ON "SilverShop_Product_ProductCategories"."SilverShop_ProductCategoryID" = "SiteTree_Live"."ID"
WHERE ("SilverShop_Product_ProductCategories"."SilverShop_ProductID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "_SortColumn0" ASC
0.0004s
0039: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SubTitle", "Page_Live"."MenuHovered", "Page_Live"."ShowInLegalMenu", "Page_Live"."ShowInMobileMenu", "Page_Live"."CrossLinkBadgeLeft", "Page_Live"."CrossLinkBadgeRight", "Page_Live"."CrossLinkBadgeAbsolute", "Page_Live"."CrossLinkTitle", "Page_Live"."CrossLinkContent", "Page_Live"."EnableStaticCache", "Page_Live"."HeaderImageID", "Page_Live"."BadgeImageID", "Page_Live"."CrossLinkImageID", "Page_Live"."CrossLinkBadgeID", "Page_Live"."ContactTeamMemberID", "SilverShop_ProductCategory_Live"."Intro", "SilverShop_ProductCategory_Live"."Icon", "SilverShop_ProductCategory_Live"."DisableLazyLoading", "SilverShop_ProductCategory_Live"."ElementalAreaID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SilverShop_ProductCategory_Live" ON "SilverShop_ProductCategory_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" IN (?, ?))
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
0.001s
0040: SELECT DISTINCT count(DISTINCT "SeminarParticipant"."ID") AS "Count"
FROM "SeminarParticipant"
WHERE ("SeminarParticipant"."SeminarID" = ?)
AND ("SeminarParticipant"."IsSynced" = ?)
0.0003s
0041: SELECT Count(*) FROM SilverShop_Order sso
LEFT JOIN SilverShop_OrderAttribute ssoa ON ssoa.OrderID = sso.ID
LEFT JOIN SilverShop_OrderItem ssoi on ssoa.ID = ssoi.ID
LEFT JOIN SilverShop_OrderItem_SeminarParticipants ssoisp ON ssoi.ID = ssoisp.SilverShop_OrderItemID
LEFT JOIN SeminarParticipant sp on ssoisp.SeminarParticipantID = sp.ID
LEFT JOIN SeminarPage sp2 on sp.SeminarID = sp2.ID
WHERE sp2.ID = 1415
AND sso.Status = 'Paid'
0.0003s
0042: SELECT DISTINCT "SilverShop_Order"."ClassName", "SilverShop_Order"."LastEdited", "SilverShop_Order"."Created", "SilverShop_Order"."BillingName", "SilverShop_Order"."VATNumber", "SilverShop_Order"."InvoiceNumber", "SilverShop_Order"."InvoiceHTML", "SilverShop_Order"."InvoicePrefix", "SilverShop_Order"."InvoiceDate", "SilverShop_Order"."ReferencePrefix", "SilverShop_Order"."Hints", "SilverShop_Order"."Hash", "SilverShop_Order"."ReceiptResent", "SilverShop_Order"."CorrectedMemberLink", "SilverShop_Order"."Total", "SilverShop_Order"."Reference", "SilverShop_Order"."Placed", "SilverShop_Order"."Paid", "SilverShop_Order"."ReceiptSent", "SilverShop_Order"."Printed", "SilverShop_Order"."Dispatched", "SilverShop_Order"."Status", "SilverShop_Order"."FirstName", "SilverShop_Order"."Surname", "SilverShop_Order"."Email", "SilverShop_Order"."Notes", "SilverShop_Order"."IPAddress", "SilverShop_Order"."SeparateBillingAddress", "SilverShop_Order"."Locale", "SilverShop_Order"."UsedPaymentOptionID", "SilverShop_Order"."MemberID", "SilverShop_Order"."ShippingAddressID", "SilverShop_Order"."BillingAddressID", "SilverShop_Order"."ID",
CASE WHEN "SilverShop_Order"."ClassName" IS NOT NULL THEN "SilverShop_Order"."ClassName"
ELSE 'SilverShop\\Model\\Order' END AS "RecordClassName"
FROM "SilverShop_Order"
WHERE ("Status" = 'Cart' )
ORDER BY "SilverShop_Order"."Placed" DESC, "SilverShop_Order"."Created" DESC
0.0003s
0043: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_OrderAttribute"."CalculatedTotal", "SilverShop_OrderAttribute"."OrderID", "SilverShop_OrderItem"."Discount", "SilverShop_OrderItem"."Quantity", "SilverShop_OrderItem"."UnitPrice", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."OrderID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?, ?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
0.0004s
0044: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_Product_OrderItem"."ProductVersion", "SilverShop_Product_OrderItem"."ProductID", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID" LEFT JOIN "SilverShop_Product_OrderItem" ON "SilverShop_Product_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."ID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
LIMIT 1
0.0003s
0045: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_OrderAttribute"."CalculatedTotal", "SilverShop_OrderAttribute"."OrderID", "SilverShop_OrderItem"."Discount", "SilverShop_OrderItem"."Quantity", "SilverShop_OrderItem"."UnitPrice", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."OrderID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?, ?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
0.0004s
0046: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_Product_OrderItem"."ProductVersion", "SilverShop_Product_OrderItem"."ProductID", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID" LEFT JOIN "SilverShop_Product_OrderItem" ON "SilverShop_Product_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."ID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
LIMIT 1
0.0003s
0047: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_Product_OrderItem"."ProductVersion", "SilverShop_Product_OrderItem"."ProductID", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID" LEFT JOIN "SilverShop_Product_OrderItem" ON "SilverShop_Product_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."ID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
LIMIT 1
0.0002s
0048: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_Product_OrderItem"."ProductVersion", "SilverShop_Product_OrderItem"."ProductID", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID" LEFT JOIN "SilverShop_Product_OrderItem" ON "SilverShop_Product_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."ID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
LIMIT 1
0.0003s
0049: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_OrderAttribute"."CalculatedTotal", "SilverShop_OrderAttribute"."OrderID", "SilverShop_OrderItem"."Discount", "SilverShop_OrderItem"."Quantity", "SilverShop_OrderItem"."UnitPrice", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."OrderID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?, ?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
0.0003s
0050: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_Product_OrderItem"."ProductVersion", "SilverShop_Product_OrderItem"."ProductID", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID" LEFT JOIN "SilverShop_Product_OrderItem" ON "SilverShop_Product_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."ID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
LIMIT 1
0.0003s
0051: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_Product_OrderItem"."ProductVersion", "SilverShop_Product_OrderItem"."ProductID", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID" LEFT JOIN "SilverShop_Product_OrderItem" ON "SilverShop_Product_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."ID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
LIMIT 1
0.0002s
0052: SELECT DISTINCT "SilverShop_OrderAttribute"."ClassName", "SilverShop_OrderAttribute"."LastEdited", "SilverShop_OrderAttribute"."Created", "SilverShop_Product_OrderItem"."ProductVersion", "SilverShop_Product_OrderItem"."ProductID", "SilverShop_OrderAttribute"."ID",
CASE WHEN "SilverShop_OrderAttribute"."ClassName" IS NOT NULL THEN "SilverShop_OrderAttribute"."ClassName"
ELSE 'SilverShop\\Model\\OrderAttribute' END AS "RecordClassName"
FROM "SilverShop_OrderAttribute" LEFT JOIN "SilverShop_OrderItem" ON "SilverShop_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID" LEFT JOIN "SilverShop_Product_OrderItem" ON "SilverShop_Product_OrderItem"."ID" = "SilverShop_OrderAttribute"."ID"
WHERE ("SilverShop_OrderAttribute"."ID" = ?)
AND ("SilverShop_OrderAttribute"."ClassName" IN (?, ?, ?))
ORDER BY "SilverShop_OrderAttribute"."Created" DESC
LIMIT 1
0.0002s
0053: SELECT CASE WHEN EXISTS(SELECT *
FROM "SilverShop_Variation"
WHERE ("SilverShop_Variation"."ProductID" = ?)) THEN 1 ELSE 0 END
0.0002s
0054: SELECT CASE WHEN EXISTS(SELECT *
FROM "SilverShop_SpecificPrice"
WHERE ("SilverShop_SpecificPrice"."ProductID" = ?)
AND ("SilverShop_SpecificPrice"."Price" < ?)) THEN 1 ELSE 0 END
0.0002s
0055: SELECT Count(*) FROM SilverShop_Order sso
LEFT JOIN SilverShop_OrderAttribute ssoa ON ssoa.OrderID = sso.ID
LEFT JOIN SilverShop_OrderItem ssoi on ssoa.ID = ssoi.ID
LEFT JOIN SilverShop_OrderItem_SeminarParticipants ssoisp ON ssoi.ID = ssoisp.SilverShop_OrderItemID
LEFT JOIN SeminarParticipant sp on ssoisp.SeminarParticipantID = sp.ID
LEFT JOIN SeminarPage sp2 on sp.SeminarID = sp2.ID
WHERE sp2.ID = 1415
AND sso.Status = 'Paid'
0.0002s
0056: SELECT DISTINCT count(DISTINCT "SeminarParticipant"."ID") AS "Count"
FROM "SeminarParticipant"
WHERE ("SeminarParticipant"."SeminarID" = ?)
AND ("SeminarParticipant"."IsSynced" = ?)
0.0002s
0057: SELECT CASE WHEN EXISTS(SELECT *
FROM "SilverShop_Variation"
WHERE ("SilverShop_Variation"."ProductID" = ?)) THEN 1 ELSE 0 END
0.0002s
0058: SELECT Count(*) FROM SilverShop_Order sso
LEFT JOIN SilverShop_OrderAttribute ssoa ON ssoa.OrderID = sso.ID
LEFT JOIN SilverShop_OrderItem ssoi on ssoa.ID = ssoi.ID
LEFT JOIN SilverShop_OrderItem_SeminarParticipants ssoisp ON ssoi.ID = ssoisp.SilverShop_OrderItemID
LEFT JOIN SeminarParticipant sp on ssoisp.SeminarParticipantID = sp.ID
LEFT JOIN SeminarPage sp2 on sp.SeminarID = sp2.ID
WHERE sp2.ID = 1415
AND sso.Status = 'Paid'
0.0003s
0059: SELECT DISTINCT count(DISTINCT "SeminarParticipant"."ID") AS "Count"
FROM "SeminarParticipant"
WHERE ("SeminarParticipant"."SeminarID" = ?)
AND ("SeminarParticipant"."IsSynced" = ?)
0.0002s
0060: SELECT DISTINCT count(DISTINCT "SeminarParticipant"."ID") AS "Count"
FROM "SeminarParticipant"
WHERE ("SeminarParticipant"."SeminarID" = ?)
AND ("SeminarParticipant"."IsSynced" = ?)
0.0002s
0061: SELECT Count(*) FROM SilverShop_Order sso
LEFT JOIN SilverShop_OrderAttribute ssoa ON ssoa.OrderID = sso.ID
LEFT JOIN SilverShop_OrderItem ssoi on ssoa.ID = ssoi.ID
LEFT JOIN SilverShop_OrderItem_SeminarParticipants ssoisp ON ssoi.ID = ssoisp.SilverShop_OrderItemID
LEFT JOIN SeminarParticipant sp on ssoisp.SeminarParticipantID = sp.ID
LEFT JOIN SeminarPage sp2 on sp.SeminarID = sp2.ID
WHERE sp2.ID = 1415
AND sso.Status = 'Paid'
0.0002s
0062: SELECT CASE WHEN EXISTS(SELECT *
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SilverShop_Product_Live" ON "SilverShop_Product_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SeminarPage_Live" ON "SeminarPage_Live"."ID" = "SiteTree_Live"."ID" INNER JOIN "SeminarPage_RelatedSeminars" ON "SeminarPage_RelatedSeminars"."ChildID" = "SiteTree_Live"."ID"
WHERE ("SeminarPage_RelatedSeminars"."SeminarPageID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0003s
0063: SELECT "SilverShop_Order"."Email", "SilverShop_Order"."Placed" AS "_SortColumn0", "SilverShop_Order"."Created" AS "_SortColumn1"
FROM "SilverShop_Order"
WHERE ("SilverShop_Order"."Status" IN (?, ?, ?, ?, ?))
ORDER BY "_SortColumn0" DESC, "_SortColumn1" DESC
0.0206s
0064: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0004s
0065: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0066: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0067: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree"
WHERE ("SiteTree"."ID" = ?)
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0003s
0068: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
Alpträume erfolgreich behandeln: Die Imagery Rehearsal Therapy » OAP
Alpträume erfolgreich behandeln: Die Imagery Rehearsal Therapy
Prof. Dr. Reinhard Pietrowsky
Alpträume kommen in der psychotherapeutischen Praxis relativ häufig vor und spielen bei Patienten mit Posttraumatischen Belastungsstörungen (PTBS) eine wichtige Rolle. Abgesehen vom Auftreten im Rahmen einer PTBS wurde ihnen bislang wenig Beachtung geschenkt. Entsprechen sind kaum etablierte Behandlungsverfahren bekannt. In dem Workshop werden Therapiemöglichkeiten von Alpträumen vorgestellt. Ein Schwerpunkt wird die Darstellung eines manualisiertes Therapiekonzepts zur Behandlung von Alpträumen auf der Grundlage der Imagery Rehearsal Therapie (IRT) sein. Bei der IRT handelt es sich um ein imaginatives Verfahren, welches das Überschreiben (Rescripting) des ursprünglichen Alptraums in einen neutralen oder positiven Traum und das imaginative Einüben dieses neuen Traumskriptes beinhaltet. Zudem werden durch die IRT die Selbstwirksamkeit und das Selbstvertrauen erhöht. Die IRT ist erwiesenermaßen geeignet zur Behandlung von idiopathischen und posttraumatischen Alpträumen. In dem Workshop wird anhand praktischer Übungen das IRT-Verfahren demonstriert und selbst angewandt. Besonderheiten bei der Behandlung von Personen mit Traumafolgestörungen und bei Kindern oder Jugendlichen werden expliziert.
Hinweis: Um eine gute Arbeitsatmosphäre zu gewährleisten, bitten wir Sie bei unseren Praxisworkshops mit Bild & Ton teilzunehmen.
Psychologische und ärztliche Psychotherapeuten; Kinder- und Jugendlichen Psychotherapeut*innen
Ein Antrag auf Akkreditierung dieses Vortrages ist bei der Landespsychotherapeutenkammer Baden-Württemberg gestellt. Die Punkte werden in der Regel auch von allen Psychotherapeuten-und Ärztekammern in Deutschland, Österreich und der Schweiz anerkannt. Im Anschluss an den Vortrag erhalten Sie automatisch eine E-Mail mit Ihrer Teilnahmebescheinigung und Ihren Fortbildungspunkten.
Sie benötigen ein internetfähiges Endgerät (Computer, Tablet oder Smartphone) mit Lautsprechern und eine stabile Internetverbindung. Der Praxisworkshop wird als Zoom-Meeting abgehalten. Bitte aktivieren Sie hierfür Ihre Kamera. Ihr Mikrofon ist zunächst stumm geschaltet, Sie können es aber für Wortmeldungen aktivieren.
Sie erhalten am Tag der Veranstaltung den Zoom-Link zur Teilnahme und die Veranstaltungsunterlagen per E-Mail zugesandt. Zur Teilnahme müssen Sie lediglich den Link anklicken und das Webinar/ Meeting wird automatisch in Ihrem Browser geöffnet.
