Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 128
• Events
• Routing
• Cache
• Translation 90
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 4
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

[
  39
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 39;

SELECT t0.id AS id_1, t0.idcaissier AS idcaissier_2, t0.idcaisse AS idcaisse_3, t0.type AS type_4, t0.enabled AS enabled_5 FROM caisse t0 WHERE t0.id = ?

[
  "3"
]

SELECT
  t0.id AS id_1,
  t0.idcaissier AS idcaissier_2,
  t0.idcaisse AS idcaisse_3,
  t0.type AS type_4,
  t0.enabled AS enabled_5
FROM
  caisse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.idcaissier AS idcaissier_2, t0.idcaisse AS idcaisse_3, t0.type AS type_4, t0.enabled AS enabled_5 FROM caisse t0 WHERE t0.id = '3';

SELECT t0.id AS id_1, t0.idcaisse AS idcaisse_2, t0.Solde AS Solde_3, t0.dateMod AS dateMod_4, t0.TypeCaisse AS TypeCaisse_5, t0.modeCaisse AS modeCaisse_6, t0.nomc AS nomc_7, t0.enabled AS enabled_8 FROM caisse_type t0 WHERE t0.enabled = ? AND t0.modeCaisse IN (?, ?)

[
  1
  "D"
  "ED"
]

SELECT
  t0.id AS id_1,
  t0.idcaisse AS idcaisse_2,
  t0.Solde AS Solde_3,
  t0.dateMod AS dateMod_4,
  t0.TypeCaisse AS TypeCaisse_5,
  t0.modeCaisse AS modeCaisse_6,
  t0.nomc AS nomc_7,
  t0.enabled AS enabled_8
FROM
  caisse_type t0
WHERE
  t0.enabled = ?
  AND t0.modeCaisse IN (?, ?)

SELECT t0.id AS id_1, t0.idcaisse AS idcaisse_2, t0.Solde AS Solde_3, t0.dateMod AS dateMod_4, t0.TypeCaisse AS TypeCaisse_5, t0.modeCaisse AS modeCaisse_6, t0.nomc AS nomc_7, t0.enabled AS enabled_8 FROM caisse_type t0 WHERE t0.enabled = 1 AND t0.modeCaisse IN ('D', 'ED');

SELECT t0.id AS id_1, t0.Denprojet AS Denprojet_2, t0.restap AS restap_3, t0.idanal AS idanal_4, t0.codeprojet AS codeprojet_5, t0.sitjuridique AS sitjuridique_6, t0.Numtitrs AS Numtitrs_7, t0.Numregistre AS Numregistre_8, t0.Numfolio AS Numfolio_9, t0.sisea AS sisea_10, t0.fokotany AS fokotany_11, t0.Commune AS Commune_12, t0.District AS District_13, t0.Region AS Region_14, t0.Nompropriete AS Nompropriete_15, t0.contenance AS contenance_16, t0.proprietaire AS proprietaire_17, t0.Signataire AS Signataire_18, t0.PersonaPPV AS PersonaPPV_19, t0.PAterrain AS PAterrain_20, t0.contrat AS contrat_21, t0.categorie AS categorie_22, t0.refarch AS refarch_23, t0.coordong AS coordong_24, t0.aventage AS aventage_25, t0.inconv AS inconv_26, t0.contenance_av AS contenance_av_27, t0.piecejoint AS piecejoint_28, t0.suivie AS suivie_29, t0.description AS description_30, t0.coordinates AS coordinates_31, t0.date AS date_32, t0.axe AS axe_33, t0.type AS type_34, t0.min AS min_35, t0.max AS max_36, t0.supmin AS supmin_37, t0.supmax AS supmax_38, t0.noted AS noted_39, t0.budget AS budget_40, t0.budgets AS budgets_41, t0.public_visibility AS public_visibility_42, t0.nextcloud_path AS nextcloud_path_43, t0.nextcloud_share_url AS nextcloud_share_url_44, t0.fournisseur_id AS fournisseur_id_45, t0.logo_id AS logo_id_46, t0.image_principal_id AS image_principal_id_47 FROM terrain t0 WHERE t0.contrat = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.Denprojet AS Denprojet_2,
  t0.restap AS restap_3,
  t0.idanal AS idanal_4,
  t0.codeprojet AS codeprojet_5,
  t0.sitjuridique AS sitjuridique_6,
  t0.Numtitrs AS Numtitrs_7,
  t0.Numregistre AS Numregistre_8,
  t0.Numfolio AS Numfolio_9,
  t0.sisea AS sisea_10,
  t0.fokotany AS fokotany_11,
  t0.Commune AS Commune_12,
  t0.District AS District_13,
  t0.Region AS Region_14,
  t0.Nompropriete AS Nompropriete_15,
  t0.contenance AS contenance_16,
  t0.proprietaire AS proprietaire_17,
  t0.Signataire AS Signataire_18,
  t0.PersonaPPV AS PersonaPPV_19,
  t0.PAterrain AS PAterrain_20,
  t0.contrat AS contrat_21,
  t0.categorie AS categorie_22,
  t0.refarch AS refarch_23,
  t0.coordong AS coordong_24,
  t0.aventage AS aventage_25,
  t0.inconv AS inconv_26,
  t0.contenance_av AS contenance_av_27,
  t0.piecejoint AS piecejoint_28,
  t0.suivie AS suivie_29,
  t0.description AS description_30,
  t0.coordinates AS coordinates_31,
  t0.date AS date_32,
  t0.axe AS axe_33,
  t0.type AS type_34,
  t0.min AS min_35,
  t0.max AS max_36,
  t0.supmin AS supmin_37,
  t0.supmax AS supmax_38,
  t0.noted AS noted_39,
  t0.budget AS budget_40,
  t0.budgets AS budgets_41,
  t0.public_visibility AS public_visibility_42,
  t0.nextcloud_path AS nextcloud_path_43,
  t0.nextcloud_share_url AS nextcloud_share_url_44,
  t0.fournisseur_id AS fournisseur_id_45,
  t0.logo_id AS logo_id_46,
  t0.image_principal_id AS image_principal_id_47
FROM
  terrain t0
WHERE
  t0.contrat = ?

SELECT t0.id AS id_1, t0.Denprojet AS Denprojet_2, t0.restap AS restap_3, t0.idanal AS idanal_4, t0.codeprojet AS codeprojet_5, t0.sitjuridique AS sitjuridique_6, t0.Numtitrs AS Numtitrs_7, t0.Numregistre AS Numregistre_8, t0.Numfolio AS Numfolio_9, t0.sisea AS sisea_10, t0.fokotany AS fokotany_11, t0.Commune AS Commune_12, t0.District AS District_13, t0.Region AS Region_14, t0.Nompropriete AS Nompropriete_15, t0.contenance AS contenance_16, t0.proprietaire AS proprietaire_17, t0.Signataire AS Signataire_18, t0.PersonaPPV AS PersonaPPV_19, t0.PAterrain AS PAterrain_20, t0.contrat AS contrat_21, t0.categorie AS categorie_22, t0.refarch AS refarch_23, t0.coordong AS coordong_24, t0.aventage AS aventage_25, t0.inconv AS inconv_26, t0.contenance_av AS contenance_av_27, t0.piecejoint AS piecejoint_28, t0.suivie AS suivie_29, t0.description AS description_30, t0.coordinates AS coordinates_31, t0.date AS date_32, t0.axe AS axe_33, t0.type AS type_34, t0.min AS min_35, t0.max AS max_36, t0.supmin AS supmin_37, t0.supmax AS supmax_38, t0.noted AS noted_39, t0.budget AS budget_40, t0.budgets AS budgets_41, t0.public_visibility AS public_visibility_42, t0.nextcloud_path AS nextcloud_path_43, t0.nextcloud_share_url AS nextcloud_share_url_44, t0.fournisseur_id AS fournisseur_id_45, t0.logo_id AS logo_id_46, t0.image_principal_id AS image_principal_id_47 FROM terrain t0 WHERE t0.contrat = 1;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.montant AS montant_3, t0.district AS district_4, t0.step AS step_5, t0.dossier_client_groupe_id AS dossier_client_groupe_id_6 FROM procedure_mutation t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.montant AS montant_3,
  t0.district AS district_4,
  t0.step AS step_5,
  t0.dossier_client_groupe_id AS dossier_client_groupe_id_6
FROM
  procedure_mutation t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.montant AS montant_3, t0.district AS district_4, t0.step AS step_5, t0.dossier_client_groupe_id AS dossier_client_groupe_id_6 FROM procedure_mutation t0;

SELECT idutilisateur,imprevu,datede,modep,prevalidate,timede,libelle,decaissement,nomc,can1,can2,typeUt,firstname,lastname,a.id,fac,timedd,reftier
                FROM decaissement a
                LEFT JOIN fos_user b ON a.idUt = b.id 
                LEFT JOIN caisse_type c ON a.modep = c.id 
                WHERE a.enabled = 1 AND a.etatde = 1 AND a.validat = 'V' AND a.idcaisse = ? AND a.datede = ? AND c.TypeCaisse IN (?, ?)

[
  3
  "2026-10-08"
  "Caisse"
  "Mobile Money"
]

SELECT
  idutilisateur,
  imprevu,
  datede,
  modep,
  prevalidate,
  timede,
  libelle,
  decaissement,
  nomc,
  can1,
  can2,
  typeUt,
  firstname,
  lastname,
  a.id,
  fac,
  timedd,
  reftier
FROM
  decaissement a
  LEFT JOIN fos_user b ON a.idUt = b.id
  LEFT JOIN caisse_type c ON a.modep = c.id
WHERE
  a.enabled = 1
  AND a.etatde = 1
  AND a.validat = 'V'
  AND a.idcaisse = ?
  AND a.datede = ?
  AND c.TypeCaisse IN (?, ?)

SELECT idutilisateur,imprevu,datede,modep,prevalidate,timede,libelle,decaissement,nomc,can1,can2,typeUt,firstname,lastname,a.id,fac,timedd,reftier
                FROM decaissement a
                LEFT JOIN fos_user b ON a.idUt = b.id 
                LEFT JOIN caisse_type c ON a.modep = c.id 
                WHERE a.enabled = 1 AND a.etatde = 1 AND a.validat = 'V' AND a.idcaisse = 3 AND a.datede = '2026-10-08' AND c.TypeCaisse IN ('Caisse', 'Mobile Money');