Symfony Profiler

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

Query Metrics

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_.part_etat AS part_etat_38, o0_.devise AS devise_39, o0_.logo AS logo_40, o0_.token AS token_41, o0_.domaine AS domaine_42, o0_.id_dw AS id_dw_43, o0_.created_at AS created_at_44, o0_.updated_at AS updated_at_45, o0_.deleted_at AS deleted_at_46, o0_.categorie_id AS categorie_id_47, o0_.forme_juridique_id AS forme_juridique_id_48, o0_.ville_id AS ville_id_49, o0_.sous_secteur_id AS sous_secteur_id_50, o0_.etd_id AS etd_id_51, o0_.province_id AS province_id_52, o0_.user_id AS user_id_53 FROM operateur o0_ INNER JOIN redevance r1_ ON o0_.id = r1_.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_.part_etat AS part_etat_38,
  o0_.devise AS devise_39,
  o0_.logo AS logo_40,
  o0_.token AS token_41,
  o0_.domaine AS domaine_42,
  o0_.id_dw AS id_dw_43,
  o0_.created_at AS created_at_44,
  o0_.updated_at AS updated_at_45,
  o0_.deleted_at AS deleted_at_46,
  o0_.categorie_id AS categorie_id_47,
  o0_.forme_juridique_id AS forme_juridique_id_48,
  o0_.ville_id AS ville_id_49,
  o0_.sous_secteur_id AS sous_secteur_id_50,
  o0_.etd_id AS etd_id_51,
  o0_.province_id AS province_id_52,
  o0_.user_id AS user_id_53
FROM
  operateur o0_
  INNER JOIN redevance r1_ ON o0_.id = r1_.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_.part_etat AS part_etat_38, o0_.devise AS devise_39, o0_.logo AS logo_40, o0_.token AS token_41, o0_.domaine AS domaine_42, o0_.id_dw AS id_dw_43, o0_.created_at AS created_at_44, o0_.updated_at AS updated_at_45, o0_.deleted_at AS deleted_at_46, o0_.categorie_id AS categorie_id_47, o0_.forme_juridique_id AS forme_juridique_id_48, o0_.ville_id AS ville_id_49, o0_.sous_secteur_id AS sous_secteur_id_50, o0_.etd_id AS etd_id_51, o0_.province_id AS province_id_52, o0_.user_id AS user_id_53 FROM operateur o0_ INNER JOIN redevance r1_ ON o0_.id = r1_.operateur_id;

SELECT SUM(r0_.montant) AS sclr_0, SUBSTRING(r0_.date_redevance FROM 6 FOR 2) AS sclr_1 FROM redevance r0_ WHERE r0_.date_redevance BETWEEN ? AND ? GROUP BY sclr_1 ORDER BY sclr_1 ASC

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

SELECT
  SUM(r0_.montant) AS sclr_0,
  SUBSTRING(
    r0_.date_redevance
    FROM
      6 FOR 2
  ) AS sclr_1
FROM
  redevance r0_
WHERE
  r0_.date_redevance BETWEEN ?
  AND ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

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

SELECT SUM(r0_.montant) AS sclr_0, SUBSTRING(r0_.date_redevance FROM 1 FOR 4) AS sclr_1 FROM redevance r0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC

[]

SELECT
  SUM(r0_.montant) AS sclr_0,
  SUBSTRING(
    r0_.date_redevance
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  redevance r0_
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(r0_.montant) AS sclr_0, SUBSTRING(r0_.date_redevance FROM 1 FOR 4) AS sclr_1 FROM redevance r0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC;