Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

3 Database Queries

3 Different statements

3.34 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.97 ms
(59.04%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.description AS description_6, t0.image AS image_7, t0.slug AS slug_8, t0.quote AS quote_9, t0.address AS address_10, t0.quote_author AS quote_author_11, t0.short_description AS short_description_12, t0.status AS status_13 FROM priests t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "jean-yves-eric-andriantsoa"
]

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.email AS email_4,
  t0.phone AS phone_5,
  t0.description AS description_6,
  t0.image AS image_7,
  t0.slug AS slug_8,
  t0.quote AS quote_9,
  t0.address AS address_10,
  t0.quote_author AS quote_author_11,
  t0.short_description AS short_description_12,
  t0.status AS status_13
FROM
  priests t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.description AS description_6, t0.image AS image_7, t0.slug AS slug_8, t0.quote AS quote_9, t0.address AS address_10, t0.quote_author AS quote_author_11, t0.short_description AS short_description_12, t0.status AS status_13 FROM priests t0 WHERE t0.slug = 'jean-yves-eric-andriantsoa' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.87 ms
(25.99%)

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

Parameters:

[
  3
]

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.priest = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 138)
8	__TwigTemplate_65b1f5b99edc1e74a63c321dfed675d5->block_body (line 430)
9	Twig\Template->yieldBlock (line 148)
10	__TwigTemplate_5f5986399152bcf378c5765d0b8f1b45->doDisplay (line 360)
11	Twig\Template->yield (line 50)
12	__TwigTemplate_65b1f5b99edc1e74a63c321dfed675d5->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 307)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
20	App\Controller\WelcomeController->singleClergy (line 178)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.50 ms
(14.97%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.description AS description_6, t0.priest AS priest_7 FROM former_ministries t0 WHERE t0.priest = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.location AS location_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.description AS description_6,
  t0.priest AS priest_7
FROM
  former_ministries t0
WHERE
  t0.priest = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.description AS description_6, t0.priest AS priest_7 FROM former_ministries t0 WHERE t0.priest = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1274)
9	Twig\Extension\CoreExtension::testEmpty (line 220)
10	__TwigTemplate_65b1f5b99edc1e74a63c321dfed675d5->block_body (line 430)
11	Twig\Template->yieldBlock (line 148)
12	__TwigTemplate_5f5986399152bcf378c5765d0b8f1b45->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_65b1f5b99edc1e74a63c321dfed675d5->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 55)
22	App\Controller\WelcomeController->singleClergy (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)

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\Priests	No errors.
App\Entity\Role	No errors.
App\Entity\FormerMinistries	No errors.

Symfony Profiler

GET http://preprod.paroissendtr.fr/bienvenue/clerg%C3%A9/jean-yves-eric-andriantsoa

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping