Symfony Profiler

Query Metrics

12 Database Queries

7 Different statements

6.58 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.41 ms
(36.67%)

SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = ? LIMIT 1

Parameters:

[
  "2963574603"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.monday_item_id AS monday_item_id_2,
  t0.monday_item_name AS monday_item_name_3,
  t0.workflow AS workflow_4,
  t0.injection_planning_status AS injection_planning_status_5,
  t0.work_date AS work_date_6,
  t0.personnel_item_id AS personnel_item_id_7,
  t0.monday_user_id AS monday_user_id_8,
  t0.affaire_item_id AS affaire_item_id_9,
  t0.activite_item_id AS activite_item_id_10,
  t0.task_planning_item_id AS task_planning_item_id_11,
  t0.absence_code AS absence_code_12,
  t0.absence_unit AS absence_unit_13,
  t0.worked_hours AS worked_hours_14,
  t0.travel_hours AS travel_hours_15,
  t0.prime_chantier AS prime_chantier_16,
  t0.deplacement_code AS deplacement_code_17,
  t0.is_injected AS is_injected_18,
  t0.injected_at AS injected_at_19,
  t0.last_snapshot AS last_snapshot_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.personnel_matricule AS personnel_matricule_23,
  t0.employee_status AS employee_status_24
FROM
  pointage t0
WHERE
  t0.monday_item_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = '2963574603' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 19)
5	App\Repository\PointageRepository->findOneByMondayItemId (line 98)
6	App\Service\PointagePersistenceService->existsByMondayItemId (line 76)
7	App\Service\PointageLifecycleService->existsByMondayItemId (line 395)
8	App\Service\PointageWebhookRouter->handleBusinessColumnChange (line 163)
9	App\Service\PointageWebhookRouter->handle (line 42)
10	App\Controller\Monday\PointageValidationWebhookController->__invoke (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 7)

1.94 ms
(29.55%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 81)
5	App\Service\PointagePlanningInjectionService->resetInjectionStatusToProcess (line 421)
6	App\Service\PointageWebhookRouter->handleBusinessColumnChange (line 163)
7	App\Service\PointageWebhookRouter->handle (line 42)
8	App\Controller\Monday\PointageValidationWebhookController->__invoke (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

0.55 ms
(8.29%)

UPDATE pointage SET updated_at = ? WHERE id = ?

Parameters:

[
  "2026-06-03 12:54:30"
  93
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  pointage
SET
  updated_at = ?
WHERE
  id = ?

UPDATE pointage SET updated_at = '2026-06-03 12:54:30' WHERE id = 93;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 502)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 386)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1137)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 407)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 81)
7	App\Service\PointagePlanningInjectionService->resetInjectionStatusToProcess (line 421)
8	App\Service\PointageWebhookRouter->handleBusinessColumnChange (line 163)
9	App\Service\PointageWebhookRouter->handle (line 42)
10	App\Controller\Monday\PointageValidationWebhookController->__invoke (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 7)

0.48 ms
(7.27%)

UPDATE pointage SET last_snapshot = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "{"mondayItemId":"2963574603","_dirty":true,"_dirty_reason":"monday_business_column_changed","_dirty_at":"2026-06-03T12:54:30+02:00"}"
  "2026-06-03 12:54:30"
  93
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  pointage
SET
  last_snapshot = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE pointage SET last_snapshot = '{\"mondayItemId\":\"2963574603\",\"_dirty\":true,\"_dirty_reason\":\"monday_business_column_changed\",\"_dirty_at\":\"2026-06-03T12:54:30+02:00\"}', updated_at = '2026-06-03 12:54:30' WHERE id = 93;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 502)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 386)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1137)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 407)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Service\PointagePersistenceService->markDirtyFromMondayItemId (line 87)
8	App\Service\PointageLifecycleService->markDirtyFromMondayItemId (line 426)
9	App\Service\PointageWebhookRouter->handleBusinessColumnChange (line 163)
10	App\Service\PointageWebhookRouter->handle (line 42)
11	App\Controller\Monday\PointageValidationWebhookController->__invoke (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 7)

0.46 ms
(6.95%)

SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.snapshot_type AS snapshot_type_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.payload AS payload_6, t0.source AS source_7, t0.created_at AS created_at_8, t0.personnel_matricule AS personnel_matricule_9, t0.employee_status AS employee_status_10, t0.pointage_id AS pointage_id_11 FROM pointage_snapshot t0 WHERE t0.pointage_id = ? ORDER BY t0.created_at DESC

Parameters:

[
  93
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.monday_item_id AS monday_item_id_2,
  t0.snapshot_type AS snapshot_type_3,
  t0.workflow AS workflow_4,
  t0.injection_planning_status AS injection_planning_status_5,
  t0.payload AS payload_6,
  t0.source AS source_7,
  t0.created_at AS created_at_8,
  t0.personnel_matricule AS personnel_matricule_9,
  t0.employee_status AS employee_status_10,
  t0.pointage_id AS pointage_id_11
FROM
  pointage_snapshot t0
WHERE
  t0.pointage_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.snapshot_type AS snapshot_type_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.payload AS payload_6, t0.source AS source_7, t0.created_at AS created_at_8, t0.personnel_matricule AS personnel_matricule_9, t0.employee_status AS employee_status_10, t0.pointage_id AS pointage_id_11 FROM pointage_snapshot t0 WHERE t0.pointage_id = 93 ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 68)
7	Doctrine\Common\Collections\AbstractLazyCollection->contains (line 361)
8	Doctrine\ORM\PersistentCollection->contains (line 129)
9	App\Entity\Pointage->addSnapshot (line 137)
10	App\Service\PointagePersistenceService->markDirtyFromMondayItemId (line 87)
11	App\Service\PointageLifecycleService->markDirtyFromMondayItemId (line 426)
12	App\Service\PointageWebhookRouter->handleBusinessColumnChange (line 163)
13	App\Service\PointageWebhookRouter->handle (line 42)
14	App\Controller\Monday\PointageValidationWebhookController->__invoke (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 7)

0.40 ms
(6.01%)

INSERT INTO pointage_snapshot (monday_item_id, snapshot_type, workflow, injection_planning_status, payload, source, created_at, personnel_matricule, employee_status, pointage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2963574603"
  "dirty"
  "À valider"
  null
  "{"mondayItemId":"2963574603","_dirty":true,"_dirty_reason":"monday_business_column_changed","_dirty_at":"2026-06-03T12:54:30+02:00"}"
  "monday_business_column_changed"
  "2026-06-03 12:54:30"
  null
  null
  93
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO pointage_snapshot (
  monday_item_id, snapshot_type, workflow,
  injection_planning_status, payload,
  source, created_at, personnel_matricule,
  employee_status, pointage_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO pointage_snapshot (monday_item_id, snapshot_type, workflow, injection_planning_status, payload, source, created_at, personnel_matricule, employee_status, pointage_id) VALUES ('2963574603', 'dirty', 'À valider', NULL, '{\"mondayItemId\":\"2963574603\",\"_dirty\":true,\"_dirty_reason\":\"monday_business_column_changed\",\"_dirty_at\":\"2026-06-03T12:54:30+02:00\"}', 'monday_business_column_changed', '2026-06-03 12:54:30', NULL, NULL, 93);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 261)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1057)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 402)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Service\PointagePersistenceService->markDirtyFromMondayItemId (line 87)
8	App\Service\PointageLifecycleService->markDirtyFromMondayItemId (line 426)
9	App\Service\PointageWebhookRouter->handleBusinessColumnChange (line 163)
10	App\Service\PointageWebhookRouter->handle (line 42)
11	App\Controller\Monday\PointageValidationWebhookController->__invoke (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 7)

0.35 ms
(5.26%)

"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 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 81)
4	App\Service\PointagePlanningInjectionService->resetInjectionStatusToProcess (line 421)
5	App\Service\PointageWebhookRouter->handleBusinessColumnChange (line 163)
6	App\Service\PointageWebhookRouter->handle (line 42)
7	App\Controller\Monday\PointageValidationWebhookController->__invoke (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 7)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\PointageSnapshot	6
App\Entity\Pointage	1

Entities Mapping

Class	Mapping errors
App\Entity\Pointage	No errors.
App\Entity\PointageSnapshot	No errors.

Symfony Profiler

POST https://pciservice.fr/webhook/monday/pointage/inject-planning

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping