Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.50 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.28 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.22 ms

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.amende AS amende_3, c0_.tig AS tig_4, c0_.amende_modif AS amende_modif_5, c0_.tig_modif AS tig_modif_6, c0_.amende_modif_percent AS amende_modif_percent_7, c0_.tig_modif_percent AS tig_modif_percent_8, c0_.version AS version_9, c0_.commentaire AS commentaire_10, c0_.debit_immediat AS debit_immediat_11, i1_.id AS id_12, i1_.category AS category_13, i1_.name AS name_14, i1_.amende_min AS amende_min_15, i1_.amende_max AS amende_max_16, i1_.tig AS tig_17, i1_.article AS article_18, i1_.quantifiable AS quantifiable_19, i1_.quantifiable_count AS quantifiable_count_20, i1_.commentaires AS commentaires_21, i1_.casier AS casier_22, i1_.impayee AS impayee_23, i1_.impayee_max AS impayee_max_24, i1_.debit_immediat AS debit_immediat_25, i1_.can_complicite AS can_complicite_26, i1_.can_saisie AS can_saisie_27, i1_.version AS version_28, c0_.infraction_id AS infraction_id_29 FROM circonstance c0_ LEFT JOIN infraction i1_ ON c0_.infraction_id = i1_.id WHERE c0_.version = ? ORDER BY c0_.type ASC, i1_.article ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.type AS type_1,
  c0_.name AS name_2,
  c0_.amende AS amende_3,
  c0_.tig AS tig_4,
  c0_.amende_modif AS amende_modif_5,
  c0_.tig_modif AS tig_modif_6,
  c0_.amende_modif_percent AS amende_modif_percent_7,
  c0_.tig_modif_percent AS tig_modif_percent_8,
  c0_.version AS version_9,
  c0_.commentaire AS commentaire_10,
  c0_.debit_immediat AS debit_immediat_11,
  i1_.id AS id_12,
  i1_.category AS category_13,
  i1_.name AS name_14,
  i1_.amende_min AS amende_min_15,
  i1_.amende_max AS amende_max_16,
  i1_.tig AS tig_17,
  i1_.article AS article_18,
  i1_.quantifiable AS quantifiable_19,
  i1_.quantifiable_count AS quantifiable_count_20,
  i1_.commentaires AS commentaires_21,
  i1_.casier AS casier_22,
  i1_.impayee AS impayee_23,
  i1_.impayee_max AS impayee_max_24,
  i1_.debit_immediat AS debit_immediat_25,
  i1_.can_complicite AS can_complicite_26,
  i1_.can_saisie AS can_saisie_27,
  i1_.version AS version_28,
  c0_.infraction_id AS infraction_id_29
FROM
  circonstance c0_
  LEFT JOIN infraction i1_ ON c0_.infraction_id = i1_.id
WHERE
  c0_.version = ?
ORDER BY
  c0_.type ASC,
  i1_.article ASC

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.amende AS amende_3, c0_.tig AS tig_4, c0_.amende_modif AS amende_modif_5, c0_.tig_modif AS tig_modif_6, c0_.amende_modif_percent AS amende_modif_percent_7, c0_.tig_modif_percent AS tig_modif_percent_8, c0_.version AS version_9, c0_.commentaire AS commentaire_10, c0_.debit_immediat AS debit_immediat_11, i1_.id AS id_12, i1_.category AS category_13, i1_.name AS name_14, i1_.amende_min AS amende_min_15, i1_.amende_max AS amende_max_16, i1_.tig AS tig_17, i1_.article AS article_18, i1_.quantifiable AS quantifiable_19, i1_.quantifiable_count AS quantifiable_count_20, i1_.commentaires AS commentaires_21, i1_.casier AS casier_22, i1_.impayee AS impayee_23, i1_.impayee_max AS impayee_max_24, i1_.debit_immediat AS debit_immediat_25, i1_.can_complicite AS can_complicite_26, i1_.can_saisie AS can_saisie_27, i1_.version AS version_28, c0_.infraction_id AS infraction_id_29 FROM circonstance c0_ LEFT JOIN infraction i1_ ON c0_.infraction_id = i1_.id WHERE c0_.version = 2 ORDER BY c0_.type ASC, i1_.article ASC;

#	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 29)
7	App\Repository\CirconstanceRepository->findByVersion (line 283)
8	App\Controller\ApiController->getCirconstances (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\Circonstance	No errors.
App\Entity\Infraction	No errors.

Symfony Profiler

GET https://intranet-dev.stsi.tech/Api/Circonstances

Configuration Settings

Theme