Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

10.55 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.40 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:

[
  "BADGES_DIRECTORY"
]

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 = 'BADGES_DIRECTORY';

#	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\Controller\Api\CertifApiController->eventImage (line 389)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 7)

2.43 ms

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

Parameters:

[
  1
]

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 = 1;

#	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->getValue (line 115)
9	App\Service\UtilsService->GetParamValue (line 42)
10	App\Controller\Api\CertifApiController->eventImage (line 389)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 7)

5.72 ms

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.username AS username_3, t0.discord_id AS discord_id_4, t0.avatar AS avatar_5, t6.id AS id_7, t6.status AS status_8, t6.last_promotion AS last_promotion_9, t6.date_entree AS date_entree_10, t6.json_entrer AS json_entrer_11, t6.promotion_send AS promotion_send_12, t6.user_id AS user_id_13, t6.grade_id AS grade_id_14, t6.pending_approval_id AS pending_approval_id_15 FROM user t0 LEFT JOIN rhmember t6 ON t6.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  110
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.username AS username_3,
  t0.discord_id AS discord_id_4,
  t0.avatar AS avatar_5,
  t6.id AS id_7,
  t6.status AS status_8,
  t6.last_promotion AS last_promotion_9,
  t6.date_entree AS date_entree_10,
  t6.json_entrer AS json_entrer_11,
  t6.promotion_send AS promotion_send_12,
  t6.user_id AS user_id_13,
  t6.grade_id AS grade_id_14,
  t6.pending_approval_id AS pending_approval_id_15
FROM
  user t0
  LEFT JOIN rhmember t6 ON t6.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.username AS username_3, t0.discord_id AS discord_id_4, t0.avatar AS avatar_5, t6.id AS id_7, t6.status AS status_8, t6.last_promotion AS last_promotion_9, t6.date_entree AS date_entree_10, t6.json_entrer AS json_entrer_11, t6.promotion_send AS promotion_send_12, t6.user_id AS user_id_13, t6.grade_id AS grade_id_14, t6.pending_approval_id AS pending_approval_id_15 FROM user t0 LEFT JOIN rhmember t6 ON t6.user_id = t0.id WHERE t0.id = 110;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 74)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
12	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 70)
13	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
14	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
19	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
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)

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\Parameter	1
App\Entity\ParameterType	1
App\Entity\User	1
App\Entity\RHMember	1
App\Entity\Rank	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.
App\Entity\RHMember	No errors.
App\Entity\Rank	No errors.
App\Entity\Traces	No errors.
App\Entity\ResponseEvent	No errors.
App\Entity\Embeddable\DiscordMeta	No errors.
App\Entity\Event	No errors.
App\Entity\VoicePresence	No errors.
App\Entity\FleetLink	No errors.
App\Entity\RHLog	No errors.
App\Entity\RHAbsence	No errors.
App\Entity\RHWarning	No errors.
App\Entity\Certifications	No errors.
App\Entity\XpTransaction	No errors.
App\Entity\AuthCertif	No errors.
App\Entity\CertifRequest	No errors.
App\Entity\ObjectifsAward	No errors.

Symfony Profiler

GET https://www.1ercorpscolonial.fr/certifbadges/68caef9f2beb3.png

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping