Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.59 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.83 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.hash_code AS hash_code_3, t0.is_enabled AS is_enabled_4, t0.phone_number AS phone_number_5, t0.verified_at AS verified_at_6, t0.is_sync AS is_sync_7, t0.is_assigned AS is_assigned_8, t0.created_at AS created_at_9, t0.last_track_at AS last_track_at_10, t0.designation AS designation_11, t0.specs AS specs_12, t0.imei AS imei_13, t0.firebase_token AS firebase_token_14, t0.employe_id AS employe_id_15 FROM device t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "DN-84859"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.hash_code AS hash_code_3,
  t0.is_enabled AS is_enabled_4,
  t0.phone_number AS phone_number_5,
  t0.verified_at AS verified_at_6,
  t0.is_sync AS is_sync_7,
  t0.is_assigned AS is_assigned_8,
  t0.created_at AS created_at_9,
  t0.last_track_at AS last_track_at_10,
  t0.designation AS designation_11,
  t0.specs AS specs_12,
  t0.imei AS imei_13,
  t0.firebase_token AS firebase_token_14,
  t0.employe_id AS employe_id_15
FROM
  device t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.hash_code AS hash_code_3, t0.is_enabled AS is_enabled_4, t0.phone_number AS phone_number_5, t0.verified_at AS verified_at_6, t0.is_sync AS is_sync_7, t0.is_assigned AS is_assigned_8, t0.created_at AS created_at_9, t0.last_track_at AS last_track_at_10, t0.designation AS designation_11, t0.specs AS specs_12, t0.imei AS imei_13, t0.firebase_token AS firebase_token_14, t0.employe_id AS employe_id_15 FROM device t0 WHERE t0.code = 'DN-84859' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.76 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom_prenom AS nom_prenom_3, t0.email AS email_4, t0.team_id AS team_id_5 FROM employe t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom_prenom AS nom_prenom_3,
  t0.email AS email_4,
  t0.team_id AS team_id_5
FROM
  employe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom_prenom AS nom_prenom_3, t0.email AS email_4, t0.team_id AS team_id_5 FROM employe t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Employe::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Employe->__get (line 44)
8	App\Entity\Employe->__toString (line 113)
9	Twig\Runtime\EscaperRuntime->escape (line 119)
10	__TwigTemplate_b7ff8a495d156823d537df7abcc5e1ab->block_body (line 437)
11	Twig\Template->yieldBlock (line 116)
12	__TwigTemplate_1fa54cb615442f18c0ebd5d476666639->doDisplay (line 393)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_b7ff8a495d156823d537df7abcc5e1ab->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
23	App\Controller\Device\ShowController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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.

Entities Mapping

Class	Mapping errors
App\Entity\Device	No errors.
App\Entity\Employe	No errors.
App\Entity\Tracking	No errors.
App\Entity\Team	No errors.

Symfony Profiler

GET https://nutrizaza.dev/device/show/DN-84859/

Configuration Settings

Theme