Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

2.39 ms Query time

3 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.06 ms
(44.48%)

SELECT t0.id AS id_1, t0.adherent AS adherent_2, t0.nom_barque AS nom_barque_3, t0.numero_immatriculation AS numero_immatriculation_4, t0.mode_paiement AS mode_paiement_5, t0.nombre_pecheurs AS nombre_pecheurs_6, t0.date_effet AS date_effet_7, t0.date_fin_effet AS date_fin_effet_8, t0.statut AS statut_9, t0.numero_cin AS numero_cin_10, t0.created_at AS created_at_11, t0.modified_at AS modified_at_12, t0.association_id AS association_id_13, t0.type_demande_id AS type_demande_id_14, t0.created_by_id AS created_by_id_15, t16.id AS id_17, t16.numero AS numero_18, t16.date_emission AS date_emission_19, t16.fichier_path AS fichier_path_20, t16.statut AS statut_21, t16.created_at AS created_at_22, t16.modified_at AS modified_at_23, t16.demande_id AS demande_id_24, t0.pecheur_id AS pecheur_id_25 FROM demande t0 LEFT JOIN attestation t16 ON t16.demande_id = t0.id WHERE t0.id = ?

Parameters:

[
  "6496"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.adherent AS adherent_2,
  t0.nom_barque AS nom_barque_3,
  t0.numero_immatriculation AS numero_immatriculation_4,
  t0.mode_paiement AS mode_paiement_5,
  t0.nombre_pecheurs AS nombre_pecheurs_6,
  t0.date_effet AS date_effet_7,
  t0.date_fin_effet AS date_fin_effet_8,
  t0.statut AS statut_9,
  t0.numero_cin AS numero_cin_10,
  t0.created_at AS created_at_11,
  t0.modified_at AS modified_at_12,
  t0.association_id AS association_id_13,
  t0.type_demande_id AS type_demande_id_14,
  t0.created_by_id AS created_by_id_15,
  t16.id AS id_17,
  t16.numero AS numero_18,
  t16.date_emission AS date_emission_19,
  t16.fichier_path AS fichier_path_20,
  t16.statut AS statut_21,
  t16.created_at AS created_at_22,
  t16.modified_at AS modified_at_23,
  t16.demande_id AS demande_id_24,
  t0.pecheur_id AS pecheur_id_25
FROM
  demande t0
  LEFT JOIN attestation t16 ON t16.demande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.adherent AS adherent_2, t0.nom_barque AS nom_barque_3, t0.numero_immatriculation AS numero_immatriculation_4, t0.mode_paiement AS mode_paiement_5, t0.nombre_pecheurs AS nombre_pecheurs_6, t0.date_effet AS date_effet_7, t0.date_fin_effet AS date_fin_effet_8, t0.statut AS statut_9, t0.numero_cin AS numero_cin_10, t0.created_at AS created_at_11, t0.modified_at AS modified_at_12, t0.association_id AS association_id_13, t0.type_demande_id AS type_demande_id_14, t0.created_by_id AS created_by_id_15, t16.id AS id_17, t16.numero AS numero_18, t16.date_emission AS date_emission_19, t16.fichier_path AS fichier_path_20, t16.statut AS statut_21, t16.created_at AS created_at_22, t16.modified_at AS modified_at_23, t16.demande_id AS demande_id_24, t0.pecheur_id AS pecheur_id_25 FROM demande t0 LEFT JOIN attestation t16 ON t16.demande_id = t0.id WHERE t0.id = '6496';

#	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\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 7)

0.48 ms
(19.91%)

SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.contact_telephone AS contact_telephone_6, t0.contact_nom AS contact_nom_7, t0.ville AS ville_8, t0.created_at AS created_at_9, t0.modified_at AS modified_at_10, t0.association_id AS association_id_11 FROM user t0 WHERE t0.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.contact_telephone AS contact_telephone_6,
  t0.contact_nom AS contact_nom_7,
  t0.ville AS ville_8,
  t0.created_at AS created_at_9,
  t0.modified_at AS modified_at_10,
  t0.association_id AS association_id_11
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.contact_telephone AS contact_telephone_6, t0.contact_nom AS contact_nom_7, t0.ville AS ville_8, t0.created_at AS created_at_9, t0.modified_at AS modified_at_10, t0.association_id AS association_id_11 FROM user t0 WHERE t0.id = 26;

#	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 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 7)

0.37 ms
(15.61%)

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.date_emission AS date_emission_3, t0.fichier_path AS fichier_path_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.demande_id AS demande_id_8 FROM attestation t0 WHERE t0.id = ?

Parameters:

[
  4930
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.date_emission AS date_emission_3,
  t0.fichier_path AS fichier_path_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.modified_at AS modified_at_7,
  t0.demande_id AS demande_id_8
FROM
  attestation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.date_emission AS date_emission_3, t0.fichier_path AS fichier_path_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.demande_id AS demande_id_8 FROM attestation t0 WHERE t0.id = 4930;

#	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->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Attestation::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Attestation->__get (line 153)
7	App\Entity\Attestation->getNumero (line 64)
8	App\Controller\PdfController->attestationAssuranceIndividuelDynamic (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 7)

0.18 ms
(7.44%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.contact_nom AS contact_nom_6, t0.contact_email AS contact_email_7, t0.contact_telephone AS contact_telephone_8, t0.status AS status_9, t0.numero_police AS numero_police_10, t0.sahara AS sahara_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13 FROM association t0 WHERE t0.id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.adresse AS adresse_4,
  t0.ville AS ville_5,
  t0.contact_nom AS contact_nom_6,
  t0.contact_email AS contact_email_7,
  t0.contact_telephone AS contact_telephone_8,
  t0.status AS status_9,
  t0.numero_police AS numero_police_10,
  t0.sahara AS sahara_11,
  t0.created_at AS created_at_12,
  t0.modified_at AS modified_at_13
FROM
  association t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.contact_nom AS contact_nom_6, t0.contact_email AS contact_email_7, t0.contact_telephone AS contact_telephone_8, t0.status AS status_9, t0.numero_police AS numero_police_10, t0.sahara AS sahara_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13 FROM association t0 WHERE t0.id = 17;

#	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->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Association::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Association->__get (line 153)
7	App\Entity\Association->getNom (line 75)
8	App\Controller\PdfController->attestationAssuranceIndividuelDynamic (line 131)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 7)

0.15 ms
(6.40%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.is_active AS is_active_4, t0.description AS description_5, t0.libelle_ar AS libelle_ar_6 FROM type_demande t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.is_active AS is_active_4,
  t0.description AS description_5,
  t0.libelle_ar AS libelle_ar_6
FROM
  type_demande t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.is_active AS is_active_4, t0.description AS description_5, t0.libelle_ar AS libelle_ar_6 FROM type_demande 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->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\TypeDemande::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\TypeDemande->__get (line 153)
7	App\Entity\TypeDemande->getCode (line 59)
8	App\Controller\PdfController->attestationAssuranceIndividuelDynamic (line 97)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 7)

0.15 ms
(6.15%)

SELECT t0.id AS id_1, t0.adherent_avant AS adherent_avant_2, t0.adherent_apres AS adherent_apres_3, t0.nom_barque_avant AS nom_barque_avant_4, t0.nom_barque_apres AS nom_barque_apres_5, t0.immatriculation_avant AS immatriculation_avant_6, t0.immatriculation_apres AS immatriculation_apres_7, t0.pecheurs_avant AS pecheurs_avant_8, t0.pecheurs_apres AS pecheurs_apres_9, t0.mode_paiement_avant AS mode_paiement_avant_10, t0.mode_paiement_apres AS mode_paiement_apres_11, t0.conge_police_path AS conge_police_path_12, t0.date_modification AS date_modification_13, t0.numero_cin_avant AS numero_cin_avant_14, t0.numero_cin_apres AS numero_cin_apres_15, t0.impacte_prime AS impacte_prime_16, t0.attestation_originale_id AS attestation_originale_id_17, t0.demande_id AS demande_id_18, t0.attestation_nouvelle_id AS attestation_nouvelle_id_19 FROM modification_demande t0 WHERE t0.demande_id = ?

Parameters:

[
  6496
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.adherent_avant AS adherent_avant_2,
  t0.adherent_apres AS adherent_apres_3,
  t0.nom_barque_avant AS nom_barque_avant_4,
  t0.nom_barque_apres AS nom_barque_apres_5,
  t0.immatriculation_avant AS immatriculation_avant_6,
  t0.immatriculation_apres AS immatriculation_apres_7,
  t0.pecheurs_avant AS pecheurs_avant_8,
  t0.pecheurs_apres AS pecheurs_apres_9,
  t0.mode_paiement_avant AS mode_paiement_avant_10,
  t0.mode_paiement_apres AS mode_paiement_apres_11,
  t0.conge_police_path AS conge_police_path_12,
  t0.date_modification AS date_modification_13,
  t0.numero_cin_avant AS numero_cin_avant_14,
  t0.numero_cin_apres AS numero_cin_apres_15,
  t0.impacte_prime AS impacte_prime_16,
  t0.attestation_originale_id AS attestation_originale_id_17,
  t0.demande_id AS demande_id_18,
  t0.attestation_nouvelle_id AS attestation_nouvelle_id_19
FROM
  modification_demande t0
WHERE
  t0.demande_id = ?

SELECT t0.id AS id_1, t0.adherent_avant AS adherent_avant_2, t0.adherent_apres AS adherent_apres_3, t0.nom_barque_avant AS nom_barque_avant_4, t0.nom_barque_apres AS nom_barque_apres_5, t0.immatriculation_avant AS immatriculation_avant_6, t0.immatriculation_apres AS immatriculation_apres_7, t0.pecheurs_avant AS pecheurs_avant_8, t0.pecheurs_apres AS pecheurs_apres_9, t0.mode_paiement_avant AS mode_paiement_avant_10, t0.mode_paiement_apres AS mode_paiement_apres_11, t0.conge_police_path AS conge_police_path_12, t0.date_modification AS date_modification_13, t0.numero_cin_avant AS numero_cin_avant_14, t0.numero_cin_apres AS numero_cin_apres_15, t0.impacte_prime AS impacte_prime_16, t0.attestation_originale_id AS attestation_originale_id_17, t0.demande_id AS demande_id_18, t0.attestation_nouvelle_id AS attestation_nouvelle_id_19 FROM modification_demande t0 WHERE t0.demande_id = 6496;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->first (line 167)
7	Doctrine\ORM\PersistentCollection->first (line 518)
8	App\Controller\PdfController->attestationAssuranceIndividuelDynamic (line 103)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
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\Demande	2
App\Entity\TypeDemande	2
App\Entity\User	1
App\Entity\Association	1
App\Entity\ModificationDemande	1
App\Entity\Attestation	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Association	No errors.
App\Entity\Demande	The field App\Entity\Demande#modifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ModificationDemande#demande does not contain the required 'inversedBy: "modifications"' attribute.
App\Entity\TypeDemande	No errors.
App\Entity\Attestation	No errors.
App\Entity\Pecheur	The association App\Entity\Pecheur#association refers to the inverse side field App\Entity\Association#assures which does not exist.
App\Entity\ModificationDemande	The association App\Entity\ModificationDemande#attestationOriginale refers to the inverse side field App\Entity\Attestation#modifications which does not exist.

Symfony Profiler

GET https://pecheurs.abetari.be/attestation-assurance-individuel/6496

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping