Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.domain AS domain_4,
  t0.path AS path_5,
  t0.locale AS locale_6,
  t0.amount AS amount_7,
  t0.currency AS currency_8,
  t0.type AS type_9,
  t0.status AS status_10,
  t0.custom_css AS custom_css_11,
  t0.background_image AS background_image_12,
  t0.header_image AS header_image_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  whitelabel_domain t0
WHERE
  t0.domain = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.domain AS domain_4, t0.path AS path_5, t0.locale AS locale_6, t0.amount AS amount_7, t0.currency AS currency_8, t0.type AS type_9, t0.status AS status_10, t0.custom_css AS custom_css_11, t0.background_image AS background_image_12, t0.header_image AS header_image_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM whitelabel_domain t0 WHERE t0.domain = 'metalica.zodii.ro' AND t0.status = 'active' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.resource_id AS resource_id_1,
  e0_.resource_type AS resource_type_2,
  e0_.type AS type_3,
  e0_.start_date AS start_date_4,
  e0_.end_date AS end_date_5,
  e0_.position AS position_6,
  e1_.id AS id_7,
  e1_.title AS title_8,
  e1_.slug AS slug_9,
  e1_.description AS description_10,
  e1_.photo AS photo_11,
  e1_.external_provider AS external_provider_12,
  e1_.external_identifier AS external_identifier_13,
  e1_.start_date AS start_date_14,
  e1_.end_date AS end_date_15,
  e1_.start_datetime AS start_datetime_16,
  e1_.status AS status_17,
  e1_.visibility AS visibility_18,
  e1_.promoting_date AS promoting_date_19,
  e1_.closed_at AS closed_at_20,
  e1_.sell_fee AS sell_fee_21,
  v2_.id AS id_22,
  v2_.name AS name_23,
  v2_.address AS address_24,
  v2_.phone AS phone_25,
  v2_.slug AS slug_26,
  v2_.lat AS lat_27,
  v2_.lng AS lng_28,
  v2_.photo AS photo_29,
  v2_.google_place_url AS google_place_url_30,
  v2_.website AS website_31,
  v2_.external_provider AS external_provider_32,
  v2_.external_identifier AS external_identifier_33,
  c3_.id AS id_34,
  c3_.name AS name_35,
  c3_.alternames AS alternames_36,
  c3_.canonical_name AS canonical_name_37,
  c3_.slug AS slug_38,
  c3_.lat AS lat_39,
  c3_.lng AS lng_40
FROM
  event_block_item e0_
  INNER JOIN event e1_ ON (e1_.id = e0_.resource_id)
  LEFT JOIN venue v2_ ON e1_.venue_id = v2_.id
  LEFT JOIN city c3_ ON v2_.city_id = c3_.id
WHERE
  e0_.type IN (?, ?)
  AND e0_.start_date < ?
  AND (
    e0_.end_date IS NULL
    OR e0_.end_date > ?
  )
  AND (
    e1_.end_date IS NULL
    OR e0_.end_date > ?
  )
ORDER BY
  e0_.position ASC

SELECT e0_.id AS id_0, e0_.resource_id AS resource_id_1, e0_.resource_type AS resource_type_2, e0_.type AS type_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.position AS position_6, e1_.id AS id_7, e1_.title AS title_8, e1_.slug AS slug_9, e1_.description AS description_10, e1_.photo AS photo_11, e1_.external_provider AS external_provider_12, e1_.external_identifier AS external_identifier_13, e1_.start_date AS start_date_14, e1_.end_date AS end_date_15, e1_.start_datetime AS start_datetime_16, e1_.status AS status_17, e1_.visibility AS visibility_18, e1_.promoting_date AS promoting_date_19, e1_.closed_at AS closed_at_20, e1_.sell_fee AS sell_fee_21, v2_.id AS id_22, v2_.name AS name_23, v2_.address AS address_24, v2_.phone AS phone_25, v2_.slug AS slug_26, v2_.lat AS lat_27, v2_.lng AS lng_28, v2_.photo AS photo_29, v2_.google_place_url AS google_place_url_30, v2_.website AS website_31, v2_.external_provider AS external_provider_32, v2_.external_identifier AS external_identifier_33, c3_.id AS id_34, c3_.name AS name_35, c3_.alternames AS alternames_36, c3_.canonical_name AS canonical_name_37, c3_.slug AS slug_38, c3_.lat AS lat_39, c3_.lng AS lng_40 FROM event_block_item e0_ INNER JOIN event e1_ ON (e1_.id = e0_.resource_id) LEFT JOIN venue v2_ ON e1_.venue_id = v2_.id LEFT JOIN city c3_ ON v2_.city_id = c3_.id WHERE e0_.type IN ('recommendation-by-ticket', 'recommendation-by-event') AND e0_.start_date < '2025-12-17 17:08:12' AND (e0_.end_date IS NULL OR e0_.end_date > '2025-12-17 17:08:12') AND (e1_.end_date IS NULL OR e0_.end_date > '2025-12-17 17:08:12') ORDER BY e0_.position ASC;

SELECT
  e0_.id AS id_0,
  e0_.resource_id AS resource_id_1,
  e0_.resource_type AS resource_type_2,
  e0_.type AS type_3,
  e0_.start_date AS start_date_4,
  e0_.end_date AS end_date_5,
  e0_.position AS position_6,
  'staticPage' AS sclr_7,
  e0_.id AS id_8,
  e0_.resource_id AS resource_id_9,
  e0_.resource_type AS resource_type_10,
  e0_.type AS type_11,
  e0_.start_date AS start_date_12,
  e0_.end_date AS end_date_13,
  e0_.position AS position_14,
  s1_.id AS id_15,
  s1_.name AS name_16,
  s1_.slug AS slug_17,
  s2_.id AS id_18,
  s2_.locale AS locale_19,
  s2_.title AS title_20,
  s2_.content AS content_21
FROM
  event_block_item e0_
  INNER JOIN static_page s1_ ON (s1_.id = e0_.resource_id)
  INNER JOIN static_page_trans s2_ ON s1_.id = s2_.static_page_id
WHERE
  e0_.type = ?
  AND e0_.start_date < ?
  AND (
    e0_.end_date IS NULL
    OR e0_.end_date > ?
  )
  AND s2_.locale = ?
ORDER BY
  e0_.position ASC

SELECT e0_.id AS id_0, e0_.resource_id AS resource_id_1, e0_.resource_type AS resource_type_2, e0_.type AS type_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.position AS position_6, 'staticPage' AS sclr_7, e0_.id AS id_8, e0_.resource_id AS resource_id_9, e0_.resource_type AS resource_type_10, e0_.type AS type_11, e0_.start_date AS start_date_12, e0_.end_date AS end_date_13, e0_.position AS position_14, s1_.id AS id_15, s1_.name AS name_16, s1_.slug AS slug_17, s2_.id AS id_18, s2_.locale AS locale_19, s2_.title AS title_20, s2_.content AS content_21 FROM event_block_item e0_ INNER JOIN static_page s1_ ON (s1_.id = e0_.resource_id) INNER JOIN static_page_trans s2_ ON s1_.id = s2_.static_page_id WHERE e0_.type = 'footer-helpful-links' AND e0_.start_date < '2025-12-17 17:08:12' AND (e0_.end_date IS NULL OR e0_.end_date > '2025-12-17 17:08:12') AND s2_.locale = 'ro' ORDER BY e0_.position ASC;

SELECT
  e0_.id AS id_0,
  e0_.resource_id AS resource_id_1,
  e0_.resource_type AS resource_type_2,
  e0_.type AS type_3,
  e0_.start_date AS start_date_4,
  e0_.end_date AS end_date_5,
  e0_.position AS position_6,
  'artist' AS sclr_7,
  e0_.id AS id_8,
  e0_.resource_id AS resource_id_9,
  e0_.resource_type AS resource_type_10,
  e0_.type AS type_11,
  e0_.start_date AS start_date_12,
  e0_.end_date AS end_date_13,
  e0_.position AS position_14,
  a1_.id AS id_15,
  a1_.name AS name_16,
  a1_.slug AS slug_17,
  a1_.summary AS summary_18,
  a1_.photo AS photo_19
FROM
  event_block_item e0_
  INNER JOIN artist a1_ ON (a1_.id = e0_.resource_id)
WHERE
  e0_.type = ?
  AND e0_.start_date < ?
  AND (
    e0_.end_date IS NULL
    OR e0_.end_date > ?
  )
ORDER BY
  e0_.position ASC

SELECT e0_.id AS id_0, e0_.resource_id AS resource_id_1, e0_.resource_type AS resource_type_2, e0_.type AS type_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.position AS position_6, 'artist' AS sclr_7, e0_.id AS id_8, e0_.resource_id AS resource_id_9, e0_.resource_type AS resource_type_10, e0_.type AS type_11, e0_.start_date AS start_date_12, e0_.end_date AS end_date_13, e0_.position AS position_14, a1_.id AS id_15, a1_.name AS name_16, a1_.slug AS slug_17, a1_.summary AS summary_18, a1_.photo AS photo_19 FROM event_block_item e0_ INNER JOIN artist a1_ ON (a1_.id = e0_.resource_id) WHERE e0_.type = 'footer' AND e0_.start_date < '2025-12-17 17:08:12' AND (e0_.end_date IS NULL OR e0_.end_date > '2025-12-17 17:08:12') ORDER BY e0_.position ASC;

SELECT
  e0_.id AS id_0,
  e0_.resource_id AS resource_id_1,
  e0_.resource_type AS resource_type_2,
  e0_.type AS type_3,
  e0_.start_date AS start_date_4,
  e0_.end_date AS end_date_5,
  e0_.position AS position_6,
  'staticPage' AS sclr_7,
  e0_.id AS id_8,
  e0_.resource_id AS resource_id_9,
  e0_.resource_type AS resource_type_10,
  e0_.type AS type_11,
  e0_.start_date AS start_date_12,
  e0_.end_date AS end_date_13,
  e0_.position AS position_14,
  s1_.id AS id_15,
  s1_.name AS name_16,
  s1_.slug AS slug_17,
  s2_.id AS id_18,
  s2_.locale AS locale_19,
  s2_.title AS title_20,
  s2_.content AS content_21
FROM
  event_block_item e0_
  INNER JOIN static_page s1_ ON (s1_.id = e0_.resource_id)
  INNER JOIN static_page_trans s2_ ON s1_.id = s2_.static_page_id
WHERE
  e0_.type = ?
  AND e0_.start_date < ?
  AND (
    e0_.end_date IS NULL
    OR e0_.end_date > ?
  )
  AND s2_.locale = ?
ORDER BY
  e0_.position ASC

SELECT e0_.id AS id_0, e0_.resource_id AS resource_id_1, e0_.resource_type AS resource_type_2, e0_.type AS type_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.position AS position_6, 'staticPage' AS sclr_7, e0_.id AS id_8, e0_.resource_id AS resource_id_9, e0_.resource_type AS resource_type_10, e0_.type AS type_11, e0_.start_date AS start_date_12, e0_.end_date AS end_date_13, e0_.position AS position_14, s1_.id AS id_15, s1_.name AS name_16, s1_.slug AS slug_17, s2_.id AS id_18, s2_.locale AS locale_19, s2_.title AS title_20, s2_.content AS content_21 FROM event_block_item e0_ INNER JOIN static_page s1_ ON (s1_.id = e0_.resource_id) INNER JOIN static_page_trans s2_ ON s1_.id = s2_.static_page_id WHERE e0_.type = 'footer-links' AND e0_.start_date < '2025-12-17 17:08:12' AND (e0_.end_date IS NULL OR e0_.end_date > '2025-12-17 17:08:12') AND s2_.locale = 'ro' ORDER BY e0_.position ASC;