http://www.staging.startplatz.de/event-series/STARTPLATZ%20TikTok%20Wochen

Query Metrics

8 Database Queries
6 Different statements
73.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
40.58 ms
(55.11%)
2
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:
[
  "STARTPLATZ TikTok Wochen"
  "publish"
]
28.77 ms
(39.07%)
2
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:
[
  "STARTPLATZ TikTok Wochen"
  5901
  "publish"
]
1.72 ms
(2.33%)
1
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" => "STARTPLATZ TikTok Wochen"
]
1.69 ms
(2.30%)
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, 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" => "STARTPLATZ TikTok Wochen"
]
0.52 ms
(0.71%)
1
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:
[
  "92518"
]
0.35 ms
(0.48%)
1
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37 FROM aaa_sp_pages t0 WHERE t0.id = ?
Parameters:
[
  "1180"
]

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\AlphaBundle\Entity\Page No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Member No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam No errors.