Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.id AS id_14,
  t0.nombre AS nombre_15,
  t0.apellido AS apellido_16,
  t0.documento_identidad AS documento_identidad_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  sonata_user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.nombre AS nombre_15, t0.apellido AS apellido_16, t0.documento_identidad AS documento_identidad_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM sonata_user t0 WHERE t0.id = 'be309420-d9c5-4f49-840a-209222087a61' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.inicio AS inicio_2,
  t0.fin AS fin_3,
  t0.estado AS estado_4,
  t0.reagendada AS reagendada_5,
  t0.revision AS revision_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.doctor_id AS doctor_id_11,
  t0.paciente_id AS paciente_id_12,
  t0.motivo_cita_id AS motivo_cita_id_13,
  t14.id AS id_15,
  t14.peso AS peso_16,
  t14.estatura AS estatura_17,
  t14.temperatura AS temperatura_18,
  t14.presion AS presion_19,
  t14.comentarios AS comentarios_20,
  t14.receta AS receta_21,
  t14.indicaciones AS indicaciones_22,
  t14.estudios AS estudios_23,
  t14.revision AS revision_24,
  t14.created_at AS created_at_25,
  t14.updated_at AS updated_at_26,
  t14.created_by AS created_by_27,
  t14.updated_by AS updated_by_28,
  t14.cita_id AS cita_id_29,
  t0.presupuesto_id AS presupuesto_id_30
FROM
  cita t0
  LEFT JOIN consulta t14 ON t14.cita_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.inicio AS inicio_2, t0.fin AS fin_3, t0.estado AS estado_4, t0.reagendada AS reagendada_5, t0.revision AS revision_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.doctor_id AS doctor_id_11, t0.paciente_id AS paciente_id_12, t0.motivo_cita_id AS motivo_cita_id_13, t14.id AS id_15, t14.peso AS peso_16, t14.estatura AS estatura_17, t14.temperatura AS temperatura_18, t14.presion AS presion_19, t14.comentarios AS comentarios_20, t14.receta AS receta_21, t14.indicaciones AS indicaciones_22, t14.estudios AS estudios_23, t14.revision AS revision_24, t14.created_at AS created_at_25, t14.updated_at AS updated_at_26, t14.created_by AS created_by_27, t14.updated_by AS updated_by_28, t14.cita_id AS cita_id_29, t0.presupuesto_id AS presupuesto_id_30 FROM cita t0 LEFT JOIN consulta t14 ON t14.cita_id = t0.id WHERE t0.id = '17872607-060e-4c47-9c8a-83d632af9029';

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.id AS id_14,
  t0.nombre AS nombre_15,
  t0.apellido AS apellido_16,
  t0.documento_identidad AS documento_identidad_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  sonata_user t0
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.nombre AS nombre_15, t0.apellido AS apellido_16, t0.documento_identidad AS documento_identidad_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM sonata_user t0 WHERE t0.id = '36617a53-88ca-11ee-940f-001a4aa86950';

SELECT
  s0_.username AS username_0,
  s0_.username_canonical AS username_canonical_1,
  s0_.email AS email_2,
  s0_.email_canonical AS email_canonical_3,
  s0_.enabled AS enabled_4,
  s0_.salt AS salt_5,
  s0_.password AS password_6,
  s0_.last_login AS last_login_7,
  s0_.confirmation_token AS confirmation_token_8,
  s0_.password_requested_at AS password_requested_at_9,
  s0_.roles AS roles_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12,
  s0_.id AS id_13,
  s0_.nombre AS nombre_14,
  s0_.apellido AS apellido_15,
  s0_.documento_identidad AS documento_identidad_16,
  s0_.created_by AS created_by_17,
  s0_.updated_by AS updated_by_18
FROM
  sonata_user s0_
WHERE
  LOWER(s0_.roles) LIKE ?
  AND s0_.id IN (?)
ORDER BY
  s0_.username ASC

SELECT s0_.username AS username_0, s0_.username_canonical AS username_canonical_1, s0_.email AS email_2, s0_.email_canonical AS email_canonical_3, s0_.enabled AS enabled_4, s0_.salt AS salt_5, s0_.password AS password_6, s0_.last_login AS last_login_7, s0_.confirmation_token AS confirmation_token_8, s0_.password_requested_at AS password_requested_at_9, s0_.roles AS roles_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.id AS id_13, s0_.nombre AS nombre_14, s0_.apellido AS apellido_15, s0_.documento_identidad AS documento_identidad_16, s0_.created_by AS created_by_17, s0_.updated_by AS updated_by_18 FROM sonata_user s0_ WHERE LOWER(s0_.roles) LIKE '%ROLE_DOCTOR%' AND s0_.id IN ('36617a53-88ca-11ee-940f-001a4aa86950') ORDER BY s0_.username ASC;

SELECT
  t0.id AS id_1,
  t0.ci AS ci_2,
  t0.nombre AS nombre_3,
  t0.apellido AS apellido_4,
  t0.telefono AS telefono_5,
  t0.celular AS celular_6,
  t0.email AS email_7,
  t0.codigo AS codigo_8,
  t0.sexo AS sexo_9,
  t0.grupo_sanguineo AS grupo_sanguineo_10,
  t0.direccion AS direccion_11,
  t0.alergias AS alergias_12,
  t0.informacion_adicional AS informacion_adicional_13,
  t0.fecha_nacimiento AS fecha_nacimiento_14,
  t0.como_llego AS como_llego_15,
  t0.revision AS revision_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.created_by AS created_by_19,
  t0.updated_by AS updated_by_20,
  t0.tipo_cliente_id AS tipo_cliente_id_21,
  t0.titular_id AS titular_id_22
FROM
  paciente t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ci AS ci_2, t0.nombre AS nombre_3, t0.apellido AS apellido_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.codigo AS codigo_8, t0.sexo AS sexo_9, t0.grupo_sanguineo AS grupo_sanguineo_10, t0.direccion AS direccion_11, t0.alergias AS alergias_12, t0.informacion_adicional AS informacion_adicional_13, t0.fecha_nacimiento AS fecha_nacimiento_14, t0.como_llego AS como_llego_15, t0.revision AS revision_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20, t0.tipo_cliente_id AS tipo_cliente_id_21, t0.titular_id AS titular_id_22 FROM paciente t0 WHERE t0.id = '78b8508c-8a34-4728-ae04-9c1c55820458';

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.fecha_inicio AS fecha_inicio_3,
  t0.fecha_fin AS fecha_fin_4,
  t0.estado AS estado_5,
  t0.monto_total AS monto_total_6,
  t0.monto_cuota AS monto_cuota_7,
  t0.cantidad_cuotas AS cantidad_cuotas_8,
  t0.fecha_firma_contrato AS fecha_firma_contrato_9,
  t0.monto_cuota_adherente AS monto_cuota_adherente_10,
  t0.monto_cuota_menor_edad AS monto_cuota_menor_edad_11,
  t0.revision AS revision_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.paciente_id AS paciente_id_17,
  t0.plan_id AS plan_id_18
FROM
  contrato t0
WHERE
  t0.paciente_id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha_inicio AS fecha_inicio_3, t0.fecha_fin AS fecha_fin_4, t0.estado AS estado_5, t0.monto_total AS monto_total_6, t0.monto_cuota AS monto_cuota_7, t0.cantidad_cuotas AS cantidad_cuotas_8, t0.fecha_firma_contrato AS fecha_firma_contrato_9, t0.monto_cuota_adherente AS monto_cuota_adherente_10, t0.monto_cuota_menor_edad AS monto_cuota_menor_edad_11, t0.revision AS revision_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.paciente_id AS paciente_id_17, t0.plan_id AS plan_id_18 FROM contrato t0 WHERE t0.paciente_id = '78b8508c-8a34-4728-ae04-9c1c55820458';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  cita
SET
  fin = ?,
  estado = ?,
  updated_at = ?,
  revision = revision + 1
WHERE
  id = ?
  AND revision = ?

UPDATE cita SET fin = '2026-07-29 15:30:00', estado = 'en_espera', updated_at = '2026-07-29 14:01:35', revision = revision + 1 WHERE id = '17872607-060e-4c47-9c8a-83d632af9029' AND revision = 2;

SELECT
  revision
FROM
  cita
WHERE
  id = ?

SELECT revision FROM cita WHERE id = '17872607-060e-4c47-9c8a-83d632af9029';

INSERT INTO revisions (timestamp, username)
VALUES
  (?, ?)

INSERT INTO revisions (timestamp, username) VALUES ('2026-07-29 14:01:35', 'karen.escobar');

INSERT INTO cita_audit (
  rev, revtype, doctor_id, paciente_id,
  motivo_cita_id, presupuesto_id,
  id, inicio, fin, estado, reagendada,
  revision, created_at, updated_at,
  created_by, updated_by
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO cita_audit (rev, revtype, doctor_id, paciente_id, motivo_cita_id, presupuesto_id, id, inicio, fin, estado, reagendada, revision, created_at, updated_at, created_by, updated_by) VALUES ('132718', 'UPD', '36617a53-88ca-11ee-940f-001a4aa86950', '78b8508c-8a34-4728-ae04-9c1c55820458', 'd35bab1c-19d5-46b7-beaa-261f39b257fe', NULL, '17872607-060e-4c47-9c8a-83d632af9029', '2026-07-29 15:15:00', '2026-07-29 15:30:00', 'en_espera', 0, 3, '2026-07-27 10:44:30', '2026-07-29 14:01:35', 'karen.escobar', 'karen.escobar');

"COMMIT"

"COMMIT";

UPDATE
  cita_audit
SET
  fin = ?,
  estado = ?,
  updated_at = ?
WHERE
  rev = ?
  AND id = ?

UPDATE cita_audit SET fin = '2026-07-29 15:30:00', estado = 'en_espera', updated_at = '2026-07-29 14:01:35' WHERE rev = '132718' AND id = '17872607-060e-4c47-9c8a-83d632af9029';