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.0003s
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.0007s
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.0002s
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.0002s
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.0003s
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.0002s
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.0002s
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.0003s
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.0002s
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.0002s
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.0002s
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.0002s
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.0003s
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.0009s
0040: SELECT DISTINCT count(DISTINCT "SeminarParticipant"."ID") AS "Count"
FROM "SeminarParticipant"
WHERE ("SeminarParticipant"."SeminarID" = ?)
AND ("SeminarParticipant"."IsSynced" = ?)
0.0002s
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 = 1406
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.0003s
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.0002s
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.0002s
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.0002s
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 = 1406
AND sso.Status = 'Paid'
0.0003s
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.0001s
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 = 1406
AND sso.Status = 'Paid'
0.0002s
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 = 1406
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.0003s
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.0002s
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.0002s
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.0002s
Schematherapie in der Gruppe – Grundlagen und Praxis » OAP
Schematherapie in der Gruppe – Grundlagen und Praxis
Dr. Antje Demmert
Schematherapie in der Gruppe bietet viele Möglichkeiten, das Moduskonzept und die schematherapeutischen Techniken anzuwenden und weiterzuentwickeln. Interpersonelle Schwierigkeiten werden in der Gruppe schnell offensichtlich und neue Verhaltensweisen können im sicheren Rahmen trainiert werden. Gruppenspezifische Wirkfaktoren wie Zusammengehörigkeitsgefühl, gegenseitige Unterstützung, Validierung sowie erlebnisbasierte Übungen unterstützen die Arbeit an dysfunktionalen Schemata und Modi.
Der Workshop richtet sich an Therapeut*innen, die bereits über grundlegende Kenntnisse der Schematherapie (Modi und Modusmodell) verfügen und ihre Kenntnisse auf das gruppentherapeutische Setting erweitern möchten. In dem Workshop soll ein fundiertes theoretisches Verständnis für Schematherapie in der Gruppe vermittelt werden und zugleich praxisnahe Anwendungen im therapeutischen Alltag ausprobiert werden.
Als theoretische Grundlagen werden Aufbau und Struktur der Gruppentherapie sowie die spezifische Rolle der Therapeut*innen im Gruppensetting beleuchtet. Die zentrale Rolle von Gruppenkohäsion, emotionalen Grundbedürfnissen und erlebnisbasierten Übungen zu verschiedenen Modi sowie die Rolle von Spiel und Spaß wird erarbeitet und in praktischen Übungen vorgestellt.
Der Workshop verbindet theoretische Inhalte mit praxisorientierten Beispielen und Übungen. Erlebnisbasierte Techniken werden exemplarisch vorgestellt, hinsichtlich ihrer Anpassung an das Gruppensetting reflektiert und in Kleingruppen (Break out rooms) geübt, um den Teilnehmenden die Möglichkeit zu bieten, das Gelernte unmittelbar auf ihre eigene therapeutische Praxis zu übertragen.
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 gestellt. 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 einen Tag vor 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.
Diese Fortbildung können Sie sich für die Zertifizierung als Schematherapeut*in über die ISST anrechnen lassen. Weiter Informationen zur Zertifizierung finden Sie unter: https://www.schematherapie-freiburg.de/zertifizierung/
