Symfony Profiler

Query Metrics

86 Database Queries

9 Different statements

17.43 ms Query time

1 Invalid entities

404 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.05 ms
(17.51%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.position_id AS position_id_3 FROM hr_main_mission t0 WHERE t0.position_id = ?

Parameters:

[
  "c27ec8d8-e8eb-43b6-90d8-514847d8e3a2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.position_id AS position_id_3
FROM
  hr_main_mission t0
WHERE
  t0.position_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.position_id AS position_id_3 FROM hr_main_mission t0 WHERE t0.position_id = 'c27ec8d8-e8eb-43b6-90d8-514847d8e3a2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 215)
8	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_once (line 5)

3.04 ms
(17.42%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.position_id AS position_id_3 FROM hr_responsibility t0 WHERE t0.position_id = ?

Parameters:

[
  "c27ec8d8-e8eb-43b6-90d8-514847d8e3a2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.position_id AS position_id_3
FROM
  hr_responsibility t0
WHERE
  t0.position_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.position_id AS position_id_3 FROM hr_responsibility t0 WHERE t0.position_id = 'c27ec8d8-e8eb-43b6-90d8-514847d8e3a2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 225)
8	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_once (line 5)

3.03 ms
(17.39%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.position_id AS position_id_3 FROM hr_mission_activity t0 WHERE t0.position_id = ?

Parameters:

[
  "c27ec8d8-e8eb-43b6-90d8-514847d8e3a2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.position_id AS position_id_3
FROM
  hr_mission_activity t0
WHERE
  t0.position_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.position_id AS position_id_3 FROM hr_mission_activity t0 WHERE t0.position_id = 'c27ec8d8-e8eb-43b6-90d8-514847d8e3a2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 220)
8	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_once (line 5)

3.01 ms
(17.25%)

SELECT t0.id AS id_1, t0.skill AS skill_2, t0.position_id AS position_id_3 FROM hr_required_skill t0 WHERE t0.position_id = ?

Parameters:

[
  "c27ec8d8-e8eb-43b6-90d8-514847d8e3a2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.skill AS skill_2,
  t0.position_id AS position_id_3
FROM
  hr_required_skill t0
WHERE
  t0.position_id = ?

SELECT t0.id AS id_1, t0.skill AS skill_2, t0.position_id AS position_id_3 FROM hr_required_skill t0 WHERE t0.position_id = 'c27ec8d8-e8eb-43b6-90d8-514847d8e3a2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 230)
8	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_once (line 5)

2.98 ms
(17.11%)

SELECT t0.id AS id_1, t0.profile AS profile_2, t0.position_id AS position_id_3 FROM hr_desired_profile t0 WHERE t0.position_id = ?

Parameters:

[
  "c27ec8d8-e8eb-43b6-90d8-514847d8e3a2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.profile AS profile_2,
  t0.position_id AS position_id_3
FROM
  hr_desired_profile t0
WHERE
  t0.position_id = ?

SELECT t0.id AS id_1, t0.profile AS profile_2, t0.position_id AS position_id_3 FROM hr_desired_profile t0 WHERE t0.position_id = 'c27ec8d8-e8eb-43b6-90d8-514847d8e3a2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 235)
8	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_once (line 5)

1.10 ms
(6.34%)

SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?

Parameters:

[
  "maintenance_mode"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.clef AS clef_1,
  t0.valeur AS valeur_2
FROM
  app_config t0
WHERE
  t0.clef = ?

SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = 'maintenance_mode';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 19)
6	App\Service\AppConfigService->get (line 56)
7	App\EventSubscriber\MaintenanceSubscriber->onKernelRequest (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.57 ms
(3.29%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.level AS level_4, t0.status AS status_5, t0.enseigne_id AS enseigne_id_6, t0.salary_min AS salary_min_7, t0.salary_max AS salary_max_8, t0.created_at AS created_at_9, t0.is_published AS is_published_10, t0.published_at AS published_at_11, t0.grade_id AS grade_id_12, t0.unit_id AS unit_id_13, t0.parent_position_id AS parent_position_id_14, t0.contract_type_id AS contract_type_id_15, t0.location_id AS location_id_16 FROM hr_job_position t0 WHERE t0.is_published = ? ORDER BY t0.published_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.status AS status_5,
  t0.enseigne_id AS enseigne_id_6,
  t0.salary_min AS salary_min_7,
  t0.salary_max AS salary_max_8,
  t0.created_at AS created_at_9,
  t0.is_published AS is_published_10,
  t0.published_at AS published_at_11,
  t0.grade_id AS grade_id_12,
  t0.unit_id AS unit_id_13,
  t0.parent_position_id AS parent_position_id_14,
  t0.contract_type_id AS contract_type_id_15,
  t0.location_id AS location_id_16
FROM
  hr_job_position t0
WHERE
  t0.is_published = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.level AS level_4, t0.status AS status_5, t0.enseigne_id AS enseigne_id_6, t0.salary_min AS salary_min_7, t0.salary_max AS salary_max_8, t0.created_at AS created_at_9, t0.is_published AS is_published_10, t0.published_at AS published_at_11, t0.grade_id AS grade_id_12, t0.unit_id AS unit_id_13, t0.parent_position_id AS parent_position_id_14, t0.contract_type_id AS contract_type_id_15, t0.location_id AS location_id_16 FROM hr_job_position t0 WHERE t0.is_published = 1 ORDER BY t0.published_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 160)
4	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_once (line 5)

0.35 ms
(2.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_evolutive AS is_evolutive_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM hr_contract_type t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_evolutive AS is_evolutive_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  hr_contract_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_evolutive AS is_evolutive_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM hr_contract_type t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\HR\ContractType::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\HR\ContractType->__get (line 45)
8	App\Entity\HR\ContractType->getName (line 208)
9	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_once (line 5)

0.30 ms
(1.69%)

SELECT t0.id AS id_1, t0.city AS city_2, t0.country AS country_3 FROM hr_location t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.country AS country_3
FROM
  hr_location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.city AS city_2, t0.country AS country_3 FROM hr_location t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\HR\Location::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\HR\Location->__get (line 35)
8	App\Entity\HR\Location->getCountry (line 204)
9	App\Controller\Api\jobsready\JobsReadyPositionController->listPublished (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_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\HR\MissionActivity	126
App\Entity\HR\RequiredSkill	88
App\Entity\HR\DesiredProfile	72
App\Entity\HR\Responsibility	67
App\Entity\HR\JobPosition	20
App\Entity\HR\MainMission	15
App\Entity\HR\OrganizationalUnit	7
App\Entity\HR\GradeLevel	4
App\Entity\AppConfig	2
App\Entity\HR\ContractType	2
App\Entity\HR\Location	1

Entities Mapping

Class	Mapping errors
App\Entity\AppConfig	No errors.
App\Entity\HR\JobPosition	No errors.
App\Entity\HR\GradeLevel	The field 'App\Entity\HR\GradeLevel#salaryCoefficient' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\HR\OrganizationalUnit	No errors.
App\Entity\HR\ContractType	No errors.
App\Entity\HR\Location	No errors.
App\Entity\HR\MainMission	No errors.
App\Entity\HR\MissionActivity	No errors.
App\Entity\HR\Responsibility	No errors.
App\Entity\HR\RequiredSkill	No errors.
App\Entity\HR\DesiredProfile	No errors.

Symfony Profiler

GET https://collabusrh-n2a.myn2a.online/public/positions

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping