Symfony Profiler

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 = ?

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 = 17;

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 = ?

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 = 3;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND (
    e0_.nom LIKE ?
    OR e0_.prenom LIKE ?
    OR e0_.numero_extrait LIKE ?
  )

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND (e0_.nom LIKE '%631 du 1%' OR e0_.prenom LIKE '%631 du 1%' OR e0_.numero_extrait LIKE '%631 du 1%');

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.id AS id_1
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND (
    e0_.nom LIKE ?
    OR e0_.prenom LIKE ?
    OR e0_.numero_extrait LIKE ?
  )
ORDER BY
  e0_.id DESC
LIMIT
  50

SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 FROM extrait e0_ WHERE e0_.client_id = 3 AND (e0_.nom LIKE '%631 du 1%' OR e0_.prenom LIKE '%631 du 1%' OR e0_.numero_extrait LIKE '%631 du 1%') ORDER BY e0_.id DESC LIMIT 50;

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_.client_id = ?
  AND (
    e0_.nom LIKE ?
    OR e0_.prenom LIKE ?
    OR e0_.numero_extrait LIKE ?
  )
  AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  e0_.id DESC

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_.client_id = 3 AND (e0_.nom LIKE '%631 du 1%' OR e0_.prenom LIKE '%631 du 1%' OR e0_.numero_extrait LIKE '%631 du 1%') AND e0_.id IN (101118, 100953, 87218, 81250, 79948, 76650, 73641, 71366, 69627) ORDER BY e0_.id DESC;

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 = ?

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 = 743;

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 = ?

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 = 2;

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 = ?

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 = 516;

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 = ?

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 = 100;