Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• 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';

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.id = 1;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_12 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 = ?) dctrn_result_inner ORDER BY created_at_12 DESC) dctrn_result LIMIT 50

[
  "pending"
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_12
    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 = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_12 DESC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_12 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') dctrn_result_inner ORDER BY created_at_12 DESC) dctrn_result LIMIT 50;

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 = ? AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.created_at DESC

[
  "pending"
  15
  14
  13
  12
  11
  10
  9
  8
  7
  6
  5
  4
  3
]

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 = ?
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  r0_.created_at DESC

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' AND r0_.id IN (15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3) ORDER BY r0_.created_at DESC;