Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.00 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.48 ms
(23.91%)

SELECT c0_.id AS id_0, c0_.hero_title AS hero_title_1, c0_.intro_title AS intro_title_2, c0_.intro_left_text AS intro_left_text_3, c0_.intro_right_text AS intro_right_text_4, c0_.key_dates_title AS key_dates_title_5, c0_.story_title AS story_title_6, c0_.story_subtitle AS story_subtitle_7, c0_.concepts_title AS concepts_title_8, c0_.offer_banner_text AS offer_banner_text_9, c0_.lead_title AS lead_title_10, c0_.lead_subtitle AS lead_subtitle_11, c0_.lead_legal AS lead_legal_12, c0_.gallery_title AS gallery_title_13, c0_.newsletter_title AS newsletter_title_14, c0_.newsletter_subtitle AS newsletter_subtitle_15, c0_.newsletter_legal AS newsletter_legal_16, c0_.updated_at AS updated_at_17 FROM cms_franchise_page c0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.hero_title AS hero_title_1,
  c0_.intro_title AS intro_title_2,
  c0_.intro_left_text AS intro_left_text_3,
  c0_.intro_right_text AS intro_right_text_4,
  c0_.key_dates_title AS key_dates_title_5,
  c0_.story_title AS story_title_6,
  c0_.story_subtitle AS story_subtitle_7,
  c0_.concepts_title AS concepts_title_8,
  c0_.offer_banner_text AS offer_banner_text_9,
  c0_.lead_title AS lead_title_10,
  c0_.lead_subtitle AS lead_subtitle_11,
  c0_.lead_legal AS lead_legal_12,
  c0_.gallery_title AS gallery_title_13,
  c0_.newsletter_title AS newsletter_title_14,
  c0_.newsletter_subtitle AS newsletter_subtitle_15,
  c0_.newsletter_legal AS newsletter_legal_16,
  c0_.updated_at AS updated_at_17
FROM
  cms_franchise_page c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.hero_title AS hero_title_1, c0_.intro_title AS intro_title_2, c0_.intro_left_text AS intro_left_text_3, c0_.intro_right_text AS intro_right_text_4, c0_.key_dates_title AS key_dates_title_5, c0_.story_title AS story_title_6, c0_.story_subtitle AS story_subtitle_7, c0_.concepts_title AS concepts_title_8, c0_.offer_banner_text AS offer_banner_text_9, c0_.lead_title AS lead_title_10, c0_.lead_subtitle AS lead_subtitle_11, c0_.lead_legal AS lead_legal_12, c0_.gallery_title AS gallery_title_13, c0_.newsletter_title AS newsletter_title_14, c0_.newsletter_subtitle AS newsletter_subtitle_15, c0_.newsletter_legal AS newsletter_legal_16, c0_.updated_at AS updated_at_17 FROM cms_franchise_page c0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Bundle\CoreBundle\Repository\CmsFranchisePageRepository->getSingleton (line 24)
7	App\Bundle\CoreBundle\Twig\Runtime\CmsRuntime->franchise (line 67)
8	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->block_body (line 124)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
21	App\Bundle\CoreBundle\Controller\LandingController->franchise (line 20)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.46 ms
(22.86%)

SELECT c0_.id AS id_0, c0_.instagram_url AS instagram_url_1, c0_.facebook_url AS facebook_url_2, c0_.contact_email AS contact_email_3, c0_.contact_phone AS contact_phone_4, c0_.contact_address AS contact_address_5, c0_.order_url AS order_url_6, c0_.footer_credit AS footer_credit_7, c0_.footer_tagline AS footer_tagline_8, c0_.updated_at AS updated_at_9 FROM cms_site_settings c0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.instagram_url AS instagram_url_1,
  c0_.facebook_url AS facebook_url_2,
  c0_.contact_email AS contact_email_3,
  c0_.contact_phone AS contact_phone_4,
  c0_.contact_address AS contact_address_5,
  c0_.order_url AS order_url_6,
  c0_.footer_credit AS footer_credit_7,
  c0_.footer_tagline AS footer_tagline_8,
  c0_.updated_at AS updated_at_9
FROM
  cms_site_settings c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.instagram_url AS instagram_url_1, c0_.facebook_url AS facebook_url_2, c0_.contact_email AS contact_email_3, c0_.contact_phone AS contact_phone_4, c0_.contact_address AS contact_address_5, c0_.order_url AS order_url_6, c0_.footer_credit AS footer_credit_7, c0_.footer_tagline AS footer_tagline_8, c0_.updated_at AS updated_at_9 FROM cms_site_settings c0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Bundle\CoreBundle\Repository\CmsSiteSettingsRepository->getSingleton (line 24)
7	App\Bundle\CoreBundle\Twig\Runtime\CmsRuntime->site (line 47)
8	__TwigTemplate_8a214c7752e867566745fd656e0c96a5->doDisplay (line 63)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->block_header (line 590)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 166)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->doDisplay (line 55)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
23	App\Bundle\CoreBundle\Controller\LandingController->franchise (line 20)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.36 ms
(17.86%)

SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.description AS description_4, t0.image_path AS image_path_5, t0.position AS position_6, t0.updated_at AS updated_at_7, t0.franchise_page_id AS franchise_page_id_8 FROM cms_franchise_key_date t0 WHERE t0.franchise_page_id = ? ORDER BY t0.position ASC, t0.year ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.image_path AS image_path_5,
  t0.position AS position_6,
  t0.updated_at AS updated_at_7,
  t0.franchise_page_id AS franchise_page_id_8
FROM
  cms_franchise_key_date t0
WHERE
  t0.franchise_page_id = ?
ORDER BY
  t0.position ASC,
  t0.year ASC

SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.description AS description_4, t0.image_path AS image_path_5, t0.position AS position_6, t0.updated_at AS updated_at_7, t0.franchise_page_id AS franchise_page_id_8 FROM cms_franchise_key_date t0 WHERE t0.franchise_page_id = 1 ORDER BY t0.position ASC, t0.year ASC;

#	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 313)
7	Twig\Extension\CoreExtension->slice (line 755)
8	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999::block_body (line 175)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
21	App\Bundle\CoreBundle\Controller\LandingController->franchise (line 20)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.29 ms
(14.26%)

SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.updated_at AS updated_at_6, t0.franchise_page_id AS franchise_page_id_7 FROM cms_franchise_story_item t0 WHERE t0.franchise_page_id = ? ORDER BY t0.position ASC, t0.year ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.position AS position_5,
  t0.updated_at AS updated_at_6,
  t0.franchise_page_id AS franchise_page_id_7
FROM
  cms_franchise_story_item t0
WHERE
  t0.franchise_page_id = ?
ORDER BY
  t0.position ASC,
  t0.year ASC

SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.updated_at AS updated_at_6, t0.franchise_page_id AS franchise_page_id_7 FROM cms_franchise_story_item t0 WHERE t0.franchise_page_id = 1 ORDER BY t0.position ASC, t0.year ASC;

#	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 313)
7	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->block_body (line 320)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Bundle\CoreBundle\Controller\LandingController->franchise (line 20)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.21 ms
(10.61%)

SELECT t0.id AS id_1, t0.zone_label AS zone_label_2, t0.title AS title_3, t0.image_path AS image_path_4, t0.surface AS surface_5, t0.service AS service_6, t0.ca_estimated AS ca_estimated_7, t0.apport_minimum AS apport_minimum_8, t0.redevance AS redevance_9, t0.concept_label AS concept_label_10, t0.position AS position_11, t0.updated_at AS updated_at_12, t0.franchise_page_id AS franchise_page_id_13 FROM cms_franchise_concept t0 WHERE t0.franchise_page_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.zone_label AS zone_label_2,
  t0.title AS title_3,
  t0.image_path AS image_path_4,
  t0.surface AS surface_5,
  t0.service AS service_6,
  t0.ca_estimated AS ca_estimated_7,
  t0.apport_minimum AS apport_minimum_8,
  t0.redevance AS redevance_9,
  t0.concept_label AS concept_label_10,
  t0.position AS position_11,
  t0.updated_at AS updated_at_12,
  t0.franchise_page_id AS franchise_page_id_13
FROM
  cms_franchise_concept t0
WHERE
  t0.franchise_page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.zone_label AS zone_label_2, t0.title AS title_3, t0.image_path AS image_path_4, t0.surface AS surface_5, t0.service AS service_6, t0.ca_estimated AS ca_estimated_7, t0.apport_minimum AS apport_minimum_8, t0.redevance AS redevance_9, t0.concept_label AS concept_label_10, t0.position AS position_11, t0.updated_at AS updated_at_12, t0.franchise_page_id AS franchise_page_id_13 FROM cms_franchise_concept t0 WHERE t0.franchise_page_id = 1 ORDER BY t0.position ASC;

#	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 313)
7	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->block_body (line 359)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Bundle\CoreBundle\Controller\LandingController->franchise (line 20)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.21 ms
(10.50%)

SELECT c0_.id AS id_0, c0_.gallery_title AS gallery_title_1, c0_.newsletter_title AS newsletter_title_2, c0_.newsletter_subtitle AS newsletter_subtitle_3, c0_.newsletter_legal AS newsletter_legal_4, c0_.updated_at AS updated_at_5 FROM cms_global_blocks c0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.gallery_title AS gallery_title_1,
  c0_.newsletter_title AS newsletter_title_2,
  c0_.newsletter_subtitle AS newsletter_subtitle_3,
  c0_.newsletter_legal AS newsletter_legal_4,
  c0_.updated_at AS updated_at_5
FROM
  cms_global_blocks c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.gallery_title AS gallery_title_1, c0_.newsletter_title AS newsletter_title_2, c0_.newsletter_subtitle AS newsletter_subtitle_3, c0_.newsletter_legal AS newsletter_legal_4, c0_.updated_at AS updated_at_5 FROM cms_global_blocks c0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Bundle\CoreBundle\Repository\CmsGlobalBlocksRepository->getSingleton (line 24)
7	App\Bundle\CoreBundle\Twig\Runtime\CmsRuntime->global (line 77)
8	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->block_body (line 126)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_a2569d6cac1742e1f357d27c4d973999->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
21	App\Bundle\CoreBundle\Controller\LandingController->franchise (line 20)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Bundle\CoreBundle\Entity\CmsFranchiseKeyDate	5
App\Bundle\CoreBundle\Entity\CmsFranchiseStoryItem	4
App\Bundle\CoreBundle\Entity\CmsFranchiseConcept	2
App\Bundle\CoreBundle\Entity\CmsFranchisePage	1

Entities Mapping

Class	Mapping errors
App\Bundle\CoreBundle\Entity\CmsSiteSettings	No errors.
App\Bundle\CoreBundle\Entity\CmsFranchisePage	No errors.
App\Bundle\CoreBundle\Entity\CmsFranchiseKeyDate	No errors.
App\Bundle\CoreBundle\Entity\CmsFranchiseStoryItem	No errors.
App\Bundle\CoreBundle\Entity\CmsFranchiseConcept	No errors.
App\Bundle\CoreBundle\Entity\CmsGlobalBlocks	No errors.

Symfony Profiler

GET https://authenticspizza.tejia.fr/franchise

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping