Symfony Profiler

Query Metrics

58 Database Queries

12 Different statements

7.18 ms Query time

49 Invalid entities

67 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.72 ms
(23.99%)

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.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.default_blog_image AS default_blog_image_32, t0.default_auction_image AS default_auction_image_33 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.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.default_blog_image AS default_blog_image_32,
  t0.default_auction_image AS default_auction_image_33
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.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.default_blog_image AS default_blog_image_32, t0.default_auction_image AS default_auction_image_33 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 139)
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)

1.46 ms
(20.34%)

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_contact_zoom AS agence_contact_zoom_12, t0.breadcrumb AS breadcrumb_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.title AS title_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.affichage_menu AS affichage_menu_19, t0.slug AS slug_20, t0.display AS display_21, t0.no_index AS no_index_22, t0.parent_id AS parent_id_23 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_contact_zoom AS agence_contact_zoom_12,
  t0.breadcrumb AS breadcrumb_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.title AS title_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.affichage_menu AS affichage_menu_19,
  t0.slug AS slug_20,
  t0.display AS display_21,
  t0.no_index AS no_index_22,
  t0.parent_id AS parent_id_23
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_contact_zoom AS agence_contact_zoom_12, t0.breadcrumb AS breadcrumb_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.title AS title_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.affichage_menu AS affichage_menu_19, t0.slug AS slug_20, t0.display AS display_21, t0.no_index AS no_index_22, t0.parent_id AS parent_id_23 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 94)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_130709123208b69e6e393a13ac6f990a::doDisplay (line 79)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_5bf331b78e99247755a816fd78d39aaf->doDisplay (line 370)
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 452)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
20	Clockbox\Core\Controller\PagesController->navBar (line 127)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
24	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
25	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
26	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
27	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
28	__TwigTemplate_04f3c22cc42234502bc804cc94dfa1cd->doDisplay (line 390)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->doDisplay (line 58)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_596c0d4b027cad1cc06b6dea7595460c->doDisplay (line 54)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
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\Auction\Controller\Auction\auctionController->pageSections (line 127)
42	Clockbox\Auction\Controller\Auction\auctionController->returnPages (line 105)
43	Clockbox\Auction\Controller\Auction\auctionController->page (line 50)
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)

1.12 ms
(15.54%)

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_contact_zoom AS agence_contact_zoom_12, t0.breadcrumb AS breadcrumb_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.title AS title_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.affichage_menu AS affichage_menu_19, t0.slug AS slug_20, t0.display AS display_21, t0.no_index AS no_index_22, t0.parent_id AS parent_id_23 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_contact_zoom AS agence_contact_zoom_12,
  t0.breadcrumb AS breadcrumb_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.title AS title_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.affichage_menu AS affichage_menu_19,
  t0.slug AS slug_20,
  t0.display AS display_21,
  t0.no_index AS no_index_22,
  t0.parent_id AS parent_id_23
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_contact_zoom AS agence_contact_zoom_12, t0.breadcrumb AS breadcrumb_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.title AS title_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.affichage_menu AS affichage_menu_19, t0.slug AS slug_20, t0.display AS display_21, t0.no_index AS no_index_22, t0.parent_id AS parent_id_23 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 139)
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.70 ms
(9.69%)

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 139)
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.61 ms
(8.55%)

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 139)
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.32 ms
(4.48%)

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.btn_display AS btn_display_26, t0.background_type AS background_type_27, t0.primary_color AS primary_color_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.blog_choice AS blog_choice_31, t0.blog_count_article AS blog_count_article_32, t0.number_product AS number_product_33, t0.display_date AS display_date_34, t0.display_place AS display_place_35, t0.page_id AS page_id_36, t0.iframe_nethelium_id AS iframe_nethelium_id_37, t0.custom_form_id AS custom_form_id_38, t39.id AS id_40, t39.title AS title_41, t39.fields AS fields_42, t39.name AS name_43, t39.description AS description_44, t39.btn_text AS btn_text_45, t39.newsletter AS newsletter_46, t39.mail_id AS mail_id_47 FROM page_section t0 LEFT JOIN custom_form t39 ON t0.custom_form_id = t39.id WHERE t0.page_id = ? ORDER BY t0.position ASC

Parameters:

[
  12
]

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.btn_display AS btn_display_26,
  t0.background_type AS background_type_27,
  t0.primary_color AS primary_color_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.blog_choice AS blog_choice_31,
  t0.blog_count_article AS blog_count_article_32,
  t0.number_product AS number_product_33,
  t0.display_date AS display_date_34,
  t0.display_place AS display_place_35,
  t0.page_id AS page_id_36,
  t0.iframe_nethelium_id AS iframe_nethelium_id_37,
  t0.custom_form_id AS custom_form_id_38,
  t39.id AS id_40,
  t39.title AS title_41,
  t39.fields AS fields_42,
  t39.name AS name_43,
  t39.description AS description_44,
  t39.btn_text AS btn_text_45,
  t39.newsletter AS newsletter_46,
  t39.mail_id AS mail_id_47
FROM
  page_section t0
  LEFT JOIN custom_form t39 ON t0.custom_form_id = t39.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.btn_display AS btn_display_26, t0.background_type AS background_type_27, t0.primary_color AS primary_color_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.blog_choice AS blog_choice_31, t0.blog_count_article AS blog_count_article_32, t0.number_product AS number_product_33, t0.display_date AS display_date_34, t0.display_place AS display_place_35, t0.page_id AS page_id_36, t0.iframe_nethelium_id AS iframe_nethelium_id_37, t0.custom_form_id AS custom_form_id_38, t39.id AS id_40, t39.title AS title_41, t39.fields AS fields_42, t39.name AS name_43, t39.description AS description_44, t39.btn_text AS btn_text_45, t39.newsletter AS newsletter_46, t39.mail_id AS mail_id_47 FROM page_section t0 LEFT JOIN custom_form t39 ON t0.custom_form_id = t39.id WHERE t0.page_id = 12 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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8::block_body (line 214)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_04f3c22cc42234502bc804cc94dfa1cd->doDisplay (line 401)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->doDisplay (line 58)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_596c0d4b027cad1cc06b6dea7595460c->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
24	Clockbox\Auction\Controller\Auction\auctionController->pageSections (line 127)
25	Clockbox\Auction\Controller\Auction\auctionController->returnPages (line 105)
26	Clockbox\Auction\Controller\Auction\auctionController->page (line 50)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.31 ms
(4.25%)

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.url AS url_2, m0_.open_window AS open_window_3, m0_.name AS name_4, m0_.display AS display_5, m0_.position AS position_6, m0_.type_blog AS type_blog_7, m0_.border AS border_8, m0_.parent_position AS parent_position_9, m0_.color_specifique AS color_specifique_10, m0_.color AS color_11, m0_.background_specifique AS background_specifique_12, m0_.background AS background_13, m0_.created_at AS created_at_14, m0_.updated_at AS updated_at_15, m0_.page_id AS page_id_16, m0_.menu_config_id AS menu_config_id_17 FROM menu m0_ LEFT JOIN menu_menu m2_ ON m0_.id = m2_.menu_source LEFT JOIN menu m1_ ON m1_.id = m2_.menu_target WHERE m1_.id IS NULL AND m0_.display = 1 ORDER BY m0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.url AS url_2,
  m0_.open_window AS open_window_3,
  m0_.name AS name_4,
  m0_.display AS display_5,
  m0_.position AS position_6,
  m0_.type_blog AS type_blog_7,
  m0_.border AS border_8,
  m0_.parent_position AS parent_position_9,
  m0_.color_specifique AS color_specifique_10,
  m0_.color AS color_11,
  m0_.background_specifique AS background_specifique_12,
  m0_.background AS background_13,
  m0_.created_at AS created_at_14,
  m0_.updated_at AS updated_at_15,
  m0_.page_id AS page_id_16,
  m0_.menu_config_id AS menu_config_id_17
FROM
  menu m0_
  LEFT JOIN menu_menu m2_ ON m0_.id = m2_.menu_source
  LEFT JOIN menu m1_ ON m1_.id = m2_.menu_target
WHERE
  m1_.id IS NULL
  AND m0_.display = 1
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.url AS url_2, m0_.open_window AS open_window_3, m0_.name AS name_4, m0_.display AS display_5, m0_.position AS position_6, m0_.type_blog AS type_blog_7, m0_.border AS border_8, m0_.parent_position AS parent_position_9, m0_.color_specifique AS color_specifique_10, m0_.color AS color_11, m0_.background_specifique AS background_specifique_12, m0_.background AS background_13, m0_.created_at AS created_at_14, m0_.updated_at AS updated_at_15, m0_.page_id AS page_id_16, m0_.menu_config_id AS menu_config_id_17 FROM menu m0_ LEFT JOIN menu_menu m2_ ON m0_.id = m2_.menu_source LEFT JOIN menu m1_ ON m1_.id = m2_.menu_target WHERE m1_.id IS NULL AND m0_.display = 1 ORDER BY m0_.position 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	Clockbox\Core\Repository\MenuRepository->findMenuWithoutSousMenu (line 80)
7	Clockbox\Core\Controller\PagesController->navBar (line 105)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
15	__TwigTemplate_04f3c22cc42234502bc804cc94dfa1cd->doDisplay (line 390)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->doDisplay (line 58)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_596c0d4b027cad1cc06b6dea7595460c->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
28	Clockbox\Auction\Controller\Auction\auctionController->pageSections (line 127)
29	Clockbox\Auction\Controller\Auction\auctionController->returnPages (line 105)
30	Clockbox\Auction\Controller\Auction\auctionController->page (line 50)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 208)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

0.30 ms
(4.23%)

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.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.page_id AS page_id_17, t0.menu_config_id AS menu_config_id_18 FROM menu t0 INNER JOIN menu_menu ON t0.id = menu_menu.menu_source WHERE menu_menu.menu_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.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.page_id AS page_id_17,
  t0.menu_config_id AS menu_config_id_18
FROM
  menu t0
  INNER JOIN menu_menu ON t0.id = menu_menu.menu_source
WHERE
  menu_menu.menu_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.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.page_id AS page_id_17, t0.menu_config_id AS menu_config_id_18 FROM menu t0 INNER JOIN menu_menu ON t0.id = menu_menu.menu_source WHERE menu_menu.menu_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 2733)
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 1050)
8	Twig\Extension\CoreExtension::sort (line 1050)
9	__TwigTemplate_5bf331b78e99247755a816fd78d39aaf::doDisplay (line 288)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 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 127)
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_04f3c22cc42234502bc804cc94dfa1cd->doDisplay (line 390)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->doDisplay (line 58)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_596c0d4b027cad1cc06b6dea7595460c->doDisplay (line 54)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
39	Clockbox\Auction\Controller\Auction\auctionController->pageSections (line 127)
40	Clockbox\Auction\Controller\Auction\auctionController->returnPages (line 105)
41	Clockbox\Auction\Controller\Auction\auctionController->page (line 50)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 208)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
46	require_once (line 29)
47	require_once (line 5)

0.18 ms
(2.53%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.required AS required_4, t0.position AS position_5, t0.multiple_file AS multiple_file_6, t0.size AS size_7, t0.text_rgpd AS text_rgpd_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.custom_form_id AS custom_form_id_11 FROM question t0 WHERE t0.custom_form_id = ? ORDER BY t0.position ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.required AS required_4,
  t0.position AS position_5,
  t0.multiple_file AS multiple_file_6,
  t0.size AS size_7,
  t0.text_rgpd AS text_rgpd_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.custom_form_id AS custom_form_id_11
FROM
  question t0
WHERE
  t0.custom_form_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.required AS required_4, t0.position AS position_5, t0.multiple_file AS multiple_file_6, t0.size AS size_7, t0.text_rgpd AS text_rgpd_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.custom_form_id AS custom_form_id_11 FROM question t0 WHERE t0.custom_form_id = 2 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 315)
7	__TwigTemplate_c42476a591b0943b3e14fc6f0e59c428->doDisplay (line 300)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_79c895f013aa30a9b64b26e0a0816ea2->doDisplay (line 144)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->block_body (line 336)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_04f3c22cc42234502bc804cc94dfa1cd->doDisplay (line 401)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->doDisplay (line 58)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_596c0d4b027cad1cc06b6dea7595460c->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	Clockbox\Auction\Controller\Auction\auctionController->pageSections (line 127)
27	Clockbox\Auction\Controller\Auction\auctionController->returnPages (line 105)
28	Clockbox\Auction\Controller\Auction\auctionController->page (line 50)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 208)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.16 ms
(2.28%)

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.display_logo AS display_logo_8, t0.text_align AS text_align_9, t0.title AS title_10, t0.display_phone AS display_phone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM menu_config 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.display_logo AS display_logo_8,
  t0.text_align AS text_align_9,
  t0.title AS title_10,
  t0.display_phone AS display_phone_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  menu_config 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.display_logo AS display_logo_8, t0.text_align AS text_align_9, t0.title AS title_10, t0.display_phone AS display_phone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM menu_config 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 111)
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_04f3c22cc42234502bc804cc94dfa1cd->doDisplay (line 390)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->doDisplay (line 58)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_596c0d4b027cad1cc06b6dea7595460c->doDisplay (line 54)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
25	Clockbox\Auction\Controller\Auction\auctionController->pageSections (line 127)
26	Clockbox\Auction\Controller\Auction\auctionController->returnPages (line 105)
27	Clockbox\Auction\Controller\Auction\auctionController->page (line 50)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 208)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

0.15 ms
(2.06%)

SELECT p0_.id AS id_0, p0_.agence AS agence_1, p0_.agence_address AS agence_address_2, p0_.agence_zip AS agence_zip_3, p0_.agence_city AS agence_city_4, p0_.agence_email AS agence_email_5, p0_.agence_phone AS agence_phone_6, p0_.agence_opening_hours AS agence_opening_hours_7, p0_.agence_contact_url AS agence_contact_url_8, p0_.agence_contact_latitude AS agence_contact_latitude_9, p0_.agence_contact_longitude AS agence_contact_longitude_10, p0_.agence_contact_zoom AS agence_contact_zoom_11, p0_.breadcrumb AS breadcrumb_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.title AS title_15, p0_.meta_title AS meta_title_16, p0_.meta_description AS meta_description_17, p0_.affichage_menu AS affichage_menu_18, p0_.slug AS slug_19, p0_.display AS display_20, p0_.no_index AS no_index_21, p0_.parent_id AS parent_id_22 FROM page p0_ WHERE p0_.slug = ? AND p0_.display = 1

Parameters:

[
  "ventes-venir"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.agence AS agence_1,
  p0_.agence_address AS agence_address_2,
  p0_.agence_zip AS agence_zip_3,
  p0_.agence_city AS agence_city_4,
  p0_.agence_email AS agence_email_5,
  p0_.agence_phone AS agence_phone_6,
  p0_.agence_opening_hours AS agence_opening_hours_7,
  p0_.agence_contact_url AS agence_contact_url_8,
  p0_.agence_contact_latitude AS agence_contact_latitude_9,
  p0_.agence_contact_longitude AS agence_contact_longitude_10,
  p0_.agence_contact_zoom AS agence_contact_zoom_11,
  p0_.breadcrumb AS breadcrumb_12,
  p0_.created_at AS created_at_13,
  p0_.updated_at AS updated_at_14,
  p0_.title AS title_15,
  p0_.meta_title AS meta_title_16,
  p0_.meta_description AS meta_description_17,
  p0_.affichage_menu AS affichage_menu_18,
  p0_.slug AS slug_19,
  p0_.display AS display_20,
  p0_.no_index AS no_index_21,
  p0_.parent_id AS parent_id_22
FROM
  page p0_
WHERE
  p0_.slug = ?
  AND p0_.display = 1

SELECT p0_.id AS id_0, p0_.agence AS agence_1, p0_.agence_address AS agence_address_2, p0_.agence_zip AS agence_zip_3, p0_.agence_city AS agence_city_4, p0_.agence_email AS agence_email_5, p0_.agence_phone AS agence_phone_6, p0_.agence_opening_hours AS agence_opening_hours_7, p0_.agence_contact_url AS agence_contact_url_8, p0_.agence_contact_latitude AS agence_contact_latitude_9, p0_.agence_contact_longitude AS agence_contact_longitude_10, p0_.agence_contact_zoom AS agence_contact_zoom_11, p0_.breadcrumb AS breadcrumb_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.title AS title_15, p0_.meta_title AS meta_title_16, p0_.meta_description AS meta_description_17, p0_.affichage_menu AS affichage_menu_18, p0_.slug AS slug_19, p0_.display AS display_20, p0_.no_index AS no_index_21, p0_.parent_id AS parent_id_22 FROM page p0_ WHERE p0_.slug = 'ventes-venir' AND p0_.display = 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	Clockbox\Core\Repository\PageRepository->findPageBySlugAndParent (line 66)
7	Clockbox\Auction\Controller\Auction\auctionController->page (line 44)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.15 ms
(2.04%)

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 118)
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_04f3c22cc42234502bc804cc94dfa1cd->doDisplay (line 390)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_d3f930df8662cabde04bb1b37986d5f8->doDisplay (line 58)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_596c0d4b027cad1cc06b6dea7595460c->doDisplay (line 54)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
25	Clockbox\Auction\Controller\Auction\auctionController->pageSections (line 127)
26	Clockbox\Auction\Controller\Auction\auctionController->returnPages (line 105)
27	Clockbox\Auction\Controller\Auction\auctionController->page (line 50)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 208)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	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\Page	14
Clockbox\Core\Entity\Menu	9
App\Entity\Menu	8
App\Entity\Parameter	4
App\Entity\Question	4
App\Entity\PageSection	2
App\Entity\Site	1
Clockbox\Core\Entity\MenuConfig	1
App\Entity\MenuConfig	1
App\Entity\CustomForm	1
Clockbox\Core\Entity\Mail	1
Clockbox\Core\Entity\CustomForm	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\Menu	The target entity 'Clockbox\Core\Entity\Page' specified on Clockbox\Core\Entity\Menu#page 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\Page' specified on App\Entity\Menu#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\MenuConfig	No errors.
App\Entity\MenuConfig	No errors.
Clockbox\Core\Entity\Bandeau	No errors.
App\Entity\Bandeau	No errors.
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\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\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\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\Auction\Entity\AddressAuction	No errors.
App\Entity\AddressAuction	No errors.
Clockbox\Catalog\Entity\Product	The target entity 'Clockbox\Catalog\Entity\Brand' specified on Clockbox\Catalog\Entity\Product#brand is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Product	The target entity 'Clockbox\Catalog\Entity\Brand' specified on App\Entity\Product#brand is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Newsletter	No errors.
App\Entity\Newsletter	No errors.
Clockbox\Catalog\Entity\ProductVariantImage	The target entity 'Clockbox\Catalog\Entity\ProductVariant' specified on Clockbox\Catalog\Entity\ProductVariantImage#productVariant is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\ProductVariantImage	The target entity 'Clockbox\Catalog\Entity\ProductVariant' specified on App\Entity\ProductVariantImage#productVariant is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Choice	The target entity 'Clockbox\Core\Entity\Question' specified on Clockbox\Core\Entity\Choice#question is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Choice	The target entity 'Clockbox\Core\Entity\Question' specified on App\Entity\Choice#question is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Media	No errors.
App\Entity\Media	No errors.
Clockbox\Catalog\Entity\AttributeValue	The target entity 'Clockbox\Catalog\Entity\ProductVariant' specified on Clockbox\Catalog\Entity\AttributeValue#productsVariants is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\AttributeValue	The target entity 'Clockbox\Catalog\Entity\ProductVariant' specified on App\Entity\AttributeValue#productsVariants is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Blog\Entity\BlogCategorySection	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on Clockbox\Blog\Entity\BlogCategorySection#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\BlogCategorySection	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on App\Entity\BlogCategorySection#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Catalog\Entity\Attribute	The target entity 'Clockbox\Catalog\Entity\AttributeValue' specified on Clockbox\Catalog\Entity\Attribute#attributeValues is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Attribute	The target entity 'Clockbox\Catalog\Entity\AttributeValue' specified on App\Entity\Attribute#attributeValues is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\User	No errors.
App\Entity\User	No errors.
Clockbox\Catalog\Entity\Category	The target entity 'Clockbox\Catalog\Entity\Product' specified on Clockbox\Catalog\Entity\Category#products is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Category	The target entity 'Clockbox\Catalog\Entity\Product' specified on App\Entity\Category#products 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.
App\Entity\Mail	The target entity 'Clockbox\Core\Entity\MailUser' specified on App\Entity\Mail#users is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Blog\Entity\BlogArticle	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on Clockbox\Blog\Entity\BlogArticle#categories is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\BlogArticle	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on App\Entity\BlogArticle#categories is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Redirection	The target entity 'Clockbox\Core\Entity\Page' specified on Clockbox\Core\Entity\Redirection#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Redirection	The target entity 'Clockbox\Core\Entity\Page' specified on App\Entity\Redirection#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Catalog\Entity\Brand	The target entity 'Clockbox\Catalog\Entity\Product' specified on Clockbox\Catalog\Entity\Brand#products is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Brand	The target entity 'Clockbox\Catalog\Entity\Product' specified on App\Entity\Brand#products is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Footer	No errors.
App\Entity\Footer	No errors.
Clockbox\Core\Entity\Partner	No errors.
App\Entity\Partner	No errors.
Clockbox\Blog\Entity\BlogArticleSection	The target entity 'Clockbox\Blog\Entity\BlogArticle' specified on Clockbox\Blog\Entity\BlogArticleSection#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\BlogArticleSection	The target entity 'Clockbox\Blog\Entity\BlogArticle' specified on App\Entity\BlogArticleSection#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\BlogCategory	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on App\Entity\BlogCategory#parent is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\MailUser	The target entity 'Clockbox\Core\Entity\Mail' specified on Clockbox\Core\Entity\MailUser#mailList is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\MailUser	The target entity 'Clockbox\Core\Entity\Mail' specified on App\Entity\MailUser#mailList is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Catalog\Entity\ProductVariant	The association Clockbox\Catalog\Entity\ProductVariant#attributes refers to the inverse side field App\Entity\AttributeValue#products which does not exist.
App\Entity\ProductVariant	The association App\Entity\ProductVariant#attributes refers to the inverse side field App\Entity\AttributeValue#products which does not exist.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://salorges-encheres.recette.agence-11h10.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DClockbox%255CBlog%255CController%255CSectionCont…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping