Symfony Profiler

Query Metrics

23 Database Queries

8 Different statements

28.36 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.78 ms
(38.00%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.icon_name AS icon_name_6, t0.icon_size AS icon_size_7, t0.icon_updated_at AS icon_updated_at_8, t0.icon_alt AS icon_alt_9, t0.sub_title AS sub_title_10, t0.skill_title AS skill_title_11, t0.page_title AS page_title_12, t0.resume AS resume_13, t0.paragraph_sub_title AS paragraph_sub_title_14, t0.paragraph_title AS paragraph_title_15, t0.contact_sub_title AS contact_sub_title_16, t0.contact_title AS contact_title_17, t0.contact_text AS contact_text_18, t0.contact_cta_text AS contact_cta_text_19, t0.contact_cta_link AS contact_cta_link_20, t0.contact_cta_external AS contact_cta_external_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.slug AS slug_24, t0.metal_work_sub_category_id AS metal_work_sub_category_id_25 FROM metal_work_sub_sub_category t0 WHERE t0.metal_work_sub_category_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_updated_at AS image_updated_at_4,
  t0.image_alt AS image_alt_5,
  t0.icon_name AS icon_name_6,
  t0.icon_size AS icon_size_7,
  t0.icon_updated_at AS icon_updated_at_8,
  t0.icon_alt AS icon_alt_9,
  t0.sub_title AS sub_title_10,
  t0.skill_title AS skill_title_11,
  t0.page_title AS page_title_12,
  t0.resume AS resume_13,
  t0.paragraph_sub_title AS paragraph_sub_title_14,
  t0.paragraph_title AS paragraph_title_15,
  t0.contact_sub_title AS contact_sub_title_16,
  t0.contact_title AS contact_title_17,
  t0.contact_text AS contact_text_18,
  t0.contact_cta_text AS contact_cta_text_19,
  t0.contact_cta_link AS contact_cta_link_20,
  t0.contact_cta_external AS contact_cta_external_21,
  t0.meta_title AS meta_title_22,
  t0.meta_description AS meta_description_23,
  t0.slug AS slug_24,
  t0.metal_work_sub_category_id AS metal_work_sub_category_id_25
FROM
  metal_work_sub_sub_category t0
WHERE
  t0.metal_work_sub_category_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.icon_name AS icon_name_6, t0.icon_size AS icon_size_7, t0.icon_updated_at AS icon_updated_at_8, t0.icon_alt AS icon_alt_9, t0.sub_title AS sub_title_10, t0.skill_title AS skill_title_11, t0.page_title AS page_title_12, t0.resume AS resume_13, t0.paragraph_sub_title AS paragraph_sub_title_14, t0.paragraph_title AS paragraph_title_15, t0.contact_sub_title AS contact_sub_title_16, t0.contact_title AS contact_title_17, t0.contact_text AS contact_text_18, t0.contact_cta_text AS contact_cta_text_19, t0.contact_cta_link AS contact_cta_link_20, t0.contact_cta_external AS contact_cta_external_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.slug AS slug_24, t0.metal_work_sub_category_id AS metal_work_sub_category_id_25 FROM metal_work_sub_sub_category t0 WHERE t0.metal_work_sub_category_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 97)
4	App\Twig\AppExtension->getMetalWorkSubSubCategories (line 252)
5	__TwigTemplate_7616a1c01cf514976760711bed31ac29->block_header (line 442)
6	Twig\Template->yieldBlock (line 57)
7	__TwigTemplate_7616a1c01cf514976760711bed31ac29->doDisplay (line 398)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
10	Twig\Template->yield (line 57)
11	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
12	Twig\Template->yield (line 53)
13	__TwigTemplate_4afdf758d2a14de34948cf4270502594->doDisplay (line 398)
14	Twig\Template->yield (line 354)
15	Twig\Template->display (line 369)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 114)
22	App\Controller\FrontController->metalWorkCategory (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

7.46 ms
(26.31%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.icon_name AS icon_name_6, t0.icon_size AS icon_size_7, t0.icon_updated_at AS icon_updated_at_8, t0.icon_alt AS icon_alt_9, t0.sub_title AS sub_title_10, t0.skill_title AS skill_title_11, t0.page_title AS page_title_12, t0.resume AS resume_13, t0.paragraph_sub_title AS paragraph_sub_title_14, t0.paragraph_title AS paragraph_title_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.slug AS slug_18 FROM metal_work_sub_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_updated_at AS image_updated_at_4,
  t0.image_alt AS image_alt_5,
  t0.icon_name AS icon_name_6,
  t0.icon_size AS icon_size_7,
  t0.icon_updated_at AS icon_updated_at_8,
  t0.icon_alt AS icon_alt_9,
  t0.sub_title AS sub_title_10,
  t0.skill_title AS skill_title_11,
  t0.page_title AS page_title_12,
  t0.resume AS resume_13,
  t0.paragraph_sub_title AS paragraph_sub_title_14,
  t0.paragraph_title AS paragraph_title_15,
  t0.meta_title AS meta_title_16,
  t0.meta_description AS meta_description_17,
  t0.slug AS slug_18
FROM
  metal_work_sub_category t0

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.icon_name AS icon_name_6, t0.icon_size AS icon_size_7, t0.icon_updated_at AS icon_updated_at_8, t0.icon_alt AS icon_alt_9, t0.sub_title AS sub_title_10, t0.skill_title AS skill_title_11, t0.page_title AS page_title_12, t0.resume AS resume_13, t0.paragraph_sub_title AS paragraph_sub_title_14, t0.paragraph_title AS paragraph_title_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.slug AS slug_18 FROM metal_work_sub_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 92)
5	App\Twig\AppExtension->getMetalWorkSubCategories (line 231)
6	__TwigTemplate_7616a1c01cf514976760711bed31ac29->block_header (line 442)
7	Twig\Template->yieldBlock (line 57)
8	__TwigTemplate_7616a1c01cf514976760711bed31ac29->doDisplay (line 398)
9	Twig\Template->yield (line 156)
10	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
11	Twig\Template->yield (line 57)
12	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_4afdf758d2a14de34948cf4270502594->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 114)
23	App\Controller\FrontController->metalWorkCategory (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

4.35 ms
(15.34%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 41)
5	Cofondateur\SocleTechniqueBundle\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.74 ms
(9.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_hp AS display_hp_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt AS image_alt_7, t0.sub_title AS sub_title_8, t0.page_title AS page_title_9, t0.resume AS resume_10, t0.seo_sub_title AS seo_sub_title_11, t0.seo_title AS seo_title_12, t0.seo_text AS seo_text_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16 FROM machine_tool_protector_sub_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_hp AS display_hp_3,
  t0.image_name AS image_name_4,
  t0.image_size AS image_size_5,
  t0.image_updated_at AS image_updated_at_6,
  t0.image_alt AS image_alt_7,
  t0.sub_title AS sub_title_8,
  t0.page_title AS page_title_9,
  t0.resume AS resume_10,
  t0.seo_sub_title AS seo_sub_title_11,
  t0.seo_title AS seo_title_12,
  t0.seo_text AS seo_text_13,
  t0.meta_title AS meta_title_14,
  t0.meta_description AS meta_description_15,
  t0.slug AS slug_16
FROM
  machine_tool_protector_sub_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_hp AS display_hp_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt AS image_alt_7, t0.sub_title AS sub_title_8, t0.page_title AS page_title_9, t0.resume AS resume_10, t0.seo_sub_title AS seo_sub_title_11, t0.seo_title AS seo_title_12, t0.seo_text AS seo_text_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16 FROM machine_tool_protector_sub_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 102)
5	App\Twig\AppExtension->getMachineToolProtectorSubCategories (line 477)
6	__TwigTemplate_7616a1c01cf514976760711bed31ac29->block_header (line 442)
7	Twig\Template->yieldBlock (line 57)
8	__TwigTemplate_7616a1c01cf514976760711bed31ac29->doDisplay (line 398)
9	Twig\Template->yield (line 156)
10	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
11	Twig\Template->yield (line 57)
12	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_4afdf758d2a14de34948cf4270502594->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 114)
23	App\Controller\FrontController->metalWorkCategory (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.50 ms
(5.28%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.link AS link_4, t0.width AS width_5, t0.position AS position_6, t0.metal_work_category_id AS metal_work_category_id_7, t0.metal_work_sub_sub_category_id AS metal_work_sub_sub_category_id_8, t0.metal_work_machine_park_page_id AS metal_work_machine_park_page_id_9, t0.machine_tool_protector_category_id AS machine_tool_protector_category_id_10 FROM colorful_block t0 WHERE t0.metal_work_category_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.title AS title_2,
  t0.text AS text_3,
  t0.link AS link_4,
  t0.width AS width_5,
  t0.position AS position_6,
  t0.metal_work_category_id AS metal_work_category_id_7,
  t0.metal_work_sub_sub_category_id AS metal_work_sub_sub_category_id_8,
  t0.metal_work_machine_park_page_id AS metal_work_machine_park_page_id_9,
  t0.machine_tool_protector_category_id AS machine_tool_protector_category_id_10
FROM
  colorful_block t0
WHERE
  t0.metal_work_category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.link AS link_4, t0.width AS width_5, t0.position AS position_6, t0.metal_work_category_id AS metal_work_category_id_7, t0.metal_work_sub_sub_category_id AS metal_work_sub_sub_category_id_8, t0.metal_work_machine_park_page_id AS metal_work_machine_park_page_id_9, t0.machine_tool_protector_category_id AS machine_tool_protector_category_id_10 FROM colorful_block t0 WHERE t0.metal_work_category_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 326)
9	__TwigTemplate_4afdf758d2a14de34948cf4270502594->block_body (line 442)
10	Twig\Template->yieldBlock (line 161)
11	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
12	Twig\Template->yield (line 57)
13	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
14	Twig\Template->yield (line 53)
15	__TwigTemplate_4afdf758d2a14de34948cf4270502594->doDisplay (line 398)
16	Twig\Template->yield (line 354)
17	Twig\Template->display (line 369)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 114)
24	App\Controller\FrontController->metalWorkCategory (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.71 ms
(2.49%)

SELECT t0.id AS id_1, t0.category AS category_2, t0.image1_name AS image1_name_3, t0.image1_size AS image1_size_4, t0.image1_updated_at AS image1_updated_at_5, t0.image1_alt AS image1_alt_6, t0.image2_name AS image2_name_7, t0.image2_size AS image2_size_8, t0.image2_updated_at AS image2_updated_at_9, t0.image2_alt AS image2_alt_10, t0.logo_name AS logo_name_11, t0.logo_size AS logo_size_12, t0.logo_updated_at AS logo_updated_at_13, t0.logo_alt AS logo_alt_14, t0.youtube_url_original AS youtube_url_original_15, t0.youtube_url_embed AS youtube_url_embed_16, t0.title AS title_17, t0.text AS text_18, t0.quote AS quote_19, t0.cta_text AS cta_text_20, t0.cta_link AS cta_link_21, t0.cta_external AS cta_external_22, t0.pdf_name AS pdf_name_23, t0.pdf_label AS pdf_label_24, t0.pdf_size AS pdf_size_25, t0.pdf_updated_at AS pdf_updated_at_26, t0.pdf_extension AS pdf_extension_27, t0.second_title AS second_title_28, t0.second_text AS second_text_29, t0.second_quote AS second_quote_30, t0.second_cta_text AS second_cta_text_31, t0.second_cta_link AS second_cta_link_32, t0.second_cta_external AS second_cta_external_33, t0.second_pdf_name AS second_pdf_name_34, t0.second_pdf_label AS second_pdf_label_35, t0.second_pdf_size AS second_pdf_size_36, t0.second_pdf_updated_at AS second_pdf_updated_at_37, t0.second_pdf_extension AS second_pdf_extension_38, t0.position AS position_39, t0.about_page_id AS about_page_id_40, t0.guarantees_page_id AS guarantees_page_id_41, t0.metal_work_category_id AS metal_work_category_id_42, t0.metal_work_sub_category_id AS metal_work_sub_category_id_43, t0.metal_work_sub_sub_category_id AS metal_work_sub_sub_category_id_44, t0.metal_work_service_page_id AS metal_work_service_page_id_45, t0.metal_work_machine_park_page_id AS metal_work_machine_park_page_id_46, t0.machine_tool_protector_category_id AS machine_tool_protector_category_id_47, t0.legislation_norm_page_id AS legislation_norm_page_id_48 FROM paragraph t0 WHERE t0.metal_work_category_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.category AS category_2,
  t0.image1_name AS image1_name_3,
  t0.image1_size AS image1_size_4,
  t0.image1_updated_at AS image1_updated_at_5,
  t0.image1_alt AS image1_alt_6,
  t0.image2_name AS image2_name_7,
  t0.image2_size AS image2_size_8,
  t0.image2_updated_at AS image2_updated_at_9,
  t0.image2_alt AS image2_alt_10,
  t0.logo_name AS logo_name_11,
  t0.logo_size AS logo_size_12,
  t0.logo_updated_at AS logo_updated_at_13,
  t0.logo_alt AS logo_alt_14,
  t0.youtube_url_original AS youtube_url_original_15,
  t0.youtube_url_embed AS youtube_url_embed_16,
  t0.title AS title_17,
  t0.text AS text_18,
  t0.quote AS quote_19,
  t0.cta_text AS cta_text_20,
  t0.cta_link AS cta_link_21,
  t0.cta_external AS cta_external_22,
  t0.pdf_name AS pdf_name_23,
  t0.pdf_label AS pdf_label_24,
  t0.pdf_size AS pdf_size_25,
  t0.pdf_updated_at AS pdf_updated_at_26,
  t0.pdf_extension AS pdf_extension_27,
  t0.second_title AS second_title_28,
  t0.second_text AS second_text_29,
  t0.second_quote AS second_quote_30,
  t0.second_cta_text AS second_cta_text_31,
  t0.second_cta_link AS second_cta_link_32,
  t0.second_cta_external AS second_cta_external_33,
  t0.second_pdf_name AS second_pdf_name_34,
  t0.second_pdf_label AS second_pdf_label_35,
  t0.second_pdf_size AS second_pdf_size_36,
  t0.second_pdf_updated_at AS second_pdf_updated_at_37,
  t0.second_pdf_extension AS second_pdf_extension_38,
  t0.position AS position_39,
  t0.about_page_id AS about_page_id_40,
  t0.guarantees_page_id AS guarantees_page_id_41,
  t0.metal_work_category_id AS metal_work_category_id_42,
  t0.metal_work_sub_category_id AS metal_work_sub_category_id_43,
  t0.metal_work_sub_sub_category_id AS metal_work_sub_sub_category_id_44,
  t0.metal_work_service_page_id AS metal_work_service_page_id_45,
  t0.metal_work_machine_park_page_id AS metal_work_machine_park_page_id_46,
  t0.machine_tool_protector_category_id AS machine_tool_protector_category_id_47,
  t0.legislation_norm_page_id AS legislation_norm_page_id_48
FROM
  paragraph t0
WHERE
  t0.metal_work_category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.category AS category_2, t0.image1_name AS image1_name_3, t0.image1_size AS image1_size_4, t0.image1_updated_at AS image1_updated_at_5, t0.image1_alt AS image1_alt_6, t0.image2_name AS image2_name_7, t0.image2_size AS image2_size_8, t0.image2_updated_at AS image2_updated_at_9, t0.image2_alt AS image2_alt_10, t0.logo_name AS logo_name_11, t0.logo_size AS logo_size_12, t0.logo_updated_at AS logo_updated_at_13, t0.logo_alt AS logo_alt_14, t0.youtube_url_original AS youtube_url_original_15, t0.youtube_url_embed AS youtube_url_embed_16, t0.title AS title_17, t0.text AS text_18, t0.quote AS quote_19, t0.cta_text AS cta_text_20, t0.cta_link AS cta_link_21, t0.cta_external AS cta_external_22, t0.pdf_name AS pdf_name_23, t0.pdf_label AS pdf_label_24, t0.pdf_size AS pdf_size_25, t0.pdf_updated_at AS pdf_updated_at_26, t0.pdf_extension AS pdf_extension_27, t0.second_title AS second_title_28, t0.second_text AS second_text_29, t0.second_quote AS second_quote_30, t0.second_cta_text AS second_cta_text_31, t0.second_cta_link AS second_cta_link_32, t0.second_cta_external AS second_cta_external_33, t0.second_pdf_name AS second_pdf_name_34, t0.second_pdf_label AS second_pdf_label_35, t0.second_pdf_size AS second_pdf_size_36, t0.second_pdf_updated_at AS second_pdf_updated_at_37, t0.second_pdf_extension AS second_pdf_extension_38, t0.position AS position_39, t0.about_page_id AS about_page_id_40, t0.guarantees_page_id AS guarantees_page_id_41, t0.metal_work_category_id AS metal_work_category_id_42, t0.metal_work_sub_category_id AS metal_work_sub_category_id_43, t0.metal_work_sub_sub_category_id AS metal_work_sub_sub_category_id_44, t0.metal_work_service_page_id AS metal_work_service_page_id_45, t0.metal_work_machine_park_page_id AS metal_work_machine_park_page_id_46, t0.machine_tool_protector_category_id AS machine_tool_protector_category_id_47, t0.legislation_norm_page_id AS legislation_norm_page_id_48 FROM paragraph t0 WHERE t0.metal_work_category_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 184)
9	__TwigTemplate_4afdf758d2a14de34948cf4270502594->block_body (line 442)
10	Twig\Template->yieldBlock (line 161)
11	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
12	Twig\Template->yield (line 57)
13	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
14	Twig\Template->yield (line 53)
15	__TwigTemplate_4afdf758d2a14de34948cf4270502594->doDisplay (line 398)
16	Twig\Template->yield (line 354)
17	Twig\Template->display (line 369)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 114)
24	App\Controller\FrontController->metalWorkCategory (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.43 ms
(1.51%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.sub_title AS sub_title_6, t0.work_title AS work_title_7, t0.page_title AS page_title_8, t0.resume AS resume_9, t0.paragraph_sub_title AS paragraph_sub_title_10, t0.paragraph_title AS paragraph_title_11, t0.last_section_sub_title AS last_section_sub_title_12, t0.last_section_title AS last_section_title_13, t0.last_section_text AS last_section_text_14, t0.last_section_cta_text AS last_section_cta_text_15, t0.last_section_cta_link AS last_section_cta_link_16, t0.last_section_cta_external AS last_section_cta_external_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19 FROM metal_work_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_updated_at AS image_updated_at_4,
  t0.image_alt AS image_alt_5,
  t0.sub_title AS sub_title_6,
  t0.work_title AS work_title_7,
  t0.page_title AS page_title_8,
  t0.resume AS resume_9,
  t0.paragraph_sub_title AS paragraph_sub_title_10,
  t0.paragraph_title AS paragraph_title_11,
  t0.last_section_sub_title AS last_section_sub_title_12,
  t0.last_section_title AS last_section_title_13,
  t0.last_section_text AS last_section_text_14,
  t0.last_section_cta_text AS last_section_cta_text_15,
  t0.last_section_cta_link AS last_section_cta_link_16,
  t0.last_section_cta_external AS last_section_cta_external_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19
FROM
  metal_work_category t0

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.sub_title AS sub_title_6, t0.work_title AS work_title_7, t0.page_title AS page_title_8, t0.resume AS resume_9, t0.paragraph_sub_title AS paragraph_sub_title_10, t0.paragraph_title AS paragraph_title_11, t0.last_section_sub_title AS last_section_sub_title_12, t0.last_section_title AS last_section_title_13, t0.last_section_text AS last_section_text_14, t0.last_section_cta_text AS last_section_cta_text_15, t0.last_section_cta_link AS last_section_cta_link_16, t0.last_section_cta_external AS last_section_cta_external_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19 FROM metal_work_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 19)
5	Cofondateur\SocleTechniqueBundle\Repository\LoneEntityRepository->findUnique (line 112)
6	App\Controller\FrontController->metalWorkCategory (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.40 ms
(1.40%)

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = ? LIMIT 1

Parameters:

[
  "app_metal_work_category_index"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.page_name AS page_name_2,
  t0.route AS route_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.h1_enabled AS h1_enabled_6,
  t0.h1 AS h1_7
FROM
  seopage t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = 'app_metal_work_category_index' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 36)
4	Cofondateur\SocleTechniqueBundle\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Entities Mapping

Class	Mapping errors
Cofondateur\SocleTechniqueBundle\Entity\SEOPage	No errors.
App\Entity\SEOPage	No errors.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\MetalWorkCategory	No errors.
App\Entity\Paragraph	No errors.
App\Entity\ColorfulBlock	No errors.
App\Entity\MetalWorkSubCategory	No errors.
App\Entity\MetalWorkSubSubCategory	No errors.
App\Entity\MachineToolProtectorSubCategory	No errors.
App\Entity\MachineToolProtectorSubSubCategory	No errors.
App\Entity\AboutPage	No errors.
App\Entity\GuaranteesPage	No errors.
App\Entity\MetalWorkServicePage	No errors.
App\Entity\MetalWorkMachineParkPage	No errors.
App\Entity\MachineToolProtectorCategory	No errors.
App\Entity\LegislationNormPage	No errors.

Symfony Profiler

GET https://parolai.asb-digital.fr/metallerie-chaudronerie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping