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(t0_.id) AS sclr_0 FROM ticket t0_ WHERE t0_.status = ?

[
  "new"
]

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 = 'new';

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.customer_name AS customer_name_2, t0_.customer_email AS customer_email_3, t0_.subject AS subject_4, t0_.status AS status_5, t0_.prestashop_order_ref AS prestashop_order_ref_6, t0_.prestashop_order_id AS prestashop_order_id_7, t0_.prestashop_customer_id AS prestashop_customer_id_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10 FROM ticket t0_ WHERE t0_.status = ? ORDER BY t0_.created_at ASC) dctrn_result) dctrn_table

[
  "new"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.reference AS reference_1,
          t0_.customer_name AS customer_name_2,
          t0_.customer_email AS customer_email_3,
          t0_.subject AS subject_4,
          t0_.status AS status_5,
          t0_.prestashop_order_ref AS prestashop_order_ref_6,
          t0_.prestashop_order_id AS prestashop_order_id_7,
          t0_.prestashop_customer_id AS prestashop_customer_id_8,
          t0_.created_at AS created_at_9,
          t0_.updated_at AS updated_at_10
        FROM
          ticket t0_
        WHERE
          t0_.status = ?
        ORDER BY
          t0_.created_at ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.customer_name AS customer_name_2, t0_.customer_email AS customer_email_3, t0_.subject AS subject_4, t0_.status AS status_5, t0_.prestashop_order_ref AS prestashop_order_ref_6, t0_.prestashop_order_id AS prestashop_order_id_7, t0_.prestashop_customer_id AS prestashop_customer_id_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10 FROM ticket t0_ WHERE t0_.status = 'new' ORDER BY t0_.created_at ASC) dctrn_result) dctrn_table;

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 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.slug AS slug_2, t0.label AS label_3, t0.color AS color_4, t0.position AS position_5, t0.is_system AS is_system_6 FROM ticket_status t0 ORDER BY t0.position ASC, t0.label ASC

[]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.color AS color_4,
  t0.position AS position_5,
  t0.is_system AS is_system_6
FROM
  ticket_status t0
ORDER BY
  t0.position ASC,
  t0.label ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.color AS color_4, t0.position AS position_5, t0.is_system AS is_system_6 FROM ticket_status t0 ORDER BY t0.position ASC, t0.label ASC;