GET https://www.staging.startplatz.de/event-series/startup-breakfast-koeln

Response
200 OK
IP
216.73.216.87
Profiled on
Token
7cdd24

Query Metrics

5 Database Queries
4 Different statements
65.68 ms Query time
0 Invalid entities
39 Managed entities

Queries

Group similar statements

#▲ Time Info
1 21.31 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_.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: 
[
  "startup-breakfast-koeln"
  "publish"
]
View formatted query    View runnable query    Explain query
2 20.77 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_.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: 
[
  "startup-breakfast-koeln"
  6995
  "publish"
]
View formatted query    View runnable query    Explain query
3 20.89 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_.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: 
[
  "startup-breakfast-koeln"
  6995
  "publish"
]
View formatted query    View runnable query    Explain query
4 1.92 ms 
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: 
[
  "startup-breakfast-koeln"
]
View formatted query    View runnable query    Explain query
5 0.79 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) 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: 
[
  "startup-breakfast-koeln"
]
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 39

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.