Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

77.19 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

58.86 ms
(76.24%)

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, p1_.id AS id_2, p1_.property_name AS property_name_3, p1_.commune AS commune_4, p1_.surface_totale AS surface_totale_5, p1_.contract_name AS contract_name_6, p1_.adresse_1 AS adresse_1_7, p1_.adresse_2 AS adresse_2_8, p1_.code_postal AS code_postal_9, i2_.id AS id_10, i2_.libelle AS libelle_11, p3_.id AS id_12, p3_.libelle AS libelle_13, p3_.description AS description_14, p3_.surface AS surface_15, p3_.cepage AS cepage_16, p3_.cdc AS cdc_17, p3_.annee AS annee_18, p3_.ecartement AS ecartement_19, p3_.num AS num_20, p3_.znt AS znt_21, p3_.dsppr AS dsppr_22, p3_.dvp AS dvp_23, p4_.id AS id_24, p4_.libelle AS libelle_25, p4_.description AS description_26, p4_.surface AS surface_27, p4_.cepage AS cepage_28, p4_.cdc AS cdc_29, p4_.annee AS annee_30, p4_.ecartement AS ecartement_31, p4_.num AS num_32, p4_.znt AS znt_33, p4_.dsppr AS dsppr_34, p4_.dvp AS dvp_35, s0_.property_id AS property_id_36, p1_.departement_id AS departement_id_37, p1_.main_consultant_id AS main_consultant_id_38, i2_.secteur_id AS secteur_id_39, i2_.property_id AS property_id_40, p3_.ilot_id AS ilot_id_41, p3_.secteur_id AS secteur_id_42, p3_.property_id AS property_id_43, p4_.ilot_id AS ilot_id_44, p4_.secteur_id AS secteur_id_45, p4_.property_id AS property_id_46 FROM secteur s0_ INNER JOIN property p1_ ON s0_.property_id = p1_.id LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  p1_.id AS id_2,
  p1_.property_name AS property_name_3,
  p1_.commune AS commune_4,
  p1_.surface_totale AS surface_totale_5,
  p1_.contract_name AS contract_name_6,
  p1_.adresse_1 AS adresse_1_7,
  p1_.adresse_2 AS adresse_2_8,
  p1_.code_postal AS code_postal_9,
  i2_.id AS id_10,
  i2_.libelle AS libelle_11,
  p3_.id AS id_12,
  p3_.libelle AS libelle_13,
  p3_.description AS description_14,
  p3_.surface AS surface_15,
  p3_.cepage AS cepage_16,
  p3_.cdc AS cdc_17,
  p3_.annee AS annee_18,
  p3_.ecartement AS ecartement_19,
  p3_.num AS num_20,
  p3_.znt AS znt_21,
  p3_.dsppr AS dsppr_22,
  p3_.dvp AS dvp_23,
  p4_.id AS id_24,
  p4_.libelle AS libelle_25,
  p4_.description AS description_26,
  p4_.surface AS surface_27,
  p4_.cepage AS cepage_28,
  p4_.cdc AS cdc_29,
  p4_.annee AS annee_30,
  p4_.ecartement AS ecartement_31,
  p4_.num AS num_32,
  p4_.znt AS znt_33,
  p4_.dsppr AS dsppr_34,
  p4_.dvp AS dvp_35,
  s0_.property_id AS property_id_36,
  p1_.departement_id AS departement_id_37,
  p1_.main_consultant_id AS main_consultant_id_38,
  i2_.secteur_id AS secteur_id_39,
  i2_.property_id AS property_id_40,
  p3_.ilot_id AS ilot_id_41,
  p3_.secteur_id AS secteur_id_42,
  p3_.property_id AS property_id_43,
  p4_.ilot_id AS ilot_id_44,
  p4_.secteur_id AS secteur_id_45,
  p4_.property_id AS property_id_46
FROM
  secteur s0_
  INNER JOIN property p1_ ON s0_.property_id = p1_.id
  LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id
  LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id
  LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, p1_.id AS id_2, p1_.property_name AS property_name_3, p1_.commune AS commune_4, p1_.surface_totale AS surface_totale_5, p1_.contract_name AS contract_name_6, p1_.adresse_1 AS adresse_1_7, p1_.adresse_2 AS adresse_2_8, p1_.code_postal AS code_postal_9, i2_.id AS id_10, i2_.libelle AS libelle_11, p3_.id AS id_12, p3_.libelle AS libelle_13, p3_.description AS description_14, p3_.surface AS surface_15, p3_.cepage AS cepage_16, p3_.cdc AS cdc_17, p3_.annee AS annee_18, p3_.ecartement AS ecartement_19, p3_.num AS num_20, p3_.znt AS znt_21, p3_.dsppr AS dsppr_22, p3_.dvp AS dvp_23, p4_.id AS id_24, p4_.libelle AS libelle_25, p4_.description AS description_26, p4_.surface AS surface_27, p4_.cepage AS cepage_28, p4_.cdc AS cdc_29, p4_.annee AS annee_30, p4_.ecartement AS ecartement_31, p4_.num AS num_32, p4_.znt AS znt_33, p4_.dsppr AS dsppr_34, p4_.dvp AS dvp_35, s0_.property_id AS property_id_36, p1_.departement_id AS departement_id_37, p1_.main_consultant_id AS main_consultant_id_38, i2_.secteur_id AS secteur_id_39, i2_.property_id AS property_id_40, p3_.ilot_id AS ilot_id_41, p3_.secteur_id AS secteur_id_42, p3_.property_id AS property_id_43, p4_.ilot_id AS ilot_id_44, p4_.secteur_id AS secteur_id_45, p4_.property_id AS property_id_46 FROM secteur s0_ INNER JOIN property p1_ ON s0_.property_id = p1_.id LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id WHERE s0_.id IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 33) ORDER BY s0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 87)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 110)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 91)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 138)
15	Symfony\Component\Serializer\Serializer->serialize (line 47)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 73)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

13.39 ms
(17.34%)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM secteur s0_ INNER JOIN property p1_ ON s0_.property_id = p1_.id LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  secteur s0_
  INNER JOIN property p1_ ON s0_.property_id = p1_.id
  LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id
  LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id
  LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM secteur s0_ INNER JOIN property p1_ ON s0_.property_id = p1_.id LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 45)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 68)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 103)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 91)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 138)
15	Symfony\Component\Serializer\Serializer->serialize (line 47)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 73)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

4.95 ms
(6.41%)

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM secteur s0_ INNER JOIN property p1_ ON s0_.property_id = p1_.id LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id ORDER BY s0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  secteur s0_
  INNER JOIN property p1_ ON s0_.property_id = p1_.id
  LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id
  LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id
  LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id
ORDER BY
  s0_.id ASC
LIMIT
  30

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM secteur s0_ INNER JOIN property p1_ ON s0_.property_id = p1_.id LEFT JOIN ilot i2_ ON s0_.id = i2_.secteur_id LEFT JOIN parcelle p3_ ON i2_.id = p3_.ilot_id LEFT JOIN parcelle p4_ ON s0_.id = p4_.secteur_id ORDER BY s0_.id ASC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 87)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 110)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 91)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 138)
15	Symfony\Component\Serializer\Serializer->serialize (line 47)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 73)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 111)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\Properties\Secteur	No errors.
App\Entity\Properties\Ilot	No errors.
App\Entity\Properties\Parcelle	No errors.
App\Entity\Properties\Property	No errors.
App\Entity\Param\Departement	No errors.
App\Entity\User	No errors.
App\Entity\Calendrier\Calendrier	No errors.
App\Entity\PreconisationActualisee\Param\PrecoRegroupementProprietes	No errors.
App\Entity\PreconisationActualisee\PreconisationActualisee	No errors.
App\Entity\Observations\Observation	No errors.
App\Entity\Properties\CatSurface	No errors.
App\Entity\Basagri\Ref\BasagriCulture	No errors.
App\Entity\Properties\Cepage	No errors.
App\Entity\Observations\Visite	No errors.

Symfony Profiler

GET https://proviter.fr/api/secteurs?property%3D405=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping