Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.21 ms Query time

0 Invalid entities

63 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.36 ms
(30.08%)

SELECT t0_.id AS id_0, t1_.id AS id_1, t1_.locale AS locale_2, t1_.name AS name_3, t1_.specialty_id AS specialty_id_4 FROM training_specialties t0_ LEFT JOIN training_specialty_translations t1_ ON t0_.id = t1_.specialty_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t1_.id AS id_1,
  t1_.locale AS locale_2,
  t1_.name AS name_3,
  t1_.specialty_id AS specialty_id_4
FROM
  training_specialties t0_
  LEFT JOIN training_specialty_translations t1_ ON t0_.id = t1_.specialty_id

SELECT t0_.id AS id_0, t1_.id AS id_1, t1_.locale AS locale_2, t1_.name AS name_3, t1_.specialty_id AS specialty_id_4 FROM training_specialties t0_ LEFT JOIN training_specialty_translations t1_ ON t0_.id = t1_.specialty_id;

#	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->getResult (line 688)
6	App\Training\Infrastructure\Persistence\Doctrine\DoctrineSpecialtyRepository->findAllWithTranslations (line 26)
7	App\UI\Training\Controller\CourseListController->__invoke (line 39)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.35 ms
(28.92%)

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.level AS level_3, t0_.image_key AS image_key_4, t0_.price_cents AS price_cents_5, t0_.currency AS currency_6, t0_.duration_hours AS duration_hours_7, t0_.published_at AS published_at_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t1_.id AS id_11, t1_.locale AS locale_12, t1_.title AS title_13, t1_.slug AS slug_14, t1_.summary AS summary_15, t1_.content AS content_16, t2_.id AS id_17, t2_.name AS name_18, t2_.logo_key AS logo_key_19, t3_.id AS id_20, t0_.institution_id AS institution_id_21, t1_.course_id AS course_id_22 FROM training_courses t0_ LEFT JOIN training_course_translations t1_ ON t0_.id = t1_.course_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_course_specialties t4_ ON t0_.id = t4_.course_id LEFT JOIN training_specialties t3_ ON t3_.id = t4_.specialty_id WHERE t0_.status = ? ORDER BY t0_.published_at DESC

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.modality AS modality_2,
  t0_.level AS level_3,
  t0_.image_key AS image_key_4,
  t0_.price_cents AS price_cents_5,
  t0_.currency AS currency_6,
  t0_.duration_hours AS duration_hours_7,
  t0_.published_at AS published_at_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  t1_.id AS id_11,
  t1_.locale AS locale_12,
  t1_.title AS title_13,
  t1_.slug AS slug_14,
  t1_.summary AS summary_15,
  t1_.content AS content_16,
  t2_.id AS id_17,
  t2_.name AS name_18,
  t2_.logo_key AS logo_key_19,
  t3_.id AS id_20,
  t0_.institution_id AS institution_id_21,
  t1_.course_id AS course_id_22
FROM
  training_courses t0_
  LEFT JOIN training_course_translations t1_ ON t0_.id = t1_.course_id
  LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id
  LEFT JOIN training_course_specialties t4_ ON t0_.id = t4_.course_id
  LEFT JOIN training_specialties t3_ ON t3_.id = t4_.specialty_id
WHERE
  t0_.status = ?
ORDER BY
  t0_.published_at DESC

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.level AS level_3, t0_.image_key AS image_key_4, t0_.price_cents AS price_cents_5, t0_.currency AS currency_6, t0_.duration_hours AS duration_hours_7, t0_.published_at AS published_at_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t1_.id AS id_11, t1_.locale AS locale_12, t1_.title AS title_13, t1_.slug AS slug_14, t1_.summary AS summary_15, t1_.content AS content_16, t2_.id AS id_17, t2_.name AS name_18, t2_.logo_key AS logo_key_19, t3_.id AS id_20, t0_.institution_id AS institution_id_21, t1_.course_id AS course_id_22 FROM training_courses t0_ LEFT JOIN training_course_translations t1_ ON t0_.id = t1_.course_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_course_specialties t4_ ON t0_.id = t4_.course_id LEFT JOIN training_specialties t3_ ON t3_.id = t4_.specialty_id WHERE t0_.status = 'published' ORDER BY t0_.published_at DESC;

#	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->getResult (line 688)
6	App\Training\Infrastructure\Persistence\Doctrine\DoctrineCourseRepository->findPublished (line 163)
7	App\Training\Application\Catalog\SearchCourses->__invoke (line 19)
8	App\UI\Training\Controller\CourseListController->__invoke (line 38)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
11	Symfony\Component\HttpKernel\Kernel->handle (line 143)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.29 ms
(23.86%)

SELECT t0_.id AS id_0, t1_.id AS id_1, t1_.locale AS locale_2, t1_.name AS name_3, t1_.profile_id AS profile_id_4 FROM training_professional_profiles t0_ LEFT JOIN training_professional_profile_translations t1_ ON t0_.id = t1_.profile_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t1_.id AS id_1,
  t1_.locale AS locale_2,
  t1_.name AS name_3,
  t1_.profile_id AS profile_id_4
FROM
  training_professional_profiles t0_
  LEFT JOIN training_professional_profile_translations t1_ ON t0_.id = t1_.profile_id

SELECT t0_.id AS id_0, t1_.id AS id_1, t1_.locale AS locale_2, t1_.name AS name_3, t1_.profile_id AS profile_id_4 FROM training_professional_profiles t0_ LEFT JOIN training_professional_profile_translations t1_ ON t0_.id = t1_.profile_id;

#	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->getResult (line 688)
6	App\Training\Infrastructure\Persistence\Doctrine\DoctrineProfessionalProfileRepository->findAllWithTranslations (line 26)
7	App\UI\Training\Controller\CourseListController->__invoke (line 40)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.21 ms
(17.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo_key AS logo_key_3 FROM training_institutions t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo_key AS logo_key_3
FROM
  training_institutions t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo_key AS logo_key_3 FROM training_institutions t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Training\Infrastructure\Persistence\Doctrine\DoctrineInstitutionRepository->findAll (line 21)
6	App\UI\Training\Controller\CourseListController->__invoke (line 41)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	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\Training\Domain\SpecialtyTranslation	16
App\Training\Domain\ProfessionalProfileTranslation	12
App\Training\Domain\CourseTranslation	10
App\Training\Domain\Specialty	8
App\Training\Domain\Institution	6
App\Training\Domain\ProfessionalProfile	6
App\Training\Domain\Course	5

Entities Mapping

Class	Mapping errors
App\Training\Domain\Course	No errors.
App\Training\Domain\CourseTranslation	No errors.
App\Training\Domain\Institution	No errors.
App\Training\Domain\Specialty	No errors.
App\Training\Domain\ProfessionalProfile	No errors.
App\Training\Domain\Instructor	No errors.
App\Training\Domain\SpecialtyTranslation	No errors.
App\Training\Domain\ProfessionalProfileTranslation	No errors.

GET https://clinical-talent.isdeveloping.com/en/courses

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping