Query Metrics
4
Database Queries
4
Different statements
8.19 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.67 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.email AS email_8, t0.last_name AS last_name_9, t0.first_name AS first_name_10, t0.phone_number AS phone_number_11, t0.address AS address_12, t0.location AS location_13, t0.client_id AS client_id_14 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||
| 2 | 0.85 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.contact AS contact_4, t0.type AS type_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.code AS code_11, t0.le_responsable AS le_responsable_12, t0.date_debut_at AS date_debut_at_13, t0.date_fin_at AS date_fin_at_14, t0.district_id AS district_id_15, t0.region_id AS region_id_16, t0.departement_id AS departement_id_17, t0.commune_id AS commune_id_18, t0.ville_id AS ville_id_19 FROM client t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||
| 3 | 3.40 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.contact AS contact_4, t0.type AS type_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.code AS code_11, t0.le_responsable AS le_responsable_12, t0.date_debut_at AS date_debut_at_13, t0.date_fin_at AS date_fin_at_14, t0.district_id AS district_id_15, t0.region_id AS region_id_16, t0.departement_id AS departement_id_17, t0.commune_id AS commune_id_18, t0.ville_id AS ville_id_19 FROM client t0 ORDER BY t0.id DESC
Parameters:
[]
|
||||||||||||||||||||||
| 4 | 2.27 ms |
SELECT t0.id AS id_1, t0.type_delai AS type_delai_2, t0.numero_extrait AS numero_extrait_3, t0.source AS source_4, t0.nni AS nni_5, t0.date_dresse AS date_dresse_6, t0.heure_dresse AS heure_dresse_7, t0.type_extrait AS type_extrait_8, t0.numero_js_loi AS numero_js_loi_9, t0.tribunal AS tribunal_10, t0.nom_juge AS nom_juge_11, t0.fonction_juge AS fonction_juge_12, t0.numero_faux_acte AS numero_faux_acte_13, t0.provenance AS provenance_14, t0.decla_de AS decla_de_15, t0.avec_assistance_de AS avec_assistance_de_16, t0.recu_en_langue AS recu_en_langue_17, t0.en_presence_de AS en_presence_de_18, t0.age_de AS age_de_19, t0.profession AS profession_20, t0.domicile AS domicile_21, t0.temoignage AS temoignage_22, t0.signature AS signature_23, t0.et_de AS et_de_24, t0.age_de2 AS age_de2_25, t0.profession2 AS profession2_26, t0.domicile2 AS domicile2_27, t0.temoignage2 AS temoignage2_28, t0.signature2 AS signature2_29, t0.par_nous AS par_nous_30, t0.nous_avons_signe AS nous_avons_signe_31, t0.piece_joint AS piece_joint_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36, t0.page AS page_37, t0.nom AS nom_38, t0.prenom AS prenom_39, t0.autre_nom AS autre_nom_40, t0.type AS type_41, t0.heure_naissance AS heure_naissance_42, t0.domicile_enfant AS domicile_enfant_43, t0.commune_enfant AS commune_enfant_44, t0.coutume_enfant AS coutume_enfant_45, t0.sexe AS sexe_46, t0.nom_dans_le_corps_de_acte AS nom_dans_le_corps_de_acte_47, t0.date_naissance AS date_naissance_48, t0.annee_naissance AS annee_naissance_49, t0.is_etat AS is_etat_50, t0.president AS president_51, t0.secretaire AS secretaire_52, t0.assesseur1 AS assesseur1_53, t0.assesseur2 AS assesseur2_54, t0.interprete AS interprete_55, t0.date_js_loi AS date_js_loi_56, t0.date_dresse_en_lettre AS date_dresse_en_lettre_57, t0.heure_dresse_en_lettre AS heure_dresse_en_lettre_58, t0.date_naissance_en_lettre AS date_naissance_en_lettre_59, t0.heure_naissance_en_lettre AS heure_naissance_en_lettre_60, t0.annee_naissance_en_lettre AS annee_naissance_en_lettre_61, t0.lieu_naissance AS lieu_naissance_62, t0.cercle AS cercle_63, t0.subdivision AS subdivision_64, t0.is_demande AS is_demande_65, t0.numero_registre AS numero_registre_66, t0.annee_registre AS annee_registre_67, t0.centre_registre AS centre_registre_68, t0.nom_pere AS nom_pere_69, t0.prenom_pere AS prenom_pere_70, t0.nom_prenom_integrale_pere AS nom_prenom_integrale_pere_71, t0.type_date_naissance_pere AS type_date_naissance_pere_72, t0.coutume_pere AS coutume_pere_73, t0.profession_pere AS profession_pere_74, t0.domicile_pere AS domicile_pere_75, t0.nationalite_pere AS nationalite_pere_76, t0.lieu_naissance_pere AS lieu_naissance_pere_77, t0.date_naissance_pere AS date_naissance_pere_78, t0.age_pere AS age_pere_79, t0.annee_naissance_pere AS annee_naissance_pere_80, t0.date_naissance_en_lettre_pere AS date_naissance_en_lettre_pere_81, t0.annee_naissance_en_lettre_pere AS annee_naissance_en_lettre_pere_82, t0.nom_prenom_integrale_mere AS nom_prenom_integrale_mere_83, t0.nom_mere AS nom_mere_84, t0.prenom_mere AS prenom_mere_85, t0.annee_naissance_en_lettre_mere AS annee_naissance_en_lettre_mere_86, t0.date_naissance_en_lettre_mere AS date_naissance_en_lettre_mere_87, t0.age_mere AS age_mere_88, t0.annee_naissance_mere AS annee_naissance_mere_89, t0.date_naissance_mere AS date_naissance_mere_90, t0.type_date_naissance_mere AS type_date_naissance_mere_91, t0.coutume_mere AS coutume_mere_92, t0.profession_mere AS profession_mere_93, t0.domicile_mere AS domicile_mere_94, t0.nationalite_mere AS nationalite_mere_95, t0.lieu_naissance_mere AS lieu_naissance_mere_96, t0.date_mariage AS date_mariage_97, t0.date_deces AS date_deces_98, t0.date_divorce AS date_divorce_99, t0.lieu_mariage AS lieu_mariage_100, t0.lieu_deces AS lieu_deces_101, t0.conjoint AS conjoint_102, t0.mention_court_mariage AS mention_court_mariage_103, t0.mention_court_deces AS mention_court_deces_104, t0.mention_court_divorce AS mention_court_divorce_105, t0.mention_court_jsloi AS mention_court_jsloi_106, t0.mention_integrale_jsloi AS mention_integrale_jsloi_107, t0.mention_integrale_divorce AS mention_integrale_divorce_108, t0.mention_integrale_deces AS mention_integrale_deces_109, t0.mention_integrale_mariage AS mention_integrale_mariage_110, t0.departement_ext_souche AS departement_ext_souche_111, t0.sous_prefecture_ext_souche AS sous_prefecture_ext_souche_112, t0.commune_ext_souche AS commune_ext_souche_113, t0.centre_ext_souche AS centre_ext_souche_114, t0.nom_avant_prenom AS nom_avant_prenom_115, t0.requerent_id AS requerent_id_116, t0.client_id AS client_id_117, t0.registre_naissance_id AS registre_naissance_id_118 FROM extrait t0 WHERE t0.is_demande = ?
Parameters:
[
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Client | 2 |
| App\Entity\User | 1 |
| App\Entity\District | 1 |
| App\Entity\Region | 1 |
| App\Entity\Departement | 1 |
| App\Entity\Commune | 1 |
| App\Entity\Ville | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Ville | No errors. |
| App\Entity\RegistreNaissance | No errors. |
| App\Entity\Extrait | No errors. |
| App\Entity\Mention | No errors. |
| App\Entity\Centre | No errors. |
| App\Entity\Personnes | No errors. |
| App\Entity\TypeRegistre | No errors. |
| App\Entity\RegistreMariage | No errors. |
| App\Entity\RegistreDeces | No errors. |
| App\Entity\ActeMariage | No errors. |
| App\Entity\ActeDeces | No errors. |
| App\Entity\CodeUtilise | No errors. |
| App\Entity\Requerent | No errors. |