Symfony Profiler

Query Metrics

22 Database Queries

8 Different statements

22.90 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.34 ms
(45.14%)

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 56)
13	__TwigTemplate_5ff13b08b0303c13b9a213cbce087e5c->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 169)
22	App\Controller\FrontController->metalWorkAchievementShow (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)

5.53 ms
(24.14%)

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 56)
14	__TwigTemplate_5ff13b08b0303c13b9a213cbce087e5c->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 169)
23	App\Controller\FrontController->metalWorkAchievementShow (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)

3.23 ms
(14.12%)

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)

1.97 ms
(8.62%)

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 56)
14	__TwigTemplate_5ff13b08b0303c13b9a213cbce087e5c->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 169)
23	App\Controller\FrontController->metalWorkAchievementShow (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)

0.53 ms
(2.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.title AS title_6, t0.resume AS resume_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.slug AS slug_10, t0.category_id AS category_id_11 FROM achievement t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "mobilier-sur-mesure-pour-lieux-conviviaux"
]

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.title AS title_6,
  t0.resume AS resume_7,
  t0.meta_title AS meta_title_8,
  t0.meta_description AS meta_description_9,
  t0.slug AS slug_10,
  t0.category_id AS category_id_11
FROM
  achievement t0
WHERE
  t0.slug = ?
LIMIT
  1

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.title AS title_6, t0.resume AS resume_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.slug AS slug_10, t0.category_id AS category_id_11 FROM achievement t0 WHERE t0.slug = 'mobilier-sur-mesure-pour-lieux-conviviaux' 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 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.49 ms
(2.15%)

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_achievement_show"
]

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_achievement_show' 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)

0.46 ms
(2.01%)

SELECT t0.id AS id_1, t0.category AS category_2, t0.title AS title_3, t0.text AS text_4, t0.quote AS quote_5, t0.cta_text AS cta_text_6, t0.cta_link AS cta_link_7, t0.cta_external AS cta_external_8, t0.pdf_name AS pdf_name_9, t0.pdf_label AS pdf_label_10, t0.pdf_size AS pdf_size_11, t0.pdf_updated_at AS pdf_updated_at_12, t0.pdf_extension AS pdf_extension_13, t0.second_title AS second_title_14, t0.second_text AS second_text_15, t0.second_quote AS second_quote_16, t0.second_cta_text AS second_cta_text_17, t0.second_cta_link AS second_cta_link_18, t0.second_cta_external AS second_cta_external_19, t0.second_pdf_name AS second_pdf_name_20, t0.second_pdf_label AS second_pdf_label_21, t0.second_pdf_size AS second_pdf_size_22, t0.second_pdf_updated_at AS second_pdf_updated_at_23, t0.second_pdf_extension AS second_pdf_extension_24, t0.position AS position_25, t0.achievement_id AS achievement_id_26 FROM achievement_paragraph t0 WHERE t0.achievement_id = ? ORDER BY t0.position ASC

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.title AS title_3,
  t0.text AS text_4,
  t0.quote AS quote_5,
  t0.cta_text AS cta_text_6,
  t0.cta_link AS cta_link_7,
  t0.cta_external AS cta_external_8,
  t0.pdf_name AS pdf_name_9,
  t0.pdf_label AS pdf_label_10,
  t0.pdf_size AS pdf_size_11,
  t0.pdf_updated_at AS pdf_updated_at_12,
  t0.pdf_extension AS pdf_extension_13,
  t0.second_title AS second_title_14,
  t0.second_text AS second_text_15,
  t0.second_quote AS second_quote_16,
  t0.second_cta_text AS second_cta_text_17,
  t0.second_cta_link AS second_cta_link_18,
  t0.second_cta_external AS second_cta_external_19,
  t0.second_pdf_name AS second_pdf_name_20,
  t0.second_pdf_label AS second_pdf_label_21,
  t0.second_pdf_size AS second_pdf_size_22,
  t0.second_pdf_updated_at AS second_pdf_updated_at_23,
  t0.second_pdf_extension AS second_pdf_extension_24,
  t0.position AS position_25,
  t0.achievement_id AS achievement_id_26
FROM
  achievement_paragraph t0
WHERE
  t0.achievement_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.category AS category_2, t0.title AS title_3, t0.text AS text_4, t0.quote AS quote_5, t0.cta_text AS cta_text_6, t0.cta_link AS cta_link_7, t0.cta_external AS cta_external_8, t0.pdf_name AS pdf_name_9, t0.pdf_label AS pdf_label_10, t0.pdf_size AS pdf_size_11, t0.pdf_updated_at AS pdf_updated_at_12, t0.pdf_extension AS pdf_extension_13, t0.second_title AS second_title_14, t0.second_text AS second_text_15, t0.second_quote AS second_quote_16, t0.second_cta_text AS second_cta_text_17, t0.second_cta_link AS second_cta_link_18, t0.second_cta_external AS second_cta_external_19, t0.second_pdf_name AS second_pdf_name_20, t0.second_pdf_label AS second_pdf_label_21, t0.second_pdf_size AS second_pdf_size_22, t0.second_pdf_updated_at AS second_pdf_updated_at_23, t0.second_pdf_extension AS second_pdf_extension_24, t0.position AS position_25, t0.achievement_id AS achievement_id_26 FROM achievement_paragraph t0 WHERE t0.achievement_id = 8 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 357)
9	__TwigTemplate_5ff13b08b0303c13b9a213cbce087e5c->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 56)
15	__TwigTemplate_5ff13b08b0303c13b9a213cbce087e5c->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 169)
24	App\Controller\FrontController->metalWorkAchievementShow (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.35 ms
(1.52%)

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.legend AS legend_6, t0.position AS position_7, t0.achievement_id AS achievement_id_8 FROM achievement_gallery_item t0 WHERE t0.achievement_id = ? ORDER BY t0.position ASC

Parameters:

[
  8
]

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.legend AS legend_6,
  t0.position AS position_7,
  t0.achievement_id AS achievement_id_8
FROM
  achievement_gallery_item t0
WHERE
  t0.achievement_id = ?
ORDER BY
  t0.position ASC

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.legend AS legend_6, t0.position AS position_7, t0.achievement_id AS achievement_id_8 FROM achievement_gallery_item t0 WHERE t0.achievement_id = 8 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 1187)
9	Twig\Extension\CoreExtension::length (line 396)
10	__TwigTemplate_5ff13b08b0303c13b9a213cbce087e5c->block_body (line 442)
11	Twig\Template->yieldBlock (line 161)
12	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
15	Twig\Template->yield (line 56)
16	__TwigTemplate_5ff13b08b0303c13b9a213cbce087e5c->doDisplay (line 398)
17	Twig\Template->yield (line 354)
18	Twig\Template->display (line 369)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 169)
25	App\Controller\FrontController->metalWorkAchievementShow (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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\Achievement	No errors.
App\Entity\AchievementCategory	No errors.
App\Entity\AchievementParagraph	No errors.
App\Entity\AchievementGalleryItem	No errors.
App\Entity\MetalWorkSubCategory	No errors.
App\Entity\Paragraph	No errors.
App\Entity\MetalWorkSubSubCategory	No errors.
App\Entity\ColorfulBlock	No errors.
App\Entity\MachineToolProtectorSubCategory	No errors.
App\Entity\MachineToolProtectorSubSubCategory	No errors.

Symfony Profiler

GET https://parolai.asb-digital.fr/metallerie-chaudronerie/realisation/mobilier-sur-mesure-pour-lieux-conviviaux

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping