Symfony Profiler

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

Query Metrics

SELECT DISTINCT MIN(t0_.due_date) AS sclr_0, COUNT(n1_.id) AS sclr_1, o2_.creation_timestamp AS creation_timestamp_2, o2_.modification_timestamp AS modification_timestamp_3, o2_.inquiry AS inquiry_4, o2_.id AS id_5, o2_.version AS version_6, o2_.name AS name_7, d3_.code AS code_8, d3_.position AS position_9, d3_.id AS id_10, d3_.version AS version_11, d3_.name AS name_12, d3_.text_color AS text_color_13, d3_.text_background_color AS text_background_color_14, e4_.id AS id_15, e4_.first_name AS first_name_16, e4_.last_name AS last_name_17, c5_.id AS id_18, c5_.first_name AS first_name_19, c5_.last_name AS last_name_20, o6_.name AS name_21, o6_.short_name AS short_name_22, o6_.id AS id_23, f7_.original_name AS original_name_24, f7_.size AS size_25, f7_.hash AS hash_26, f7_.id AS id_27, o8_.type AS type_28, o2_.supervisor_id AS supervisor_id_29, o2_.client_id AS client_id_30, o2_.organization_id AS organization_id_31, o2_.creator_id AS creator_id_32, o2_.modifier_id AS modifier_id_33, o2_.status_id AS status_id_34, o2_.operator_id AS operator_id_35, d3_.discriminator AS discriminator_36, d3_.operator_id AS operator_id_37, e4_.operator_id AS operator_id_38, c5_.organization_id AS organization_id_39, c5_.operator_id AS operator_id_40, o6_.operator_id AS operator_id_41, f7_.discriminator AS discriminator_42, o8_.offer_id AS offer_id_43 FROM offers o2_ INNER JOIN dictionaries d3_ ON o2_.status_id = d3_.id AND d3_.discriminator IN ('offer_status') LEFT JOIN employees e4_ ON o2_.supervisor_id = e4_.id LEFT JOIN clients c5_ ON o2_.client_id = c5_.id LEFT JOIN organizations o6_ ON o2_.organization_id = o6_.id LEFT JOIN tasks t0_ ON (t0_.offer_id = o2_.id AND t0_.action_timestamp IS NULL) AND t0_.discriminator IN ('offer') LEFT JOIN offer_files o8_ ON o2_.id = o8_.offer_id LEFT JOIN files f7_ ON o8_.id = f7_.id LEFT JOIN notes n1_ ON (n1_.offer_id = o2_.id) AND n1_.discriminator IN ('offer') WHERE o2_.operator_id = ? AND (o2_.creation_timestamp >= ? AND o2_.creation_timestamp < ?) GROUP BY o2_.id, e4_.id, c5_.id, d3_.id, o6_.id, f7_.original_name, f7_.content_type, f7_.key, f7_.creation_timestamp, f7_.size, f7_.hash, f7_.encryption_key, f7_.encryption_iv, f7_.id, o8_.name, o8_.type, o8_.version, o8_.offer_id ORDER BY o2_.creation_timestamp DESC

[
  1
  "2026-01-01"
  "2027-01-01"
]

SELECT
  DISTINCT MIN(t0_.due_date) AS sclr_0,
  COUNT(n1_.id) AS sclr_1,
  o2_.creation_timestamp AS creation_timestamp_2,
  o2_.modification_timestamp AS modification_timestamp_3,
  o2_.inquiry AS inquiry_4,
  o2_.id AS id_5,
  o2_.version AS version_6,
  o2_.name AS name_7,
  d3_.code AS code_8,
  d3_.position AS position_9,
  d3_.id AS id_10,
  d3_.version AS version_11,
  d3_.name AS name_12,
  d3_.text_color AS text_color_13,
  d3_.text_background_color AS text_background_color_14,
  e4_.id AS id_15,
  e4_.first_name AS first_name_16,
  e4_.last_name AS last_name_17,
  c5_.id AS id_18,
  c5_.first_name AS first_name_19,
  c5_.last_name AS last_name_20,
  o6_.name AS name_21,
  o6_.short_name AS short_name_22,
  o6_.id AS id_23,
  f7_.original_name AS original_name_24,
  f7_.size AS size_25,
  f7_.hash AS hash_26,
  f7_.id AS id_27,
  o8_.type AS type_28,
  o2_.supervisor_id AS supervisor_id_29,
  o2_.client_id AS client_id_30,
  o2_.organization_id AS organization_id_31,
  o2_.creator_id AS creator_id_32,
  o2_.modifier_id AS modifier_id_33,
  o2_.status_id AS status_id_34,
  o2_.operator_id AS operator_id_35,
  d3_.discriminator AS discriminator_36,
  d3_.operator_id AS operator_id_37,
  e4_.operator_id AS operator_id_38,
  c5_.organization_id AS organization_id_39,
  c5_.operator_id AS operator_id_40,
  o6_.operator_id AS operator_id_41,
  f7_.discriminator AS discriminator_42,
  o8_.offer_id AS offer_id_43
FROM
  offers o2_
  INNER JOIN dictionaries d3_ ON o2_.status_id = d3_.id
  AND d3_.discriminator IN ('offer_status')
  LEFT JOIN employees e4_ ON o2_.supervisor_id = e4_.id
  LEFT JOIN clients c5_ ON o2_.client_id = c5_.id
  LEFT JOIN organizations o6_ ON o2_.organization_id = o6_.id
  LEFT JOIN tasks t0_ ON (
    t0_.offer_id = o2_.id
    AND t0_.action_timestamp IS NULL
  )
  AND t0_.discriminator IN ('offer')
  LEFT JOIN offer_files o8_ ON o2_.id = o8_.offer_id
  LEFT JOIN files f7_ ON o8_.id = f7_.id
  LEFT JOIN notes n1_ ON (n1_.offer_id = o2_.id)
  AND n1_.discriminator IN ('offer')
WHERE
  o2_.operator_id = ?
  AND (
    o2_.creation_timestamp >= ?
    AND o2_.creation_timestamp < ?
  )
GROUP BY
  o2_.id,
  e4_.id,
  c5_.id,
  d3_.id,
  o6_.id,
  f7_.original_name,
  f7_.content_type,
  f7_.key,
  f7_.creation_timestamp,
  f7_.size,
  f7_.hash,
  f7_.encryption_key,
  f7_.encryption_iv,
  f7_.id,
  o8_.name,
  o8_.type,
  o8_.version,
  o8_.offer_id
ORDER BY
  o2_.creation_timestamp DESC

SELECT DISTINCT MIN(t0_.due_date) AS sclr_0, COUNT(n1_.id) AS sclr_1, o2_.creation_timestamp AS creation_timestamp_2, o2_.modification_timestamp AS modification_timestamp_3, o2_.inquiry AS inquiry_4, o2_.id AS id_5, o2_.version AS version_6, o2_.name AS name_7, d3_.code AS code_8, d3_.position AS position_9, d3_.id AS id_10, d3_.version AS version_11, d3_.name AS name_12, d3_.text_color AS text_color_13, d3_.text_background_color AS text_background_color_14, e4_.id AS id_15, e4_.first_name AS first_name_16, e4_.last_name AS last_name_17, c5_.id AS id_18, c5_.first_name AS first_name_19, c5_.last_name AS last_name_20, o6_.name AS name_21, o6_.short_name AS short_name_22, o6_.id AS id_23, f7_.original_name AS original_name_24, f7_.size AS size_25, f7_.hash AS hash_26, f7_.id AS id_27, o8_.type AS type_28, o2_.supervisor_id AS supervisor_id_29, o2_.client_id AS client_id_30, o2_.organization_id AS organization_id_31, o2_.creator_id AS creator_id_32, o2_.modifier_id AS modifier_id_33, o2_.status_id AS status_id_34, o2_.operator_id AS operator_id_35, d3_.discriminator AS discriminator_36, d3_.operator_id AS operator_id_37, e4_.operator_id AS operator_id_38, c5_.organization_id AS organization_id_39, c5_.operator_id AS operator_id_40, o6_.operator_id AS operator_id_41, f7_.discriminator AS discriminator_42, o8_.offer_id AS offer_id_43 FROM offers o2_ INNER JOIN dictionaries d3_ ON o2_.status_id = d3_.id AND d3_.discriminator IN ('offer_status') LEFT JOIN employees e4_ ON o2_.supervisor_id = e4_.id LEFT JOIN clients c5_ ON o2_.client_id = c5_.id LEFT JOIN organizations o6_ ON o2_.organization_id = o6_.id LEFT JOIN tasks t0_ ON (t0_.offer_id = o2_.id AND t0_.action_timestamp IS NULL) AND t0_.discriminator IN ('offer') LEFT JOIN offer_files o8_ ON o2_.id = o8_.offer_id LEFT JOIN files f7_ ON o8_.id = f7_.id LEFT JOIN notes n1_ ON (n1_.offer_id = o2_.id) AND n1_.discriminator IN ('offer') WHERE o2_.operator_id = 1 AND (o2_.creation_timestamp >= '2026-01-01' AND o2_.creation_timestamp < '2027-01-01') GROUP BY o2_.id, e4_.id, c5_.id, d3_.id, o6_.id, f7_.original_name, f7_.content_type, f7_.key, f7_.creation_timestamp, f7_.size, f7_.hash, f7_.encryption_key, f7_.encryption_iv, f7_.id, o8_.name, o8_.type, o8_.version, o8_.offer_id ORDER BY o2_.creation_timestamp DESC;

SELECT t0.role AS role_1, t0.email AS email_2, t0.password AS password_3, t0.id AS id_4, t0.version AS version_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.operator_id AS operator_id_8 FROM employees t0 WHERE t0.email = ? LIMIT 1

[
  "teresa@fokus.waw.pl"
]

SELECT
  t0.role AS role_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.id AS id_4,
  t0.version AS version_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.operator_id AS operator_id_8
FROM
  employees t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.role AS role_1, t0.email AS email_2, t0.password AS password_3, t0.id AS id_4, t0.version AS version_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.operator_id AS operator_id_8 FROM employees t0 WHERE t0.email = 'teresa@fokus.waw.pl' LIMIT 1;