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.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.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.ci = ?
LIMIT
  2

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.ci = '6157149' LIMIT 2;

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.codigo = ?
LIMIT
  2

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.codigo = '6.157.149' LIMIT 2;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  paciente
SET
  nombre = ?,
  apellido = ?,
  como_llego = ?,
  updated_at = ?,
  revision = revision + 1
WHERE
  id = ?
  AND revision = ?

UPDATE paciente SET nombre = 'Dahiana Magali', apellido = 'Peralta Arrua', como_llego = 'facebook', updated_at = '2026-07-29 14:01:21', revision = revision + 1 WHERE id = '78b8508c-8a34-4728-ae04-9c1c55820458' AND revision = 1;

SELECT
  revision
FROM
  paciente
WHERE
  id = ?

SELECT revision FROM paciente WHERE id = '78b8508c-8a34-4728-ae04-9c1c55820458';

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

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

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.activa AS activa_3,
  t0.revision AS revision_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  vacuna t0
  INNER JOIN paciente_vacuna ON t0.id = paciente_vacuna.vacuna_id
WHERE
  paciente_vacuna.paciente_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activa AS activa_3, t0.revision AS revision_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM vacuna t0 INNER JOIN paciente_vacuna ON t0.id = paciente_vacuna.vacuna_id WHERE paciente_vacuna.paciente_id = '78b8508c-8a34-4728-ae04-9c1c55820458';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.activo AS activo_3,
  t0.revision AS revision_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  antecedente t0
  INNER JOIN paciente_antecedente ON t0.id = paciente_antecedente.antecedente_id
WHERE
  paciente_antecedente.paciente_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.revision AS revision_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM antecedente t0 INNER JOIN paciente_antecedente ON t0.id = paciente_antecedente.antecedente_id WHERE paciente_antecedente.paciente_id = '78b8508c-8a34-4728-ae04-9c1c55820458';

INSERT INTO paciente_audit (
  rev, revtype, tipo_cliente_id, titular_id,
  id, ci, nombre, apellido, telefono,
  celular, email, codigo, sexo, grupo_sanguineo,
  direccion, alergias, informacion_adicional,
  fecha_nacimiento, como_llego, revision,
  created_at, updated_at, created_by,
  updated_by
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO paciente_audit (rev, revtype, tipo_cliente_id, titular_id, id, ci, nombre, apellido, telefono, celular, email, codigo, sexo, grupo_sanguineo, direccion, alergias, informacion_adicional, fecha_nacimiento, como_llego, revision, created_at, updated_at, created_by, updated_by) VALUES ('132717', 'UPD', '86ecf761-88c9-11ee-940f-001a4aa86950', NULL, '78b8508c-8a34-4728-ae04-9c1c55820458', '6157149', 'Dahiana Magali', 'Peralta Arrua', '595973906812', '595973906812', NULL, '6.157.149', 'Femenino', NULL, NULL, NULL, NULL, '2000-03-14', 'facebook', 2, '2026-07-27 10:42:35', '2026-07-29 14:01:21', 'karen.escobar', 'karen.escobar');

"COMMIT"

"COMMIT";

UPDATE
  paciente_audit
SET
  nombre = ?,
  apellido = ?,
  como_llego = ?,
  updated_at = ?
WHERE
  rev = ?
  AND id = ?

UPDATE paciente_audit SET nombre = 'Dahiana Magali', apellido = 'Peralta Arrua', como_llego = 'facebook', updated_at = '2026-07-29 14:01:21' WHERE rev = '132717' AND id = '78b8508c-8a34-4728-ae04-9c1c55820458';