Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

1.65 ms Query time

1 Invalid entities

83 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.29 ms
(17.35%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, featured_on_search_7, updated_at_5 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33 FROM training t0_ WHERE t0_.category_id IN (?)) dctrn_result_inner ORDER BY featured_on_search_7 DESC, updated_at_5 DESC) dctrn_result LIMIT 7

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      featured_on_search_7,
      updated_at_5
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.label AS label_1,
          t0_.slug AS slug_2,
          t0_.pdf_name AS pdf_name_3,
          t0_.pdf_mime_type AS pdf_mime_type_4,
          t0_.updated_at AS updated_at_5,
          t0_.show_on_home_page AS show_on_home_page_6,
          t0_.featured_on_search AS featured_on_search_7,
          t0_.price AS price_8,
          t0_.cpf AS cpf_9,
          t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10,
          t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11,
          t0_.individual_videoconference_hours AS individual_videoconference_hours_12,
          t0_.collective_videoconference_hours AS collective_videoconference_hours_13,
          t0_.elearning_hours AS elearning_hours_14,
          t0_.format AS format_15,
          t0_.description AS description_16,
          t0_.min_period AS min_period_17,
          t0_.max_period AS max_period_18,
          t0_.public AS public_19,
          t0_.prerequisites AS prerequisites_20,
          t0_.code AS code_21,
          t0_.face_to_face_hours_text AS face_to_face_hours_text_22,
          t0_.satisfaction_rate AS satisfaction_rate_23,
          t0_.cpf_link AS cpf_link_24,
          t0_.completion_rate AS completion_rate_25,
          t0_.slug_history AS slug_history_26,
          t0_.sub_title AS sub_title_27,
          t0_.pixels AS pixels_28,
          t0_.status AS status_29,
          t0_.seo_title AS seo_title_30,
          t0_.seo_description AS seo_description_31,
          t0_.seo_canonical AS seo_canonical_32,
          t0_.seo_indexed AS seo_indexed_33
        FROM
          training t0_
        WHERE
          t0_.category_id IN (?)
      ) dctrn_result_inner
    ORDER BY
      featured_on_search_7 DESC,
      updated_at_5 DESC
  ) dctrn_result
LIMIT
  7

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, featured_on_search_7, updated_at_5 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33 FROM training t0_ WHERE t0_.category_id IN ('6')) dctrn_result_inner ORDER BY featured_on_search_7 DESC, updated_at_5 DESC) dctrn_result LIMIT 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
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 68)
12	__TwigTemplate_e48b6641d514dd6e21a6e60367222cc0->doDisplay (line 393)
13	Twig\Template->yield (line 61)
14	__TwigTemplate_22af2f531727f3401696f12b4a983be1->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
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 171)
21	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->block_body (line 437)
22	Twig\Template->yieldBlock (line 138)
23	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
26	Twig\Template->yield (line 349)
27	Twig\Template->display (line 364)
28	Twig\Template->render (line 35)
29	Twig\TemplateWrapper->render (line 306)
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 23)
34	App\Controller\Training\SearchTrainingController->__invoke (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require (line 7)

0.27 ms
(16.39%)

SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33, t0_.certification_id AS certification_id_34, t0_.category_id AS category_id_35, t0_.created_by_id AS created_by_id_36 FROM training t0_ WHERE t0_.category_id IN (?) AND t0_.id IN (?, ?) ORDER BY t0_.featured_on_search DESC, t0_.updated_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.label AS label_1,
  t0_.slug AS slug_2,
  t0_.pdf_name AS pdf_name_3,
  t0_.pdf_mime_type AS pdf_mime_type_4,
  t0_.updated_at AS updated_at_5,
  t0_.show_on_home_page AS show_on_home_page_6,
  t0_.featured_on_search AS featured_on_search_7,
  t0_.price AS price_8,
  t0_.cpf AS cpf_9,
  t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10,
  t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11,
  t0_.individual_videoconference_hours AS individual_videoconference_hours_12,
  t0_.collective_videoconference_hours AS collective_videoconference_hours_13,
  t0_.elearning_hours AS elearning_hours_14,
  t0_.format AS format_15,
  t0_.description AS description_16,
  t0_.min_period AS min_period_17,
  t0_.max_period AS max_period_18,
  t0_.public AS public_19,
  t0_.prerequisites AS prerequisites_20,
  t0_.code AS code_21,
  t0_.face_to_face_hours_text AS face_to_face_hours_text_22,
  t0_.satisfaction_rate AS satisfaction_rate_23,
  t0_.cpf_link AS cpf_link_24,
  t0_.completion_rate AS completion_rate_25,
  t0_.slug_history AS slug_history_26,
  t0_.sub_title AS sub_title_27,
  t0_.pixels AS pixels_28,
  t0_.status AS status_29,
  t0_.seo_title AS seo_title_30,
  t0_.seo_description AS seo_description_31,
  t0_.seo_canonical AS seo_canonical_32,
  t0_.seo_indexed AS seo_indexed_33,
  t0_.certification_id AS certification_id_34,
  t0_.category_id AS category_id_35,
  t0_.created_by_id AS created_by_id_36
FROM
  training t0_
WHERE
  t0_.category_id IN (?)
  AND t0_.id IN (?, ?)
ORDER BY
  t0_.featured_on_search DESC,
  t0_.updated_at DESC

SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33, t0_.certification_id AS certification_id_34, t0_.category_id AS category_id_35, t0_.created_by_id AS created_by_id_36 FROM training t0_ WHERE t0_.category_id IN ('6') AND t0_.id IN (123, 122) ORDER BY t0_.featured_on_search DESC, t0_.updated_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
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 68)
12	__TwigTemplate_e48b6641d514dd6e21a6e60367222cc0->doDisplay (line 393)
13	Twig\Template->yield (line 61)
14	__TwigTemplate_22af2f531727f3401696f12b4a983be1->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
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 171)
21	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->block_body (line 437)
22	Twig\Template->yieldBlock (line 138)
23	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
26	Twig\Template->yield (line 349)
27	Twig\Template->display (line 364)
28	Twig\Template->render (line 35)
29	Twig\TemplateWrapper->render (line 306)
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 23)
34	App\Controller\Training\SearchTrainingController->__invoke (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require (line 7)

0.26 ms
(15.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 118)
5	App\Twig\Components\SearchTraining->preMount (line 184)
6	Symfony\UX\TwigComponent\ComponentFactory->preMount (line 93)
7	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 84)
8	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
9	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
10	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 171)
11	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->block_body (line 437)
12	Twig\Template->yieldBlock (line 138)
13	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
24	App\Controller\Training\SearchTrainingController->__invoke (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require (line 7)

0.23 ms
(13.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6 FROM financing t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.description AS description_4,
  t0.image_name AS image_name_5,
  t0.updated_at AS updated_at_6
FROM
  financing t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6 FROM financing t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 123)
5	App\Twig\Components\SearchTraining->preMount (line 184)
6	Symfony\UX\TwigComponent\ComponentFactory->preMount (line 93)
7	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 84)
8	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
9	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
10	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 171)
11	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->block_body (line 437)
12	Twig\Template->yieldBlock (line 138)
13	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
24	App\Controller\Training\SearchTrainingController->__invoke (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require (line 7)

0.17 ms
(10.52%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33 FROM training t0_ WHERE t0_.category_id IN (?) ORDER BY t0_.featured_on_search DESC, t0_.updated_at DESC) dctrn_result) dctrn_table

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.label AS label_1,
          t0_.slug AS slug_2,
          t0_.pdf_name AS pdf_name_3,
          t0_.pdf_mime_type AS pdf_mime_type_4,
          t0_.updated_at AS updated_at_5,
          t0_.show_on_home_page AS show_on_home_page_6,
          t0_.featured_on_search AS featured_on_search_7,
          t0_.price AS price_8,
          t0_.cpf AS cpf_9,
          t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10,
          t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11,
          t0_.individual_videoconference_hours AS individual_videoconference_hours_12,
          t0_.collective_videoconference_hours AS collective_videoconference_hours_13,
          t0_.elearning_hours AS elearning_hours_14,
          t0_.format AS format_15,
          t0_.description AS description_16,
          t0_.min_period AS min_period_17,
          t0_.max_period AS max_period_18,
          t0_.public AS public_19,
          t0_.prerequisites AS prerequisites_20,
          t0_.code AS code_21,
          t0_.face_to_face_hours_text AS face_to_face_hours_text_22,
          t0_.satisfaction_rate AS satisfaction_rate_23,
          t0_.cpf_link AS cpf_link_24,
          t0_.completion_rate AS completion_rate_25,
          t0_.slug_history AS slug_history_26,
          t0_.sub_title AS sub_title_27,
          t0_.pixels AS pixels_28,
          t0_.status AS status_29,
          t0_.seo_title AS seo_title_30,
          t0_.seo_description AS seo_description_31,
          t0_.seo_canonical AS seo_canonical_32,
          t0_.seo_indexed AS seo_indexed_33
        FROM
          training t0_
        WHERE
          t0_.category_id IN (?)
        ORDER BY
          t0_.featured_on_search DESC,
          t0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33 FROM training t0_ WHERE t0_.category_id IN ('6') ORDER BY t0_.featured_on_search DESC, t0_.updated_at DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
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 91)
12	App\Repository\TrainingRepository->search (line 152)
13	App\Twig\Components\SearchTraining->loadTrainings (line 147)
14	App\Twig\Components\SearchTraining->preMount (line 184)
15	Symfony\UX\TwigComponent\ComponentFactory->preMount (line 93)
16	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 84)
17	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 171)
20	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->block_body (line 437)
21	Twig\Template->yieldBlock (line 138)
22	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
25	Twig\Template->yield (line 349)
26	Twig\Template->display (line 364)
27	Twig\Template->render (line 35)
28	Twig\TemplateWrapper->render (line 306)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
33	App\Controller\Training\SearchTrainingController->__invoke (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require (line 7)

0.17 ms
(10.39%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 ORDER BY t0.city ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.address AS address_3,
  t0.zip_code AS zip_code_4,
  t0.city AS city_5,
  t0.image_name AS image_name_6,
  t0.updated_at AS updated_at_7,
  t0.phone_number AS phone_number_8,
  t0.information AS information_9,
  t0.amenities AS amenities_10,
  t0.google_map_link AS google_map_link_11
FROM
  place t0
ORDER BY
  t0.city ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 ORDER BY t0.city ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 133)
5	App\Twig\Components\SearchTraining->preMount (line 184)
6	Symfony\UX\TwigComponent\ComponentFactory->preMount (line 93)
7	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 84)
8	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
9	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
10	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 171)
11	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->block_body (line 437)
12	Twig\Template->yieldBlock (line 138)
13	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
24	App\Controller\Training\SearchTrainingController->__invoke (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require (line 7)

0.15 ms
(9.31%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = ?

Parameters:

[
  34
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 34;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 367)
5	Proxies\__CG__\App\Entity\Certification::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Certification->__get (line 78)
8	App\Entity\Certification->getName (line 63)
9	App\Entity\Certification->__toString (line 113)
10	Twig\Runtime\EscaperRuntime->escape (line 259)
11	__TwigTemplate_08e8f7c5fd9dc971d5aa9d4f5901df9c->doDisplay (line 393)
12	Twig\Template->yield (line 73)
13	__TwigTemplate_e48b6641d514dd6e21a6e60367222cc0->doDisplay (line 393)
14	Twig\Template->yield (line 61)
15	__TwigTemplate_22af2f531727f3401696f12b4a983be1->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
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 171)
22	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->block_body (line 437)
23	Twig\Template->yieldBlock (line 138)
24	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
27	Twig\Template->yield (line 349)
28	Twig\Template->display (line 364)
29	Twig\Template->render (line 35)
30	Twig\TemplateWrapper->render (line 306)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
35	App\Controller\Training\SearchTrainingController->__invoke (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require (line 7)

0.11 ms
(6.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 49)
5	App\Twig\Runtime\MenuExtensionRuntime->getCmsPages (line 179)
6	__TwigTemplate_c075e72bad17f8ebc2a69dec01d7de26->doDisplay (line 393)
7	Twig\Template->yield (line 106)
8	__TwigTemplate_3cba56ab96708df288b27a0850d4527d->doDisplay (line 393)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_f8a8d5566f46da74bfb70c1a2d4a736e->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
19	App\Controller\Training\SearchTrainingController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require (line 7)

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\Place	51
App\Entity\TrainingCategory	24
App\Entity\Financing	5
App\Entity\Training	2
App\Entity\Certification	1

Entities Mapping

Class	Mapping errors
App\Entity\Cms\CmsPage	No errors.
App\Entity\TrainingCategory	No errors.
App\Entity\Training	The association App\Entity\Training#createdBy refers to the inverse side field App\Entity\User#trainings which does not exist.
App\Entity\Financing	No errors.
App\Entity\Place	No errors.
App\Entity\PlacePicture	No errors.
App\Entity\Certification	No errors.
App\Entity\User	No errors.
App\Entity\TrainingObjective	No errors.
App\Entity\TrainingProgramPart	No errors.
App\Entity\Session	No errors.
App\Entity\TrainingCityChild	No errors.
App\Entity\FAQ	No errors.
App\Entity\Trainer\Trainer	No errors.

Symfony Profiler

GET https://preprod-website.kaza-senza.com/nos-formations?selectedCategories%5B0%5D=6

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping