Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.external_id AS external_id_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.is_index AS is_index_7,
  t0.css AS css_8,
  t0.js_head AS js_head_9,
  t0.js_body_start AS js_body_start_10,
  t0.js_body_end AS js_body_end_11
FROM
  page t0
WHERE
  t0.slug = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.external_id AS external_id_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_index AS is_index_7, t0.css AS css_8, t0.js_head AS js_head_9, t0.js_body_start AS js_body_start_10, t0.js_body_end AS js_body_end_11 FROM page t0 WHERE t0.slug = 'tag=albatrosi' AND t0.status = 1 LIMIT 1;

SELECT
  tag.id as id,
  tag.slug as slug,
  tag.external_id as external_id,
  tag_lang.name as name,
  tag.is_artist as is_artist,
  tag.image as image,
  tag_lang.name_in_low as name_in_low,
  tag_lang.name_in_single_low as name_in_single_low,
  tag_lang.name_low as name_low,
  tag_lang_default.name as default_name,
  tag_lang_default.name_in_low as default_name_in_low,
  tag_lang_default.name_in_single_low as default_name_in_single_low,
  tag_lang_default.name_low as default_name_low
FROM
  tag
  LEFT JOIN tag_lang tag_lang ON tag_lang.model_id = tag.id
  AND tag_lang.language_code = ?
  LEFT JOIN tag_lang tag_lang_default ON tag_lang_default.model_id = tag.id
  AND tag_lang_default.language_code = ?
WHERE
  tag.status = ?
ORDER BY
  name ASC

SELECT tag.id as id, tag.slug as slug, tag.external_id as external_id, tag_lang.name as name, tag.is_artist as is_artist, tag.image as image, tag_lang.name_in_low as name_in_low, tag_lang.name_in_single_low as name_in_single_low, tag_lang.name_low as name_low, tag_lang_default.name as default_name, tag_lang_default.name_in_low as default_name_in_low, tag_lang_default.name_in_single_low as default_name_in_single_low, tag_lang_default.name_low as default_name_low FROM tag LEFT JOIN tag_lang tag_lang ON tag_lang.model_id = tag.id AND tag_lang.language_code = 'ua' LEFT JOIN tag_lang tag_lang_default ON tag_lang_default.model_id = tag.id AND tag_lang_default.language_code = 'en' WHERE tag.status = 1 ORDER BY name ASC;

SELECT
  count(*) as cnt
FROM
  (
    SELECT
      event.id as id,
      event.fm_id as fm_id,
      event.currency_id as currency_id,
      event.building_id as building_id,
      event.activity_id as activity_id,
      event.city_id as city_id,
      event.free_places as free_places,
      event.use_event_name as use_event_name,
      event.slug as slug,
      event.custom_link as custom_link,
      event.available_to_sell as available_to_sell,
      event.sticker_id as sticker_id,
      event.sticker_activity_time_from as sticker_activity_time_from,
      event.sticker_activity_time_to as sticker_activity_time_to,
      event.price_from as price_from,
      event.price_to as price_to,
      event.event_status as event_status,
      event.fm_status as fm_status,
      event.event_date as event_date,
      event.event_end_date as event_end_date,
      event.sales_end_time as sales_end_time,
      event_lang.name as name,
      event_lang.description as description,
      event_lang_default.name as default_name,
      event.image_big as image_big,
      event.image_medium as image_medium,
      event.image_large as image_large,
      event.image_small as image_small,
      CASE WHEN event.event_date <= CURRENT_DATE
      AND (
        event.event_end_date >= CURRENT_DATE
        OR event.event_end_date IS NULL
      ) THEN CURRENT_DATE WHEN (
        event.event_end_date > CURRENT_DATE
        OR event.event_date < CURRENT_DATE
        OR event.event_end_date IS NULL
      ) THEN COALESCE(
        event.event_end_date, event.event_date
      ) END AS virtual_date
    FROM
      event
      LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id
      AND event_lang.language_code = ?
      LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id
      AND event_lang_default.language_code = ?
      LEFT JOIN event_tag event_tag ON event_tag.event_id = event.id
      LEFT JOIN activity_tag activity_tag ON activity_tag.activity_id = event.activity_id
    WHERE
      (event.status = ?)
      AND (event.sales_end_time > ?)
      AND (
        COALESCE(
          activity_tag.tag_id, event_tag.tag_id
        ) = ?
      )
  ) dbal_count_tbl

SELECT count(*) as cnt FROM (SELECT event.id as id, event.fm_id as fm_id, event.currency_id as currency_id, event.building_id as building_id, event.activity_id as activity_id, event.city_id as city_id, event.free_places as free_places, event.use_event_name as use_event_name, event.slug as slug, event.custom_link as custom_link, event.available_to_sell as available_to_sell, event.sticker_id as sticker_id, event.sticker_activity_time_from as sticker_activity_time_from, event.sticker_activity_time_to as sticker_activity_time_to, event.price_from as price_from, event.price_to as price_to, event.event_status as event_status, event.fm_status as fm_status, event.event_date as event_date, event.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event_lang.description as description, event_lang_default.name as default_name, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, CASE
               WHEN event.event_date <= CURRENT_DATE AND (event.event_end_date >= CURRENT_DATE OR event.event_end_date IS NULL) THEN CURRENT_DATE
               WHEN (event.event_end_date > CURRENT_DATE OR event.event_date < CURRENT_DATE OR event.event_end_date IS NULL) THEN COALESCE(event.event_end_date, event.event_date)
            END AS virtual_date FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'ua' LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = 'en' LEFT JOIN event_tag event_tag ON event_tag.event_id = event.id LEFT JOIN activity_tag activity_tag ON activity_tag.activity_id = event.activity_id WHERE (event.status = 1) AND (event.sales_end_time > '2025-05-13 12:41:30') AND (COALESCE(activity_tag.tag_id, event_tag.tag_id) = '018eb761-7acd-7f88-b5eb-d96f7cf7792d')) dbal_count_tbl;

SELECT
  seo_data.id as id,
  seo_data_lang.title,
  seo_data_lang.h1Seo,
  seo_data_lang.seo_text,
  seo_data_lang.description
FROM
  seo_data
  INNER JOIN seo_data_lang seo_data_lang ON seo_data_lang.model_id = seo_data.id
  AND seo_data_lang.language_code = ?
WHERE
  (
    (seo_data.tag_id = ?)
    AND (seo_data.category_id is NULL)
    AND (seo_data.month is NULL)
    AND (
      seo_data.city_id is null
      and seo_data.month is NULL
      and seo_data.category_id is NULL
    )
  )
  OR (
    seo_data.for_all_cities_status = 1
    and seo_data.month is NULL
    and seo_data.category_id is NULL
    and seo_data.tag_id = ?
  )
ORDER BY
  tag_id DESC,
  city_id ASC
LIMIT
  1

SELECT seo_data.id as id, seo_data_lang.title, seo_data_lang.h1Seo, seo_data_lang.seo_text, seo_data_lang.description FROM seo_data INNER JOIN seo_data_lang seo_data_lang ON seo_data_lang.model_id = seo_data.id AND seo_data_lang.language_code = 'ua' WHERE ((seo_data.tag_id = '018eb761-7acd-7f88-b5eb-d96f7cf7792d') AND (seo_data.category_id is NULL) AND (seo_data.month is NULL) AND (seo_data.city_id is null and seo_data.month is NULL and seo_data.category_id is NULL)) OR (seo_data.for_all_cities_status=1 and  seo_data.month is NULL and seo_data.category_id is NULL and seo_data.tag_id = '018eb761-7acd-7f88-b5eb-d96f7cf7792d') ORDER BY tag_id DESC, city_id ASC LIMIT 1;

SELECT
  DISTINCT city.id as id,
  city.domain as domain,
  city.external_id as external_id,
  city.updated_at as updated_at,
  city.country_id as country_id,
  city.position as position,
  city_lang.name as name,
  city_lang.canonical as canonical,
  city_lang.seo_image as seo_image,
  city_lang.seo_title as seo_title,
  city_lang.seo_description as seo_description,
  city_lang.prepositional as prepositional,
  city_lang.language_code as lang_code,
  city_lang_default.name as default_name,
  city_lang_default.prepositional as default_prepositional,
  city_lang_default.language_code as default_lang_code
FROM
  city
  LEFT JOIN city_lang city_lang ON city_lang.model_id = city.id
  AND city_lang.language_code = ?
  LEFT JOIN city_lang city_lang_default ON city_lang_default.model_id = city.id
  AND city_lang_default.language_code = ?
  INNER JOIN event event ON city.id = event.city_id
WHERE
  (event.status = ?)
  AND (event.event_date >= ?)
  AND (event.available_to_sell = 1)
  AND (
    event.fm_status IN (?, ?, ?)
  )
ORDER BY
  - position desc,
  COALESCE(
    city_lang.name, city_lang_default.name
  ) asc

SELECT DISTINCT city.id as id, city.domain as domain, city.external_id as external_id, city.updated_at as updated_at, city.country_id as country_id, city.position as position, city_lang.name as name, city_lang.canonical as canonical, city_lang.seo_image as seo_image, city_lang.seo_title as seo_title, city_lang.seo_description as seo_description, city_lang.prepositional as prepositional, city_lang.language_code as lang_code, city_lang_default.name as default_name, city_lang_default.prepositional as default_prepositional, city_lang_default.language_code as default_lang_code FROM city LEFT JOIN city_lang city_lang ON city_lang.model_id = city.id AND city_lang.language_code = 'ua' LEFT JOIN city_lang city_lang_default ON city_lang_default.model_id = city.id AND city_lang_default.language_code = 'en' INNER JOIN event event ON city.id = event.city_id WHERE (event.status = 1) AND (event.event_date >= '2025-05-13') AND (event.available_to_sell = 1) AND (event.fm_status IN (0, 2, 3)) ORDER BY -position desc, COALESCE(city_lang.name, city_lang_default.name) asc;

SELECT
  country.id as id,
  country.domain as domain,
  country.external_id as external_id,
  country.position as position,
  country.iso_code as iso_code,
  country.icon as icon,
  country.menu_label as menu_label,
  country.show_on_footer_menu as show_on_footer_menu,
  country_lang.name as name,
  country_lang.language_code as lang_code,
  country_lang_default.name as default_name
FROM
  country
  LEFT JOIN country_lang country_lang ON country_lang.model_id = country.id
  AND country_lang.language_code = ?
  LEFT JOIN country_lang country_lang_default ON country_lang_default.model_id = country.id
  AND country_lang_default.language_code = ?

SELECT country.id as id, country.domain as domain, country.external_id as external_id, country.position as position, country.iso_code as iso_code, country.icon as icon, country.menu_label as menu_label, country.show_on_footer_menu as show_on_footer_menu, country_lang.name as name, country_lang.language_code as lang_code, country_lang_default.name as default_name FROM country LEFT JOIN country_lang country_lang ON country_lang.model_id = country.id AND country_lang.language_code = 'ua' LEFT JOIN country_lang country_lang_default ON country_lang_default.model_id = country.id AND country_lang_default.language_code = 'en';