Symfony Profiler

Query Metrics

19 Database Queries

6 Different statements

3.30 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.85 ms
(55.88%)

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = ?

Parameters:

[
  978
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 978;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 778)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2513)
4	Doctrine\ORM\UnitOfWork->createEntity (line 168)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 59)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 168)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 937)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
9	Doctrine\ORM\EntityRepository->findBy (line 27)
10	App\Controller\NegociateurController->indexAction (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.49 ms
(14.86%)

SELECT t1.date_creation AS date_creation_2, t1.date_maj AS date_maj_3, t1.id AS id_4, t1.prenom AS prenom_5, t1.nom AS nom_6, t1.adresse AS adresse_7, t1.code_postal AS code_postal_8, t1.ville AS ville_9, t1.tel_domicile AS tel_domicile_10, t1.tel_bureau AS tel_bureau_11, t1.tel_mobile AS tel_mobile_12, t1.note_tel_mobile AS note_tel_mobile_13, t1.tel_mobile2 AS tel_mobile2_14, t1.note_tel_mobile2 AS note_tel_mobile2_15, t1.email AS email_16, t1.email2 AS email2_17, t0.secteur AS secteur_18, t0.ville_rattachement AS ville_rattachement_19, t0.photo AS photo_20, t0.display_web AS display_web_21, t0.position AS position_22, t1.civilite_id AS civilite_id_23, t0.utilisateur_id AS utilisateur_id_24, t1.discr FROM negociateur t0 INNER JOIN personne t1 ON t0.id = t1.id WHERE t0.display_web = ? ORDER BY t0.position ASC, t1.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.date_creation AS date_creation_2,
  t1.date_maj AS date_maj_3,
  t1.id AS id_4,
  t1.prenom AS prenom_5,
  t1.nom AS nom_6,
  t1.adresse AS adresse_7,
  t1.code_postal AS code_postal_8,
  t1.ville AS ville_9,
  t1.tel_domicile AS tel_domicile_10,
  t1.tel_bureau AS tel_bureau_11,
  t1.tel_mobile AS tel_mobile_12,
  t1.note_tel_mobile AS note_tel_mobile_13,
  t1.tel_mobile2 AS tel_mobile2_14,
  t1.note_tel_mobile2 AS note_tel_mobile2_15,
  t1.email AS email_16,
  t1.email2 AS email2_17,
  t0.secteur AS secteur_18,
  t0.ville_rattachement AS ville_rattachement_19,
  t0.photo AS photo_20,
  t0.display_web AS display_web_21,
  t0.position AS position_22,
  t1.civilite_id AS civilite_id_23,
  t0.utilisateur_id AS utilisateur_id_24,
  t1.discr
FROM
  negociateur t0
  INNER JOIN personne t1 ON t0.id = t1.id
WHERE
  t0.display_web = ?
ORDER BY
  t0.position ASC,
  t1.id ASC

SELECT t1.date_creation AS date_creation_2, t1.date_maj AS date_maj_3, t1.id AS id_4, t1.prenom AS prenom_5, t1.nom AS nom_6, t1.adresse AS adresse_7, t1.code_postal AS code_postal_8, t1.ville AS ville_9, t1.tel_domicile AS tel_domicile_10, t1.tel_bureau AS tel_bureau_11, t1.tel_mobile AS tel_mobile_12, t1.note_tel_mobile AS note_tel_mobile_13, t1.tel_mobile2 AS tel_mobile2_14, t1.note_tel_mobile2 AS note_tel_mobile2_15, t1.email AS email_16, t1.email2 AS email2_17, t0.secteur AS secteur_18, t0.ville_rattachement AS ville_rattachement_19, t0.photo AS photo_20, t0.display_web AS display_web_21, t0.position AS position_22, t1.civilite_id AS civilite_id_23, t0.utilisateur_id AS utilisateur_id_24, t1.discr FROM negociateur t0 INNER JOIN personne t1 ON t0.id = t1.id WHERE t0.display_web = 1 ORDER BY t0.position ASC, t1.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 27)
4	App\Controller\NegociateurController->indexAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.42 ms
(12.83%)

SELECT MIN(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MIN(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 14)
7	App\Repository\OffreRepository->getMinCA (line 29)
8	App\Service\FormRechercheOfficine->getForm (line 227)
9	App\Controller\DefaultController->getAllForm (line 32)
10	App\Controller\NegociateurController->indexAction (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.29 ms
(8.93%)

SELECT MAX(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MAX(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 23)
7	App\Repository\OffreRepository->getMaxCA (line 30)
8	App\Service\FormRechercheOfficine->getForm (line 227)
9	App\Controller\DefaultController->getAllForm (line 32)
10	App\Controller\NegociateurController->indexAction (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.13 ms
(3.81%)

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.abreviation AS abreviation_2, r0_.code AS code_3, r0_.centroid AS centroid_4, r0_.position AS position_5 FROM region r0_ ORDER BY r0_.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.abreviation AS abreviation_2,
  r0_.code AS code_3,
  r0_.centroid AS centroid_4,
  r0_.position AS position_5
FROM
  region r0_
ORDER BY
  r0_.nom ASC

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.abreviation AS abreviation_2, r0_.code AS code_3, r0_.centroid AS centroid_4, r0_.position AS position_5 FROM region r0_ ORDER BY r0_.nom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 183)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 194)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 473)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 227)
21	App\Controller\DefaultController->getAllForm (line 32)
22	App\Controller\NegociateurController->indexAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.12 ms
(3.69%)

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.abreviation AS abreviation_2, d0_.numero AS numero_3, d0_.region_id AS region_id_4 FROM departement d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.nom AS nom_1,
  d0_.abreviation AS abreviation_2,
  d0_.numero AS numero_3,
  d0_.region_id AS region_id_4
FROM
  departement d0_

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.abreviation AS abreviation_2, d0_.numero AS numero_3, d0_.region_id AS region_id_4 FROM departement d0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 183)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 194)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 473)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 227)
21	App\Controller\DefaultController->getAllForm (line 32)
22	App\Controller\NegociateurController->indexAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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.

Entities Mapping

Class	Mapping errors
App\Entity\Historisation	No errors.
App\Entity\Personne	No errors.
App\Entity\Negociateur	No errors.
App\Entity\Civilite	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Acheteur	No errors.
App\Entity\UtilisateurSite	No errors.
App\Entity\PasswordToken	No errors.
App\Entity\Departement	No errors.
App\Entity\Offre	No errors.
App\Entity\Visite	No errors.
App\Entity\Region	No errors.

Symfony Profiler

GET https://cabinet-guerry.test.agence-11h10.fr/login-popup

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping