http://drh-fcz.ma/salarie/salarie/plusinfo Return to referer URL

Query Metrics

5 Database Queries
5 Different statements
9.40 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.16 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = ?
Parameters:
[
  106
]
2 0.91 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.matricule AS matricule_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.sexe AS sexe_8, t0.nombre_enfants AS nombre_enfants_9, t0.nbr_pris_en_charge AS nbr_pris_en_charge_10, t0.cin AS cin_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.nationalite AS nationalite_17, t0.tel1 AS tel1_18, t0.tel2 AS tel2_19, t0.email AS email_20, t0.active AS active_21, t0.created AS created_22, t0.contacturgent AS contacturgent_23, t0.prenomurgence AS prenomurgence_24, t0.nomurgence AS nomurgence_25, t0.degredeparente AS degredeparente_26, t0.adresseurgence AS adresseurgence_27, t0.teleurgence AS teleurgence_28, t0.villeurgence AS villeurgence_29, t0.prenomconjoint AS prenomconjoint_30, t0.nomconjoint AS nomconjoint_31, t0.datenaiconjoint AS datenaiconjoint_32, t0.nomprenompere AS nomprenompere_33, t0.nomprenommere AS nomprenommere_34, t0.stc AS stc_35, t0.updated AS updated_36, t0.roles AS roles_37, t0.password AS password_38, t0.nombre_jour_conge AS nombre_jour_conge_39, t0.is_first_login AS is_first_login_40, t0.situation_familiale_id_id AS situation_familiale_id_id_41, t0.user_updated_id AS user_updated_id_42, t43.id AS id_44, t43.cin AS cin_45, t43.cin_path AS cin_path_46, t43.acte_naissance AS acte_naissance_47, t43.acte_naissance_path AS acte_naissance_path_48, t43.formulaire AS formulaire_49, t43.formulaire_path AS formulaire_path_50, t43.contrat AS contrat_51, t43.contrat_path AS contrat_path_52, t43.dossier_medical AS dossier_medical_53, t43.dossier_medical_path AS dossier_medical_path_54, t43.bac AS bac_55, t43.bac_path AS bac_path_56, t43.diplome AS diplome_57, t43.diplome_path AS diplome_path_58, t43.cv AS cv_59, t43.cv_path AS cv_path_60, t43.rib AS rib_61, t43.rib_path AS rib_path_62, t43.fiche_anthropometrique AS fiche_anthropometrique_63, t43.fiche_anthropometrique_path AS fiche_anthropometrique_path_64, t43.photo AS photo_65, t43.photo_path AS photo_path_66, t43.emprunte AS emprunte_67, t43.emprunte_path AS emprunte_path_68, t43.acte_mariage AS acte_mariage_69, t43.acte_mariage_path AS acte_mariage_path_70, t43.cin_conjoint AS cin_conjoint_71, t43.cin_conjoint_path AS cin_conjoint_path_72, t43.acte_naissance_enfants AS acte_naissance_enfants_73, t43.acte_naissance_enfants_path AS acte_naissance_enfants_path_74, t43.cin_enfants AS cin_enfants_75, t43.cin_enfants_path AS cin_enfants_path_76, t43.cin_parents AS cin_parents_77, t43.cin_parents_path AS cin_parents_path_78, t43.employe_id AS employe_id_79 FROM pemploye t0 LEFT JOIN pemploye_document t43 ON t43.employe_id = t0.id WHERE t0.id = ?
Parameters:
[
  "8751"
]
3 0.37 ms
"START TRANSACTION"
Parameters:
[]
4 0.75 ms
UPDATE pemploye SET contacturgent = ?, prenomurgence = ?, nomurgence = ?, degredeparente = ?, adresseurgence = ?, teleurgence = ?, villeurgence = ?, prenomconjoint = ?, nomconjoint = ?, datenaiconjoint = ?, nomprenompere = ?, nomprenommere = ? WHERE id = ?
Parameters:
[
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  ""
  "1970-01-01"
  ""
  ""
  8751
]
5 6.21 ms
"COMMIT"
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\Users No errors.
App\Entity\PDossier No errors.
App\Entity\HonoraireDetFixe No errors.
App\Entity\TCnssA00 No errors.
App\Entity\PNotification No errors.
App\Entity\Pemploye
  • The association App\Entity\Pemploye#situation_familiale_id refers to the inverse side field App\Entity\PsituationFamiliale#code which does not exist.
  • The field App\Entity\Pemploye#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LContract#employe does not contain the required 'inversedBy="contracts"' attribute.
App\Entity\PsituationFamiliale No errors.
App\Entity\PemployeDocument No errors.
App\Entity\Diplome No errors.
App\Entity\LContract
  • The mappings App\Entity\LContract#lmatriculationCotis and App\Entity\LmatriculationCoti#contract_id are inconsistent with each other.
  • The mappings App\Entity\LContract#fonction and App\Entity\Pfonction#lContracts are inconsistent with each other.
  • The association App\Entity\LContract#tCnssA02s refers to the owning side field App\Entity\TCnssA02#LContract which does not exist.
App\Entity\DemandeConge No errors.