Symfony Profiler

Query Metrics

24 Database Queries

10 Different statements

22.56 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.41 ms
(55.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_01a28628ad484fde46ff356d072cb496->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 159)
22	App\Controller\FrontController->metalWorkAchievementList (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)

3.23 ms
(14.34%)

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_01a28628ad484fde46ff356d072cb496->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 159)
23	App\Controller\FrontController->metalWorkAchievementList (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)

2.78 ms
(12.32%)

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_01a28628ad484fde46ff356d072cb496->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 159)
23	App\Controller\FrontController->metalWorkAchievementList (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.85 ms
(3.78%)

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

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_list' 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.64 ms
(2.84%)

SELECT a0_.id AS id_0, a0_.image_name AS image_name_1, a0_.image_size AS image_size_2, a0_.image_updated_at AS image_updated_at_3, a0_.image_alt AS image_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.slug AS slug_9, a0_.category_id AS category_id_10 FROM achievement a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.image_name AS image_name_1,
  a0_.image_size AS image_size_2,
  a0_.image_updated_at AS image_updated_at_3,
  a0_.image_alt AS image_alt_4,
  a0_.title AS title_5,
  a0_.resume AS resume_6,
  a0_.meta_title AS meta_title_7,
  a0_.meta_description AS meta_description_8,
  a0_.slug AS slug_9,
  a0_.category_id AS category_id_10
FROM
  achievement a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.image_name AS image_name_1, a0_.image_size AS image_size_2, a0_.image_updated_at AS image_updated_at_3, a0_.image_alt AS image_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.slug AS slug_9, a0_.category_id AS category_id_10 FROM achievement a0_ WHERE a0_.id IN (12, 11, 10, 9, 8, 7, 6, 5, 4) ORDER BY a0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 249)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 415)
11	Pagerfanta\Pagerfanta->getIterator (line 253)
12	__TwigTemplate_01a28628ad484fde46ff356d072cb496->block_body (line 442)
13	Twig\Template->yieldBlock (line 161)
14	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
17	Twig\Template->yield (line 53)
18	__TwigTemplate_01a28628ad484fde46ff356d072cb496->doDisplay (line 398)
19	Twig\Template->yield (line 354)
20	Twig\Template->display (line 369)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 159)
27	App\Controller\FrontController->metalWorkAchievementList (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.62 ms
(2.77%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.image_name AS image_name_1, a0_.image_size AS image_size_2, a0_.image_updated_at AS image_updated_at_3, a0_.image_alt AS image_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.slug AS slug_9 FROM achievement a0_ ORDER BY a0_.id DESC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.image_name AS image_name_1,
          a0_.image_size AS image_size_2,
          a0_.image_updated_at AS image_updated_at_3,
          a0_.image_alt AS image_alt_4,
          a0_.title AS title_5,
          a0_.resume AS resume_6,
          a0_.meta_title AS meta_title_7,
          a0_.meta_description AS meta_description_8,
          a0_.slug AS slug_9
        FROM
          achievement a0_
        ORDER BY
          a0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.image_name AS image_name_1, a0_.image_size AS image_size_2, a0_.image_updated_at AS image_updated_at_3, a0_.image_alt AS image_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.slug AS slug_9 FROM achievement a0_ ORDER BY a0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 42)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 292)
9	Pagerfanta\Pagerfanta->getNbResults (line 405)
10	Pagerfanta\Pagerfanta->count (line 247)
11	__TwigTemplate_01a28628ad484fde46ff356d072cb496->block_body (line 442)
12	Twig\Template->yieldBlock (line 161)
13	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
16	Twig\Template->yield (line 53)
17	__TwigTemplate_01a28628ad484fde46ff356d072cb496->doDisplay (line 398)
18	Twig\Template->yield (line 354)
19	Twig\Template->display (line 369)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 306)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 159)
26	App\Controller\FrontController->metalWorkAchievementList (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.59 ms
(2.59%)

SELECT t0.id AS id_1, t0.main_sub_title AS main_sub_title_2, t0.main_title AS main_title_3, t0.main_resume AS main_resume_4, t0.default_title AS default_title_5, t0.default_description AS default_description_6, t0.last_section_sub_title AS last_section_sub_title_7, t0.last_section_title AS last_section_title_8, t0.last_section_text AS last_section_text_9, t0.last_section_cta_text AS last_section_cta_text_10, t0.last_section_cta_link AS last_section_cta_link_11, t0.last_section_cta_external AS last_section_cta_external_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14 FROM achievement_page t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.main_sub_title AS main_sub_title_2,
  t0.main_title AS main_title_3,
  t0.main_resume AS main_resume_4,
  t0.default_title AS default_title_5,
  t0.default_description AS default_description_6,
  t0.last_section_sub_title AS last_section_sub_title_7,
  t0.last_section_title AS last_section_title_8,
  t0.last_section_text AS last_section_text_9,
  t0.last_section_cta_text AS last_section_cta_text_10,
  t0.last_section_cta_link AS last_section_cta_link_11,
  t0.last_section_cta_external AS last_section_cta_external_12,
  t0.meta_title AS meta_title_13,
  t0.meta_description AS meta_description_14
FROM
  achievement_page t0

SELECT t0.id AS id_1, t0.main_sub_title AS main_sub_title_2, t0.main_title AS main_title_3, t0.main_resume AS main_resume_4, t0.default_title AS default_title_5, t0.default_description AS default_description_6, t0.last_section_sub_title AS last_section_sub_title_7, t0.last_section_title AS last_section_title_8, t0.last_section_text AS last_section_text_9, t0.last_section_cta_text AS last_section_cta_text_10, t0.last_section_cta_link AS last_section_cta_link_11, t0.last_section_cta_external AS last_section_cta_external_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14 FROM achievement_page 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 162)
6	App\Controller\FrontController->metalWorkAchievementList (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.50 ms
(2.21%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.image_name AS image_name_1, a0_.image_size AS image_size_2, a0_.image_updated_at AS image_updated_at_3, a0_.image_alt AS image_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.slug AS slug_9 FROM achievement a0_) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 9

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.image_name AS image_name_1,
          a0_.image_size AS image_size_2,
          a0_.image_updated_at AS image_updated_at_3,
          a0_.image_alt AS image_alt_4,
          a0_.title AS title_5,
          a0_.resume AS resume_6,
          a0_.meta_title AS meta_title_7,
          a0_.meta_description AS meta_description_8,
          a0_.slug AS slug_9
        FROM
          achievement a0_
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  9

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.image_name AS image_name_1, a0_.image_size AS image_size_2, a0_.image_updated_at AS image_updated_at_3, a0_.image_alt AS image_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.slug AS slug_9 FROM achievement a0_) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 249)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 415)
11	Pagerfanta\Pagerfanta->getIterator (line 253)
12	__TwigTemplate_01a28628ad484fde46ff356d072cb496->block_body (line 442)
13	Twig\Template->yieldBlock (line 161)
14	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
17	Twig\Template->yield (line 53)
18	__TwigTemplate_01a28628ad484fde46ff356d072cb496->doDisplay (line 398)
19	Twig\Template->yield (line 354)
20	Twig\Template->display (line 369)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 159)
27	App\Controller\FrontController->metalWorkAchievementList (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.48 ms
(2.13%)

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)

0.45 ms
(2.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.title AS title_4, t0.text AS text_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8 FROM achievement_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.color AS color_3,
  t0.title AS title_4,
  t0.text AS text_5,
  t0.slug AS slug_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8
FROM
  achievement_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.title AS title_4, t0.text AS text_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8 FROM achievement_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 107)
5	App\Twig\AppExtension->getMetalWorkAchievementCategories (line 180)
6	__TwigTemplate_01a28628ad484fde46ff356d072cb496->block_body (line 442)
7	Twig\Template->yieldBlock (line 161)
8	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
9	Twig\Template->yield (line 57)
10	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_01a28628ad484fde46ff356d072cb496->doDisplay (line 398)
13	Twig\Template->yield (line 354)
14	Twig\Template->display (line 369)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 159)
21	App\Controller\FrontController->metalWorkAchievementList (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\AchievementPage	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.
App\Entity\AchievementCategory	No errors.
App\Entity\AchievementParagraph	No errors.
App\Entity\AchievementGalleryItem	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping