http://drh-fcz.ma/reporting/cnss/app_reporting_cnss_export/155

Query Metrics

9 Database Queries
9 Different statements
14.47 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 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 0.91 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.identi_transfert AS identi_transfert_3, t0.cat AS cat_4, t0.filler AS filler_5, t0.periode AS periode_6, t0.active AS active_7, t0.created AS created_8, t0.user_created_id AS user_created_id_9 FROM tcnss_a00 t0 WHERE t0.id = ?
Parameters:
[
  "155"
]
3 0.73 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.identi_transfert AS identi_transfert_3, t0.cat AS cat_4, t0.filler AS filler_5, t0.periode AS periode_6, t0.cnssa00_id AS cnssa00_id_7 FROM tcnss_b00 t0 WHERE t0.cnssa00_id = ? LIMIT 1
Parameters:
[
  155
]
4 1.95 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.num_affilie AS num_affilie_3, t0.periode AS periode_4, t0.raison_sociale AS raison_sociale_5, t0.activite AS activite_6, t0.adresse AS adresse_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.code_agence AS code_agence_10, t0.date_emission AS date_emission_11, t0.date_exig AS date_exig_12, t0.cnssb00_id AS cnssb00_id_13 FROM tcnss_b01 t0 WHERE t0.cnssb00_id = ?
Parameters:
[
  147
]
5 7.12 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.num_affilie AS num_affilie_3, t0.periode AS periode_4, t0.num_assure AS num_assure_5, t0.nom_prenom AS nom_prenom_6, t0.enfants AS enfants_7, t0.af_apayer AS af_apayer_8, t0.af_adeduire AS af_adeduire_9, t0.af_net_apayer AS af_net_apayer_10, t0.af_areverser AS af_areverser_11, t0.n_jours_declares AS n_jours_declares_12, t0.n_salaire_reel AS n_salaire_reel_13, t0.n_salaire_plaf AS n_salaire_plaf_14, t0.l_situation AS l_situation_15, t0.l_situation_num AS l_situation_num_16, t0.s_ctr AS s_ctr_17, t0.filler AS filler_18, t0.site AS site_19, t0.statut AS statut_20, t0.montant_reel AS montant_reel_21, t0.montant_plaf AS montant_plaf_22, t0.contract_id AS contract_id_23, t0.cnssb00_id AS cnssb00_id_24 FROM tcnss_b02 t0 WHERE t0.cnssb00_id = ?
Parameters:
[
  147
]
6 1.17 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.num_affilie AS num_affilie_3, t0.periode AS periode_4, t0.nbr_salaries AS nbr_salaries_5, t0.t_enfants AS t_enfants_6, t0.t_af_apayer AS t_af_apayer_7, t0.t_af_adeduire AS t_af_adeduire_8, t0.t_af_net_apayer AS t_af_net_apayer_9, t0.t_num_imma AS t_num_imma_10, t0.t_af_areverser AS t_af_areverser_11, t0.t_jours_declares AS t_jours_declares_12, t0.t_salaire_reel AS t_salaire_reel_13, t0.t_salaire_plaf AS t_salaire_plaf_14, t0.t_ctr AS t_ctr_15, t0.filler AS filler_16, t0.cnssb00_id AS cnssb00_id_17 FROM tcnss_b03 t0 WHERE t0.cnssb00_id = ?
Parameters:
[
  147
]
7 0.83 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.num_affilie AS num_affilie_3, t0.periode AS periode_4, t0.num_assure AS num_assure_5, t0.nom_prenom AS nom_prenom_6, t0.num_cin AS num_cin_7, t0.nbr_jours AS nbr_jours_8, t0.sal_reel AS sal_reel_9, t0.sal_plaf AS sal_plaf_10, t0.s_ctr AS s_ctr_11, t0.filler AS filler_12, t0.site AS site_13, t0.montant_reel AS montant_reel_14, t0.montant_plaf AS montant_plaf_15, t0.contract_id AS contract_id_16, t0.cnssb00_id AS cnssb00_id_17 FROM tcnss_b04 t0 WHERE t0.cnssb00_id = ?
Parameters:
[
  147
]
8 0.55 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.num_affilie AS num_affilie_3, t0.periode AS periode_4, t0.nbr_salaries AS nbr_salaries_5, t0.t_num_imma AS t_num_imma_6, t0.t_jours_declares AS t_jours_declares_7, t0.t_salaire_reel AS t_salaire_reel_8, t0.t_salaire_plaf AS t_salaire_plaf_9, t0.t_ctr AS t_ctr_10, t0.filler AS filler_11, t0.cnssb00_id AS cnssb00_id_12 FROM tcnss_b05 t0 WHERE t0.cnssb00_id = ?
Parameters:
[
  147
]
9 0.57 ms
SELECT t0.id AS id_1, t0.type_enreg AS type_enreg_2, t0.num_affilie AS num_affilie_3, t0.periode AS periode_4, t0.nbr_salaries AS nbr_salaries_5, t0.t_num_imma AS t_num_imma_6, t0.t_jours_declares AS t_jours_declares_7, t0.t_salaire_reel AS t_salaire_reel_8, t0.t_salaire_plaf AS t_salaire_plaf_9, t0.t_ctr AS t_ctr_10, t0.filler AS filler_11, t0.cnssb00_id AS cnssb00_id_12 FROM tcnss_b06 t0 WHERE t0.cnssb00_id = ?
Parameters:
[
  147
]

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\TCnssA01 No errors.
App\Entity\TCnssA02
  • The mappings App\Entity\TCnssA02#contract and App\Entity\LContract#tCnssA02s are inconsistent with each other.
App\Entity\TCnssA03 No errors.
App\Entity\TCnssB00 No errors.
App\Entity\TCnssB01 No errors.
App\Entity\TCnssB02 No errors.
App\Entity\TCnssB03 No errors.
App\Entity\TCnssB04 No errors.
App\Entity\TCnssB05 No errors.
App\Entity\TCnssB06 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.