Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 27
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 22
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Blocks 0
• Configuration

Query Metrics

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_.code AS code_18, c0_.pas_de_porte AS pas_de_porte_19, c0_.loyer_annuel AS loyer_annuel_20, c0_.royaltie AS royaltie_21, c0_.date_expiration AS date_expiration_22, c0_.created_at AS created_at_23, c0_.updated_at AS updated_at_24, c0_.deleted_at AS deleted_at_25, c0_.pays_id AS pays_id_26, c0_.operateur_id AS operateur_id_27, c0_.type_document_id AS type_document_id_28, c0_.user_id AS user_id_29 FROM contrat_principal c0_ ORDER BY c0_.date_signature DESC

[]

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_.code AS code_18,
  c0_.pas_de_porte AS pas_de_porte_19,
  c0_.loyer_annuel AS loyer_annuel_20,
  c0_.royaltie AS royaltie_21,
  c0_.date_expiration AS date_expiration_22,
  c0_.created_at AS created_at_23,
  c0_.updated_at AS updated_at_24,
  c0_.deleted_at AS deleted_at_25,
  c0_.pays_id AS pays_id_26,
  c0_.operateur_id AS operateur_id_27,
  c0_.type_document_id AS type_document_id_28,
  c0_.user_id AS user_id_29
FROM
  contrat_principal c0_
ORDER BY
  c0_.date_signature DESC

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_.code AS code_18, c0_.pas_de_porte AS pas_de_porte_19, c0_.loyer_annuel AS loyer_annuel_20, c0_.royaltie AS royaltie_21, c0_.date_expiration AS date_expiration_22, c0_.created_at AS created_at_23, c0_.updated_at AS updated_at_24, c0_.deleted_at AS deleted_at_25, c0_.pays_id AS pays_id_26, c0_.operateur_id AS operateur_id_27, c0_.type_document_id AS type_document_id_28, c0_.user_id AS user_id_29 FROM contrat_principal c0_ ORDER BY c0_.date_signature DESC;

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_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 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 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 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.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 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.province_id AS province_id_19, t0.user_id AS user_id_20 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.province_id AS province_id_19,
  t0.user_id AS user_id_20
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.province_id AS province_id_19, t0.user_id AS user_id_20 FROM gisement t0;