Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 128
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• 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 = ?

[
  2
]

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 = 2;

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.dateex AS dateex_3, t0.role AS role_4, t0.id_caisse_id AS id_caisse_id_5, t0.user_id_id AS user_id_id_6 FROM liste_caissier t0 WHERE t0.user_id_id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.expiration AS expiration_2,
  t0.dateex AS dateex_3,
  t0.role AS role_4,
  t0.id_caisse_id AS id_caisse_id_5,
  t0.user_id_id AS user_id_id_6
FROM
  liste_caissier t0
WHERE
  t0.user_id_id = ?

SELECT t0.id AS id_1, t0.expiration AS expiration_2, t0.dateex AS dateex_3, t0.role AS role_4, t0.id_caisse_id AS id_caisse_id_5, t0.user_id_id AS user_id_id_6 FROM liste_caissier t0 WHERE t0.user_id_id = 2;

SELECT id, nomc, TypeCaisse AS typecaisse
             FROM caisse_type
             WHERE enabled = 1 AND TypeCaisse IN (?, ?)
             ORDER BY nomc ASC

[
  "Caisse"
  "Mobile Money"
]

SELECT
  id,
  nomc,
  TypeCaisse AS typecaisse
FROM
  caisse_type
WHERE
  enabled = 1
  AND TypeCaisse IN (?, ?)
ORDER BY
  nomc ASC

SELECT id, nomc, TypeCaisse AS typecaisse
             FROM caisse_type
             WHERE enabled = 1 AND TypeCaisse IN ('Caisse', 'Mobile Money')
             ORDER BY nomc ASC;

SELECT idcaisse AS caisse_id, modeP AS mode_id,
    COALESCE(SUM(CASE WHEN dateEn < ? THEN Encaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN dateEn = ? THEN Encaissement ELSE 0 END), 0) AS jour
FROM encaissement
WHERE enabled = 1 AND staten = 1 AND idcaisse IN (?) AND modeP IN (?, ?, ?)
GROUP BY idcaisse, modeP

[
  "2026-10-08"
  "2026-10-08"
  "1"
  "1"
  "4"
  "6"
]

SELECT
  idcaisse AS caisse_id,
  modeP AS mode_id,
  COALESCE(
    SUM(
      CASE WHEN dateEn < ? THEN Encaissement ELSE 0 END
    ),
    0
  ) AS prec,
  COALESCE(
    SUM(
      CASE WHEN dateEn = ? THEN Encaissement ELSE 0 END
    ),
    0
  ) AS jour
FROM
  encaissement
WHERE
  enabled = 1
  AND staten = 1
  AND idcaisse IN (?)
  AND modeP IN (?, ?, ?)
GROUP BY
  idcaisse,
  modeP

SELECT idcaisse AS caisse_id, modeP AS mode_id,
    COALESCE(SUM(CASE WHEN dateEn < '2026-10-08' THEN Encaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN dateEn = '2026-10-08' THEN Encaissement ELSE 0 END), 0) AS jour
FROM encaissement
WHERE enabled = 1 AND staten = 1 AND idcaisse IN ('1') AND modeP IN ('1', '4', '6')
GROUP BY idcaisse, modeP;

SELECT idcaisse AS caisse_id, modep AS mode_id,
    COALESCE(SUM(CASE WHEN datede < ? THEN decaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN datede = ? THEN decaissement ELSE 0 END), 0) AS jour
FROM decaissement
WHERE enabled = 1 AND etatde = 1 AND validat = 'V' AND idcaisse IN (?) AND modep IN (?, ?, ?)
GROUP BY idcaisse, modep

[
  "2026-10-08"
  "2026-10-08"
  "1"
  "1"
  "4"
  "6"
]

SELECT
  idcaisse AS caisse_id,
  modep AS mode_id,
  COALESCE(
    SUM(
      CASE WHEN datede < ? THEN decaissement ELSE 0 END
    ),
    0
  ) AS prec,
  COALESCE(
    SUM(
      CASE WHEN datede = ? THEN decaissement ELSE 0 END
    ),
    0
  ) AS jour
FROM
  decaissement
WHERE
  enabled = 1
  AND etatde = 1
  AND validat = 'V'
  AND idcaisse IN (?)
  AND modep IN (?, ?, ?)
GROUP BY
  idcaisse,
  modep

SELECT idcaisse AS caisse_id, modep AS mode_id,
    COALESCE(SUM(CASE WHEN datede < '2026-10-08' THEN decaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN datede = '2026-10-08' THEN decaissement ELSE 0 END), 0) AS jour
FROM decaissement
WHERE enabled = 1 AND etatde = 1 AND validat = 'V' AND idcaisse IN ('1') AND modep IN ('1', '4', '6')
GROUP BY idcaisse, modep;

SELECT TRIM(compte) AS compte,
    COALESCE(SUM(CASE WHEN dateEn < ? THEN Encaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN dateEn = ? THEN Encaissement ELSE 0 END), 0) AS jour
FROM encaissement
WHERE enabled = 1 AND staten = 1
  AND compte IS NOT NULL AND TRIM(compte) <> ''
GROUP BY TRIM(compte)

[
  "2026-10-08"
  "2026-10-08"
]

SELECT
  TRIM(compte) AS compte,
  COALESCE(
    SUM(
      CASE WHEN dateEn < ? THEN Encaissement ELSE 0 END
    ),
    0
  ) AS prec,
  COALESCE(
    SUM(
      CASE WHEN dateEn = ? THEN Encaissement ELSE 0 END
    ),
    0
  ) AS jour
FROM
  encaissement
WHERE
  enabled = 1
  AND staten = 1
  AND compte IS NOT NULL
  AND TRIM(compte) <> ''
GROUP BY
  TRIM(compte)

SELECT TRIM(compte) AS compte,
    COALESCE(SUM(CASE WHEN dateEn < '2026-10-08' THEN Encaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN dateEn = '2026-10-08' THEN Encaissement ELSE 0 END), 0) AS jour
FROM encaissement
WHERE enabled = 1 AND staten = 1
  AND compte IS NOT NULL AND TRIM(compte) <> ''
GROUP BY TRIM(compte);

SELECT TRIM(compte) AS compte,
    COALESCE(SUM(CASE WHEN datede < ? THEN decaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN datede = ? THEN decaissement ELSE 0 END), 0) AS jour
FROM decaissement
WHERE enabled = 1 AND etatde = 1 AND validat = 'V'
  AND compte IS NOT NULL AND TRIM(compte) <> ''
GROUP BY TRIM(compte)

[
  "2026-10-08"
  "2026-10-08"
]

SELECT
  TRIM(compte) AS compte,
  COALESCE(
    SUM(
      CASE WHEN datede < ? THEN decaissement ELSE 0 END
    ),
    0
  ) AS prec,
  COALESCE(
    SUM(
      CASE WHEN datede = ? THEN decaissement ELSE 0 END
    ),
    0
  ) AS jour
FROM
  decaissement
WHERE
  enabled = 1
  AND etatde = 1
  AND validat = 'V'
  AND compte IS NOT NULL
  AND TRIM(compte) <> ''
GROUP BY
  TRIM(compte)

SELECT TRIM(compte) AS compte,
    COALESCE(SUM(CASE WHEN datede < '2026-10-08' THEN decaissement ELSE 0 END), 0) AS prec,
    COALESCE(SUM(CASE WHEN datede = '2026-10-08' THEN decaissement ELSE 0 END), 0) AS jour
FROM decaissement
WHERE enabled = 1 AND etatde = 1 AND validat = 'V'
  AND compte IS NOT NULL AND TRIM(compte) <> ''
GROUP BY TRIM(compte);

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

[
  1
]

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 = 1;

SELECT TRIM(a.compte) AS compte, ct.TypeCaisse AS typecaisse
FROM encaissement a
INNER JOIN caisse_type ct ON ct.id = a.modeP
WHERE a.enabled = 1 AND a.staten = 1
  AND a.compte IS NOT NULL AND TRIM(a.compte) <> ''
GROUP BY TRIM(a.compte), ct.TypeCaisse
UNION
SELECT TRIM(a.compte) AS compte, ct.TypeCaisse AS typecaisse
FROM decaissement a
INNER JOIN caisse_type ct ON ct.id = a.modep
WHERE a.enabled = 1 AND a.etatde = 1 AND a.validat = 'V'
  AND a.compte IS NOT NULL AND TRIM(a.compte) <> ''
GROUP BY TRIM(a.compte), ct.TypeCaisse

[]

SELECT
  TRIM(a.compte) AS compte,
  ct.TypeCaisse AS typecaisse
FROM
  encaissement a
  INNER JOIN caisse_type ct ON ct.id = a.modeP
WHERE
  a.enabled = 1
  AND a.staten = 1
  AND a.compte IS NOT NULL
  AND TRIM(a.compte) <> ''
GROUP BY
  TRIM(a.compte),
  ct.TypeCaisse
UNION
SELECT
  TRIM(a.compte) AS compte,
  ct.TypeCaisse AS typecaisse
FROM
  decaissement a
  INNER JOIN caisse_type ct ON ct.id = a.modep
WHERE
  a.enabled = 1
  AND a.etatde = 1
  AND a.validat = 'V'
  AND a.compte IS NOT NULL
  AND TRIM(a.compte) <> ''
GROUP BY
  TRIM(a.compte),
  ct.TypeCaisse

SELECT TRIM(a.compte) AS compte, ct.TypeCaisse AS typecaisse
FROM encaissement a
INNER JOIN caisse_type ct ON ct.id = a.modeP
WHERE a.enabled = 1 AND a.staten = 1
  AND a.compte IS NOT NULL AND TRIM(a.compte) <> ''
GROUP BY TRIM(a.compte), ct.TypeCaisse
UNION
SELECT TRIM(a.compte) AS compte, ct.TypeCaisse AS typecaisse
FROM decaissement a
INNER JOIN caisse_type ct ON ct.id = a.modep
WHERE a.enabled = 1 AND a.etatde = 1 AND a.validat = 'V'
  AND a.compte IS NOT NULL AND TRIM(a.compte) <> ''
GROUP BY TRIM(a.compte), ct.TypeCaisse;