Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.requested_at AS requested_at_4, t0.status AS status_5, t0.reviewed_at AS reviewed_at_6, t0.requested_by_id AS requested_by_id_7, t0.reviewed_by_id AS reviewed_by_id_8 FROM request t0 WHERE t0.requested_by_id IS NULL

[]

SELECT
  t0.id AS id_1,
  t0.entity_type AS entity_type_2,
  t0.entity_id AS entity_id_3,
  t0.requested_at AS requested_at_4,
  t0.status AS status_5,
  t0.reviewed_at AS reviewed_at_6,
  t0.requested_by_id AS requested_by_id_7,
  t0.reviewed_by_id AS reviewed_by_id_8
FROM
  request t0
WHERE
  t0.requested_by_id IS NULL

SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.requested_at AS requested_at_4, t0.status AS status_5, t0.reviewed_at AS reviewed_at_6, t0.requested_by_id AS requested_by_id_7, t0.reviewed_by_id AS reviewed_by_id_8 FROM request t0 WHERE t0.requested_by_id IS NULL;

SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.requested_at AS requested_at_4, t0.status AS status_5, t0.reviewed_at AS reviewed_at_6, t0.requested_by_id AS requested_by_id_7, t0.reviewed_by_id AS reviewed_by_id_8 FROM request t0 WHERE t0.requested_by_id IS NULL

[]

SELECT
  t0.id AS id_1,
  t0.entity_type AS entity_type_2,
  t0.entity_id AS entity_id_3,
  t0.requested_at AS requested_at_4,
  t0.status AS status_5,
  t0.reviewed_at AS reviewed_at_6,
  t0.requested_by_id AS requested_by_id_7,
  t0.reviewed_by_id AS reviewed_by_id_8
FROM
  request t0
WHERE
  t0.requested_by_id IS NULL

SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.requested_at AS requested_at_4, t0.status AS status_5, t0.reviewed_at AS reviewed_at_6, t0.requested_by_id AS requested_by_id_7, t0.reviewed_by_id AS reviewed_by_id_8 FROM request t0 WHERE t0.requested_by_id IS NULL;

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.limit_amount_of_capitals AS limit_amount_of_capitals_4, t0.contract_rc AS contract_rc_5, t0.property_damage AS property_damage_6, t0.soft_deleted AS soft_deleted_7, t0.rate AS rate_8, t0.creator_user_id AS creator_user_id_9, t0.contact_person_id AS contact_person_id_10, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.phone AS phone_15, t11.email AS email_16, t11.job AS job_17, t0.accounting_person_id AS accounting_person_id_18, t19.id AS id_20, t19.firstname AS firstname_21, t19.lastname AS lastname_22, t19.phone AS phone_23, t19.email AS email_24, t19.job AS job_25, t0.logo_id AS logo_id_26, t27.id AS id_28, t27.original_name AS original_name_29, t27.filename AS filename_30, t27.path AS path_31, t27.comment AS comment_32, t27.description AS description_33, t27.created_at AS created_at_34, t27.author_id AS author_id_35 FROM company t0 INNER JOIN contact_person t11 ON t0.contact_person_id = t11.id LEFT JOIN contact_person t19 ON t0.accounting_person_id = t19.id LEFT JOIN uploaded_file t27 ON t0.logo_id = t27.id

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.comment AS comment_3,
  t0.limit_amount_of_capitals AS limit_amount_of_capitals_4,
  t0.contract_rc AS contract_rc_5,
  t0.property_damage AS property_damage_6,
  t0.soft_deleted AS soft_deleted_7,
  t0.rate AS rate_8,
  t0.creator_user_id AS creator_user_id_9,
  t0.contact_person_id AS contact_person_id_10,
  t11.id AS id_12,
  t11.firstname AS firstname_13,
  t11.lastname AS lastname_14,
  t11.phone AS phone_15,
  t11.email AS email_16,
  t11.job AS job_17,
  t0.accounting_person_id AS accounting_person_id_18,
  t19.id AS id_20,
  t19.firstname AS firstname_21,
  t19.lastname AS lastname_22,
  t19.phone AS phone_23,
  t19.email AS email_24,
  t19.job AS job_25,
  t0.logo_id AS logo_id_26,
  t27.id AS id_28,
  t27.original_name AS original_name_29,
  t27.filename AS filename_30,
  t27.path AS path_31,
  t27.comment AS comment_32,
  t27.description AS description_33,
  t27.created_at AS created_at_34,
  t27.author_id AS author_id_35
FROM
  company t0
  INNER JOIN contact_person t11 ON t0.contact_person_id = t11.id
  LEFT JOIN contact_person t19 ON t0.accounting_person_id = t19.id
  LEFT JOIN uploaded_file t27 ON t0.logo_id = t27.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.limit_amount_of_capitals AS limit_amount_of_capitals_4, t0.contract_rc AS contract_rc_5, t0.property_damage AS property_damage_6, t0.soft_deleted AS soft_deleted_7, t0.rate AS rate_8, t0.creator_user_id AS creator_user_id_9, t0.contact_person_id AS contact_person_id_10, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.phone AS phone_15, t11.email AS email_16, t11.job AS job_17, t0.accounting_person_id AS accounting_person_id_18, t19.id AS id_20, t19.firstname AS firstname_21, t19.lastname AS lastname_22, t19.phone AS phone_23, t19.email AS email_24, t19.job AS job_25, t0.logo_id AS logo_id_26, t27.id AS id_28, t27.original_name AS original_name_29, t27.filename AS filename_30, t27.path AS path_31, t27.comment AS comment_32, t27.description AS description_33, t27.created_at AS created_at_34, t27.author_id AS author_id_35 FROM company t0 INNER JOIN contact_person t11 ON t0.contact_person_id = t11.id LEFT JOIN contact_person t19 ON t0.accounting_person_id = t19.id LEFT JOIN uploaded_file t27 ON t0.logo_id = t27.id;

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE c0_.start <= ? AND (c0_.end IS NULL OR c0_.end >= ?) AND c0_.draft = 0

[
  "2025-04-02 06:24:59"
  "2025-04-02 06:24:59"
]

SELECT
  c0_.id AS id_0,
  c0_.start AS start_1,
  c0_.end AS end_2,
  c0_.number AS number_3,
  c0_.insurer AS insurer_4,
  c0_.draft AS draft_5,
  c0_.type AS type_6,
  c0_.office_id AS office_id_7
FROM
  contract c0_
WHERE
  c0_.start <= ?
  AND (
    c0_.end IS NULL
    OR c0_.end >= ?
  )
  AND c0_.draft = 0

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE c0_.start <= '2025-04-02 06:24:59' AND (c0_.end IS NULL OR c0_.end >= '2025-04-02 06:24:59') AND c0_.draft = 0;

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.number AS number_4, t0.insurer AS insurer_5, t0.draft AS draft_6, t0.type AS type_7, t0.office_id AS office_id_8 FROM contract t0 WHERE t0.draft = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.number AS number_4,
  t0.insurer AS insurer_5,
  t0.draft AS draft_6,
  t0.type AS type_7,
  t0.office_id AS office_id_8
FROM
  contract t0
WHERE
  t0.draft = ?

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.number AS number_4, t0.insurer AS insurer_5, t0.draft AS draft_6, t0.type AS type_7, t0.office_id AS office_id_8 FROM contract t0 WHERE t0.draft = 1;

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE (c0_.end IS NOT NULL AND c0_.end >= ?) AND c0_.draft = 0

[
  "2025-04-02 06:24:59"
]

SELECT
  c0_.id AS id_0,
  c0_.start AS start_1,
  c0_.end AS end_2,
  c0_.number AS number_3,
  c0_.insurer AS insurer_4,
  c0_.draft AS draft_5,
  c0_.type AS type_6,
  c0_.office_id AS office_id_7
FROM
  contract c0_
WHERE
  (
    c0_.end IS NOT NULL
    AND c0_.end >= ?
  )
  AND c0_.draft = 0

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE (c0_.end IS NOT NULL AND c0_.end >= '2025-04-02 06:24:59') AND c0_.draft = 0;