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 = 'de2e1078-7e3c-4caf-912a-c255c832bf9c' 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 = '2e6a314e-9afe-4300-842b-8a338ec1b111';

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 = '366179c8-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 ('366179c8-88ca-11ee-940f-001a4aa86950') ORDER BY s0_.username ASC;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE cita SET fin = '2026-05-29 16:30:00', estado = 'reagendar', updated_at = '2026-05-29 15:47:37', updated_by = 'kathia.acosta', revision = revision + 1 WHERE id = '2e6a314e-9afe-4300-842b-8a338ec1b111' AND revision = 4;

SELECT
  revision
FROM
  cita
WHERE
  id = ?

SELECT revision FROM cita WHERE id = '2e6a314e-9afe-4300-842b-8a338ec1b111';

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

INSERT INTO revisions (timestamp, username) VALUES ('2026-05-29 15:47:37', 'kathia.acosta');

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 ('115560', 'UPD', '366179c8-88ca-11ee-940f-001a4aa86950', 'deb5e33d-1e38-4546-b99c-0670e4b5bcef', '404e3b67-88cd-11ee-940f-001a4aa86950', NULL, '2e6a314e-9afe-4300-842b-8a338ec1b111', '2026-05-29 16:15:00', '2026-05-29 16:30:00', 'reagendar', 0, 5, '2026-05-20 09:01:41', '2026-05-29 15:47:37', 'mateo.gonzalez', 'kathia.acosta');

"COMMIT"

"COMMIT";

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

UPDATE cita_audit SET fin = '2026-05-29 16:30:00', estado = 'reagendar', updated_at = '2026-05-29 15:47:37', updated_by = 'kathia.acosta' WHERE rev = '115560' AND id = '2e6a314e-9afe-4300-842b-8a338ec1b111';

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 = 'deb5e33d-1e38-4546-b99c-0670e4b5bcef';