Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.47 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.93 ms

SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9 FROM property t0 WHERE t0.id = ?

Parameters:

[
  "232"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.property_name AS property_name_2,
  t0.commune AS commune_3,
  t0.surface_totale AS surface_totale_4,
  t0.contract_name AS contract_name_5,
  t0.adresse_1 AS adresse_1_6,
  t0.adresse_2 AS adresse_2_7,
  t0.code_postal AS code_postal_8,
  t0.departement_id AS departement_id_9
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9 FROM property t0 WHERE t0.id = '232';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 31)
6	App\Filter\PropertyBasedIlots->filterProperty (line 43)
7	ApiPlatform\Doctrine\Orm\Filter\AbstractFilter->apply (line 63)
8	ApiPlatform\Doctrine\Orm\Extension\FilterExtension->applyToCollection (line 71)
9	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 43)
10	ApiPlatform\State\CallableProvider->provide (line 75)
11	ApiPlatform\State\Provider\ReadProvider->provide (line 48)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 53)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 47)
14	ApiPlatform\State\Provider\DeserializeProvider->provide (line 53)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 54)
16	ApiPlatform\Symfony\Validator\State\QueryParameterValidateProvider->provide (line 32)
17	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 53)
18	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 56)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 82)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

1.01 ms

SELECT COUNT(DISTINCT i0_.id) AS sclr_0 FROM ilot i0_ LEFT JOIN property p1_ ON i0_.property_id = p1_.id LEFT JOIN secteur s2_ ON i0_.secteur_id = s2_.id LEFT JOIN parcelle p3_ ON i0_.id = p3_.ilot_id WHERE i0_.id IN (SELECT i4_.id FROM ilot i4_ LEFT JOIN property p5_ ON i4_.property_id = p5_.id WHERE p5_.id = ?)

Parameters:

[
  "232"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT i0_.id) AS sclr_0
FROM
  ilot i0_
  LEFT JOIN property p1_ ON i0_.property_id = p1_.id
  LEFT JOIN secteur s2_ ON i0_.secteur_id = s2_.id
  LEFT JOIN parcelle p3_ ON i0_.id = p3_.ilot_id
WHERE
  i0_.id IN (
    SELECT
      i4_.id
    FROM
      ilot i4_
      LEFT JOIN property p5_ ON i4_.property_id = p5_.id
    WHERE
      p5_.id = ?
  )

SELECT COUNT(DISTINCT i0_.id) AS sclr_0 FROM ilot i0_ LEFT JOIN property p1_ ON i0_.property_id = p1_.id LEFT JOIN secteur s2_ ON i0_.secteur_id = s2_.id LEFT JOIN parcelle p3_ ON i0_.id = p3_.ilot_id WHERE i0_.id IN (SELECT i4_.id FROM ilot i4_ LEFT JOIN property p5_ ON i4_.property_id = p5_.id WHERE p5_.id = '232');

#	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)

0.52 ms

SELECT DISTINCT i0_.id AS id_0, i0_.id AS id_1 FROM ilot i0_ LEFT JOIN property p1_ ON i0_.property_id = p1_.id LEFT JOIN secteur s2_ ON i0_.secteur_id = s2_.id LEFT JOIN parcelle p3_ ON i0_.id = p3_.ilot_id WHERE i0_.id IN (SELECT i4_.id FROM ilot i4_ LEFT JOIN property p5_ ON i4_.property_id = p5_.id WHERE p5_.id = ?) ORDER BY i0_.id ASC LIMIT 30

Parameters:

[
  "232"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT i0_.id AS id_0,
  i0_.id AS id_1
FROM
  ilot i0_
  LEFT JOIN property p1_ ON i0_.property_id = p1_.id
  LEFT JOIN secteur s2_ ON i0_.secteur_id = s2_.id
  LEFT JOIN parcelle p3_ ON i0_.id = p3_.ilot_id
WHERE
  i0_.id IN (
    SELECT
      i4_.id
    FROM
      ilot i4_
      LEFT JOIN property p5_ ON i4_.property_id = p5_.id
    WHERE
      p5_.id = ?
  )
ORDER BY
  i0_.id ASC
LIMIT
  30

SELECT DISTINCT i0_.id AS id_0, i0_.id AS id_1 FROM ilot i0_ LEFT JOIN property p1_ ON i0_.property_id = p1_.id LEFT JOIN secteur s2_ ON i0_.secteur_id = s2_.id LEFT JOIN parcelle p3_ ON i0_.id = p3_.ilot_id WHERE i0_.id IN (SELECT i4_.id FROM ilot i4_ LEFT JOIN property p5_ ON i4_.property_id = p5_.id WHERE p5_.id = '232') ORDER BY i0_.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\Ilot	No errors.
App\Entity\Properties\Property	No errors.
App\Entity\Param\Departement	No errors.
App\Entity\User	No errors.
App\Entity\Properties\Secteur	No errors.
App\Entity\Properties\Parcelle	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/ilots?property=232

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping