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

Query Metrics

6 Database Queries
6 Different statements
12.37 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 0.68 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:
[
  3
]
2 2.32 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.active AS active_5, t0.date_sortie AS date_sortie_6, t0.motif_sortie AS motif_sortie_7, t0.date_anciennete AS date_anciennete_8, t0.prise_en_charge AS prise_en_charge_9, t0.salairegrille AS salairegrille_10, t0.salaireaffecte AS salaireaffecte_11, t0.ppc AS ppc_12, t0.rpc AS rpc_13, t0.matricule_ancien AS matricule_ancien_14, t0.date_desactiver AS date_desactiver_15, t0.cnss AS cnss_16, t0.date_cnss AS date_cnss_17, t0.cimr AS cimr_18, t0.date_cimr AS date_cimr_19, t0.created AS created_20, t0.updated AS updated_21, t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22, t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23, t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24, t0.stagiaire AS stagiaire_25, t0.employe_id AS employe_id_26, t0.pnature_contract_id AS pnature_contract_id_27, t0.dossier_id AS dossier_id_28, t0.bareme_id AS bareme_id_29, t0.fonction_id AS fonction_id_30, t0.piece_id AS piece_id_31, t0.user_desactiver_id AS user_desactiver_id_32, t0.duree_contract_id AS duree_contract_id_33, t0.user_updated_id AS user_updated_id_34, t0.user_created_id AS user_created_id_35 FROM lcontract t0 WHERE t0.id = ?
Parameters:
[
  "11624"
]
3 0.54 ms
"START TRANSACTION"
Parameters:
[]
4 1.05 ms
UPDATE lcontract SET updated = ? WHERE id = ?
Parameters:
[
  "2025-06-06 12:10:05"
  11624
]
5 5.78 ms
"COMMIT"
Parameters:
[]
6 2.01 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.created AS created_5, t0.code AS code_6, t0.active AS active_7, t0.swift AS swift_8, t0.banque AS banque_9, t0.contact_id_id AS contact_id_id_10 FROM lrib t0 WHERE t0.contact_id_id = ? AND t0.active = ? LIMIT 1
Parameters:
[
  11624
  1
]

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\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\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\PnatureContract No errors.
App\Entity\Pbareme
  • The association App\Entity\Pbareme#nature_cab_id refers to the owning side field App\Entity\PNaturesalarieCab#pbareme which does not exist.
App\Entity\Pfonction
  • The association App\Entity\Pfonction#lContracts refers to the owning side field App\Entity\LContract#fonctionid which does not exist.
App\Entity\PPiece No errors.
App\Entity\PdureeContract No errors.
App\Entity\LcontractFonction No errors.
App\Entity\LdossierContract No errors.
App\Entity\LmatriculationCoti No errors.
App\Entity\Lrib No errors.
App\Entity\LelementFixe No errors.
App\Entity\PArretTravail No errors.
App\Entity\LElementEcheance No errors.
App\Entity\PPrelevement No errors.
App\Entity\Tbulletin
  • The field App\Entity\Tbulletin#bulletinLgs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TbulletinLg#bulletin does not contain the required 'inversedBy="bulletinLgs"' attribute.
App\Entity\Probleme No errors.
App\Entity\TCnssA02
  • The mappings App\Entity\TCnssA02#contract and App\Entity\LContract#tCnssA02s are inconsistent with each other.
App\Entity\TCnssB02 No errors.
App\Entity\TCnssB04 No errors.