Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = ? ORDER BY r0_.created_at DESC) dctrn_result) dctrn_table

[
  "pending"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.last_name AS last_name_1,
          r0_.first_name AS first_name_2,
          r0_.email AS email_3,
          r0_.order_number AS order_number_4,
          r0_.order_number_normalized AS order_number_normalized_5,
          r0_.screenshot_path AS screenshot_path_6,
          r0_.status AS status_7,
          r0_.rejection_reason AS rejection_reason_8,
          r0_.order_verified AS order_verified_9,
          r0_.prestashop_order_id AS prestashop_order_id_10,
          r0_.prestashop_order_ref AS prestashop_order_ref_11,
          r0_.created_at AS created_at_12,
          r0_.updated_at AS updated_at_13
        FROM
          review_submission r0_
        WHERE
          r0_.status = ?
        ORDER BY
          r0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.last_name AS last_name_1, r0_.first_name AS first_name_2, r0_.email AS email_3, r0_.order_number AS order_number_4, r0_.order_number_normalized AS order_number_normalized_5, r0_.screenshot_path AS screenshot_path_6, r0_.status AS status_7, r0_.rejection_reason AS rejection_reason_8, r0_.order_verified AS order_verified_9, r0_.prestashop_order_id AS prestashop_order_id_10, r0_.prestashop_order_ref AS prestashop_order_ref_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13 FROM review_submission r0_ WHERE r0_.status = 'pending' ORDER BY r0_.created_at DESC) dctrn_result) dctrn_table;

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = ?

[
  "pending"
]

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  review_submission r0_
WHERE
  r0_.status = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = 'pending';

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = ?

[
  "sent"
]

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  review_submission r0_
WHERE
  r0_.status = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = 'sent';

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = ?

[
  "rejected"
]

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  review_submission r0_
WHERE
  r0_.status = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM review_submission r0_ WHERE r0_.status = 'rejected';

SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ WHERE t0_.status <> ?

[
  "closed"
]

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  ticket t0_
WHERE
  t0_.status <> ?

SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ WHERE t0_.status <> 'closed';