POST https://tidy.alfredocruz.cl/webhook/salesforce/caso-deuda

Query Metrics

11 Database Queries
7 Different statements
33.69 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time Count Info
22.31 ms
(66.21%)
3
"COMMIT"
Parameters:
[]
5.51 ms
(16.35%)
1
UPDATE background_job SET status = ?, result_summary = ?, finished_at = ? WHERE id = ?
Parameters:
[
  "completed"
  "{"durationSeconds":0.004,"counts":{"casosDeudasActualizados":1},"warnings":[],"errors":[],"extra":[]}"
  "2026-06-22 17:17:14"
  118400
]
2.34 ms
(6.95%)
1
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
Parameters:
[
  "019ef131-d029-7d89-829a-b21fc3a58cce"
]
1.24 ms
(3.68%)
3
"START TRANSACTION"
Parameters:
[]
0.90 ms
(2.68%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "019ef131-d029-7d89-829a-b21fc3a58cce"
  "sync_sf_caso_webhook"
  "pending"
  "Webhook SF Caso — a0MNx000002ZcqrMAC"
  0
  null
  "{"salesforceId":"a0MNx000002ZcqrMAC"}"
  null
  null
  null
  null
  null
  "{"salesforceId":"a0MNx000002ZcqrMAC","useSandbox":null}"
  0
  "2026-06-22 17:17:14"
  null
  null
  null
  null
  null
  null
  null
  null
  null
]
0.72 ms
(2.13%)
1
UPDATE background_job SET status = ?, started_at = ? WHERE id = ?
Parameters:
[
  "running"
  "2026-06-22 17:17:14"
  118400
]
0.67 ms
(1.99%)
1
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
Parameters:
[
  "a0MNx000002ZcqrMAC"
]

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\BackgroundJob 1

Entities Mapping

Class Mapping errors
App\Entity\BackgroundJob No errors.
App\Entity\User No errors.
App\Entity\CasoDeuda No errors.
App\Entity\Empresa No errors.
App\Entity\Trabajador No errors.