Query Metrics
7
Database Queries
5
Different statements
10.36 ms
Query time
6
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.07 ms (39.28%) |
1 |
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.active = ? AND t0.code = ? LIMIT 1
Parameters:
[ 1 "350810000000000761394495" ] |
2.99 ms (28.85%) |
2 |
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:
[
7459
]
|
2.01 ms (19.38%) |
2 |
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:
[
"11980"
]
|
0.69 ms (6.65%) |
1 |
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:
[ 11980 1 ] |
0.61 ms (5.84%) |
1 |
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:
[
105
]
|
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 |
|
App\Entity\Pemploye |
|
App\Entity\PnatureContract | No errors. |
App\Entity\Pbareme |
|
App\Entity\Pfonction |
|
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 |
|
App\Entity\Probleme | No errors. |
App\Entity\TCnssA02 |
|
App\Entity\TCnssB02 | No errors. |
App\Entity\TCnssB04 | No errors. |
App\Entity\PsituationFamiliale | No errors. |
App\Entity\PemployeDocument | No errors. |
App\Entity\Diplome | No errors. |
App\Entity\DemandeConge | No errors. |