http://www.staging.startplatz.de/event/genai-ki-fuer-logistik-lager-supply-chain/?tag=ki-fuer-logistik

Query Metrics

8 Database Queries
6 Different statements
9.04 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.01 ms
(77.58%)
2
SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasFollowUp AS hasFollowUp_24, t0.isNetworking AS isNetworking_25, t0.networkingRounds AS networkingRounds_26, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28, t0.isFutureEvent AS isFutureEvent_29, t0.visibility AS visibility_30, t0.access AS access_31, t0.tags AS tags_32, t0.typeformLink AS typeformLink_33, t0.zoomLink AS zoomLink_34, t0.bgImageUrl AS bgImageUrl_35, t0.startDate AS startDate_36, t0.endDate AS endDate_37, t0.stripePriceId AS stripePriceId_38, t0.stripeProductId AS stripeProductId_39, t0.stripeAccount AS stripeAccount_40, t0.isFreeForKiCampus AS isFreeForKiCampus_41, t0.isFreeForCommunity AS isFreeForCommunity_42, t0.mailDesignTemplate AS mailDesignTemplate_43, t0.senderMail AS senderMail_44, t0.fromName AS fromName_45, t0.recipientMonitoringMail AS recipientMonitoringMail_46, t0.confirmationMailSubject AS confirmationMailSubject_47, t0.confirmationMailContent AS confirmationMailContent_48, t0.adminNotificationMailSubject AS adminNotificationMailSubject_49, t0.adminNotificationMailContent AS adminNotificationMailContent_50, t0.reminderMailTemplateId AS reminderMailTemplateId_51, t0.reminderSenderEmail AS reminderSenderEmail_52, t0.reminderBulkMailId AS reminderBulkMailId_53, t0.reminderMailSendDate AS reminderMailSendDate_54, t0.reminderMailSubject AS reminderMailSubject_55, t0.reminderMailContent AS reminderMailContent_56, t0.$reminderMailStatus AS reminderMailStatus_57, t0.surveyId AS surveyId_58, t0.surveyMailTemplateId AS surveyMailTemplateId_59, t0.surveyBulkMailId AS surveyBulkMailId_60, t0.template AS template_61, t0.pageTemplate AS pageTemplate_62, t0.footerTemplate AS footerTemplate_63, t0.email AS email_64, t0.emailSubject AS emailSubject_65, t0.emailContent AS emailContent_66, t0.landingPageContent AS landingPageContent_67, t0.landingPageDescription AS landingPageDescription_68, t0.landingPageCss AS landingPageCss_69, t0.landingPageJs AS landingPageJs_70, t0.landingPageFooterTemplate AS landingPageFooterTemplate_71, t0.landingPageSocialImage AS landingPageSocialImage_72, t0.landingPageTitle AS landingPageTitle_73, t0.landingPageTwig AS landingPageTwig_74, t0.goToPage AS goToPage_75, t0.phrasesDe AS phrasesDe_76, t0.phrasesEn AS phrasesEn_77, t0.settings AS settings_78, t0.asssesmentDimensions AS asssesmentDimensions_79, t0.start AS start_80, t0.end AS end_81, t0.pitchTopic AS pitchTopic_82, t0.pitchImageLink AS pitchImageLink_83, t0.pitchVideoLink AS pitchVideoLink_84, t0.pitchPartner AS pitchPartner_85, t0.pitchPartnerId AS pitchPartnerId_86, t0.pitchDescription AS pitchDescription_87, t0.followUpPageContent AS followUpPageContent_88, t0.followUpPageDescription AS followUpPageDescription_89, t0.followUpPageCss AS followUpPageCss_90, t0.followUpPageJs AS followUpPageJs_91, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_92, t0.followUpPageTitle AS followUpPageTitle_93, t0.followUpPageSocialImage AS followUpPageSocialImage_94, t0.followUpDescription AS followUpDescription_95, t0.followUpVideoLink AS followUpVideoLink_96, t0.followUpPresentation AS followUpPresentation_97, t0.pitchDate AS pitchDate_98, t0.pitchTime AS pitchTime_99, t0.prepitchDate AS prepitchDate_100, t0.city AS city_101, t0.applicationsCount AS applicationsCount_102, t0.startedCount AS startedCount_103, t0.appliedCount AS appliedCount_104, t0.approvedCount AS approvedCount_105, t0.rejectedCount AS rejectedCount_106, t0.$skoolWebhook AS skoolWebhook_107, t0.zapierWebhook AS zapierWebhook_108, t0.history AS history_109, t0.createdAt AS createdAt_110, t0.lastModified AS lastModified_111, t0.lastChangeUser AS lastChangeUser_112, t0.program_id AS program_id_113, t0.assessmentTeamId AS assessmentTeamId_114 FROM sp_batches t0 WHERE t0.programId = ? AND t0.eventId = ? AND t0.status = ? AND t0.access = ? LIMIT 1
Parameters:
[
  27
  6250
  "active"
  "anonymous"
]
0.79 ms
(8.78%)
2
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.hubspotSyncPending AS hubspotSyncPending_66, t0.enterDate AS enterDate_67, t0.exitDate AS exitDate_68, t0.physicalMembershipStarted AS physicalMembershipStarted_69, t0.physicalMembershipEnded AS physicalMembershipEnded_70, t0.lastModified AS lastModified_71, t0.lastChangeUser AS lastChangeUser_72, t0.nAiWebinarsAttended AS nAiWebinarsAttended_73, t0.nAiWebinarsApplied AS nAiWebinarsApplied_74, t0.nAiEventsAttended AS nAiEventsAttended_75, t0.nAiEventsApplied AS nAiEventsApplied_76, t0.nPaidAttended AS nPaidAttended_77, t0.nPaidApplied AS nPaidApplied_78, t0.nKiEinstiegAttended AS nKiEinstiegAttended_79, t0.nKiEinstiegApplied AS nKiEinstiegApplied_80, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_81, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_82, t0.nEcodynamicsAttended AS nEcodynamicsAttended_83, t0.nEcodynamicsApplied AS nEcodynamicsApplied_84, t0.nBbqApplied AS nBbqApplied_85, t0.nAiFridayApplied AS nAiFridayApplied_86, t0.nAiGatheringApplied AS nAiGatheringApplied_87, t0.nAiGatheringAttended AS nAiGatheringAttended_88, t0.aiSs24Applied AS aiSs24Applied_89, t0.aiSs24Booked AS aiSs24Booked_90, t0.interestedIn AS interestedIn_91, t0.interests AS interests_92, t0.mentorMetadata AS mentorMetadata_93, t0.eventParticipations AS eventParticipations_94, t0.kiKompetenz AS kiKompetenz_95, t0.mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0.id = ?
Parameters:
[
  "97568"
]
0.50 ms
(5.48%)
1
SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.wpPostId AS wpPostId_3, t0.title AS title_4, t0.slug AS slug_5, t0.lang AS lang_6, t0.imagelink AS imagelink_7, t0.videolink AS videolink_8, t0.bgImagelink AS bgImagelink_9, t0.tagline AS tagline_10, t0.headerTextColor AS headerTextColor_11, t0.spResponsiblePerson AS spResponsiblePerson_12, t0.organization AS organization_13, t0.organizerName AS organizerName_14, t0.organizerEmail AS organizerEmail_15, t0.venueName AS venueName_16, t0.venueAddress AS venueAddress_17, t0.ticketing AS ticketing_18, t0.applicationUrl AS applicationUrl_19, t0.alert AS alert_20, t0.trainer AS trainer_21, t0.speakers AS speakers_22, t0.teaser AS teaser_23, t0.navbar AS navbar_24, t0.stripePriceId AS stripePriceId_25, t0.stripeProductId AS stripeProductId_26, t0.stripeAccount AS stripeAccount_27, t0.priceInEuroCent AS priceInEuroCent_28, t0.isTaxIncluded AS isTaxIncluded_29, t0.isFreeForKiCampus AS isFreeForKiCampus_30, t0.isFreeForCommunity AS isFreeForCommunity_31, t0.isSinglePage AS isSinglePage_32, t0.isFormalLanguage AS isFormalLanguage_33, t0.isMultiBatchEvent AS isMultiBatchEvent_34, t0.twigFile AS twigFile_35, t0.additionalCss AS additionalCss_36, t0.content AS content_37, t0.contentTwig AS contentTwig_38, t0.ctaContent AS ctaContent_39, t0.postCtaContent AS postCtaContent_40, t0.tags AS tags_41, t0.seriesTag AS seriesTag_42, t0.type AS type_43, t0.location AS location_44, t0.startDate AS startDate_45, t0.endDate AS endDate_46, t0.duration AS duration_47, t0.status AS status_48, t0.settings AS settings_49, t0.displayStartDate AS displayStartDate_50, t0.seoTitle AS seoTitle_51, t0.seoKeyword AS seoKeyword_52, t0.seoDescription AS seoDescription_53, t0.navbar_en AS navbar_en_54, t0.teaser_en AS teaser_en_55, t0.content_en AS content_en_56, t0.content_twig_en AS content_twig_en_57, t0.post_cta_content_en AS post_cta_content_en_58, t0.seo_title_en AS seo_title_en_59, t0.seo_description_en AS seo_description_en_60, t0.seo_keyword_en AS seo_keyword_en_61, t0.has_english_version AS has_english_version_62, t0.additional_js AS additional_js_63, t0.metaPixelId AS metaPixelId_64, t0.createDate AS createDate_65, t0.lastChangeDate AS lastChangeDate_66, t0.lastChangeUser AS lastChangeUser_67, t0.publicId AS publicId_68, t0.isExternalSubmission AS isExternalSubmission_69, t0.createdBy AS createdBy_70, t0.lastModified AS lastModified_71, t0.createdAt AS createdAt_72, t0.orgaNote AS orgaNote_73, t0.history AS history_74, t0.todoHistory AS todoHistory_75 FROM sp_event_events t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "genai-ki-fuer-logistik-lager-supply-chain"
]
0.31 ms
(3.48%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isNetworking AS isNetworking_20, t0.networkingRounds AS networkingRounds_21, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_22, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_23, t0.eventId AS eventId_24, t0.zoomLink AS zoomLink_25, t0.typeformLink AS typeformLink_26, t0.mailTemplate AS mailTemplate_27, t0.mailSubject AS mailSubject_28, t0.reminderMailTemplateId AS reminderMailTemplateId_29, t0.reminderSenderEmail AS reminderSenderEmail_30, t0.phrasesDe AS phrasesDe_31, t0.phrasesEn AS phrasesEn_32, t0.settings AS settings_33, t0.createdAt AS createdAt_34, t0.lastModified AS lastModified_35, t0.lastChangeUser AS lastChangeUser_36 FROM sp_programs t0 WHERE t0.id = ?
Parameters:
[
  27
]
0.21 ms
(2.38%)
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, t0.publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0.id = ?
Parameters:
[
  "1210"
]
0.21 ms
(2.30%)
1
SELECT t0.id AS id_1, t0.metaname AS metaname_2, t0.label AS label_3, t0.metavalue AS metavalue_4, t0.lastModified AS lastModified_5 FROM sp_member_options t0 WHERE t0.metaname = ? LIMIT 1
Parameters:
[
  "sp.phrases.application.de"
]

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