Query Metrics
7
Database Queries
7
Different statements
4.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.98 ms (21.23%) |
1 |
SELECT s0_.id AS id_0, s0_.category AS category_1, s0_.type AS type_2, s0_.slug AS slug_3, s0_.title AS title_4, s0_.teaser AS teaser_5, s0_.partnerAdminRating AS partnerAdminRating_6, s0_.imagelink AS imagelink_7, s0_.website AS website_8, s0_.tags AS tags_9, s0_.feedTags AS feedTags_10, s0_.logoUrl AS logoUrl_11, s0_.publicId AS publicId_12, s0_.description AS description_13, s0_.relatedInformation AS relatedInformation_14, s0_.redeemPerk AS redeemPerk_15, s0_.targetGroup AS targetGroup_16, s0_.contactPartner AS contactPartner_17, s0_.contactPartnerMemberId AS contactPartnerMemberId_18, s0_.isActive AS isActive_19, s0_.status AS status_20, s0_.visibility AS visibility_21, s0_.teamId AS teamId_22, s0_.teamName AS teamName_23, s0_.titleEN AS titleEN_24, s0_.teaserEN AS teaserEN_25, s0_.descriptionEN AS descriptionEN_26, s0_.relatedInformationEN AS relatedInformationEN_27, s0_.redeemPerkEN AS redeemPerkEN_28, s0_.seoTitle AS seoTitle_29, s0_.seoKeyword AS seoKeyword_30, s0_.seoDescription AS seoDescription_31, s0_.history AS history_32, s0_.lastModified AS lastModified_33, s0_.lastChangeUser AS lastChangeUser_34, s0_.createdAt AS createdAt_35, s0_.additionalHead AS additionalHead_36, s0_.publicCategory AS publicCategory_37 FROM sp_content_pages s0_ WHERE s0_.type IN (?) AND s0_.isActive = ? AND s0_.status = ? ORDER BY s0_.partnerAdminRating DESC, s0_.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"
]
|
|
0.97 ms (21.14%) |
1 |
SELECT s0_.id AS id_0, s0_.category AS category_1, s0_.type AS type_2, s0_.slug AS slug_3, s0_.title AS title_4, s0_.teaser AS teaser_5, s0_.partnerAdminRating AS partnerAdminRating_6, s0_.imagelink AS imagelink_7, s0_.website AS website_8, s0_.tags AS tags_9, s0_.feedTags AS feedTags_10, s0_.logoUrl AS logoUrl_11, s0_.publicId AS publicId_12, s0_.description AS description_13, s0_.relatedInformation AS relatedInformation_14, s0_.redeemPerk AS redeemPerk_15, s0_.targetGroup AS targetGroup_16, s0_.contactPartner AS contactPartner_17, s0_.contactPartnerMemberId AS contactPartnerMemberId_18, s0_.isActive AS isActive_19, s0_.status AS status_20, s0_.visibility AS visibility_21, s0_.teamId AS teamId_22, s0_.teamName AS teamName_23, s0_.titleEN AS titleEN_24, s0_.teaserEN AS teaserEN_25, s0_.descriptionEN AS descriptionEN_26, s0_.relatedInformationEN AS relatedInformationEN_27, s0_.redeemPerkEN AS redeemPerkEN_28, s0_.seoTitle AS seoTitle_29, s0_.seoKeyword AS seoKeyword_30, s0_.seoDescription AS seoDescription_31, s0_.history AS history_32, s0_.lastModified AS lastModified_33, s0_.lastChangeUser AS lastChangeUser_34, s0_.createdAt AS createdAt_35, s0_.additionalHead AS additionalHead_36, s0_.publicCategory AS publicCategory_37 FROM sp_content_pages s0_ WHERE s0_.type IN (?) AND s0_.isActive = ? AND s0_.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"
]
|
|
0.74 ms (15.96%) |
1 |
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 sp_setting_attributes t0 WHERE t0.name = ?
Parameters:
[
"partner.tags"
]
|
|
0.68 ms (14.74%) |
1 |
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 sp_setting_attributes t0 WHERE t0.name = ? AND t0.parent = ?
Parameters:
[ "page.type" "partner" ] |
|
0.58 ms (12.66%) |
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.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.email = ? LIMIT 1
Parameters:
[ "" ] |
|
0.37 ms (8.01%) |
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.slug = ? LIMIT 1
Parameters:
[
"partner"
]
|
|
0.29 ms (6.25%) |
1 |
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_content_pages s0_ WHERE s0_.type IN (?) AND s0_.isActive = ? AND s0_.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"
]
|
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\MemberBundle\Entity\Member | No errors. |
| App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam | No errors. |
| App\StartPlatz\Bundle\AlphaBundle\Entity\Page | No errors. |
| App\StartPlatz\Bundle\MetaBundle\Entity\Attribute | No errors. |