Symfony Profiler

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

Query Metrics

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 type_contribution 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
  type_contribution 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 type_contribution t0;

SELECT o0_.id AS id_0, o0_.denomination AS denomination_1, o0_.sigle AS sigle_2, o0_.statut AS statut_3, o0_.nature AS nature_4, o0_.raison_sociale AS raison_sociale_5, o0_.regime_fiscal AS regime_fiscal_6, o0_.siege AS siege_7, o0_.annee_fermeture AS annee_fermeture_8, o0_.nombre_surccursale AS nombre_surccursale_9, o0_.code_unique AS code_unique_10, o0_.rccm AS rccm_11, o0_.id_nationnal AS id_nationnal_12, o0_.num_ident_fiscal AS num_ident_fiscal_13, o0_.num_import_export AS num_import_export_14, o0_.num_affactation_inss AS num_affactation_inss_15, o0_.num_affectation_inpp AS num_affectation_inpp_16, o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_17, o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18, o0_.capital_social AS capital_social_19, o0_.num_tva AS num_tva_20, o0_.num_dgda AS num_dgda_21, o0_.num_dgi AS num_dgi_22, o0_.num_dgrad AS num_dgrad_23, o0_.num_occ AS num_occ_24, o0_.boite_postal AS boite_postal_25, o0_.fax AS fax_26, o0_.telephone AS telephone_27, o0_.site_web AS site_web_28, o0_.email AS email_29, o0_.fichier AS fichier_30, o0_.nom_original AS nom_original_31, o0_.description AS description_32, o0_.anne_creation AS anne_creation_33, o0_.code_operateur AS code_operateur_34, o0_.code_indentification AS code_indentification_35, o0_.date_creation AS date_creation_36, o0_.service AS service_37, o0_.created_at AS created_at_38, o0_.updated_at AS updated_at_39, o0_.deleted_at AS deleted_at_40, o0_.categorie_id AS categorie_id_41, o0_.forme_juridique_id AS forme_juridique_id_42, o0_.ville_id AS ville_id_43, o0_.sous_secteur_id AS sous_secteur_id_44, o0_.etd_id AS etd_id_45, o0_.province_id AS province_id_46, o0_.user_id AS user_id_47 FROM operateur o0_ INNER JOIN contribution c1_ ON o0_.id = c1_.operateur_id

[]

SELECT
  o0_.id AS id_0,
  o0_.denomination AS denomination_1,
  o0_.sigle AS sigle_2,
  o0_.statut AS statut_3,
  o0_.nature AS nature_4,
  o0_.raison_sociale AS raison_sociale_5,
  o0_.regime_fiscal AS regime_fiscal_6,
  o0_.siege AS siege_7,
  o0_.annee_fermeture AS annee_fermeture_8,
  o0_.nombre_surccursale AS nombre_surccursale_9,
  o0_.code_unique AS code_unique_10,
  o0_.rccm AS rccm_11,
  o0_.id_nationnal AS id_nationnal_12,
  o0_.num_ident_fiscal AS num_ident_fiscal_13,
  o0_.num_import_export AS num_import_export_14,
  o0_.num_affactation_inss AS num_affactation_inss_15,
  o0_.num_affectation_inpp AS num_affectation_inpp_16,
  o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_17,
  o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18,
  o0_.capital_social AS capital_social_19,
  o0_.num_tva AS num_tva_20,
  o0_.num_dgda AS num_dgda_21,
  o0_.num_dgi AS num_dgi_22,
  o0_.num_dgrad AS num_dgrad_23,
  o0_.num_occ AS num_occ_24,
  o0_.boite_postal AS boite_postal_25,
  o0_.fax AS fax_26,
  o0_.telephone AS telephone_27,
  o0_.site_web AS site_web_28,
  o0_.email AS email_29,
  o0_.fichier AS fichier_30,
  o0_.nom_original AS nom_original_31,
  o0_.description AS description_32,
  o0_.anne_creation AS anne_creation_33,
  o0_.code_operateur AS code_operateur_34,
  o0_.code_indentification AS code_indentification_35,
  o0_.date_creation AS date_creation_36,
  o0_.service AS service_37,
  o0_.created_at AS created_at_38,
  o0_.updated_at AS updated_at_39,
  o0_.deleted_at AS deleted_at_40,
  o0_.categorie_id AS categorie_id_41,
  o0_.forme_juridique_id AS forme_juridique_id_42,
  o0_.ville_id AS ville_id_43,
  o0_.sous_secteur_id AS sous_secteur_id_44,
  o0_.etd_id AS etd_id_45,
  o0_.province_id AS province_id_46,
  o0_.user_id AS user_id_47
FROM
  operateur o0_
  INNER JOIN contribution c1_ ON o0_.id = c1_.operateur_id

SELECT o0_.id AS id_0, o0_.denomination AS denomination_1, o0_.sigle AS sigle_2, o0_.statut AS statut_3, o0_.nature AS nature_4, o0_.raison_sociale AS raison_sociale_5, o0_.regime_fiscal AS regime_fiscal_6, o0_.siege AS siege_7, o0_.annee_fermeture AS annee_fermeture_8, o0_.nombre_surccursale AS nombre_surccursale_9, o0_.code_unique AS code_unique_10, o0_.rccm AS rccm_11, o0_.id_nationnal AS id_nationnal_12, o0_.num_ident_fiscal AS num_ident_fiscal_13, o0_.num_import_export AS num_import_export_14, o0_.num_affactation_inss AS num_affactation_inss_15, o0_.num_affectation_inpp AS num_affectation_inpp_16, o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_17, o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18, o0_.capital_social AS capital_social_19, o0_.num_tva AS num_tva_20, o0_.num_dgda AS num_dgda_21, o0_.num_dgi AS num_dgi_22, o0_.num_dgrad AS num_dgrad_23, o0_.num_occ AS num_occ_24, o0_.boite_postal AS boite_postal_25, o0_.fax AS fax_26, o0_.telephone AS telephone_27, o0_.site_web AS site_web_28, o0_.email AS email_29, o0_.fichier AS fichier_30, o0_.nom_original AS nom_original_31, o0_.description AS description_32, o0_.anne_creation AS anne_creation_33, o0_.code_operateur AS code_operateur_34, o0_.code_indentification AS code_indentification_35, o0_.date_creation AS date_creation_36, o0_.service AS service_37, o0_.created_at AS created_at_38, o0_.updated_at AS updated_at_39, o0_.deleted_at AS deleted_at_40, o0_.categorie_id AS categorie_id_41, o0_.forme_juridique_id AS forme_juridique_id_42, o0_.ville_id AS ville_id_43, o0_.sous_secteur_id AS sous_secteur_id_44, o0_.etd_id AS etd_id_45, o0_.province_id AS province_id_46, o0_.user_id AS user_id_47 FROM operateur o0_ INNER JOIN contribution c1_ ON o0_.id = c1_.operateur_id;

SELECT SUM(c0_.montant) AS sclr_0, SUBSTRING(c0_.date_contribution FROM 6 FOR 2) AS sclr_1 FROM contribution c0_ WHERE c0_.date_contribution BETWEEN ? AND ? GROUP BY sclr_1 ORDER BY sclr_1 ASC

[
  "2024-01-01 00:00:00"
  "2024-12-31 23:59:00"
]

SELECT
  SUM(c0_.montant) AS sclr_0,
  SUBSTRING(
    c0_.date_contribution
    FROM
      6 FOR 2
  ) AS sclr_1
FROM
  contribution c0_
WHERE
  c0_.date_contribution BETWEEN ?
  AND ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(c0_.montant) AS sclr_0, SUBSTRING(c0_.date_contribution FROM 6 FOR 2) AS sclr_1 FROM contribution c0_ WHERE c0_.date_contribution BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:00' GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT SUM(c0_.montant) AS sclr_0, SUBSTRING(c0_.date_contribution FROM 1 FOR 4) AS sclr_1 FROM contribution c0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC

[]

SELECT
  SUM(c0_.montant) AS sclr_0,
  SUBSTRING(
    c0_.date_contribution
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  contribution c0_
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(c0_.montant) AS sclr_0, SUBSTRING(c0_.date_contribution FROM 1 FOR 4) AS sclr_1 FROM contribution c0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC;

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;