Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.29 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.15 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.montee AS montee_7, t0.tel AS tel_8, t0.discord_id AS discord_id_9, t0.birth_date AS birth_date_10, t0.last_activity AS last_activity_11, t0.created_date AS created_date_12, t0.status AS status_13, t0.dispos AS dispos_14, t0.photo AS photo_15, t0.last_dispatch_at AS last_dispatch_at_16, t0.last_montee_at AS last_montee_at_17, t0.genre AS genre_18, t0.commentaire AS commentaire_19, t0.annuaire AS annuaire_20, t0.evaluation AS evaluation_21, t0.evaluation_commentaire AS evaluation_commentaire_22, t0.is_apte_for_evaluation AS is_apte_for_evaluation_23, t0.grade_id AS grade_id_24, t25.id AS id_26, t25.name AS name_27, t25.abrv AS abrv_28, t25.hierarchie AS hierarchie_29, t25.category AS category_30, t25.prime AS prime_31, t32.id AS id_33, t32.matricule AS matricule_34, t32.blocked AS blocked_35, t32.category AS category_36, t32.user_id AS user_id_37, t0.visite_medicale_id AS visite_medicale_id_38, t0.superviseur_id AS superviseur_id_39 FROM user t0 LEFT JOIN grade t25 ON t0.grade_id = t25.id LEFT JOIN matricule t32 ON t32.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  76
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.first_name AS first_name_3,
  t0.name AS name_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.montee AS montee_7,
  t0.tel AS tel_8,
  t0.discord_id AS discord_id_9,
  t0.birth_date AS birth_date_10,
  t0.last_activity AS last_activity_11,
  t0.created_date AS created_date_12,
  t0.status AS status_13,
  t0.dispos AS dispos_14,
  t0.photo AS photo_15,
  t0.last_dispatch_at AS last_dispatch_at_16,
  t0.last_montee_at AS last_montee_at_17,
  t0.genre AS genre_18,
  t0.commentaire AS commentaire_19,
  t0.annuaire AS annuaire_20,
  t0.evaluation AS evaluation_21,
  t0.evaluation_commentaire AS evaluation_commentaire_22,
  t0.is_apte_for_evaluation AS is_apte_for_evaluation_23,
  t0.grade_id AS grade_id_24,
  t25.id AS id_26,
  t25.name AS name_27,
  t25.abrv AS abrv_28,
  t25.hierarchie AS hierarchie_29,
  t25.category AS category_30,
  t25.prime AS prime_31,
  t32.id AS id_33,
  t32.matricule AS matricule_34,
  t32.blocked AS blocked_35,
  t32.category AS category_36,
  t32.user_id AS user_id_37,
  t0.visite_medicale_id AS visite_medicale_id_38,
  t0.superviseur_id AS superviseur_id_39
FROM
  user t0
  LEFT JOIN grade t25 ON t0.grade_id = t25.id
  LEFT JOIN matricule t32 ON t32.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.montee AS montee_7, t0.tel AS tel_8, t0.discord_id AS discord_id_9, t0.birth_date AS birth_date_10, t0.last_activity AS last_activity_11, t0.created_date AS created_date_12, t0.status AS status_13, t0.dispos AS dispos_14, t0.photo AS photo_15, t0.last_dispatch_at AS last_dispatch_at_16, t0.last_montee_at AS last_montee_at_17, t0.genre AS genre_18, t0.commentaire AS commentaire_19, t0.annuaire AS annuaire_20, t0.evaluation AS evaluation_21, t0.evaluation_commentaire AS evaluation_commentaire_22, t0.is_apte_for_evaluation AS is_apte_for_evaluation_23, t0.grade_id AS grade_id_24, t25.id AS id_26, t25.name AS name_27, t25.abrv AS abrv_28, t25.hierarchie AS hierarchie_29, t25.category AS category_30, t25.prime AS prime_31, t32.id AS id_33, t32.matricule AS matricule_34, t32.blocked AS blocked_35, t32.category AS category_36, t32.user_id AS user_id_37, t0.visite_medicale_id AS visite_medicale_id_38, t0.superviseur_id AS superviseur_id_39 FROM user t0 LEFT JOIN grade t25 ON t0.grade_id = t25.id LEFT JOIN matricule t32 ON t32.user_id = t0.id WHERE t0.id = 76;

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

0.14 ms

SELECT n0_.category AS category_0, n0_.notif AS notif_1, n0_.id AS id_2, n0_.created_at AS created_at_3 FROM notification n0_ WHERE n0_.user_id = ? ORDER BY n0_.id DESC

Parameters:

[
  76
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.category AS category_0,
  n0_.notif AS notif_1,
  n0_.id AS id_2,
  n0_.created_at AS created_at_3
FROM
  notification n0_
WHERE
  n0_.user_id = ?
ORDER BY
  n0_.id DESC

SELECT n0_.category AS category_0, n0_.notif AS notif_1, n0_.id AS id_2, n0_.created_at AS created_at_3 FROM notification n0_ WHERE n0_.user_id = 76 ORDER BY n0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\NotificationRepository->findByUser (line 29)
8	App\Controller\UserController->notifications (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 21)

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\Entity\User	The field App\Entity\User#primes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Prime#user does not contain the required 'inversedBy="primes"' attribute. The field App\Entity\User#convocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Convocation#agent does not contain the required 'inversedBy="convocations"' attribute.
App\Entity\Grade	No errors.
App\Entity\Matricule	No errors.
App\Entity\MedicalEntry	No errors.
App\Entity\Unit	No errors.
App\Entity\Plainte	No errors.
App\Entity\Formation	No errors.
App\Entity\Absence	No errors.
App\Entity\Prime	No errors.
App\Entity\Dispatch	No errors.
App\Entity\Service	No errors.
App\Entity\Sanction	No errors.
App\Entity\Moderation	No errors.
App\Entity\InventoryDotation	No errors.
App\Entity\Convocation	No errors.
App\Entity\EvaluationCommentaire	No errors.
App\Entity\Questionnaire	No errors.
App\Entity\Page	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

GET https://intranet-dev.stsi.tech/Notifications

Configuration Settings

Theme