Symfony Profiler

Query Metrics

24 Database Queries

13 Different statements

5.47 ms Query time

0 Invalid entities

38 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.25 ms
(22.81%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.export AS export_4, t0.gallery_over_title AS gallery_over_title_5, t0.gallery_title AS gallery_title_6, t0.gallery_content AS gallery_content_7, t0.picture_name AS picture_name_8, t0.picture_size AS picture_size_9, t0.picture_updated_at AS picture_updated_at_10, t0.picture_alt AS picture_alt_11, t0.published_at AS published_at_12, t0.created_at AS created_at_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.is_published AS is_published_17, t0.sub_category_id AS sub_category_id_18, t0.homepage_id AS homepage_id_19 FROM reference t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_id WHERE reference_category_link.reference_category_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.summary AS summary_3,
  t0.export AS export_4,
  t0.gallery_over_title AS gallery_over_title_5,
  t0.gallery_title AS gallery_title_6,
  t0.gallery_content AS gallery_content_7,
  t0.picture_name AS picture_name_8,
  t0.picture_size AS picture_size_9,
  t0.picture_updated_at AS picture_updated_at_10,
  t0.picture_alt AS picture_alt_11,
  t0.published_at AS published_at_12,
  t0.created_at AS created_at_13,
  t0.meta_title AS meta_title_14,
  t0.meta_description AS meta_description_15,
  t0.slug AS slug_16,
  t0.is_published AS is_published_17,
  t0.sub_category_id AS sub_category_id_18,
  t0.homepage_id AS homepage_id_19
FROM
  reference t0
  INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_id
WHERE
  reference_category_link.reference_category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.export AS export_4, t0.gallery_over_title AS gallery_over_title_5, t0.gallery_title AS gallery_title_6, t0.gallery_content AS gallery_content_7, t0.picture_name AS picture_name_8, t0.picture_size AS picture_size_9, t0.picture_updated_at AS picture_updated_at_10, t0.picture_alt AS picture_alt_11, t0.published_at AS published_at_12, t0.created_at AS created_at_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.is_published AS is_published_17, t0.sub_category_id AS sub_category_id_18, t0.homepage_id AS homepage_id_19 FROM reference t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_id WHERE reference_category_link.reference_category_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1130)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1052)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 96)
8	App\Entity\ReferenceCategory->hasRef (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 135)
10	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->block_body (line 431)
11	Twig\Template->yieldBlock (line 167)
12	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
13	Twig\Template->yield (line 69)
14	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
15	Twig\Template->yield (line 56)
16	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 320)
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 215)
25	App\Controller\FrontController->listReferencesBySubCat (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.00 ms
(18.32%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16 FROM reference r0_ WHERE r0_.is_published = 1 AND r0_.sub_category_id = ? ORDER BY r0_.published_at DESC, r0_.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
          r0_.id AS id_0,
          r0_.title AS title_1,
          r0_.summary AS summary_2,
          r0_.export AS export_3,
          r0_.gallery_over_title AS gallery_over_title_4,
          r0_.gallery_title AS gallery_title_5,
          r0_.gallery_content AS gallery_content_6,
          r0_.picture_name AS picture_name_7,
          r0_.picture_size AS picture_size_8,
          r0_.picture_updated_at AS picture_updated_at_9,
          r0_.picture_alt AS picture_alt_10,
          r0_.published_at AS published_at_11,
          r0_.created_at AS created_at_12,
          r0_.meta_title AS meta_title_13,
          r0_.meta_description AS meta_description_14,
          r0_.slug AS slug_15,
          r0_.is_published AS is_published_16
        FROM
          reference r0_
        WHERE
          r0_.is_published = 1
          AND r0_.sub_category_id = ?
        ORDER BY
          r0_.published_at DESC,
          r0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16 FROM reference r0_ WHERE r0_.is_published = 1 AND r0_.sub_category_id = 1 ORDER BY r0_.published_at DESC, r0_.created_at DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 42)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 300)
9	Pagerfanta\Pagerfanta->getNbResults (line 326)
10	Pagerfanta\Pagerfanta->calculateNbPages (line 308)
11	Pagerfanta\Pagerfanta->getNbPages (line 45)
12	App\Twig\Components\Reference\ReferenceList->getReferences (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 48)
14	__TwigTemplate_a62217c405daccd7ee0937c9adef3a49->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 77)
18	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
19	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
20	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 292)
21	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->block_body (line 431)
22	Twig\Template->yieldBlock (line 167)
23	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
24	Twig\Template->yield (line 69)
25	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
26	Twig\Template->yield (line 56)
27	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
28	Twig\Template->yield (line 343)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 35)
31	Twig\TemplateWrapper->render (line 320)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
36	App\Controller\FrontController->listReferencesBySubCat (line 178)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

0.61 ms
(11.19%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_category_id WHERE reference_category_link.reference_id = ? ORDER BY t0.position ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.position AS position_5,
  t0.slug AS slug_6
FROM
  reference_category t0
  INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_category_id
WHERE
  reference_category_link.reference_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_category_id WHERE reference_category_link.reference_id = 4 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1130)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1052)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 101)
8	__TwigTemplate_55c1bb75c6e68f75d3cc2926462125b6->doDisplay (line 387)
9	Twig\Template->yield (line 343)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 60)
15	__TwigTemplate_a62217c405daccd7ee0937c9adef3a49->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 77)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
21	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 292)
22	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->block_body (line 431)
23	Twig\Template->yieldBlock (line 167)
24	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
25	Twig\Template->yield (line 69)
26	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
27	Twig\Template->yield (line 56)
28	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
29	Twig\Template->yield (line 343)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 35)
32	Twig\TemplateWrapper->render (line 320)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
37	App\Controller\FrontController->listReferencesBySubCat (line 178)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.53 ms
(9.75%)

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16, r0_.sub_category_id AS sub_category_id_17, r0_.homepage_id AS homepage_id_18 FROM reference r0_ WHERE r0_.is_published = 1 AND r0_.sub_category_id = ? AND r0_.id IN (?, ?, ?, ?) ORDER BY r0_.published_at DESC, r0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.summary AS summary_2,
  r0_.export AS export_3,
  r0_.gallery_over_title AS gallery_over_title_4,
  r0_.gallery_title AS gallery_title_5,
  r0_.gallery_content AS gallery_content_6,
  r0_.picture_name AS picture_name_7,
  r0_.picture_size AS picture_size_8,
  r0_.picture_updated_at AS picture_updated_at_9,
  r0_.picture_alt AS picture_alt_10,
  r0_.published_at AS published_at_11,
  r0_.created_at AS created_at_12,
  r0_.meta_title AS meta_title_13,
  r0_.meta_description AS meta_description_14,
  r0_.slug AS slug_15,
  r0_.is_published AS is_published_16,
  r0_.sub_category_id AS sub_category_id_17,
  r0_.homepage_id AS homepage_id_18
FROM
  reference r0_
WHERE
  r0_.is_published = 1
  AND r0_.sub_category_id = ?
  AND r0_.id IN (?, ?, ?, ?)
ORDER BY
  r0_.published_at DESC,
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16, r0_.sub_category_id AS sub_category_id_17, r0_.homepage_id AS homepage_id_18 FROM reference r0_ WHERE r0_.is_published = 1 AND r0_.sub_category_id = 1 AND r0_.id IN (4, 8, 9, 10) ORDER BY r0_.published_at DESC, r0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 268)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 427)
11	Pagerfanta\Pagerfanta->getIterator (line 55)
12	__TwigTemplate_a62217c405daccd7ee0937c9adef3a49->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 292)
19	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->block_body (line 431)
20	Twig\Template->yieldBlock (line 167)
21	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
22	Twig\Template->yield (line 69)
23	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
24	Twig\Template->yield (line 56)
25	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
26	Twig\Template->yield (line 343)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 35)
29	Twig\TemplateWrapper->render (line 320)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
34	App\Controller\FrontController->listReferencesBySubCat (line 178)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.51 ms
(9.35%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_11, created_at_12 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16 FROM reference r0_ WHERE r0_.is_published = 1 AND r0_.sub_category_id = ?) dctrn_result_inner ORDER BY published_at_11 DESC, created_at_12 DESC) dctrn_result LIMIT 20

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_11,
      created_at_12
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.title AS title_1,
          r0_.summary AS summary_2,
          r0_.export AS export_3,
          r0_.gallery_over_title AS gallery_over_title_4,
          r0_.gallery_title AS gallery_title_5,
          r0_.gallery_content AS gallery_content_6,
          r0_.picture_name AS picture_name_7,
          r0_.picture_size AS picture_size_8,
          r0_.picture_updated_at AS picture_updated_at_9,
          r0_.picture_alt AS picture_alt_10,
          r0_.published_at AS published_at_11,
          r0_.created_at AS created_at_12,
          r0_.meta_title AS meta_title_13,
          r0_.meta_description AS meta_description_14,
          r0_.slug AS slug_15,
          r0_.is_published AS is_published_16
        FROM
          reference r0_
        WHERE
          r0_.is_published = 1
          AND r0_.sub_category_id = ?
      ) dctrn_result_inner
    ORDER BY
      published_at_11 DESC,
      created_at_12 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_11, created_at_12 FROM (SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.summary AS summary_2, r0_.export AS export_3, r0_.gallery_over_title AS gallery_over_title_4, r0_.gallery_title AS gallery_title_5, r0_.gallery_content AS gallery_content_6, r0_.picture_name AS picture_name_7, r0_.picture_size AS picture_size_8, r0_.picture_updated_at AS picture_updated_at_9, r0_.picture_alt AS picture_alt_10, r0_.published_at AS published_at_11, r0_.created_at AS created_at_12, r0_.meta_title AS meta_title_13, r0_.meta_description AS meta_description_14, r0_.slug AS slug_15, r0_.is_published AS is_published_16 FROM reference r0_ WHERE r0_.is_published = 1 AND r0_.sub_category_id = 1) dctrn_result_inner ORDER BY published_at_11 DESC, created_at_12 DESC) dctrn_result LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 268)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 427)
11	Pagerfanta\Pagerfanta->getIterator (line 55)
12	__TwigTemplate_a62217c405daccd7ee0937c9adef3a49->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 292)
19	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->block_body (line 431)
20	Twig\Template->yieldBlock (line 167)
21	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
22	Twig\Template->yield (line 69)
23	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
24	Twig\Template->yield (line 56)
25	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
26	Twig\Template->yield (line 343)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 35)
29	Twig\TemplateWrapper->render (line 320)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
34	App\Controller\FrontController->listReferencesBySubCat (line 178)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.29 ms
(5.28%)

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, t0.global_activity_description AS global_activity_description_20 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,
  t0.global_activity_description AS global_activity_description_20
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, t0.global_activity_description AS global_activity_description_20 FROM site_settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
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.23 ms
(4.25%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "menuiserie-aluminium-neuf"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6
FROM
  reference_sub_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0 WHERE t0.slug = 'menuiserie-aluminium-neuf' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 206)
4	App\Controller\FrontController->listReferencesBySubCat (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.22 ms
(3.98%)

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

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_reference_list_sub' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
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.19 ms
(3.41%)

SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.position AS position_1,
  t0.id AS id_2,
  t0.over_title AS over_title_3,
  t0.title AS title_4,
  t0.summary AS summary_5,
  t0.picture_name AS picture_name_6,
  t0.picture_size AS picture_size_7,
  t0.picture_updated_at AS picture_updated_at_8,
  t0.picture_alt AS picture_alt_9,
  t0.card_section_title AS card_section_title_10,
  t0.regulations_title AS regulations_title_11,
  t0.refs_title AS refs_title_12,
  t0.last_block_title AS last_block_title_13,
  t0.last_block_summary AS last_block_summary_14,
  t0.last_block_link_title AS last_block_link_title_15,
  t0.last_block_link_target AS last_block_link_target_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.slug AS slug_19,
  t0.category_id AS category_id_20
FROM
  activity t0
ORDER BY
  t0.position ASC

SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 92)
4	App\Twig\AppExtension->getHeaderNavLinks (line 52)
5	__TwigTemplate_2f689a78c36628fefaa4957d8817b6d3->doDisplay (line 387)
6	Twig\Template->yield (line 162)
7	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
8	Twig\Template->yield (line 69)
9	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
10	Twig\Template->yield (line 56)
11	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 320)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 215)
20	App\Controller\FrontController->listReferencesBySubCat (line 178)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.19 ms
(3.40%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.icon_name AS icon_name_10, t0.icon_size AS icon_size_11, t0.icon_updated_at AS icon_updated_at_12, t0.icon_alt AS icon_alt_13, t0.card_section_title AS card_section_title_14, t0.last_block_title AS last_block_title_15, t0.last_block_summary AS last_block_summary_16, t0.last_block_picture_name AS last_block_picture_name_17, t0.last_block_picture_size AS last_block_picture_size_18, t0.last_block_picture_updated_at AS last_block_picture_updated_at_19, t0.last_block_picture_alt AS last_block_picture_alt_20, t0.last_block_link_title AS last_block_link_title_21, t0.last_block_link_target AS last_block_link_target_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25 FROM building_type 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.over_title AS over_title_3,
  t0.title AS title_4,
  t0.summary AS summary_5,
  t0.picture_name AS picture_name_6,
  t0.picture_size AS picture_size_7,
  t0.picture_updated_at AS picture_updated_at_8,
  t0.picture_alt AS picture_alt_9,
  t0.icon_name AS icon_name_10,
  t0.icon_size AS icon_size_11,
  t0.icon_updated_at AS icon_updated_at_12,
  t0.icon_alt AS icon_alt_13,
  t0.card_section_title AS card_section_title_14,
  t0.last_block_title AS last_block_title_15,
  t0.last_block_summary AS last_block_summary_16,
  t0.last_block_picture_name AS last_block_picture_name_17,
  t0.last_block_picture_size AS last_block_picture_size_18,
  t0.last_block_picture_updated_at AS last_block_picture_updated_at_19,
  t0.last_block_picture_alt AS last_block_picture_alt_20,
  t0.last_block_link_title AS last_block_link_title_21,
  t0.last_block_link_target AS last_block_link_target_22,
  t0.meta_title AS meta_title_23,
  t0.meta_description AS meta_description_24,
  t0.slug AS slug_25
FROM
  building_type t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.icon_name AS icon_name_10, t0.icon_size AS icon_size_11, t0.icon_updated_at AS icon_updated_at_12, t0.icon_alt AS icon_alt_13, t0.card_section_title AS card_section_title_14, t0.last_block_title AS last_block_title_15, t0.last_block_summary AS last_block_summary_16, t0.last_block_picture_name AS last_block_picture_name_17, t0.last_block_picture_size AS last_block_picture_size_18, t0.last_block_picture_updated_at AS last_block_picture_updated_at_19, t0.last_block_picture_alt AS last_block_picture_alt_20, t0.last_block_link_title AS last_block_link_title_21, t0.last_block_link_target AS last_block_link_target_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25 FROM building_type t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 138)
5	App\Twig\AppExtension->getBuildings (line 54)
6	__TwigTemplate_3ebe045862f57870e150928b98db9d33->doDisplay (line 387)
7	Twig\Template->yield (line 172)
8	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
9	Twig\Template->yield (line 69)
10	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
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 215)
21	App\Controller\FrontController->listReferencesBySubCat (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)

0.16 ms
(2.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.position AS position_5,
  t0.slug AS slug_6
FROM
  reference_category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 212)
5	App\Controller\FrontController->listReferencesBySubCat (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.16 ms
(2.85%)

SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.position AS position_1,
  t0.id AS id_2,
  t0.over_title AS over_title_3,
  t0.title AS title_4,
  t0.summary AS summary_5,
  t0.picture_name AS picture_name_6,
  t0.picture_size AS picture_size_7,
  t0.picture_updated_at AS picture_updated_at_8,
  t0.picture_alt AS picture_alt_9,
  t0.card_section_title AS card_section_title_10,
  t0.regulations_title AS regulations_title_11,
  t0.refs_title AS refs_title_12,
  t0.last_block_title AS last_block_title_13,
  t0.last_block_summary AS last_block_summary_14,
  t0.last_block_link_title AS last_block_link_title_15,
  t0.last_block_link_target AS last_block_link_target_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.slug AS slug_19,
  t0.category_id AS category_id_20
FROM
  activity t0

SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 132)
5	App\Twig\AppExtension->getActivities (line 52)
6	__TwigTemplate_3ebe045862f57870e150928b98db9d33->doDisplay (line 387)
7	Twig\Template->yield (line 172)
8	__TwigTemplate_20fc2012e2a339235f6d5b9047017724->doDisplay (line 387)
9	Twig\Template->yield (line 69)
10	__TwigTemplate_1a135f624b5a55c28103cb5bb2120d70->doDisplay (line 387)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_e12cfead6d7f1b081faec7f14ab57da6->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
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 215)
21	App\Controller\FrontController->listReferencesBySubCat (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)

0.14 ms
(2.48%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6
FROM
  reference_sub_category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 213)
5	App\Controller\FrontController->listReferencesBySubCat (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Reference	12
App\Entity\Activity	8
App\Entity\ReferenceCategory	7
App\Entity\ActivityCategory	7
App\Entity\ReferenceSubCategory	2
App\Entity\SiteSettings	1
App\Entity\Homepage	1

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\ReferenceSubCategory	No errors.
App\Entity\Reference	No errors.
App\Entity\ReferenceCategory	No errors.
App\Entity\Activity	No errors.
App\Entity\ActivityCategory	No errors.
App\Entity\ActivityParagraph	No errors.
App\Entity\ActivityCard	No errors.
App\Entity\ActivityBlock	No errors.
App\Entity\Regulation	No errors.
App\Entity\Homepage	No errors.
App\Entity\ReferenceMedia	No errors.
App\Entity\ReferenceParagraph	No errors.
App\Entity\BuildingType	No errors.

Symfony Profiler

GET https://kapeci-alu.asb-digital.fr/references/sub/menuiserie-aluminium-neuf

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping