Query Metrics
30
Database Queries
9
Different statements
209.11 ms
Query time
6
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
115.29 ms (55.14%) |
1 |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"BLP-HCZ-005233_24"
]
|
52.14 ms (24.93%) |
22 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id = ?
Parameters:
[
1
]
|
13.08 ms (6.25%) |
1 |
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.sens AS sens_3, t0.active AS active_4, t0.montant_devise AS montant_devise_5, t0.bulletin_id AS bulletin_id_6, t0.rubrique_id AS rubrique_id_7 FROM tbulletin_lg t0 WHERE t0.bulletin_id = ?
Parameters:
[
59820
]
|
7.11 ms (3.40%) |
1 |
SELECT t0.id AS id_1, t0.niveau_id AS niveau_id_2, t0.bareme AS bareme_3, t0.designation AS designation_4, t0.netapayer AS netapayer_5, t0.profil AS profil_6, t0.poste AS poste_7, t0.experience AS experience_8, t0.groupe AS groupe_9, t0.salaire_brute AS salaire_brute_10, t0.anc_profil1 AS anc_profil1_11, t0.anc_profil2 AS anc_profil2_12, t0.reference AS reference_13, t0.classe AS classe_14, t0.code_ref AS code_ref_15, t0.st_nst AS st_nst_16, t0.cmpt AS cmpt_17, t0.conditions_de_passage AS conditions_de_passage_18, t0.nature AS nature_19, t0.grade AS grade_20, t0.active AS active_21, t0.nature_sal_id_id AS nature_sal_id_id_22, t0.bareme_type_id AS bareme_type_id_23 FROM pbareme t0 WHERE t0.id = ?
Parameters:
[
131
]
|
6.85 ms (3.28%) |
1 |
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:
[
260
]
|
5.95 ms (2.84%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.active AS active_4, t0.abreviation AS abreviation_5, t0.partenaire_id AS partenaire_id_6, t0.taux_ir AS taux_ir_7, t0.type_id AS type_id_8 FROM pnature_contract t0 WHERE t0.id = ?
Parameters:
[
18
]
|
4.38 ms (2.10%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.abreviation AS abreviation_3, t0.date AS date_4, t0.is_valider AS is_valider_5, t0.is_integrer AS is_integrer_6 FROM periode t0 WHERE t0.id = ?
Parameters:
[
14
]
|
3.64 ms (1.74%) |
1 |
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.employe_id AS employe_id_22, t0.pnature_contract_id AS pnature_contract_id_23, t0.dossier_id AS dossier_id_24, t0.bareme_id AS bareme_id_25, t0.fonction_id AS fonction_id_26, t0.piece_id AS piece_id_27, t0.user_desactiver_id AS user_desactiver_id_28, t0.duree_contract_id AS duree_contract_id_29, t0.user_updated_id AS user_updated_id_30, t0.user_created_id AS user_created_id_31 FROM lcontract t0 WHERE t0.id = ?
Parameters:
[
1770
]
|
0.66 ms (0.32%) |
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:
[
10
]
|
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\Tbulletin |
|
App\Entity\Periode | No errors. |
App\Entity\LContract |
|
App\Entity\PDevise | No errors. |
App\Entity\PPaiement | No errors. |
App\Entity\PBordereau | No errors. |
App\Entity\PPiece | No errors. |
App\Entity\PPrelevementLg | No errors. |
App\Entity\TbulletinLg | No errors. |
App\Entity\LElementEcheance | No errors. |
App\Entity\JournalBulletinLg | No errors. |
App\Entity\ContractNetTheorique | No errors. |
App\Entity\Prubrique | No errors. |
App\Entity\Pemploye |
|
App\Entity\PnatureContract | No errors. |
App\Entity\Pbareme |
|
App\Entity\Pfonction |
|
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\PPrelevement | No errors. |
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. |
App\Entity\TypRemuneration | No errors. |
App\Entity\PCompteComptable | No errors. |
App\Entity\LnaturecontratBareme | No errors. |
App\Entity\PNaturesalarieCab | No errors. |
App\Entity\PBaremeType | No errors. |
App\Entity\PbaremeBrute | No errors. |
App\Entity\PBaremeCimr | No errors. |
App\Entity\PArretTravailLg | No errors. |
App\Entity\SyntheseRemunarationCab | No errors. |
App\Entity\VMatrix | No errors. |