Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

4.85 ms Query time

0 Invalid entities

15 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.80 ms
(37.15%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.email_verification_token AS email_verification_token_6, t0.email_verification_token_expires_at AS email_verification_token_expires_at_7, t0.totp_secret AS totp_secret_8, t0.totp_verified AS totp_verified_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.created_at AS created_at_12, t0.terms_and_conditions_at AS terms_and_conditions_at_13, t0.reminder_unsubscribed AS reminder_unsubscribed_14, t0.deleted AS deleted_15, t0.deleted_at AS deleted_at_16, t0.company_id AS company_id_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  b"\x01žDËéŽp§ "á,,ù÷í"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.email_verification_token AS email_verification_token_6,
  t0.email_verification_token_expires_at AS email_verification_token_expires_at_7,
  t0.totp_secret AS totp_secret_8,
  t0.totp_verified AS totp_verified_9,
  t0.first_name AS first_name_10,
  t0.last_name AS last_name_11,
  t0.created_at AS created_at_12,
  t0.terms_and_conditions_at AS terms_and_conditions_at_13,
  t0.reminder_unsubscribed AS reminder_unsubscribed_14,
  t0.deleted AS deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.company_id AS company_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.email_verification_token AS email_verification_token_6, t0.email_verification_token_expires_at AS email_verification_token_expires_at_7, t0.totp_secret AS totp_secret_8, t0.totp_verified AS totp_verified_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.created_at AS created_at_12, t0.terms_and_conditions_at AS terms_and_conditions_at_13, t0.reminder_unsubscribed AS reminder_unsubscribed_14, t0.deleted AS deleted_15, t0.deleted_at AS deleted_at_16, t0.company_id AS company_id_17 FROM user t0 WHERE t0.id = 0x019E44CBE98D70A7A022E12C2CF9F7ED;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

1.42 ms
(29.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "CREATE_COMPANY"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_COMPANY' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\AcademyOnboardingAllowlist->resolvePendingActionNames (line 160)
5	App\Service\AcademyOnboardingAllowlist->hasPendingOnboardingActions (line 140)
6	App\EventSubscriber\AcademyOnboardingGuardSubscriber->onKernelRequest (line 68)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.07 ms
(22.10%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.street AS street_4, t0.zip AS zip_5, t0.city AS city_6, t0.vat_number AS vat_number_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.is_visible AS is_visible_12, t0.onboarding_completed AS onboarding_completed_13, t0.stripe_customer_id AS stripe_customer_id_14, t0.stripe_subscription_id AS stripe_subscription_id_15, t0.average_rating AS average_rating_16, t0.review_count AS review_count_17, t0.additional_discount AS additional_discount_18, t0.country_id AS country_id_19, t0.edu_package_id AS edu_package_id_20, t21.id AS id_22, t21.slogan AS slogan_23, t21.short_description AS short_description_24, t21.long_description AS long_description_25, t21.website AS website_26, t21.facebook_link AS facebook_link_27, t21.instagram_link AS instagram_link_28, t21.linkedin_link AS linkedin_link_29, t21.vimeo_video_id AS vimeo_video_id_30, t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31, t21.created_at AS created_at_32, t21.updated_at AS updated_at_33, t21.company_id AS company_id_34, t21.logo_image_id AS logo_image_id_35, t21.main_image_id AS main_image_id_36 FROM company t0 LEFT JOIN company_detail t21 ON t21.company_id = t0.id WHERE t0.id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.street AS street_4,
  t0.zip AS zip_5,
  t0.city AS city_6,
  t0.vat_number AS vat_number_7,
  t0.email AS email_8,
  t0.telephone AS telephone_9,
  t0.longitude AS longitude_10,
  t0.latitude AS latitude_11,
  t0.is_visible AS is_visible_12,
  t0.onboarding_completed AS onboarding_completed_13,
  t0.stripe_customer_id AS stripe_customer_id_14,
  t0.stripe_subscription_id AS stripe_subscription_id_15,
  t0.average_rating AS average_rating_16,
  t0.review_count AS review_count_17,
  t0.additional_discount AS additional_discount_18,
  t0.country_id AS country_id_19,
  t0.edu_package_id AS edu_package_id_20,
  t21.id AS id_22,
  t21.slogan AS slogan_23,
  t21.short_description AS short_description_24,
  t21.long_description AS long_description_25,
  t21.website AS website_26,
  t21.facebook_link AS facebook_link_27,
  t21.instagram_link AS instagram_link_28,
  t21.linkedin_link AS linkedin_link_29,
  t21.vimeo_video_id AS vimeo_video_id_30,
  t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31,
  t21.created_at AS created_at_32,
  t21.updated_at AS updated_at_33,
  t21.company_id AS company_id_34,
  t21.logo_image_id AS logo_image_id_35,
  t21.main_image_id AS main_image_id_36
FROM
  company t0
  LEFT JOIN company_detail t21 ON t21.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.street AS street_4, t0.zip AS zip_5, t0.city AS city_6, t0.vat_number AS vat_number_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.is_visible AS is_visible_12, t0.onboarding_completed AS onboarding_completed_13, t0.stripe_customer_id AS stripe_customer_id_14, t0.stripe_subscription_id AS stripe_subscription_id_15, t0.average_rating AS average_rating_16, t0.review_count AS review_count_17, t0.additional_discount AS additional_discount_18, t0.country_id AS country_id_19, t0.edu_package_id AS edu_package_id_20, t21.id AS id_22, t21.slogan AS slogan_23, t21.short_description AS short_description_24, t21.long_description AS long_description_25, t21.website AS website_26, t21.facebook_link AS facebook_link_27, t21.instagram_link AS instagram_link_28, t21.linkedin_link AS linkedin_link_29, t21.vimeo_video_id AS vimeo_video_id_30, t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31, t21.created_at AS created_at_32, t21.updated_at AS updated_at_33, t21.company_id AS company_id_34, t21.logo_image_id AS logo_image_id_35, t21.main_image_id AS main_image_id_36 FROM company t0 LEFT JOIN company_detail t21 ON t21.company_id = t0.id WHERE t0.id = 28;

#	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\Entity\Company::isOnboardingCompleted (line 226)
5	App\Service\AcademyOnboardingAllowlist->resolvePendingActionNames (line 152)
6	App\Service\AcademyOnboardingAllowlist->hasPendingOnboardingActions (line 140)
7	App\EventSubscriber\AcademyOnboardingGuardSubscriber->onKernelRequest (line 68)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.55 ms
(11.40%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id WHERE user_user_actions.user_id = ?

Parameters:

[
  b"\x01žDËéŽp§ "á,,ù÷í"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
  INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id
WHERE
  user_user_actions.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id WHERE user_user_actions.user_id = 0x019E44CBE98D70A7A022E12C2CF9F7ED;

#	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->contains (line 70)
7	Doctrine\ORM\PersistentCollection->contains (line 361)
8	App\Service\AcademyOnboardingAllowlist->resolvePendingActionNames (line 164)
9	App\Service\AcademyOnboardingAllowlist->hasPendingOnboardingActions (line 140)
10	App\EventSubscriber\AcademyOnboardingGuardSubscriber->onKernelRequest (line 68)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

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\UserActions	4
App\Entity\EmailTemplate	4
App\Entity\Image	2
App\Entity\User	1
App\Entity\Company	1
App\Entity\Country	1
App\Entity\EduPackage	1
App\Entity\CompanyDetail	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\UserActions	No errors.
App\Entity\Country	No errors.
App\Entity\EduPackage	No errors.
App\Entity\CompanyDetail	No errors.
App\Entity\Image	No errors.
App\Entity\EmailTemplate	No errors.

Symfony Profiler

GET https://staging.my-waycard.com/media/cache/resolve/backend_media_thumbnail/uploads/company/images/closeup-of-unrecognizable-woman-practicing-yoga-at-2026-01-08-…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping