http://www.staging.startplatz.de/event-series/ki-einstieg-fuer-alle-und-effektives-prompting

Method
GET
HTTP Status
200
IP
172.22.0.12
Profiled on
Token
59ed30

Query Metrics

10 Database Queries
8 Different statements
70.35 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 14.71 ms 
SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ?
Parameters: 
[
  "ki-einstieg-fuer-alle-und-effektives-prompting"
  "publish"
]
View formatted query    View runnable query    Explain query
2 1.57 ms 
SELECT a0_.id AS id_0, a0_.programId AS programId_1, a0_.eventId AS eventId_2, a0_.productId AS productId_3, a0_.batchNumber AS batchNumber_4, a0_.url AS url_5, a0_.name AS name_6, a0_.slug AS slug_7, a0_.alias AS alias_8, a0_.status AS status_9, a0_.focusStatus AS focusStatus_10, a0_.lang AS lang_11, a0_.priceInEuroCent AS priceInEuroCent_12, a0_.isTaxIncluded AS isTaxIncluded_13, a0_.discount100MemberTags AS discount100MemberTags_14, a0_.discount50MemberTags AS discount50MemberTags_15, a0_.discount20MemberTags AS discount20MemberTags_16, a0_.askForTeam AS askForTeam_17, a0_.hasEvent AS hasEvent_18, a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, a0_.hasIncludePhone AS hasIncludePhone_22, a0_.hasFollowUp AS hasFollowUp_23, a0_.isNetworking AS isNetworking_24, a0_.networkingRounds AS networkingRounds_25, a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, a0_.isFutureEvent AS isFutureEvent_28, a0_.visibility AS visibility_29, a0_.access AS access_30, a0_.tags AS tags_31, a0_.typeformLink AS typeformLink_32, a0_.zoomLink AS zoomLink_33, a0_.bgImageUrl AS bgImageUrl_34, a0_.startDate AS startDate_35, a0_.endDate AS endDate_36, a0_.stripePriceId AS stripePriceId_37, a0_.stripeProductId AS stripeProductId_38, a0_.stripeAccount AS stripeAccount_39, a0_.isFreeForKiCampus AS isFreeForKiCampus_40, a0_.isFreeForCommunity AS isFreeForCommunity_41, a0_.mailDesignTemplate AS mailDesignTemplate_42, a0_.senderMail AS senderMail_43, a0_.fromName AS fromName_44, a0_.recipientMonitoringMail AS recipientMonitoringMail_45, a0_.confirmationMailSubject AS confirmationMailSubject_46, a0_.confirmationMailContent AS confirmationMailContent_47, a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, a0_.adminNotificationMailContent AS adminNotificationMailContent_49, a0_.reminderMailTemplateId AS reminderMailTemplateId_50, a0_.reminderSenderEmail AS reminderSenderEmail_51, a0_.reminderBulkMailId AS reminderBulkMailId_52, a0_.reminderMailSendDate AS reminderMailSendDate_53, a0_.reminderMailSubject AS reminderMailSubject_54, a0_.reminderMailContent AS reminderMailContent_55, a0_.$reminderMailStatus AS reminderMailStatus_56, a0_.surveyId AS surveyId_57, a0_.surveyMailTemplateId AS surveyMailTemplateId_58, a0_.surveyBulkMailId AS surveyBulkMailId_59, a0_.template AS template_60, a0_.pageTemplate AS pageTemplate_61, a0_.footerTemplate AS footerTemplate_62, a0_.email AS email_63, a0_.emailSubject AS emailSubject_64, a0_.emailContent AS emailContent_65, a0_.landingPageContent AS landingPageContent_66, a0_.landingPageDescription AS landingPageDescription_67, a0_.landingPageCss AS landingPageCss_68, a0_.landingPageJs AS landingPageJs_69, a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, a0_.landingPageSocialImage AS landingPageSocialImage_71, a0_.landingPageTitle AS landingPageTitle_72, a0_.landingPageTwig AS landingPageTwig_73, a0_.goToPage AS goToPage_74, a0_.phrasesDe AS phrasesDe_75, a0_.phrasesEn AS phrasesEn_76, a0_.settings AS settings_77, a0_.asssesmentDimensions AS asssesmentDimensions_78, a0_.start AS start_79, a0_.end AS end_80, a0_.pitchTopic AS pitchTopic_81, a0_.pitchImageLink AS pitchImageLink_82, a0_.pitchVideoLink AS pitchVideoLink_83, a0_.pitchPartner AS pitchPartner_84, a0_.pitchPartnerId AS pitchPartnerId_85, a0_.pitchDescription AS pitchDescription_86, a0_.followUpPageContent AS followUpPageContent_87, a0_.followUpPageDescription AS followUpPageDescription_88, a0_.followUpPageCss AS followUpPageCss_89, a0_.followUpPageJs AS followUpPageJs_90, a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, a0_.followUpPageTitle AS followUpPageTitle_92, a0_.followUpPageSocialImage AS followUpPageSocialImage_93, a0_.followUpDescription AS followUpDescription_94, a0_.followUpVideoLink AS followUpVideoLink_95, a0_.followUpPresentation AS followUpPresentation_96, a0_.pitchDate AS pitchDate_97, a0_.pitchTime AS pitchTime_98, a0_.city AS city_99, a0_.applicationsCount AS applicationsCount_100, a0_.startedCount AS startedCount_101, a0_.appliedCount AS appliedCount_102, a0_.approvedCount AS approvedCount_103, a0_.rejectedCount AS rejectedCount_104, a0_.$skoolWebhook AS skoolWebhook_105, a0_.zapierWebhook AS zapierWebhook_106, a0_.history AS history_107, a0_.createdAt AS createdAt_108, a0_.lastModified AS lastModified_109, a0_.lastChangeUser AS lastChangeUser_110, a0_.program_id AS program_id_111, a0_.assessmentTeamId AS assessmentTeamId_112 FROM aab_batches a0_ WHERE a0_.eventId = ? AND ((a0_.startDate IS NOT NULL AND a0_.startDate > ?) OR (a0_.startDate IS NULL AND a0_.pitchDate > ?)) ORDER BY a0_.startDate ASC, a0_.pitchDate ASC LIMIT 1
Parameters: 
[
  6423
  "2025-12-29 10:33:22"
  "2025-12-29 10:33:22"
]
View formatted query    View runnable query    Explain query
3 15.72 ms 
SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.status = ?
Parameters: 
[
  "ki-einstieg-fuer-alle-und-effektives-prompting"
  "publish"
]
View formatted query    View runnable query    Explain query
4 1.93 ms 
SELECT a0_.id AS id_0, a0_.programId AS programId_1, a0_.eventId AS eventId_2, a0_.productId AS productId_3, a0_.batchNumber AS batchNumber_4, a0_.url AS url_5, a0_.name AS name_6, a0_.slug AS slug_7, a0_.alias AS alias_8, a0_.status AS status_9, a0_.focusStatus AS focusStatus_10, a0_.lang AS lang_11, a0_.priceInEuroCent AS priceInEuroCent_12, a0_.isTaxIncluded AS isTaxIncluded_13, a0_.discount100MemberTags AS discount100MemberTags_14, a0_.discount50MemberTags AS discount50MemberTags_15, a0_.discount20MemberTags AS discount20MemberTags_16, a0_.askForTeam AS askForTeam_17, a0_.hasEvent AS hasEvent_18, a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, a0_.hasIncludePhone AS hasIncludePhone_22, a0_.hasFollowUp AS hasFollowUp_23, a0_.isNetworking AS isNetworking_24, a0_.networkingRounds AS networkingRounds_25, a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, a0_.isFutureEvent AS isFutureEvent_28, a0_.visibility AS visibility_29, a0_.access AS access_30, a0_.tags AS tags_31, a0_.typeformLink AS typeformLink_32, a0_.zoomLink AS zoomLink_33, a0_.bgImageUrl AS bgImageUrl_34, a0_.startDate AS startDate_35, a0_.endDate AS endDate_36, a0_.stripePriceId AS stripePriceId_37, a0_.stripeProductId AS stripeProductId_38, a0_.stripeAccount AS stripeAccount_39, a0_.isFreeForKiCampus AS isFreeForKiCampus_40, a0_.isFreeForCommunity AS isFreeForCommunity_41, a0_.mailDesignTemplate AS mailDesignTemplate_42, a0_.senderMail AS senderMail_43, a0_.fromName AS fromName_44, a0_.recipientMonitoringMail AS recipientMonitoringMail_45, a0_.confirmationMailSubject AS confirmationMailSubject_46, a0_.confirmationMailContent AS confirmationMailContent_47, a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, a0_.adminNotificationMailContent AS adminNotificationMailContent_49, a0_.reminderMailTemplateId AS reminderMailTemplateId_50, a0_.reminderSenderEmail AS reminderSenderEmail_51, a0_.reminderBulkMailId AS reminderBulkMailId_52, a0_.reminderMailSendDate AS reminderMailSendDate_53, a0_.reminderMailSubject AS reminderMailSubject_54, a0_.reminderMailContent AS reminderMailContent_55, a0_.$reminderMailStatus AS reminderMailStatus_56, a0_.surveyId AS surveyId_57, a0_.surveyMailTemplateId AS surveyMailTemplateId_58, a0_.surveyBulkMailId AS surveyBulkMailId_59, a0_.template AS template_60, a0_.pageTemplate AS pageTemplate_61, a0_.footerTemplate AS footerTemplate_62, a0_.email AS email_63, a0_.emailSubject AS emailSubject_64, a0_.emailContent AS emailContent_65, a0_.landingPageContent AS landingPageContent_66, a0_.landingPageDescription AS landingPageDescription_67, a0_.landingPageCss AS landingPageCss_68, a0_.landingPageJs AS landingPageJs_69, a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, a0_.landingPageSocialImage AS landingPageSocialImage_71, a0_.landingPageTitle AS landingPageTitle_72, a0_.landingPageTwig AS landingPageTwig_73, a0_.goToPage AS goToPage_74, a0_.phrasesDe AS phrasesDe_75, a0_.phrasesEn AS phrasesEn_76, a0_.settings AS settings_77, a0_.asssesmentDimensions AS asssesmentDimensions_78, a0_.start AS start_79, a0_.end AS end_80, a0_.pitchTopic AS pitchTopic_81, a0_.pitchImageLink AS pitchImageLink_82, a0_.pitchVideoLink AS pitchVideoLink_83, a0_.pitchPartner AS pitchPartner_84, a0_.pitchPartnerId AS pitchPartnerId_85, a0_.pitchDescription AS pitchDescription_86, a0_.followUpPageContent AS followUpPageContent_87, a0_.followUpPageDescription AS followUpPageDescription_88, a0_.followUpPageCss AS followUpPageCss_89, a0_.followUpPageJs AS followUpPageJs_90, a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, a0_.followUpPageTitle AS followUpPageTitle_92, a0_.followUpPageSocialImage AS followUpPageSocialImage_93, a0_.followUpDescription AS followUpDescription_94, a0_.followUpVideoLink AS followUpVideoLink_95, a0_.followUpPresentation AS followUpPresentation_96, a0_.pitchDate AS pitchDate_97, a0_.pitchTime AS pitchTime_98, a0_.city AS city_99, a0_.applicationsCount AS applicationsCount_100, a0_.startedCount AS startedCount_101, a0_.appliedCount AS appliedCount_102, a0_.approvedCount AS approvedCount_103, a0_.rejectedCount AS rejectedCount_104, a0_.$skoolWebhook AS skoolWebhook_105, a0_.zapierWebhook AS zapierWebhook_106, a0_.history AS history_107, a0_.createdAt AS createdAt_108, a0_.lastModified AS lastModified_109, a0_.lastChangeUser AS lastChangeUser_110, a0_.program_id AS program_id_111, a0_.assessmentTeamId AS assessmentTeamId_112 FROM aab_batches a0_ WHERE a0_.eventId = ? AND ((a0_.endDate IS NOT NULL AND a0_.endDate < ?) OR (a0_.endDate IS NULL AND a0_.startDate < ?) OR (a0_.startDate IS NULL AND a0_.pitchDate < ?)) ORDER BY a0_.endDate DESC, a0_.startDate DESC, a0_.pitchDate DESC LIMIT 1
Parameters: 
[
  6423
  "2025-12-29 10:33:22"
  "2025-12-29 10:33:22"
  "2025-12-29 10:33:22"
]
View formatted query    View runnable query    Explain query
5 16.49 ms 
SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.status = ?
Parameters: 
[
  "ki-einstieg-fuer-alle-und-effektives-prompting"
  6423
  "publish"
]
View formatted query    View runnable query    Explain query
6 15.01 ms 
SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag = ? AND a0_.id <> ? AND a0_.status = ?
Parameters: 
[
  "ki-einstieg-fuer-alle-und-effektives-prompting"
  6423
  "publish"
]
View formatted query    View runnable query    Explain query
7 1.90 ms 
SELECT a0_.id AS id_0, a0_.programId AS programId_1, a0_.eventId AS eventId_2, a0_.productId AS productId_3, a0_.batchNumber AS batchNumber_4, a0_.url AS url_5, a0_.name AS name_6, a0_.slug AS slug_7, a0_.alias AS alias_8, a0_.status AS status_9, a0_.focusStatus AS focusStatus_10, a0_.lang AS lang_11, a0_.priceInEuroCent AS priceInEuroCent_12, a0_.isTaxIncluded AS isTaxIncluded_13, a0_.discount100MemberTags AS discount100MemberTags_14, a0_.discount50MemberTags AS discount50MemberTags_15, a0_.discount20MemberTags AS discount20MemberTags_16, a0_.askForTeam AS askForTeam_17, a0_.hasEvent AS hasEvent_18, a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, a0_.hasIncludePhone AS hasIncludePhone_22, a0_.hasFollowUp AS hasFollowUp_23, a0_.isNetworking AS isNetworking_24, a0_.networkingRounds AS networkingRounds_25, a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, a0_.isFutureEvent AS isFutureEvent_28, a0_.visibility AS visibility_29, a0_.access AS access_30, a0_.tags AS tags_31, a0_.typeformLink AS typeformLink_32, a0_.zoomLink AS zoomLink_33, a0_.bgImageUrl AS bgImageUrl_34, a0_.startDate AS startDate_35, a0_.endDate AS endDate_36, a0_.stripePriceId AS stripePriceId_37, a0_.stripeProductId AS stripeProductId_38, a0_.stripeAccount AS stripeAccount_39, a0_.isFreeForKiCampus AS isFreeForKiCampus_40, a0_.isFreeForCommunity AS isFreeForCommunity_41, a0_.mailDesignTemplate AS mailDesignTemplate_42, a0_.senderMail AS senderMail_43, a0_.fromName AS fromName_44, a0_.recipientMonitoringMail AS recipientMonitoringMail_45, a0_.confirmationMailSubject AS confirmationMailSubject_46, a0_.confirmationMailContent AS confirmationMailContent_47, a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, a0_.adminNotificationMailContent AS adminNotificationMailContent_49, a0_.reminderMailTemplateId AS reminderMailTemplateId_50, a0_.reminderSenderEmail AS reminderSenderEmail_51, a0_.reminderBulkMailId AS reminderBulkMailId_52, a0_.reminderMailSendDate AS reminderMailSendDate_53, a0_.reminderMailSubject AS reminderMailSubject_54, a0_.reminderMailContent AS reminderMailContent_55, a0_.$reminderMailStatus AS reminderMailStatus_56, a0_.surveyId AS surveyId_57, a0_.surveyMailTemplateId AS surveyMailTemplateId_58, a0_.surveyBulkMailId AS surveyBulkMailId_59, a0_.template AS template_60, a0_.pageTemplate AS pageTemplate_61, a0_.footerTemplate AS footerTemplate_62, a0_.email AS email_63, a0_.emailSubject AS emailSubject_64, a0_.emailContent AS emailContent_65, a0_.landingPageContent AS landingPageContent_66, a0_.landingPageDescription AS landingPageDescription_67, a0_.landingPageCss AS landingPageCss_68, a0_.landingPageJs AS landingPageJs_69, a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, a0_.landingPageSocialImage AS landingPageSocialImage_71, a0_.landingPageTitle AS landingPageTitle_72, a0_.landingPageTwig AS landingPageTwig_73, a0_.goToPage AS goToPage_74, a0_.phrasesDe AS phrasesDe_75, a0_.phrasesEn AS phrasesEn_76, a0_.settings AS settings_77, a0_.asssesmentDimensions AS asssesmentDimensions_78, a0_.start AS start_79, a0_.end AS end_80, a0_.pitchTopic AS pitchTopic_81, a0_.pitchImageLink AS pitchImageLink_82, a0_.pitchVideoLink AS pitchVideoLink_83, a0_.pitchPartner AS pitchPartner_84, a0_.pitchPartnerId AS pitchPartnerId_85, a0_.pitchDescription AS pitchDescription_86, a0_.followUpPageContent AS followUpPageContent_87, a0_.followUpPageDescription AS followUpPageDescription_88, a0_.followUpPageCss AS followUpPageCss_89, a0_.followUpPageJs AS followUpPageJs_90, a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, a0_.followUpPageTitle AS followUpPageTitle_92, a0_.followUpPageSocialImage AS followUpPageSocialImage_93, a0_.followUpDescription AS followUpDescription_94, a0_.followUpVideoLink AS followUpVideoLink_95, a0_.followUpPresentation AS followUpPresentation_96, a0_.pitchDate AS pitchDate_97, a0_.pitchTime AS pitchTime_98, a0_.city AS city_99, a0_.applicationsCount AS applicationsCount_100, a0_.startedCount AS startedCount_101, a0_.appliedCount AS appliedCount_102, a0_.approvedCount AS approvedCount_103, a0_.rejectedCount AS rejectedCount_104, a0_.$skoolWebhook AS skoolWebhook_105, a0_.zapierWebhook AS zapierWebhook_106, a0_.history AS history_107, a0_.createdAt AS createdAt_108, a0_.lastModified AS lastModified_109, a0_.lastChangeUser AS lastChangeUser_110, a0_.program_id AS program_id_111, a0_.assessmentTeamId AS assessmentTeamId_112 FROM aab_batches a0_ WHERE a0_.eventId = ? AND a0_.status = ? AND a0_.access = ? AND ((a0_.startDate IS NOT NULL AND a0_.startDate > ?) OR (a0_.startDate IS NULL AND a0_.pitchDate > ?)) ORDER BY a0_.startDate ASC, a0_.pitchDate ASC LIMIT 1
Parameters: 
[
  6423
  "active"
  "anonymous"
  "2025-12-29 10:33:22"
  "2025-12-29 10:33:22"
]
View formatted query    View runnable query    Explain query
8 1.23 ms 
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.startDate, b.pitchDate) 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 asp_events e
            INNER JOIN aab_batches b ON b.eventId = e.id
            WHERE e.seriesTag = :seriesTag
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.startDate IS NOT NULL AND b.startDate > NOW()) OR 
                (b.startDate IS NULL AND b.pitchDate > NOW())
            )
         ORDER BY COALESCE(b.startDate, b.pitchDate) ASC
Parameters: 
[
  "seriesTag" => "ki-einstieg-fuer-alle-und-effektives-prompting"
]
View formatted query    View runnable query    Explain query
9 1.37 ms 
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, b.pitchDate) 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 asp_events e
            INNER JOIN aab_batches b ON b.eventId = e.id
            WHERE e.seriesTag = :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()) OR
                (b.startDate IS NULL AND b.pitchDate < NOW())
            )
         ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC
Parameters: 
[
  "seriesTag" => "ki-einstieg-fuer-alle-und-effektives-prompting"
]
View formatted query    View runnable query    Explain query
10 0.42 ms 
SELECT t0.id AS id_1, t0.spMemberId AS spMemberId_2, t0.score AS score_3, t0.completenessScore AS completenessScore_4, t0.status AS status_5, t0.location AS location_6, t0.salutation AS salutation_7, t0.title AS title_8, t0.jobTitle AS jobTitle_9, t0.firstName AS firstName_10, t0.lastName AS lastName_11, t0.name AS name_12, t0.sortName AS sortName_13, t0.email AS email_14, t0.secondaryEmail AS secondaryEmail_15, t0.phone AS phone_16, t0.hasCommunityMembership AS hasCommunityMembership_17, t0.aiMemberValid AS aiMemberValid_18, t0.aiMemberStatus AS aiMemberStatus_19, t0.aiMemberReason AS aiMemberReason_20, t0.aiMemberStart AS aiMemberStart_21, t0.aiMemberEnd AS aiMemberEnd_22, t0.utm_source AS utm_source_23, t0.utm_medium AS utm_medium_24, t0.utm_campaign AS utm_campaign_25, t0.utm_term AS utm_term_26, t0.utm_content AS utm_content_27, t0.birthday AS birthday_28, t0.addressFieldOne AS addressFieldOne_29, t0.addressFieldTwo AS addressFieldTwo_30, t0.addressCountryCode AS addressCountryCode_31, t0.addressPostalCode AS addressPostalCode_32, t0.addressCity AS addressCity_33, t0.teamId AS teamId_34, t0.teamName AS teamName_35, t0.company AS company_36, t0.history AS history_37, t0.tags AS tags_38, t0.annotation AS annotation_39, t0.mentorBuckets AS mentorBuckets_40, t0.areasOfExpertise AS areasOfExpertise_41, t0.mentor_firma AS mentor_firma_42, t0.mentor_firma_url AS mentor_firma_url_43, t0.mentor_locations AS mentor_locations_44, t0.mentor_profile AS mentor_profile_45, t0.mentor_note AS mentor_note_46, t0.mentor_admin_rating AS mentor_admin_rating_47, t0.active AS active_48, t0.tiefgarage AS tiefgarage_49, t0.transponder AS transponder_50, t0.isTransponderAllowed AS isTransponderAllowed_51, t0.imageLink AS imageLink_52, t0.homepage AS homepage_53, t0.xing AS xing_54, t0.pipedriveId AS pipedriveId_55, t0.linkedin AS linkedin_56, t0.facebook AS facebook_57, t0.instagram AS instagram_58, t0.twitter AS twitter_59, t0.skills AS skills_60, t0.description AS description_61, t0.touchpoints AS touchpoints_62, t0.isAddressComplete AS isAddressComplete_63, t0.hasMailchimp AS hasMailchimp_64, t0.hasKiNewsletter AS hasKiNewsletter_65, t0.enterDate AS enterDate_66, t0.exitDate AS exitDate_67, t0.physicalMembershipStarted AS physicalMembershipStarted_68, t0.physicalMembershipEnded AS physicalMembershipEnded_69, t0.lastModified AS lastModified_70, t0.lastChangeUser AS lastChangeUser_71, t0.nAiWebinarsAttended AS nAiWebinarsAttended_72, t0.nAiWebinarsApplied AS nAiWebinarsApplied_73, t0.nAiEventsAttended AS nAiEventsAttended_74, t0.nAiEventsApplied AS nAiEventsApplied_75, t0.nPaidAttended AS nPaidAttended_76, t0.nPaidApplied AS nPaidApplied_77, t0.nKiEinstiegAttended AS nKiEinstiegAttended_78, t0.nKiEinstiegApplied AS nKiEinstiegApplied_79, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_80, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_81, t0.nEcodynamicsAttended AS nEcodynamicsAttended_82, t0.nEcodynamicsApplied AS nEcodynamicsApplied_83, t0.nBbqApplied AS nBbqApplied_84, t0.nAiFridayApplied AS nAiFridayApplied_85, t0.nAiGatheringApplied AS nAiGatheringApplied_86, t0.nAiGatheringAttended AS nAiGatheringAttended_87, t0.aiSs24Applied AS aiSs24Applied_88, t0.aiSs24Booked AS aiSs24Booked_89, t0.interestedIn AS interestedIn_90, t0.interests AS interests_91, t0.mentorMetadata AS mentorMetadata_92, t0.eventParticipations AS eventParticipations_93, t0.kiKompetenz AS kiKompetenz_94, t0.mentorOwnerId AS mentorOwnerId_95 FROM aaa_sp_members t0 WHERE t0.id = ?
Parameters: 
[
  "91699"
]
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.

Entities Mapping

Class Mapping errors
App\StartPlatz\Bundle\UserBundle\Entity\User No errors.
App\StartPlatz\Bundle\EventBundle\Entity\Event No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Program No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Member No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam No errors.