Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.97 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.17 ms

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 427)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 52)
4	App\Messenger\Handler\InformationFinanciereHandler->__invoke (line 152)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 212)
15	App\Controller\Obligation\InformationFinanciereController->addData (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.64 ms

INSERT INTO information_financiere (volume, chiffre_affaire, date_info, dotation, retrocession, numero_bordereau_dgi, id_dw, is_publish, created_at, updated_at, deleted_at, operateur_id, repartition_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "0"
  "1951646131"
  "2024-01-31 00:00:00"
  null
  "331779842.27"
  null
  202
  null
  "2025-12-31 15:18:42"
  null
  null
  null
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO information_financiere (
  volume, chiffre_affaire, date_info,
  dotation, retrocession, numero_bordereau_dgi,
  id_dw, is_publish, created_at, updated_at,
  deleted_at, operateur_id, repartition_id,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO information_financiere (volume, chiffre_affaire, date_info, dotation, retrocession, numero_bordereau_dgi, id_dw, is_publish, created_at, updated_at, deleted_at, operateur_id, repartition_id, user_id) VALUES ('0', '1951646131', '2024-01-31 00:00:00', NULL, '331779842.27', NULL, 202, NULL, '2025-12-31 15:18:42', NULL, NULL, NULL, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 280)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1182)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 446)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 52)
7	App\Messenger\Handler\InformationFinanciereHandler->__invoke (line 152)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
11	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
12	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
13	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
14	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
15	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
16	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
17	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 212)
18	App\Controller\Obligation\InformationFinanciereController->addData (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.16 ms

"ROLLBACK"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"ROLLBACK"

"ROLLBACK";

#	File/Call
1	Doctrine\DBAL\Connection->rollBack (line 484)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 52)
4	App\Messenger\Handler\InformationFinanciereHandler->__invoke (line 152)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 37)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 40)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 212)
15	App\Controller\Obligation\InformationFinanciereController->addData (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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\Obligation\InformationFinanciere	The field App\Entity\Obligation\InformationFinanciere#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Obligation\InformationFinanciere#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Operateur	The association App\Entity\Operateur\Operateur#commodites refers to the inverse side field App\Entity\Transparence\Commodite#operateurs which does not exist. The association App\Entity\Operateur\Operateur#province refers to the inverse side field App\Entity\Transparence\Province#operateurs which does not exist. The field App\Entity\Operateur\Operateur#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Operateur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Obligation\RepartitionDotation	The field App\Entity\Obligation\RepartitionDotation#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Obligation\RepartitionDotation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\User	The field App\Entity\User#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\User#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

POST https://dot.cd/obligation/information/financiere/add/data

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping