Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

13.07 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.82 ms
(82.79%)

SELECT e0_.id AS id_0, e0_.thumbnail AS thumbnail_1, e0_.hero_image AS hero_image_2, e0_.og_image AS og_image_3, e0_.slug AS slug_4, e0_.title AS title_5, e0_.description AS description_6, e0_.location AS location_7, e0_.country AS country_8, e0_.datetime AS datetime_9, e0_.admission AS admission_10, e0_.is_featured AS is_featured_11, e0_.programme AS programme_12, e0_.key_topics AS key_topics_13, e0_.who_should_attend AS who_should_attend_14, e0_.language AS language_15, e0_.cta AS cta_16, e0_.seo_title AS seo_title_17, e0_.meta_description AS meta_description_18, e0_.external_speakers AS external_speakers_19, e0_.status AS status_20, e0_.created_at AS created_at_21, e0_.updated_at AS updated_at_22, e0_.organizer_id AS organizer_id_23, e0_.created_by_id AS created_by_id_24, e0_.updated_by_id AS updated_by_id_25 FROM event e0_ LEFT JOIN partner p1_ ON e0_.organizer_id = p1_.id LEFT JOIN event_partner e3_ ON e0_.id = e3_.event_id LEFT JOIN partner p2_ ON p2_.id = e3_.partner_id WHERE e0_.status = ? AND (p1_.slug = ? OR p2_.slug = ?) AND e0_.datetime >= ? GROUP BY e0_.id ORDER BY e0_.datetime ASC LIMIT 3

Parameters:

[
  "published"
  "andrei-movchan"
  "andrei-movchan"
  "2026-07-14 13:11:06"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.thumbnail AS thumbnail_1,
  e0_.hero_image AS hero_image_2,
  e0_.og_image AS og_image_3,
  e0_.slug AS slug_4,
  e0_.title AS title_5,
  e0_.description AS description_6,
  e0_.location AS location_7,
  e0_.country AS country_8,
  e0_.datetime AS datetime_9,
  e0_.admission AS admission_10,
  e0_.is_featured AS is_featured_11,
  e0_.programme AS programme_12,
  e0_.key_topics AS key_topics_13,
  e0_.who_should_attend AS who_should_attend_14,
  e0_.language AS language_15,
  e0_.cta AS cta_16,
  e0_.seo_title AS seo_title_17,
  e0_.meta_description AS meta_description_18,
  e0_.external_speakers AS external_speakers_19,
  e0_.status AS status_20,
  e0_.created_at AS created_at_21,
  e0_.updated_at AS updated_at_22,
  e0_.organizer_id AS organizer_id_23,
  e0_.created_by_id AS created_by_id_24,
  e0_.updated_by_id AS updated_by_id_25
FROM
  event e0_
  LEFT JOIN partner p1_ ON e0_.organizer_id = p1_.id
  LEFT JOIN event_partner e3_ ON e0_.id = e3_.event_id
  LEFT JOIN partner p2_ ON p2_.id = e3_.partner_id
WHERE
  e0_.status = ?
  AND (
    p1_.slug = ?
    OR p2_.slug = ?
  )
  AND e0_.datetime >= ?
GROUP BY
  e0_.id
ORDER BY
  e0_.datetime ASC
LIMIT
  3

SELECT e0_.id AS id_0, e0_.thumbnail AS thumbnail_1, e0_.hero_image AS hero_image_2, e0_.og_image AS og_image_3, e0_.slug AS slug_4, e0_.title AS title_5, e0_.description AS description_6, e0_.location AS location_7, e0_.country AS country_8, e0_.datetime AS datetime_9, e0_.admission AS admission_10, e0_.is_featured AS is_featured_11, e0_.programme AS programme_12, e0_.key_topics AS key_topics_13, e0_.who_should_attend AS who_should_attend_14, e0_.language AS language_15, e0_.cta AS cta_16, e0_.seo_title AS seo_title_17, e0_.meta_description AS meta_description_18, e0_.external_speakers AS external_speakers_19, e0_.status AS status_20, e0_.created_at AS created_at_21, e0_.updated_at AS updated_at_22, e0_.organizer_id AS organizer_id_23, e0_.created_by_id AS created_by_id_24, e0_.updated_by_id AS updated_by_id_25 FROM event e0_ LEFT JOIN partner p1_ ON e0_.organizer_id = p1_.id LEFT JOIN event_partner e3_ ON e0_.id = e3_.event_id LEFT JOIN partner p2_ ON p2_.id = e3_.partner_id WHERE e0_.status = 'published' AND (p1_.slug = 'andrei-movchan' OR p2_.slug = 'andrei-movchan') AND e0_.datetime >= '2026-07-14 13:11:06' GROUP BY e0_.id ORDER BY e0_.datetime ASC LIMIT 3;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Event\EventRepository->findForApi (line 107)
7	App\Controller\Api\EventController->index (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 7)

1.42 ms
(10.86%)

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 INNER JOIN event_partner ON t0.id = event_partner.partner_id WHERE event_partner.event_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.avatar AS avatar_2,
  t0.og_image AS og_image_3,
  t0.slug AS slug_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.full_name AS full_name_7,
  t0.position AS position_8,
  t0.about AS about_9,
  t0.languages AS languages_10,
  t0.categories AS categories_11,
  t0.status AS status_12,
  t0.profile_img AS profile_img_13,
  t0.country AS country_14,
  t0.type AS type_15,
  t0.socials_linkedin AS socials_linkedin_16,
  t0.socials_facebook AS socials_facebook_17,
  t0.socials_telegram AS socials_telegram_18,
  t0.socials_youtube AS socials_youtube_19,
  t0.socials_website AS socials_website_20,
  t0.socials_instagram AS socials_instagram_21,
  t0.company_name AS company_name_22,
  t0.company_category AS company_category_23,
  t0.company_industry AS company_industry_24,
  t0.company_headquarters AS company_headquarters_25,
  t0.company_website AS company_website_26,
  t0.company_countries AS company_countries_27,
  t0.company_description AS company_description_28,
  t0.company_logo AS company_logo_29,
  t0.expertise AS expertise_30,
  t0.is_featured AS is_featured_31,
  t0.sort_order AS sort_order_32,
  t0.seo_title AS seo_title_33,
  t0.meta_description AS meta_description_34,
  t0.charter_accepted AS charter_accepted_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.user_id AS user_id_38,
  t0.created_by_id AS created_by_id_39,
  t0.updated_by_id AS updated_by_id_40
FROM
  partner t0
  INNER JOIN event_partner ON t0.id = event_partner.partner_id
WHERE
  event_partner.event_id = ?

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 INNER JOIN event_partner ON t0.id = event_partner.partner_id WHERE event_partner.event_id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	App\Entity\Event->getSpeakers (line 162)
8	App\Controller\Api\EventController->serializeEvent (line 84)
9	App\Controller\Api\EventController->{closure:App\Controller\Api\EventController::index():40} (line 40)
10	array_map (line 40)
11	App\Controller\Api\EventController::index (line 40)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 191)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 7)

0.83 ms
(6.35%)

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.avatar AS avatar_2,
  t0.og_image AS og_image_3,
  t0.slug AS slug_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.full_name AS full_name_7,
  t0.position AS position_8,
  t0.about AS about_9,
  t0.languages AS languages_10,
  t0.categories AS categories_11,
  t0.status AS status_12,
  t0.profile_img AS profile_img_13,
  t0.country AS country_14,
  t0.type AS type_15,
  t0.socials_linkedin AS socials_linkedin_16,
  t0.socials_facebook AS socials_facebook_17,
  t0.socials_telegram AS socials_telegram_18,
  t0.socials_youtube AS socials_youtube_19,
  t0.socials_website AS socials_website_20,
  t0.socials_instagram AS socials_instagram_21,
  t0.company_name AS company_name_22,
  t0.company_category AS company_category_23,
  t0.company_industry AS company_industry_24,
  t0.company_headquarters AS company_headquarters_25,
  t0.company_website AS company_website_26,
  t0.company_countries AS company_countries_27,
  t0.company_description AS company_description_28,
  t0.company_logo AS company_logo_29,
  t0.expertise AS expertise_30,
  t0.is_featured AS is_featured_31,
  t0.sort_order AS sort_order_32,
  t0.seo_title AS seo_title_33,
  t0.meta_description AS meta_description_34,
  t0.charter_accepted AS charter_accepted_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.user_id AS user_id_38,
  t0.created_by_id AS created_by_id_39,
  t0.updated_by_id AS updated_by_id_40
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.og_image AS og_image_3, t0.slug AS slug_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.full_name AS full_name_7, t0.position AS position_8, t0.about AS about_9, t0.languages AS languages_10, t0.categories AS categories_11, t0.status AS status_12, t0.profile_img AS profile_img_13, t0.country AS country_14, t0.type AS type_15, t0.socials_linkedin AS socials_linkedin_16, t0.socials_facebook AS socials_facebook_17, t0.socials_telegram AS socials_telegram_18, t0.socials_youtube AS socials_youtube_19, t0.socials_website AS socials_website_20, t0.socials_instagram AS socials_instagram_21, t0.company_name AS company_name_22, t0.company_category AS company_category_23, t0.company_industry AS company_industry_24, t0.company_headquarters AS company_headquarters_25, t0.company_website AS company_website_26, t0.company_countries AS company_countries_27, t0.company_description AS company_description_28, t0.company_logo AS company_logo_29, t0.expertise AS expertise_30, t0.is_featured AS is_featured_31, t0.sort_order AS sort_order_32, t0.seo_title AS seo_title_33, t0.meta_description AS meta_description_34, t0.charter_accepted AS charter_accepted_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.user_id AS user_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM partner t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Controller\Api\EventController::serializePartner (line 98)
5	App\Controller\Api\EventController::serializeEvent (line 83)
6	App\Controller\Api\EventController->{closure:App\Controller\Api\EventController::index():40} (line 40)
7	array_map (line 40)
8	App\Controller\Api\EventController::index (line 40)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 7)

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\Entity\Partner	3
App\Entity\User	3
App\Entity\Event	1

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\Partner	No errors.
App\Entity\User	No errors.
App\Entity\Tag	No errors.

Symfony Profiler

GET https://cp.movchansalliance.com/api/events?limit=3&partnerSlug=andrei-movchan&upcoming=true

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping