Query Metrics
6
Database Queries
5
Different statements
9.56 ms
Query time
0
Invalid entities
1
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.53 ms |
SELECT t0.id AS id_1, t0.extId AS extId_2, t0.visibility AS visibility_3, t0.score AS score_4, t0.name AS name_5, t0.teamId AS teamId_6, t0.website AS website_7, t0.domain AS domain_8, t0.slug AS slug_9, t0.status AS status_10, t0.editStatus AS editStatus_11, t0.stage AS stage_12, t0.source AS source_13, t0.runway AS runway_14, t0.fundingSinceProgram AS fundingSinceProgram_15, t0.partnerTags AS partnerTags_16, t0.lastCheckDate AS lastCheckDate_17, t0.alumniStatus AS alumniStatus_18, t0.logoUrl AS logoUrl_19, t0.logoBackground AS logoBackground_20, t0.imageLink AS imageLink_21, t0.currentPitchDeckUrl AS currentPitchDeckUrl_22, t0.kiAccelerator AS kiAccelerator_23, t0.todos AS todos_24, t0.industry AS industry_25, t0.industryCondensed AS industryCondensed_26, t0.customerFocus AS customerFocus_27, t0.BusinessModel AS BusinessModel_28, t0.tags AS tags_29, t0.oneSentencePitch AS oneSentencePitch_30, t0.oneSentencePitchEn AS oneSentencePitchEn_31, t0.foundationYear AS foundationYear_32, t0.location AS location_33, t0.city AS city_34, t0.employeesCount AS employeesCount_35, t0.funding AS funding_36, t0.investors AS investors_37, t0.revenue AS revenue_38, t0.contactPerson AS contactPerson_39, t0.contactEmail AS contactEmail_40, t0.contactTelefon AS contactTelefon_41, t0.xing AS xing_42, t0.linkedin AS linkedin_43, t0.facebook AS facebook_44, t0.twitter AS twitter_45, t0.instagram AS instagram_46, t0.tiktok AS tiktok_47, t0.threads AS threads_48, t0.youtube AS youtube_49, t0.description AS description_50, t0.publicDetailHtml AS publicDetailHtml_51, t0.publicDetailHtmlEn AS publicDetailHtmlEn_52, t0.internalDetailHtml AS internalDetailHtml_53, t0.internalDetailHtmlEn AS internalDetailHtmlEn_54, t0.gsPublicSummary AS gsPublicSummary_55, t0.gsIndustries AS gsIndustries_56, t0.gsKeywords AS gsKeywords_57, t0.gsProfile AS gsProfile_58, t0.comments AS comments_59, t0.history AS history_60, t0.lastChangeUser AS lastChangeUser_61, t0.createdAt AS createdAt_62, t0.lastModified AS lastModified_63, t0.lastChangedBy AS lastChangedBy_64 FROM sp_startup_profiles t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3000888"
]
|
| 2 | 2.62 ms |
SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC
Parameters:
[
"%"mobideo"%"
]
|
| 3 | 3.04 ms |
SELECT s0_.startupName AS startupName_0, s0_.pitchPosition AS pitchPosition_1, s0_.programName AS programName_2, s0_.batchName AS batchName_3, s1_.pitchDate AS pitchDate_4, s1_.city AS city_5 FROM sp_applications s0_ INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id) WHERE s0_.startupId = ? AND s0_.programId = ?
Parameters:
[ "3000888" 1 ] |
| 4 | 0.35 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s1_.type AS type_2, s0_.email AS email_3 FROM sp_member_teams s1_ INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id) WHERE s1_.team_id = ?
Parameters:
[
"3000888"
]
|
| 5 | 2.58 ms |
SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE ? ORDER BY s0_.score DESC
Parameters:
[
"%"mobideo"%"
]
|
| 6 | 0.43 ms |
SELECT s0_.id AS id_0, s0_.startupId AS startupId_1, s0_.url AS url_2, s0_.title AS title_3, s0_.publishedAt AS publishedAt_4, s0_.isActive AS isActive_5, s0_.submittedBy AS submittedBy_6, s0_.createdAt AS createdAt_7 FROM sp_startup_news_links s0_ WHERE s0_.startupId = ? AND s0_.isActive = 1 ORDER BY s0_.publishedAt DESC, s0_.createdAt DESC
Parameters:
[
3000888
]
|
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\StartupBundle\Entity\Startup | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\StartPlatz\Bundle\UserBundle\Entity\User | No errors. |
| App\StartPlatz\Bundle\MemberBundle\Entity\Team | No errors. |
| App\StartPlatz\Bundle\StartupBundle\Entity\Startup | No errors. |
| App\StartPlatz\Bundle\AlphaBundle\Entity\Feed | No errors. |
| App\StartPlatz\Bundle\StartupBundle\Entity\Application | No errors. |
| App\StartPlatz\Bundle\StartupBundle\Entity\Batch | No errors. |
| App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam | No errors. |
| App\StartPlatz\Bundle\MemberBundle\Entity\Member | No errors. |
| App\StartPlatz\Bundle\StartupBundle\Entity\StartupNewsLink | No errors. |
| App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment | No errors. |
| App\StartPlatz\Bundle\StartupBundle\Entity\Program | No errors. |