Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

0.59 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.09 ms
(16.07%)

SELECT DISTINCT m0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_materiau r2_ ON r1_.id = r2_.realisation_id INNER JOIN materiau m0_ ON m0_.id = r2_.materiau_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = ? ORDER BY m0_.nom ASC

Parameters:

[
  "DMP"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.nom AS nom_0
FROM
  realisation r1_
  INNER JOIN realisation_materiau r2_ ON r1_.id = r2_.realisation_id
  INNER JOIN materiau m0_ ON m0_.id = r2_.materiau_id
  INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id
  INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id
WHERE
  r3_.code = ?
ORDER BY
  m0_.nom ASC

SELECT DISTINCT m0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_materiau r2_ ON r1_.id = r2_.realisation_id INNER JOIN materiau m0_ ON m0_.id = r2_.materiau_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = 'DMP' ORDER BY m0_.nom ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\RealisationRepository->findDistinctMateriaux (line 260)
7	App\Controller\Api\FiltreController->index (line 52)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.09 ms
(15.95%)

SELECT DISTINCT p0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_produit r2_ ON r1_.id = r2_.realisation_id INNER JOIN produit p0_ ON p0_.id = r2_.produit_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = ? ORDER BY p0_.nom ASC

Parameters:

[
  "DMP"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.nom AS nom_0
FROM
  realisation r1_
  INNER JOIN realisation_produit r2_ ON r1_.id = r2_.realisation_id
  INNER JOIN produit p0_ ON p0_.id = r2_.produit_id
  INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id
  INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id
WHERE
  r3_.code = ?
ORDER BY
  p0_.nom ASC

SELECT DISTINCT p0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_produit r2_ ON r1_.id = r2_.realisation_id INNER JOIN produit p0_ ON p0_.id = r2_.produit_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = 'DMP' ORDER BY p0_.nom ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\RealisationRepository->findDistinctProduits (line 239)
7	App\Controller\Api\FiltreController->index (line 51)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.09 ms
(15.91%)

SELECT DISTINCT r0_.type_realisation AS type_realisation_0, r0_.type_realisation_label AS type_realisation_label_1 FROM realisation r0_ INNER JOIN realisation_reseau r2_ ON r0_.id = r2_.realisation_id INNER JOIN reseau r1_ ON r1_.id = r2_.reseau_id WHERE r0_.type_realisation IS NOT NULL AND r1_.code = ? ORDER BY r0_.type_realisation_label ASC

Parameters:

[
  "DMP"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r0_.type_realisation AS type_realisation_0,
  r0_.type_realisation_label AS type_realisation_label_1
FROM
  realisation r0_
  INNER JOIN realisation_reseau r2_ ON r0_.id = r2_.realisation_id
  INNER JOIN reseau r1_ ON r1_.id = r2_.reseau_id
WHERE
  r0_.type_realisation IS NOT NULL
  AND r1_.code = ?
ORDER BY
  r0_.type_realisation_label ASC

SELECT DISTINCT r0_.type_realisation AS type_realisation_0, r0_.type_realisation_label AS type_realisation_label_1 FROM realisation r0_ INNER JOIN realisation_reseau r2_ ON r0_.id = r2_.realisation_id INNER JOIN reseau r1_ ON r1_.id = r2_.reseau_id WHERE r0_.type_realisation IS NOT NULL AND r1_.code = 'DMP' ORDER BY r0_.type_realisation_label ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\RealisationRepository->findDistinctTypeRealisations (line 218)
7	App\Controller\Api\FiltreController->index (line 50)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.09 ms
(15.27%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.alphasia_network_id AS alphasia_network_id_4 FROM reseau t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.alphasia_network_id AS alphasia_network_id_4
FROM
  reseau t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.alphasia_network_id AS alphasia_network_id_4 FROM reseau t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Api\FiltreController->index (line 48)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.08 ms
(13.57%)

SELECT DISTINCT s0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_style r2_ ON r1_.id = r2_.realisation_id INNER JOIN style s0_ ON s0_.id = r2_.style_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = ? ORDER BY s0_.nom ASC

Parameters:

[
  "DMP"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.nom AS nom_0
FROM
  realisation r1_
  INNER JOIN realisation_style r2_ ON r1_.id = r2_.realisation_id
  INNER JOIN style s0_ ON s0_.id = r2_.style_id
  INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id
  INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id
WHERE
  r3_.code = ?
ORDER BY
  s0_.nom ASC

SELECT DISTINCT s0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_style r2_ ON r1_.id = r2_.realisation_id INNER JOIN style s0_ ON s0_.id = r2_.style_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = 'DMP' ORDER BY s0_.nom ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\RealisationRepository->findDistinctStyles (line 281)
7	App\Controller\Api\FiltreController->index (line 53)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.08 ms
(13.21%)

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.name AS name_3, t0.active AS active_4, t0.created_at AS created_at_5 FROM api_key t0 WHERE t0.api_key = ? LIMIT 1

Parameters:

[
  "e9cd5bbb94ff23fdd3ef6ff56bc638b87cec1ac66f99c2981957edd9f221f7b2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5
FROM
  api_key t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.name AS name_3, t0.active AS active_4, t0.created_at AS created_at_5 FROM api_key t0 WHERE t0.api_key = 'e9cd5bbb94ff23fdd3ef6ff56bc638b87cec1ac66f99c2981957edd9f221f7b2' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Security\ApiKeyAuthenticator->authenticate (line 40)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.06 ms
(10.02%)

SELECT DISTINCT g0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_geographie r2_ ON r1_.id = r2_.realisation_id INNER JOIN geographie g0_ ON g0_.id = r2_.geographie_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = ? ORDER BY g0_.nom ASC

Parameters:

[
  "DMP"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT g0_.nom AS nom_0
FROM
  realisation r1_
  INNER JOIN realisation_geographie r2_ ON r1_.id = r2_.realisation_id
  INNER JOIN geographie g0_ ON g0_.id = r2_.geographie_id
  INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id
  INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id
WHERE
  r3_.code = ?
ORDER BY
  g0_.nom ASC

SELECT DISTINCT g0_.nom AS nom_0 FROM realisation r1_ INNER JOIN realisation_geographie r2_ ON r1_.id = r2_.realisation_id INNER JOIN geographie g0_ ON g0_.id = r2_.geographie_id INNER JOIN realisation_reseau r4_ ON r1_.id = r4_.realisation_id INNER JOIN reseau r3_ ON r3_.id = r4_.reseau_id WHERE r3_.code = 'DMP' ORDER BY g0_.nom ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\RealisationRepository->findDistinctGeographies (line 302)
7	App\Controller\Api\FiltreController->index (line 54)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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\Reseau	4
App\Entity\ApiKey	1

Entities Mapping

Class	Mapping errors
App\Entity\ApiKey	No errors.
App\Entity\Reseau	No errors.
App\Entity\Realisation	No errors.
App\Entity\Produit	No errors.
App\Entity\Materiau	No errors.
App\Entity\Style	No errors.
App\Entity\Geographie	No errors.

Symfony Profiler

GET https://dm-media-api.lebarts.com/api/filtres?reseau=DMP

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping