Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.06 ms Query time

0 Invalid entities

9 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.39 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value_text AS value_text_2, p0_.value_type_id AS value_type_id_3, p0_.value_user_id AS value_user_id_4, p0_.value_channel_id AS value_channel_id_5 FROM parameter p0_ WHERE p0_.name = ?

Parameters:

[
  "EDIT_EVENT"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value_text AS value_text_2,
  p0_.value_type_id AS value_type_id_3,
  p0_.value_user_id AS value_user_id_4,
  p0_.value_channel_id AS value_channel_id_5
FROM
  parameter p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value_text AS value_text_2, p0_.value_type_id AS value_type_id_3, p0_.value_user_id AS value_user_id_4, p0_.value_channel_id AS value_channel_id_5 FROM parameter p0_ WHERE p0_.name = 'EDIT_EVENT';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Repository\ParameterRepository->findOneByName (line 26)
7	App\Service\UtilsService->GetParamValue (line 36)
8	App\Twig\AppExtension->getGlobals (line 30)
9	Twig\ExtensionSet->getGlobals (line 359)
10	Twig\Environment->getGlobals (line 900)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
19	App\Controller\HomeController->mentions (line 33)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 7)

0.36 ms

SELECT t0.id AS id_1, t0.type_param AS type_param_2 FROM parameter_type t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type_param AS type_param_2
FROM
  parameter_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type_param AS type_param_2 FROM parameter_type t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\ParameterType::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\ParameterType->__get (line 146)
7	App\Entity\ParameterType->getTypeParam (line 26)
8	App\Entity\Parameter->getIdValue (line 156)
9	App\Service\UtilsService->GetParamValue (line 42)
10	App\Twig\AppExtension->getGlobals (line 30)
11	Twig\ExtensionSet->getGlobals (line 359)
12	Twig\Environment->getGlobals (line 900)
13	Twig\Template->yield (line 398)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\HomeController->mentions (line 33)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 7)

0.31 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.discord_id AS discord_id_3 FROM role t0 INNER JOIN parameter_role ON t0.id = parameter_role.role_id WHERE parameter_role.parameter_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.discord_id AS discord_id_3
FROM
  role t0
  INNER JOIN parameter_role ON t0.id = parameter_role.role_id
WHERE
  parameter_role.parameter_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.discord_id AS discord_id_3 FROM role t0 INNER JOIN parameter_role ON t0.id = parameter_role.role_id WHERE parameter_role.parameter_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 157)
7	App\Entity\Parameter->getIdValue (line 160)
8	App\Service\UtilsService->GetParamValue (line 42)
9	App\Twig\AppExtension->getGlobals (line 30)
10	Twig\ExtensionSet->getGlobals (line 359)
11	Twig\Environment->getGlobals (line 900)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\HomeController->mentions (line 33)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 7)

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\Role	7
App\Entity\Parameter	1
App\Entity\ParameterType	1

Entities Mapping

Class	Mapping errors
App\Entity\Parameter	No errors.
App\Entity\ParameterType	No errors.
App\Entity\User	No errors.
App\Entity\Channel	No errors.
App\Entity\Role	No errors.

Symfony Profiler

GET https://1ercorpscolonial.fr/mentions

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping