Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.99 ms Query time

0 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.58 ms

SELECT m0_.id AS id_0, COUNT(v1_.id) AS sclr_1 FROM vehicule_neuf v1_ LEFT JOIN marque m0_ ON v1_.marque_id = m0_.id LEFT JOIN concession c2_ ON v1_.concession_id = c2_.id WHERE v1_.is_supprimed = 0 AND v1_.is_published = ? GROUP BY m0_.id

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  COUNT(v1_.id) AS sclr_1
FROM
  vehicule_neuf v1_
  LEFT JOIN marque m0_ ON v1_.marque_id = m0_.id
  LEFT JOIN concession c2_ ON v1_.concession_id = c2_.id
WHERE
  v1_.is_supprimed = 0
  AND v1_.is_published = ?
GROUP BY
  m0_.id

SELECT m0_.id AS id_0, COUNT(v1_.id) AS sclr_1 FROM vehicule_neuf v1_ LEFT JOIN marque m0_ ON v1_.marque_id = m0_.id LEFT JOIN concession c2_ ON v1_.concession_id = c2_.id WHERE v1_.is_supprimed = 0 AND v1_.is_published = 1 GROUP BY m0_.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 287)
7	App\Repository\VehiculeNeufRepository->countByMarque (line 19)
8	App\Controller\FO\AccueilController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.74 ms

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.type AS type_2 FROM marque m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND m0_.type = ? ORDER BY m0_.nom ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.type AS type_2
FROM
  marque m0_
WHERE
  m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
  AND m0_.type = ?
ORDER BY
  m0_.nom ASC

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.type AS type_2 FROM marque m0_ WHERE m0_.id IN (3, 18, 167, 166, 8, 15, 13, 6) AND m0_.type = 'auto' ORDER BY m0_.nom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 35)
7	App\Controller\FO\AccueilController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.67 ms

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.type AS type_2 FROM marque m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND m0_.type = ? ORDER BY m0_.nom ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.type AS type_2
FROM
  marque m0_
WHERE
  m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
  AND m0_.type = ?
ORDER BY
  m0_.nom ASC

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.type AS type_2 FROM marque m0_ WHERE m0_.id IN (3, 18, 167, 166, 8, 15, 13, 6) AND m0_.type = 'moto' ORDER BY m0_.nom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 41)
7	App\Controller\FO\AccueilController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Marque	8

Entities Mapping

Class	Mapping errors
App\Entity\VehiculeNeuf	No errors.
App\Entity\Marque	No errors.
App\Entity\Concession	No errors.

Symfony Profiler

GET http://vehicules-neufs.neubauer.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping