Symfony Profiler

Query Metrics

25 Database Queries

9 Different statements

12.96 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.21 ms
(40.19%)

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_1222cb8a51f79103e01bfce580b411b2->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 342)
22	App\Controller\FrontController->listArticles (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)

1.50 ms
(11.55%)

SELECT t0.id AS id_1, t0.color AS color_2, t0.name AS name_3, t0.category_id AS category_id_4 FROM blog_category t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.name AS name_3,
  t0.category_id AS category_id_4
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.color AS color_2, t0.name AS name_3, t0.category_id AS category_id_4 FROM blog_category t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\BlogCategory::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\BlogCategory->__get (line 51)
8	App\Entity\BlogCategory->getColor (line 1740)
9	Twig\Extension\CoreExtension::getAttribute (line 191)
10	__TwigTemplate_1222cb8a51f79103e01bfce580b411b2->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 53)
16	__TwigTemplate_1222cb8a51f79103e01bfce580b411b2->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 342)
25	App\Controller\FrontController->listArticles (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)

1.39 ms
(10.75%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_8 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.created_at AS created_at_8, a0_.slug AS slug_9, a0_.position AS position_10, a0_.meta_title AS meta_title_11, a0_.meta_description AS meta_description_12 FROM article a0_ WHERE a0_.published = ?) dctrn_result_inner ORDER BY created_at_8 DESC) dctrn_result LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_8
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.summary AS summary_2,
          a0_.published AS published_3,
          a0_.picture_name AS picture_name_4,
          a0_.picture_size AS picture_size_5,
          a0_.picture_updated_at AS picture_updated_at_6,
          a0_.picture_alt AS picture_alt_7,
          a0_.created_at AS created_at_8,
          a0_.slug AS slug_9,
          a0_.position AS position_10,
          a0_.meta_title AS meta_title_11,
          a0_.meta_description AS meta_description_12
        FROM
          article a0_
        WHERE
          a0_.published = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_8 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_8 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.created_at AS created_at_8, a0_.slug AS slug_9, a0_.position AS position_10, a0_.meta_title AS meta_title_11, a0_.meta_description AS meta_description_12 FROM article a0_ WHERE a0_.published = 1) dctrn_result_inner ORDER BY created_at_8 DESC) dctrn_result LIMIT 6;

#	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 155)
12	__TwigTemplate_1222cb8a51f79103e01bfce580b411b2->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_1222cb8a51f79103e01bfce580b411b2->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 342)
27	App\Controller\FrontController->listArticles (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)

1.22 ms
(9.44%)

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_1222cb8a51f79103e01bfce580b411b2->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 342)
23	App\Controller\FrontController->listArticles (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.02 ms
(7.90%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.created_at AS created_at_8, a0_.slug AS slug_9, a0_.position AS position_10, a0_.meta_title AS meta_title_11, a0_.meta_description AS meta_description_12 FROM article a0_ WHERE a0_.published = ? ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table

Parameters:

[
  1
]

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_.title AS title_1,
          a0_.summary AS summary_2,
          a0_.published AS published_3,
          a0_.picture_name AS picture_name_4,
          a0_.picture_size AS picture_size_5,
          a0_.picture_updated_at AS picture_updated_at_6,
          a0_.picture_alt AS picture_alt_7,
          a0_.created_at AS created_at_8,
          a0_.slug AS slug_9,
          a0_.position AS position_10,
          a0_.meta_title AS meta_title_11,
          a0_.meta_description AS meta_description_12
        FROM
          article a0_
        WHERE
          a0_.published = ?
        ORDER BY
          a0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.created_at AS created_at_8, a0_.slug AS slug_9, a0_.position AS position_10, a0_.meta_title AS meta_title_11, a0_.meta_description AS meta_description_12 FROM article a0_ WHERE a0_.published = 1 ORDER BY a0_.created_at 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 318)
10	Pagerfanta\Pagerfanta->calculateNbPages (line 300)
11	Pagerfanta\Pagerfanta->getNbPages (line 43)
12	Pagerfanta\View\View->initializePagerfanta (line 29)
13	Pagerfanta\View\TemplateView->render (line 34)
14	Pagerfanta\Twig\Extension\PagerfantaRuntime->renderPagerfanta (line 223)
15	__TwigTemplate_1222cb8a51f79103e01bfce580b411b2->block_body (line 442)
16	Twig\Template->yieldBlock (line 161)
17	__TwigTemplate_44e425bfa4f74c33358a9357cff6f69c->doDisplay (line 398)
18	Twig\Template->yield (line 57)
19	__TwigTemplate_13fe701e2403922e0d27db48879bd5b1->doDisplay (line 398)
20	Twig\Template->yield (line 53)
21	__TwigTemplate_1222cb8a51f79103e01bfce580b411b2->doDisplay (line 398)
22	Twig\Template->yield (line 354)
23	Twig\Template->display (line 369)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 306)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 342)
30	App\Controller\FrontController->listArticles (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.92 ms
(7.10%)

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_1222cb8a51f79103e01bfce580b411b2->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 342)
23	App\Controller\FrontController->listArticles (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.86 ms
(6.63%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.created_at AS created_at_8, a0_.slug AS slug_9, a0_.position AS position_10, a0_.meta_title AS meta_title_11, a0_.meta_description AS meta_description_12, a0_.category_id AS category_id_13 FROM article a0_ WHERE a0_.published = ? AND a0_.id IN (?, ?, ?, ?, ?) ORDER BY a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.summary AS summary_2,
  a0_.published AS published_3,
  a0_.picture_name AS picture_name_4,
  a0_.picture_size AS picture_size_5,
  a0_.picture_updated_at AS picture_updated_at_6,
  a0_.picture_alt AS picture_alt_7,
  a0_.created_at AS created_at_8,
  a0_.slug AS slug_9,
  a0_.position AS position_10,
  a0_.meta_title AS meta_title_11,
  a0_.meta_description AS meta_description_12,
  a0_.category_id AS category_id_13
FROM
  article a0_
WHERE
  a0_.published = ?
  AND a0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.created_at AS created_at_8, a0_.slug AS slug_9, a0_.position AS position_10, a0_.meta_title AS meta_title_11, a0_.meta_description AS meta_description_12, a0_.category_id AS category_id_13 FROM article a0_ WHERE a0_.published = 1 AND a0_.id IN (8, 7, 6, 4, 1) ORDER BY a0_.created_at 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 155)
12	__TwigTemplate_1222cb8a51f79103e01bfce580b411b2->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_1222cb8a51f79103e01bfce580b411b2->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 342)
27	App\Controller\FrontController->listArticles (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.50 ms
(3.84%)

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_article_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_article_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.34 ms
(2.60%)

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)

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\Blog\Article	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\BlogCategory	The association App\Entity\BlogCategory#category refers to the inverse side field App\Entity\BlogCategory#blogs which does not exist.
App\Entity\Blog\ArticleParagraph	No errors.
App\Entity\BlogGalleryItem	No errors.

Symfony Profiler

GET https://parolai.asb-digital.fr/articles

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping