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 ('72c9ff2a-7c9a-4d29-8702-83eae7e06c5c', '2026-08-03 07:00:00', '2026-08-03 07:15:00', 'agendada', 0, '2026-07-31 08:09:43', '2026-07-31 08:09:43', 'karen.escobar', 'karen.escobar', '36617a53-88ca-11ee-940f-001a4aa86950', '28c73d98-269c-4a18-a80c-2bb52a360f8d', '404e254d-88cd-11ee-940f-001a4aa86950', NULL);

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 ('133258', 'INS', '36617a53-88ca-11ee-940f-001a4aa86950', '28c73d98-269c-4a18-a80c-2bb52a360f8d', '404e254d-88cd-11ee-940f-001a4aa86950', NULL, '72c9ff2a-7c9a-4d29-8702-83eae7e06c5c', '2026-08-03 07:00:00', '2026-08-03 07:15:00', 'agendada', 0, 1, '2026-07-31 08:09:43', '2026-07-31 08:09:43', 'karen.escobar', 'karen.escobar');

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;

"COMMIT"

"COMMIT";

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 = '72c9ff2a-7c9a-4d29-8702-83eae7e06c5c', inicio = '2026-08-03 07:00:00', fin = '2026-08-03 07:15:00', estado = 'agendada', reagendada = 0, created_at = '2026-07-31 08:09:43', updated_at = '2026-07-31 08:09:43', created_by = 'karen.escobar', updated_by = 'karen.escobar', doctor_id = '36617a53-88ca-11ee-940f-001a4aa86950', paciente_id = '28c73d98-269c-4a18-a80c-2bb52a360f8d', motivo_cita_id = '404e254d-88cd-11ee-940f-001a4aa86950', presupuesto_id = NULL WHERE rev = '133258' AND id = '72c9ff2a-7c9a-4d29-8702-83eae7e06c5c';

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.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 = '28c73d98-269c-4a18-a80c-2bb52a360f8d';

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 = '404e254d-88cd-11ee-940f-001a4aa86950';

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 = '28c73d98-269c-4a18-a80c-2bb52a360f8d';

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

INSERT INTO revisions (timestamp, username) VALUES ('2026-07-31 08:09:43', 'karen.escobar');

SELECT
  revision
FROM
  cita
WHERE
  id = ?

SELECT revision FROM cita WHERE id = '72c9ff2a-7c9a-4d29-8702-83eae7e06c5c';

"START TRANSACTION"

"START TRANSACTION";