Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 86
• Events
• Routing
• Cache
• Translation 5
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT e0_.id AS id_0, e0_.date_created AS date_created_1, e0_.date_changed AS date_changed_2, e0_.active AS active_3, e0_.name AS name_4, e0_.remark AS remark_5, l1_.id AS id_6, l1_.date_created AS date_created_7, l1_.date_changed AS date_changed_8, l1_.active AS active_9, l1_.name AS name_10, l1_.label AS label_11, l1_.color AS color_12, l1_.status AS status_13, l1_.oib AS oib_14, l1_.address AS address_15, l1_.place AS place_16, l1_.county AS county_17, l1_.country AS country_18, l1_.contact_phone AS contact_phone_19, l1_.contact_email AS contact_email_20, l1_.web_page AS web_page_21, l1_.additional_data AS additional_data_22, l1_.is_pdv AS is_pdv_23, l1_.iban AS iban_24, l1_.longitude AS longitude_25, l1_.latitude AS latitude_26, l1_.image AS image_27, e0_.user_created AS user_created_28, e0_.user_changed AS user_changed_29, e0_.LegalPerson AS LegalPerson_30, l1_.user_created AS user_created_31, l1_.user_changed AS user_changed_32, l1_.legal_entity AS legal_entity_33 FROM event e0_ INNER JOIN legal_person l1_ ON e0_.LegalPerson = l1_.id WHERE e0_.active = ? GROUP BY e0_.id, l1_.id

[
  1
]

SELECT
  e0_.id AS id_0,
  e0_.date_created AS date_created_1,
  e0_.date_changed AS date_changed_2,
  e0_.active AS active_3,
  e0_.name AS name_4,
  e0_.remark AS remark_5,
  l1_.id AS id_6,
  l1_.date_created AS date_created_7,
  l1_.date_changed AS date_changed_8,
  l1_.active AS active_9,
  l1_.name AS name_10,
  l1_.label AS label_11,
  l1_.color AS color_12,
  l1_.status AS status_13,
  l1_.oib AS oib_14,
  l1_.address AS address_15,
  l1_.place AS place_16,
  l1_.county AS county_17,
  l1_.country AS country_18,
  l1_.contact_phone AS contact_phone_19,
  l1_.contact_email AS contact_email_20,
  l1_.web_page AS web_page_21,
  l1_.additional_data AS additional_data_22,
  l1_.is_pdv AS is_pdv_23,
  l1_.iban AS iban_24,
  l1_.longitude AS longitude_25,
  l1_.latitude AS latitude_26,
  l1_.image AS image_27,
  e0_.user_created AS user_created_28,
  e0_.user_changed AS user_changed_29,
  e0_.LegalPerson AS LegalPerson_30,
  l1_.user_created AS user_created_31,
  l1_.user_changed AS user_changed_32,
  l1_.legal_entity AS legal_entity_33
FROM
  event e0_
  INNER JOIN legal_person l1_ ON e0_.LegalPerson = l1_.id
WHERE
  e0_.active = ?
GROUP BY
  e0_.id,
  l1_.id

SELECT e0_.id AS id_0, e0_.date_created AS date_created_1, e0_.date_changed AS date_changed_2, e0_.active AS active_3, e0_.name AS name_4, e0_.remark AS remark_5, l1_.id AS id_6, l1_.date_created AS date_created_7, l1_.date_changed AS date_changed_8, l1_.active AS active_9, l1_.name AS name_10, l1_.label AS label_11, l1_.color AS color_12, l1_.status AS status_13, l1_.oib AS oib_14, l1_.address AS address_15, l1_.place AS place_16, l1_.county AS county_17, l1_.country AS country_18, l1_.contact_phone AS contact_phone_19, l1_.contact_email AS contact_email_20, l1_.web_page AS web_page_21, l1_.additional_data AS additional_data_22, l1_.is_pdv AS is_pdv_23, l1_.iban AS iban_24, l1_.longitude AS longitude_25, l1_.latitude AS latitude_26, l1_.image AS image_27, e0_.user_created AS user_created_28, e0_.user_changed AS user_changed_29, e0_.LegalPerson AS LegalPerson_30, l1_.user_created AS user_created_31, l1_.user_changed AS user_changed_32, l1_.legal_entity AS legal_entity_33 FROM event e0_ INNER JOIN legal_person l1_ ON e0_.LegalPerson = l1_.id WHERE e0_.active = 1 GROUP BY e0_.id, l1_.id;

SELECT u0_.first_name AS first_name_0, u0_.id AS id_1, u0_.last_name AS last_name_2, r1_.reservation_start AS reservation_start_3, r1_.reservation_end AS reservation_end_4, r1_.description AS description_5, r1_.name AS name_6, s2_.name AS name_7, b3_.address AS address_8, b3_.place AS place_9, r1_.implementation_status AS implementation_status_10, s2_.maximum_number_of_participants AS maximum_number_of_participants_11, sum(CASE WHEN r4_.participant = ? AND r4_.status = ? THEN 1 ELSE 0 END) AS sclr_12, sum(CASE WHEN r4_.participant = ? AND r4_.status = ? THEN 1 ELSE 0 END) AS sclr_13, sum(CASE WHEN r4_.participant = ? AND r4_.status = ? THEN 1 ELSE 0 END) AS sclr_14, sum(CASE WHEN r4_.participant = ? AND r4_.status = ? THEN 1 ELSE 0 END) AS sclr_15, sum(CASE WHEN r4_.status = ? THEN 1 ELSE 0 END) AS sclr_16, s2_.id AS id_17, r1_.id AS id_18 FROM reservation r1_ INNER JOIN user u0_ ON r1_.user_created = u0_.id LEFT JOIN reservation_legal_person_event r5_ ON r1_.id = r5_.reservation LEFT JOIN event e6_ ON r5_.event = e6_.id LEFT JOIN space_room s2_ ON r1_.spaceRoom = s2_.id LEFT JOIN reservation_participant r4_ ON r1_.id = r4_.reservation LEFT JOIN user u7_ ON r4_.participant = u7_.id LEFT JOIN building_space b8_ ON s2_.buildingSpace = b8_.id LEFT JOIN building b3_ ON b8_.building = b3_.id LEFT JOIN reservation_service r9_ ON r1_.id = r9_.reservation LEFT JOIN price_list_item p10_ ON r9_.PriceListItem = p10_.id LEFT JOIN service s11_ ON p10_.service = s11_.id WHERE e6_.name LIKE ? AND r1_.name LIKE ? AND r1_.active = ? AND r1_.implementation_status = ? AND r1_.reservation_type = ? AND r1_.application_type = ? AND r1_.reservation_start > ? GROUP BY r1_.id

[
  0
  "REGISTERED"
  0
  "SINGED_OUT"
  0
  "REJECTED"
  0
  "NOT_SHOW_UP"
  "REGISTERED"
  "%%"
  "%%"
  1
  "RESERVED"
  "WITH_PARTICIPANTS"
  "OPEN"
  "2026-03-01 10:20:08"
]

SELECT
  u0_.first_name AS first_name_0,
  u0_.id AS id_1,
  u0_.last_name AS last_name_2,
  r1_.reservation_start AS reservation_start_3,
  r1_.reservation_end AS reservation_end_4,
  r1_.description AS description_5,
  r1_.name AS name_6,
  s2_.name AS name_7,
  b3_.address AS address_8,
  b3_.place AS place_9,
  r1_.implementation_status AS implementation_status_10,
  s2_.maximum_number_of_participants AS maximum_number_of_participants_11,
  sum(
    CASE WHEN r4_.participant = ?
    AND r4_.status = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_12,
  sum(
    CASE WHEN r4_.participant = ?
    AND r4_.status = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_13,
  sum(
    CASE WHEN r4_.participant = ?
    AND r4_.status = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_14,
  sum(
    CASE WHEN r4_.participant = ?
    AND r4_.status = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_15,
  sum(
    CASE WHEN r4_.status = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_16,
  s2_.id AS id_17,
  r1_.id AS id_18
FROM
  reservation r1_
  INNER JOIN user u0_ ON r1_.user_created = u0_.id
  LEFT JOIN reservation_legal_person_event r5_ ON r1_.id = r5_.reservation
  LEFT JOIN event e6_ ON r5_.event = e6_.id
  LEFT JOIN space_room s2_ ON r1_.spaceRoom = s2_.id
  LEFT JOIN reservation_participant r4_ ON r1_.id = r4_.reservation
  LEFT JOIN user u7_ ON r4_.participant = u7_.id
  LEFT JOIN building_space b8_ ON s2_.buildingSpace = b8_.id
  LEFT JOIN building b3_ ON b8_.building = b3_.id
  LEFT JOIN reservation_service r9_ ON r1_.id = r9_.reservation
  LEFT JOIN price_list_item p10_ ON r9_.PriceListItem = p10_.id
  LEFT JOIN service s11_ ON p10_.service = s11_.id
WHERE
  e6_.name LIKE ?
  AND r1_.name LIKE ?
  AND r1_.active = ?
  AND r1_.implementation_status = ?
  AND r1_.reservation_type = ?
  AND r1_.application_type = ?
  AND r1_.reservation_start > ?
GROUP BY
  r1_.id

SELECT u0_.first_name AS first_name_0, u0_.id AS id_1, u0_.last_name AS last_name_2, r1_.reservation_start AS reservation_start_3, r1_.reservation_end AS reservation_end_4, r1_.description AS description_5, r1_.name AS name_6, s2_.name AS name_7, b3_.address AS address_8, b3_.place AS place_9, r1_.implementation_status AS implementation_status_10, s2_.maximum_number_of_participants AS maximum_number_of_participants_11, sum(CASE WHEN r4_.participant = 0 AND r4_.status = 'REGISTERED' THEN 1 ELSE 0 END) AS sclr_12, sum(CASE WHEN r4_.participant = 0 AND r4_.status = 'SINGED_OUT' THEN 1 ELSE 0 END) AS sclr_13, sum(CASE WHEN r4_.participant = 0 AND r4_.status = 'REJECTED' THEN 1 ELSE 0 END) AS sclr_14, sum(CASE WHEN r4_.participant = 0 AND r4_.status = 'NOT_SHOW_UP' THEN 1 ELSE 0 END) AS sclr_15, sum(CASE WHEN r4_.status = 'REGISTERED' THEN 1 ELSE 0 END) AS sclr_16, s2_.id AS id_17, r1_.id AS id_18 FROM reservation r1_ INNER JOIN user u0_ ON r1_.user_created = u0_.id LEFT JOIN reservation_legal_person_event r5_ ON r1_.id = r5_.reservation LEFT JOIN event e6_ ON r5_.event = e6_.id LEFT JOIN space_room s2_ ON r1_.spaceRoom = s2_.id LEFT JOIN reservation_participant r4_ ON r1_.id = r4_.reservation LEFT JOIN user u7_ ON r4_.participant = u7_.id LEFT JOIN building_space b8_ ON s2_.buildingSpace = b8_.id LEFT JOIN building b3_ ON b8_.building = b3_.id LEFT JOIN reservation_service r9_ ON r1_.id = r9_.reservation LEFT JOIN price_list_item p10_ ON r9_.PriceListItem = p10_.id LEFT JOIN service s11_ ON p10_.service = s11_.id WHERE e6_.name LIKE '%%' AND r1_.name LIKE '%%' AND r1_.active = 1 AND r1_.implementation_status = 'RESERVED' AND r1_.reservation_type = 'WITH_PARTICIPANTS' AND r1_.application_type = 'OPEN' AND r1_.reservation_start > '2026-03-01 10:20:08' GROUP BY r1_.id;