Symfony Profiler

Query Metrics

12 Database Queries

12 Different statements

3.16 ms Query time

6 Invalid entities

72 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.26 ms
(39.94%)

SELECT * FROM training WHERE type = 'professional' AND (slug = :slug OR EXISTS (
                SELECT 1 FROM json_each(slug_history) WHERE value = :slug
            ))

Parameters:

[
  "slug" => "Prendre-la-Parole-en-Public-en-Présentiel"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  training
WHERE
  type = 'professional'
  AND (
    slug = :slug
    OR EXISTS (
      SELECT
        1
      FROM
        json_each(slug_history)
      WHERE
        value = :slug
    )
  )

SELECT * FROM training WHERE type = 'professional' AND (slug = 'Prendre-la-Parole-en-Public-en-Présentiel' OR EXISTS (
                SELECT 1 FROM json_each(slug_history) WHERE value = 'Prendre-la-Parole-en-Public-en-Présentiel'
            ));

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 119)
2	Doctrine\DBAL\Statement->executeQuery (line 82)
3	App\Repository\TrainingProfessionalRepository->findBySlugHistory (line 116)
4	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 59)
5	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 230)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findViaExpression (line 59)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require (line 7)

0.34 ms
(10.93%)

SELECT f.id, f.question, f.answer, f.category_id, c.label AS category_label
                FROM faq f
                LEFT JOIN faqcategory c ON f.category_id = c.id
                WHERE (f.training_id = ? OR f.training_id IS NULL)
                AND (
                    c.type IS NULL -- For specific questions not linked to a category
                    OR c.type = ? 
                    OR c.type = ?
                )
                ORDER BY c.id, f.question

Parameters:

[
  307
  "BOTH"
  "PROFESSIONAL"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f.id,
  f.question,
  f.answer,
  f.category_id,
  c.label AS category_label
FROM
  faq f
  LEFT JOIN faqcategory c ON f.category_id = c.id
WHERE
  (
    f.training_id = ?
    OR f.training_id IS NULL
  )
  AND (
    c.type IS NULL -- For specific questions not linked to a category
    OR c.type = ?
    OR c.type = ?
  )
ORDER BY
  c.id,
  f.question

SELECT f.id, f.question, f.answer, f.category_id, c.label AS category_label
                FROM faq f
                LEFT JOIN faqcategory c ON f.category_id = c.id
                WHERE (f.training_id = 307 OR f.training_id IS NULL)
                AND (
                    c.type IS NULL -- For specific questions not linked to a category
                    OR c.type = 'BOTH' 
                    OR c.type = 'PROFESSIONAL'
                )
                ORDER BY c.id, f.question;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 36)
3	App\Repository\FAQRepository->loadWithProfessionalTraining (line 46)
4	App\Controller\Training\ShowTrainingController->__invoke (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require (line 7)

0.23 ms
(7.20%)

SELECT s0_.id AS id_0, s0_.start_date AS start_date_1, s0_.end_date AS end_date_2, s0_.full AS full_3, s0_.training_id AS training_id_4 FROM session s0_ WHERE s0_.start_date > ? ORDER BY s0_.start_date ASC LIMIT 5

Parameters:

[
  "2026-02-28 22:21:52"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.start_date AS start_date_1,
  s0_.end_date AS end_date_2,
  s0_.full AS full_3,
  s0_.training_id AS training_id_4
FROM
  session s0_
WHERE
  s0_.start_date > ?
ORDER BY
  s0_.start_date ASC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.start_date AS start_date_1, s0_.end_date AS end_date_2, s0_.full AS full_3, s0_.training_id AS training_id_4 FROM session s0_ WHERE s0_.start_date > '2026-02-28 22:21:52' ORDER BY s0_.start_date ASC LIMIT 5;

#	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 38)
7	App\Repository\SessionRepository->findNextAvailableSessions (line 49)
8	App\Controller\Training\ShowTrainingController->__invoke (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require (line 7)

0.19 ms
(6.12%)

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

Parameters:

[
  29
]

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

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

#	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\TrainingCategory::{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\TrainingCategory->__get (line 67)
8	App\Entity\TrainingCategory->getName (line 57)
9	App\Entity\TrainingCategory->__toString (line 113)
10	Twig\Runtime\EscaperRuntime->escape (line 161)
11	__TwigTemplate_56aebf996a306e89485b795430fd3dff->doDisplay (line 393)
12	Twig\Template->yield (line 82)
13	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->block_meta (line 437)
14	Twig\Template->yieldBlock (line 89)
15	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->doDisplay (line 393)
18	Twig\Template->yield (line 349)
19	Twig\Template->display (line 364)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 306)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
26	App\Controller\Training\ShowTrainingController->__invoke (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require (line 7)

0.19 ms
(5.98%)

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 INNER JOIN training_professional_place ON t0.id = training_professional_place.place_id WHERE training_professional_place.training_professional_id = ?

Parameters:

[
  307
]

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
  INNER JOIN training_professional_place ON t0.id = training_professional_place.place_id
WHERE
  training_professional_place.training_professional_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 INNER JOIN training_professional_place ON t0.id = training_professional_place.place_id WHERE training_professional_place.training_professional_id = 307;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 47)
8	App\Twig\Components\TrainingSessionPlaceSearch->postMount (line 199)
9	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 108)
10	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 84)
11	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 48)
14	__TwigTemplate_5aa475deb4bfa08ed4aef7b82e18f7cc->doDisplay (line 393)
15	Twig\Template->yield (line 56)
16	__TwigTemplate_c1085d43248ce69db1ec1a6705d869b8->doDisplay (line 393)
17	Twig\Template->yield (line 418)
18	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->block_body (line 437)
19	Twig\Template->yieldBlock (line 151)
20	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->doDisplay (line 393)
23	Twig\Template->yield (line 349)
24	Twig\Template->display (line 364)
25	Twig\Template->render (line 35)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
31	App\Controller\Training\ShowTrainingController->__invoke (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 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require (line 7)

0.17 ms
(5.38%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.created_by_id AS created_by_id_17, t0.category_id AS category_id_18, t0.type, t0.slug AS slug_19, t0.sub_title AS sub_title_20, t0.show_on_home_page AS show_on_home_page_21, t0.format AS format_22, t0.collective_face_to_face_hours AS collective_face_to_face_hours_23, t0.individual_face_to_face_hours AS individual_face_to_face_hours_24, t0.individual_videoconference_hours AS individual_videoconference_hours_25, t0.collective_videoconference_hours AS collective_videoconference_hours_26, t0.elearning_hours AS elearning_hours_27, t0.face_to_face_hours_text AS face_to_face_hours_text_28, t0.min_period AS min_period_29, t0.max_period AS max_period_30, t0.public AS public_31, t0.prerequisites AS prerequisites_32, t0.cpf AS cpf_33, t0.cpf_link AS cpf_link_34, t0.pdf_name AS pdf_name_35, t0.pdf_mime_type AS pdf_mime_type_36, t0.certification_id AS certification_id_37, t0.slug AS slug_38, t0.level AS level_39, t0.language AS language_40, t0.hours AS hours_41, t0.additional_students AS additional_students_42, t0.listing_image_name AS listing_image_name_43, t0.show_image_name AS show_image_name_44 FROM training t0 INNER JOIN training_related ON t0.id = training_related.training_target WHERE training_related.training_source = ? AND t0.type IN ('professional', 'elearning')

Parameters:

[
  307
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.slug_history AS slug_history_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.status AS status_7,
  t0.satisfaction_rate AS satisfaction_rate_8,
  t0.completion_rate AS completion_rate_9,
  t0.featured_on_search AS featured_on_search_10,
  t0.pixels AS pixels_11,
  t0.updated_at AS updated_at_12,
  t0.seo_title AS seo_title_13,
  t0.seo_description AS seo_description_14,
  t0.seo_canonical AS seo_canonical_15,
  t0.seo_indexed AS seo_indexed_16,
  t0.created_by_id AS created_by_id_17,
  t0.category_id AS category_id_18,
  t0.type,
  t0.slug AS slug_19,
  t0.sub_title AS sub_title_20,
  t0.show_on_home_page AS show_on_home_page_21,
  t0.format AS format_22,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_23,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_24,
  t0.individual_videoconference_hours AS individual_videoconference_hours_25,
  t0.collective_videoconference_hours AS collective_videoconference_hours_26,
  t0.elearning_hours AS elearning_hours_27,
  t0.face_to_face_hours_text AS face_to_face_hours_text_28,
  t0.min_period AS min_period_29,
  t0.max_period AS max_period_30,
  t0.public AS public_31,
  t0.prerequisites AS prerequisites_32,
  t0.cpf AS cpf_33,
  t0.cpf_link AS cpf_link_34,
  t0.pdf_name AS pdf_name_35,
  t0.pdf_mime_type AS pdf_mime_type_36,
  t0.certification_id AS certification_id_37,
  t0.slug AS slug_38,
  t0.level AS level_39,
  t0.language AS language_40,
  t0.hours AS hours_41,
  t0.additional_students AS additional_students_42,
  t0.listing_image_name AS listing_image_name_43,
  t0.show_image_name AS show_image_name_44
FROM
  training t0
  INNER JOIN training_related ON t0.id = training_related.training_target
WHERE
  training_related.training_source = ?
  AND t0.type IN ('professional', 'elearning')

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.created_by_id AS created_by_id_17, t0.category_id AS category_id_18, t0.type, t0.slug AS slug_19, t0.sub_title AS sub_title_20, t0.show_on_home_page AS show_on_home_page_21, t0.format AS format_22, t0.collective_face_to_face_hours AS collective_face_to_face_hours_23, t0.individual_face_to_face_hours AS individual_face_to_face_hours_24, t0.individual_videoconference_hours AS individual_videoconference_hours_25, t0.collective_videoconference_hours AS collective_videoconference_hours_26, t0.elearning_hours AS elearning_hours_27, t0.face_to_face_hours_text AS face_to_face_hours_text_28, t0.min_period AS min_period_29, t0.max_period AS max_period_30, t0.public AS public_31, t0.prerequisites AS prerequisites_32, t0.cpf AS cpf_33, t0.cpf_link AS cpf_link_34, t0.pdf_name AS pdf_name_35, t0.pdf_mime_type AS pdf_mime_type_36, t0.certification_id AS certification_id_37, t0.slug AS slug_38, t0.level AS level_39, t0.language AS language_40, t0.hours AS hours_41, t0.additional_students AS additional_students_42, t0.listing_image_name AS listing_image_name_43, t0.show_image_name AS show_image_name_44 FROM training t0 INNER JOIN training_related ON t0.id = training_related.training_target WHERE training_related.training_source = 307 AND t0.type IN ('professional', 'elearning');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1595)
10	Twig\Extension\CoreExtension::getAttribute (line 288)
11	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->block_body (line 437)
12	Twig\Template->yieldBlock (line 151)
13	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->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 43)
24	App\Controller\Training\ShowTrainingController->__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
(4.79%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.sub_title AS sub_title_18, t0.show_on_home_page AS show_on_home_page_19, t0.format AS format_20, t0.collective_face_to_face_hours AS collective_face_to_face_hours_21, t0.individual_face_to_face_hours AS individual_face_to_face_hours_22, t0.individual_videoconference_hours AS individual_videoconference_hours_23, t0.collective_videoconference_hours AS collective_videoconference_hours_24, t0.elearning_hours AS elearning_hours_25, t0.face_to_face_hours_text AS face_to_face_hours_text_26, t0.min_period AS min_period_27, t0.max_period AS max_period_28, t0.public AS public_29, t0.prerequisites AS prerequisites_30, t0.cpf AS cpf_31, t0.cpf_link AS cpf_link_32, t0.pdf_name AS pdf_name_33, t0.pdf_mime_type AS pdf_mime_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, t0.type FROM training t0 WHERE t0.id = ? AND t0.type IN ('professional')

Parameters:

[
  307
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.slug_history AS slug_history_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.status AS status_7,
  t0.satisfaction_rate AS satisfaction_rate_8,
  t0.completion_rate AS completion_rate_9,
  t0.featured_on_search AS featured_on_search_10,
  t0.pixels AS pixels_11,
  t0.updated_at AS updated_at_12,
  t0.seo_title AS seo_title_13,
  t0.seo_description AS seo_description_14,
  t0.seo_canonical AS seo_canonical_15,
  t0.seo_indexed AS seo_indexed_16,
  t0.slug AS slug_17,
  t0.sub_title AS sub_title_18,
  t0.show_on_home_page AS show_on_home_page_19,
  t0.format AS format_20,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_21,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_22,
  t0.individual_videoconference_hours AS individual_videoconference_hours_23,
  t0.collective_videoconference_hours AS collective_videoconference_hours_24,
  t0.elearning_hours AS elearning_hours_25,
  t0.face_to_face_hours_text AS face_to_face_hours_text_26,
  t0.min_period AS min_period_27,
  t0.max_period AS max_period_28,
  t0.public AS public_29,
  t0.prerequisites AS prerequisites_30,
  t0.cpf AS cpf_31,
  t0.cpf_link AS cpf_link_32,
  t0.pdf_name AS pdf_name_33,
  t0.pdf_mime_type AS pdf_mime_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,
  t0.type
FROM
  training t0
WHERE
  t0.id = ?
  AND t0.type IN ('professional')

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.sub_title AS sub_title_18, t0.show_on_home_page AS show_on_home_page_19, t0.format AS format_20, t0.collective_face_to_face_hours AS collective_face_to_face_hours_21, t0.individual_face_to_face_hours AS individual_face_to_face_hours_22, t0.individual_videoconference_hours AS individual_videoconference_hours_23, t0.collective_videoconference_hours AS collective_videoconference_hours_24, t0.elearning_hours AS elearning_hours_25, t0.face_to_face_hours_text AS face_to_face_hours_text_26, t0.min_period AS min_period_27, t0.max_period AS max_period_28, t0.public AS public_29, t0.prerequisites AS prerequisites_30, t0.cpf AS cpf_31, t0.cpf_link AS cpf_link_32, t0.pdf_name AS pdf_name_33, t0.pdf_mime_type AS pdf_mime_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, t0.type FROM training t0 WHERE t0.id = 307 AND t0.type IN ('professional');

#	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 84)
7	App\Repository\TrainingProfessionalRepository->findBySlugHistory (line 116)
8	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 59)
9	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 230)
10	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findViaExpression (line 59)
11	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
12	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
14	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require (line 7)

0.15 ms
(4.69%)

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 55)
10	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->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 43)
19	App\Controller\Training\ShowTrainingController->__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.13 ms
(4.15%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.training_id AS training_id_4 FROM training_program_part t0 WHERE t0.training_id = ?

Parameters:

[
  307
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.training_id AS training_id_4
FROM
  training_program_part t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.training_id AS training_id_4 FROM training_program_part t0 WHERE t0.training_id = 307;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 63)
9	__TwigTemplate_ea21a35a9c9eb03240b010ab102b47a6->doDisplay (line 393)
10	Twig\Template->yield (line 352)
11	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->block_body (line 437)
12	Twig\Template->yieldBlock (line 151)
13	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->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 43)
24	App\Controller\Training\ShowTrainingController->__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.12 ms
(3.71%)

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.full AS full_4, t0.training_id AS training_id_5 FROM session t0 WHERE t0.training_id = ?

Parameters:

[
  307
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.full AS full_4,
  t0.training_id AS training_id_5
FROM
  session t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.full AS full_4, t0.training_id AS training_id_5 FROM session t0 WHERE t0.training_id = 307;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 47)
9	App\Controller\Training\ShowTrainingController->__invoke (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require (line 7)

0.12 ms
(3.71%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.training_id AS training_id_3 FROM training_objective t0 WHERE t0.training_id = ?

Parameters:

[
  307
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.training_id AS training_id_3
FROM
  training_objective t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.training_id AS training_id_3 FROM training_objective t0 WHERE t0.training_id = 307;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 54)
8	__TwigTemplate_5871d5ab80f2ff212bc3da2f629484a9->doDisplay (line 393)
9	Twig\Template->yield (line 344)
10	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->block_body (line 437)
11	Twig\Template->yieldBlock (line 151)
12	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
23	App\Controller\Training\ShowTrainingController->__invoke (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require (line 7)

0.11 ms
(3.42%)

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 INNER JOIN training_professional_financing ON t0.id = training_professional_financing.financing_id WHERE training_professional_financing.training_professional_id = ?

Parameters:

[
  307
]

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
  INNER JOIN training_professional_financing ON t0.id = training_professional_financing.financing_id
WHERE
  training_professional_financing.training_professional_id = ?

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 INNER JOIN training_professional_financing ON t0.id = training_professional_financing.financing_id WHERE training_professional_financing.training_professional_id = 307;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 53)
8	__TwigTemplate_6c5987695dabd0d923c0abaf0ca9ea05->doDisplay (line 393)
9	Twig\Template->yield (line 410)
10	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->block_body (line 437)
11	Twig\Template->yieldBlock (line 151)
12	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_073ee24aeb802cbfe68dc0b907cf7ea5->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
23	App\Controller\Training\ShowTrainingController->__invoke (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\TrainingObjective	8
App\Entity\Session	4
App\Entity\TrainingProgramPart	4
App\Entity\Financing	3
App\Entity\Training	1
App\Entity\TrainingCategory	1

Entities Mapping

Class	Mapping 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\User	No errors.
App\Entity\TrainingCategory	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\Financing	No errors.
App\Entity\Place	No errors.
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.
App\Entity\Cms\CmsPage	No errors.
App\Entity\TrainingElearning	The association App\Entity\TrainingElearning#createdBy refers to the inverse side field App\Entity\User#trainings which does not exist.
App\Entity\PlacePicture	No errors.

Symfony Profiler

GET https://preprod-website.kaza-senza.com/nos-formations/Prendre-la-Parole-en-Public-en-Pr%C3%A9sentiel

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping