Symfony Profiler

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
  service_etat t0

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

SELECT
  o0_.id AS id_0,
  o0_.denomination AS denomination_1,
  o0_.sigle AS sigle_2,
  o0_.nature AS nature_3,
  o0_.raison_sociale AS raison_sociale_4,
  o0_.regime_fiscal AS regime_fiscal_5,
  o0_.siege AS siege_6,
  o0_.annee_fermeture AS annee_fermeture_7,
  o0_.nombre_surccursale AS nombre_surccursale_8,
  o0_.code_unique AS code_unique_9,
  o0_.rccm AS rccm_10,
  o0_.id_nationnal AS id_nationnal_11,
  o0_.num_ident_fiscal AS num_ident_fiscal_12,
  o0_.num_import_export AS num_import_export_13,
  o0_.num_affactation_inss AS num_affactation_inss_14,
  o0_.num_affectation_inpp AS num_affectation_inpp_15,
  o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_16,
  o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_17,
  o0_.capital_social AS capital_social_18,
  o0_.num_tva AS num_tva_19,
  o0_.num_dgda AS num_dgda_20,
  o0_.num_dgi AS num_dgi_21,
  o0_.num_dgrad AS num_dgrad_22,
  o0_.num_occ AS num_occ_23,
  o0_.boite_postal AS boite_postal_24,
  o0_.fax AS fax_25,
  o0_.telephone AS telephone_26,
  o0_.site_web AS site_web_27,
  o0_.email AS email_28,
  o0_.fichier AS fichier_29,
  o0_.nom_original AS nom_original_30,
  o0_.description AS description_31,
  o0_.anne_creation AS anne_creation_32,
  o0_.code_operateur AS code_operateur_33,
  o0_.code_indentification AS code_indentification_34,
  o0_.date_creation AS date_creation_35,
  o0_.service AS service_36,
  o0_.profil_oil AS profil_oil_37,
  o0_.detail_regime AS detail_regime_38,
  o0_.zone AS zone_39,
  o0_.date_agrement AS date_agrement_40,
  o0_.date_expiration_agrement AS date_expiration_agrement_41,
  o0_.sous_categorie AS sous_categorie_42,
  o0_.created_at AS created_at_43,
  o0_.updated_at AS updated_at_44,
  o0_.deleted_at AS deleted_at_45,
  o0_.categorie_id AS categorie_id_46,
  o0_.forme_juridique_id AS forme_juridique_id_47,
  o0_.ville_id AS ville_id_48,
  o0_.sous_secteur_id AS sous_secteur_id_49,
  o0_.etd_id AS etd_id_50,
  o0_.province_id AS province_id_51,
  o0_.secteur_id AS secteur_id_52,
  o0_.statut_id AS statut_id_53,
  o0_.user_id AS user_id_54
FROM
  operateur o0_
  INNER JOIN paiement p1_ ON o0_.id = p1_.operateur_id
WHERE
  p1_.type_paiement = ?

SELECT o0_.id AS id_0, o0_.denomination AS denomination_1, o0_.sigle AS sigle_2, o0_.nature AS nature_3, o0_.raison_sociale AS raison_sociale_4, o0_.regime_fiscal AS regime_fiscal_5, o0_.siege AS siege_6, o0_.annee_fermeture AS annee_fermeture_7, o0_.nombre_surccursale AS nombre_surccursale_8, o0_.code_unique AS code_unique_9, o0_.rccm AS rccm_10, o0_.id_nationnal AS id_nationnal_11, o0_.num_ident_fiscal AS num_ident_fiscal_12, o0_.num_import_export AS num_import_export_13, o0_.num_affactation_inss AS num_affactation_inss_14, o0_.num_affectation_inpp AS num_affectation_inpp_15, o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_16, o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_17, o0_.capital_social AS capital_social_18, o0_.num_tva AS num_tva_19, o0_.num_dgda AS num_dgda_20, o0_.num_dgi AS num_dgi_21, o0_.num_dgrad AS num_dgrad_22, o0_.num_occ AS num_occ_23, o0_.boite_postal AS boite_postal_24, o0_.fax AS fax_25, o0_.telephone AS telephone_26, o0_.site_web AS site_web_27, o0_.email AS email_28, o0_.fichier AS fichier_29, o0_.nom_original AS nom_original_30, o0_.description AS description_31, o0_.anne_creation AS anne_creation_32, o0_.code_operateur AS code_operateur_33, o0_.code_indentification AS code_indentification_34, o0_.date_creation AS date_creation_35, o0_.service AS service_36, o0_.profil_oil AS profil_oil_37, o0_.detail_regime AS detail_regime_38, o0_.zone AS zone_39, o0_.date_agrement AS date_agrement_40, o0_.date_expiration_agrement AS date_expiration_agrement_41, o0_.sous_categorie AS sous_categorie_42, o0_.created_at AS created_at_43, o0_.updated_at AS updated_at_44, o0_.deleted_at AS deleted_at_45, o0_.categorie_id AS categorie_id_46, o0_.forme_juridique_id AS forme_juridique_id_47, o0_.ville_id AS ville_id_48, o0_.sous_secteur_id AS sous_secteur_id_49, o0_.etd_id AS etd_id_50, o0_.province_id AS province_id_51, o0_.secteur_id AS secteur_id_52, o0_.statut_id AS statut_id_53, o0_.user_id AS user_id_54 FROM operateur o0_ INNER JOIN paiement p1_ ON o0_.id = p1_.operateur_id WHERE p1_.type_paiement = 'Droit';

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_.type_paiement = ?
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_.type_paiement = 'Droit' 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_.type_paiement = ?
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_.type_paiement = 'Droit' 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.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;