Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

31.65 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.66 ms
(68.42%)

SELECT t0_.title AS title_0, t0_.startup AS startup_1, t0_.duration AS duration_2, t0_.periode AS periode_3, t0_.language AS language_4, t0_.about AS about_5, t0_.objective AS objective_6, t0_.prerequired AS prerequired_7, t0_.learn AS learn_8, t0_.career AS career_9, t0_.project AS project_10, t0_.id AS id_11, t0_.idnum AS idnum_12, t0_.enabled AS enabled_13, t0_.slug AS slug_14, t0_.created AS created_15, t0_.updated AS updated_16, t0_.file_name AS file_name_17, t0_.file_url AS file_url_18, t0_.title AS title_19, t0_.startup AS startup_20, t0_.duration AS duration_21, t0_.periode AS periode_22, t0_.language AS language_23, t0_.about AS about_24, t0_.objective AS objective_25, t0_.prerequired AS prerequired_26, t0_.learn AS learn_27, t0_.career AS career_28, t0_.project AS project_29, t0_.id AS id_30, t0_.idnum AS idnum_31, t0_.enabled AS enabled_32, t0_.slug AS slug_33, t0_.created AS created_34, t0_.updated AS updated_35, t0_.file_name AS file_name_36, t0_.file_url AS file_url_37, t1_.name AS name_38, t1_.id AS id_39, t1_.idnum AS idnum_40, t1_.enabled AS enabled_41, t1_.slug AS slug_42, t2_.name AS name_43, t2_.id AS id_44, t2_.idnum AS idnum_45, t2_.enabled AS enabled_46, t2_.slug AS slug_47, t3_.name AS name_48, t3_.id AS id_49, t3_.idnum AS idnum_50, t3_.enabled AS enabled_51, t3_.slug AS slug_52, t4_.id AS id_53, t4_.idnum AS idnum_54, t4_.enabled AS enabled_55, p5_.title AS title_56, p5_.position AS position_57, p5_.id AS id_58, p5_.idnum AS idnum_59, p5_.enabled AS enabled_60, t6_.name AS name_61, t6_.scopes AS scopes_62, t6_.id AS id_63, t6_.idnum AS idnum_64, t6_.enabled AS enabled_65, t6_.slug AS slug_66, t0_.category_id AS category_id_67, t0_.level_id AS level_id_68, t0_.program_id AS program_id_69, p5_.program_id AS program_id_70 FROM training t0_ LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id LEFT JOIN training_training_format t7_ ON t0_.id = t7_.training_id LEFT JOIN training_format t2_ ON t2_.id = t7_.training_format_id LEFT JOIN training_level t3_ ON t0_.level_id = t3_.id LEFT JOIN training_program t4_ ON t0_.program_id = t4_.id LEFT JOIN program_module p5_ ON t4_.id = p5_.program_id LEFT JOIN training_tag t8_ ON t0_.id = t8_.training_id LEFT JOIN tag t6_ ON t6_.id = t8_.tag_id WHERE t0_.slug = ? AND t0_.enabled = ? ORDER BY p5_.position ASC

Parameters:

[
  "excel-competences-essentielles-pour-l-analyse"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.title AS title_0,
  t0_.startup AS startup_1,
  t0_.duration AS duration_2,
  t0_.periode AS periode_3,
  t0_.language AS language_4,
  t0_.about AS about_5,
  t0_.objective AS objective_6,
  t0_.prerequired AS prerequired_7,
  t0_.learn AS learn_8,
  t0_.career AS career_9,
  t0_.project AS project_10,
  t0_.id AS id_11,
  t0_.idnum AS idnum_12,
  t0_.enabled AS enabled_13,
  t0_.slug AS slug_14,
  t0_.created AS created_15,
  t0_.updated AS updated_16,
  t0_.file_name AS file_name_17,
  t0_.file_url AS file_url_18,
  t0_.title AS title_19,
  t0_.startup AS startup_20,
  t0_.duration AS duration_21,
  t0_.periode AS periode_22,
  t0_.language AS language_23,
  t0_.about AS about_24,
  t0_.objective AS objective_25,
  t0_.prerequired AS prerequired_26,
  t0_.learn AS learn_27,
  t0_.career AS career_28,
  t0_.project AS project_29,
  t0_.id AS id_30,
  t0_.idnum AS idnum_31,
  t0_.enabled AS enabled_32,
  t0_.slug AS slug_33,
  t0_.created AS created_34,
  t0_.updated AS updated_35,
  t0_.file_name AS file_name_36,
  t0_.file_url AS file_url_37,
  t1_.name AS name_38,
  t1_.id AS id_39,
  t1_.idnum AS idnum_40,
  t1_.enabled AS enabled_41,
  t1_.slug AS slug_42,
  t2_.name AS name_43,
  t2_.id AS id_44,
  t2_.idnum AS idnum_45,
  t2_.enabled AS enabled_46,
  t2_.slug AS slug_47,
  t3_.name AS name_48,
  t3_.id AS id_49,
  t3_.idnum AS idnum_50,
  t3_.enabled AS enabled_51,
  t3_.slug AS slug_52,
  t4_.id AS id_53,
  t4_.idnum AS idnum_54,
  t4_.enabled AS enabled_55,
  p5_.title AS title_56,
  p5_.position AS position_57,
  p5_.id AS id_58,
  p5_.idnum AS idnum_59,
  p5_.enabled AS enabled_60,
  t6_.name AS name_61,
  t6_.scopes AS scopes_62,
  t6_.id AS id_63,
  t6_.idnum AS idnum_64,
  t6_.enabled AS enabled_65,
  t6_.slug AS slug_66,
  t0_.category_id AS category_id_67,
  t0_.level_id AS level_id_68,
  t0_.program_id AS program_id_69,
  p5_.program_id AS program_id_70
FROM
  training t0_
  LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id
  LEFT JOIN training_training_format t7_ ON t0_.id = t7_.training_id
  LEFT JOIN training_format t2_ ON t2_.id = t7_.training_format_id
  LEFT JOIN training_level t3_ ON t0_.level_id = t3_.id
  LEFT JOIN training_program t4_ ON t0_.program_id = t4_.id
  LEFT JOIN program_module p5_ ON t4_.id = p5_.program_id
  LEFT JOIN training_tag t8_ ON t0_.id = t8_.training_id
  LEFT JOIN tag t6_ ON t6_.id = t8_.tag_id
WHERE
  t0_.slug = ?
  AND t0_.enabled = ?
ORDER BY
  p5_.position ASC

SELECT t0_.title AS title_0, t0_.startup AS startup_1, t0_.duration AS duration_2, t0_.periode AS periode_3, t0_.language AS language_4, t0_.about AS about_5, t0_.objective AS objective_6, t0_.prerequired AS prerequired_7, t0_.learn AS learn_8, t0_.career AS career_9, t0_.project AS project_10, t0_.id AS id_11, t0_.idnum AS idnum_12, t0_.enabled AS enabled_13, t0_.slug AS slug_14, t0_.created AS created_15, t0_.updated AS updated_16, t0_.file_name AS file_name_17, t0_.file_url AS file_url_18, t0_.title AS title_19, t0_.startup AS startup_20, t0_.duration AS duration_21, t0_.periode AS periode_22, t0_.language AS language_23, t0_.about AS about_24, t0_.objective AS objective_25, t0_.prerequired AS prerequired_26, t0_.learn AS learn_27, t0_.career AS career_28, t0_.project AS project_29, t0_.id AS id_30, t0_.idnum AS idnum_31, t0_.enabled AS enabled_32, t0_.slug AS slug_33, t0_.created AS created_34, t0_.updated AS updated_35, t0_.file_name AS file_name_36, t0_.file_url AS file_url_37, t1_.name AS name_38, t1_.id AS id_39, t1_.idnum AS idnum_40, t1_.enabled AS enabled_41, t1_.slug AS slug_42, t2_.name AS name_43, t2_.id AS id_44, t2_.idnum AS idnum_45, t2_.enabled AS enabled_46, t2_.slug AS slug_47, t3_.name AS name_48, t3_.id AS id_49, t3_.idnum AS idnum_50, t3_.enabled AS enabled_51, t3_.slug AS slug_52, t4_.id AS id_53, t4_.idnum AS idnum_54, t4_.enabled AS enabled_55, p5_.title AS title_56, p5_.position AS position_57, p5_.id AS id_58, p5_.idnum AS idnum_59, p5_.enabled AS enabled_60, t6_.name AS name_61, t6_.scopes AS scopes_62, t6_.id AS id_63, t6_.idnum AS idnum_64, t6_.enabled AS enabled_65, t6_.slug AS slug_66, t0_.category_id AS category_id_67, t0_.level_id AS level_id_68, t0_.program_id AS program_id_69, p5_.program_id AS program_id_70 FROM training t0_ LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id LEFT JOIN training_training_format t7_ ON t0_.id = t7_.training_id LEFT JOIN training_format t2_ ON t2_.id = t7_.training_format_id LEFT JOIN training_level t3_ ON t0_.level_id = t3_.id LEFT JOIN training_program t4_ ON t0_.program_id = t4_.id LEFT JOIN program_module p5_ ON t4_.id = p5_.program_id LEFT JOIN training_tag t8_ ON t0_.id = t8_.training_id LEFT JOIN tag t6_ ON t6_.id = t8_.tag_id WHERE t0_.slug = 'excel-competences-essentielles-pour-l-analyse' AND t0_.enabled = 1 ORDER BY p5_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Training\TrainingRepository->findOneCompleteBy (line 221)
7	App\Repository\Training\TrainingRepository->findOneCompleteBySlug (line 229)
8	App\Controller\Frontend\Training\TrainingController->show (line 78)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

9.99 ms
(31.58%)

SELECT t0_.id AS id_0, t0_.idnum AS idnum_1, t0_.enabled AS enabled_2, t0_.title AS title_3, t0_.slug AS slug_4, t0_.startup AS startup_5, t0_.file_name AS file_name_6, t0_.file_url AS file_url_7, t1_.id AS id_8, t1_.name AS name_9, t1_.slug AS slug_10, t2_.id AS id_11, t2_.name AS name_12, t2_.slug AS slug_13, COUNT(DISTINCT p3_.id) AS sclr_14, COUNT(DISTINCT t4_.id) AS sclr_15 FROM training t0_ LEFT JOIN training_program t5_ ON t0_.program_id = t5_.id LEFT JOIN program_module p3_ ON t5_.id = p3_.program_id LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id LEFT JOIN training_level t2_ ON t0_.level_id = t2_.id LEFT JOIN training_tag t6_ ON t0_.id = t6_.training_id LEFT JOIN tag t4_ ON t4_.id = t6_.tag_id WHERE t0_.enabled = ? AND t0_.id <> ? AND t4_.id IN (?, ?, ?) GROUP BY t0_.id, t1_.id, t2_.id ORDER BY sclr_15 DESC, t0_.created DESC LIMIT 4

Parameters:

[
  1
  Symfony\Component\Uid\UuidV7 {#1078
    __toString(): "019c0dd0-e616-7bfc-9f39-0be530bf6f9a"
  }
  Symfony\Component\Uid\UuidV7 {#1119
    __toString(): "019c0dc4-c60d-7cdc-833d-cb8eb622bdb5"
  }
  Symfony\Component\Uid\UuidV7 {#1358
    __toString(): "019c0dc3-c1e5-714e-b81a-efbad8738036"
  }
  Symfony\Component\Uid\UuidV7 {#1356
    __toString(): "019c0dc6-220d-702d-9f5c-1ba924d12fa6"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.idnum AS idnum_1,
  t0_.enabled AS enabled_2,
  t0_.title AS title_3,
  t0_.slug AS slug_4,
  t0_.startup AS startup_5,
  t0_.file_name AS file_name_6,
  t0_.file_url AS file_url_7,
  t1_.id AS id_8,
  t1_.name AS name_9,
  t1_.slug AS slug_10,
  t2_.id AS id_11,
  t2_.name AS name_12,
  t2_.slug AS slug_13,
  COUNT(DISTINCT p3_.id) AS sclr_14,
  COUNT(DISTINCT t4_.id) AS sclr_15
FROM
  training t0_
  LEFT JOIN training_program t5_ ON t0_.program_id = t5_.id
  LEFT JOIN program_module p3_ ON t5_.id = p3_.program_id
  LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id
  LEFT JOIN training_level t2_ ON t0_.level_id = t2_.id
  LEFT JOIN training_tag t6_ ON t0_.id = t6_.training_id
  LEFT JOIN tag t4_ ON t4_.id = t6_.tag_id
WHERE
  t0_.enabled = ?
  AND t0_.id <> ?
  AND t4_.id IN (?, ?, ?)
GROUP BY
  t0_.id,
  t1_.id,
  t2_.id
ORDER BY
  sclr_15 DESC,
  t0_.created DESC
LIMIT
  4

SELECT t0_.id AS id_0, t0_.idnum AS idnum_1, t0_.enabled AS enabled_2, t0_.title AS title_3, t0_.slug AS slug_4, t0_.startup AS startup_5, t0_.file_name AS file_name_6, t0_.file_url AS file_url_7, t1_.id AS id_8, t1_.name AS name_9, t1_.slug AS slug_10, t2_.id AS id_11, t2_.name AS name_12, t2_.slug AS slug_13, COUNT(DISTINCT p3_.id) AS sclr_14, COUNT(DISTINCT t4_.id) AS sclr_15 FROM training t0_ LEFT JOIN training_program t5_ ON t0_.program_id = t5_.id LEFT JOIN program_module p3_ ON t5_.id = p3_.program_id LEFT JOIN training_category t1_ ON t0_.category_id = t1_.id LEFT JOIN training_level t2_ ON t0_.level_id = t2_.id LEFT JOIN training_tag t6_ ON t0_.id = t6_.training_id LEFT JOIN tag t4_ ON t4_.id = t6_.tag_id WHERE t0_.enabled = 1 AND t0_.id <> '019c0dd0-e616-7bfc-9f39-0be530bf6f9a' AND t4_.id IN ('019c0dc4-c60d-7cdc-833d-cb8eb622bdb5', '019c0dc3-c1e5-714e-b81a-efbad8738036', '019c0dc6-220d-702d-9f5c-1ba924d12fa6') GROUP BY t0_.id, t1_.id, t2_.id ORDER BY sclr_15 DESC, t0_.created DESC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Repository\Training\TrainingRepository->findSimilarByTags (line 320)
7	App\Components\Training\Training\TrainingSimilar->getSimilarTrainings (line 20)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_69080f8c91093d2cbe7468c4f1c52d7a::doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_fca369ccc245536951c557b8bb472d4e->block_content (line 144)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_f16b8672e65512743c9449fa73d7c6f2->doDisplay (line 112)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_fca369ccc245536951c557b8bb472d4e->doDisplay (line 57)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\Frontend\Training\TrainingController->show (line 84)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

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\Training\ProgramModule	5
App\Entity\Setting\Tag	3
App\Entity\Training\TrainingFormat	2
App\Entity\Training\Training	1
App\Entity\Training\TrainingCategory	1
App\Entity\Training\TrainingLevel	1
App\Entity\Training\TrainingProgram	1

Entities Mapping

Class	Mapping errors
App\Entity\Training\Training	No errors.
App\Entity\Training\TrainingCategory	No errors.
App\Entity\Training\TrainingFormat	No errors.
App\Entity\Training\TrainingLevel	No errors.
App\Entity\Training\TrainingProgram	No errors.
App\Entity\Training\ProgramModule	No errors.
App\Entity\Setting\Tag	No errors.
App\Entity\Training\TrainingSubscriber	No errors.
App\Entity\Blog\Post	No errors.

Symfony Profiler

GET https://test.icesacademy.org/fr/trainings/excel-competences-essentielles-pour-l-analyse

Configuration Settings

Theme

Page Width