http://www.staging.startplatz.de/fr/partenaires

Query Metrics

7 Database Queries
7 Different statements
3.66 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 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.email = ? LIMIT 1
Parameters:
[
  ""
]
2 0.29 ms
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.slug = ? LIMIT 1
Parameters:
[
  "partner"
]
3 0.66 ms
SELECT t0.id AS id_1, t0.attributeId AS attributeId_2, t0.name AS name_3, t0.level AS level_4, t0.code AS code_5, t0.parent AS parent_6, t0.label AS label_7, t0.description AS description_8, t0.note AS note_9, t0.createdAt AS createdAt_10, t0.lastModified AS lastModified_11, t0.history AS history_12, t0.lastChangeUser AS lastChangeUser_13 FROM aaa_sp_attributes t0 WHERE t0.name = ? AND t0.parent = ?
Parameters:
[
  "page.type"
  "partner"
]
4 0.74 ms
SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.type AS type_2, a0_.slug AS slug_3, a0_.title AS title_4, a0_.teaser AS teaser_5, a0_.partnerAdminRating AS partnerAdminRating_6, a0_.imagelink AS imagelink_7, a0_.website AS website_8, a0_.tags AS tags_9, a0_.feedTags AS feedTags_10, a0_.logoUrl AS logoUrl_11, a0_.publicId AS publicId_12, a0_.description AS description_13, a0_.relatedInformation AS relatedInformation_14, a0_.redeemPerk AS redeemPerk_15, a0_.targetGroup AS targetGroup_16, a0_.contactPartner AS contactPartner_17, a0_.contactPartnerMemberId AS contactPartnerMemberId_18, a0_.isActive AS isActive_19, a0_.status AS status_20, a0_.visibility AS visibility_21, a0_.teamId AS teamId_22, a0_.teamName AS teamName_23, a0_.titleEN AS titleEN_24, a0_.teaserEN AS teaserEN_25, a0_.descriptionEN AS descriptionEN_26, a0_.relatedInformationEN AS relatedInformationEN_27, a0_.redeemPerkEN AS redeemPerkEN_28, a0_.seoTitle AS seoTitle_29, a0_.seoKeyword AS seoKeyword_30, a0_.seoDescription AS seoDescription_31, a0_.history AS history_32, a0_.lastModified AS lastModified_33, a0_.lastChangeUser AS lastChangeUser_34, a0_.createdAt AS createdAt_35, a0_.additionalHead AS additionalHead_36 FROM aaa_sp_pages a0_ WHERE a0_.type IN (?) AND a0_.isActive = ? AND a0_.status = ? ORDER BY a0_.partnerAdminRating DESC, a0_.lastModified DESC LIMIT 128
Parameters:
[
  [
    "corporate-partner"
    "partner"
    "service-partner"
    "accelerator-venture-capital-partner"
    "accelerator-technology-partner"
    "accelerator-support-partner"
    "strategic-partner"
    "education-partner"
    "academic-partner"
    "web3-technology-partner"
    "web3-investment-partner"
    "collaborating-partner"
    "network-partner"
  ]
  1
  "publish"
]
5 0.25 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM aaa_sp_pages a0_ WHERE a0_.type IN (?) AND a0_.isActive = ? AND a0_.status = ?
Parameters:
[
  [
    "corporate-partner"
    "partner"
    "service-partner"
    "accelerator-venture-capital-partner"
    "accelerator-technology-partner"
    "accelerator-support-partner"
    "strategic-partner"
    "education-partner"
    "academic-partner"
    "web3-technology-partner"
    "web3-investment-partner"
    "collaborating-partner"
    "network-partner"
  ]
  1
  "publish"
]
6 0.62 ms
SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.type AS type_2, a0_.slug AS slug_3, a0_.title AS title_4, a0_.teaser AS teaser_5, a0_.partnerAdminRating AS partnerAdminRating_6, a0_.imagelink AS imagelink_7, a0_.website AS website_8, a0_.tags AS tags_9, a0_.feedTags AS feedTags_10, a0_.logoUrl AS logoUrl_11, a0_.publicId AS publicId_12, a0_.description AS description_13, a0_.relatedInformation AS relatedInformation_14, a0_.redeemPerk AS redeemPerk_15, a0_.targetGroup AS targetGroup_16, a0_.contactPartner AS contactPartner_17, a0_.contactPartnerMemberId AS contactPartnerMemberId_18, a0_.isActive AS isActive_19, a0_.status AS status_20, a0_.visibility AS visibility_21, a0_.teamId AS teamId_22, a0_.teamName AS teamName_23, a0_.titleEN AS titleEN_24, a0_.teaserEN AS teaserEN_25, a0_.descriptionEN AS descriptionEN_26, a0_.relatedInformationEN AS relatedInformationEN_27, a0_.redeemPerkEN AS redeemPerkEN_28, a0_.seoTitle AS seoTitle_29, a0_.seoKeyword AS seoKeyword_30, a0_.seoDescription AS seoDescription_31, a0_.history AS history_32, a0_.lastModified AS lastModified_33, a0_.lastChangeUser AS lastChangeUser_34, a0_.createdAt AS createdAt_35, a0_.additionalHead AS additionalHead_36 FROM aaa_sp_pages a0_ WHERE a0_.type IN (?) AND a0_.isActive = ? AND a0_.status = ?
Parameters:
[
  [
    "corporate-partner"
    "partner"
    "service-partner"
    "accelerator-venture-capital-partner"
    "accelerator-technology-partner"
    "accelerator-support-partner"
    "strategic-partner"
    "education-partner"
    "academic-partner"
    "web3-technology-partner"
    "web3-investment-partner"
    "collaborating-partner"
    "network-partner"
  ]
  1
  "publish"
]
7 0.58 ms
SELECT t0.id AS id_1, t0.attributeId AS attributeId_2, t0.name AS name_3, t0.level AS level_4, t0.code AS code_5, t0.parent AS parent_6, t0.label AS label_7, t0.description AS description_8, t0.note AS note_9, t0.createdAt AS createdAt_10, t0.lastModified AS lastModified_11, t0.history AS history_12, t0.lastChangeUser AS lastChangeUser_13 FROM aaa_sp_attributes t0 WHERE t0.name = ?
Parameters:
[
  "partner.tags"
]

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