Symfony Profiler

Query Metrics

12 Database Queries

6 Different statements

585.82 ms Query time

2 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

184.00 ms
(31.41%)

SELECT COUNT(*) FROM candidat t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  candidat t0

SELECT COUNT(*) FROM candidat t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Controller\ListeCandidatController->index (line 24)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

144.82 ms
(24.72%)

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero_decision AS numero_decision_3, t0.nbr_poste AS nbr_poste_4, t0.is_active AS is_active_5 FROM recrutement t0 WHERE t0.is_active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.numero_decision AS numero_decision_3,
  t0.nbr_poste AS nbr_poste_4,
  t0.is_active AS is_active_5
FROM
  recrutement t0
WHERE
  t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero_decision AS numero_decision_3, t0.nbr_poste AS nbr_poste_4, t0.is_active AS is_active_5 FROM recrutement t0 WHERE t0.is_active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ListeCandidatController->index (line 26)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

100.99 ms
(17.24%)

SELECT t0.id AS id_1, t0.abr AS abr_2, t0.diplome AS diplome_3, t0.niveau AS niveau_4, t0.points_cfp AS points_cfp_5, t0.points_ltp AS points_ltp_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM diplome t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.abr AS abr_2,
  t0.diplome AS diplome_3,
  t0.niveau AS niveau_4,
  t0.points_cfp AS points_cfp_5,
  t0.points_ltp AS points_ltp_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  diplome t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.abr AS abr_2, t0.diplome AS diplome_3, t0.niveau AS niveau_4, t0.points_cfp AS points_cfp_5, t0.points_ltp AS points_ltp_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM diplome t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Diplome::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Diplome->__get (line 153)
7	App\Entity\Diplome->getDiplome (line 71)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_ca76f62270ce910228d3855d6ded8271::block_body (line 392)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_974f76c986cd749fd1396ab22fe75688->doDisplay (line 75)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_ca76f62270ce910228d3855d6ded8271->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\ListeCandidatController->index (line 33)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

75.49 ms
(12.89%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.date_entree AS date_entree_12, t0.anciennete AS anciennete_13, t0.type_matiere AS type_matiere_14, t0.volume_horaire AS volume_horaire_15, t0.competences AS competences_16, t0.matieres AS matieres_17, t0.fichier_name AS fichier_name_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.note_anciennete AS note_anciennete_21, t0.note_specialite AS note_specialite_22, t0.note_volume_horaire AS note_volume_horaire_23, t0.note_diplome AS note_diplome_24, t0.note_age AS note_age_25, t0.note_total AS note_total_26, t0.region_id AS region_id_27, t0.etablissement_id AS etablissement_id_28, t0.diplome_id AS diplome_id_29, t0.recrutement_id AS recrutement_id_30 FROM candidat t0 WHERE t0.recrutement_id = ? ORDER BY t0.id ASC LIMIT 10 OFFSET 100

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.statut AS statut_4,
  t0.im AS im_5,
  t0.cin AS cin_6,
  t0.date_naissance AS date_naissance_7,
  t0.lieu_delivrance AS lieu_delivrance_8,
  t0.infos AS infos_9,
  t0.corps AS corps_10,
  t0.num_decision AS num_decision_11,
  t0.date_entree AS date_entree_12,
  t0.anciennete AS anciennete_13,
  t0.type_matiere AS type_matiere_14,
  t0.volume_horaire AS volume_horaire_15,
  t0.competences AS competences_16,
  t0.matieres AS matieres_17,
  t0.fichier_name AS fichier_name_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.note_anciennete AS note_anciennete_21,
  t0.note_specialite AS note_specialite_22,
  t0.note_volume_horaire AS note_volume_horaire_23,
  t0.note_diplome AS note_diplome_24,
  t0.note_age AS note_age_25,
  t0.note_total AS note_total_26,
  t0.region_id AS region_id_27,
  t0.etablissement_id AS etablissement_id_28,
  t0.diplome_id AS diplome_id_29,
  t0.recrutement_id AS recrutement_id_30
FROM
  candidat t0
WHERE
  t0.recrutement_id = ?
ORDER BY
  t0.id ASC
LIMIT
  10
OFFSET
  100

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.date_entree AS date_entree_12, t0.anciennete AS anciennete_13, t0.type_matiere AS type_matiere_14, t0.volume_horaire AS volume_horaire_15, t0.competences AS competences_16, t0.matieres AS matieres_17, t0.fichier_name AS fichier_name_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.note_anciennete AS note_anciennete_21, t0.note_specialite AS note_specialite_22, t0.note_volume_horaire AS note_volume_horaire_23, t0.note_diplome AS note_diplome_24, t0.note_age AS note_age_25, t0.note_total AS note_total_26, t0.region_id AS region_id_27, t0.etablissement_id AS etablissement_id_28, t0.diplome_id AS diplome_id_29, t0.recrutement_id AS recrutement_id_30 FROM candidat t0 WHERE t0.recrutement_id = 1 ORDER BY t0.id ASC LIMIT 10 OFFSET 100;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\ListeCandidatController->index (line 29)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

44.21 ms
(7.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_active AS is_active_4 FROM region t0 WHERE t0.id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_active AS is_active_4
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_active AS is_active_4 FROM region t0 WHERE t0.id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Region::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Region->__get (line 153)
7	App\Entity\Region->getName (line 52)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_ca76f62270ce910228d3855d6ded8271::block_body (line 375)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_974f76c986cd749fd1396ab22fe75688->doDisplay (line 75)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_ca76f62270ce910228d3855d6ded8271->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\ListeCandidatController->index (line 33)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

36.31 ms
(6.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.is_active AS is_active_6, t0.type AS type_7, t0.quota AS quota_8, t0.timetable AS timetable_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.region_id AS region_id_12 FROM entity t0 WHERE t0.id = ?

Parameters:

[
  82
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.is_active AS is_active_6,
  t0.type AS type_7,
  t0.quota AS quota_8,
  t0.timetable AS timetable_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.region_id AS region_id_12
FROM
  entity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.is_active AS is_active_6, t0.type AS type_7, t0.quota AS quota_8, t0.timetable AS timetable_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.region_id AS region_id_12 FROM entity t0 WHERE t0.id = 82;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Entity::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Entity->__isset (line 258)
7	App\Entity\Entity->__toString (line 204)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_ca76f62270ce910228d3855d6ded8271->block_body (line 379)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_974f76c986cd749fd1396ab22fe75688->doDisplay (line 75)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_ca76f62270ce910228d3855d6ded8271->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\ListeCandidatController->index (line 33)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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\Candidat	10
App\Entity\Diplome	5
App\Entity\Entity	3
App\Entity\Recrutement	1
App\Entity\Region	1

Entities Mapping

Class	Mapping errors
App\Entity\Candidat	No errors.
App\Entity\Recrutement	No errors.
App\Entity\ProcesVerbal	No errors.
App\Entity\Region	The field App\Entity\Region#users is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#region does not contain the required 'inversedBy: "users"' attribute. The field App\Entity\Region#candidats is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Candidat#region does not contain the required 'inversedBy: "candidats"' attribute.
App\Entity\Entity	The field App\Entity\Entity#users is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#entity does not contain the required 'inversedBy: "users"' attribute.
App\Entity\Diplome	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://e-recru.metfp.mg/?page=11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping