Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.64 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.40 ms
(62.46%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.locale AS locale_8, t0.deletion_requested_at AS deletion_requested_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t13.id AS id_14, t13.code AS code_15, t13.first_name AS first_name_16, t13.last_name AS last_name_17, t13.birth_date AS birth_date_18, t13.nationality AS nationality_19, t13.phone AS phone_20, t13.marital_status AS marital_status_21, t13.address AS address_22, t13.current_step AS current_step_23, t13.status_eligible AS status_eligible_24, t13.status_visa_eligible AS status_visa_eligible_25, t13.status_visa_non_eligible AS status_visa_non_eligible_26, t13.eligibility_pay AS eligibility_pay_27, t13.visa_eligible_step1_pay AS visa_eligible_step1_pay_28, t13.visa_eligible_step2_pay AS visa_eligible_step2_pay_29, t13.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_30, t13.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_31, t13.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_32, t13.payment_instructions AS payment_instructions_33, t13.rejection_reason AS rejection_reason_34, t13.agreement_sent_at AS agreement_sent_at_35, t13.agreement_validated_at AS agreement_validated_at_36, t13.created_at AS created_at_37, t13.updated_at AS updated_at_38, t13.deleted_at AS deleted_at_39, t13.user_id AS user_id_40, t13.birth_certificate_id AS birth_certificate_id_41, t13.passport_id AS passport_id_42, t43.id AS id_44, t43.code AS code_45, t43.first_name AS first_name_46, t43.last_name AS last_name_47, t43.birth_date AS birth_date_48, t43.nationality AS nationality_49, t43.phone AS phone_50, t43.marital_status AS marital_status_51, t43.address AS address_52, t43.gender AS gender_53, t43.citizenship AS citizenship_54, t43.number_of_children AS number_of_children_55, t43.current_immigration_status AS current_immigration_status_56, t43.application_type AS application_type_57, t43.language_test AS language_test_58, t43.language_test_score AS language_test_score_59, t43.has_family_in_canada AS has_family_in_canada_60, t43.current_step AS current_step_61, t43.status_eligible AS status_eligible_62, t43.status_visa_eligible AS status_visa_eligible_63, t43.status_visa_non_eligible AS status_visa_non_eligible_64, t43.eligibility_pay AS eligibility_pay_65, t43.visa_eligible_step1_pay AS visa_eligible_step1_pay_66, t43.visa_eligible_step2_pay AS visa_eligible_step2_pay_67, t43.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_68, t43.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_69, t43.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_70, t43.payment_instructions AS payment_instructions_71, t43.rejection_reason AS rejection_reason_72, t43.agreement_sent_at AS agreement_sent_at_73, t43.agreement_validated_at AS agreement_validated_at_74, t43.created_at AS created_at_75, t43.updated_at AS updated_at_76, t43.deleted_at AS deleted_at_77, t43.user_id AS user_id_78, t43.cv_id AS cv_id_79, t43.diploma_id AS diploma_id_80, t43.identity_photo_id AS identity_photo_id_81, t43.passport_id AS passport_id_82 FROM `user` t0 LEFT JOIN student t13 ON t13.user_id = t0.id LEFT JOIN worker t43 ON t43.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  8
]

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_active AS is_active_5,
  t0.verification_token AS verification_token_6,
  t0.reset_token AS reset_token_7,
  t0.locale AS locale_8,
  t0.deletion_requested_at AS deletion_requested_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t13.id AS id_14,
  t13.code AS code_15,
  t13.first_name AS first_name_16,
  t13.last_name AS last_name_17,
  t13.birth_date AS birth_date_18,
  t13.nationality AS nationality_19,
  t13.phone AS phone_20,
  t13.marital_status AS marital_status_21,
  t13.address AS address_22,
  t13.current_step AS current_step_23,
  t13.status_eligible AS status_eligible_24,
  t13.status_visa_eligible AS status_visa_eligible_25,
  t13.status_visa_non_eligible AS status_visa_non_eligible_26,
  t13.eligibility_pay AS eligibility_pay_27,
  t13.visa_eligible_step1_pay AS visa_eligible_step1_pay_28,
  t13.visa_eligible_step2_pay AS visa_eligible_step2_pay_29,
  t13.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_30,
  t13.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_31,
  t13.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_32,
  t13.payment_instructions AS payment_instructions_33,
  t13.rejection_reason AS rejection_reason_34,
  t13.agreement_sent_at AS agreement_sent_at_35,
  t13.agreement_validated_at AS agreement_validated_at_36,
  t13.created_at AS created_at_37,
  t13.updated_at AS updated_at_38,
  t13.deleted_at AS deleted_at_39,
  t13.user_id AS user_id_40,
  t13.birth_certificate_id AS birth_certificate_id_41,
  t13.passport_id AS passport_id_42,
  t43.id AS id_44,
  t43.code AS code_45,
  t43.first_name AS first_name_46,
  t43.last_name AS last_name_47,
  t43.birth_date AS birth_date_48,
  t43.nationality AS nationality_49,
  t43.phone AS phone_50,
  t43.marital_status AS marital_status_51,
  t43.address AS address_52,
  t43.gender AS gender_53,
  t43.citizenship AS citizenship_54,
  t43.number_of_children AS number_of_children_55,
  t43.current_immigration_status AS current_immigration_status_56,
  t43.application_type AS application_type_57,
  t43.language_test AS language_test_58,
  t43.language_test_score AS language_test_score_59,
  t43.has_family_in_canada AS has_family_in_canada_60,
  t43.current_step AS current_step_61,
  t43.status_eligible AS status_eligible_62,
  t43.status_visa_eligible AS status_visa_eligible_63,
  t43.status_visa_non_eligible AS status_visa_non_eligible_64,
  t43.eligibility_pay AS eligibility_pay_65,
  t43.visa_eligible_step1_pay AS visa_eligible_step1_pay_66,
  t43.visa_eligible_step2_pay AS visa_eligible_step2_pay_67,
  t43.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_68,
  t43.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_69,
  t43.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_70,
  t43.payment_instructions AS payment_instructions_71,
  t43.rejection_reason AS rejection_reason_72,
  t43.agreement_sent_at AS agreement_sent_at_73,
  t43.agreement_validated_at AS agreement_validated_at_74,
  t43.created_at AS created_at_75,
  t43.updated_at AS updated_at_76,
  t43.deleted_at AS deleted_at_77,
  t43.user_id AS user_id_78,
  t43.cv_id AS cv_id_79,
  t43.diploma_id AS diploma_id_80,
  t43.identity_photo_id AS identity_photo_id_81,
  t43.passport_id AS passport_id_82
FROM
  `user` t0
  LEFT JOIN student t13 ON t13.user_id = t0.id
  LEFT JOIN worker t43 ON t43.user_id = t0.id
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_active AS is_active_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.locale AS locale_8, t0.deletion_requested_at AS deletion_requested_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t13.id AS id_14, t13.code AS code_15, t13.first_name AS first_name_16, t13.last_name AS last_name_17, t13.birth_date AS birth_date_18, t13.nationality AS nationality_19, t13.phone AS phone_20, t13.marital_status AS marital_status_21, t13.address AS address_22, t13.current_step AS current_step_23, t13.status_eligible AS status_eligible_24, t13.status_visa_eligible AS status_visa_eligible_25, t13.status_visa_non_eligible AS status_visa_non_eligible_26, t13.eligibility_pay AS eligibility_pay_27, t13.visa_eligible_step1_pay AS visa_eligible_step1_pay_28, t13.visa_eligible_step2_pay AS visa_eligible_step2_pay_29, t13.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_30, t13.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_31, t13.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_32, t13.payment_instructions AS payment_instructions_33, t13.rejection_reason AS rejection_reason_34, t13.agreement_sent_at AS agreement_sent_at_35, t13.agreement_validated_at AS agreement_validated_at_36, t13.created_at AS created_at_37, t13.updated_at AS updated_at_38, t13.deleted_at AS deleted_at_39, t13.user_id AS user_id_40, t13.birth_certificate_id AS birth_certificate_id_41, t13.passport_id AS passport_id_42, t43.id AS id_44, t43.code AS code_45, t43.first_name AS first_name_46, t43.last_name AS last_name_47, t43.birth_date AS birth_date_48, t43.nationality AS nationality_49, t43.phone AS phone_50, t43.marital_status AS marital_status_51, t43.address AS address_52, t43.gender AS gender_53, t43.citizenship AS citizenship_54, t43.number_of_children AS number_of_children_55, t43.current_immigration_status AS current_immigration_status_56, t43.application_type AS application_type_57, t43.language_test AS language_test_58, t43.language_test_score AS language_test_score_59, t43.has_family_in_canada AS has_family_in_canada_60, t43.current_step AS current_step_61, t43.status_eligible AS status_eligible_62, t43.status_visa_eligible AS status_visa_eligible_63, t43.status_visa_non_eligible AS status_visa_non_eligible_64, t43.eligibility_pay AS eligibility_pay_65, t43.visa_eligible_step1_pay AS visa_eligible_step1_pay_66, t43.visa_eligible_step2_pay AS visa_eligible_step2_pay_67, t43.visa_non_eligible_step1_pay AS visa_non_eligible_step1_pay_68, t43.visa_non_eligible_step2_pay AS visa_non_eligible_step2_pay_69, t43.visa_non_eligible_step3_pay AS visa_non_eligible_step3_pay_70, t43.payment_instructions AS payment_instructions_71, t43.rejection_reason AS rejection_reason_72, t43.agreement_sent_at AS agreement_sent_at_73, t43.agreement_validated_at AS agreement_validated_at_74, t43.created_at AS created_at_75, t43.updated_at AS updated_at_76, t43.deleted_at AS deleted_at_77, t43.user_id AS user_id_78, t43.cv_id AS cv_id_79, t43.diploma_id AS diploma_id_80, t43.identity_photo_id AS identity_photo_id_81, t43.passport_id AS passport_id_82 FROM `user` t0 LEFT JOIN student t13 ON t13.user_id = t0.id LEFT JOIN worker t43 ON t43.user_id = t0.id WHERE t0.id = 8;

#	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\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
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 52)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.24 ms
(37.54%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.is_active AS is_active_3, l0_.is_default AS is_default_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.deleted_at AS deleted_at_7 FROM language l0_ WHERE l0_.is_active = 1 ORDER BY l0_.is_default DESC, l0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.code AS code_2,
  l0_.is_active AS is_active_3,
  l0_.is_default AS is_default_4,
  l0_.created_at AS created_at_5,
  l0_.updated_at AS updated_at_6,
  l0_.deleted_at AS deleted_at_7
FROM
  language l0_
WHERE
  l0_.is_active = 1
ORDER BY
  l0_.is_default DESC,
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.is_active AS is_active_3, l0_.is_default AS is_default_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.deleted_at AS deleted_at_7 FROM language l0_ WHERE l0_.is_active = 1 ORDER BY l0_.is_default DESC, l0_.name ASC;

#	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\LanguageRepository->findActive (line 24)
7	App\Repository\LanguageRepository->findActiveCodes (line 35)
8	App\EventSubscriber\LocaleSubscriber->getActiveCodes (line 52)
9	App\EventSubscriber\LocaleSubscriber->onKernelRequest (line 31)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	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\Language	2
App\Entity\Media	2
App\Entity\User	1
App\Entity\Student	1

Entities Mapping

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\User	No errors.
App\Entity\Student	No errors.
App\Entity\Media	No errors.
App\Entity\Worker	No errors.
App\Entity\Payment	No errors.
App\Entity\Notification	No errors.
App\Entity\StudentParent	No errors.
App\Entity\AcademicRecord	No errors.

Symfony Profiler

GET https://govoyage.ekrea.cloud/logout

Configuration Settings

Theme

Page Width