Symfony Profiler

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

Query Metrics

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 = ?

[
  "14"
]

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 = '14';

SELECT SUM(p0_.montant) AS sclr_0, SUBSTRING(p0_.date_paiement FROM 6 FOR 2) AS sclr_1 FROM paiement p0_ WHERE (p0_.date_paiement BETWEEN ? AND ?) AND p0_.operateur_id = ? GROUP BY sclr_1 ORDER BY sclr_1 ASC

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

SELECT
  SUM(p0_.montant) AS sclr_0,
  SUBSTRING(
    p0_.date_paiement
    FROM
      6 FOR 2
  ) AS sclr_1
FROM
  paiement p0_
WHERE
  (
    p0_.date_paiement BETWEEN ?
    AND ?
  )
  AND p0_.operateur_id = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(p0_.montant) AS sclr_0, SUBSTRING(p0_.date_paiement FROM 6 FOR 2) AS sclr_1 FROM paiement p0_ WHERE (p0_.date_paiement BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:00') AND p0_.operateur_id = 14 GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT SUM(p0_.montant) AS sclr_0, SUBSTRING(p0_.date_paiement FROM 1 FOR 4) AS sclr_1 FROM paiement p0_ WHERE p0_.operateur_id = ? GROUP BY sclr_1 ORDER BY sclr_1 ASC

[
  14
]

SELECT
  SUM(p0_.montant) AS sclr_0,
  SUBSTRING(
    p0_.date_paiement
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  paiement p0_
WHERE
  p0_.operateur_id = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(p0_.montant) AS sclr_0, SUBSTRING(p0_.date_paiement FROM 1 FOR 4) AS sclr_1 FROM paiement p0_ WHERE p0_.operateur_id = 14 GROUP BY sclr_1 ORDER BY sclr_1 ASC;