GET https://getaci.dianoch.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAdminController%253A%253ArenderSidebar

Response
200 OK
Browse referrer URL
IP
160.154.233.185
Profiled on
Token
0696ba

Query Metrics

11 Database Queries
11 Different statements
252.29 ms Query time
0 Invalid entities
27 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
244.08 ms
(96.74%) 		1 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
1.23 ms
(0.49%) 		1 
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.registre_naissance_id = ?
Parameters: 
[
  287
]
View formatted query    View runnable query    Explain query    View query backtrace
1.02 ms
(0.40%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.client_id AS client_id_7 FROM centre t0 WHERE t0.client_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.99 ms
(0.39%) 		1 
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.registre_naissance_id = ?
Parameters: 
[
  287
]
View formatted query    View runnable query    Explain query    View query backtrace
0.97 ms
(0.38%) 		1 
SELECT t0.id AS id_1, t0.code AS code_2, t0.annee AS annee_3, t0.lieu_etablissement AS lieu_etablissement_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.centre_id AS centre_id_9, t0.client_id AS client_id_10, t0.type_registre_id AS type_registre_id_11 FROM registre_naissance t0 WHERE t0.id = ?
Parameters: 
[
  "287"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(0.35%) 		1 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.client_id AS client_id_7 FROM type_registre t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.83 ms
(0.33%) 		1 
SELECT e0_.id AS id_0, e0_.type_delai AS type_delai_1, e0_.numero_extrait AS numero_extrait_2, e0_.source AS source_3, e0_.nni AS nni_4, e0_.date_dresse AS date_dresse_5, e0_.heure_dresse AS heure_dresse_6, e0_.type_extrait AS type_extrait_7, e0_.numero_js_loi AS numero_js_loi_8, e0_.tribunal AS tribunal_9, e0_.nom_juge AS nom_juge_10, e0_.fonction_juge AS fonction_juge_11, e0_.numero_faux_acte AS numero_faux_acte_12, e0_.provenance AS provenance_13, e0_.decla_de AS decla_de_14, e0_.avec_assistance_de AS avec_assistance_de_15, e0_.recu_en_langue AS recu_en_langue_16, e0_.en_presence_de AS en_presence_de_17, e0_.age_de AS age_de_18, e0_.profession AS profession_19, e0_.domicile AS domicile_20, e0_.temoignage AS temoignage_21, e0_.signature AS signature_22, e0_.et_de AS et_de_23, e0_.age_de2 AS age_de2_24, e0_.profession2 AS profession2_25, e0_.domicile2 AS domicile2_26, e0_.temoignage2 AS temoignage2_27, e0_.signature2 AS signature2_28, e0_.par_nous AS par_nous_29, e0_.nous_avons_signe AS nous_avons_signe_30, e0_.piece_joint AS piece_joint_31, e0_.created_at AS created_at_32, e0_.updated_at AS updated_at_33, e0_.created_by AS created_by_34, e0_.updated_by AS updated_by_35, e0_.page AS page_36, e0_.nom AS nom_37, e0_.prenom AS prenom_38, e0_.autre_nom AS autre_nom_39, e0_.type AS type_40, e0_.heure_naissance AS heure_naissance_41, e0_.domicile_enfant AS domicile_enfant_42, e0_.commune_enfant AS commune_enfant_43, e0_.coutume_enfant AS coutume_enfant_44, e0_.sexe AS sexe_45, e0_.nom_dans_le_corps_de_acte AS nom_dans_le_corps_de_acte_46, e0_.date_naissance AS date_naissance_47, e0_.annee_naissance AS annee_naissance_48, e0_.is_etat AS is_etat_49, e0_.president AS president_50, e0_.secretaire AS secretaire_51, e0_.assesseur1 AS assesseur1_52, e0_.assesseur2 AS assesseur2_53, e0_.interprete AS interprete_54, e0_.date_js_loi AS date_js_loi_55, e0_.date_dresse_en_lettre AS date_dresse_en_lettre_56, e0_.heure_dresse_en_lettre AS heure_dresse_en_lettre_57, e0_.date_naissance_en_lettre AS date_naissance_en_lettre_58, e0_.heure_naissance_en_lettre AS heure_naissance_en_lettre_59, e0_.annee_naissance_en_lettre AS annee_naissance_en_lettre_60, e0_.lieu_naissance AS lieu_naissance_61, e0_.cercle AS cercle_62, e0_.subdivision AS subdivision_63, e0_.is_demande AS is_demande_64, e0_.numero_registre AS numero_registre_65, e0_.annee_registre AS annee_registre_66, e0_.centre_registre AS centre_registre_67, e0_.nom_pere AS nom_pere_68, e0_.prenom_pere AS prenom_pere_69, e0_.nom_prenom_integrale_pere AS nom_prenom_integrale_pere_70, e0_.type_date_naissance_pere AS type_date_naissance_pere_71, e0_.coutume_pere AS coutume_pere_72, e0_.profession_pere AS profession_pere_73, e0_.domicile_pere AS domicile_pere_74, e0_.nationalite_pere AS nationalite_pere_75, e0_.lieu_naissance_pere AS lieu_naissance_pere_76, e0_.date_naissance_pere AS date_naissance_pere_77, e0_.age_pere AS age_pere_78, e0_.annee_naissance_pere AS annee_naissance_pere_79, e0_.date_naissance_en_lettre_pere AS date_naissance_en_lettre_pere_80, e0_.annee_naissance_en_lettre_pere AS annee_naissance_en_lettre_pere_81, e0_.nom_prenom_integrale_mere AS nom_prenom_integrale_mere_82, e0_.nom_mere AS nom_mere_83, e0_.prenom_mere AS prenom_mere_84, e0_.annee_naissance_en_lettre_mere AS annee_naissance_en_lettre_mere_85, e0_.date_naissance_en_lettre_mere AS date_naissance_en_lettre_mere_86, e0_.age_mere AS age_mere_87, e0_.annee_naissance_mere AS annee_naissance_mere_88, e0_.date_naissance_mere AS date_naissance_mere_89, e0_.type_date_naissance_mere AS type_date_naissance_mere_90, e0_.coutume_mere AS coutume_mere_91, e0_.profession_mere AS profession_mere_92, e0_.domicile_mere AS domicile_mere_93, e0_.nationalite_mere AS nationalite_mere_94, e0_.lieu_naissance_mere AS lieu_naissance_mere_95, e0_.date_mariage AS date_mariage_96, e0_.date_deces AS date_deces_97, e0_.date_divorce AS date_divorce_98, e0_.lieu_mariage AS lieu_mariage_99, e0_.lieu_deces AS lieu_deces_100, e0_.conjoint AS conjoint_101, e0_.mention_court_mariage AS mention_court_mariage_102, e0_.mention_court_deces AS mention_court_deces_103, e0_.mention_court_divorce AS mention_court_divorce_104, e0_.mention_court_jsloi AS mention_court_jsloi_105, e0_.mention_integrale_jsloi AS mention_integrale_jsloi_106, e0_.mention_integrale_divorce AS mention_integrale_divorce_107, e0_.mention_integrale_deces AS mention_integrale_deces_108, e0_.mention_integrale_mariage AS mention_integrale_mariage_109, e0_.departement_ext_souche AS departement_ext_souche_110, e0_.sous_prefecture_ext_souche AS sous_prefecture_ext_souche_111, e0_.commune_ext_souche AS commune_ext_souche_112, e0_.centre_ext_souche AS centre_ext_souche_113, e0_.nom_avant_prenom AS nom_avant_prenom_114, e0_.requerent_id AS requerent_id_115, e0_.client_id AS client_id_116, e0_.registre_naissance_id AS registre_naissance_id_117 FROM extrait e0_ WHERE e0_.registre_naissance_id = ? AND e0_.id IN (?) ORDER BY e0_.id DESC
Parameters: 
[
  287
  98592
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(0.27%) 		1 
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: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(0.23%) 		1 
SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 FROM extrait e0_ WHERE e0_.registre_naissance_id = ? ORDER BY e0_.id DESC LIMIT 10
Parameters: 
[
  287
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(0.22%) 		1 
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: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.19%) 		1 
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, t0_.created_by AS created_by_4, t0_.updated_by AS updated_by_5, t0_.client_id AS client_id_6 FROM type_registre t0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\TypeRegistre 10
App\Entity\Centre 8
App\Entity\User 1
App\Entity\Client 1
App\Entity\District 1
App\Entity\Region 1
App\Entity\Departement 1
App\Entity\Commune 1
App\Entity\Ville 1
App\Entity\RegistreNaissance 1
App\Entity\Extrait 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\CertificatVie No errors.
App\Entity\RechercheInfructueuse No errors.
App\Entity\AttestationNonNaissance No errors.
App\Entity\AttestationNonDeces No errors.
App\Entity\Requerent No errors.