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.code AS code_19,
  t0.pas_de_porte AS pas_de_porte_20,
  t0.loyer_annuel AS loyer_annuel_21,
  t0.royaltie AS royaltie_22,
  t0.date_expiration AS date_expiration_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.deleted_at AS deleted_at_26,
  t0.pays_id AS pays_id_27,
  t0.operateur_id AS operateur_id_28,
  t0.type_document_id AS type_document_id_29,
  t0.user_id AS user_id_30
FROM
  contrat_principal t0

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.code AS code_19, t0.pas_de_porte AS pas_de_porte_20, t0.loyer_annuel AS loyer_annuel_21, t0.royaltie AS royaltie_22, t0.date_expiration AS date_expiration_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.pays_id AS pays_id_27, t0.operateur_id AS operateur_id_28, t0.type_document_id AS type_document_id_29, t0.user_id AS user_id_30 FROM contrat_principal t0;

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

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

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
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  commodite c0_

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

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  pays p0_
  INNER JOIN contrat_principal c1_ ON p0_.id = c1_.pays_id
WHERE
  c1_.id IS NOT NULL

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM pays p0_ INNER JOIN contrat_principal c1_ ON p0_.id = c1_.pays_id WHERE c1_.id IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.unite AS unite_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.user_id AS user_id_8
FROM
  filiere t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_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
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_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 categorie t0;

SELECT
  t0.id AS id_1,
  t0.nom_gisement AS nom_gisement_2,
  t0.nom_mine AS nom_mine_3,
  t0.ressource AS ressource_4,
  t0.teneur AS teneur_5,
  t0.metal_contenu AS metal_contenu_6,
  t0.longitude AS longitude_7,
  t0.latitude AS latitude_8,
  t0.annotation AS annotation_9,
  t0.date_debut AS date_debut_10,
  t0.code AS code_11,
  t0.details AS details_12,
  t0.superficie_on AS superficie_on_13,
  t0.superficie_off AS superficie_off_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.deleted_at AS deleted_at_17,
  t0.operateur_id AS operateur_id_18,
  t0.user_id AS user_id_19
FROM
  gisement t0

SELECT t0.id AS id_1, t0.nom_gisement AS nom_gisement_2, t0.nom_mine AS nom_mine_3, t0.ressource AS ressource_4, t0.teneur AS teneur_5, t0.metal_contenu AS metal_contenu_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.annotation AS annotation_9, t0.date_debut AS date_debut_10, t0.code AS code_11, t0.details AS details_12, t0.superficie_on AS superficie_on_13, t0.superficie_off AS superficie_off_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.operateur_id AS operateur_id_18, t0.user_id AS user_id_19 FROM gisement t0;

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.sigle AS sigle_3,
  t0.nature AS nature_4,
  t0.raison_sociale AS raison_sociale_5,
  t0.regime_fiscal AS regime_fiscal_6,
  t0.siege AS siege_7,
  t0.annee_fermeture AS annee_fermeture_8,
  t0.nombre_surccursale AS nombre_surccursale_9,
  t0.code_unique AS code_unique_10,
  t0.rccm AS rccm_11,
  t0.id_nationnal AS id_nationnal_12,
  t0.num_ident_fiscal AS num_ident_fiscal_13,
  t0.num_import_export AS num_import_export_14,
  t0.num_affactation_inss AS num_affactation_inss_15,
  t0.num_affectation_inpp AS num_affectation_inpp_16,
  t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_17,
  t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18,
  t0.capital_social AS capital_social_19,
  t0.num_tva AS num_tva_20,
  t0.num_dgda AS num_dgda_21,
  t0.num_dgi AS num_dgi_22,
  t0.num_dgrad AS num_dgrad_23,
  t0.num_occ AS num_occ_24,
  t0.boite_postal AS boite_postal_25,
  t0.fax AS fax_26,
  t0.telephone AS telephone_27,
  t0.site_web AS site_web_28,
  t0.email AS email_29,
  t0.fichier AS fichier_30,
  t0.nom_original AS nom_original_31,
  t0.description AS description_32,
  t0.anne_creation AS anne_creation_33,
  t0.code_operateur AS code_operateur_34,
  t0.code_indentification AS code_indentification_35,
  t0.date_creation AS date_creation_36,
  t0.service AS service_37,
  t0.profil_oil AS profil_oil_38,
  t0.detail_regime AS detail_regime_39,
  t0.zone AS zone_40,
  t0.date_agrement AS date_agrement_41,
  t0.date_expiration_agrement AS date_expiration_agrement_42,
  t0.sous_categorie AS sous_categorie_43,
  t0.created_at AS created_at_44,
  t0.updated_at AS updated_at_45,
  t0.deleted_at AS deleted_at_46,
  t0.categorie_id AS categorie_id_47,
  t0.forme_juridique_id AS forme_juridique_id_48,
  t0.ville_id AS ville_id_49,
  t0.sous_secteur_id AS sous_secteur_id_50,
  t0.etd_id AS etd_id_51,
  t0.province_id AS province_id_52,
  t0.secteur_id AS secteur_id_53,
  t0.statut_id AS statut_id_54,
  t0.user_id AS user_id_55
FROM
  operateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.nature AS nature_4, t0.raison_sociale AS raison_sociale_5, t0.regime_fiscal AS regime_fiscal_6, t0.siege AS siege_7, t0.annee_fermeture AS annee_fermeture_8, t0.nombre_surccursale AS nombre_surccursale_9, t0.code_unique AS code_unique_10, t0.rccm AS rccm_11, t0.id_nationnal AS id_nationnal_12, t0.num_ident_fiscal AS num_ident_fiscal_13, t0.num_import_export AS num_import_export_14, t0.num_affactation_inss AS num_affactation_inss_15, t0.num_affectation_inpp AS num_affectation_inpp_16, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_17, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18, t0.capital_social AS capital_social_19, t0.num_tva AS num_tva_20, t0.num_dgda AS num_dgda_21, t0.num_dgi AS num_dgi_22, t0.num_dgrad AS num_dgrad_23, t0.num_occ AS num_occ_24, t0.boite_postal AS boite_postal_25, t0.fax AS fax_26, t0.telephone AS telephone_27, t0.site_web AS site_web_28, t0.email AS email_29, t0.fichier AS fichier_30, t0.nom_original AS nom_original_31, t0.description AS description_32, t0.anne_creation AS anne_creation_33, t0.code_operateur AS code_operateur_34, t0.code_indentification AS code_indentification_35, t0.date_creation AS date_creation_36, t0.service AS service_37, t0.profil_oil AS profil_oil_38, t0.detail_regime AS detail_regime_39, t0.zone AS zone_40, t0.date_agrement AS date_agrement_41, t0.date_expiration_agrement AS date_expiration_agrement_42, t0.sous_categorie AS sous_categorie_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.deleted_at AS deleted_at_46, t0.categorie_id AS categorie_id_47, t0.forme_juridique_id AS forme_juridique_id_48, t0.ville_id AS ville_id_49, t0.sous_secteur_id AS sous_secteur_id_50, t0.etd_id AS etd_id_51, t0.province_id AS province_id_52, t0.secteur_id AS secteur_id_53, t0.statut_id AS statut_id_54, t0.user_id AS user_id_55 FROM operateur t0 WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.sigle AS sigle_3,
  t0.nature AS nature_4,
  t0.raison_sociale AS raison_sociale_5,
  t0.regime_fiscal AS regime_fiscal_6,
  t0.siege AS siege_7,
  t0.annee_fermeture AS annee_fermeture_8,
  t0.nombre_surccursale AS nombre_surccursale_9,
  t0.code_unique AS code_unique_10,
  t0.rccm AS rccm_11,
  t0.id_nationnal AS id_nationnal_12,
  t0.num_ident_fiscal AS num_ident_fiscal_13,
  t0.num_import_export AS num_import_export_14,
  t0.num_affactation_inss AS num_affactation_inss_15,
  t0.num_affectation_inpp AS num_affectation_inpp_16,
  t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_17,
  t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18,
  t0.capital_social AS capital_social_19,
  t0.num_tva AS num_tva_20,
  t0.num_dgda AS num_dgda_21,
  t0.num_dgi AS num_dgi_22,
  t0.num_dgrad AS num_dgrad_23,
  t0.num_occ AS num_occ_24,
  t0.boite_postal AS boite_postal_25,
  t0.fax AS fax_26,
  t0.telephone AS telephone_27,
  t0.site_web AS site_web_28,
  t0.email AS email_29,
  t0.fichier AS fichier_30,
  t0.nom_original AS nom_original_31,
  t0.description AS description_32,
  t0.anne_creation AS anne_creation_33,
  t0.code_operateur AS code_operateur_34,
  t0.code_indentification AS code_indentification_35,
  t0.date_creation AS date_creation_36,
  t0.service AS service_37,
  t0.profil_oil AS profil_oil_38,
  t0.detail_regime AS detail_regime_39,
  t0.zone AS zone_40,
  t0.date_agrement AS date_agrement_41,
  t0.date_expiration_agrement AS date_expiration_agrement_42,
  t0.sous_categorie AS sous_categorie_43,
  t0.created_at AS created_at_44,
  t0.updated_at AS updated_at_45,
  t0.deleted_at AS deleted_at_46,
  t0.categorie_id AS categorie_id_47,
  t0.forme_juridique_id AS forme_juridique_id_48,
  t0.ville_id AS ville_id_49,
  t0.sous_secteur_id AS sous_secteur_id_50,
  t0.etd_id AS etd_id_51,
  t0.province_id AS province_id_52,
  t0.secteur_id AS secteur_id_53,
  t0.statut_id AS statut_id_54,
  t0.user_id AS user_id_55
FROM
  operateur t0
  INNER JOIN contrat_principal_operateur ON t0.id = contrat_principal_operateur.operateur_id
WHERE
  contrat_principal_operateur.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.nature AS nature_4, t0.raison_sociale AS raison_sociale_5, t0.regime_fiscal AS regime_fiscal_6, t0.siege AS siege_7, t0.annee_fermeture AS annee_fermeture_8, t0.nombre_surccursale AS nombre_surccursale_9, t0.code_unique AS code_unique_10, t0.rccm AS rccm_11, t0.id_nationnal AS id_nationnal_12, t0.num_ident_fiscal AS num_ident_fiscal_13, t0.num_import_export AS num_import_export_14, t0.num_affactation_inss AS num_affactation_inss_15, t0.num_affectation_inpp AS num_affectation_inpp_16, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_17, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18, t0.capital_social AS capital_social_19, t0.num_tva AS num_tva_20, t0.num_dgda AS num_dgda_21, t0.num_dgi AS num_dgi_22, t0.num_dgrad AS num_dgrad_23, t0.num_occ AS num_occ_24, t0.boite_postal AS boite_postal_25, t0.fax AS fax_26, t0.telephone AS telephone_27, t0.site_web AS site_web_28, t0.email AS email_29, t0.fichier AS fichier_30, t0.nom_original AS nom_original_31, t0.description AS description_32, t0.anne_creation AS anne_creation_33, t0.code_operateur AS code_operateur_34, t0.code_indentification AS code_indentification_35, t0.date_creation AS date_creation_36, t0.service AS service_37, t0.profil_oil AS profil_oil_38, t0.detail_regime AS detail_regime_39, t0.zone AS zone_40, t0.date_agrement AS date_agrement_41, t0.date_expiration_agrement AS date_expiration_agrement_42, t0.sous_categorie AS sous_categorie_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.deleted_at AS deleted_at_46, t0.categorie_id AS categorie_id_47, t0.forme_juridique_id AS forme_juridique_id_48, t0.ville_id AS ville_id_49, t0.sous_secteur_id AS sous_secteur_id_50, t0.etd_id AS etd_id_51, t0.province_id AS province_id_52, t0.secteur_id AS secteur_id_53, t0.statut_id AS statut_id_54, t0.user_id AS user_id_55 FROM operateur t0 INNER JOIN contrat_principal_operateur ON t0.id = contrat_principal_operateur.operateur_id WHERE contrat_principal_operateur.contrat_principal_id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_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
  secteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_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 secteur t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.unite AS unite_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.filiere_id AS filiere_id_10,
  t0.localisation_id AS localisation_id_11,
  t0.user_id AS user_id_12
FROM
  commodite t0
  INNER JOIN contrat_principal_commodite ON t0.id = contrat_principal_commodite.commodite_id
WHERE
  contrat_principal_commodite.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.unite AS unite_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.filiere_id AS filiere_id_10, t0.localisation_id AS localisation_id_11, t0.user_id AS user_id_12 FROM commodite t0 INNER JOIN contrat_principal_commodite ON t0.id = contrat_principal_commodite.commodite_id WHERE contrat_principal_commodite.contrat_principal_id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.user_id AS user_id_6
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.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.user_id AS user_id_6 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.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.operateur_id AS operateur_id_15,
  t0.province_id AS province_id_16,
  t0.arrete_id AS arrete_id_17,
  t0.projet_id AS projet_id_18,
  t0.gisement_id AS gisement_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.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.operateur_id AS operateur_id_15, t0.province_id AS province_id_16, t0.arrete_id AS arrete_id_17, t0.projet_id AS projet_id_18, t0.gisement_id AS gisement_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.identifiant_gouvernement AS identifiant_gouvernement_13,
  t0.page_manquent AS page_manquent_14,
  t0.annexe_manquent AS annexe_manquent_15,
  t0.statut AS statut_16,
  t0.part_etat AS part_etat_17,
  t0.dure AS dure_18,
  t0.annee_signature AS annee_signature_19,
  t0.code AS code_20,
  t0.pas_de_porte AS pas_de_porte_21,
  t0.loyer_annuel AS loyer_annuel_22,
  t0.royaltie AS royaltie_23,
  t0.date_expiration AS date_expiration_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.deleted_at AS deleted_at_27,
  t0.contrat_principal_id AS contrat_principal_id_28,
  t0.pays_id AS pays_id_29,
  t0.type_document_id AS type_document_id_30,
  t0.user_id AS user_id_31
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.identifiant_gouvernement AS identifiant_gouvernement_13, t0.page_manquent AS page_manquent_14, t0.annexe_manquent AS annexe_manquent_15, t0.statut AS statut_16, t0.part_etat AS part_etat_17, t0.dure AS dure_18, t0.annee_signature AS annee_signature_19, t0.code AS code_20, t0.pas_de_porte AS pas_de_porte_21, t0.loyer_annuel AS loyer_annuel_22, t0.royaltie AS royaltie_23, t0.date_expiration AS date_expiration_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.deleted_at AS deleted_at_27, t0.contrat_principal_id AS contrat_principal_id_28, t0.pays_id AS pays_id_29, t0.type_document_id AS type_document_id_30, t0.user_id AS user_id_31 FROM contrat_relatif t0 WHERE t0.contrat_principal_id = 1;