Symfony Profiler

Query Metrics

14 Database Queries

8 Different statements

24.17 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.58 ms
(31.38%)

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.id AS id_4 FROM app_question_thema t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.enabled AS enabled_3,
  t0.id AS id_4
FROM
  app_question_thema t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.id AS id_4 FROM app_question_thema t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Question\QuestionThema::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Question\QuestionThema->__get (line 36)
8	App\Entity\Question\QuestionThema->getName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 101)
10	__TwigTemplate_17351341cebbfaef70d20174e2bdba2d->{closure} (line 2079)
11	Twig\Extension\CoreExtension::captureOutput (line 69)
12	__TwigTemplate_17351341cebbfaef70d20174e2bdba2d->macro_question_card (line 122)
13	__TwigTemplate_4c1fc148bb3d88f8ea628821e3e53071->doDisplay (line 388)
14	Twig\Template->yield (line 72)
15	__TwigTemplate_61a3118be0365a2e7db5bbee3fc31123->doDisplay (line 388)
16	Twig\Template->yield (line 142)
17	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->block_content (line 432)
18	Twig\Template->yieldBlock (line 85)
19	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->block_global_content (line 432)
20	Twig\Template->yieldBlock (line 690)
21	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->block_body (line 432)
22	Twig\Template->yieldBlock (line 252)
23	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->doDisplay (line 388)
24	Twig\Template->yield (line 56)
25	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->doDisplay (line 388)
26	Twig\Template->yield (line 60)
27	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->doDisplay (line 388)
28	Twig\Template->yield (line 344)
29	Twig\Template->display (line 359)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 334)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
35	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 21)
36	App\Controller\Website\DefaultController->index (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 69)

4.86 ms
(20.13%)

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.id AS id_4 FROM app_question_organ t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.enabled AS enabled_3,
  t0.id AS id_4
FROM
  app_question_organ t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.id AS id_4 FROM app_question_organ t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Question\QuestionOrgan::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Question\QuestionOrgan->__get (line 36)
8	App\Entity\Question\QuestionOrgan->getName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 110)
10	__TwigTemplate_17351341cebbfaef70d20174e2bdba2d->{closure} (line 2079)
11	Twig\Extension\CoreExtension::captureOutput (line 69)
12	__TwigTemplate_17351341cebbfaef70d20174e2bdba2d->macro_question_card (line 122)
13	__TwigTemplate_4c1fc148bb3d88f8ea628821e3e53071->doDisplay (line 388)
14	Twig\Template->yield (line 72)
15	__TwigTemplate_61a3118be0365a2e7db5bbee3fc31123->doDisplay (line 388)
16	Twig\Template->yield (line 142)
17	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->block_content (line 432)
18	Twig\Template->yieldBlock (line 85)
19	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->block_global_content (line 432)
20	Twig\Template->yieldBlock (line 690)
21	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->block_body (line 432)
22	Twig\Template->yieldBlock (line 252)
23	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->doDisplay (line 388)
24	Twig\Template->yield (line 56)
25	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->doDisplay (line 388)
26	Twig\Template->yield (line 60)
27	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->doDisplay (line 388)
28	Twig\Template->yield (line 344)
29	Twig\Template->display (line 359)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 334)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
35	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 21)
36	App\Controller\Website\DefaultController->index (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 69)

2.39 ms
(9.88%)

SELECT DISTINCT id_4 FROM (SELECT DISTINCT id_4, CASE WHEN list_position_5 IS NULL THEN 1 ELSE 0 END, list_position_5, updated_at_7 FROM (SELECT a0_.answer AS answer_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.enabled AS enabled_3, a0_.id AS id_4, a0_.list_position AS list_position_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7 FROM app_question a0_ LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id) dctrn_result_inner ORDER BY CASE WHEN list_position_5 IS NULL THEN 1 ELSE 0 END ASC, list_position_5 ASC, updated_at_7 DESC) dctrn_result LIMIT 12

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_4
FROM
  (
    SELECT
      DISTINCT id_4,
      CASE WHEN list_position_5 IS NULL THEN
        1
      ELSE
        0
      END,
      list_position_5,
      updated_at_7
    FROM
      (
        SELECT
          a0_.answer AS answer_0,
          a0_.slug AS slug_1,
          a0_.title AS title_2,
          a0_.enabled AS enabled_3,
          a0_.id AS id_4,
          a0_.list_position AS list_position_5,
          a0_.created_at AS created_at_6,
          a0_.updated_at AS updated_at_7
        FROM
          app_question a0_
          LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id
          LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id
      ) dctrn_result_inner
    ORDER BY
      CASE WHEN list_position_5 IS NULL THEN
        1
      ELSE
        0
      END ASC,
      list_position_5 ASC,
      updated_at_7 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_4 FROM (SELECT DISTINCT id_4, CASE WHEN list_position_5 IS NULL THEN 1 ELSE 0 END, list_position_5, updated_at_7 FROM (SELECT a0_.answer AS answer_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.enabled AS enabled_3, a0_.id AS id_4, a0_.list_position AS list_position_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7 FROM app_question a0_ LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id) dctrn_result_inner ORDER BY CASE WHEN list_position_5 IS NULL THEN 1 ELSE 0 END ASC, list_position_5 ASC, updated_at_7 DESC) dctrn_result LIMIT 12;

#	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 117)
8	__TwigTemplate_4c1fc148bb3d88f8ea628821e3e53071->doDisplay (line 388)
9	Twig\Template->yield (line 72)
10	__TwigTemplate_61a3118be0365a2e7db5bbee3fc31123->doDisplay (line 388)
11	Twig\Template->yield (line 142)
12	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->block_content (line 432)
13	Twig\Template->yieldBlock (line 85)
14	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->block_global_content (line 432)
15	Twig\Template->yieldBlock (line 690)
16	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->block_body (line 432)
17	Twig\Template->yieldBlock (line 252)
18	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->doDisplay (line 388)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->doDisplay (line 388)
21	Twig\Template->yield (line 60)
22	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
30	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 21)
31	App\Controller\Website\DefaultController->index (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 69)

2.14 ms
(8.84%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT a0_.answer AS answer_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.enabled AS enabled_3, a0_.id AS id_4, a0_.list_position AS list_position_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7 FROM app_question a0_ LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id ORDER BY CASE WHEN a0_.list_position IS NULL THEN 1 ELSE 0 END ASC, a0_.list_position ASC, a0_.updated_at 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_4
    FROM
      (
        SELECT
          a0_.answer AS answer_0,
          a0_.slug AS slug_1,
          a0_.title AS title_2,
          a0_.enabled AS enabled_3,
          a0_.id AS id_4,
          a0_.list_position AS list_position_5,
          a0_.created_at AS created_at_6,
          a0_.updated_at AS updated_at_7
        FROM
          app_question a0_
          LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id
          LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id
        ORDER BY
          CASE WHEN a0_.list_position IS NULL THEN
            1
          ELSE
            0
          END ASC,
          a0_.list_position ASC,
          a0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT a0_.answer AS answer_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.enabled AS enabled_3, a0_.id AS id_4, a0_.list_position AS list_position_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7 FROM app_question a0_ LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id ORDER BY CASE WHEN a0_.list_position IS NULL THEN 1 ELSE 0 END ASC, a0_.list_position ASC, a0_.updated_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 1)
8	count (line 101)
9	App\Repository\Question\QuestionRepository->search (line 55)
10	App\Service\Search\Type\Question\SearchQuestions->search (line 25)
11	App\Service\Block\DataLoader\Type\BlockQuestionsDataLoader->load (line 30)
12	App\Service\Block\DataBlock->load (line 23)
13	App\Controller\Website\DefaultController->index (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.90 ms
(7.85%)

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC

Parameters:

[
  "dod.oj-consulting.fr"
  "dev"
  "don-d-organes"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'dod.oj-consulting.fr' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'don-d-organes' ORDER BY w0_.id ASC;

#	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 66)
7	Sulu\Bundle\WebsiteBundle\Entity\AnalyticsRepository->findByUrl (line 109)
8	Sulu\Bundle\WebsiteBundle\EventListener\AppendAnalyticsListener->onResponse (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 216)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.83 ms
(7.56%)

SELECT a0_.answer AS answer_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.enabled AS enabled_3, a0_.id AS id_4, a0_.list_position AS list_position_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.organ_id AS organ_id_8, a0_.thema_id AS thema_id_9 FROM app_question a0_ LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY CASE WHEN a0_.list_position IS NULL THEN 1 ELSE 0 END ASC, a0_.list_position ASC, a0_.updated_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.answer AS answer_0,
  a0_.slug AS slug_1,
  a0_.title AS title_2,
  a0_.enabled AS enabled_3,
  a0_.id AS id_4,
  a0_.list_position AS list_position_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.organ_id AS organ_id_8,
  a0_.thema_id AS thema_id_9
FROM
  app_question a0_
  LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id
  LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  CASE WHEN a0_.list_position IS NULL THEN
    1
  ELSE
    0
  END ASC,
  a0_.list_position ASC,
  a0_.updated_at DESC

SELECT a0_.answer AS answer_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.enabled AS enabled_3, a0_.id AS id_4, a0_.list_position AS list_position_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.organ_id AS organ_id_8, a0_.thema_id AS thema_id_9 FROM app_question a0_ LEFT JOIN app_question_organ a1_ ON a0_.organ_id = a1_.id LEFT JOIN app_question_thema a2_ ON a0_.thema_id = a2_.id WHERE a0_.id IN (87, 1, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127) ORDER BY CASE WHEN a0_.list_position IS NULL THEN 1 ELSE 0 END ASC, a0_.list_position ASC, a0_.updated_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 117)
8	__TwigTemplate_4c1fc148bb3d88f8ea628821e3e53071->doDisplay (line 388)
9	Twig\Template->yield (line 72)
10	__TwigTemplate_61a3118be0365a2e7db5bbee3fc31123->doDisplay (line 388)
11	Twig\Template->yield (line 142)
12	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->block_content (line 432)
13	Twig\Template->yieldBlock (line 85)
14	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->block_global_content (line 432)
15	Twig\Template->yieldBlock (line 690)
16	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->block_body (line 432)
17	Twig\Template->yieldBlock (line 252)
18	__TwigTemplate_ad0730ca817e970418f53f880225d9cc->doDisplay (line 388)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_005957a4918cabf2f41bade471c3e66c->doDisplay (line 388)
21	Twig\Template->yield (line 60)
22	__TwigTemplate_5ed4214caf4f605f6e3e563cd43e4dfa->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
30	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 21)
31	App\Controller\Website\DefaultController->index (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.79 ms
(7.40%)

SELECT a0_.name AS name_0, a0_.slug AS slug_1 FROM app_question_organ a0_ WHERE a0_.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.name AS name_0,
  a0_.slug AS slug_1
FROM
  app_question_organ a0_
WHERE
  a0_.enabled = ?

SELECT a0_.name AS name_0, a0_.slug AS slug_1 FROM app_question_organ a0_ WHERE a0_.enabled = 1;

#	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 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 50)
7	App\Repository\Question\QuestionOrganRepository->getLabelsAndValues (line 39)
8	App\Service\Search\Type\Question\SearchQuestions->getFilters (line 28)
9	App\Service\Block\DataLoader\Type\BlockQuestionsDataLoader->load (line 30)
10	App\Service\Block\DataBlock->load (line 23)
11	App\Controller\Website\DefaultController->index (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.68 ms
(6.96%)

SELECT a0_.name AS name_0, a0_.slug AS slug_1 FROM app_question_thema a0_ WHERE a0_.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.name AS name_0,
  a0_.slug AS slug_1
FROM
  app_question_thema a0_
WHERE
  a0_.enabled = ?

SELECT a0_.name AS name_0, a0_.slug AS slug_1 FROM app_question_thema a0_ WHERE a0_.enabled = 1;

#	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 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 50)
7	App\Repository\Question\QuestionThemaRepository->getLabelsAndValues (line 44)
8	App\Service\Search\Type\Question\SearchQuestions->getFilters (line 28)
9	App\Service\Block\DataLoader\Type\BlockQuestionsDataLoader->load (line 30)
10	App\Service\Block\DataBlock->load (line 23)
11	App\Controller\Website\DefaultController->index (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 69)

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
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
Sulu\Bundle\FormBundle\Entity\Form	No errors.
App\Entity\Question\Question	No errors.
App\Entity\Question\QuestionOrgan	No errors.
App\Entity\Question\QuestionThema	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.

Symfony Profiler

GET https://dod.oj-consulting.fr/comprendre-le-don-et-la-greffe/des-reponses-a-mes-questions

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping