GET https://www.staging.startplatz.de/event-series/afterwork-duesseldorf

Response
200 OK
IP
216.73.216.87
Profiled on
Token
3637f9

Query Metrics

13 Database Queries
8 Different statements
81.37 ms Query time
0 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
46.24 ms
(56.82%) 		2 
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ?
Parameters: 
[
  "afterwork-duesseldorf"
  7064
  "publish"
]
View formatted query    View runnable query    Explain query
26.87 ms
(33.02%) 		1 
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ?
Parameters: 
[
  "afterwork-duesseldorf"
  "publish"
]
View formatted query    View runnable query    Explain query
4.49 ms
(5.51%) 		5 
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC LIMIT 1
Parameters: 
[
  6803
  "2026-08-07 17:57:54"
  "2026-08-07 17:57:54"
]
View formatted query    View runnable query    Explain query
1.19 ms
(1.46%) 		1 
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.startDate > ? ORDER BY s0_.startDate ASC LIMIT 1
Parameters: 
[
  6803
  "2026-08-07 17:57:53"
]
View formatted query    View runnable query    Explain query
0.78 ms
(0.96%) 		1 
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                b.startDate as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM sp_event_events e
            INNER JOIN sp_event_dates b ON b.eventId = e.id
            WHERE e.seriesTag = ?
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND b.startDate > NOW()
         ORDER BY b.startDate ASC
Parameters: 
[
  "afterwork-duesseldorf"
]
View formatted query    View runnable query    Explain query
0.63 ms
(0.77%) 		1 
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.endDate, b.startDate) as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM sp_event_events e
            INNER JOIN sp_event_dates b ON b.eventId = e.id
            WHERE e.seriesTag = ?
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.endDate IS NOT NULL AND b.endDate < NOW()) OR
                (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW())
            )
         ORDER BY COALESCE(b.endDate, b.startDate) DESC
Parameters: 
[
  "afterwork-duesseldorf"
]
View formatted query    View runnable query    Explain query
0.60 ms
(0.74%) 		1 
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?))
Parameters: 
[
  6803
  "2026-08-07 17:57:54"
  "2026-08-07 17:57:54"
]
View formatted query    View runnable query    Explain query
0.58 ms
(0.71%) 		1 
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND s0_.startDate > ?
Parameters: 
[
  6803
  "2026-08-07 17:57:54"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\StartPlatz\Bundle\EventBundle\Entity\Event 9
App\StartPlatz\Bundle\EventBundle\Entity\EventDate 1

Entities Mapping

Class Mapping errors
App\StartPlatz\Bundle\UserBundle\Entity\User No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team No errors.
App\StartPlatz\Bundle\EventBundle\Entity\Event No errors.
App\StartPlatz\Bundle\EventBundle\Entity\EventDate No errors.