Symfony Profiler

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.royalties AS royalties_21,
  t0.reserves AS reserves_22,
  t0.ressources AS ressources_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.actionnariats_locaux_id AS actionnariats_locaux_id_30,
  t0.user_id AS user_id_31
FROM
  contrat_principal t0
WHERE
  t0.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.royalties AS royalties_21, t0.reserves AS reserves_22, t0.ressources AS ressources_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.actionnariats_locaux_id AS actionnariats_locaux_id_30, t0.user_id AS user_id_31 FROM contrat_principal t0 WHERE t0.id = '4';

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.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_document t0
WHERE
  t0.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_document t0 WHERE t0.id = 6;

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;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.unite AS unite_4,
  t0.symbole_chimique AS symbole_chimique_5,
  t0.max AS max_6,
  t0.maxim AS maxim_7,
  t0.amount AS amount_8,
  t0.min_annuel AS min_annuel_9,
  t0.max_annuel AS max_annuel_10,
  t0.amout_annuel AS amout_annuel_11,
  t0.max_semestre AS max_semestre_12,
  t0.amount_semestre AS amount_semestre_13,
  t0.min_trimestre AS min_trimestre_14,
  t0.max_trimestre AS max_trimestre_15,
  t0.amount_trimestre AS amount_trimestre_16,
  t0.min_semetre AS min_semetre_17,
  t0.id_dw AS id_dw_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.deleted_at AS deleted_at_21,
  t0.user_id AS user_id_22
FROM
  commodite t0
  INNER JOIN commodite_contrat_principal ON t0.id = commodite_contrat_principal.commodite_id
WHERE
  commodite_contrat_principal.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.unite AS unite_4, t0.symbole_chimique AS symbole_chimique_5, t0.max AS max_6, t0.maxim AS maxim_7, t0.amount AS amount_8, t0.min_annuel AS min_annuel_9, t0.max_annuel AS max_annuel_10, t0.amout_annuel AS amout_annuel_11, t0.max_semestre AS max_semestre_12, t0.amount_semestre AS amount_semestre_13, t0.min_trimestre AS min_trimestre_14, t0.max_trimestre AS max_trimestre_15, t0.amount_trimestre AS amount_trimestre_16, t0.min_semetre AS min_semetre_17, t0.id_dw AS id_dw_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.user_id AS user_id_22 FROM commodite t0 INNER JOIN commodite_contrat_principal ON t0.id = commodite_contrat_principal.commodite_id WHERE commodite_contrat_principal.contrat_principal_id = 4;

SELECT
  t0.id AS id_1,
  t0.part_capital AS part_capital_2,
  t0.date_acquisition AS date_acquisition_3,
  t0.type_acquisition AS type_acquisition_4,
  t0.proprietaire AS proprietaire_5,
  t0.id_dw AS id_dw_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.actionnaire_id AS actionnaire_id_10,
  t0.investisseur_id AS investisseur_id_11,
  t0.contrat_principal_id AS contrat_principal_id_12,
  t0.contrat_relatif_id AS contrat_relatif_id_13,
  t0.user_id AS user_id_14
FROM
  part_contrat t0
WHERE
  t0.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.part_capital AS part_capital_2, t0.date_acquisition AS date_acquisition_3, t0.type_acquisition AS type_acquisition_4, t0.proprietaire AS proprietaire_5, t0.id_dw AS id_dw_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.actionnaire_id AS actionnaire_id_10, t0.investisseur_id AS investisseur_id_11, t0.contrat_principal_id AS contrat_principal_id_12, t0.contrat_relatif_id AS contrat_relatif_id_13, t0.user_id AS user_id_14 FROM part_contrat t0 WHERE t0.contrat_principal_id = 4;

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

SELECT
  t0.id AS id_1,
  t0.action AS action_2,
  t0.date_acquisition AS date_acquisition_3,
  t0.id_dw AS id_dw_4,
  t0.is_publish AS is_publish_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.actionnaire_id AS actionnaire_id_9,
  t0.contrat_relatif_id AS contrat_relatif_id_10,
  t0.contrat_principal_id AS contrat_principal_id_11,
  t0.user_id AS user_id_12
FROM
  actionnariat_local t0
WHERE
  t0.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.action AS action_2, t0.date_acquisition AS date_acquisition_3, t0.id_dw AS id_dw_4, t0.is_publish AS is_publish_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.actionnaire_id AS actionnaire_id_9, t0.contrat_relatif_id AS contrat_relatif_id_10, t0.contrat_principal_id AS contrat_principal_id_11, t0.user_id AS user_id_12 FROM actionnariat_local t0 WHERE t0.contrat_principal_id = 4;