Symfony Profiler

Query Metrics

8 Database Queries

2 Different statements

3.32 ms Query time

0 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.29 ms
(69.11%)

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::home():49} (line 53)
8	array_map (line 49)
9	App\Controller\HomeController::home (line 49)
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.02 ms
(30.89%)

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.title AS title_2, m0_.description AS description_3, m0_.icon AS icon_4, m0_.front_page AS front_page_5 FROM module m0_ WHERE m0_.front_page = ? AND m0_.type = ?

Parameters:

[
  1
  "Disponible"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.title AS title_2,
  m0_.description AS description_3,
  m0_.icon AS icon_4,
  m0_.front_page AS front_page_5
FROM
  module m0_
WHERE
  m0_.front_page = ?
  AND m0_.type = ?

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.title AS title_2, m0_.description AS description_3, m0_.icon AS icon_4, m0_.front_page AS front_page_5 FROM module m0_ WHERE m0_.front_page = 1 AND m0_.type = 'Disponible';

#	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->getResult (line 688)
6	App\Repository\Module\ModuleRepository->findFrontPageModules (line 28)
7	App\Controller\HomeController->home (line 47)
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	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
12	frankenphp_handle_request (line 45)
13	Runtime\FrankenPhpSymfony\Runner::run (line 45)
14	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Module\Module	7
App\Entity\Module\Tag	6

Entities Mapping

Class	Mapping errors
App\Entity\Security\User	No errors.
App\Entity\Geo\City	No errors.
App\Entity\Geo\Region	No errors.
App\Entity\Geo\Department	No errors.
App\Entity\Module\Module	No errors.
App\Entity\Module\Tag	No errors.
App\Entity\Contact\Contact	No errors.
App\Entity\Common\Hours	No errors.
App\Entity\Common\Address	No errors.
App\Entity\LegalUnit\NafCode	No errors.
App\Entity\LegalUnit\NaturalPerson	No errors.
App\Entity\LegalUnit\Establishment	No errors.
App\Entity\LegalUnit\Profile\Faq	No errors.
App\Entity\LegalUnit\Profile\SocietyProfile	No errors.
App\Entity\LegalUnit\Profile\Product	No errors.
App\Entity\LegalUnit\Profile\SpecialHours	No errors.
App\Entity\LegalUnit\Profile\Logo	No errors.
App\Entity\LegalUnit\LegalUnit	No errors.
App\Entity\Page\ArticleCategory	No errors.
App\Entity\Page\Page	No errors.
App\Entity\Page\Media	No errors.
Zhortein\AuditableBundle\Entity\AuditEntry	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://bbernier.devlogiciel.com/

Configuration Settings

Theme

Page Width