Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.59 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.45 ms

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_4feb2330d0f2667f11e359bb2000b948->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->menu (line 26)
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.24 ms

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.subtitle AS subtitle_2, c0_.selection_label AS selection_label_3, c0_.updated_at AS updated_at_4 FROM cms_menu_page c0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.subtitle AS subtitle_2,
  c0_.selection_label AS selection_label_3,
  c0_.updated_at AS updated_at_4
FROM
  cms_menu_page c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.subtitle AS subtitle_2, c0_.selection_label AS selection_label_3, c0_.updated_at AS updated_at_4 FROM cms_menu_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\CmsMenuPageRepository->getSingleton (line 24)
7	App\Bundle\CoreBundle\Twig\Runtime\CmsRuntime->menu (line 87)
8	__TwigTemplate_4feb2330d0f2667f11e359bb2000b948->block_body (line 124)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_4feb2330d0f2667f11e359bb2000b948->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->menu (line 26)
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.61 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.position AS position_3, c0_.is_visible AS is_visible_4, c0_.updated_at AS updated_at_5, c1_.id AS id_6, c1_.name AS name_7, c1_.description AS description_8, c1_.image_path AS image_path_9, c1_.price_small_label AS price_small_label_10, c1_.price_small_cents AS price_small_cents_11, c1_.price_large_label AS price_large_label_12, c1_.price_large_cents AS price_large_cents_13, c1_.badge AS badge_14, c1_.is_available AS is_available_15, c1_.is_featured AS is_featured_16, c1_.position AS position_17, c1_.updated_at AS updated_at_18, c0_.menu_page_id AS menu_page_id_19, c1_.category_id AS category_id_20 FROM cms_menu_category c0_ LEFT JOIN cms_menu_item c1_ ON c0_.id = c1_.category_id AND (c1_.is_available = 1) WHERE c0_.is_visible = 1 ORDER BY c0_.position ASC, c0_.id ASC, c1_.position ASC, c1_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.position AS position_3,
  c0_.is_visible AS is_visible_4,
  c0_.updated_at AS updated_at_5,
  c1_.id AS id_6,
  c1_.name AS name_7,
  c1_.description AS description_8,
  c1_.image_path AS image_path_9,
  c1_.price_small_label AS price_small_label_10,
  c1_.price_small_cents AS price_small_cents_11,
  c1_.price_large_label AS price_large_label_12,
  c1_.price_large_cents AS price_large_cents_13,
  c1_.badge AS badge_14,
  c1_.is_available AS is_available_15,
  c1_.is_featured AS is_featured_16,
  c1_.position AS position_17,
  c1_.updated_at AS updated_at_18,
  c0_.menu_page_id AS menu_page_id_19,
  c1_.category_id AS category_id_20
FROM
  cms_menu_category c0_
  LEFT JOIN cms_menu_item c1_ ON c0_.id = c1_.category_id
  AND (c1_.is_available = 1)
WHERE
  c0_.is_visible = 1
ORDER BY
  c0_.position ASC,
  c0_.id ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.position AS position_3, c0_.is_visible AS is_visible_4, c0_.updated_at AS updated_at_5, c1_.id AS id_6, c1_.name AS name_7, c1_.description AS description_8, c1_.image_path AS image_path_9, c1_.price_small_label AS price_small_label_10, c1_.price_small_cents AS price_small_cents_11, c1_.price_large_label AS price_large_label_12, c1_.price_large_cents AS price_large_cents_13, c1_.badge AS badge_14, c1_.is_available AS is_available_15, c1_.is_featured AS is_featured_16, c1_.position AS position_17, c1_.updated_at AS updated_at_18, c0_.menu_page_id AS menu_page_id_19, c1_.category_id AS category_id_20 FROM cms_menu_category c0_ LEFT JOIN cms_menu_item c1_ ON c0_.id = c1_.category_id AND (c1_.is_available = 1) WHERE c0_.is_visible = 1 ORDER BY c0_.position ASC, c0_.id ASC, c1_.position ASC, c1_.id ASC;

#	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->getResult (line 688)
6	App\Bundle\CoreBundle\Repository\CmsMenuCategoryRepository->findVisibleOrdered (line 33)
7	App\Bundle\CoreBundle\Twig\Runtime\CmsRuntime->menuCategories (line 94)
8	__TwigTemplate_4feb2330d0f2667f11e359bb2000b948->block_body (line 126)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_4feb2330d0f2667f11e359bb2000b948->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->menu (line 26)
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.30 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.image_path AS image_path_3, c0_.price_small_label AS price_small_label_4, c0_.price_small_cents AS price_small_cents_5, c0_.price_large_label AS price_large_label_6, c0_.price_large_cents AS price_large_cents_7, c0_.badge AS badge_8, c0_.is_available AS is_available_9, c0_.is_featured AS is_featured_10, c0_.position AS position_11, c0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.position AS position_16, c1_.is_visible AS is_visible_17, c1_.updated_at AS updated_at_18, c0_.category_id AS category_id_19, c1_.menu_page_id AS menu_page_id_20 FROM cms_menu_item c0_ LEFT JOIN cms_menu_category c1_ ON c0_.category_id = c1_.id WHERE c0_.is_featured = 1 AND c0_.is_available = 1 ORDER BY c0_.updated_at DESC, c0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.image_path AS image_path_3,
  c0_.price_small_label AS price_small_label_4,
  c0_.price_small_cents AS price_small_cents_5,
  c0_.price_large_label AS price_large_label_6,
  c0_.price_large_cents AS price_large_cents_7,
  c0_.badge AS badge_8,
  c0_.is_available AS is_available_9,
  c0_.is_featured AS is_featured_10,
  c0_.position AS position_11,
  c0_.updated_at AS updated_at_12,
  c1_.id AS id_13,
  c1_.name AS name_14,
  c1_.description AS description_15,
  c1_.position AS position_16,
  c1_.is_visible AS is_visible_17,
  c1_.updated_at AS updated_at_18,
  c0_.category_id AS category_id_19,
  c1_.menu_page_id AS menu_page_id_20
FROM
  cms_menu_item c0_
  LEFT JOIN cms_menu_category c1_ ON c0_.category_id = c1_.id
WHERE
  c0_.is_featured = 1
  AND c0_.is_available = 1
ORDER BY
  c0_.updated_at DESC,
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.image_path AS image_path_3, c0_.price_small_label AS price_small_label_4, c0_.price_small_cents AS price_small_cents_5, c0_.price_large_label AS price_large_label_6, c0_.price_large_cents AS price_large_cents_7, c0_.badge AS badge_8, c0_.is_available AS is_available_9, c0_.is_featured AS is_featured_10, c0_.position AS position_11, c0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.position AS position_16, c1_.is_visible AS is_visible_17, c1_.updated_at AS updated_at_18, c0_.category_id AS category_id_19, c1_.menu_page_id AS menu_page_id_20 FROM cms_menu_item c0_ LEFT JOIN cms_menu_category c1_ ON c0_.category_id = c1_.id WHERE c0_.is_featured = 1 AND c0_.is_available = 1 ORDER BY c0_.updated_at DESC, c0_.id DESC 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\CmsMenuItemRepository->findFeatured (line 46)
7	App\Bundle\CoreBundle\Twig\Runtime\CmsRuntime->featuredMenuItem (line 104)
8	__TwigTemplate_4feb2330d0f2667f11e359bb2000b948->block_body (line 128)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_2c4bc99f34bad8d25bbabd47c735ca88->doDisplay (line 169)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_4feb2330d0f2667f11e359bb2000b948->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->menu (line 26)
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\CmsMenuCategory	2
App\Bundle\CoreBundle\Entity\CmsMenuPage	1
App\Bundle\CoreBundle\Entity\CmsMenuItem	1

Entities Mapping

Class	Mapping errors
App\Bundle\CoreBundle\Entity\CmsSiteSettings	No errors.
App\Bundle\CoreBundle\Entity\CmsMenuPage	No errors.
App\Bundle\CoreBundle\Entity\CmsMenuCategory	No errors.
App\Bundle\CoreBundle\Entity\CmsMenuItem	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping