Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.fichier AS fichier_1,
  c0_.nom AS nom_2,
  c0_.langue AS langue_3,
  c0_.date_signature AS date_signature_4,
  c0_.url_source AS url_source_5,
  c0_.mode_divulgation AS mode_divulgation_6,
  c0_.mode_text_divulgation AS mode_text_divulgation_7,
  c0_.date_recuperation AS date_recuperation_8,
  c0_.categorie AS categorie_9,
  c0_.note AS note_10,
  c0_.identifiant AS identifiant_11,
  c0_.page_manquent AS page_manquent_12,
  c0_.annexe_manquent AS annexe_manquent_13,
  c0_.statut AS statut_14,
  c0_.part_etat AS part_etat_15,
  c0_.dure AS dure_16,
  c0_.annee_signature AS annee_signature_17,
  c0_.pas_de_porte AS pas_de_porte_18,
  c0_.loyer_annuel AS loyer_annuel_19,
  c0_.royalties AS royalties_20,
  c0_.reserves AS reserves_21,
  c0_.ressources AS ressources_22,
  c0_.id_dw AS id_dw_23,
  c0_.is_publish AS is_publish_24,
  c0_.created_at AS created_at_25,
  c0_.updated_at AS updated_at_26,
  c0_.deleted_at AS deleted_at_27,
  c0_.type_document_id AS type_document_id_28,
  c0_.actionnariats_locaux_id AS actionnariats_locaux_id_29,
  c0_.user_id AS user_id_30
FROM
  contrat_principal c0_
WHERE
  c0_.is_publish = 1
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.fichier AS fichier_1, c0_.nom AS nom_2, c0_.langue AS langue_3, c0_.date_signature AS date_signature_4, c0_.url_source AS url_source_5, c0_.mode_divulgation AS mode_divulgation_6, c0_.mode_text_divulgation AS mode_text_divulgation_7, c0_.date_recuperation AS date_recuperation_8, c0_.categorie AS categorie_9, c0_.note AS note_10, c0_.identifiant AS identifiant_11, c0_.page_manquent AS page_manquent_12, c0_.annexe_manquent AS annexe_manquent_13, c0_.statut AS statut_14, c0_.part_etat AS part_etat_15, c0_.dure AS dure_16, c0_.annee_signature AS annee_signature_17, c0_.pas_de_porte AS pas_de_porte_18, c0_.loyer_annuel AS loyer_annuel_19, c0_.royalties AS royalties_20, c0_.reserves AS reserves_21, c0_.ressources AS ressources_22, c0_.id_dw AS id_dw_23, c0_.is_publish AS is_publish_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c0_.deleted_at AS deleted_at_27, c0_.type_document_id AS type_document_id_28, c0_.actionnariats_locaux_id AS actionnariats_locaux_id_29, c0_.user_id AS user_id_30 FROM contrat_principal c0_ WHERE c0_.is_publish = 1 ORDER BY c0_.id ASC;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_principal c0_
WHERE
  c0_.is_publish = 1

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.is_publish = 1;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_relatif c0_

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.id_dw AS id_dw_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  type_contrat t0
  INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id
WHERE
  contrat_principal_type_contrat.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_contrat t0 INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id WHERE contrat_principal_type_contrat.contrat_principal_id = 1;

SELECT
  t0.id AS id_1,
  t0.permis AS permis_2,
  t0.titulaire AS titulaire_3,
  t0.type_permis AS type_permis_4,
  t0.status AS status_5,
  t0.date_octroi AS date_octroi_6,
  t0.date_expiration AS date_expiration_7,
  t0.carres AS carres_8,
  t0.localisation AS localisation_9,
  t0.code AS code_10,
  t0.libelle AS libelle_11,
  t0.id_dw AS id_dw_12,
  t0.is_publish AS is_publish_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.province_id AS province_id_17,
  t0.arrete_id AS arrete_id_18,
  t0.projet_id AS projet_id_19,
  t0.user_id AS user_id_20
FROM
  titre_minier t0
  INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id
WHERE
  contrat_principal_titre_minier.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.permis AS permis_2, t0.titulaire AS titulaire_3, t0.type_permis AS type_permis_4, t0.status AS status_5, t0.date_octroi AS date_octroi_6, t0.date_expiration AS date_expiration_7, t0.carres AS carres_8, t0.localisation AS localisation_9, t0.code AS code_10, t0.libelle AS libelle_11, t0.id_dw AS id_dw_12, t0.is_publish AS is_publish_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.province_id AS province_id_17, t0.arrete_id AS arrete_id_18, t0.projet_id AS projet_id_19, t0.user_id AS user_id_20 FROM titre_minier t0 INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id WHERE contrat_principal_titre_minier.contrat_principal_id = 1;

SELECT
  t0.id AS id_1,
  t0.fichier AS fichier_2,
  t0.nom AS nom_3,
  t0.langue AS langue_4,
  t0.date_signature AS date_signature_5,
  t0.url_source AS url_source_6,
  t0.mode_divulgation AS mode_divulgation_7,
  t0.mode_text_divulgation AS mode_text_divulgation_8,
  t0.date_recuperation AS date_recuperation_9,
  t0.categorie AS categorie_10,
  t0.note AS note_11,
  t0.identifiant AS identifiant_12,
  t0.page_manquent AS page_manquent_13,
  t0.annexe_manquent AS annexe_manquent_14,
  t0.statut AS statut_15,
  t0.part_etat AS part_etat_16,
  t0.dure AS dure_17,
  t0.annee_signature AS annee_signature_18,
  t0.pas_de_porte AS pas_de_porte_19,
  t0.loyer_annuel AS loyer_annuel_20,
  t0.royaltie AS royaltie_21,
  t0.ressources AS ressources_22,
  t0.reserves AS reserves_23,
  t0.id_dw AS id_dw_24,
  t0.is_publish AS is_publish_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.deleted_at AS deleted_at_28,
  t0.type_document_id AS type_document_id_29,
  t0.contrat_principal_id AS contrat_principal_id_30,
  t0.actionnariats_locaux_id AS actionnariats_locaux_id_31,
  t0.user_id AS user_id_32
FROM
  contrat_relatif t0
WHERE
  t0.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.pas_de_porte AS pas_de_porte_19, t0.loyer_annuel AS loyer_annuel_20, t0.royaltie AS royaltie_21, t0.ressources AS ressources_22, t0.reserves AS reserves_23, t0.id_dw AS id_dw_24, t0.is_publish AS is_publish_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.type_document_id AS type_document_id_29, t0.contrat_principal_id AS contrat_principal_id_30, t0.actionnariats_locaux_id AS actionnariats_locaux_id_31, t0.user_id AS user_id_32 FROM contrat_relatif t0 WHERE t0.contrat_principal_id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.id_dw AS id_dw_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  type_contrat t0
  INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id
WHERE
  contrat_principal_type_contrat.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_contrat t0 INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id WHERE contrat_principal_type_contrat.contrat_principal_id = 2;

SELECT
  t0.id AS id_1,
  t0.permis AS permis_2,
  t0.titulaire AS titulaire_3,
  t0.type_permis AS type_permis_4,
  t0.status AS status_5,
  t0.date_octroi AS date_octroi_6,
  t0.date_expiration AS date_expiration_7,
  t0.carres AS carres_8,
  t0.localisation AS localisation_9,
  t0.code AS code_10,
  t0.libelle AS libelle_11,
  t0.id_dw AS id_dw_12,
  t0.is_publish AS is_publish_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.province_id AS province_id_17,
  t0.arrete_id AS arrete_id_18,
  t0.projet_id AS projet_id_19,
  t0.user_id AS user_id_20
FROM
  titre_minier t0
  INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id
WHERE
  contrat_principal_titre_minier.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.permis AS permis_2, t0.titulaire AS titulaire_3, t0.type_permis AS type_permis_4, t0.status AS status_5, t0.date_octroi AS date_octroi_6, t0.date_expiration AS date_expiration_7, t0.carres AS carres_8, t0.localisation AS localisation_9, t0.code AS code_10, t0.libelle AS libelle_11, t0.id_dw AS id_dw_12, t0.is_publish AS is_publish_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.province_id AS province_id_17, t0.arrete_id AS arrete_id_18, t0.projet_id AS projet_id_19, t0.user_id AS user_id_20 FROM titre_minier t0 INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id WHERE contrat_principal_titre_minier.contrat_principal_id = 2;

SELECT
  t0.id AS id_1,
  t0.fichier AS fichier_2,
  t0.nom AS nom_3,
  t0.langue AS langue_4,
  t0.date_signature AS date_signature_5,
  t0.url_source AS url_source_6,
  t0.mode_divulgation AS mode_divulgation_7,
  t0.mode_text_divulgation AS mode_text_divulgation_8,
  t0.date_recuperation AS date_recuperation_9,
  t0.categorie AS categorie_10,
  t0.note AS note_11,
  t0.identifiant AS identifiant_12,
  t0.page_manquent AS page_manquent_13,
  t0.annexe_manquent AS annexe_manquent_14,
  t0.statut AS statut_15,
  t0.part_etat AS part_etat_16,
  t0.dure AS dure_17,
  t0.annee_signature AS annee_signature_18,
  t0.pas_de_porte AS pas_de_porte_19,
  t0.loyer_annuel AS loyer_annuel_20,
  t0.royaltie AS royaltie_21,
  t0.ressources AS ressources_22,
  t0.reserves AS reserves_23,
  t0.id_dw AS id_dw_24,
  t0.is_publish AS is_publish_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.deleted_at AS deleted_at_28,
  t0.type_document_id AS type_document_id_29,
  t0.contrat_principal_id AS contrat_principal_id_30,
  t0.actionnariats_locaux_id AS actionnariats_locaux_id_31,
  t0.user_id AS user_id_32
FROM
  contrat_relatif t0
WHERE
  t0.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.pas_de_porte AS pas_de_porte_19, t0.loyer_annuel AS loyer_annuel_20, t0.royaltie AS royaltie_21, t0.ressources AS ressources_22, t0.reserves AS reserves_23, t0.id_dw AS id_dw_24, t0.is_publish AS is_publish_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.type_document_id AS type_document_id_29, t0.contrat_principal_id AS contrat_principal_id_30, t0.actionnariats_locaux_id AS actionnariats_locaux_id_31, t0.user_id AS user_id_32 FROM contrat_relatif t0 WHERE t0.contrat_principal_id = 2;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.id_dw AS id_dw_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  type_contrat t0
  INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id
WHERE
  contrat_principal_type_contrat.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_contrat t0 INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id WHERE contrat_principal_type_contrat.contrat_principal_id = 3;

SELECT
  t0.id AS id_1,
  t0.permis AS permis_2,
  t0.titulaire AS titulaire_3,
  t0.type_permis AS type_permis_4,
  t0.status AS status_5,
  t0.date_octroi AS date_octroi_6,
  t0.date_expiration AS date_expiration_7,
  t0.carres AS carres_8,
  t0.localisation AS localisation_9,
  t0.code AS code_10,
  t0.libelle AS libelle_11,
  t0.id_dw AS id_dw_12,
  t0.is_publish AS is_publish_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.province_id AS province_id_17,
  t0.arrete_id AS arrete_id_18,
  t0.projet_id AS projet_id_19,
  t0.user_id AS user_id_20
FROM
  titre_minier t0
  INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id
WHERE
  contrat_principal_titre_minier.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.permis AS permis_2, t0.titulaire AS titulaire_3, t0.type_permis AS type_permis_4, t0.status AS status_5, t0.date_octroi AS date_octroi_6, t0.date_expiration AS date_expiration_7, t0.carres AS carres_8, t0.localisation AS localisation_9, t0.code AS code_10, t0.libelle AS libelle_11, t0.id_dw AS id_dw_12, t0.is_publish AS is_publish_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.province_id AS province_id_17, t0.arrete_id AS arrete_id_18, t0.projet_id AS projet_id_19, t0.user_id AS user_id_20 FROM titre_minier t0 INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id WHERE contrat_principal_titre_minier.contrat_principal_id = 3;

SELECT
  t0.id AS id_1,
  t0.fichier AS fichier_2,
  t0.nom AS nom_3,
  t0.langue AS langue_4,
  t0.date_signature AS date_signature_5,
  t0.url_source AS url_source_6,
  t0.mode_divulgation AS mode_divulgation_7,
  t0.mode_text_divulgation AS mode_text_divulgation_8,
  t0.date_recuperation AS date_recuperation_9,
  t0.categorie AS categorie_10,
  t0.note AS note_11,
  t0.identifiant AS identifiant_12,
  t0.page_manquent AS page_manquent_13,
  t0.annexe_manquent AS annexe_manquent_14,
  t0.statut AS statut_15,
  t0.part_etat AS part_etat_16,
  t0.dure AS dure_17,
  t0.annee_signature AS annee_signature_18,
  t0.pas_de_porte AS pas_de_porte_19,
  t0.loyer_annuel AS loyer_annuel_20,
  t0.royaltie AS royaltie_21,
  t0.ressources AS ressources_22,
  t0.reserves AS reserves_23,
  t0.id_dw AS id_dw_24,
  t0.is_publish AS is_publish_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.deleted_at AS deleted_at_28,
  t0.type_document_id AS type_document_id_29,
  t0.contrat_principal_id AS contrat_principal_id_30,
  t0.actionnariats_locaux_id AS actionnariats_locaux_id_31,
  t0.user_id AS user_id_32
FROM
  contrat_relatif t0
WHERE
  t0.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.pas_de_porte AS pas_de_porte_19, t0.loyer_annuel AS loyer_annuel_20, t0.royaltie AS royaltie_21, t0.ressources AS ressources_22, t0.reserves AS reserves_23, t0.id_dw AS id_dw_24, t0.is_publish AS is_publish_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.type_document_id AS type_document_id_29, t0.contrat_principal_id AS contrat_principal_id_30, t0.actionnariats_locaux_id AS actionnariats_locaux_id_31, t0.user_id AS user_id_32 FROM contrat_relatif t0 WHERE t0.contrat_principal_id = 3;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.id_dw AS id_dw_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  type_contrat t0
  INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id
WHERE
  contrat_principal_type_contrat.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_contrat t0 INNER JOIN contrat_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id WHERE contrat_principal_type_contrat.contrat_principal_id = 4;

SELECT
  t0.id AS id_1,
  t0.permis AS permis_2,
  t0.titulaire AS titulaire_3,
  t0.type_permis AS type_permis_4,
  t0.status AS status_5,
  t0.date_octroi AS date_octroi_6,
  t0.date_expiration AS date_expiration_7,
  t0.carres AS carres_8,
  t0.localisation AS localisation_9,
  t0.code AS code_10,
  t0.libelle AS libelle_11,
  t0.id_dw AS id_dw_12,
  t0.is_publish AS is_publish_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.province_id AS province_id_17,
  t0.arrete_id AS arrete_id_18,
  t0.projet_id AS projet_id_19,
  t0.user_id AS user_id_20
FROM
  titre_minier t0
  INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id
WHERE
  contrat_principal_titre_minier.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.permis AS permis_2, t0.titulaire AS titulaire_3, t0.type_permis AS type_permis_4, t0.status AS status_5, t0.date_octroi AS date_octroi_6, t0.date_expiration AS date_expiration_7, t0.carres AS carres_8, t0.localisation AS localisation_9, t0.code AS code_10, t0.libelle AS libelle_11, t0.id_dw AS id_dw_12, t0.is_publish AS is_publish_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.province_id AS province_id_17, t0.arrete_id AS arrete_id_18, t0.projet_id AS projet_id_19, t0.user_id AS user_id_20 FROM titre_minier t0 INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id WHERE contrat_principal_titre_minier.contrat_principal_id = 4;