Symfony Profiler

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

INSERT INTO cita (id, inicio, fin, estado, reagendada, created_at, updated_at, created_by, updated_by, doctor_id, paciente_id, motivo_cita_id, presupuesto_id) VALUES ('2cfd38d2-2e3a-436b-83ad-f9108a016e1d', '2026-08-03 08:00:00', '2026-08-03 08:15:00', 'agendada', 0, '2026-08-01 08:29:07', '2026-08-01 08:29:07', 'johana.torres', 'johana.torres', 'f2d78fae-ba21-4986-8c7c-27a7c176d9d7', 'a3dc241f-0eaf-4967-80e3-54360b6d9b85', 'e3a3b33d-841f-4251-8823-cf52404b50c1', NULL);

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 = 'a1740ec3-b621-487b-89a8-c674084c9976' LIMIT 1;

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 ('133607', 'INS', 'f2d78fae-ba21-4986-8c7c-27a7c176d9d7', 'a3dc241f-0eaf-4967-80e3-54360b6d9b85', 'e3a3b33d-841f-4251-8823-cf52404b50c1', NULL, '2cfd38d2-2e3a-436b-83ad-f9108a016e1d', '2026-08-03 08:00:00', '2026-08-03 08:15:00', 'agendada', 0, 1, '2026-08-01 08:29:07', '2026-08-01 08:29:07', 'johana.torres', 'johana.torres');

UPDATE
  cita_audit
SET
  id = ?,
  inicio = ?,
  fin = ?,
  estado = ?,
  reagendada = ?,
  created_at = ?,
  updated_at = ?,
  created_by = ?,
  updated_by = ?,
  doctor_id = ?,
  paciente_id = ?,
  motivo_cita_id = ?,
  presupuesto_id = ?
WHERE
  rev = ?
  AND id = ?

UPDATE cita_audit SET id = '2cfd38d2-2e3a-436b-83ad-f9108a016e1d', inicio = '2026-08-03 08:00:00', fin = '2026-08-03 08:15:00', estado = 'agendada', reagendada = 0, created_at = '2026-08-01 08:29:07', updated_at = '2026-08-01 08:29:07', created_by = 'johana.torres', updated_by = 'johana.torres', doctor_id = 'f2d78fae-ba21-4986-8c7c-27a7c176d9d7', paciente_id = 'a3dc241f-0eaf-4967-80e3-54360b6d9b85', motivo_cita_id = 'e3a3b33d-841f-4251-8823-cf52404b50c1', presupuesto_id = NULL WHERE rev = '133607' AND id = '2cfd38d2-2e3a-436b-83ad-f9108a016e1d';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.costo AS costo_3,
  t0.activo AS activo_4,
  t0.tipo_cita AS tipo_cita_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
FROM
  motivo_cita t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.costo AS costo_3, t0.activo AS activo_4, t0.tipo_cita AS tipo_cita_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 FROM motivo_cita t0 WHERE t0.id = 'e3a3b33d-841f-4251-8823-cf52404b50c1';

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 ('f2d78fae-ba21-4986-8c7c-27a7c176d9d7') ORDER BY s0_.username ASC;

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 = 'a3dc241f-0eaf-4967-80e3-54360b6d9b85';

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 = 'a3dc241f-0eaf-4967-80e3-54360b6d9b85';

"COMMIT"

"COMMIT";

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

INSERT INTO revisions (timestamp, username) VALUES ('2026-08-01 08:29:07', 'johana.torres');

SELECT
  revision
FROM
  cita
WHERE
  id = ?

SELECT revision FROM cita WHERE id = '2cfd38d2-2e3a-436b-83ad-f9108a016e1d';

"START TRANSACTION"

"START TRANSACTION";