Symfony Profiler

Query Metrics

12 Database Queries

10 Different statements

3.14 ms Query time

0 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.46 ms
(14.49%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 INNER JOIN page_image ON t0.id = page_image.image_id WHERE page_image.page_id = ? ORDER BY t0.position ASC

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.updated_at AS updated_at_3,
  t0.alt_image AS alt_image_4,
  t0.alt_image_ca AS alt_image_ca_5,
  t0.alt_image_es AS alt_image_es_6,
  t0.alt_image_fr AS alt_image_fr_7,
  t0.alt_image_en AS alt_image_en_8,
  t0.alt_image_it AS alt_image_it_9,
  t0.alt_image_kr AS alt_image_kr_10,
  t0.desc_image AS desc_image_11,
  t0.desc_image_ca AS desc_image_ca_12,
  t0.desc_image_es AS desc_image_es_13,
  t0.desc_image_fr AS desc_image_fr_14,
  t0.desc_image_en AS desc_image_en_15,
  t0.desc_image_it AS desc_image_it_16,
  t0.desc_image_kr AS desc_image_kr_17,
  t0.position AS position_18
FROM
  image t0
  INNER JOIN page_image ON t0.id = page_image.image_id
WHERE
  page_image.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 INNER JOIN page_image ON t0.id = page_image.image_id WHERE page_image.page_id = 9 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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b::block_body (line 243)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_13661e98574f0c4171cb0c1ed01d53d8->doDisplay (line 129)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
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\SurroundsController->surroundsIndex (line 39)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.45 ms
(14.38%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_published AS is_published_3,
  t0.position AS position_4,
  t0.main_image_id AS main_image_id_5
FROM
  room t0
WHERE
  t0.is_published = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\CommonController->roomsMenu (line 51)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_f6f894de3056f9b6f5686b824cf42bcb->doDisplay (line 170)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_13661e98574f0c4171cb0c1ed01d53d8->doDisplay (line 120)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\SurroundsController->surroundsIndex (line 39)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.44 ms
(14.01%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.position AS position_4
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Language::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Language->__get (line 153)
7	App\Entity\Language->getCode (line 66)
8	App\Entity\Page->getContentByLocale (line 27)
9	App\Controller\SurroundsController->surroundsIndex (line 29)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.39 ms
(12.41%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1

Parameters:

[
  1
  "ca"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.intro AS intro_5,
  t0.body AS body_6,
  t0.room_id AS room_id_7,
  t0.language_id AS language_id_8,
  t0.seo_id AS seo_id_9
FROM
  room_content t0
WHERE
  t0.room_id = ?
  AND t0.language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = 1 AND t0.language_id = 'ca' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\CommonController->roomsMenu (line 54)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_f6f894de3056f9b6f5686b824cf42bcb->doDisplay (line 170)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_13661e98574f0c4171cb0c1ed01d53d8->doDisplay (line 120)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\SurroundsController->surroundsIndex (line 39)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.31 ms
(9.86%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.icon AS icon_4, t0.updated_at AS updated_at_5, t0.is_published AS is_published_6, t0.parent_id AS parent_id_7 FROM surround t0 WHERE t0.is_published = ? AND t0.parent_id IS NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.icon AS icon_4,
  t0.updated_at AS updated_at_5,
  t0.is_published AS is_published_6,
  t0.parent_id AS parent_id_7
FROM
  surround t0
WHERE
  t0.is_published = ?
  AND t0.parent_id IS NULL

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.icon AS icon_4, t0.updated_at AS updated_at_5, t0.is_published AS is_published_6, t0.parent_id AS parent_id_7 FROM surround t0 WHERE t0.is_published = 1 AND t0.parent_id IS NULL;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\SurroundsController->surroundsIndex (line 32)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.28 ms
(8.88%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.updated_at AS updated_at_4, t0.is_published AS is_published_5, t0.video AS video_6, t0.main_image_id AS main_image_id_7 FROM page t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "surrounds_index"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.title AS title_3,
  t0.updated_at AS updated_at_4,
  t0.is_published AS is_published_5,
  t0.video AS video_6,
  t0.main_image_id AS main_image_id_7
FROM
  page t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.updated_at AS updated_at_4, t0.is_published AS is_published_5, t0.video AS video_6, t0.main_image_id AS main_image_id_7 FROM page t0 WHERE t0.code = 'surrounds_index' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\SurroundsController->surroundsIndex (line 28)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.22 ms
(6.84%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.introduction AS introduction_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7, t0.seo_id AS seo_id_8 FROM page_content t0 WHERE t0.page_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.slug AS slug_4,
  t0.introduction AS introduction_5,
  t0.page_id AS page_id_6,
  t0.language_id AS language_id_7,
  t0.seo_id AS seo_id_8
FROM
  page_content t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.introduction AS introduction_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7, t0.seo_id AS seo_id_8 FROM page_content t0 WHERE t0.page_id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Page->getContentByLocale (line 26)
8	App\Controller\SurroundsController->surroundsIndex (line 29)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.21 ms
(6.59%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.body AS body_5, t0.rate AS rate_6, t0.is_published AS is_published_7, t0.language_id AS language_id_8 FROM review t0 WHERE t0.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.title AS title_3,
  t0.subtitle AS subtitle_4,
  t0.body AS body_5,
  t0.rate AS rate_6,
  t0.is_published AS is_published_7,
  t0.language_id AS language_id_8
FROM
  review t0
WHERE
  t0.is_published = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.body AS body_5, t0.rate AS rate_6, t0.is_published AS is_published_7, t0.language_id AS language_id_8 FROM review t0 WHERE t0.is_published = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\CommonController->reviews (line 19)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b->block_body (line 273)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_13661e98574f0c4171cb0c1ed01d53d8->doDisplay (line 129)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\SurroundsController->surroundsIndex (line 39)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.20 ms
(6.43%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 WHERE t0.id = ?

Parameters:

[
  82
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.updated_at AS updated_at_3,
  t0.alt_image AS alt_image_4,
  t0.alt_image_ca AS alt_image_ca_5,
  t0.alt_image_es AS alt_image_es_6,
  t0.alt_image_fr AS alt_image_fr_7,
  t0.alt_image_en AS alt_image_en_8,
  t0.alt_image_it AS alt_image_it_9,
  t0.alt_image_kr AS alt_image_kr_10,
  t0.desc_image AS desc_image_11,
  t0.desc_image_ca AS desc_image_ca_12,
  t0.desc_image_es AS desc_image_es_13,
  t0.desc_image_fr AS desc_image_fr_14,
  t0.desc_image_en AS desc_image_en_15,
  t0.desc_image_it AS desc_image_it_16,
  t0.desc_image_kr AS desc_image_kr_17,
  t0.position AS position_18
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 WHERE t0.id = 82;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Image::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Image->__get (line 153)
7	App\Entity\Image->getImage (line 87)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b::block_body (line 155)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_13661e98574f0c4171cb0c1ed01d53d8->doDisplay (line 129)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
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\SurroundsController->surroundsIndex (line 39)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.19 ms
(6.12%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.intro AS intro_5,
  t0.body AS body_6,
  t0.room_id AS room_id_7,
  t0.language_id AS language_id_8,
  t0.seo_id AS seo_id_9
FROM
  room_content t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Room->getContentByLocale (line 26)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_895ee836528479951168ac57733f80ea::doDisplay (line 53)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\CommonController->roomsMenu (line 64)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
26	__TwigTemplate_f6f894de3056f9b6f5686b824cf42bcb->doDisplay (line 170)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_13661e98574f0c4171cb0c1ed01d53d8->doDisplay (line 120)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_9e9b670e6a2452d3b4ae0f549104628b->doDisplay (line 55)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\SurroundsController->surroundsIndex (line 39)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	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\Review	6
App\Entity\Image	5
App\Entity\Language	4
App\Entity\RoomContent	4
App\Entity\Seo	2
App\Entity\Page	1
App\Entity\PageContent	1
App\Entity\Room	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Image	No errors.
App\Entity\PageContent	No errors.
App\Entity\Language	No errors.
App\Entity\Seo	No errors.
App\Entity\ArticleContent	No errors.
App\Entity\ArticleCategoryContent	No errors.
App\Entity\Banner	No errors.
App\Entity\OfferContent	No errors.
App\Entity\Surround	No errors.
App\Entity\Room	No errors.
App\Entity\RoomContent	No errors.
App\Entity\RoomService	No errors.
App\Entity\Article	No errors.
App\Entity\ArticleCategory	No errors.
App\Entity\Offer	No errors.
App\Entity\SurroundContent	No errors.
App\Entity\RoomServiceContent	No errors.
App\Entity\HotelService	No errors.
App\Entity\User	No errors.
App\Entity\HotelServiceContent	No errors.
App\Entity\Review	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://novara-peninsular.mitica.net/ca/entorn

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping