Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

34.49 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

30.57 ms
(88.61%)

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 (?, ?)

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 268)
2	App\Repository\DecaissementRepository->myNowDecaissement (line 92)
3	App\Controller\DecaissementController->decaissement (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

2.65 ms
(7.68%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 52)
4	App\Controller\DecaissementController->decaissement (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.38 ms
(1.10%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 54)
5	App\Controller\DecaissementController->decaissement (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.37 ms
(1.06%)

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:

[
  39
]

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

#	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.31 ms
(0.89%)

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 (?, ?)

Parameters:

[
  1
  "D"
  "ED"
]

View formatted query View runnable query Explain query View query backtrace

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 44)
4	App\Controller\DecaissementController->decaissement (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.23 ms
(0.66%)

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:

[
  "3"
]

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

#	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 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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.
App\Entity\CaisseType	No errors.
App\Entity\Terrain	The association App\Entity\Terrain#fournisseur refers to the inverse side field App\Entity\Fournisseur#terrains which does not exist.
App\Entity\Fournisseur	No errors.
App\Entity\Image	No errors.
App\Entity\ImageTerrain	No errors.
App\Entity\TerrainTag	No errors.
App\Entity\PropositionOffre	No errors.
App\Entity\SourceTerrain	No errors.
App\Entity\Contract	The field 'App\Entity\Contract#amount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Promesse	The field App\Entity\Promesse#negociations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Negociation#compromis does not contain the required 'inversedBy="negociations"' attribute.
App\Entity\Reservation	No errors.
App\Entity\Decaissement	No errors.
App\Entity\Terrassement	No errors.
App\Entity\Mutation	No errors.
App\Entity\ProcedureMutation	No errors.
App\Entity\DossierClientGroupe	No errors.

Symfony Profiler

GET https://app.master-immo.net/decaissement/liste/3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping