Symfony Profiler

Query Metrics

42 Database Queries

13 Different statements

5.18 ms Query time

25 Invalid entities

71 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.52 ms
(29.25%)

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.agence AS agence_2,
  t0.agence_address AS agence_address_3,
  t0.agence_zip AS agence_zip_4,
  t0.agence_city AS agence_city_5,
  t0.agence_email AS agence_email_6,
  t0.agence_phone AS agence_phone_7,
  t0.agence_opening_hours AS agence_opening_hours_8,
  t0.agence_contact_url AS agence_contact_url_9,
  t0.agence_contact_latitude AS agence_contact_latitude_10,
  t0.agence_contact_longitude AS agence_contact_longitude_11,
  t0.agence_nethelium AS agence_nethelium_12,
  t0.agence_contact_zoom AS agence_contact_zoom_13,
  t0.breadcrumb AS breadcrumb_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.title AS title_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.affichage_menu AS affichage_menu_20,
  t0.slug AS slug_21,
  t0.display AS display_22,
  t0.no_index AS no_index_23,
  t0.primary_page AS primary_page_24,
  t0.parent_id AS parent_id_25
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.id = 19;

#	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__\Clockbox\Core\Entity\Page::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\Clockbox\Core\Entity\Page->__get (line 184)
7	Clockbox\Core\Entity\Page->getSlug (line 97)
8	Clockbox\Core\Entity\Page->getFullSlugPath (line 231)
9	Twig\Extension\CoreExtension->getAttribute (line 1928)
10	__TwigTemplate_0b0a29738af4176f6a93e9f6b927676c::doDisplay (line 80)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_afb97c0afaa9a34a66ad6ac4cbfb98ee->doDisplay (line 420)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
21	Clockbox\Core\Controller\PagesController->navBar (line 170)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
29	__TwigTemplate_e22043808d715c537e0ea18cd7751509->doDisplay (line 355)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_a94ba1f91dd1209921686469db236fe3->doDisplay (line 55)
32	Twig\Template->yield (line 411)
33	__TwigTemplate_16b2c7862f525aaf629b1ce1f7702fbc->doDisplay (line 59)
34	Twig\Template->yield (line 411)
35	__TwigTemplate_755bc63f374e7220b3a47e6b06c794da->doDisplay (line 55)
36	Twig\Template->yield (line 411)
37	Twig\Template->display (line 366)
38	Twig\Template->render (line 381)
39	Twig\TemplateWrapper->render (line 51)
40	Twig\Environment->render (line 333)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
44	Clockbox\Core\Controller\PagesController->pageSection (line 208)
45	Clockbox\Core\Controller\PagesController->returnPage (line 138)
46	Clockbox\Core\Controller\PagesController->index (line 57)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
49	Symfony\Component\HttpKernel\Kernel->handle (line 208)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
51	require_once (line 29)
52	require_once (line 5)

0.84 ms
(16.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.matomo_url AS matomo_url_18, t0.matomo_js AS matomo_js_19, t0.matomo_tracker AS matomo_tracker_20, t0.google_map AS google_map_21, t0.maintenance AS maintenance_22, t0.logo AS logo_23, t0.fav_icon AS fav_icon_24, t0.contact_url AS contact_url_25, t0.contact_background AS contact_background_26, t0.contact_latitude AS contact_latitude_27, t0.contact_longitude AS contact_longitude_28, t0.type_map AS type_map_29, t0.tarte_au_citron_url AS tarte_au_citron_url_30, t0.tarte_au_citron_js AS tarte_au_citron_js_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.default_blog_image AS default_blog_image_34, t0.default_auction_image AS default_auction_image_35 FROM site t0 WHERE t0.id = ? LIMIT 1

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.address AS address_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.opening_hours AS opening_hours_8,
  t0.net_helium AS net_helium_9,
  t0.facebook AS facebook_10,
  t0.twitter AS twitter_11,
  t0.instagram AS instagram_12,
  t0.linkedin AS linkedin_13,
  t0.youtube AS youtube_14,
  t0.gta AS gta_15,
  t0.gtm AS gtm_16,
  t0.matomo AS matomo_17,
  t0.matomo_url AS matomo_url_18,
  t0.matomo_js AS matomo_js_19,
  t0.matomo_tracker AS matomo_tracker_20,
  t0.google_map AS google_map_21,
  t0.maintenance AS maintenance_22,
  t0.logo AS logo_23,
  t0.fav_icon AS fav_icon_24,
  t0.contact_url AS contact_url_25,
  t0.contact_background AS contact_background_26,
  t0.contact_latitude AS contact_latitude_27,
  t0.contact_longitude AS contact_longitude_28,
  t0.type_map AS type_map_29,
  t0.tarte_au_citron_url AS tarte_au_citron_url_30,
  t0.tarte_au_citron_js AS tarte_au_citron_js_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.default_blog_image AS default_blog_image_34,
  t0.default_auction_image AS default_auction_image_35
FROM
  site t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.matomo_url AS matomo_url_18, t0.matomo_js AS matomo_js_19, t0.matomo_tracker AS matomo_tracker_20, t0.google_map AS google_map_21, t0.maintenance AS maintenance_22, t0.logo AS logo_23, t0.fav_icon AS fav_icon_24, t0.contact_url AS contact_url_25, t0.contact_background AS contact_background_26, t0.contact_latitude AS contact_latitude_27, t0.contact_longitude AS contact_longitude_28, t0.type_map AS type_map_29, t0.tarte_au_citron_url AS tarte_au_citron_url_30, t0.tarte_au_citron_js AS tarte_au_citron_js_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.default_blog_image AS default_blog_image_34, t0.default_auction_image AS default_auction_image_35 FROM site t0 WHERE t0.id = 1 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	Clockbox\Core\Service\SiteProvider->get (line 18)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 37)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.63 ms
(12.21%)

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.display = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.agence AS agence_2,
  t0.agence_address AS agence_address_3,
  t0.agence_zip AS agence_zip_4,
  t0.agence_city AS agence_city_5,
  t0.agence_email AS agence_email_6,
  t0.agence_phone AS agence_phone_7,
  t0.agence_opening_hours AS agence_opening_hours_8,
  t0.agence_contact_url AS agence_contact_url_9,
  t0.agence_contact_latitude AS agence_contact_latitude_10,
  t0.agence_contact_longitude AS agence_contact_longitude_11,
  t0.agence_nethelium AS agence_nethelium_12,
  t0.agence_contact_zoom AS agence_contact_zoom_13,
  t0.breadcrumb AS breadcrumb_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.title AS title_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.affichage_menu AS affichage_menu_20,
  t0.slug AS slug_21,
  t0.display AS display_22,
  t0.no_index AS no_index_23,
  t0.primary_page AS primary_page_24,
  t0.parent_id AS parent_id_25
FROM
  page t0
WHERE
  t0.display = ?

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.display = 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	Clockbox\Core\Service\PageProvider->getPagesOrderBySlugType (line 19)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 39)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.37 ms
(7.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter t0 WHERE t0.public = ?

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.value AS value_3,
  t0.libelle AS libelle_4,
  t0.public AS public_5
FROM
  parameter t0
WHERE
  t0.public = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter t0 WHERE t0.public = 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	Clockbox\Core\Service\ParameterProvider->getAll (line 18)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 40)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.34 ms
(6.63%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter_module t0 WHERE t0.public = ?

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.value AS value_3,
  t0.libelle AS libelle_4,
  t0.public AS public_5
FROM
  parameter_module t0
WHERE
  t0.public = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter_module t0 WHERE t0.public = 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	Clockbox\Core\Service\ParameterModuleProvider->getAll (line 18)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 41)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.34 ms
(6.48%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.open_window AS open_window_4, t0.name AS name_5, t0.display AS display_6, t0.position AS position_7, t0.type_blog AS type_blog_8, t0.border AS border_9, t0.parent_position AS parent_position_10, t0.color_specifique AS color_specifique_11, t0.color AS color_12, t0.background_specifique AS background_specifique_13, t0.background AS background_14, t0.display_in_menu_mobile AS display_in_menu_mobile_15, t0.display_picto_mobile AS display_picto_mobile_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.page_id AS page_id_19, t0.group_id AS group_id_20 FROM menu_item t0 INNER JOIN menu_item_menu_item ON t0.id = menu_item_menu_item.menu_item_source WHERE menu_item_menu_item.menu_item_target = ?

Parameters:

[
  239
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.url AS url_3,
  t0.open_window AS open_window_4,
  t0.name AS name_5,
  t0.display AS display_6,
  t0.position AS position_7,
  t0.type_blog AS type_blog_8,
  t0.border AS border_9,
  t0.parent_position AS parent_position_10,
  t0.color_specifique AS color_specifique_11,
  t0.color AS color_12,
  t0.background_specifique AS background_specifique_13,
  t0.background AS background_14,
  t0.display_in_menu_mobile AS display_in_menu_mobile_15,
  t0.display_picto_mobile AS display_picto_mobile_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.page_id AS page_id_19,
  t0.group_id AS group_id_20
FROM
  menu_item t0
  INNER JOIN menu_item_menu_item ON t0.id = menu_item_menu_item.menu_item_source
WHERE
  menu_item_menu_item.menu_item_target = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.open_window AS open_window_4, t0.name AS name_5, t0.display AS display_6, t0.position AS position_7, t0.type_blog AS type_blog_8, t0.border AS border_9, t0.parent_position AS parent_position_10, t0.color_specifique AS color_specifique_11, t0.color AS color_12, t0.background_specifique AS background_specifique_13, t0.background AS background_14, t0.display_in_menu_mobile AS display_in_menu_mobile_15, t0.display_picto_mobile AS display_picto_mobile_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.page_id AS page_id_19, t0.group_id AS group_id_20 FROM menu_item t0 INNER JOIN menu_item_menu_item ON t0.id = menu_item_menu_item.menu_item_source WHERE menu_item_menu_item.menu_item_target = 239;

#	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 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	iterator_to_array (line 1053)
8	Twig\Extension\CoreExtension::sort (line 1053)
9	__TwigTemplate_afb97c0afaa9a34a66ad6ac4cbfb98ee::doDisplay (line 336)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	Clockbox\Core\Controller\PagesController->navBar (line 170)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
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 78)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
26	__TwigTemplate_e22043808d715c537e0ea18cd7751509->doDisplay (line 355)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_a94ba1f91dd1209921686469db236fe3->doDisplay (line 55)
29	Twig\Template->yield (line 411)
30	__TwigTemplate_16b2c7862f525aaf629b1ce1f7702fbc->doDisplay (line 59)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_755bc63f374e7220b3a47e6b06c794da->doDisplay (line 55)
33	Twig\Template->yield (line 411)
34	Twig\Template->display (line 366)
35	Twig\Template->render (line 381)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
41	Clockbox\Core\Controller\PagesController->pageSection (line 208)
42	Clockbox\Core\Controller\PagesController->returnPage (line 138)
43	Clockbox\Core\Controller\PagesController->index (line 57)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 208)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 29)
49	require_once (line 5)

0.29 ms
(5.53%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.open_window AS open_window_4, t0.name AS name_5, t0.display AS display_6, t0.position AS position_7, t0.type_blog AS type_blog_8, t0.border AS border_9, t0.parent_position AS parent_position_10, t0.color_specifique AS color_specifique_11, t0.color AS color_12, t0.background_specifique AS background_specifique_13, t0.background AS background_14, t0.display_in_menu_mobile AS display_in_menu_mobile_15, t0.display_picto_mobile AS display_picto_mobile_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.page_id AS page_id_19, t0.group_id AS group_id_20 FROM menu_item t0 WHERE t0.group_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.url AS url_3,
  t0.open_window AS open_window_4,
  t0.name AS name_5,
  t0.display AS display_6,
  t0.position AS position_7,
  t0.type_blog AS type_blog_8,
  t0.border AS border_9,
  t0.parent_position AS parent_position_10,
  t0.color_specifique AS color_specifique_11,
  t0.color AS color_12,
  t0.background_specifique AS background_specifique_13,
  t0.background AS background_14,
  t0.display_in_menu_mobile AS display_in_menu_mobile_15,
  t0.display_picto_mobile AS display_picto_mobile_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.page_id AS page_id_19,
  t0.group_id AS group_id_20
FROM
  menu_item t0
WHERE
  t0.group_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.open_window AS open_window_4, t0.name AS name_5, t0.display AS display_6, t0.position AS position_7, t0.type_blog AS type_blog_8, t0.border AS border_9, t0.parent_position AS parent_position_10, t0.color_specifique AS color_specifique_11, t0.color AS color_12, t0.background_specifique AS background_specifique_13, t0.background AS background_14, t0.display_in_menu_mobile AS display_in_menu_mobile_15, t0.display_picto_mobile AS display_picto_mobile_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.page_id AS page_id_19, t0.group_id AS group_id_20 FROM menu_item t0 WHERE t0.group_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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	Clockbox\Core\Entity\MenuGroup->getDisplayedItems (line 142)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_afb97c0afaa9a34a66ad6ac4cbfb98ee::doDisplay (line 223)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	Clockbox\Core\Controller\PagesController->navBar (line 170)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
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 78)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
26	__TwigTemplate_e22043808d715c537e0ea18cd7751509->doDisplay (line 355)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_a94ba1f91dd1209921686469db236fe3->doDisplay (line 55)
29	Twig\Template->yield (line 411)
30	__TwigTemplate_16b2c7862f525aaf629b1ce1f7702fbc->doDisplay (line 59)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_755bc63f374e7220b3a47e6b06c794da->doDisplay (line 55)
33	Twig\Template->yield (line 411)
34	Twig\Template->display (line 366)
35	Twig\Template->render (line 381)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
41	Clockbox\Core\Controller\PagesController->pageSection (line 208)
42	Clockbox\Core\Controller\PagesController->returnPage (line 138)
43	Clockbox\Core\Controller\PagesController->index (line 57)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 208)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 29)
49	require_once (line 5)

0.24 ms
(4.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.title AS title_4, t0.btn_color AS btn_color_5, t0.text_color AS text_color_6, t0.type AS type_7, t0.image AS image_8, t0.image2 AS image2_9, t0.image_mobile AS image_mobile_10, t0.image_position_horizontal AS image_position_horizontal_11, t0.image_position_vertical AS image_position_vertical_12, t0.video AS video_13, t0.position AS position_14, t0.carrousel AS carrousel_15, t0.button AS button_16, t0.map_latitude AS map_latitude_17, t0.map_longitude AS map_longitude_18, t0.map_zoom AS map_zoom_19, t0.section_nethelium_affichage AS section_nethelium_affichage_20, t0.link AS link_21, t0.link_target AS link_target_22, t0.btn_text AS btn_text_23, t0.min_height AS min_height_24, t0.text_position AS text_position_25, t0.text_position_vertical AS text_position_vertical_26, t0.btn_display AS btn_display_27, t0.background_type AS background_type_28, t0.primary_color AS primary_color_29, t0.carrousel_thumb AS carrousel_thumb_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.blog_choice AS blog_choice_33, t0.blog_count_article AS blog_count_article_34, t0.number_product AS number_product_35, t0.display_date AS display_date_36, t0.display_place AS display_place_37, t0.type_auction AS type_auction_38, t0.page_id AS page_id_39, t0.iframe_nethelium_id AS iframe_nethelium_id_40, t0.custom_form_id AS custom_form_id_41, t42.id AS id_43, t42.title AS title_44, t42.fields AS fields_45, t42.name AS name_46, t42.description AS description_47, t42.btn_text AS btn_text_48, t42.newsletter AS newsletter_49, t42.created_at AS created_at_50, t42.updated_at AS updated_at_51, t42.mail_id AS mail_id_52 FROM page_section t0 LEFT JOIN custom_form t42 ON t0.custom_form_id = t42.id WHERE t0.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.name AS name_2,
  t0.text AS text_3,
  t0.title AS title_4,
  t0.btn_color AS btn_color_5,
  t0.text_color AS text_color_6,
  t0.type AS type_7,
  t0.image AS image_8,
  t0.image2 AS image2_9,
  t0.image_mobile AS image_mobile_10,
  t0.image_position_horizontal AS image_position_horizontal_11,
  t0.image_position_vertical AS image_position_vertical_12,
  t0.video AS video_13,
  t0.position AS position_14,
  t0.carrousel AS carrousel_15,
  t0.button AS button_16,
  t0.map_latitude AS map_latitude_17,
  t0.map_longitude AS map_longitude_18,
  t0.map_zoom AS map_zoom_19,
  t0.section_nethelium_affichage AS section_nethelium_affichage_20,
  t0.link AS link_21,
  t0.link_target AS link_target_22,
  t0.btn_text AS btn_text_23,
  t0.min_height AS min_height_24,
  t0.text_position AS text_position_25,
  t0.text_position_vertical AS text_position_vertical_26,
  t0.btn_display AS btn_display_27,
  t0.background_type AS background_type_28,
  t0.primary_color AS primary_color_29,
  t0.carrousel_thumb AS carrousel_thumb_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.blog_choice AS blog_choice_33,
  t0.blog_count_article AS blog_count_article_34,
  t0.number_product AS number_product_35,
  t0.display_date AS display_date_36,
  t0.display_place AS display_place_37,
  t0.type_auction AS type_auction_38,
  t0.page_id AS page_id_39,
  t0.iframe_nethelium_id AS iframe_nethelium_id_40,
  t0.custom_form_id AS custom_form_id_41,
  t42.id AS id_43,
  t42.title AS title_44,
  t42.fields AS fields_45,
  t42.name AS name_46,
  t42.description AS description_47,
  t42.btn_text AS btn_text_48,
  t42.newsletter AS newsletter_49,
  t42.created_at AS created_at_50,
  t42.updated_at AS updated_at_51,
  t42.mail_id AS mail_id_52
FROM
  page_section t0
  LEFT JOIN custom_form t42 ON t0.custom_form_id = t42.id
WHERE
  t0.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.title AS title_4, t0.btn_color AS btn_color_5, t0.text_color AS text_color_6, t0.type AS type_7, t0.image AS image_8, t0.image2 AS image2_9, t0.image_mobile AS image_mobile_10, t0.image_position_horizontal AS image_position_horizontal_11, t0.image_position_vertical AS image_position_vertical_12, t0.video AS video_13, t0.position AS position_14, t0.carrousel AS carrousel_15, t0.button AS button_16, t0.map_latitude AS map_latitude_17, t0.map_longitude AS map_longitude_18, t0.map_zoom AS map_zoom_19, t0.section_nethelium_affichage AS section_nethelium_affichage_20, t0.link AS link_21, t0.link_target AS link_target_22, t0.btn_text AS btn_text_23, t0.min_height AS min_height_24, t0.text_position AS text_position_25, t0.text_position_vertical AS text_position_vertical_26, t0.btn_display AS btn_display_27, t0.background_type AS background_type_28, t0.primary_color AS primary_color_29, t0.carrousel_thumb AS carrousel_thumb_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.blog_choice AS blog_choice_33, t0.blog_count_article AS blog_count_article_34, t0.number_product AS number_product_35, t0.display_date AS display_date_36, t0.display_place AS display_place_37, t0.type_auction AS type_auction_38, t0.page_id AS page_id_39, t0.iframe_nethelium_id AS iframe_nethelium_id_40, t0.custom_form_id AS custom_form_id_41, t42.id AS id_43, t42.title AS title_44, t42.fields AS fields_45, t42.name AS name_46, t42.description AS description_47, t42.btn_text AS btn_text_48, t42.newsletter AS newsletter_49, t42.created_at AS created_at_50, t42.updated_at AS updated_at_51, t42.mail_id AS mail_id_52 FROM page_section t0 LEFT JOIN custom_form t42 ON t0.custom_form_id = t42.id WHERE t0.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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Clockbox\Core\Entity\Page->hasSection (line 145)
8	Clockbox\Core\Controller\PagesController->returnPage (line 119)
9	Clockbox\Core\Controller\PagesController->index (line 57)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.16 ms
(3.01%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.position AS position_4, t0.text AS text_5, t0.url AS url_6, t0.display AS display_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM partner t0 WHERE t0.display = ? 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.title AS title_2,
  t0.image AS image_3,
  t0.position AS position_4,
  t0.text AS text_5,
  t0.url AS url_6,
  t0.display AS display_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  partner t0
WHERE
  t0.display = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.position AS position_4, t0.text AS text_5, t0.url AS url_6, t0.display AS display_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM partner t0 WHERE t0.display = 1 ORDER BY t0.position ASC;

#	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	Clockbox\Core\Controller\PagesController->pageSection (line 193)
5	Clockbox\Core\Controller\PagesController->returnPage (line 138)
6	Clockbox\Core\Controller\PagesController->index (line 57)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.12 ms
(2.41%)

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.primary_page = ? AND t0.display = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.agence AS agence_2,
  t0.agence_address AS agence_address_3,
  t0.agence_zip AS agence_zip_4,
  t0.agence_city AS agence_city_5,
  t0.agence_email AS agence_email_6,
  t0.agence_phone AS agence_phone_7,
  t0.agence_opening_hours AS agence_opening_hours_8,
  t0.agence_contact_url AS agence_contact_url_9,
  t0.agence_contact_latitude AS agence_contact_latitude_10,
  t0.agence_contact_longitude AS agence_contact_longitude_11,
  t0.agence_nethelium AS agence_nethelium_12,
  t0.agence_contact_zoom AS agence_contact_zoom_13,
  t0.breadcrumb AS breadcrumb_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.title AS title_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.affichage_menu AS affichage_menu_20,
  t0.slug AS slug_21,
  t0.display AS display_22,
  t0.no_index AS no_index_23,
  t0.primary_page AS primary_page_24,
  t0.parent_id AS parent_id_25
FROM
  page t0
WHERE
  t0.primary_page = ?
  AND t0.display = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.primary_page = 1 AND t0.display = 1 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	Clockbox\Core\Controller\PagesController->index (line 53)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.12 ms
(2.26%)

SELECT t0.id AS id_1, t0.background AS background_2, t0.color AS color_3, t0.color_active AS color_active_4, t0.font_size AS font_size_5, t0.position AS position_6, t0.display AS display_7, t0.text_align AS text_align_8, t0.title AS title_9, t0.background_mobile AS background_mobile_10, t0.color_mobile AS color_mobile_11, t0.color_mobile_active AS color_mobile_active_12, t0.opacity AS opacity_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM menu t0 WHERE t0.display = ? 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.background AS background_2,
  t0.color AS color_3,
  t0.color_active AS color_active_4,
  t0.font_size AS font_size_5,
  t0.position AS position_6,
  t0.display AS display_7,
  t0.text_align AS text_align_8,
  t0.title AS title_9,
  t0.background_mobile AS background_mobile_10,
  t0.color_mobile AS color_mobile_11,
  t0.color_mobile_active AS color_mobile_active_12,
  t0.opacity AS opacity_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  menu t0
WHERE
  t0.display = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.background AS background_2, t0.color AS color_3, t0.color_active AS color_active_4, t0.font_size AS font_size_5, t0.position AS position_6, t0.display AS display_7, t0.text_align AS text_align_8, t0.title AS title_9, t0.background_mobile AS background_mobile_10, t0.color_mobile AS color_mobile_11, t0.color_mobile_active AS color_mobile_active_12, t0.opacity AS opacity_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM menu t0 WHERE t0.display = 1 ORDER BY t0.position ASC;

#	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	Clockbox\Core\Controller\PagesController->navBar (line 147)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
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 78)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
12	__TwigTemplate_e22043808d715c537e0ea18cd7751509->doDisplay (line 355)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_a94ba1f91dd1209921686469db236fe3->doDisplay (line 55)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_16b2c7862f525aaf629b1ce1f7702fbc->doDisplay (line 59)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_755bc63f374e7220b3a47e6b06c794da->doDisplay (line 55)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
27	Clockbox\Core\Controller\PagesController->pageSection (line 208)
28	Clockbox\Core\Controller\PagesController->returnPage (line 138)
29	Clockbox\Core\Controller\PagesController->index (line 57)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 208)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.11 ms
(2.18%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.menu_id AS menu_id_7 FROM menu_group t0 WHERE t0.menu_id = ?

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.display AS display_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.menu_id AS menu_id_7
FROM
  menu_group t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.menu_id AS menu_id_7 FROM menu_group t0 WHERE t0.menu_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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	Clockbox\Core\Entity\Menu->getDisplayedGroups (line 275)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_afb97c0afaa9a34a66ad6ac4cbfb98ee::doDisplay (line 201)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	Clockbox\Core\Controller\PagesController->navBar (line 170)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
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 78)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
26	__TwigTemplate_e22043808d715c537e0ea18cd7751509->doDisplay (line 355)
27	Twig\Template->yield (line 411)
28	__TwigTemplate_a94ba1f91dd1209921686469db236fe3->doDisplay (line 55)
29	Twig\Template->yield (line 411)
30	__TwigTemplate_16b2c7862f525aaf629b1ce1f7702fbc->doDisplay (line 59)
31	Twig\Template->yield (line 411)
32	__TwigTemplate_755bc63f374e7220b3a47e6b06c794da->doDisplay (line 55)
33	Twig\Template->yield (line 411)
34	Twig\Template->display (line 366)
35	Twig\Template->render (line 381)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
41	Clockbox\Core\Controller\PagesController->pageSection (line 208)
42	Clockbox\Core\Controller\PagesController->returnPage (line 138)
43	Clockbox\Core\Controller\PagesController->index (line 57)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 208)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 29)
49	require_once (line 5)

0.11 ms
(2.14%)

SELECT t0.id AS id_1, t0.background_color AS background_color_2, t0.text AS text_3, t0.display AS display_4, t0.position AS position_5, t0.days AS days_6, t0.button_background_color AS button_background_color_7, t0.button_font_color AS button_font_color_8, t0.button_font_size AS button_font_size_9, t0.button_text AS button_text_10, t0.button_url AS button_url_11, t0.button_display AS button_display_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM bandeau t0 WHERE t0.display = ? 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.background_color AS background_color_2,
  t0.text AS text_3,
  t0.display AS display_4,
  t0.position AS position_5,
  t0.days AS days_6,
  t0.button_background_color AS button_background_color_7,
  t0.button_font_color AS button_font_color_8,
  t0.button_font_size AS button_font_size_9,
  t0.button_text AS button_text_10,
  t0.button_url AS button_url_11,
  t0.button_display AS button_display_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  bandeau t0
WHERE
  t0.display = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.background_color AS background_color_2, t0.text AS text_3, t0.display AS display_4, t0.position AS position_5, t0.days AS days_6, t0.button_background_color AS button_background_color_7, t0.button_font_color AS button_font_color_8, t0.button_font_size AS button_font_size_9, t0.button_text AS button_text_10, t0.button_url AS button_url_11, t0.button_display AS button_display_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM bandeau t0 WHERE t0.display = 1 ORDER BY t0.position ASC;

#	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	Clockbox\Core\Controller\PagesController->navBar (line 154)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
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 78)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
12	__TwigTemplate_e22043808d715c537e0ea18cd7751509->doDisplay (line 355)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_a94ba1f91dd1209921686469db236fe3->doDisplay (line 55)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_16b2c7862f525aaf629b1ce1f7702fbc->doDisplay (line 59)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_755bc63f374e7220b3a47e6b06c794da->doDisplay (line 55)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
27	Clockbox\Core\Controller\PagesController->pageSection (line 208)
28	Clockbox\Core\Controller\PagesController->returnPage (line 138)
29	Clockbox\Core\Controller\PagesController->index (line 57)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 208)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	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\Page	20
Clockbox\Core\Entity\MenuItem	18
Clockbox\Core\Entity\Page	14
App\Entity\Parameter	4
App\Entity\PageSection	4
App\Entity\Partner	4
Clockbox\Core\Entity\MenuGroup	2
App\Entity\Site	1
App\Entity\CustomForm	1
Clockbox\Core\Entity\Mail	1
App\Entity\Menu	1
Clockbox\Core\Entity\Menu	1

Entities Mapping

Class	Mapping errors
Clockbox\Core\Entity\Site	No errors.
App\Entity\Site	No errors.
Clockbox\Core\Entity\Page	No errors.
App\Entity\Page	No errors.
Clockbox\Core\Entity\PageSection	No errors.
App\Entity\PageSection	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on App\Entity\PageSection#blogCategories is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Parameter	No errors.
App\Entity\Parameter	No errors.
Clockbox\Core\Entity\ParameterModule	No errors.
App\Entity\ParameterModule	No errors.
Clockbox\Core\Entity\IframeNethelium	The target entity 'Clockbox\Core\Entity\PageSection' specified on Clockbox\Core\Entity\IframeNethelium#sectionsPage is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\IframeNethelium	The target entity 'Clockbox\Core\Entity\PageSection' specified on App\Entity\IframeNethelium#sectionsPage is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\CustomForm	The target entity 'Clockbox\Core\Entity\Mail' specified on Clockbox\Core\Entity\CustomForm#mail is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\CustomForm	The target entity 'Clockbox\Core\Entity\Mail' specified on App\Entity\CustomForm#mail is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Mail	The target entity 'Clockbox\Core\Entity\MailUser' specified on Clockbox\Core\Entity\Mail#users is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Norme	The target entity 'Clockbox\Core\Entity\PageSection' specified on Clockbox\Core\Entity\Norme#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Norme	The target entity 'Clockbox\Core\Entity\PageSection' specified on App\Entity\Norme#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Marker	The target entity 'Clockbox\Core\Entity\PageSection' specified on Clockbox\Core\Entity\Marker#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Marker	The target entity 'Clockbox\Core\Entity\PageSection' specified on App\Entity\Marker#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Carrousel	The target entity 'Clockbox\Core\Entity\PageSection' specified on Clockbox\Core\Entity\Carrousel#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Carrousel	The target entity 'Clockbox\Core\Entity\PageSection' specified on App\Entity\Carrousel#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\SocialNetwork	The target entity 'Clockbox\Core\Entity\PageSection' specified on Clockbox\Core\Entity\SocialNetwork#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\SocialNetwork	The target entity 'Clockbox\Core\Entity\PageSection' specified on App\Entity\SocialNetwork#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Faq	The target entity 'Clockbox\Core\Entity\PageSection' specified on Clockbox\Core\Entity\Faq#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Faq	The target entity 'Clockbox\Core\Entity\PageSection' specified on App\Entity\Faq#pageSection is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Blog\Entity\BlogCategory	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on Clockbox\Blog\Entity\BlogCategory#parent is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Auction\Entity\SlideAuction	No errors.
App\Entity\SlideAuction	No errors.
Clockbox\Core\Entity\Question	The target entity 'Clockbox\Core\Entity\CustomForm' specified on Clockbox\Core\Entity\Question#customForm is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Question	The target entity 'Clockbox\Core\Entity\CustomForm' specified on App\Entity\Question#customForm is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\FooterLink	The target entity 'Clockbox\Core\Entity\Page' specified on Clockbox\Core\Entity\FooterLink#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\FooterLink	The target entity 'Clockbox\Core\Entity\Page' specified on App\Entity\FooterLink#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Partner	No errors.
App\Entity\Partner	No errors.
Clockbox\Core\Entity\Menu	The target entity 'Clockbox\Core\Entity\MenuGroup' specified on Clockbox\Core\Entity\Menu#groups is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Menu	The target entity 'Clockbox\Core\Entity\MenuGroup' specified on App\Entity\Menu#groups is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\MenuGroup	The target entity 'Clockbox\Core\Entity\Menu' specified on Clockbox\Core\Entity\MenuGroup#menu is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Bandeau	No errors.
App\Entity\Bandeau	No errors.
Clockbox\Core\Entity\MenuItem	The target entity 'Clockbox\Core\Entity\Page' specified on Clockbox\Core\Entity\MenuItem#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.

Symfony Profiler

GET https://www.encheres-nantes-labaule.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DClockbox%255CCore%255CController%255CPagesController%253A%…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping