Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.full_name AS full_name_5,
  t0.reset_token AS reset_token_6,
  t0.reset_requested_at AS reset_requested_at_7,
  t0.is_active AS is_active_8,
  t0.business_id AS business_id_9
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.reset_token AS reset_token_6, t0.reset_requested_at AS reset_requested_at_7, t0.is_active AS is_active_8, t0.business_id AS business_id_9 FROM users t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t5.id AS id_6,
  t5.status AS status_7,
  t5.start_at AS start_at_8,
  t5.end_at AS end_at_9,
  t5.trial_ends_at AS trial_ends_at_10,
  t5.notes AS notes_11,
  t5.mp_preapproval_id AS mp_preapproval_id_12,
  t5.mp_preapproval_plan_id AS mp_preapproval_plan_id_13,
  t5.payer_email AS payer_email_14,
  t5.last_synced_at AS last_synced_at_15,
  t5.override_mode AS override_mode_16,
  t5.override_until AS override_until_17,
  t5.created_at AS created_at_18,
  t5.updated_at AS updated_at_19,
  t5.business_id AS business_id_20,
  t5.plan_id AS plan_id_21
FROM
  business t0
  LEFT JOIN subscriptions t5 ON t5.business_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t5.id AS id_6, t5.status AS status_7, t5.start_at AS start_at_8, t5.end_at AS end_at_9, t5.trial_ends_at AS trial_ends_at_10, t5.notes AS notes_11, t5.mp_preapproval_id AS mp_preapproval_id_12, t5.mp_preapproval_plan_id AS mp_preapproval_plan_id_13, t5.payer_email AS payer_email_14, t5.last_synced_at AS last_synced_at_15, t5.override_mode AS override_mode_16, t5.override_until AS override_until_17, t5.created_at AS created_at_18, t5.updated_at AS updated_at_19, t5.business_id AS business_id_20, t5.plan_id AS plan_id_21 FROM business t0 LEFT JOIN subscriptions t5 ON t5.business_id = t0.id WHERE t0.id = 1;

SELECT
  COALESCE(
    SUM(s0_.total),
    0
  ) AS sclr_0,
  COUNT(s0_.id) AS sclr_1,
  COALESCE(
    AVG(s0_.total),
    0
  ) AS sclr_2
FROM
  sales s0_
WHERE
  s0_.business_id = ?
  AND s0_.created_at >= ?
  AND s0_.created_at < ?
  AND s0_.status = ?

SELECT COALESCE(SUM(s0_.total), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1, COALESCE(AVG(s0_.total), 0) AS sclr_2 FROM sales s0_ WHERE s0_.business_id = 1 AND s0_.created_at >= '2025-12-29 00:00:00' AND s0_.created_at < '2025-12-30 00:00:00' AND s0_.status = 'CONFIRMED';

SELECT
  c0_.id AS id_0,
  c0_.opened_at AS opened_at_1,
  c0_.closed_at AS closed_at_2,
  c0_.initial_cash AS initial_cash_3,
  c0_.final_cash_counted AS final_cash_counted_4,
  c0_.totals_by_payment_method AS totals_by_payment_method_5,
  c0_.business_id AS business_id_6,
  c0_.opened_by_id AS opened_by_id_7
FROM
  cash_sessions c0_
WHERE
  c0_.business_id = ?
  AND c0_.opened_by_id = ?
  AND c0_.closed_at IS NULL
LIMIT
  1

SELECT c0_.id AS id_0, c0_.opened_at AS opened_at_1, c0_.closed_at AS closed_at_2, c0_.initial_cash AS initial_cash_3, c0_.final_cash_counted AS final_cash_counted_4, c0_.totals_by_payment_method AS totals_by_payment_method_5, c0_.business_id AS business_id_6, c0_.opened_by_id AS opened_by_id_7 FROM cash_sessions c0_ WHERE c0_.business_id = 1 AND c0_.opened_by_id = 1 AND c0_.closed_at IS NULL LIMIT 1;

SELECT
  COALESCE(
    SUM(s0_.total),
    0
  ) AS sclr_0,
  COUNT(s0_.id) AS sclr_1,
  COALESCE(
    AVG(s0_.total),
    0
  ) AS sclr_2
FROM
  sales s0_
WHERE
  s0_.business_id = ?
  AND s0_.created_at >= ?
  AND s0_.created_at < ?
  AND s0_.status = ?

SELECT COALESCE(SUM(s0_.total), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1, COALESCE(AVG(s0_.total), 0) AS sclr_2 FROM sales s0_ WHERE s0_.business_id = 1 AND s0_.created_at >= '2025-12-01 00:00:00' AND s0_.created_at < '2026-01-01 00:00:00' AND s0_.status = 'CONFIRMED';

SELECT
  p0_.method AS method_0,
  COALESCE(
    SUM(p0_.amount),
    0
  ) AS sclr_1
FROM
  payments p0_
  INNER JOIN sales s1_ ON p0_.sale_id = s1_.id
WHERE
  s1_.business_id = ?
  AND s1_.status = ?
  AND p0_.created_at >= ?
  AND p0_.created_at < ?
GROUP BY
  p0_.method

SELECT p0_.method AS method_0, COALESCE(SUM(p0_.amount), 0) AS sclr_1 FROM payments p0_ INNER JOIN sales s1_ ON p0_.sale_id = s1_.id WHERE s1_.business_id = 1 AND s1_.status = 'CONFIRMED' AND p0_.created_at >= '2025-12-01 00:00:00' AND p0_.created_at < '2026-01-01 00:00:00' GROUP BY p0_.method;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  sales s1_
  LEFT JOIN customers c0_ ON s1_.customer_id = c0_.id
WHERE
  s1_.business_id = ?
  AND s1_.created_at >= ?
  AND s1_.created_at < ?
  AND s1_.status = ?
  AND c0_.id IS NOT NULL
  AND c0_.is_active = 1

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM sales s1_ LEFT JOIN customers c0_ ON s1_.customer_id = c0_.id WHERE s1_.business_id = 1 AND s1_.created_at >= '2025-12-01 00:00:00' AND s1_.created_at < '2026-01-01 00:00:00' AND s1_.status = 'CONFIRMED' AND c0_.id IS NOT NULL AND c0_.is_active = 1;

SELECT
  DATE_FORMAT(s.created_at, '%H') AS hour,
  COALESCE(
    SUM(s.total),
    0
  ) AS amount
FROM
  sales s
WHERE
  s.business_id = ?
  AND s.created_at >= ?
  AND s.created_at < ?
  AND s.status = 'CONFIRMED'
GROUP BY
  hour
ORDER BY
  hour ASC

SELECT DATE_FORMAT(s.created_at, '%H') AS hour, COALESCE(SUM(s.total), 0) AS amount
    FROM sales s
    WHERE s.business_id = 1
      AND s.created_at >= '2025-12-29 00:00:00'
      AND s.created_at < '2025-12-30 00:00:00'
      AND s.status = 'CONFIRMED' GROUP BY hour ORDER BY hour ASC;

SELECT
  DATE_FORMAT(s.created_at, '%Y-%m-%d') AS date,
  COALESCE(
    SUM(s.total),
    0
  ) AS amount
FROM
  sales s
WHERE
  s.business_id = ?
  AND s.created_at >= ?
  AND s.created_at < ?
  AND s.status = 'CONFIRMED'
GROUP BY
  date
ORDER BY
  date ASC

SELECT DATE_FORMAT(s.created_at, '%Y-%m-%d') AS date, COALESCE(SUM(s.total), 0) AS amount
    FROM sales s
    WHERE s.business_id = 1
      AND s.created_at >= '2025-12-23 00:00:00'
      AND s.created_at < '2025-12-30 00:00:00'
      AND s.status = 'CONFIRMED'
    GROUP BY date
    ORDER BY date ASC;

SELECT
  p0_.method AS method_0,
  COALESCE(
    SUM(p0_.amount),
    0
  ) AS sclr_1
FROM
  payments p0_
  INNER JOIN sales s1_ ON p0_.sale_id = s1_.id
WHERE
  s1_.business_id = ?
  AND s1_.status = ?
  AND p0_.created_at >= ?
  AND p0_.created_at < ?
GROUP BY
  p0_.method

SELECT p0_.method AS method_0, COALESCE(SUM(p0_.amount), 0) AS sclr_1 FROM payments p0_ INNER JOIN sales s1_ ON p0_.sale_id = s1_.id WHERE s1_.business_id = 1 AND s1_.status = 'CONFIRMED' AND p0_.created_at >= '2025-12-29 00:00:00' AND p0_.created_at < '2025-12-30 00:00:00' GROUP BY p0_.method;

SELECT
  p0_.id AS id_0,
  p0_.sku AS sku_1,
  p0_.name AS name_2,
  p0_.stock AS stock_3,
  p0_.stock_min AS stock_min_4,
  p0_.stock - p0_.stock_min AS sclr_5
FROM
  products p0_
WHERE
  p0_.business_id = ?
  AND p0_.stock <= p0_.stock_min
ORDER BY
  sclr_5 ASC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.stock AS stock_3, p0_.stock_min AS stock_min_4, p0_.stock - p0_.stock_min AS sclr_5 FROM products p0_ WHERE p0_.business_id = 1 AND p0_.stock <= p0_.stock_min ORDER BY sclr_5 ASC LIMIT 5;

SELECT
  c0_.customer_id AS sclr_0,
  COALESCE(
    SUM(
      CASE WHEN c0_.type = ? THEN
        c0_.amount
      ELSE
        - c0_.amount
      END
    ),
    0
  ) AS sclr_1,
  MAX(c0_.created_at) AS sclr_2
FROM
  customer_account_movements c0_
WHERE
  c0_.business_id = ?
GROUP BY
  c0_.customer_id
HAVING
  COALESCE(
    SUM(
      CASE WHEN c0_.type = ? THEN
        c0_.amount
      ELSE
        - c0_.amount
      END
    ),
    0
  ) > 0
ORDER BY
  sclr_1 DESC
LIMIT
  5

SELECT c0_.customer_id AS sclr_0, COALESCE(SUM(CASE WHEN c0_.type = 'DEBIT' THEN c0_.amount ELSE -c0_.amount END), 0) AS sclr_1, MAX(c0_.created_at) AS sclr_2 FROM customer_account_movements c0_ WHERE c0_.business_id = 1 GROUP BY c0_.customer_id HAVING COALESCE(SUM(CASE WHEN c0_.type = 'DEBIT' THEN c0_.amount ELSE -c0_.amount END), 0) > 0 ORDER BY sclr_1 DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.document_type AS document_type_3,
  t0.document_number AS document_number_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.customer_type AS customer_type_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.business_id AS business_id_10,
  t0.price_list_id AS price_list_id_11
FROM
  customers t0
WHERE
  t0.id IN (?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.document_type AS document_type_3, t0.document_number AS document_number_4, t0.phone AS phone_5, t0.address AS address_6, t0.customer_type AS customer_type_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.business_id AS business_id_10, t0.price_list_id AS price_list_id_11 FROM customers t0 WHERE t0.id IN (1, 2);

SELECT
  s0_.id AS id_0,
  s0_.created_at AS created_at_1,
  s0_.total AS total_2,
  COALESCE(c1_.name, ?) AS sclr_3,
  MIN(p2_.method) AS sclr_4
FROM
  sales s0_
  LEFT JOIN customers c1_ ON s0_.customer_id = c1_.id
  LEFT JOIN payments p2_ ON s0_.id = p2_.sale_id
WHERE
  s0_.business_id = ?
  AND s0_.status = ?
GROUP BY
  s0_.id,
  c1_.name,
  s0_.created_at,
  s0_.total
ORDER BY
  s0_.created_at DESC
LIMIT
  10

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.total AS total_2, COALESCE(c1_.name, 'Consumidor final') AS sclr_3, MIN(p2_.method) AS sclr_4 FROM sales s0_ LEFT JOIN customers c1_ ON s0_.customer_id = c1_.id LEFT JOIN payments p2_ ON s0_.id = p2_.sale_id WHERE s0_.business_id = 1 AND s0_.status = 'CONFIRMED' GROUP BY s0_.id, c1_.name, s0_.created_at, s0_.total ORDER BY s0_.created_at DESC LIMIT 10;