Symfony Profiler

Query Metrics

10 Database Queries

7 Different statements

1.38 ms Query time

0 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.42 ms
(30.35%)

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.page AS page_4, t0.position AS position_5, t0.occasion_id AS occasion_id_6, t0.animation_id AS animation_id_7, t0.space_id AS space_id_8 FROM faq t0 WHERE t0.space_id = ? ORDER BY t0.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.answer AS answer_3,
  t0.page AS page_4,
  t0.position AS position_5,
  t0.occasion_id AS occasion_id_6,
  t0.animation_id AS animation_id_7,
  t0.space_id AS space_id_8
FROM
  faq t0
WHERE
  t0.space_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.page AS page_4, t0.position AS position_5, t0.occasion_id AS occasion_id_6, t0.animation_id AS animation_id_7, t0.space_id AS space_id_8 FROM faq t0 WHERE t0.space_id = 2 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->length (line 1299)
9	__TwigTemplate_a7df698b49b513dadba7c2ef80c99d6b::{closure:{closure:__TwigTemplate_a7df698b49b513dadba7c2ef80c99d6b::loadDeclaredMacros():304}:314} (line 323)
10	Twig\Extension\CoreExtension->captureOutput (line 2208)
11	__TwigTemplate_a7df698b49b513dadba7c2ef80c99d6b::{closure:__TwigTemplate_a7df698b49b513dadba7c2ef80c99d6b::loadDeclaredMacros():304} (line 314)
12	Twig\TwigMacro->callLegacy (line 100)
13	Twig\MacroNamespace->call (line 57)
14	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad->block_jsonld (line 223)
15	Twig\Template->yieldBlock (line 493)
16	__TwigTemplate_d44bfb2c02fc90bc19da4a389d74d244->doDisplay (line 133)
17	Twig\Template->yield (line 461)
18	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad->doDisplay (line 77)
19	Twig\Template->yield (line 461)
20	Twig\Template->display (line 416)
21	Twig\Template->render (line 431)
22	Twig\TemplateWrapper->render (line 53)
23	Twig\Environment->render (line 343)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\SpaceController->show (line 37)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
30	Symfony\Component\HttpKernel\Kernel->handle (line 205)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 5)

0.36 ms
(26.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.tagline AS tagline_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.body AS body_7, t0.capacity AS capacity_8, t0.ambiance AS ambiance_9, t0.facts AS facts_10, t0.equipments AS equipments_11, t0.hero_title AS hero_title_12, t0.hero_lead AS hero_lead_13, t0.hero_info AS hero_info_14, t0.image AS image_15, t0.image_alt AS image_alt_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.position AS position_19, t0.published AS published_20 FROM space t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "mezzanine"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.tagline AS tagline_4,
  t0.short_description AS short_description_5,
  t0.description AS description_6,
  t0.body AS body_7,
  t0.capacity AS capacity_8,
  t0.ambiance AS ambiance_9,
  t0.facts AS facts_10,
  t0.equipments AS equipments_11,
  t0.hero_title AS hero_title_12,
  t0.hero_lead AS hero_lead_13,
  t0.hero_info AS hero_info_14,
  t0.image AS image_15,
  t0.image_alt AS image_alt_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.position AS position_19,
  t0.published AS published_20
FROM
  space t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.tagline AS tagline_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.body AS body_7, t0.capacity AS capacity_8, t0.ambiance AS ambiance_9, t0.facts AS facts_10, t0.equipments AS equipments_11, t0.hero_title AS hero_title_12, t0.hero_lead AS hero_lead_13, t0.hero_info AS hero_info_14, t0.image AS image_15, t0.image_alt AS image_alt_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.position AS position_19, t0.published AS published_20 FROM space t0 WHERE t0.slug = 'mezzanine' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 89)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 187)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
10	Symfony\Component\HttpKernel\Kernel->handle (line 205)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.19 ms
(13.57%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.tagline AS tagline_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.body AS body_7, t0.capacity AS capacity_8, t0.ambiance AS ambiance_9, t0.facts AS facts_10, t0.equipments AS equipments_11, t0.hero_title AS hero_title_12, t0.hero_lead AS hero_lead_13, t0.hero_info AS hero_info_14, t0.image AS image_15, t0.image_alt AS image_alt_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.position AS position_19, t0.published AS published_20 FROM space t0 WHERE t0.published = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.tagline AS tagline_4,
  t0.short_description AS short_description_5,
  t0.description AS description_6,
  t0.body AS body_7,
  t0.capacity AS capacity_8,
  t0.ambiance AS ambiance_9,
  t0.facts AS facts_10,
  t0.equipments AS equipments_11,
  t0.hero_title AS hero_title_12,
  t0.hero_lead AS hero_lead_13,
  t0.hero_info AS hero_info_14,
  t0.image AS image_15,
  t0.image_alt AS image_alt_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.position AS position_19,
  t0.published AS published_20
FROM
  space t0
WHERE
  t0.published = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.tagline AS tagline_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.body AS body_7, t0.capacity AS capacity_8, t0.ambiance AS ambiance_9, t0.facts AS facts_10, t0.equipments AS equipments_11, t0.hero_title AS hero_title_12, t0.hero_lead AS hero_lead_13, t0.hero_info AS hero_info_14, t0.image AS image_15, t0.image_alt AS image_alt_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.position AS position_19, t0.published AS published_20 FROM space t0 WHERE t0.published = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 81)
4	App\Repository\SpaceRepository->findPublished (line 22)
5	App\Controller\SpaceController->show (line 39)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
8	Symfony\Component\HttpKernel\Kernel->handle (line 205)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.18 ms
(12.78%)

SELECT t0.id AS id_1, t0.alt AS alt_2, t0.position AS position_3, t0.space_id AS space_id_4, t0.photo_id AS photo_id_5 FROM space_photo t0 WHERE t0.space_id = ? ORDER BY t0.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.alt AS alt_2,
  t0.position AS position_3,
  t0.space_id AS space_id_4,
  t0.photo_id AS photo_id_5
FROM
  space_photo t0
WHERE
  t0.space_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.alt AS alt_2, t0.position AS position_3, t0.space_id AS space_id_4, t0.photo_id AS photo_id_5 FROM space_photo t0 WHERE t0.space_id = 2 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->length (line 1299)
9	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad::block_body (line 331)
10	Twig\Template->yieldBlock (line 493)
11	__TwigTemplate_d44bfb2c02fc90bc19da4a389d74d244->doDisplay (line 442)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad->doDisplay (line 77)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Environment->render (line 343)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\SpaceController->show (line 37)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
25	Symfony\Component\HttpKernel\Kernel->handle (line 205)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.13 ms
(9.15%)

SELECT t0.id AS id_1, t0.file AS file_2, t0.alt AS alt_3, t0.created_at AS created_at_4 FROM photo t0 WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.alt AS alt_3,
  t0.created_at AS created_at_4
FROM
  photo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.alt AS alt_3, t0.created_at AS created_at_4 FROM photo t0 WHERE t0.id = 20;

#	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():338} (line 339)
4	Proxies\__CG__\App\Entity\Photo::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():415}:416} (line 417)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Photo->__get (line 153)
7	App\Entity\Photo->getFile (line 49)
8	Twig\Extension\CoreExtension->getAttribute (line 1996)
9	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad::block_body (line 362)
10	Twig\Template->yieldBlock (line 493)
11	__TwigTemplate_d44bfb2c02fc90bc19da4a389d74d244->doDisplay (line 442)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad->doDisplay (line 77)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Environment->render (line 343)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\SpaceController->show (line 37)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
25	Symfony\Component\HttpKernel\Kernel->handle (line 205)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.06 ms
(4.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_suffix AS price_suffix_4, t0.items AS items_5, t0.badge AS badge_6, t0.featured AS featured_7, t0.show_on_spaces AS show_on_spaces_8, t0.position AS position_9, t0.occasion_id AS occasion_id_10, t0.animation_id AS animation_id_11 FROM formula t0 WHERE t0.show_on_spaces = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.price_suffix AS price_suffix_4,
  t0.items AS items_5,
  t0.badge AS badge_6,
  t0.featured AS featured_7,
  t0.show_on_spaces AS show_on_spaces_8,
  t0.position AS position_9,
  t0.occasion_id AS occasion_id_10,
  t0.animation_id AS animation_id_11
FROM
  formula t0
WHERE
  t0.show_on_spaces = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_suffix AS price_suffix_4, t0.items AS items_5, t0.badge AS badge_6, t0.featured AS featured_7, t0.show_on_spaces AS show_on_spaces_8, t0.position AS position_9, t0.occasion_id AS occasion_id_10, t0.animation_id AS animation_id_11 FROM formula t0 WHERE t0.show_on_spaces = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 81)
4	App\Repository\FormulaRepository->findForSpaces (line 22)
5	App\Controller\SpaceController->show (line 40)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
8	Symfony\Component\HttpKernel\Kernel->handle (line 205)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.05 ms
(3.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category AS category_4, t0.short_description AS short_description_5, t0.card_meta AS card_meta_6, t0.hero_title AS hero_title_7, t0.hero_lead AS hero_lead_8, t0.hero_info AS hero_info_9, t0.hero_image AS hero_image_10, t0.image AS image_11, t0.image_alt AS image_alt_12, t0.formulas_intro AS formulas_intro_13, t0.timeline AS timeline_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.position AS position_17, t0.published AS published_18 FROM occasion t0 INNER JOIN space_occasion ON t0.id = space_occasion.occasion_id WHERE space_occasion.space_id = ? ORDER BY t0.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.category AS category_4,
  t0.short_description AS short_description_5,
  t0.card_meta AS card_meta_6,
  t0.hero_title AS hero_title_7,
  t0.hero_lead AS hero_lead_8,
  t0.hero_info AS hero_info_9,
  t0.hero_image AS hero_image_10,
  t0.image AS image_11,
  t0.image_alt AS image_alt_12,
  t0.formulas_intro AS formulas_intro_13,
  t0.timeline AS timeline_14,
  t0.meta_title AS meta_title_15,
  t0.meta_description AS meta_description_16,
  t0.position AS position_17,
  t0.published AS published_18
FROM
  occasion t0
  INNER JOIN space_occasion ON t0.id = space_occasion.occasion_id
WHERE
  space_occasion.space_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category AS category_4, t0.short_description AS short_description_5, t0.card_meta AS card_meta_6, t0.hero_title AS hero_title_7, t0.hero_lead AS hero_lead_8, t0.hero_info AS hero_info_9, t0.hero_image AS hero_image_10, t0.image AS image_11, t0.image_alt AS image_alt_12, t0.formulas_intro AS formulas_intro_13, t0.timeline AS timeline_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.position AS position_17, t0.published AS published_18 FROM occasion t0 INNER JOIN space_occasion ON t0.id = space_occasion.occasion_id WHERE space_occasion.space_id = 2 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->length (line 1299)
9	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad::block_body (line 455)
10	Twig\Template->yieldBlock (line 493)
11	__TwigTemplate_d44bfb2c02fc90bc19da4a389d74d244->doDisplay (line 442)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_c9f08c89df0098e7a2144af58951ecad->doDisplay (line 77)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Environment->render (line 343)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\SpaceController->show (line 37)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
25	Symfony\Component\HttpKernel\Kernel->handle (line 205)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Space	4
App\Entity\Formula	4
App\Entity\Occasion	4
App\Entity\Faq	4
App\Entity\SpacePhoto	3
App\Entity\Photo	3

Entities Mapping

Class	Mapping errors
App\Entity\Space	No errors.
App\Entity\Occasion	No errors.
App\Entity\Faq	No errors.
App\Entity\SpacePhoto	No errors.
App\Entity\Formula	No errors.
App\Entity\Animation	No errors.
App\Entity\Photo	No errors.

Symfony Profiler

GET https://dolcecapanna.echodigital.fr/privatisation/mezzanine/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping