Symfony Profiler

[
  "route" => "webhook_monday_pointage_inject_planning"
  "route_parameters" => [
    "_route" => "webhook_monday_pointage_inject_planning"
    "_controller" => "App\Controller\Monday\PointageValidationWebhookController"
  ]
  "request_uri" => "https://pciservice.fr/webhook/monday/pointage/inject-planning"
  "method" => "POST"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\PointageEntrySubmitGuardSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerY9bv6YS\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "route" => "webhook_monday_pointage_inject_planning"
  "raw" => "{"event":{"app":"monday","type":"update_column_value","triggerTime":"2026-06-03T10:54:29.882Z","subscriptionId":111469992,"isRetry":true,"userId":70786235,"originalTriggerUuid":null,"boardId":5092742922,"groupId":"group_mknhd2s8","pulseId":2963574603,"pulseName":"2026-04-30 - Adeline MATHON - BE AUT ATELIER — Test Adeline","columnId":"dropdown_mm1t9gnw","columnType":"dropdown","columnTitle":"Prime Chaniter","value":{"chosenValues":[{"id":41,"name":"10"}]},"previousValue":null,"changedAt":1780484004.9968164,"isTopGroup":true,"triggerUuid":"eb9f67bd4152de14c5695a5847b6a8a5"}}"
  "payload" => [
    "event" => [
      "app" => "monday"
      "type" => "update_column_value"
      "triggerTime" => "2026-06-03T10:54:29.882Z"
      "subscriptionId" => 111469992
      "isRetry" => true
      "userId" => 70786235
      "originalTriggerUuid" => null
      "boardId" => 5092742922
      "groupId" => "group_mknhd2s8"
      "pulseId" => 2963574603
      "pulseName" => "2026-04-30 - Adeline MATHON - BE AUT ATELIER — Test Adeline"
      "columnId" => "dropdown_mm1t9gnw"
      "columnType" => "dropdown"
      "columnTitle" => "Prime Chaniter"
      "value" => [
        "chosenValues" => [
          [
            "id" => 41
            "name" => "10"
          ]
        ]
      ]
      "previousValue" => null
      "changedAt" => 1780484004.9968
      "isTopGroup" => true
      "triggerUuid" => "eb9f67bd4152de14c5695a5847b6a8a5"
    ]
  ]
]

[
  "itemId" => "2963574603"
  "columnId" => "dropdown_mm1t9gnw"
  "userId" => 70786235
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "mysqlUser"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "pci_service"
    "serverVersion" => "11.6.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2963574603"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2963574603"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "keys" => [
    "query"
    "variables"
  ]
  "hasVars" => true
  "vars_keys" => [
    "boardId"
    "itemId"
    "columnId"
    "value"
  ]
]

[
  "has_data" => true
  "data_keys" => [
    "change_simple_column_value"
  ]
]

[
  "pointageItemId" => "2963574603"
  "label" => "A traiter"
  "result" => [
    "data" => [
      "change_simple_column_value" => [
        "id" => "2963574603"
      ]
    ]
    "extensions" => [
      "request_id" => "dab16736-e921-9f0f-845d-983eb9cc5acd"
    ]
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2963574603"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "UPDATE pointage SET updated_at = ? WHERE id = ?"
  "params" => [
    1 => "2026-06-03 12:54:30"
    2 => 93
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "pointageItemId" => "2963574603"
  "reason" => "monday_business_column_changed"
  "mondayStatusReset" => true
  "bddReset" => true
]

[
  "sql" => "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"
  "params" => [
    1 => "2963574603"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 93
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO pointage_snapshot (monday_item_id, snapshot_type, workflow, injection_planning_status, payload, source, created_at, personnel_matricule, employee_status, pointage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "2963574603"
    2 => "dirty"
    3 => "À valider"
    4 => null
    5 => "{"mondayItemId":"2963574603","_dirty":true,"_dirty_reason":"monday_business_column_changed","_dirty_at":"2026-06-03T12:54:30+02:00"}"
    6 => "monday_business_column_changed"
    7 => "2026-06-03 12:54:30"
    8 => null
    9 => null
    10 => 93
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 1
  ]
]

[
  "sql" => "UPDATE pointage SET last_snapshot = ?, updated_at = ? WHERE id = ?"
  "params" => [
    1 => "{"mondayItemId":"2963574603","_dirty":true,"_dirty_reason":"monday_business_column_changed","_dirty_at":"2026-06-03T12:54:30+02:00"}"
    2 => "2026-06-03 12:54:30"
    3 => 93
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "keys" => [
    "query"
    "variables"
  ]
  "hasVars" => true
  "vars_keys" => [
    "itemId"
    "boardId"
    "value"
  ]
]

[
  "has_data" => true
  "data_keys" => [
    "change_column_value"
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Mercure\EventSubscriber\SetCookieSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]