Symfony Profiler

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
  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
  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
  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);

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
  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
  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;