Symfony Profiler

Query Metrics

15 Database Queries

9 Different statements

2.79 ms Query time

9 Invalid entities

21 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.68 ms
(24.42%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t5.id AS id_4, t5.title AS title_6, t5.duration AS duration_7, t5.position AS position_8, t5.module_id AS module_id_9, t5.item_id AS item_id_10, t0.type, t0.content AS content_11, t0.quiz_id AS quiz_id_12, t0.audio_name AS audio_name_13, t0.video_url AS video_url_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = ? AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable')

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t5.id AS id_4,
  t5.title AS title_6,
  t5.duration AS duration_7,
  t5.position AS position_8,
  t5.module_id AS module_id_9,
  t5.item_id AS item_id_10,
  t0.type,
  t0.content AS content_11,
  t0.quiz_id AS quiz_id_12,
  t0.audio_name AS audio_name_13,
  t0.video_url AS video_url_14,
  t0.instructions AS instructions_15
FROM
  chapter_item t0
  LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'text', 'quiz', 'audio', 'video', 'deliverable'
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t5.id AS id_4, t5.title AS title_6, t5.duration AS duration_7, t5.position AS position_8, t5.module_id AS module_id_9, t5.item_id AS item_id_10, t0.type, t0.content AS content_11, t0.quiz_id AS quiz_id_12, t0.audio_name AS audio_name_13, t0.video_url AS video_url_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 4 AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 784)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2530)
4	Doctrine\ORM\UnitOfWork->createEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 147)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 171)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1005)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1792)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
11	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
12	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
13	Doctrine\ORM\PersistentCollection->initialize (line 313)
14	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 117)
15	__TwigTemplate_e8cf5e74cdbe69a0810d18932a72dd36->doDisplay (line 393)
16	Twig\Template->yield (line 418)
17	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->block_body (line 437)
18	Twig\Template->yieldBlock (line 151)
19	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->doDisplay (line 393)
22	Twig\Template->yield (line 349)
23	Twig\Template->display (line 364)
24	Twig\Template->render (line 35)
25	Twig\TemplateWrapper->render (line 306)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
30	App\Controller\Training\ShowTrainingElearningController->__invoke (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require (line 7)

0.59 ms
(21.23%)

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.level AS level_18, t0.language AS language_19, t0.hours AS hours_20, t0.additional_students AS additional_students_21, t0.listing_image_name AS listing_image_name_22, t0.show_image_name AS show_image_name_23, t0.created_by_id AS created_by_id_24, t0.category_id AS category_id_25, t0.type FROM training t0 WHERE t0.slug = ? AND t0.type IN ('elearning') LIMIT 1

Parameters:

[
  "efefefe"
]

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.level AS level_18,
  t0.language AS language_19,
  t0.hours AS hours_20,
  t0.additional_students AS additional_students_21,
  t0.listing_image_name AS listing_image_name_22,
  t0.show_image_name AS show_image_name_23,
  t0.created_by_id AS created_by_id_24,
  t0.category_id AS category_id_25,
  t0.type
FROM
  training t0
WHERE
  t0.slug = ?
  AND t0.type IN ('elearning')
LIMIT
  1

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.level AS level_18, t0.language AS language_19, t0.hours AS hours_20, t0.additional_students AS additional_students_21, t0.listing_image_name AS listing_image_name_22, t0.show_image_name AS show_image_name_23, t0.created_by_id AS created_by_id_24, t0.category_id AS category_id_25, t0.type FROM training t0 WHERE t0.slug = 'efefefe' AND t0.type IN ('elearning') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
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.32 ms
(11.44%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.duration AS duration_3, t0.position AS position_4, t0.module_id AS module_id_5, t0.item_id AS item_id_6 FROM elearning_chapter t0 WHERE t0.module_id = ? ORDER BY t0.position ASC

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.duration AS duration_3,
  t0.position AS position_4,
  t0.module_id AS module_id_5,
  t0.item_id AS item_id_6
FROM
  elearning_chapter t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.duration AS duration_3, t0.position AS position_4, t0.module_id AS module_id_5, t0.item_id AS item_id_6 FROM elearning_chapter t0 WHERE t0.module_id = 5 ORDER BY t0.position ASC;

#	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 117)
8	__TwigTemplate_e8cf5e74cdbe69a0810d18932a72dd36->doDisplay (line 393)
9	Twig\Template->yield (line 418)
10	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->block_body (line 437)
11	Twig\Template->yieldBlock (line 151)
12	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->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 23)
23	App\Controller\Training\ShowTrainingElearningController->__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.31 ms
(11.15%)

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:

[
  386
  "BOTH"
  "E_LEARNING"
]

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 = 386 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 = 'E_LEARNING'
                )
                ORDER BY c.id, f.question;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 73)
3	App\Repository\FAQRepository->loadWithElearningTraining (line 25)
4	App\Controller\Training\ShowTrainingElearningController->__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.25 ms
(8.86%)

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_47f1c5df416a4d2105a53084308ae6cf->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\ShowTrainingElearningController->__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.20 ms
(7.14%)

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:

[
  7
]

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

#	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 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 216)
10	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->block_body (line 437)
11	Twig\Template->yieldBlock (line 151)
12	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->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 23)
23	App\Controller\Training\ShowTrainingElearningController->__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.17 ms
(6.06%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.training_elearning_id AS training_elearning_id_4 FROM elearning_module t0 WHERE t0.training_elearning_id = ? ORDER BY t0.position ASC

Parameters:

[
  386
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3,
  t0.training_elearning_id AS training_elearning_id_4
FROM
  elearning_module t0
WHERE
  t0.training_elearning_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.training_elearning_id AS training_elearning_id_4 FROM elearning_module t0 WHERE t0.training_elearning_id = 386 ORDER BY t0.position ASC;

#	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 1202)
9	Twig\Extension\CoreExtension::length (line 349)
10	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->block_body (line 437)
11	Twig\Template->yieldBlock (line 151)
12	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->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 23)
23	App\Controller\Training\ShowTrainingElearningController->__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.15 ms
(5.24%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.slug AS slug_4, t0.description AS description_5, t0.certifications AS certifications_6, t0.status AS status_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.available AS available_10, t0.nda_status AS nda_status_11, t0.joined_at AS joined_at_12, t0.is_senza_trainer AS is_senza_trainer_13, t0.data_gouv_link AS data_gouv_link_14, t0.level AS level_15, t0.languages AS languages_16, t0.total_trainings AS total_trainings_17, t0.quality_chart_signed AS quality_chart_signed_18, t0.senza_training_validated AS senza_training_validated_19, t0.expert AS expert_20, t0.siret AS siret_21, t0.nda_number AS nda_number_22, t0.email_hash AS email_hash_23, t0.user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id WHERE training_trainer.training_id = ?

Parameters:

[
  386
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.certifications AS certifications_6,
  t0.status AS status_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t0.available AS available_10,
  t0.nda_status AS nda_status_11,
  t0.joined_at AS joined_at_12,
  t0.is_senza_trainer AS is_senza_trainer_13,
  t0.data_gouv_link AS data_gouv_link_14,
  t0.level AS level_15,
  t0.languages AS languages_16,
  t0.total_trainings AS total_trainings_17,
  t0.quality_chart_signed AS quality_chart_signed_18,
  t0.senza_training_validated AS senza_training_validated_19,
  t0.expert AS expert_20,
  t0.siret AS siret_21,
  t0.nda_number AS nda_number_22,
  t0.email_hash AS email_hash_23,
  t0.user_id AS user_id_24
FROM
  trainer t0
  INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id
WHERE
  training_trainer.training_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.slug AS slug_4, t0.description AS description_5, t0.certifications AS certifications_6, t0.status AS status_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.available AS available_10, t0.nda_status AS nda_status_11, t0.joined_at AS joined_at_12, t0.is_senza_trainer AS is_senza_trainer_13, t0.data_gouv_link AS data_gouv_link_14, t0.level AS level_15, t0.languages AS languages_16, t0.total_trainings AS total_trainings_17, t0.quality_chart_signed AS quality_chart_signed_18, t0.senza_training_validated AS senza_training_validated_19, t0.expert AS expert_20, t0.siret AS siret_21, t0.nda_number AS nda_number_22, t0.email_hash AS email_hash_23, t0.user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id WHERE training_trainer.training_id = 386;

#	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 693)
8	Twig\Extension\CoreExtension::slice (line 725)
9	Twig\Extension\CoreExtension::first (line 280)
10	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->block_body (line 437)
11	Twig\Template->yieldBlock (line 151)
12	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->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 23)
23	App\Controller\Training\ShowTrainingElearningController->__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.12 ms
(4.45%)

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:

[
  386
]

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

#	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 406)
10	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->block_body (line 437)
11	Twig\Template->yieldBlock (line 151)
12	__TwigTemplate_ed2db91afe01c7a1788ed1e047ce3dc6->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_47f1c5df416a4d2105a53084308ae6cf->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 23)
23	App\Controller\Training\ShowTrainingElearningController->__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\Elearning\ElearningChapter	5
App\Entity\Elearning\ChapterItem	5
App\Entity\Elearning\ElearningModule	3
App\Entity\TrainingObjective	3
App\Entity\Training	1
App\Entity\TrainingCategory	1
App\Entity\Trainer\Trainer	1
App\Entity\User	1
App\Entity\Quiz\Quiz	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\TrainingElearning	The association App\Entity\TrainingElearning#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\TrainingObjective	No errors.
App\Entity\FAQ	No errors.
App\Entity\Trainer\Trainer	No errors.
App\Entity\Elearning\ElearningModule	No errors.
App\Entity\Cms\CmsPage	No errors.
App\Entity\Place	No errors.
App\Entity\Trainer\TrainerDocument	No errors.
App\Entity\Trainer\TrainerExperience	No errors.
App\Entity\Trainer\TrainerDiploma	No errors.
App\Entity\Trainer\TrainerReview	No errors.
App\Entity\Trainer\TrainerSkill	No errors.
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\Elearning\ElearningChapter	No errors.
App\Entity\Elearning\ChapterItem	The field App\Entity\Elearning\ChapterItem#chapter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Elearning\ElearningChapter#item does not contain the required 'inversedBy: "chapter"' attribute.
App\Entity\Elearning\ChapterItemText	The field App\Entity\Elearning\ChapterItemText#chapter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Elearning\ElearningChapter#item does not contain the required 'inversedBy: "chapter"' attribute.
App\Entity\Elearning\ChapterItemQuiz	The field App\Entity\Elearning\ChapterItemQuiz#chapter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Elearning\ElearningChapter#item does not contain the required 'inversedBy: "chapter"' attribute.
App\Entity\Quiz\Quiz	No errors.
App\Entity\Elearning\ChapterItemAudio	The field App\Entity\Elearning\ChapterItemAudio#chapter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Elearning\ElearningChapter#item does not contain the required 'inversedBy: "chapter"' attribute.
App\Entity\Elearning\ChapterItemVideo	The field App\Entity\Elearning\ChapterItemVideo#chapter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Elearning\ElearningChapter#item does not contain the required 'inversedBy: "chapter"' attribute.
App\Entity\Elearning\ChapterItemDeliverable	The field App\Entity\Elearning\ChapterItemDeliverable#chapter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Elearning\ElearningChapter#item does not contain the required 'inversedBy: "chapter"' attribute.

Symfony Profiler

GET https://preprod-website.kaza-senza.com/formations-e-learning/efefefe

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping