Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.88 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.12 ms
(38.79%)

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.65 ms
(22.52%)

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 214)
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.47 ms
(16.31%)

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 214)
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.35 ms
(12.24%)

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 214)
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.29 ms
(10.13%)

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 214)
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\Offre	No errors.
App\Entity\Region	No errors.
App\Entity\Departement	No errors.
App\Entity\PasswordToken	No errors.
App\Entity\AchatEnAssociation	No errors.
App\Entity\Publipostage	No errors.
App\Entity\ChiffreAffaire	No errors.
App\Entity\Vendeur	No errors.
App\Entity\Visite	No errors.
App\Entity\UtilisateurSite	No errors.
App\Entity\Newsletter	No errors.
App\Entity\Actualite	No errors.
App\Entity\Courrier	No errors.
App\Entity\Slider	No errors.
App\Entity\Partenaire	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Algolia\SearchBundle\Entity\Aggregator	No errors.
FOS\UserBundle\Model\User	No errors.

Symfony Profiler

GET http://cabinet-guerry.preprod.agence-11h10.fr/negociateurs

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping