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
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.activo AS activo_2,
  p0_.monto AS monto_3,
  p0_.monto_adherente AS monto_adherente_4,
  p0_.monto_menor_edad AS monto_menor_edad_5,
  p0_.revision AS revision_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.created_by AS created_by_9,
  p0_.updated_by AS updated_by_10
FROM
  plan p0_

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.activo AS activo_2, p0_.monto AS monto_3, p0_.monto_adherente AS monto_adherente_4, p0_.monto_menor_edad AS monto_menor_edad_5, p0_.revision AS revision_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.created_by AS created_by_9, p0_.updated_by AS updated_by_10 FROM plan p0_;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  contrato c0_
  LEFT JOIN paciente p1_ ON c0_.paciente_id = p1_.id
WHERE
  p1_.ci LIKE ?

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM contrato c0_ LEFT JOIN paciente p1_ ON c0_.paciente_id = p1_.id WHERE p1_.ci LIKE '%3317936%';

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.numero AS numero_1,
  c0_.id AS id_2
FROM
  contrato c0_
  LEFT JOIN paciente p1_ ON c0_.paciente_id = p1_.id
WHERE
  p1_.ci LIKE ?
ORDER BY
  c0_.numero ASC,
  c0_.id ASC
LIMIT
  25

SELECT DISTINCT c0_.id AS id_0, c0_.numero AS numero_1, c0_.id AS id_2 FROM contrato c0_ LEFT JOIN paciente p1_ ON c0_.paciente_id = p1_.id WHERE p1_.ci LIKE '%3317936%' ORDER BY c0_.numero ASC, c0_.id ASC LIMIT 25;

SELECT
  c0_.id AS id_0,
  c0_.numero AS numero_1,
  c0_.fecha_inicio AS fecha_inicio_2,
  c0_.fecha_fin AS fecha_fin_3,
  c0_.estado AS estado_4,
  c0_.monto_total AS monto_total_5,
  c0_.monto_cuota AS monto_cuota_6,
  c0_.cantidad_cuotas AS cantidad_cuotas_7,
  c0_.fecha_firma_contrato AS fecha_firma_contrato_8,
  c0_.monto_cuota_adherente AS monto_cuota_adherente_9,
  c0_.monto_cuota_menor_edad AS monto_cuota_menor_edad_10,
  c0_.revision AS revision_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13,
  c0_.created_by AS created_by_14,
  c0_.updated_by AS updated_by_15,
  c0_.paciente_id AS paciente_id_16,
  c0_.plan_id AS plan_id_17
FROM
  contrato c0_
  LEFT JOIN paciente p1_ ON c0_.paciente_id = p1_.id
WHERE
  p1_.ci LIKE ?
  AND c0_.id IN (?)
ORDER BY
  c0_.numero ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.numero AS numero_1, c0_.fecha_inicio AS fecha_inicio_2, c0_.fecha_fin AS fecha_fin_3, c0_.estado AS estado_4, c0_.monto_total AS monto_total_5, c0_.monto_cuota AS monto_cuota_6, c0_.cantidad_cuotas AS cantidad_cuotas_7, c0_.fecha_firma_contrato AS fecha_firma_contrato_8, c0_.monto_cuota_adherente AS monto_cuota_adherente_9, c0_.monto_cuota_menor_edad AS monto_cuota_menor_edad_10, c0_.revision AS revision_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.created_by AS created_by_14, c0_.updated_by AS updated_by_15, c0_.paciente_id AS paciente_id_16, c0_.plan_id AS plan_id_17 FROM contrato c0_ LEFT JOIN paciente p1_ ON c0_.paciente_id = p1_.id WHERE p1_.ci LIKE '%3317936%' AND c0_.id IN ('af472010-9bf8-4932-9f95-f843ab3a59f1') ORDER BY c0_.numero ASC, c0_.id 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 = '4a09b681-65f1-4161-a8b1-1e3743b5fff5';

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.monto AS monto_3,
  t0.fecha_vencimiento AS fecha_vencimiento_4,
  t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11
FROM
  cuota t0
WHERE
  (
    (
      t0.fecha_cobro IS NULL
      AND t0.fecha_vencimiento < ?
    )
    AND t0.contrato_id = ?
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.monto AS monto_3, t0.fecha_vencimiento AS fecha_vencimiento_4, t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11 FROM cuota t0 WHERE ((t0.fecha_cobro IS NULL AND t0.fecha_vencimiento < '2026-05-29') AND t0.contrato_id = 'af472010-9bf8-4932-9f95-f843ab3a59f1') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.monto AS monto_3,
  t0.fecha_vencimiento AS fecha_vencimiento_4,
  t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11
FROM
  cuota t0
WHERE
  (
    (
      t0.fecha_cobro IS NULL
      AND t0.fecha_vencimiento < ?
    )
    AND t0.contrato_id = ?
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.monto AS monto_3, t0.fecha_vencimiento AS fecha_vencimiento_4, t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11 FROM cuota t0 WHERE ((t0.fecha_cobro IS NULL AND t0.fecha_vencimiento < '2026-05-29') AND t0.contrato_id = 'af472010-9bf8-4932-9f95-f843ab3a59f1') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.monto AS monto_3,
  t0.fecha_vencimiento AS fecha_vencimiento_4,
  t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11
FROM
  cuota t0
WHERE
  (
    t0.numero = ?
    AND t0.contrato_id = ?
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.monto AS monto_3, t0.fecha_vencimiento AS fecha_vencimiento_4, t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11 FROM cuota t0 WHERE (t0.numero = 1 AND t0.contrato_id = 'af472010-9bf8-4932-9f95-f843ab3a59f1') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.monto AS monto_3,
  t0.fecha_vencimiento AS fecha_vencimiento_4,
  t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11
FROM
  cuota t0
WHERE
  (
    t0.fecha_cobro IS NULL
    AND t0.contrato_id = ?
  )
ORDER BY
  t0.fecha_vencimiento ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.monto AS monto_3, t0.fecha_vencimiento AS fecha_vencimiento_4, t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11 FROM cuota t0 WHERE (t0.fecha_cobro IS NULL AND t0.contrato_id = 'af472010-9bf8-4932-9f95-f843ab3a59f1') ORDER BY t0.fecha_vencimiento ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.monto AS monto_3,
  t0.fecha_vencimiento AS fecha_vencimiento_4,
  t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11
FROM
  cuota t0
WHERE
  (
    (
      t0.fecha_cobro IS NULL
      AND t0.fecha_vencimiento < ?
    )
    AND t0.contrato_id = ?
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.monto AS monto_3, t0.fecha_vencimiento AS fecha_vencimiento_4, t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11 FROM cuota t0 WHERE ((t0.fecha_cobro IS NULL AND t0.fecha_vencimiento < '2026-05-29') AND t0.contrato_id = 'af472010-9bf8-4932-9f95-f843ab3a59f1') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.monto AS monto_3,
  t0.fecha_vencimiento AS fecha_vencimiento_4,
  t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11
FROM
  cuota t0
WHERE
  t0.contrato_id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.monto AS monto_3, t0.fecha_vencimiento AS fecha_vencimiento_4, t0.fecha_cobro AS fecha_cobro_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.contrato_id AS contrato_id_11 FROM cuota t0 WHERE t0.contrato_id = 'af472010-9bf8-4932-9f95-f843ab3a59f1';

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.revision AS revision_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.contrato_id AS contrato_id_8,
  t0.adherente_id AS adherente_id_9
FROM
  contrato_adherente t0
WHERE
  t0.contrato_id = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.revision AS revision_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.contrato_id AS contrato_id_8, t0.adherente_id AS adherente_id_9 FROM contrato_adherente t0 WHERE t0.contrato_id = 'af472010-9bf8-4932-9f95-f843ab3a59f1';