Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.position AS position_4 FROM ticket_template t0 ORDER BY t0.position ASC, t0.title ASC

[]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.position AS position_4
FROM
  ticket_template t0
ORDER BY
  t0.position ASC,
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.position AS position_4 FROM ticket_template t0 ORDER BY t0.position ASC, t0.title ASC;

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.body AS body_2, t0.direction AS direction_3, t0.attachment_path AS attachment_path_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_message t0 WHERE t0.ticket_id = ? ORDER BY t0.created_at ASC

[
  897
]

SELECT
  t0.id AS id_1,
  t0.body AS body_2,
  t0.direction AS direction_3,
  t0.attachment_path AS attachment_path_4,
  t0.created_at AS created_at_5,
  t0.ticket_id AS ticket_id_6
FROM
  ticket_message t0
WHERE
  t0.ticket_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.body AS body_2, t0.direction AS direction_3, t0.attachment_path AS attachment_path_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_message t0 WHERE t0.ticket_id = 897 ORDER BY t0.created_at ASC;

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 t0.id AS id_1, t0.reference AS reference_2, t0.customer_name AS customer_name_3, t0.customer_email AS customer_email_4, t0.subject AS subject_5, t0.status AS status_6, t0.prestashop_order_ref AS prestashop_order_ref_7, t0.prestashop_order_id AS prestashop_order_id_8, t0.prestashop_customer_id AS prestashop_customer_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM ticket t0 WHERE t0.id = ?

[
  "897"
]

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.customer_name AS customer_name_3,
  t0.customer_email AS customer_email_4,
  t0.subject AS subject_5,
  t0.status AS status_6,
  t0.prestashop_order_ref AS prestashop_order_ref_7,
  t0.prestashop_order_id AS prestashop_order_id_8,
  t0.prestashop_customer_id AS prestashop_customer_id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  ticket t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.customer_name AS customer_name_3, t0.customer_email AS customer_email_4, t0.subject AS subject_5, t0.status AS status_6, t0.prestashop_order_ref AS prestashop_order_ref_7, t0.prestashop_order_id AS prestashop_order_id_8, t0.prestashop_customer_id AS prestashop_customer_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM ticket t0 WHERE t0.id = '897';

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.siret AS siret_4, t0.vat_number AS vat_number_5, t0.address AS address_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.phone AS phone_9, t0.email AS email_10, t0.website AS website_11, t0.ticket_signature AS ticket_signature_12 FROM company t0 LIMIT 1

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.legal_name AS legal_name_3,
  t0.siret AS siret_4,
  t0.vat_number AS vat_number_5,
  t0.address AS address_6,
  t0.zip_code AS zip_code_7,
  t0.city AS city_8,
  t0.phone AS phone_9,
  t0.email AS email_10,
  t0.website AS website_11,
  t0.ticket_signature AS ticket_signature_12
FROM
  company t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.siret AS siret_4, t0.vat_number AS vat_number_5, t0.address AS address_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.phone AS phone_9, t0.email AS email_10, t0.website AS website_11, t0.ticket_signature AS ticket_signature_12 FROM company t0 LIMIT 1;

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;