Symfony Profiler

SELECT
  city.id as id,
  city.country_id as country_id
FROM
  city
  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 (?, ?, ?)
  )
  AND (city.domain = ?)
LIMIT
  1

SELECT city.id as id, city.country_id as country_id FROM city INNER JOIN event event ON city.id = event.city_id WHERE (event.status = 1) AND (event.event_date >= '2025-01-22') AND (event.available_to_sell = 1) AND (event.fm_status IN (0, 2, 3)) AND (city.domain = 'berezan.bavtest.net') 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 = ?
WHERE
  (
    (seo_data.city_id = ?)
    OR (
      seo_data.city_id is null
      AND seo_data.for_all_cities_status = 1
    )
  )
  AND (seo_data.category_id is null)
  AND (seo_data.month is null)
  AND (seo_data.tag_id is null)
ORDER BY
  city_id DESC
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 = 'en' WHERE ((seo_data.city_id='018eb296-04b4-7938-b0e6-838df34de361') OR (seo_data.city_id is null AND seo_data.for_all_cities_status=1)) AND (seo_data.category_id is null) AND (seo_data.month is null) AND (seo_data.tag_id is null) ORDER BY city_id DESC LIMIT 1;

SELECT
  category.id as id,
  category.external_id as external_id,
  category.slug as slug,
  category.status as status,
  category.position as position
FROM
  category
  INNER JOIN event_category event_category ON event_category.category_id = category.id
  INNER JOIN event event ON event.id = event_category.event_id
  INNER JOIN city city ON event.city_id = city.id
WHERE
  (category.status = ?)
  AND (category.use_in_filtration = 1)
  AND (event.status = ?)
  AND (event.fm_status = ?)
  AND (
    event.event_status IN (?)
  )
  AND (city.domain = ?)
GROUP BY
  category.id
ORDER BY
  category.position asc,
  category.slug asc

SELECT category.id as id, category.external_id as external_id, category.slug as slug, category.status as status, category.position as position FROM category INNER JOIN event_category event_category ON event_category.category_id = category.id INNER JOIN event event ON event.id = event_category.event_id INNER JOIN city city ON event.city_id = city.id WHERE (category.status = 1) AND (category.use_in_filtration = 1) AND (event.status = 1) AND (event.fm_status = 0) AND (event.event_status IN ('InStock')) AND (city.domain = 'berezan.bavtest.net') GROUP BY category.id ORDER BY category.position asc, category.slug asc;

SELECT
  count(*) as cnt
FROM
  (
    SELECT
      event.id as id,
      event.slug as slug,
      event.external_id as external_id,
      event.sticker_id,
      event.sticker_activity_time_from as sticker_activity_time_from,
      event.sticker_activity_time_to as sticker_activity_time_to,
      event.event_status as event_status,
      event.free_places as free_places,
      event.fm_status as fm_status,
      event.fm_id as fm_id,
      event.custom_link as custom_link,
      event.use_event_name as use_event_name,
      event.available_to_sell as available_to_sell,
      event.building_id as building_id,
      event.city_id as city_id,
      event.currency_id as currency_id,
      event.organization_id as organization_id,
      event.price_from as price_from,
      event.price_to as price_to,
      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_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
    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 = ?
    WHERE
      (event.status = ?)
      AND (
        event.fm_status IN (?, ?, ?, ?)
      )
      AND (event.city_id IS NOT NULL)
      AND (event.available_to_sell = 1)
      AND (event.free_places > 0)
      AND (event.price_from > 0)
      AND (
        event.event_status IN (?, ?, ?, ?, ?, ?, ?)
      )
      AND (event.sales_end_time >= ?)
      AND (
        event.city_id IN (?)
      )
      AND (event.sales_end_time >= ?)
  ) dbal_count_tbl

SELECT count(*) as cnt FROM (SELECT event.id as id, event.slug as slug, event.external_id as external_id, event.sticker_id, event.sticker_activity_time_from as sticker_activity_time_from, event.sticker_activity_time_to as sticker_activity_time_to, event.event_status as event_status, event.free_places as free_places, event.fm_status as fm_status, event.fm_id as fm_id, event.custom_link as custom_link, event.use_event_name as use_event_name, event.available_to_sell as available_to_sell, event.building_id as building_id, event.city_id as city_id, event.currency_id as currency_id, event.organization_id as organization_id, event.price_from as price_from, event.price_to as price_to, 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_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 FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'en' LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = 'en' WHERE (event.status = 1) AND (event.fm_status IN (0, 2, 3, 1)) AND (event.city_id IS NOT NULL) AND (event.available_to_sell = 1) AND (event.free_places > 0) AND (event.price_from > 0) AND (event.event_status IN ('Discontinued', 'InStock', 'LimitedAvailability', 'PreOrder', 'PreSale', 'Rescheduled', 'Cancelled')) AND (event.sales_end_time >= '2025-01-22 17:52:19') AND (event.city_id IN ('018eb296-04b4-7938-b0e6-838df34de361')) AND (event.sales_end_time >= '2025-01-22 15:52:19')) dbal_count_tbl;

SELECT
  event.id as id,
  event.slug as slug,
  event.external_id as external_id,
  event.sticker_id,
  event.sticker_activity_time_from as sticker_activity_time_from,
  event.sticker_activity_time_to as sticker_activity_time_to,
  event.event_status as event_status,
  event.free_places as free_places,
  event.fm_status as fm_status,
  event.fm_id as fm_id,
  event.custom_link as custom_link,
  event.use_event_name as use_event_name,
  event.available_to_sell as available_to_sell,
  event.building_id as building_id,
  event.city_id as city_id,
  event.currency_id as currency_id,
  event.organization_id as organization_id,
  event.price_from as price_from,
  event.price_to as price_to,
  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_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
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 = ?
WHERE
  (event.status = ?)
  AND (
    event.fm_status IN (?, ?, ?, ?)
  )
  AND (event.city_id IS NOT NULL)
  AND (event.available_to_sell = 1)
  AND (event.free_places > 0)
  AND (event.price_from > 0)
  AND (
    event.event_status IN (?, ?, ?, ?, ?, ?, ?)
  )
  AND (event.sales_end_time >= ?)
  AND (
    event.city_id IN (?)
  )
  AND (event.sales_end_time >= ?)
ORDER BY
  event_date asc
LIMIT
  30

SELECT event.id as id, event.slug as slug, event.external_id as external_id, event.sticker_id, event.sticker_activity_time_from as sticker_activity_time_from, event.sticker_activity_time_to as sticker_activity_time_to, event.event_status as event_status, event.free_places as free_places, event.fm_status as fm_status, event.fm_id as fm_id, event.custom_link as custom_link, event.use_event_name as use_event_name, event.available_to_sell as available_to_sell, event.building_id as building_id, event.city_id as city_id, event.currency_id as currency_id, event.organization_id as organization_id, event.price_from as price_from, event.price_to as price_to, 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_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 FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'en' LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = 'en' WHERE (event.status = 1) AND (event.fm_status IN (0, 2, 3, 1)) AND (event.city_id IS NOT NULL) AND (event.available_to_sell = 1) AND (event.free_places > 0) AND (event.price_from > 0) AND (event.event_status IN ('Discontinued', 'InStock', 'LimitedAvailability', 'PreOrder', 'PreSale', 'Rescheduled', 'Cancelled')) AND (event.sales_end_time >= '2025-01-22 17:52:19') AND (event.city_id IN ('018eb296-04b4-7938-b0e6-838df34de361')) AND (event.sales_end_time >= '2025-01-22 15:52:19') ORDER BY event_date asc LIMIT 30;

SELECT
  running_line.image_desktop,
  running_line.image_tablet,
  running_line.image_mobile,
  running_line.gtm_event,
  running_line.gtm_event_name,
  running_line.starts_at,
  running_line.finishes_at,
  running_line_lang.link
FROM
  running_line
  LEFT JOIN running_line_lang running_line_lang ON running_line_lang.model_id = running_line.id
  AND running_line_lang.language_code = ?
WHERE
  (running_line.starts_at <= ?)
  AND (running_line.finishes_at >= ?)
ORDER BY
  running_line.position asc
LIMIT
  100

SELECT running_line.image_desktop, running_line.image_tablet, running_line.image_mobile, running_line.gtm_event, running_line.gtm_event_name, running_line.starts_at, running_line.finishes_at, running_line_lang.link FROM running_line LEFT JOIN running_line_lang running_line_lang ON running_line_lang.model_id = running_line.id AND running_line_lang.language_code='en' WHERE (running_line.starts_at <= '2025-01-22 15:52:20') AND (running_line.finishes_at >= '2025-01-22 15:52:20') ORDER BY running_line.position asc LIMIT 100;