Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine 2
• Debug
• Serializer
• Configuration

Query Metrics

SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.cashier_id AS cashier_id_10 FROM sales s0_ WHERE s0_.created_at >= ? AND s0_.created_at <= ? ORDER BY s0_.created_at DESC

[
  "2025-12-26 19:43:55"
  "2026-01-02 19:43:55"
]

SELECT
  s0_.id AS id_0,
  s0_.invoice_number AS invoice_number_1,
  s0_.total_amount AS total_amount_2,
  s0_.amount_paid AS amount_paid_3,
  s0_.payment_method AS payment_method_4,
  s0_.status AS status_5,
  s0_.customer_name AS customer_name_6,
  s0_.customer_phone AS customer_phone_7,
  s0_.notes AS notes_8,
  s0_.created_at AS created_at_9,
  s0_.cashier_id AS cashier_id_10
FROM
  sales s0_
WHERE
  s0_.created_at >= ?
  AND s0_.created_at <= ?
ORDER BY
  s0_.created_at DESC

SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.cashier_id AS cashier_id_10 FROM sales s0_ WHERE s0_.created_at >= '2025-12-26 19:43:55' AND s0_.created_at <= '2026-01-02 19:43:55' ORDER BY s0_.created_at DESC;

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

[
  "2025-12-26 19:43:55"
  "2026-01-02 19:43:55"
  "completed"
]

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

SELECT COUNT(s0_.id) AS sclr_0, SUM(s0_.total_amount) AS sclr_1, AVG(s0_.total_amount) AS sclr_2 FROM sales s0_ WHERE s0_.created_at >= '2025-12-26 19:43:55' AND s0_.created_at <= '2026-01-02 19:43:55' AND s0_.status = 'completed';

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

[
  "2025-12-27 19:43:55"
  "2025-12-28 19:43:55"
  "completed"
]

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

SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= '2025-12-27 19:43:55' AND s0_.created_at < '2025-12-28 19:43:55' AND s0_.status = 'completed';

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

[
  "2025-12-28 19:43:55"
  "2025-12-29 19:43:55"
  "completed"
]

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

SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= '2025-12-28 19:43:55' AND s0_.created_at < '2025-12-29 19:43:55' AND s0_.status = 'completed';

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

[
  "2025-12-29 19:43:55"
  "2025-12-30 19:43:55"
  "completed"
]

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

SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= '2025-12-29 19:43:55' AND s0_.created_at < '2025-12-30 19:43:55' AND s0_.status = 'completed';

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

[
  "2025-12-30 19:43:55"
  "2025-12-31 19:43:55"
  "completed"
]

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

SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= '2025-12-30 19:43:55' AND s0_.created_at < '2025-12-31 19:43:55' AND s0_.status = 'completed';

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

[
  "2025-12-31 19:43:55"
  "2026-01-01 19:43:55"
  "completed"
]

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

SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= '2025-12-31 19:43:55' AND s0_.created_at < '2026-01-01 19:43:55' AND s0_.status = 'completed';

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

[
  "2026-01-01 19:43:55"
  "2026-01-02 19:43:55"
  "completed"
]

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

SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= '2026-01-01 19:43:55' AND s0_.created_at < '2026-01-02 19:43:55' AND s0_.status = 'completed';

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

[
  "2026-01-02 19:43:55"
  "2026-01-03 19:43:55"
  "completed"
]

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

SELECT COALESCE(SUM(s0_.total_amount), 0) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sales s0_ WHERE s0_.created_at >= '2026-01-02 19:43:55' AND s0_.created_at < '2026-01-03 19:43:55' AND s0_.status = 'completed';

SELECT s0_.payment_method AS payment_method_0, COUNT(s0_.id) AS sclr_1, SUM(s0_.total_amount) AS sclr_2 FROM sales s0_ WHERE s0_.created_at >= ? AND s0_.created_at <= ? AND s0_.status = ? GROUP BY s0_.payment_method

[
  "2025-12-26 19:43:55"
  "2026-01-02 19:43:55"
  "completed"
]

SELECT
  s0_.payment_method AS payment_method_0,
  COUNT(s0_.id) AS sclr_1,
  SUM(s0_.total_amount) AS sclr_2
FROM
  sales s0_
WHERE
  s0_.created_at >= ?
  AND s0_.created_at <= ?
  AND s0_.status = ?
GROUP BY
  s0_.payment_method

SELECT s0_.payment_method AS payment_method_0, COUNT(s0_.id) AS sclr_1, SUM(s0_.total_amount) AS sclr_2 FROM sales s0_ WHERE s0_.created_at >= '2025-12-26 19:43:55' AND s0_.created_at <= '2026-01-02 19:43:55' AND s0_.status = 'completed' GROUP BY s0_.payment_method;