Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

8.99 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.53 ms
(50.39%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.maitre_ouvrage AS maitre_ouvrage_2, p0_.delivered_at AS delivered_at_3, p0_.location AS location_4, p0_.mt AS mt_5, p0_.missions AS missions_6, p0_.architect AS architect_7, p0_.budget AS budget_8, p0_.description AS description_9, p0_.position AS position_10, p0_.thumbnail AS thumbnail_11 FROM project p0_ ORDER BY p0_.position ASC LIMIT 10 OFFSET 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.maitre_ouvrage AS maitre_ouvrage_2,
  p0_.delivered_at AS delivered_at_3,
  p0_.location AS location_4,
  p0_.mt AS mt_5,
  p0_.missions AS missions_6,
  p0_.architect AS architect_7,
  p0_.budget AS budget_8,
  p0_.description AS description_9,
  p0_.position AS position_10,
  p0_.thumbnail AS thumbnail_11
FROM
  project p0_
ORDER BY
  p0_.position ASC
LIMIT
  10 OFFSET 20

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.maitre_ouvrage AS maitre_ouvrage_2, p0_.delivered_at AS delivered_at_3, p0_.location AS location_4, p0_.mt AS mt_5, p0_.missions AS missions_6, p0_.architect AS architect_7, p0_.budget AS budget_8, p0_.description AS description_9, p0_.position AS position_10, p0_.thumbnail AS thumbnail_11 FROM project p0_ ORDER BY p0_.position ASC LIMIT 10 OFFSET 20;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 115)
7	App\Controller\IndexController->realisations (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.33 ms
(25.95%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 119)
8	App\Controller\IndexController->realisations (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.13 ms
(23.66%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.is_before AS is_before_3, t0.project_id AS project_id_4 FROM project_image t0 WHERE t0.project_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.is_before AS is_before_3,
  t0.project_id AS project_id_4
FROM
  project_image t0
WHERE
  t0.project_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.path AS path_2, t0.is_before AS is_before_3, t0.project_id AS project_id_4 FROM project_image t0 WHERE t0.project_id IN (144, 145, 146, 147, 148, 149, 150, 151, 171, 175);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 168)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 689)
9	Doctrine\ORM\AbstractQuery->getResult (line 115)
10	App\Controller\IndexController->realisations (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
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\Project	No errors.
App\Entity\ProjectImage	No errors.

Symfony Profiler

GET https://www.ingenierie-architecture.com/realisations?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping