Symfony Profiler

"COMMIT"

"COMMIT";

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

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 = 'a10Nx00002bKNYSIA4' LIMIT 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 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

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 = '17774946-k' AND t0.empresa_id = 160 LIMIT 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 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

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 = 'a12Nx00000155rw' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

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 = '0011J00001gpUrRQAU' LIMIT 1;

INSERT INTO licencia (
  uuid, salesforce_id, folio, resolucion,
  tipo_licencia, fecha_inicio, fecha_termino,
  dias_autorizados, nombre_medico,
  rut_medico, institucion_salud, causa_rechazo,
  last_sync_at, formato_licencia,
  codigo_operador, fecha_tramitacion,
  fecha_emision, tipo_reposo, estado,
  pronunciamiento_texto, pronunciamiento_fecha,
  fecha_ultima_actualizacion_externa,
  datos_zona_c, datos_borrador, estado_recupero,
  entidad_pronuncia, fecha_resolucion,
  numero_resolucion, derecho_subsidio,
  observacion_rechazo, direccion_reposo,
  lugar_reposo, comuna_reposo, nombre_jefatura,
  email_jefatura, email_trabajador,
  sindicato, grupo_sindicato, cencos,
  id_interno_trabajador, division,
  rol_trabajador, especialidad_medico,
  direccion_medico, comuna_medico,
  telefono_lm, lm_continua, suma_dias_pagados,
  suma_montos_pagados, created_at,
  updated_at, empresa_id, trabajador_id,
  pdf_archivo_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO licencia (uuid, salesforce_id, folio, resolucion, tipo_licencia, fecha_inicio, fecha_termino, dias_autorizados, nombre_medico, rut_medico, institucion_salud, causa_rechazo, last_sync_at, formato_licencia, codigo_operador, fecha_tramitacion, fecha_emision, tipo_reposo, estado, pronunciamiento_texto, pronunciamiento_fecha, fecha_ultima_actualizacion_externa, datos_zona_c, datos_borrador, estado_recupero, entidad_pronuncia, fecha_resolucion, numero_resolucion, derecho_subsidio, observacion_rechazo, direccion_reposo, lugar_reposo, comuna_reposo, nombre_jefatura, email_jefatura, email_trabajador, sindicato, grupo_sindicato, cencos, id_interno_trabajador, division, rol_trabajador, especialidad_medico, direccion_medico, comuna_medico, telefono_lm, lm_continua, suma_dias_pagados, suma_montos_pagados, created_at, updated_at, empresa_id, trabajador_id, pdf_archivo_id) VALUES ('019ef084-a3aa-7571-8f08-f999e91fd800', 'a10Nx00002bKNYSIA4', '129261451-5', '0', '1', '2026-06-22', '2026-07-02', 0, 'Douglas Alfredo Mantilla Roman', '25393504-9', NULL, '0', '2026-06-22 14:08:05', 'Electrónica', NULL, NULL, '2026-06-22', '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, 'FONASA', '1969-12-31', NULL, NULL, NULL, 'Rejalga 1708 Los Minerales', '1', '03101', 'Mercado Macaya, Roberto Alejandro', NULL, NULL, 'MV – Sindicato N°2', NULL, 'BMCL0045470210', '6126304', 'Carguío y Transporte MV', NULL, 'MEDICINA GENERAL', 'Calle Toro 1665, 0', '13125', '56 09 769004', '0', '0', '0', '2026-06-22 14:08:05', '2026-06-22 14:08:05', 160, 14763, NULL);

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
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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 ('sf_webhook', NULL, NULL, 'salesforce', NULL, '{\"duration_seconds\":1.133,\"salesforceId\":\"a10Nx00002bKNYSIA4\",\"created\":1,\"updated\":0,\"skipped\":0,\"linked\":1,\"errors\":0}', NULL, 'ok', NULL, '2026-06-22 14:08:05', 44958, 160, NULL);