Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

5 Database Queries

2 Different statements

3.07 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.75 ms
(57.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.priest AS priest_3 FROM role t0 WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.priest AS priest_3
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.priest AS priest_3 FROM role t0 WHERE t0.id = 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\Role::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Role->__get (line 30)
8	App\Entity\Role->getName (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 146)
10	__TwigTemplate_9cb6408ac4706f3315e0756e425a8fb4->block_body (line 430)
11	Twig\Template->yieldBlock (line 148)
12	__TwigTemplate_5f5986399152bcf378c5765d0b8f1b45->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_9cb6408ac4706f3315e0756e425a8fb4->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 75)
22	App\Controller\WelcomeController->employees (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.32 ms
(42.85%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.image AS image_4, t0.status AS status_5, t0.role AS role_6 FROM secular t0 WHERE t0.status = ?

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.image AS image_4,
  t0.status AS status_5,
  t0.role AS role_6
FROM
  secular t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.image AS image_4, t0.status AS status_5, t0.role AS role_6 FROM secular t0 WHERE t0.status = 'published';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	App\Controller\WelcomeController->employees (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Secular	No errors.
App\Entity\Role	No errors.
App\Entity\Priests	No errors.

Symfony Profiler

GET http://preprod.paroissendtr.fr/bienvenue/salaries-benevoles

Configuration Settings

Theme