Symfony Profiler

Query Metrics

10 Database Queries

2 Different statements

4.93 ms Query time

0 Invalid entities

38 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.03 ms
(61.59%)

SELECT t0.id AS id_1, t0.label AS label_2 FROM tag t0 INNER JOIN module_tag ON t0.id = module_tag.tag_id WHERE module_tag.module_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  tag t0
  INNER JOIN module_tag ON t0.id = module_tag.tag_id
WHERE
  module_tag.module_id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM tag t0 INNER JOIN module_tag ON t0.id = module_tag.tag_id WHERE module_tag.module_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	App\Controller\HomeController->{closure:App\Controller\HomeController::modules():71} (line 75)
8	array_map (line 71)
9	App\Controller\HomeController::modules (line 71)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
14	frankenphp_handle_request (line 45)
15	Runtime\FrankenPhpSymfony\Runner::run (line 45)
16	require_once (line 32)
17	require_once (line 5)

1.89 ms
(38.41%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.description AS description_4, t0.icon AS icon_5, t0.front_page AS front_page_6 FROM module t0 WHERE t0.type = ?

Parameters:

[
  "Disponible"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.front_page AS front_page_6
FROM
  module t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.description AS description_4, t0.icon AS icon_5, t0.front_page AS front_page_6 FROM module t0 WHERE t0.type = 'Disponible';

#	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	App\Controller\HomeController->modules (line 64)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
9	frankenphp_handle_request (line 45)
10	Runtime\FrankenPhpSymfony\Runner::run (line 45)
11	require_once (line 32)
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\Module\Module	32
App\Entity\Module\Tag	6

Entities Mapping

Class	Mapping errors
App\Entity\Module\Module	No errors.
App\Entity\Module\Tag	No errors.

Symfony Profiler

GET https://bbernier.devlogiciel.com/modules

Configuration Settings

Theme

Page Width