Query Metrics
11
Database Queries
7
Different statements
33.69 ms
Query time
0
Invalid entities
1
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 ms |
"START TRANSACTION"
Parameters:
[] |
| 2 | 0.90 ms |
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 ] |
| 3 | 5.07 ms |
"COMMIT"
Parameters:
[] |
| 4 | 2.34 ms |
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"
]
|
| 5 | 0.31 ms |
"START TRANSACTION"
Parameters:
[] |
| 6 | 0.72 ms |
UPDATE background_job SET status = ?, started_at = ? WHERE id = ?
Parameters:
[ "running" "2026-06-22 17:17:14" 118400 ] |
| 7 | 8.58 ms |
"COMMIT"
Parameters:
[] |
| 8 | 0.67 ms |
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"
]
|
| 9 | 0.27 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 5.51 ms |
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 ] |
| 11 | 8.66 ms |
"COMMIT"
Parameters:
[] |
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. |