Symfony Profiler

Query Metrics

7 Database Queries

3 Different statements

2.36 ms Query time

0 Invalid entities

15 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.77 ms
(75.09%)

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:

[
  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.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 = 1 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->getIterator (line 315)
7	Twig\Extension\CoreExtension->map (line 2111)
8	__TwigTemplate_e01a49aad272aaf69415fbdb28e7fe53::block_body (line 325)
9	Twig\Template->yieldBlock (line 493)
10	__TwigTemplate_d44bfb2c02fc90bc19da4a389d74d244->doDisplay (line 442)
11	Twig\Template->yield (line 461)
12	__TwigTemplate_e01a49aad272aaf69415fbdb28e7fe53->doDisplay (line 67)
13	Twig\Template->yield (line 461)
14	Twig\Template->display (line 416)
15	Twig\Template->render (line 431)
16	Twig\TemplateWrapper->render (line 53)
17	Twig\Environment->render (line 343)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\SpaceController->index (line 21)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
24	Symfony\Component\HttpKernel\Kernel->handle (line 205)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.37 ms
(15.74%)

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.page = ? ORDER BY t0.position ASC

Parameters:

[
  "espaces"
]

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.page = ?
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.page = 'espaces' 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\FaqRepository->findForPage (line 22)
5	App\Controller\SpaceController->index (line 23)
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.22 ms
(9.17%)

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->index (line 22)
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)

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\Occasion	7
App\Entity\Space	4
App\Entity\Faq	4

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\Animation	No errors.
App\Entity\Formula	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping