Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;

SELECT
  COALESCE(
    SUM(s.net_amount),
    0
  ) AS revenue,
  COALESCE(
    SUM(s.vat_amount),
    0
  ) AS vat,
  COALESCE(
    SUM(s.gross_amount),
    0
  ) AS gross,
  COALESCE(
    SUM(
      CASE WHEN s.gross_amount < 0 THEN
        ABS(s.net_amount)
      ELSE
        0
      END
    ),
    0
  ) AS credits,
  COUNT(
    CASE WHEN s.gross_amount < 0 THEN
      1
    END
  ) AS credit_documents,
  COUNT(
    CASE WHEN s.gross_amount > 0 THEN
      1
    END
  ) AS documents,
  COUNT(
    DISTINCT CASE WHEN s.gross_amount > 0 THEN
      s.customer_id
    END
  ) AS buyers,
  COUNT(
    DISTINCT CASE WHEN s.gross_amount > 0
    AND firsts.first_purchase >= ? THEN
      s.customer_id
    END
  ) AS new_buyers,
  COALESCE(
    ROUND(
      AVG(
        CASE WHEN s.gross_amount > 0 THEN
          s.net_amount
        END
      ),
      2
    ),
    0
  ) AS average
FROM
  sale s
  LEFT JOIN (
    SELECT
      customer_id,
      MIN(date) AS first_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
    GROUP BY
      customer_id
  ) firsts ON firsts.customer_id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.date BETWEEN ?
  AND ?

SELECT
            COALESCE(SUM(s.net_amount), 0) AS revenue,
            COALESCE(SUM(s.vat_amount), 0) AS vat,
            COALESCE(SUM(s.gross_amount), 0) AS gross,
            COALESCE(SUM(CASE WHEN s.gross_amount < 0 THEN ABS(s.net_amount) ELSE 0 END), 0) AS credits,
            COUNT(CASE WHEN s.gross_amount < 0 THEN 1 END) AS credit_documents,
            COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS documents,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 THEN s.customer_id END) AS buyers,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 AND firsts.first_purchase >= '2026-10-01' THEN s.customer_id END) AS new_buyers,
            COALESCE(ROUND(AVG(CASE WHEN s.gross_amount > 0 THEN s.net_amount END), 2), 0) AS average
            FROM sale s LEFT JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.date BETWEEN '2026-10-01' AND '2026-10-26';

SELECT
  COALESCE(
    SUM(s.net_amount),
    0
  ) AS revenue,
  COALESCE(
    SUM(s.vat_amount),
    0
  ) AS vat,
  COALESCE(
    SUM(s.gross_amount),
    0
  ) AS gross,
  COALESCE(
    SUM(
      CASE WHEN s.gross_amount < 0 THEN
        ABS(s.net_amount)
      ELSE
        0
      END
    ),
    0
  ) AS credits,
  COUNT(
    CASE WHEN s.gross_amount < 0 THEN
      1
    END
  ) AS credit_documents,
  COUNT(
    CASE WHEN s.gross_amount > 0 THEN
      1
    END
  ) AS documents,
  COUNT(
    DISTINCT CASE WHEN s.gross_amount > 0 THEN
      s.customer_id
    END
  ) AS buyers,
  COUNT(
    DISTINCT CASE WHEN s.gross_amount > 0
    AND firsts.first_purchase >= ? THEN
      s.customer_id
    END
  ) AS new_buyers,
  COALESCE(
    ROUND(
      AVG(
        CASE WHEN s.gross_amount > 0 THEN
          s.net_amount
        END
      ),
      2
    ),
    0
  ) AS average
FROM
  sale s
  LEFT JOIN (
    SELECT
      customer_id,
      MIN(date) AS first_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
    GROUP BY
      customer_id
  ) firsts ON firsts.customer_id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.date BETWEEN ?
  AND ?

SELECT
            COALESCE(SUM(s.net_amount), 0) AS revenue,
            COALESCE(SUM(s.vat_amount), 0) AS vat,
            COALESCE(SUM(s.gross_amount), 0) AS gross,
            COALESCE(SUM(CASE WHEN s.gross_amount < 0 THEN ABS(s.net_amount) ELSE 0 END), 0) AS credits,
            COUNT(CASE WHEN s.gross_amount < 0 THEN 1 END) AS credit_documents,
            COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS documents,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 THEN s.customer_id END) AS buyers,
            COUNT(DISTINCT CASE WHEN s.gross_amount > 0 AND firsts.first_purchase >= '2026-09-01' THEN s.customer_id END) AS new_buyers,
            COALESCE(ROUND(AVG(CASE WHEN s.gross_amount > 0 THEN s.net_amount END), 2), 0) AS average
            FROM sale s LEFT JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.date BETWEEN '2026-09-01' AND '2026-09-26';

SELECT
  date,
  SUM(net_amount) AS revenue,
  SUM(vat_amount) AS vat,
  SUM(gross_amount) AS gross,
  SUM(
    CASE WHEN gross_amount < 0 THEN
      ABS(net_amount)
    ELSE
      0
    END
  ) AS credits
FROM
  sale
WHERE
  cancelled = 0
  AND date BETWEEN ?
  AND ?
GROUP BY
  date
ORDER BY
  date

SELECT date, SUM(net_amount) AS revenue,
            SUM(vat_amount) AS vat, SUM(gross_amount) AS gross,
            SUM(CASE WHEN gross_amount < 0 THEN ABS(net_amount) ELSE 0 END) AS credits
            FROM sale WHERE cancelled = 0 AND date BETWEEN '2026-10-01' AND '2026-10-26' GROUP BY date ORDER BY date;

SELECT
  date,
  SUM(net_amount) AS revenue,
  SUM(vat_amount) AS vat,
  SUM(gross_amount) AS gross,
  SUM(
    CASE WHEN gross_amount < 0 THEN
      ABS(net_amount)
    ELSE
      0
    END
  ) AS credits
FROM
  sale
WHERE
  cancelled = 0
  AND date BETWEEN ?
  AND ?
GROUP BY
  date
ORDER BY
  date

SELECT date, SUM(net_amount) AS revenue,
            SUM(vat_amount) AS vat, SUM(gross_amount) AS gross,
            SUM(CASE WHEN gross_amount < 0 THEN ABS(net_amount) ELSE 0 END) AS credits
            FROM sale WHERE cancelled = 0 AND date BETWEEN '2026-09-01' AND '2026-09-30' GROUP BY date ORDER BY date;

SELECT
  s.date AS bucket,
  COUNT(
    DISTINCT CASE WHEN firsts.first_purchase >= s.date THEN
      s.customer_id
    END
  ) AS new_buyers,
  COUNT(
    DISTINCT CASE WHEN firsts.first_purchase < s.date THEN
      s.customer_id
    END
  ) AS returning_buyers
FROM
  sale s
  JOIN (
    SELECT
      customer_id,
      MIN(date) AS first_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
    GROUP BY
      customer_id
  ) firsts ON firsts.customer_id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.gross_amount > 0
  AND s.date BETWEEN ?
  AND ?
GROUP BY
  bucket
ORDER BY
  bucket

SELECT s.date AS bucket,
            COUNT(DISTINCT CASE WHEN firsts.first_purchase >= s.date THEN s.customer_id END) AS new_buyers,
            COUNT(DISTINCT CASE WHEN firsts.first_purchase < s.date THEN s.customer_id END) AS returning_buyers
            FROM sale s JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.gross_amount > 0 AND s.date BETWEEN '2026-10-01' AND '2026-10-26'
            GROUP BY bucket ORDER BY bucket;

SELECT
  DISTINCT DATE_FORMAT(s.date, '%Y-%m') AS month,
  s.customer_id,
  firsts.first_purchase
FROM
  sale s
  JOIN (
    SELECT
      customer_id,
      MIN(date) AS first_purchase
    FROM
      sale
    WHERE
      cancelled = 0
      AND gross_amount > 0
    GROUP BY
      customer_id
  ) firsts ON firsts.customer_id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.gross_amount > 0
  AND s.date BETWEEN ?
  AND ?
ORDER BY
  month

SELECT DISTINCT DATE_FORMAT(s.date, '%Y-%m') AS month, s.customer_id, firsts.first_purchase
            FROM sale s JOIN (SELECT customer_id, MIN(date) AS first_purchase FROM sale WHERE cancelled = 0 AND gross_amount > 0 GROUP BY customer_id) firsts ON firsts.customer_id = s.customer_id
            WHERE s.cancelled = 0 AND s.gross_amount > 0 AND s.date BETWEEN '2025-11-01' AND '2026-10-26' ORDER BY month;

SELECT
  c.id,
  c.name,
  c.softone_code,
  MAX(
    CASE WHEN s.gross_amount > 0 THEN
      s.date
    END
  ) AS last_purchase,
  COUNT(
    CASE WHEN s.gross_amount > 0 THEN
      1
    END
  ) AS purchases,
  COALESCE(
    SUM(s.net_amount),
    0
  ) AS revenue
FROM
  customer c
  LEFT JOIN sale s ON s.customer_id = c.id
  AND s.cancelled = 0
  AND s.date <= ?
WHERE
  c.active = 1
GROUP BY
  c.id,
  c.name,
  c.softone_code

SELECT c.id, c.name, c.softone_code,
            MAX(CASE WHEN s.gross_amount > 0 THEN s.date END) AS last_purchase,
            COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS purchases,
            COALESCE(SUM(s.net_amount), 0) AS revenue
            FROM customer c LEFT JOIN sale s ON s.customer_id = c.id AND s.cancelled = 0 AND s.date <= '2026-10-26'
            WHERE c.active = 1 GROUP BY c.id, c.name, c.softone_code;

SELECT
  c.id,
  c.name,
  c.softone_code,
  SUM(s.net_amount) AS revenue,
  COUNT(
    CASE WHEN s.gross_amount > 0 THEN
      1
    END
  ) AS purchases
FROM
  sale s
  JOIN customer c ON c.id = s.customer_id
WHERE
  s.cancelled = 0
  AND s.date BETWEEN ?
  AND ?
GROUP BY
  c.id,
  c.name,
  c.softone_code
HAVING
  purchases > 0
ORDER BY
  revenue DESC,
  c.name ASC,
  c.id ASC
LIMIT
  5

SELECT c.id, c.name, c.softone_code,
            SUM(s.net_amount) AS revenue, COUNT(CASE WHEN s.gross_amount > 0 THEN 1 END) AS purchases
            FROM sale s JOIN customer c ON c.id = s.customer_id
            WHERE s.cancelled = 0 AND s.date BETWEEN '2026-10-01' AND '2026-10-26'
            GROUP BY c.id, c.name, c.softone_code HAVING purchases > 0
            ORDER BY revenue DESC, c.name ASC, c.id ASC LIMIT 5;

SELECT
  MIN(date) AS first_date,
  MAX(date) AS last_date,
  COUNT(*) AS documents
FROM
  sale
WHERE
  cancelled = 0
  AND date <= ?

SELECT MIN(date) AS first_date, MAX(date) AS last_date, COUNT(*) AS documents
            FROM sale WHERE cancelled = 0 AND date <= '2026-10-26';