Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.amount AS amount_3,
  t0.concept AS concept_4,
  t0.entry_date AS entry_date_5,
  t0.paid_amount AS paid_amount_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.movement_type_id AS movement_type_id_10,
  t0.account_id AS account_id_11,
  t0.organization_id AS organization_id_12
FROM
  debt_entry t0
WHERE
  t0.account_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.amount AS amount_3, t0.concept AS concept_4, t0.entry_date AS entry_date_5, t0.paid_amount AS paid_amount_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.movement_type_id AS movement_type_id_10, t0.account_id AS account_id_11, t0.organization_id AS organization_id_12 FROM debt_entry t0 WHERE t0.account_id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.name AS name_4,
  t0.roles AS roles_5,
  t0.theme AS theme_6,
  t0.is_active AS is_active_7,
  t0.telegram_chat_id AS telegram_chat_id_8,
  t0.telegram_link_token AS telegram_link_token_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.organization_id AS organization_id_13
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.roles AS roles_5, t0.theme AS theme_6, t0.is_active AS is_active_7, t0.telegram_chat_id AS telegram_chat_id_8, t0.telegram_link_token AS telegram_link_token_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.organization_id AS organization_id_13 FROM "user" t0 WHERE t0.id = 2;

SELECT
  a0_.id AS id_0,
  a0_.uuid AS uuid_1,
  a0_.share_token AS share_token_2,
  a0_.name AS name_3,
  a0_.description AS description_4,
  a0_.discount_percent AS discount_percent_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.deleted_at AS deleted_at_8,
  c1_.id AS id_9,
  c1_.uuid AS uuid_10,
  c1_.name AS name_11,
  c1_.email AS email_12,
  c1_.phone AS phone_13,
  c1_.alias AS alias_14,
  c1_.credit_days AS credit_days_15,
  c1_.discount_percent AS discount_percent_16,
  c1_.notes AS notes_17,
  c1_.is_active AS is_active_18,
  c1_.created_at AS created_at_19,
  c1_.updated_at AS updated_at_20,
  c1_.deleted_at AS deleted_at_21,
  a0_.contact_id AS contact_id_22,
  a0_.organization_id AS organization_id_23,
  c1_.organization_id AS organization_id_24
FROM
  account a0_
  INNER JOIN contact c1_ ON a0_.contact_id = c1_.id
WHERE
  a0_.deleted_at IS NULL
  AND a0_.organization_id IN (?, ?)
ORDER BY
  c1_.name ASC,
  a0_.name ASC
LIMIT
  5000

SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.share_token AS share_token_2, a0_.name AS name_3, a0_.description AS description_4, a0_.discount_percent AS discount_percent_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.deleted_at AS deleted_at_8, c1_.id AS id_9, c1_.uuid AS uuid_10, c1_.name AS name_11, c1_.email AS email_12, c1_.phone AS phone_13, c1_.alias AS alias_14, c1_.credit_days AS credit_days_15, c1_.discount_percent AS discount_percent_16, c1_.notes AS notes_17, c1_.is_active AS is_active_18, c1_.created_at AS created_at_19, c1_.updated_at AS updated_at_20, c1_.deleted_at AS deleted_at_21, a0_.contact_id AS contact_id_22, a0_.organization_id AS organization_id_23, c1_.organization_id AS organization_id_24 FROM account a0_ INNER JOIN contact c1_ ON a0_.contact_id = c1_.id WHERE a0_.deleted_at IS NULL AND a0_.organization_id IN (2, 1) ORDER BY c1_.name ASC, a0_.name ASC LIMIT 5000;

SELECT
  d0_.account_id AS sclr_0,
  SUM(d0_.amount) AS sclr_1
FROM
  debt_entry d0_
WHERE
  d0_.deleted_at IS NULL
GROUP BY
  d0_.account_id

SELECT d0_.account_id AS sclr_0, SUM(d0_.amount) AS sclr_1 FROM debt_entry d0_ WHERE d0_.deleted_at IS NULL GROUP BY d0_.account_id;

SELECT
  p0_.account_id AS sclr_0,
  SUM(p0_.amount) AS sclr_1
FROM
  payment p0_
WHERE
  p0_.deleted_at IS NULL
GROUP BY
  p0_.account_id

SELECT p0_.account_id AS sclr_0, SUM(p0_.amount) AS sclr_1 FROM payment p0_ WHERE p0_.deleted_at IS NULL GROUP BY p0_.account_id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.primary_color AS primary_color_5,
  t0.secondary_color AS secondary_color_6,
  t0.accent_color AS accent_color_7,
  t0.navbar_color AS navbar_color_8,
  t0.logo_path AS logo_path_9,
  t0.timezone AS timezone_10,
  t0.plan AS plan_11,
  t0.billing_started_at AS billing_started_at_12,
  t0.plan_expires_at AS plan_expires_at_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  organization t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.accent_color AS accent_color_7, t0.navbar_color AS navbar_color_8, t0.logo_path AS logo_path_9, t0.timezone AS timezone_10, t0.plan AS plan_11, t0.billing_started_at AS billing_started_at_12, t0.plan_expires_at AS plan_expires_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM organization t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.primary_color AS primary_color_5,
  t0.secondary_color AS secondary_color_6,
  t0.accent_color AS accent_color_7,
  t0.navbar_color AS navbar_color_8,
  t0.logo_path AS logo_path_9,
  t0.timezone AS timezone_10,
  t0.plan AS plan_11,
  t0.billing_started_at AS billing_started_at_12,
  t0.plan_expires_at AS plan_expires_at_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  organization t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.accent_color AS accent_color_7, t0.navbar_color AS navbar_color_8, t0.logo_path AS logo_path_9, t0.timezone AS timezone_10, t0.plan AS plan_11, t0.billing_started_at AS billing_started_at_12, t0.plan_expires_at AS plan_expires_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM organization t0 WHERE t0.slug = 'sistema' LIMIT 1;

SELECT
  to_char(p.paid_at, 'YYYY-MM') AS mes,
  SUM(p.amount):: numeric AS total
FROM
  payment p
WHERE
  p.deleted_at IS NULL
  AND p.paid_at >= ?
  AND p.organization_id IN (2, 1)
GROUP BY
  mes
ORDER BY
  mes

SELECT to_char(p.paid_at, 'YYYY-MM') AS mes, SUM(p.amount)::numeric AS total
                FROM payment p
                WHERE p.deleted_at IS NULL AND p.paid_at >= '2026-04-01'  AND p.organization_id IN (2,1)
                GROUP BY mes ORDER BY mes;

SELECT
  to_char(d.entry_date, 'YYYY-MM') AS mes,
  SUM(d.amount - d.paid_amount):: numeric AS total
FROM
  debt_entry d
WHERE
  d.deleted_at IS NULL
  AND d.entry_date >= ?
  AND d.organization_id IN (2, 1)
GROUP BY
  mes
ORDER BY
  mes

SELECT to_char(d.entry_date, 'YYYY-MM') AS mes, SUM(d.amount - d.paid_amount)::numeric AS total
                FROM debt_entry d
                WHERE d.deleted_at IS NULL AND d.entry_date >= '2026-04-01'  AND d.organization_id IN (2,1)
                GROUP BY mes ORDER BY mes;

SELECT
  SUM(p0_.amount) AS sclr_0
FROM
  payment p0_
WHERE
  p0_.deleted_at IS NULL
  AND p0_.paid_at >= ?
  AND p0_.paid_at <= ?
  AND p0_.organization_id IN (?, ?)

SELECT SUM(p0_.amount) AS sclr_0 FROM payment p0_ WHERE p0_.deleted_at IS NULL AND p0_.paid_at >= '2026-09-01 00:00:00' AND p0_.paid_at <= '2026-09-30 00:00:00' AND p0_.organization_id IN (2, 1);