Query Metrics
11
Database Queries
8
Different statements
14.33 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.63 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.rut AS rut_3, t0.razon_social AS razon_social_4, t0.activa AS activa_5, t0.medipass_key AS medipass_key_6, t0.imed_key AS imed_key_7, t0.salesforce_id AS salesforce_id_8, t0.exists_in_salesforce AS exists_in_salesforce_9, t0.origen AS origen_10, t0.frecuencia_sync AS frecuencia_sync_11, t0.last_sync_at AS last_sync_at_12, t0.last_sf_sync_at AS last_sf_sync_at_13, t0.salesforce_parent_id AS salesforce_parent_id_14, t0.is_holding AS is_holding_15, t0.codigo_actividad AS codigo_actividad_16, t0.direccion_tramitacion AS direccion_tramitacion_17, t0.comuna_tramitacion AS comuna_tramitacion_18, t0.ciudad_tramitacion AS ciudad_tramitacion_19, t0.pais_tramitacion AS pais_tramitacion_20, t0.telefono_empresa AS telefono_empresa_21, t0.numero_empleados AS numero_empleados_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.parent_empresa_id AS parent_empresa_id_25, t0.cliente_id AS cliente_id_26, t0.logo_id AS logo_id_27 FROM empresa t0 WHERE t0.salesforce_id = ? LIMIT 1
Parameters:
[
"0011J00001gpUrRQAU"
]
|
| 2 | 0.85 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.salesforce_id AS salesforce_id_3, t0.folio AS folio_4, t0.resolucion AS resolucion_5, t0.tipo_licencia AS tipo_licencia_6, t0.fecha_inicio AS fecha_inicio_7, t0.fecha_termino AS fecha_termino_8, t0.dias_autorizados AS dias_autorizados_9, t0.nombre_medico AS nombre_medico_10, t0.rut_medico AS rut_medico_11, t0.institucion_salud AS institucion_salud_12, t0.causa_rechazo AS causa_rechazo_13, t0.last_sync_at AS last_sync_at_14, t0.formato_licencia AS formato_licencia_15, t0.codigo_operador AS codigo_operador_16, t0.fecha_tramitacion AS fecha_tramitacion_17, t0.fecha_emision AS fecha_emision_18, t0.tipo_reposo AS tipo_reposo_19, t0.estado AS estado_20, t0.pronunciamiento_texto AS pronunciamiento_texto_21, t0.pronunciamiento_fecha AS pronunciamiento_fecha_22, t0.fecha_ultima_actualizacion_externa AS fecha_ultima_actualizacion_externa_23, t0.datos_zona_c AS datos_zona_c_24, t0.datos_borrador AS datos_borrador_25, t0.estado_recupero AS estado_recupero_26, t0.entidad_pronuncia AS entidad_pronuncia_27, t0.fecha_resolucion AS fecha_resolucion_28, t0.numero_resolucion AS numero_resolucion_29, t0.derecho_subsidio AS derecho_subsidio_30, t0.observacion_rechazo AS observacion_rechazo_31, t0.direccion_reposo AS direccion_reposo_32, t0.lugar_reposo AS lugar_reposo_33, t0.comuna_reposo AS comuna_reposo_34, t0.nombre_jefatura AS nombre_jefatura_35, t0.email_jefatura AS email_jefatura_36, t0.email_trabajador AS email_trabajador_37, t0.sindicato AS sindicato_38, t0.grupo_sindicato AS grupo_sindicato_39, t0.cencos AS cencos_40, t0.id_interno_trabajador AS id_interno_trabajador_41, t0.division AS division_42, t0.rol_trabajador AS rol_trabajador_43, t0.especialidad_medico AS especialidad_medico_44, t0.direccion_medico AS direccion_medico_45, t0.comuna_medico AS comuna_medico_46, t0.telefono_lm AS telefono_lm_47, t0.lm_continua AS lm_continua_48, t0.suma_dias_pagados AS suma_dias_pagados_49, t0.suma_montos_pagados AS suma_montos_pagados_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.empresa_id AS empresa_id_53, t0.trabajador_id AS trabajador_id_54, t0.pdf_archivo_id AS pdf_archivo_id_55 FROM licencia t0 WHERE t0.salesforce_id = ? LIMIT 1
Parameters:
[
"a10Nx00002bKNYSIA4"
]
|
| 3 | 0.94 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 AS rut_5, t0.email AS email_6, t0.telefono AS telefono_7, t0.direccion AS direccion_8, t0.cargo AS cargo_9, t0.area AS area_10, t0.fecha_contratacion AS fecha_contratacion_11, t0.tipo_contrato AS tipo_contrato_12, t0.afp AS afp_13, t0.salud AS salud_14, t0.finiquitado AS finiquitado_15, t0.fecha_finiquito AS fecha_finiquito_16, t0.last_sync_at AS last_sync_at_17, t0.ocupacion AS ocupacion_18, t0.region AS region_19, t0.comuna AS comuna_20, t0.direccion_laboral AS direccion_laboral_21, t0.regimen_previsional AS regimen_previsional_22, t0.entidad_previsional AS entidad_previsional_23, t0.afc_afiliado AS afc_afiliado_24, t0.email_personal AS email_personal_25, t0.fecha_nacimiento AS fecha_nacimiento_26, t0.sexo AS sexo_27, t0.estado_civil AS estado_civil_28, t0.id_interno_empresa AS id_interno_empresa_29, t0.id_cargo AS id_cargo_30, t0.turno AS turno_31, t0.rol AS rol_32, t0.division_trabajador AS division_trabajador_33, t0.sub_division AS sub_division_34, t0.gerencia AS gerencia_35, t0.sindicato AS sindicato_36, t0.grupo_sindicato AS grupo_sindicato_37, t0.cencos AS cencos_38, t0.id_jefatura AS id_jefatura_39, t0.rut_jefatura AS rut_jefatura_40, t0.nombre_jefatura AS nombre_jefatura_41, t0.cargo_jefatura AS cargo_jefatura_42, t0.email_jefatura AS email_jefatura_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.empresa_id AS empresa_id_46 FROM trabajador t0 WHERE t0.salesforce_id = ? LIMIT 1
Parameters:
[
"a12Nx00000155rw"
]
|
| 4 | 0.52 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 AS rut_5, t0.email AS email_6, t0.telefono AS telefono_7, t0.direccion AS direccion_8, t0.cargo AS cargo_9, t0.area AS area_10, t0.fecha_contratacion AS fecha_contratacion_11, t0.tipo_contrato AS tipo_contrato_12, t0.afp AS afp_13, t0.salud AS salud_14, t0.finiquitado AS finiquitado_15, t0.fecha_finiquito AS fecha_finiquito_16, t0.last_sync_at AS last_sync_at_17, t0.ocupacion AS ocupacion_18, t0.region AS region_19, t0.comuna AS comuna_20, t0.direccion_laboral AS direccion_laboral_21, t0.regimen_previsional AS regimen_previsional_22, t0.entidad_previsional AS entidad_previsional_23, t0.afc_afiliado AS afc_afiliado_24, t0.email_personal AS email_personal_25, t0.fecha_nacimiento AS fecha_nacimiento_26, t0.sexo AS sexo_27, t0.estado_civil AS estado_civil_28, t0.id_interno_empresa AS id_interno_empresa_29, t0.id_cargo AS id_cargo_30, t0.turno AS turno_31, t0.rol AS rol_32, t0.division_trabajador AS division_trabajador_33, t0.sub_division AS sub_division_34, t0.gerencia AS gerencia_35, t0.sindicato AS sindicato_36, t0.grupo_sindicato AS grupo_sindicato_37, t0.cencos AS cencos_38, t0.id_jefatura AS id_jefatura_39, t0.rut_jefatura AS rut_jefatura_40, t0.nombre_jefatura AS nombre_jefatura_41, t0.cargo_jefatura AS cargo_jefatura_42, t0.email_jefatura AS email_jefatura_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.empresa_id AS empresa_id_46 FROM trabajador t0 WHERE t0.rut = ? AND t0.empresa_id = ? LIMIT 1
Parameters:
[ "17774946-k" 160 ] |
| 5 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
| 6 | 0.49 ms |
UPDATE licencia SET fecha_inicio = ?, fecha_termino = ?, last_sync_at = ?, fecha_tramitacion = ?, fecha_emision = ?, fecha_resolucion = ?, suma_dias_pagados = ?, suma_montos_pagados = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-06-22" "2026-07-02" "2026-06-22 14:08:15" "2026-06-22" "2026-06-22" "1969-12-31" "0" "0" "2026-06-22 14:08:15" 44958 ] |
| 7 | 3.73 ms |
"COMMIT"
Parameters:
[] |
| 8 | 1.65 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.salesforce_id AS salesforce_id_3, t0.folio AS folio_4, t0.resolucion AS resolucion_5, t0.tipo_licencia AS tipo_licencia_6, t0.fecha_inicio AS fecha_inicio_7, t0.fecha_termino AS fecha_termino_8, t0.dias_autorizados AS dias_autorizados_9, t0.nombre_medico AS nombre_medico_10, t0.rut_medico AS rut_medico_11, t0.institucion_salud AS institucion_salud_12, t0.causa_rechazo AS causa_rechazo_13, t0.last_sync_at AS last_sync_at_14, t0.formato_licencia AS formato_licencia_15, t0.codigo_operador AS codigo_operador_16, t0.fecha_tramitacion AS fecha_tramitacion_17, t0.fecha_emision AS fecha_emision_18, t0.tipo_reposo AS tipo_reposo_19, t0.estado AS estado_20, t0.pronunciamiento_texto AS pronunciamiento_texto_21, t0.pronunciamiento_fecha AS pronunciamiento_fecha_22, t0.fecha_ultima_actualizacion_externa AS fecha_ultima_actualizacion_externa_23, t0.datos_zona_c AS datos_zona_c_24, t0.datos_borrador AS datos_borrador_25, t0.estado_recupero AS estado_recupero_26, t0.entidad_pronuncia AS entidad_pronuncia_27, t0.fecha_resolucion AS fecha_resolucion_28, t0.numero_resolucion AS numero_resolucion_29, t0.derecho_subsidio AS derecho_subsidio_30, t0.observacion_rechazo AS observacion_rechazo_31, t0.direccion_reposo AS direccion_reposo_32, t0.lugar_reposo AS lugar_reposo_33, t0.comuna_reposo AS comuna_reposo_34, t0.nombre_jefatura AS nombre_jefatura_35, t0.email_jefatura AS email_jefatura_36, t0.email_trabajador AS email_trabajador_37, t0.sindicato AS sindicato_38, t0.grupo_sindicato AS grupo_sindicato_39, t0.cencos AS cencos_40, t0.id_interno_trabajador AS id_interno_trabajador_41, t0.division AS division_42, t0.rol_trabajador AS rol_trabajador_43, t0.especialidad_medico AS especialidad_medico_44, t0.direccion_medico AS direccion_medico_45, t0.comuna_medico AS comuna_medico_46, t0.telefono_lm AS telefono_lm_47, t0.lm_continua AS lm_continua_48, t0.suma_dias_pagados AS suma_dias_pagados_49, t0.suma_montos_pagados AS suma_montos_pagados_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.empresa_id AS empresa_id_53, t0.trabajador_id AS trabajador_id_54, t0.pdf_archivo_id AS pdf_archivo_id_55 FROM licencia t0 WHERE t0.salesforce_id = ? LIMIT 1
Parameters:
[
"a10Nx00002bKNYSIA4"
]
|
| 9 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 0.47 ms |
INSERT INTO licencia_log (tipo, formato, codigo_operador, origen, request_data, response_data, xml_generado, estado, error_message, created_at, licencia_id, empresa_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "sf_webhook" null null "salesforce" null "{"duration_seconds":1.127,"salesforceId":"a10Nx00002bKNYSIA4","created":0,"updated":1,"skipped":0,"linked":0,"errors":0}" null "ok" null "2026-06-22 14:08:15" 44958 160 null ] |
| 11 | 4.52 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\Empresa | 2 |
| App\Entity\Licencia | 1 |
| App\Entity\Trabajador | 1 |
| App\Entity\LicenciaLog | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Empresa | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\Archivo | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Licencia | No errors. |
| App\Entity\Trabajador | No errors. |
| App\Entity\LicenciaTramitacionArchivo | No errors. |
| App\Entity\Recupero | No errors. |
| App\Entity\LicenciaLog | No errors. |