Symfony Profiler

Query Metrics

495 Database Queries

7 Different statements

172.49 ms Query time

4 Invalid entities

287 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

65.29 ms
(37.85%)

174

SELECT l0_.id AS id_0, l0_.etage AS etage_1, l0_.numero AS numero_2, l0_.type_id AS type_id_3, l0_.pieces_nb AS pieces_nb_4, l0_.reference AS reference_5, l0_.surface AS surface_6, l0_.occupant_id AS occupant_id_7, l0_.intervention_site_id AS intervention_site_id_8 FROM lieu l0_ WHERE l0_.reference = ? AND l0_.intervention_site_id = ? AND l0_.etage = ? AND l0_.numero = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.etage AS etage_1,
  l0_.numero AS numero_2,
  l0_.type_id AS type_id_3,
  l0_.pieces_nb AS pieces_nb_4,
  l0_.reference AS reference_5,
  l0_.surface AS surface_6,
  l0_.occupant_id AS occupant_id_7,
  l0_.intervention_site_id AS intervention_site_id_8
FROM
  lieu l0_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

SELECT l0_.id AS id_0, l0_.etage AS etage_1, l0_.numero AS numero_2, l0_.type_id AS type_id_3, l0_.pieces_nb AS pieces_nb_4, l0_.reference AS reference_5, l0_.surface AS surface_6, l0_.occupant_id AS occupant_id_7, l0_.intervention_site_id AS intervention_site_id_8 FROM lieu l0_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '101';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Service\ImportLieuService->import (line 200)
7	App\Controller\Client\ImportController->manageForm (line 57)
8	App\Controller\Client\ImportController->lieu (line 42)
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 5)

50.57 ms
(29.32%)

134

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5 FROM occupant t0 WHERE t0.id = ?

Parameters:

[
  594
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5
FROM
  occupant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5 FROM occupant t0 WHERE t0.id = 594;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Occupant::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Occupant->__set (line 225)
7	App\Entity\Occupant->setNom (line 56)
8	App\Service\ImportLieuService->import (line 225)
9	App\Controller\Client\ImportController->manageForm (line 57)
10	App\Controller\Client\ImportController->lieu (line 42)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 5)

47.33 ms
(27.44%)

174

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = ? AND t0.bailleur_id = ? AND t0.client_id = ? LIMIT 1

Parameters:

[
  "SECTEUR NORD"
  29
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\CacheEntity->getTheEntity (line 57)
5	App\Service\ImportLieuService->import (line 145)
6	App\Controller\Client\ImportController->manageForm (line 57)
7	App\Controller\Client\ImportController->lieu (line 42)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

5.92 ms
(3.43%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.the_statut_id AS the_statut_id_3, t0.reference AS reference_4, t0.reference_index AS reference_index_5, t0.reference_bailleur AS reference_bailleur_6, t0.bailleur_id AS bailleur_id_7, t0.adresse_id AS adresse_id_8, t0.client_id AS client_id_9, t0.agence_id AS agence_id_10 FROM intervention_site t0 WHERE t0.nom = ? AND t0.client_id = ? LIMIT 1

Parameters:

[
  "RESIDENCE DU PETIT BOIS"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.the_statut_id AS the_statut_id_3,
  t0.reference AS reference_4,
  t0.reference_index AS reference_index_5,
  t0.reference_bailleur AS reference_bailleur_6,
  t0.bailleur_id AS bailleur_id_7,
  t0.adresse_id AS adresse_id_8,
  t0.client_id AS client_id_9,
  t0.agence_id AS agence_id_10
FROM
  intervention_site t0
WHERE
  t0.nom = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.the_statut_id AS the_statut_id_3, t0.reference AS reference_4, t0.reference_index AS reference_index_5, t0.reference_bailleur AS reference_bailleur_6, t0.bailleur_id AS bailleur_id_7, t0.adresse_id AS adresse_id_8, t0.client_id AS client_id_9, t0.agence_id AS agence_id_10 FROM intervention_site t0 WHERE t0.nom = 'RESIDENCE DU PETIT BOIS' AND t0.client_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\CacheEntity->getTheEntity (line 57)
5	App\Service\ImportLieuService->import (line 163)
6	App\Controller\Client\ImportController->manageForm (line 57)
7	App\Controller\Client\ImportController->lieu (line 42)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

2.18 ms
(1.27%)

SELECT t0.id AS id_1, t0.etage AS etage_2, t0.numero AS numero_3, t0.type_id AS type_id_4, t0.pieces_nb AS pieces_nb_5, t0.reference AS reference_6, t0.surface AS surface_7, t0.occupant_id AS occupant_id_8, t0.intervention_site_id AS intervention_site_id_9 FROM lieu t0 WHERE t0.intervention_site_id = ? ORDER BY t0.etage ASC, t0.numero ASC

Parameters:

[
  433
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.etage AS etage_2,
  t0.numero AS numero_3,
  t0.type_id AS type_id_4,
  t0.pieces_nb AS pieces_nb_5,
  t0.reference AS reference_6,
  t0.surface AS surface_7,
  t0.occupant_id AS occupant_id_8,
  t0.intervention_site_id AS intervention_site_id_9
FROM
  lieu t0
WHERE
  t0.intervention_site_id = ?
ORDER BY
  t0.etage ASC,
  t0.numero ASC

SELECT t0.id AS id_1, t0.etage AS etage_2, t0.numero AS numero_3, t0.type_id AS type_id_4, t0.pieces_nb AS pieces_nb_5, t0.reference AS reference_6, t0.surface AS surface_7, t0.occupant_id AS occupant_id_8, t0.intervention_site_id AS intervention_site_id_9 FROM lieu t0 WHERE t0.intervention_site_id = 433 ORDER BY t0.etage ASC, t0.numero ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
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->contains (line 68)
7	Doctrine\ORM\PersistentCollection->contains (line 361)
8	App\Entity\InterventionSite->addLieu (line 246)
9	App\Service\ImportLieuService->import (line 206)
10	App\Controller\Client\ImportController->manageForm (line 57)
11	App\Controller\Client\ImportController->lieu (line 42)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.65 ms
(0.38%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.updated_at AS updated_at_8, t0.email AS email_9, t0.the_statut_id AS the_statut_id_10, t0.secteurs_id AS secteurs_id_11, t0.client_id AS client_id_12 FROM bailleurs t0 WHERE t0.raison_sociale = ? AND t0.client_id = ? LIMIT 1

Parameters:

[
  "DOMNIS"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.raison_sociale AS raison_sociale_3,
  t0.siret AS siret_4,
  t0.reference_index AS reference_index_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.updated_at AS updated_at_8,
  t0.email AS email_9,
  t0.the_statut_id AS the_statut_id_10,
  t0.secteurs_id AS secteurs_id_11,
  t0.client_id AS client_id_12
FROM
  bailleurs t0
WHERE
  t0.raison_sociale = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.updated_at AS updated_at_8, t0.email AS email_9, t0.the_statut_id AS the_statut_id_10, t0.secteurs_id AS secteurs_id_11, t0.client_id AS client_id_12 FROM bailleurs t0 WHERE t0.raison_sociale = 'DOMNIS' AND t0.client_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\CacheEntity->getTheEntity (line 57)
5	App\Service\ImportLieuService->import (line 128)
6	App\Controller\Client\ImportController->manageForm (line 57)
7	App\Controller\Client\ImportController->lieu (line 42)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.55 ms
(0.32%)

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.token_password AS token_password_8,
  t0.token_activate AS token_activate_9,
  t0.nom AS nom_10,
  t0.prenom AS prenom_11,
  t0.created_at AS created_at_12,
  t0.the_statut_id AS the_statut_id_13,
  t0.mobile AS mobile_14,
  t0.reference AS reference_15,
  t0.the_type_id AS the_type_id_16,
  t0.the_role_principal_id AS the_role_principal_id_17,
  t0.photo AS photo_18,
  t0.updated_at AS updated_at_19,
  t0.discr,
  t2.tarif_horaire AS tarif_horaire_20,
  t2.client_id AS client_id_21,
  t3.client_id AS client_id_22,
  t3.bailleur_id AS bailleur_id_23
FROM
  user t0
  LEFT JOIN user_admin t1 ON t0.id = t1.id
  LEFT JOIN user_client t2 ON t0.id = t2.id
  LEFT JOIN user_bailleur t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
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\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	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\Lieu	136
App\Entity\Occupant	136
App\Entity\InterventionSite	6
App\Entity\Adresses	6
App\Entity\User	1
App\Entity\Clients	1
App\Entity\Bailleurs	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserAdmin	No errors.
App\Entity\UserClient	The association App\Entity\UserClient#diagnosticTechnicien refers to the owning side field App\Entity\Diagnostic#technicien which does not exist.
App\Entity\UserBailleur	No errors.
App\Entity\Clients	No errors.
App\Entity\Bailleurs	No errors.
App\Entity\Diagnostic	No errors.
App\Entity\Intervention	No errors.
App\Entity\Commande	No errors.
App\Entity\InterventionSite	No errors.
App\Entity\Lieu	No errors.
App\Entity\Agence	No errors.
App\Entity\Secteurs	No errors.
App\Entity\Adresses	No errors.
App\Entity\Contacts	The association App\Entity\Contacts#fonction refers to the inverse side field App\Entity\Fonctions#contacts which does not exist.
App\Entity\CommandeSite	No errors.
App\Entity\Occupant	No errors.
App\Entity\DiagnosticPhoto	No errors.
App\Entity\InterventionPrestation	No errors.
App\Entity\Devis	No errors.
App\Entity\BonCommande	No errors.
App\Entity\Fiches	No errors.
App\Entity\Rapport	No errors.
App\Entity\CommandeLieu	No errors.
App\Entity\InterventionFichier	No errors.
App\Entity\Visite	No errors.
App\Entity\CommandeControle	No errors.
App\Entity\Fonctions	No errors.
App\Entity\Prestations	The association App\Entity\Prestations#prestationsInterventions refers to the inverse side field App\Entity\Intervention#interventionsPrestations which does not exist.
App\Entity\InterventionPrestationPhoto	No errors.
App\Entity\DevisPrestation	No errors.
App\Entity\Signature	No errors.
App\Entity\VisiteControle	No errors.
App\Entity\VisiteLieu	No errors.
App\Entity\VisiteSite	No errors.
App\Entity\VisiteTravaux	No errors.
App\Entity\VisitePhoto	No errors.
App\Entity\VisiteControleTache	No errors.
App\Entity\Controle	No errors.
App\Entity\Parametres	No errors.
App\Entity\Forfait	No errors.
App\Entity\FonctionnaliteDescription	No errors.
App\Entity\Permission	No errors.
App\Entity\Paiement	No errors.
App\Entity\FaqContenu	No errors.
App\Entity\FonctionnaliteResume	No errors.
App\Entity\FaqCategorie	No errors.
App\Entity\PrestationUnite	No errors.
App\Entity\ControleTache	No errors.
App\Entity\DiagnosticControle	The association App\Entity\DiagnosticControle#diagnostic refers to the inverse side field App\Entity\Diagnostic#diagnosticControles which does not exist.
App\Entity\Abonnement	No errors.
App\Entity\Historique	No errors.
App\Entity\Fonctionnalite	No errors.
App\Entity\Option	No errors.
App\Entity\CodePromo	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

POST https://www.test.fluxxo.fr/client/import/lieu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping