Query Metrics
9
Database Queries
9
Different statements
14.47 ms
Query time
2
Invalid entities
Queries
#▲ | 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 |
|
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 |
|