http://www.staging.startplatz.de/events?type=logistik

Query Metrics

14 Database Queries
10 Different statements
46.35 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.domain AS domain_4, t0.description AS description_5, t0.sqlSelect AS sqlSelect_6, t0.zapierWebhook AS zapierWebhook_7, t0.isFavorite AS isFavorite_8, t0.isModul AS isModul_9, t0.isThema AS isThema_10, t0.isEditableByUser AS isEditableByUser_11, t0.isUsedInWordPress AS isUsedInWordPress_12, t0.wpEntitiesCount AS wpEntitiesCount_13, t0.entitiesCount AS entitiesCount_14, t0.history AS history_15, t0.createdAt AS createdAt_16, t0.lastModified AS lastModified_17 FROM sp_tags t0 WHERE t0.domain = ? AND t0.isEditableByUser = ? ORDER BY t0.tag ASC
Parameters:
[
  "event"
  1
]
2 0.57 ms
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.domain AS domain_4, t0.description AS description_5, t0.sqlSelect AS sqlSelect_6, t0.zapierWebhook AS zapierWebhook_7, t0.isFavorite AS isFavorite_8, t0.isModul AS isModul_9, t0.isThema AS isThema_10, t0.isEditableByUser AS isEditableByUser_11, t0.isUsedInWordPress AS isUsedInWordPress_12, t0.wpEntitiesCount AS wpEntitiesCount_13, t0.entitiesCount AS entitiesCount_14, t0.history AS history_15, t0.createdAt AS createdAt_16, t0.lastModified AS lastModified_17 FROM sp_tags t0 WHERE t0.domain = ? AND t0.isUsedInWordPress = ? ORDER BY t0.tag ASC
Parameters:
[
  "event"
  1
]
3 25.85 ms
(
                SELECT
                    e.*,
                    NULL as nextBatchId,
                    NULL as nextBatchName,
                    e.startDate as nextBatchDate,
                    e.endDate as nextBatchEndDate,
                    COALESCE((SELECT b2.priceInEuroCent FROM sp_batches b2 WHERE b2.eventId = e.id ORDER BY b2.id DESC LIMIT 1), e.priceInEuroCent) as displayPrice,
                    e.isFreeForKICampus as displayFreeForKiCampus,
                    NULL as batchTopic,
                    NULL as batchImageLink,
                    NULL as batchPartnerDescription
                FROM sp_event_events e
                WHERE e.status = 'publish' AND e.type = :type
                AND e.isMultiBatchEvent = 0
                AND COALESCE(e.endDate, e.startDate) >= CURDATE()
            )
            UNION ALL
            (
                SELECT
                    e.*,
                    b.id as nextBatchId,
                    b.name as nextBatchName,
                    COALESCE(b.startDate, b.pitchDate) as nextBatchDate,
                    b.endDate as nextBatchEndDate,
                    b.priceInEuroCent as displayPrice,
                    b.isFreeForKiCampus as displayFreeForKiCampus,
                    COALESCE(NULLIF(b.landingPageTitle, ''), b.pitchTopic) as batchTopic,
                    COALESCE(NULLIF(b.landingPageSocialImage, ''), b.pitchImageLink) as batchImageLink,
                    b.pitchPartner as batchPartnerDescription
                FROM sp_event_events e
                INNER JOIN sp_batches b ON e.id = b.eventId
                WHERE e.status = 'publish' AND e.type = :type
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND COALESCE(b.startDate, b.pitchDate) >= CURDATE()
            )
            ORDER BY nextBatchDate ASC
            LIMIT :limit
Parameters:
[
  "type" => "logistik"
  "limit" => 900
]
4 0.37 ms
SELECT MONTH(e.startDate) as month, YEAR(e.startDate) as year, COUNT(MONTH(e.startDate)) as total
          FROM sp_event_events e
          WHERE e.startDate >  :lastDayOfNextMonth AND e.status = :criteria0 AND e.type = :criteria1 GROUP BY MONTH(e.startDate)
Parameters:
[
  ":lastDayOfNextMonth" => "2026-05-31"
  ":criteria0" => "publish"
  ":criteria1" => "logistik"
]
5 14.77 ms
(
                SELECT
                    e.*,
                    NULL as nextBatchId,
                    NULL as nextBatchName,
                    e.startDate as nextBatchDate,
                    e.endDate as nextBatchEndDate,
                    COALESCE((SELECT b2.priceInEuroCent FROM sp_batches b2 WHERE b2.eventId = e.id ORDER BY b2.id DESC LIMIT 1), e.priceInEuroCent) as displayPrice,
                    e.isFreeForKICampus as displayFreeForKiCampus,
                    NULL as batchTopic,
                    NULL as batchImageLink,
                    NULL as batchPartnerDescription
                FROM sp_event_events e
                WHERE e.status = 'publish' AND e.type = :type
                AND e.isMultiBatchEvent = 0
                AND COALESCE(e.endDate, e.startDate) < CURDATE()
            )
            UNION ALL
            (
                SELECT
                    e.*,
                    b.id as nextBatchId,
                    b.name as nextBatchName,
                    COALESCE(b.startDate, b.pitchDate) as nextBatchDate,
                    b.endDate as nextBatchEndDate,
                    b.priceInEuroCent as displayPrice,
                    b.isFreeForKiCampus as displayFreeForKiCampus,
                    COALESCE(NULLIF(b.landingPageTitle, ''), b.pitchTopic) as batchTopic,
                    COALESCE(NULLIF(b.landingPageSocialImage, ''), b.pitchImageLink) as batchImageLink,
                    b.pitchPartner as batchPartnerDescription
                FROM sp_event_events e
                INNER JOIN sp_batches b ON e.id = b.eventId
                WHERE e.status = 'publish' AND e.type = :type
                AND e.isMultiBatchEvent = 1
                AND b.status = 'active'
                AND COALESCE(b.endDate, b.startDate, b.pitchDate) < CURDATE()
            )
            ORDER BY nextBatchDate DESC
            LIMIT :limit
Parameters:
[
  "type" => "logistik"
  "limit" => 900
]
6 0.37 ms
SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = ?
Parameters:
[
  6250
]
7 0.29 ms
SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = ?
Parameters:
[
  6249
]
8 0.29 ms
SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = ?
Parameters:
[
  6247
]
9 0.28 ms
SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.id = ?
Parameters:
[
  6170
]
10 0.45 ms
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.domain AS domain_4, t0.description AS description_5, t0.sqlSelect AS sqlSelect_6, t0.zapierWebhook AS zapierWebhook_7, t0.isFavorite AS isFavorite_8, t0.isModul AS isModul_9, t0.isThema AS isThema_10, t0.isEditableByUser AS isEditableByUser_11, t0.isUsedInWordPress AS isUsedInWordPress_12, t0.wpEntitiesCount AS wpEntitiesCount_13, t0.entitiesCount AS entitiesCount_14, t0.history AS history_15, t0.createdAt AS createdAt_16, t0.lastModified AS lastModified_17 FROM sp_tags t0 WHERE t0.domain = ? AND t0.isThema = ? ORDER BY t0.tag ASC
Parameters:
[
  "event"
  1
]
11 0.34 ms
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.domain AS domain_4, t0.description AS description_5, t0.sqlSelect AS sqlSelect_6, t0.zapierWebhook AS zapierWebhook_7, t0.isFavorite AS isFavorite_8, t0.isModul AS isModul_9, t0.isThema AS isThema_10, t0.isEditableByUser AS isEditableByUser_11, t0.isUsedInWordPress AS isUsedInWordPress_12, t0.wpEntitiesCount AS wpEntitiesCount_13, t0.entitiesCount AS entitiesCount_14, t0.history AS history_15, t0.createdAt AS createdAt_16, t0.lastModified AS lastModified_17 FROM sp_tags t0 WHERE t0.domain = ? AND t0.isModul = ? ORDER BY t0.tag ASC
Parameters:
[
  "event"
  1
]
12 0.51 ms
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_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.status = 'publish' AND s0_.startDate >= ? AND s0_.type = ? ORDER BY s0_.startDate ASC LIMIT 1
Parameters:
[
  "2026-04-16"
  "Konferenz"
]
13 0.39 ms
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_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.status = 'publish' AND s0_.startDate >= ? AND s0_.type = ? ORDER BY s0_.startDate ASC LIMIT 1
Parameters:
[
  "2026-04-16"
  "Workshop"
]
14 1.26 ms
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_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.startDate >= ? AND s0_.status = 'publish' AND s0_.status = 'publish' ORDER BY s0_.startDate ASC LIMIT 100
Parameters:
[
  "2026-04-16"
]

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\MetaBundle\Entity\Tag No errors.
App\StartPlatz\Bundle\UserBundle\Entity\User No errors.
App\StartPlatz\Bundle\UserBundle\Entity\LoginToken No errors.
App\StartPlatz\Bundle\PartnersBundle\Entity\Partner No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team No errors.
App\StartPlatz\Ecosystem\Participation\Entity\Participation No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Application
  • The field 'App\StartPlatz\Bundle\StartupBundle\Entity\Application#ratingAverage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\StartPlatz\Bundle\StartupBundle\Entity\Application#assessments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment#application does not contain the required 'inversedBy="assessments"' attribute.
App\StartPlatz\Bundle\EventBundle\Entity\Event No errors.