Symfony Profiler

Query Metrics

13 Database Queries

9 Different statements

3.22 ms Query time

5 Invalid entities

92 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.80 ms
(24.83%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.sub_title AS sub_title_17, t0_.show_on_home_page AS show_on_home_page_18, t0_.format AS format_19, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21, t0_.individual_videoconference_hours AS individual_videoconference_hours_22, t0_.collective_videoconference_hours AS collective_videoconference_hours_23, t0_.elearning_hours AS elearning_hours_24, t0_.face_to_face_hours_text AS face_to_face_hours_text_25, t0_.min_period AS min_period_26, t0_.max_period AS max_period_27, t0_.public AS public_28, t0_.prerequisites AS prerequisites_29, t0_.cpf AS cpf_30, t0_.cpf_link AS cpf_link_31, t0_.pdf_name AS pdf_name_32, t0_.pdf_mime_type AS pdf_mime_type_33, t0_.type AS type_34 FROM training t0_ INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (?)) WHERE t0_.type IN ('professional') ORDER BY t0_.updated_at DESC) dctrn_result) dctrn_table

Parameters:

[
  33
]

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_.code AS code_2,
          t0_.slug_history AS slug_history_3,
          t0_.description AS description_4,
          t0_.price AS price_5,
          t0_.status AS status_6,
          t0_.satisfaction_rate AS satisfaction_rate_7,
          t0_.completion_rate AS completion_rate_8,
          t0_.featured_on_search AS featured_on_search_9,
          t0_.pixels AS pixels_10,
          t0_.updated_at AS updated_at_11,
          t0_.seo_title AS seo_title_12,
          t0_.seo_description AS seo_description_13,
          t0_.seo_canonical AS seo_canonical_14,
          t0_.seo_indexed AS seo_indexed_15,
          t0_.slug AS slug_16,
          t0_.sub_title AS sub_title_17,
          t0_.show_on_home_page AS show_on_home_page_18,
          t0_.format AS format_19,
          t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20,
          t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21,
          t0_.individual_videoconference_hours AS individual_videoconference_hours_22,
          t0_.collective_videoconference_hours AS collective_videoconference_hours_23,
          t0_.elearning_hours AS elearning_hours_24,
          t0_.face_to_face_hours_text AS face_to_face_hours_text_25,
          t0_.min_period AS min_period_26,
          t0_.max_period AS max_period_27,
          t0_.public AS public_28,
          t0_.prerequisites AS prerequisites_29,
          t0_.cpf AS cpf_30,
          t0_.cpf_link AS cpf_link_31,
          t0_.pdf_name AS pdf_name_32,
          t0_.pdf_mime_type AS pdf_mime_type_33,
          t0_.type AS type_34
        FROM
          training t0_
          INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id
          INNER JOIN place p1_ ON p1_.id = t2_.place_id
          AND (
            p1_.id IN (?)
          )
        WHERE
          t0_.type IN ('professional')
        ORDER BY
          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_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.sub_title AS sub_title_17, t0_.show_on_home_page AS show_on_home_page_18, t0_.format AS format_19, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21, t0_.individual_videoconference_hours AS individual_videoconference_hours_22, t0_.collective_videoconference_hours AS collective_videoconference_hours_23, t0_.elearning_hours AS elearning_hours_24, t0_.face_to_face_hours_text AS face_to_face_hours_text_25, t0_.min_period AS min_period_26, t0_.max_period AS max_period_27, t0_.public AS public_28, t0_.prerequisites AS prerequisites_29, t0_.cpf AS cpf_30, t0_.cpf_link AS cpf_link_31, t0_.pdf_name AS pdf_name_32, t0_.pdf_mime_type AS pdf_mime_type_33, t0_.type AS type_34 FROM training t0_ INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (33)) WHERE t0_.type IN ('professional') ORDER BY 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 42)
12	App\Repository\TrainingProfessionalRepository->getPager (line 72)
13	App\Repository\TrainingProfessionalRepository->search (line 143)
14	App\Twig\Components\SearchTraining->loadTrainings (line 138)
15	App\Twig\Components\SearchTraining->preMount (line 184)
16	Symfony\UX\TwigComponent\ComponentFactory->preMount (line 93)
17	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 84)
18	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
19	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
20	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 171)
21	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->block_body (line 437)
22	Twig\Template->yieldBlock (line 151)
23	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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.67 ms
(20.98%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_11 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.sub_title AS sub_title_17, t0_.show_on_home_page AS show_on_home_page_18, t0_.format AS format_19, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21, t0_.individual_videoconference_hours AS individual_videoconference_hours_22, t0_.collective_videoconference_hours AS collective_videoconference_hours_23, t0_.elearning_hours AS elearning_hours_24, t0_.face_to_face_hours_text AS face_to_face_hours_text_25, t0_.min_period AS min_period_26, t0_.max_period AS max_period_27, t0_.public AS public_28, t0_.prerequisites AS prerequisites_29, t0_.cpf AS cpf_30, t0_.cpf_link AS cpf_link_31, t0_.pdf_name AS pdf_name_32, t0_.pdf_mime_type AS pdf_mime_type_33, p1_.id AS id_34, p1_.slug AS slug_35, p1_.address AS address_36, p1_.zip_code AS zip_code_37, p1_.city AS city_38, p1_.image_name AS image_name_39, p1_.updated_at AS updated_at_40, p1_.phone_number AS phone_number_41, p1_.information AS information_42, p1_.amenities AS amenities_43, p1_.google_map_link AS google_map_link_44, t0_.type AS type_45 FROM training t0_ INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (?)) WHERE t0_.type IN ('professional')) dctrn_result_inner ORDER BY updated_at_11 DESC) dctrn_result LIMIT 7

Parameters:

[
  33
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      updated_at_11
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.label AS label_1,
          t0_.code AS code_2,
          t0_.slug_history AS slug_history_3,
          t0_.description AS description_4,
          t0_.price AS price_5,
          t0_.status AS status_6,
          t0_.satisfaction_rate AS satisfaction_rate_7,
          t0_.completion_rate AS completion_rate_8,
          t0_.featured_on_search AS featured_on_search_9,
          t0_.pixels AS pixels_10,
          t0_.updated_at AS updated_at_11,
          t0_.seo_title AS seo_title_12,
          t0_.seo_description AS seo_description_13,
          t0_.seo_canonical AS seo_canonical_14,
          t0_.seo_indexed AS seo_indexed_15,
          t0_.slug AS slug_16,
          t0_.sub_title AS sub_title_17,
          t0_.show_on_home_page AS show_on_home_page_18,
          t0_.format AS format_19,
          t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20,
          t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21,
          t0_.individual_videoconference_hours AS individual_videoconference_hours_22,
          t0_.collective_videoconference_hours AS collective_videoconference_hours_23,
          t0_.elearning_hours AS elearning_hours_24,
          t0_.face_to_face_hours_text AS face_to_face_hours_text_25,
          t0_.min_period AS min_period_26,
          t0_.max_period AS max_period_27,
          t0_.public AS public_28,
          t0_.prerequisites AS prerequisites_29,
          t0_.cpf AS cpf_30,
          t0_.cpf_link AS cpf_link_31,
          t0_.pdf_name AS pdf_name_32,
          t0_.pdf_mime_type AS pdf_mime_type_33,
          p1_.id AS id_34,
          p1_.slug AS slug_35,
          p1_.address AS address_36,
          p1_.zip_code AS zip_code_37,
          p1_.city AS city_38,
          p1_.image_name AS image_name_39,
          p1_.updated_at AS updated_at_40,
          p1_.phone_number AS phone_number_41,
          p1_.information AS information_42,
          p1_.amenities AS amenities_43,
          p1_.google_map_link AS google_map_link_44,
          t0_.type AS type_45
        FROM
          training t0_
          INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id
          INNER JOIN place p1_ ON p1_.id = t2_.place_id
          AND (
            p1_.id IN (?)
          )
        WHERE
          t0_.type IN ('professional')
      ) dctrn_result_inner
    ORDER BY
      updated_at_11 DESC
  ) dctrn_result
LIMIT
  7

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_11 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.sub_title AS sub_title_17, t0_.show_on_home_page AS show_on_home_page_18, t0_.format AS format_19, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21, t0_.individual_videoconference_hours AS individual_videoconference_hours_22, t0_.collective_videoconference_hours AS collective_videoconference_hours_23, t0_.elearning_hours AS elearning_hours_24, t0_.face_to_face_hours_text AS face_to_face_hours_text_25, t0_.min_period AS min_period_26, t0_.max_period AS max_period_27, t0_.public AS public_28, t0_.prerequisites AS prerequisites_29, t0_.cpf AS cpf_30, t0_.cpf_link AS cpf_link_31, t0_.pdf_name AS pdf_name_32, t0_.pdf_mime_type AS pdf_mime_type_33, p1_.id AS id_34, p1_.slug AS slug_35, p1_.address AS address_36, p1_.zip_code AS zip_code_37, p1_.city AS city_38, p1_.image_name AS image_name_39, p1_.updated_at AS updated_at_40, p1_.phone_number AS phone_number_41, p1_.information AS information_42, p1_.amenities AS amenities_43, p1_.google_map_link AS google_map_link_44, t0_.type AS type_45 FROM training t0_ INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (33)) WHERE t0_.type IN ('professional')) dctrn_result_inner ORDER BY updated_at_11 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_e9fc9fff5832f193212dad7d1cc8964f->doDisplay (line 393)
13	Twig\Template->yield (line 61)
14	__TwigTemplate_7f89c1be1ab49f208146a7ea8bf1cbde->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_c661f41584b3d6fa582dd0d68416eae5->block_body (line 437)
22	Twig\Template->yieldBlock (line 151)
23	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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.54 ms
(16.90%)

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:

[
  11
]

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 = 11;

#	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_b5595d22ab44336ebc0f52783fbb7d1e->doDisplay (line 393)
12	Twig\Template->yield (line 73)
13	__TwigTemplate_e9fc9fff5832f193212dad7d1cc8964f->doDisplay (line 393)
14	Twig\Template->yield (line 61)
15	__TwigTemplate_7f89c1be1ab49f208146a7ea8bf1cbde->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_c661f41584b3d6fa582dd0d68416eae5->block_body (line 437)
23	Twig\Template->yieldBlock (line 151)
24	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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.28 ms
(8.80%)

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 109)
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_c661f41584b3d6fa582dd0d68416eae5->block_body (line 437)
12	Twig\Template->yieldBlock (line 151)
13	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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.27 ms
(8.27%)

SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.sub_title AS sub_title_17, t0_.show_on_home_page AS show_on_home_page_18, t0_.format AS format_19, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21, t0_.individual_videoconference_hours AS individual_videoconference_hours_22, t0_.collective_videoconference_hours AS collective_videoconference_hours_23, t0_.elearning_hours AS elearning_hours_24, t0_.face_to_face_hours_text AS face_to_face_hours_text_25, t0_.min_period AS min_period_26, t0_.max_period AS max_period_27, t0_.public AS public_28, t0_.prerequisites AS prerequisites_29, t0_.cpf AS cpf_30, t0_.cpf_link AS cpf_link_31, t0_.pdf_name AS pdf_name_32, t0_.pdf_mime_type AS pdf_mime_type_33, t0_.type AS type_34, t0_.created_by_id AS created_by_id_35, t0_.category_id AS category_id_36, t0_.certification_id AS certification_id_37 FROM training t0_ INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (?)) WHERE (t0_.id IN (?, ?, ?, ?, ?, ?, ?)) AND t0_.type IN ('professional') ORDER BY 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_.code AS code_2,
  t0_.slug_history AS slug_history_3,
  t0_.description AS description_4,
  t0_.price AS price_5,
  t0_.status AS status_6,
  t0_.satisfaction_rate AS satisfaction_rate_7,
  t0_.completion_rate AS completion_rate_8,
  t0_.featured_on_search AS featured_on_search_9,
  t0_.pixels AS pixels_10,
  t0_.updated_at AS updated_at_11,
  t0_.seo_title AS seo_title_12,
  t0_.seo_description AS seo_description_13,
  t0_.seo_canonical AS seo_canonical_14,
  t0_.seo_indexed AS seo_indexed_15,
  t0_.slug AS slug_16,
  t0_.sub_title AS sub_title_17,
  t0_.show_on_home_page AS show_on_home_page_18,
  t0_.format AS format_19,
  t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20,
  t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21,
  t0_.individual_videoconference_hours AS individual_videoconference_hours_22,
  t0_.collective_videoconference_hours AS collective_videoconference_hours_23,
  t0_.elearning_hours AS elearning_hours_24,
  t0_.face_to_face_hours_text AS face_to_face_hours_text_25,
  t0_.min_period AS min_period_26,
  t0_.max_period AS max_period_27,
  t0_.public AS public_28,
  t0_.prerequisites AS prerequisites_29,
  t0_.cpf AS cpf_30,
  t0_.cpf_link AS cpf_link_31,
  t0_.pdf_name AS pdf_name_32,
  t0_.pdf_mime_type AS pdf_mime_type_33,
  t0_.type AS type_34,
  t0_.created_by_id AS created_by_id_35,
  t0_.category_id AS category_id_36,
  t0_.certification_id AS certification_id_37
FROM
  training t0_
  INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id
  INNER JOIN place p1_ ON p1_.id = t2_.place_id
  AND (
    p1_.id IN (?)
  )
WHERE
  (
    t0_.id IN (?, ?, ?, ?, ?, ?, ?)
  )
  AND t0_.type IN ('professional')
ORDER BY
  t0_.updated_at DESC

SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.sub_title AS sub_title_17, t0_.show_on_home_page AS show_on_home_page_18, t0_.format AS format_19, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21, t0_.individual_videoconference_hours AS individual_videoconference_hours_22, t0_.collective_videoconference_hours AS collective_videoconference_hours_23, t0_.elearning_hours AS elearning_hours_24, t0_.face_to_face_hours_text AS face_to_face_hours_text_25, t0_.min_period AS min_period_26, t0_.max_period AS max_period_27, t0_.public AS public_28, t0_.prerequisites AS prerequisites_29, t0_.cpf AS cpf_30, t0_.cpf_link AS cpf_link_31, t0_.pdf_name AS pdf_name_32, t0_.pdf_mime_type AS pdf_mime_type_33, t0_.type AS type_34, t0_.created_by_id AS created_by_id_35, t0_.category_id AS category_id_36, t0_.certification_id AS certification_id_37 FROM training t0_ INNER JOIN training_professional_place t2_ ON t0_.id = t2_.training_professional_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (33)) WHERE (t0_.id IN (38, 247, 226, 381, 70, 228, 376)) AND t0_.type IN ('professional') ORDER BY 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_e9fc9fff5832f193212dad7d1cc8964f->doDisplay (line 393)
13	Twig\Template->yield (line 61)
14	__TwigTemplate_7f89c1be1ab49f208146a7ea8bf1cbde->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_c661f41584b3d6fa582dd0d68416eae5->block_body (line 437)
22	Twig\Template->yieldBlock (line 151)
23	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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.21 ms
(6.47%)

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 68)
5	App\Twig\Runtime\MenuExtensionRuntime->getCmsPages (line 271)
6	__TwigTemplate_5028b06c55d52e946822d9d8a6abcbe5->doDisplay (line 393)
7	Twig\Template->yield (line 119)
8	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
9	Twig\Template->yield (line 54)
10	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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)

0.17 ms
(5.34%)

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 124)
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_c661f41584b3d6fa582dd0d68416eae5->block_body (line 437)
12	Twig\Template->yieldBlock (line 151)
13	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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.16 ms
(5.03%)

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 114)
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_c661f41584b3d6fa582dd0d68416eae5->block_body (line 437)
12	Twig\Template->yieldBlock (line 151)
13	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_c661f41584b3d6fa582dd0d68416eae5->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.11 ms
(3.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 WHERE t0.id = ?

Parameters:

[
  "33"
]

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
WHERE
  t0.id = ?

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 WHERE t0.id = '33';

#	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 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 24)
7	App\Controller\Training\SearchTrainingController->__invoke (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Training	7
App\Entity\Financing	5
App\Entity\Certification	5

Entities Mapping

Class	Mapping errors
App\Entity\Place	No errors.
App\Entity\PlacePicture	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\TrainingProfessional	The association App\Entity\TrainingProfessional#createdBy refers to the inverse side field App\Entity\User#trainings which does not exist.
App\Entity\Cms\CmsPage	No errors.
App\Entity\TrainingCategory	No errors.
App\Entity\Financing	No errors.
App\Entity\User	No errors.
App\Entity\Certification	No errors.
App\Entity\TrainingObjective	No errors.
App\Entity\FAQ	No errors.
App\Entity\Trainer\Trainer	No errors.
App\Entity\TrainingProgramPart	The association App\Entity\TrainingProgramPart#training refers to the inverse side field App\Entity\Training#trainingProgramParts which does not exist.
App\Entity\Session	The association App\Entity\Session#training refers to the inverse side field App\Entity\Training#sessions which does not exist.
App\Entity\TrainingCityChild	The association App\Entity\TrainingCityChild#training refers to the inverse side field App\Entity\Training#trainingCityChildren which does not exist.

Symfony Profiler

GET https://preprod-website.kaza-senza.com/nos-formations?selectedPlace=33

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping