Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

104.46 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

38.52 ms
(36.87%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 901)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 300)
3	App\Dashboard\CaisseDashboardBalanceBuilder->aggregateByCaisseAndMode (line 70)
4	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
5	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
6	App\Dashboard\DashboardWidgetProvider->build (line 36)
7	App\Controller\HomeController->widget (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

26.07 ms
(24.95%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 901)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 389)
3	App\Dashboard\CaisseDashboardBalanceBuilder->compteTypes (line 141)
4	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
5	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
6	App\Dashboard\DashboardWidgetProvider->build (line 36)
7	App\Controller\HomeController->widget (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

19.22 ms
(18.40%)

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)

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 901)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 352)
3	App\Dashboard\CaisseDashboardBalanceBuilder->aggregateByCompte (line 74)
4	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
5	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
6	App\Dashboard\DashboardWidgetProvider->build (line 36)
7	App\Controller\HomeController->widget (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

11.89 ms
(11.38%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 901)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 300)
3	App\Dashboard\CaisseDashboardBalanceBuilder->aggregateByCaisseAndMode (line 69)
4	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
5	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
6	App\Dashboard\DashboardWidgetProvider->build (line 36)
7	App\Controller\HomeController->widget (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

7.04 ms
(6.74%)

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)

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 901)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 352)
3	App\Dashboard\CaisseDashboardBalanceBuilder->aggregateByCompte (line 73)
4	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
5	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
6	App\Dashboard\DashboardWidgetProvider->build (line 36)
7	App\Controller\HomeController->widget (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.60 ms
(0.57%)

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

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 189)
4	App\Dashboard\CaisseDashboardBalanceBuilder->accessibleCaisses (line 38)
5	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
6	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
7	App\Dashboard\DashboardWidgetProvider->build (line 36)
8	App\Controller\HomeController->widget (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.40 ms
(0.38%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Caisse::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Caisse->__get (line 85)
8	App\Entity\Caisse->getIdcaisse (line 123)
9	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
10	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
11	App\Dashboard\DashboardWidgetProvider->build (line 36)
12	App\Controller\HomeController->widget (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.39 ms
(0.37%)

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

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.35 ms
(0.33%)

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

Parameters:

[
  "Caisse"
  "Mobile Money"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 901)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 227)
3	App\Dashboard\CaisseDashboardBalanceBuilder->modes (line 53)
4	App\Dashboard\CaisseDashboardBalanceBuilder->build (line 106)
5	App\Dashboard\DashboardWidgetProvider->caisse (line 61)
6	App\Dashboard\DashboardWidgetProvider->build (line 36)
7	App\Controller\HomeController->widget (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\ContractGroup	No errors.
App\Entity\Documentation	No errors.
App\Entity\Offre	No errors.
App\Entity\Caisse	No errors.
App\Entity\ListeCaissier	The association App\Entity\ListeCaissier#UserId refers to the inverse side field App\Entity\User#listeCaissiers which does not exist.
App\Entity\CaisseCompte	No errors.

Symfony Profiler

GET https://app.master-immo.net/accueil/widget/caisse

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping