Symfony Profiler

[
  "route" => "webhook_salesforce_caso_deuda"
  "route_parameters" => [
    "_route" => "webhook_salesforce_caso_deuda"
    "_controller" => "App\Controller\Webhook\SalesforceWebhookController::handleCasoDeudaChange"
  ]
  "request_uri" => "https://tidy.alfredocruz.cl/webhook/salesforce/caso-deuda"
  "method" => "POST"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelRequest"
]

[
  "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" => "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" => "App\EventListener\MustChangePasswordListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\CompanyContextListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\DeactivatedUserListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\SingleSessionListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\CompanyFilterListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Intensos\TimeOutVault\Symfony\EventListener\TimeOutVaultSessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Event\TwoFactorFormListener::onKernelRequest"
]

[
  "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\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "salesforceId" => "a0MNx000002ZcqrMAC"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "acruz-mariadb.cyzcgouedqgr.us-west-2.rds.amazonaws.com"
    "port" => 3306
    "user" => "tidy_dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "tidy_dev"
    "serverVersion" => "mariadb-10.11.13"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "INSERT INTO background_job (uuid, type, status, title, progress_current, progress_total, metadata, result_summary, error_message, error_class, error_trace, error_context, message_payload, retry_count, dispatched_at, started_at, finished_at, dismissed_at, cancelled_at, related_entity_type, related_entity_id, user_id, retry_of_job_id, cancelled_by_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "019ef131-d029-7d89-829a-b21fc3a58cce"
    2 => "sync_sf_caso_webhook"
    3 => "pending"
    4 => "Webhook SF Caso — a0MNx000002ZcqrMAC"
    5 => 0
    6 => null
    7 => "{"salesforceId":"a0MNx000002ZcqrMAC"}"
    8 => null
    9 => null
    10 => null
    11 => null
    12 => null
    13 => "{"salesforceId":"a0MNx000002ZcqrMAC","useSandbox":null}"
    14 => 0
    15 => "2026-06-22 17:17:14"
    16 => null
    17 => null
    18 => null
    19 => null
    20 => null
    21 => null
    22 => null
    23 => null
    24 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#946}
    3 => Doctrine\DBAL\ParameterType {#946}
    4 => Doctrine\DBAL\ParameterType {#946}
    5 => Doctrine\DBAL\ParameterType {#944
      +name: "INTEGER"
    }
    6 => Doctrine\DBAL\ParameterType {#944}
    7 => Doctrine\DBAL\ParameterType {#946}
    8 => Doctrine\DBAL\ParameterType {#946}
    9 => Doctrine\DBAL\ParameterType {#946}
    10 => Doctrine\DBAL\ParameterType {#946}
    11 => Doctrine\DBAL\ParameterType {#946}
    12 => Doctrine\DBAL\ParameterType {#946}
    13 => Doctrine\DBAL\ParameterType {#946}
    14 => Doctrine\DBAL\ParameterType {#944}
    15 => Doctrine\DBAL\ParameterType {#946}
    16 => Doctrine\DBAL\ParameterType {#946}
    17 => Doctrine\DBAL\ParameterType {#946}
    18 => Doctrine\DBAL\ParameterType {#946}
    19 => Doctrine\DBAL\ParameterType {#946}
    20 => Doctrine\DBAL\ParameterType {#946}
    21 => Doctrine\DBAL\ParameterType {#944}
    22 => Doctrine\DBAL\ParameterType {#944}
    23 => Doctrine\DBAL\ParameterType {#944}
    24 => Doctrine\DBAL\ParameterType {#944}
  ]
]

[
  "job_uuid" => "019ef131-d029-7d89-829a-b21fc3a58cce"
  "job_type" => "sync_sf_caso_webhook"
  "user_id" => null
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.type AS type_3, t0.status AS status_4, t0.title AS title_5, t0.progress_current AS progress_current_6, t0.progress_total AS progress_total_7, t0.metadata AS metadata_8, t0.result_summary AS result_summary_9, t0.error_message AS error_message_10, t0.error_class AS error_class_11, t0.error_trace AS error_trace_12, t0.error_context AS error_context_13, t0.message_payload AS message_payload_14, t0.retry_count AS retry_count_15, t0.dispatched_at AS dispatched_at_16, t0.started_at AS started_at_17, t0.finished_at AS finished_at_18, t0.dismissed_at AS dismissed_at_19, t0.cancelled_at AS cancelled_at_20, t0.related_entity_type AS related_entity_type_21, t0.related_entity_id AS related_entity_id_22, t0.user_id AS user_id_23, t0.retry_of_job_id AS retry_of_job_id_24, t0.cancelled_by_user_id AS cancelled_by_user_id_25 FROM background_job t0 WHERE t0.uuid = ? LIMIT 1"
  "params" => [
    1 => "019ef131-d029-7d89-829a-b21fc3a58cce"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "STRING"
    }
  ]
]

[
  "sql" => "UPDATE background_job SET status = ?, started_at = ? WHERE id = ?"
  "params" => [
    1 => "running"
    2 => "2026-06-22 17:17:14"
    3 => 118400
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#946}
    3 => Doctrine\DBAL\ParameterType {#944
      +name: "INTEGER"
    }
  ]
]

[
  "salesforceId" => "a0MNx000002ZcqrMAC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.salesforce_id AS salesforce_id_3, t0.nombre AS nombre_4, t0.rut_trabajador AS rut_trabajador_5, t0.entidad AS entidad_6, t0.tipo_prevision AS tipo_prevision_7, t0.estado_final AS estado_final_8, t0.estado_caso AS estado_caso_9, t0.condicion_caso AS condicion_caso_10, t0.causa AS causa_11, t0.monto_total_deuda AS monto_total_deuda_12, t0.monto_total_ahorrado AS monto_total_ahorrado_13, t0.numero_registros AS numero_registros_14, t0.dias_abierto AS dias_abierto_15, t0.dias_cierre AS dias_cierre_16, t0.fecha_cierre AS fecha_cierre_17, t0.fecha_asignacion_analista AS fecha_asignacion_analista_18, t0.fecha_asignacion_gestor AS fecha_asignacion_gestor_19, t0.plazo_solucion AS plazo_solucion_20, t0.observaciones AS observaciones_21, t0.resumen_analisis AS resumen_analisis_22, t0.observaciones_pago AS observaciones_pago_23, t0.tipo_pago AS tipo_pago_24, t0.prorroga AS prorroga_25, t0.observacion_prorroga AS observacion_prorroga_26, t0.estudio_juridico AS estudio_juridico_27, t0.numero_comprobante AS numero_comprobante_28, t0.empresa_nombre AS empresa_nombre_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.sf_created_at AS sf_created_at_32, t0.last_sync_at AS last_sync_at_33, t0.empresa_id AS empresa_id_34, t0.trabajador_id AS trabajador_id_35 FROM caso_deuda t0 WHERE t0.salesforce_id = ? LIMIT 1"
  "params" => [
    1 => "a0MNx000002ZcqrMAC"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "STRING"
    }
  ]
]

[
  "salesforceId" => "a0MNx000002ZcqrMAC"
]

[
  "salesforceId" => "a0MNx000002ZcqrMAC"
]

[
  "sql" => "UPDATE background_job SET status = ?, result_summary = ?, finished_at = ? WHERE id = ?"
  "params" => [
    1 => "completed"
    2 => "{"durationSeconds":0.004,"counts":{"casosDeudasActualizados":1},"warnings":[],"errors":[],"extra":[]}"
    3 => "2026-06-22 17:17:14"
    4 => 118400
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#946
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#946}
    3 => Doctrine\DBAL\ParameterType {#946}
    4 => Doctrine\DBAL\ParameterType {#944
      +name: "INTEGER"
    }
  ]
]

[
  "job_uuid" => "019ef131-d029-7d89-829a-b21fc3a58cce"
  "job_type" => "sync_sf_caso_webhook"
  "user_id" => null
  "duration_seconds" => 0.0
]

[
  "class" => "App\Message\SyncSalesforceCasoMessage"
  "handler" => "App\MessageHandler\SyncSalesforceCasoHandler::__invoke"
]

[
  "event" => "kernel.response"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Provider\TwoFactorProviderPreparationListener::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" => "Nelmio\SecurityBundle\EventListener\ContentTypeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ReferrerPolicyListener::onKernelResponse"
]

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Trusted\TrustedCookieResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ClickjackingListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\NoIndexListener::__invoke"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\PermissionsPolicyListener::__invoke"
]

[
  "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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]