Symfony Profiler

SELECT
  count(*) as cnt
FROM
  (
    SELECT
      event.id as id,
      event.slug as slug,
      event.event_status as event_status,
      event.fm_status as fm_status,
      event.fm_id as fm_id,
      event.price_from as price_from,
      event.city_id as city_id,
      event.building_id as building_id,
      event.activity_id as activity_id,
      event.last_status_updated_at as last_status_updated_at,
      event.currency_id as currency_id,
      event.use_event_name as use_event_name,
      event.price_to as price_to,
      event.event_date as event_date,
      event.event_old_date as event_old_date,
      event.event_new_date as event_new_date,
      event.event_end_date as event_end_date,
      event_lang.name as event_name,
      event_lang_default.name as default_event_name,
      event_lang.status_tooltip as status_tooltip,
      event.image_big as image_big,
      event.image_medium as image_medium,
      event.image_large as image_large,
      event.image_small as image_small,
      event.legal_id as legal_id,
      legal.name as legal_name,
      organization.name as organization_name,
      legal.edrpou as legal_edrpou
    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 legal legal ON legal.id = event.legal_id
      LEFT JOIN organization organization ON organization.id = event.organization_id
    WHERE
      (event.status = ?)
      AND (
        event.fm_status IN (?, ?, ?)
      )
      AND (
        (
          event_lang.name like '%%'
          OR event_lang_default.name like '%%'
          OR event_date like '%%'
          OR event_new_date like '%%'
          OR legal.name like '%%'
          OR organization.name like '%%'
          OR legal.edrpou like '%%'
        )
      )
  ) dbal_count_tbl

SELECT count(*) as cnt FROM (SELECT event.id as id, event.slug as slug, event.event_status as event_status, event.fm_status as fm_status, event.fm_id as fm_id, event.price_from as price_from, event.city_id as city_id, event.building_id as building_id, event.activity_id as activity_id, event.last_status_updated_at as last_status_updated_at, event.currency_id as currency_id, event.use_event_name as use_event_name, event.price_to as price_to, event.event_date as event_date, event.event_old_date as event_old_date, event.event_new_date as event_new_date, event.event_end_date as event_end_date, event_lang.name as event_name, event_lang_default.name as default_event_name, event_lang.status_tooltip as status_tooltip, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, event.legal_id as legal_id, legal.name as legal_name, organization.name as organization_name, legal.edrpou as legal_edrpou 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' LEFT JOIN legal legal ON legal.id = event.legal_id LEFT JOIN organization organization ON organization.id = event.organization_id WHERE (event.status = 1) AND (event.fm_status IN (2, 1, 3)) AND ((event_lang.name like '%%' OR event_lang_default.name like '%%' OR event_date like '%%' OR event_new_date like '%%' OR legal.name like '%%' OR organization.name like '%%' OR legal.edrpou like '%%'))) dbal_count_tbl;

SELECT
  event.id as id,
  event.slug as slug,
  event.event_status as event_status,
  event.fm_status as fm_status,
  event.fm_id as fm_id,
  event.price_from as price_from,
  event.city_id as city_id,
  event.building_id as building_id,
  event.activity_id as activity_id,
  event.last_status_updated_at as last_status_updated_at,
  event.currency_id as currency_id,
  event.use_event_name as use_event_name,
  event.price_to as price_to,
  event.event_date as event_date,
  event.event_old_date as event_old_date,
  event.event_new_date as event_new_date,
  event.event_end_date as event_end_date,
  event_lang.name as event_name,
  event_lang_default.name as default_event_name,
  event_lang.status_tooltip as status_tooltip,
  event.image_big as image_big,
  event.image_medium as image_medium,
  event.image_large as image_large,
  event.image_small as image_small,
  event.legal_id as legal_id,
  legal.name as legal_name,
  organization.name as organization_name,
  legal.edrpou as legal_edrpou
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 legal legal ON legal.id = event.legal_id
  LEFT JOIN organization organization ON organization.id = event.organization_id
WHERE
  (event.status = ?)
  AND (
    event.fm_status IN (?, ?, ?)
  )
  AND (
    (
      event_lang.name like '%%'
      OR event_lang_default.name like '%%'
      OR event_date like '%%'
      OR event_new_date like '%%'
      OR legal.name like '%%'
      OR organization.name like '%%'
      OR legal.edrpou like '%%'
    )
  )
ORDER BY
  event.last_status_updated_at desc
LIMIT
  10 OFFSET 3770

SELECT event.id as id, event.slug as slug, event.event_status as event_status, event.fm_status as fm_status, event.fm_id as fm_id, event.price_from as price_from, event.city_id as city_id, event.building_id as building_id, event.activity_id as activity_id, event.last_status_updated_at as last_status_updated_at, event.currency_id as currency_id, event.use_event_name as use_event_name, event.price_to as price_to, event.event_date as event_date, event.event_old_date as event_old_date, event.event_new_date as event_new_date, event.event_end_date as event_end_date, event_lang.name as event_name, event_lang_default.name as default_event_name, event_lang.status_tooltip as status_tooltip, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, event.legal_id as legal_id, legal.name as legal_name, organization.name as organization_name, legal.edrpou as legal_edrpou 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' LEFT JOIN legal legal ON legal.id = event.legal_id LEFT JOIN organization organization ON organization.id = event.organization_id WHERE (event.status = 1) AND (event.fm_status IN (2, 1, 3)) AND ((event_lang.name like '%%' OR event_lang_default.name like '%%' OR event_date like '%%' OR event_new_date like '%%' OR legal.name like '%%' OR organization.name like '%%' OR legal.edrpou like '%%')) ORDER BY event.last_status_updated_at desc LIMIT 10 OFFSET 3770;

SELECT
  building.id as id,
  building.slug as slug,
  building.parent_id as parent_id,
  building.zipcode as zipcode,
  building.external_id as external_id,
  building.city_id as city_id,
  building.latitude as latitude,
  building.longitude as longitude,
  building_lang.name as name,
  building_lang.address as address,
  building_lang.short_name as short_name,
  building_lang.description as description,
  building_lang.language_code as lang_code,
  building_lang_default.name as default_name,
  building_lang_default.address as default_address,
  building_lang_default.short_name as default_short_name,
  building_lang_default.description as default_description,
  building_lang_default.language_code as default_lang_code
FROM
  building
  LEFT JOIN building_lang building_lang ON building_lang.model_id = building.id
  AND building_lang.language_code = ?
  LEFT JOIN building_lang building_lang_default ON building_lang_default.model_id = building.id
  AND building_lang_default.language_code = ?
WHERE
  (building.status = ?)
  AND (building.city_id IS NOT NULL)

SELECT building.id as id, building.slug as slug, building.parent_id as parent_id, building.zipcode as zipcode, building.external_id as external_id, building.city_id as city_id, building.latitude as latitude, building.longitude as longitude, building_lang.name as name, building_lang.address as address, building_lang.short_name as short_name, building_lang.description as description, building_lang.language_code as lang_code, building_lang_default.name as default_name, building_lang_default.address as default_address, building_lang_default.short_name as default_short_name, building_lang_default.description as default_description, building_lang_default.language_code as default_lang_code FROM building LEFT JOIN building_lang building_lang ON building_lang.model_id = building.id AND building_lang.language_code = 'en' LEFT JOIN building_lang building_lang_default ON building_lang_default.model_id = building.id AND building_lang_default.language_code = 'en' WHERE (building.status = 1) AND (building.city_id IS NOT NULL);

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 = 'en' 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-03-06') 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
  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,
  country.id as country_id,
  country_lang.name as country_name,
  country_lang_default.name as default_country_name
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 = ?
  LEFT JOIN country country ON country.id = city.country_id
  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 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, country.id as country_id, country_lang.name as country_name, country_lang_default.name as default_country_name FROM city LEFT JOIN city_lang city_lang ON city_lang.model_id = city.id AND city_lang.language_code = 'en' LEFT JOIN city_lang city_lang_default ON city_lang_default.model_id = city.id AND city_lang_default.language_code = 'en' LEFT JOIN country country ON country.id = city.country_id LEFT JOIN country_lang country_lang ON country_lang.model_id = country.id AND country_lang.language_code = 'en' LEFT JOIN country_lang country_lang_default ON country_lang_default.model_id = country.id AND country_lang_default.language_code = 'en';

SELECT
  category.id as id,
  category.slug as slug,
  category.external_id as external_id,
  category.schema_name as schema_name,
  category_lang.name as name,
  category_lang.color as color,
  category_lang.name_for_afisha as name_for_afisha,
  category_lang.name_for_event as name_for_event,
  category_lang.name_multiple as name_multiple,
  category_lang.name_single as name_single,
  category_lang_default.name as default_name,
  category_lang_default.name_for_afisha as default_name_for_afisha,
  category_lang_default.name_for_event as default_name_for_event,
  category_lang_default.name_multiple as default_name_multiple,
  category_lang_default.name_single as default_name_single,
  category.category_style_id,
  category.sticker_id,
  category_style.header_background_color as category_style_header_background_color,
  category_style.header_background_transparency as category_style_header_background_transparency,
  category_style.header_dark_fonts_color as category_style_header_dark_fonts_color,
  category_style.header_dark_fonts_color_hover as category_style_header_dark_fonts_color_hover,
  category_style.header_logo as category_style_header_logo,
  category_style.footer_background_color as category_style_footer_background_color,
  category_style.footer_background_transparency as category_style_footer_background_transparency,
  category_style.footer_fonts_color as category_style_footer_fonts_color,
  category_style.footer_fonts_color_hover as category_style_footer_fonts_color_hover,
  category_style.footer_logo as category_style_footer_logo,
  category.sticker_activity_time_from as sticker_activity_time_from,
  category.sticker_activity_time_to as sticker_activity_time_to,
  category_lang.sticker_description as sticker_description,
  category_lang_default.sticker_description as default_sticker_description
FROM
  category
  LEFT JOIN category_lang category_lang ON category_lang.model_id = category.id
  AND category_lang.language_code = ?
  LEFT JOIN category_lang category_lang_default ON category_lang_default.model_id = category.id
  AND category_lang_default.language_code = ?
  LEFT JOIN category_style category_style ON category_style.id = category.category_style_id
  AND category_style.published = ?
WHERE
  category.status = ?

SELECT category.id as id, category.slug as slug, category.external_id as external_id, category.schema_name as schema_name, category_lang.name as name, category_lang.color as color, category_lang.name_for_afisha as name_for_afisha, category_lang.name_for_event as name_for_event, category_lang.name_multiple as name_multiple, category_lang.name_single as name_single, category_lang_default.name as default_name, category_lang_default.name_for_afisha as default_name_for_afisha, category_lang_default.name_for_event as default_name_for_event, category_lang_default.name_multiple as default_name_multiple, category_lang_default.name_single as default_name_single, category.category_style_id, category.sticker_id, category_style.header_background_color as category_style_header_background_color, category_style.header_background_transparency as category_style_header_background_transparency, category_style.header_dark_fonts_color as category_style_header_dark_fonts_color, category_style.header_dark_fonts_color_hover as category_style_header_dark_fonts_color_hover, category_style.header_logo as category_style_header_logo, category_style.footer_background_color as category_style_footer_background_color, category_style.footer_background_transparency as category_style_footer_background_transparency, category_style.footer_fonts_color as category_style_footer_fonts_color, category_style.footer_fonts_color_hover as category_style_footer_fonts_color_hover, category_style.footer_logo as category_style_footer_logo, category.sticker_activity_time_from as sticker_activity_time_from, category.sticker_activity_time_to as sticker_activity_time_to, category_lang.sticker_description as sticker_description, category_lang_default.sticker_description as default_sticker_description FROM category LEFT JOIN category_lang category_lang ON category_lang.model_id = category.id AND category_lang.language_code = 'en' LEFT JOIN category_lang category_lang_default ON category_lang_default.model_id = category.id AND category_lang_default.language_code = 'en' LEFT JOIN category_style category_style ON category_style.id = category.category_style_id AND category_style.published = 1 WHERE category.status = 1;

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 = 'en' LEFT JOIN country_lang country_lang_default ON country_lang_default.model_id = country.id AND country_lang_default.language_code = 'en';

SELECT
  activity.id as id,
  activity.external_id as external_id,
  activity.sticker_id as sticker_id,
  activity.sticker_activity_time_from as sticker_activity_time_from,
  activity.sticker_activity_time_to as sticker_activity_time_to,
  activity_lang.name as name,
  activity_lang.description as description,
  activity_lang_default.name as default_name,
  activity_lang_default.description as default_description,
  activity_lang.sticker_description as sticker_description,
  activity_lang_default.sticker_description as default_sticker_description,
  event.id as event_id
FROM
  activity
  LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id
  AND activity_lang.language_code = ?
  LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id
  AND activity_lang_default.language_code = ?
  INNER JOIN event event ON event.activity_id = activity.id
WHERE
  event.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = 'en' LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = 'en' INNER JOIN event event ON event.activity_id = activity.id WHERE event.id IN ('018ef094-a98b-72bb-a47d-c3f3261fdbc0', '018ef094-a997-7f40-8ebe-1a7e334019a3', '018ef094-a9be-73d6-b18c-26ec3fcbd275', '018ef094-a9ee-7e7d-8707-66cd5f2544c9', '018ef094-aa21-71a2-aec4-192b9c850550', '018ef094-aa33-7c49-9664-f34398954200', '018ef094-aa69-7fba-a712-0cfc6b93ec2a', '018ef094-aa7c-7aae-b21f-aa5c1a063171', '018ef094-aa8d-7627-99ce-93be21033c15', '018ef094-aab2-74c6-9242-ed934acc3b18');

SELECT
  activity.id as id,
  activity.external_id as external_id,
  activity.sticker_id as sticker_id,
  activity.sticker_activity_time_from as sticker_activity_time_from,
  activity.sticker_activity_time_to as sticker_activity_time_to,
  activity_lang.name as name,
  activity_lang.description as description,
  activity_lang_default.name as default_name,
  activity_lang_default.description as default_description,
  activity_lang.sticker_description as sticker_description,
  activity_lang_default.sticker_description as default_sticker_description,
  event.id as event_id
FROM
  activity
  LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id
  AND activity_lang.language_code = ?
  LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id
  AND activity_lang_default.language_code = ?
  INNER JOIN event event ON event.activity_id = activity.id
WHERE
  event.id = ?
LIMIT
  1

SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = 'en' LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = 'en' INNER JOIN event event ON event.activity_id = activity.id WHERE event.id ='018ef094-aa8d-7627-99ce-93be21033c15' 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 = ?
  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 = 'info' AND t0.status = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language_code AS language_code_2,
  t0.title AS title_3,
  t0.canonical AS canonical_4,
  t0.seo_title AS seo_title_5,
  t0.seo_image AS seo_image_6,
  t0.seo_description AS seo_description_7,
  t0.seo_keywords AS seo_keywords_8,
  t0.model_id AS model_id_9
FROM
  page_lang t0
WHERE
  t0.model_id = ?

SELECT t0.id AS id_1, t0.language_code AS language_code_2, t0.title AS title_3, t0.canonical AS canonical_4, t0.seo_title AS seo_title_5, t0.seo_image AS seo_image_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.model_id AS model_id_9 FROM page_lang t0 WHERE t0.model_id = '018b472e-d8e1-77a1-97df-861acfe708ed';