POST https://e-recru.metfp.mg/

Query Metrics

11 Database Queries
6 Different statements
6.74 ms Query time
2 Invalid entities
19 Managed entities

Queries

Group similar statements

# Time Info
1 0.86 ms
SELECT COUNT(*) FROM candidat t0
Parameters:
[]
2 0.64 ms
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
]
3 1.03 ms
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
Parameters:
[
  1
]
4 0.79 ms
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:
[
  3
]
5 0.58 ms
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:
[
  190
]
6 0.44 ms
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:
[
  19
]
7 0.48 ms
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:
[
  181
]
8 0.50 ms
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:
[
  1
]
9 0.45 ms
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:
[
  5
]
10 0.47 ms
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
]
11 0.49 ms
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:
[
  9
]

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 2
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.