Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

16.17 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

9.19 ms

SELECT DISTINCT p0_.id AS id_0, p0_.surface AS surface_1 FROM parcellaire p0_ ORDER BY p0_.surface ASC LIMIT 20 OFFSET 220

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.surface AS surface_1
FROM
  parcellaire p0_
ORDER BY
  p0_.surface ASC
LIMIT
  20 OFFSET 220

SELECT DISTINCT p0_.id AS id_0, p0_.surface AS surface_1 FROM parcellaire p0_ ORDER BY p0_.surface ASC LIMIT 20 OFFSET 220;

#	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 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (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.90 ms

SELECT p0_.id AS id_0, p0_.property_name AS property_name_1, p0_.secteur_name AS secteur_name_2, p0_.ilot_name AS ilot_name_3, p0_.parcelle_name AS parcelle_name_4, p0_.description AS description_5, p0_.surface AS surface_6, p0_.cepage AS cepage_7, p0_.cdc AS cdc_8, p0_.annee AS annee_9, p0_.ecartement AS ecartement_10, p0_.num AS num_11, p0_.znt AS znt_12, p0_.dsppr AS dsppr_13, p0_.dvp AS dvp_14 FROM parcellaire p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.surface ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.property_name AS property_name_1,
  p0_.secteur_name AS secteur_name_2,
  p0_.ilot_name AS ilot_name_3,
  p0_.parcelle_name AS parcelle_name_4,
  p0_.description AS description_5,
  p0_.surface AS surface_6,
  p0_.cepage AS cepage_7,
  p0_.cdc AS cdc_8,
  p0_.annee AS annee_9,
  p0_.ecartement AS ecartement_10,
  p0_.num AS num_11,
  p0_.znt AS znt_12,
  p0_.dsppr AS dsppr_13,
  p0_.dvp AS dvp_14
FROM
  parcellaire p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.surface ASC

SELECT p0_.id AS id_0, p0_.property_name AS property_name_1, p0_.secteur_name AS secteur_name_2, p0_.ilot_name AS ilot_name_3, p0_.parcelle_name AS parcelle_name_4, p0_.description AS description_5, p0_.surface AS surface_6, p0_.cepage AS cepage_7, p0_.cdc AS cdc_8, p0_.annee AS annee_9, p0_.ecartement AS ecartement_10, p0_.num AS num_11, p0_.znt AS znt_12, p0_.dsppr AS dsppr_13, p0_.dvp AS dvp_14 FROM parcellaire p0_ WHERE p0_.id IN (221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240) ORDER BY p0_.surface 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 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (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)

6.08 ms

SELECT COUNT(p0_.id) AS sclr_0 FROM parcellaire p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  parcellaire p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM parcellaire p0_;

#	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 68)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (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)

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\Files\Import\Parcellaire	No errors.

Symfony Profiler

GET https://proviter.fr/?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CFiles%5CParcellaireCrudController&page=12&sort%5Bsurface%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping