Symfony Profiler

SELECT
  id
FROM
  building b
WHERE
  b.parent_id = ?

SELECT id FROM building b WHERE b.parent_id='018eb292-23b3-7a8a-8a32-69ab5d11cd4b';

SELECT
  event.id as id,
  event.fm_id as fm_id,
  event.city_id as city_id,
  event.building_id as building_id,
  event.activity_id as activity_id,
  event.currency_id as currency_id,
  event.slug as slug,
  event.sticker_id as sticker_id,
  event.use_event_name as use_event_name,
  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.free_places as free_places,
  event.event_end_date as event_end_date,
  event.sales_end_time as sales_end_time,
  event_lang.name as name,
  event.free_places as free_places,
  event.available_to_sell as available_to_sell,
  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,
  event.custom_link as custom_link,
  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 = ?
WHERE
  (event.sales_end_time > ?)
  AND (
    event.building_id IN (?)
  )
  AND (event.status = ?)
  AND (
    COALESCE(
      event.event_end_date, event.sales_end_time,
      event.event_date
    ) >= ?
  )
ORDER BY
  virtual_date asc,
  event_date asc

SELECT event.id as id, event.fm_id as fm_id, event.city_id as city_id, event.building_id as building_id, event.activity_id as activity_id, event.currency_id as currency_id, event.slug as slug, event.sticker_id as sticker_id, event.use_event_name as use_event_name, 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.free_places as free_places, event.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event.free_places as free_places, event.available_to_sell as available_to_sell, 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, event.custom_link as custom_link, 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' WHERE (event.sales_end_time > '2025-01-24 11:52:52') AND (event.building_id IN  ('018eb292-23b3-7a8a-8a32-69ab5d11cd4b')) AND (event.status = 1) AND (COALESCE(event.event_end_date, event.sales_end_time, event.event_date) >= '2025-01-24 09:01') ORDER BY virtual_date asc, event_date asc;

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 = 'ua' 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 ('019426c8-f0c3-7a71-bbfc-faf654e03370', '019426c9-e4e8-7ba3-b93e-10a7e3f224b4', '019426c8-f1f8-736f-9e9e-4c363d87b3bc', '019426c8-f258-76e1-ba53-d5200984b6cb', '019426c8-f2af-7730-8109-f86ffcc63aad', '019426c8-f2fb-7214-9535-fa405809ab87', '019426c8-f339-7bae-ac87-d3d02961d1c9', '019426ca-f0ad-74fb-8278-3e6121c6eda8', '019426ca-f3ac-7f00-82f2-8d5062e4d23a', '019426ca-c3cf-723f-a01d-140f333cd965', '019426ca-1f5a-7b94-8f5d-18c1ec022153', '019426ca-2070-756f-9ba9-f55b268da6b1', '019426ca-2148-7447-9a5c-34080356ea8a', '019426ca-2194-7efa-8ebe-1e9f28e82c00', '019426ca-2253-7159-9f33-346552718e1d', '019426ca-a933-7874-b3b7-01df3fa80cc7', '019426ca-aa5c-75a5-ae29-c7b9c07067bc', '019426ca-ac25-7adb-b4df-4f59ee465a49', '019426ca-aca5-77ae-b779-11e2fba226db', '019426ca-af56-7760-8f13-924fe6c7cd27', '01943aec-09b2-744e-9591-649613247a27', '01943aeb-5955-7c8d-a1a4-433939c8b944');

SELECT
  event_category.category_id as id,
  event_category.event_id as event_id
FROM
  event_category
WHERE
  event_category.event_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT event_category.category_id as id, event_category.event_id as event_id FROM event_category WHERE event_category.event_id IN ('019426c8-f0c3-7a71-bbfc-faf654e03370', '019426c9-e4e8-7ba3-b93e-10a7e3f224b4', '019426c8-f1f8-736f-9e9e-4c363d87b3bc', '019426c8-f258-76e1-ba53-d5200984b6cb', '019426c8-f2af-7730-8109-f86ffcc63aad', '019426c8-f2fb-7214-9535-fa405809ab87', '019426c8-f339-7bae-ac87-d3d02961d1c9', '019426ca-f0ad-74fb-8278-3e6121c6eda8', '019426ca-f3ac-7f00-82f2-8d5062e4d23a', '019426ca-c3cf-723f-a01d-140f333cd965', '019426ca-1f5a-7b94-8f5d-18c1ec022153', '019426ca-2070-756f-9ba9-f55b268da6b1', '019426ca-2148-7447-9a5c-34080356ea8a', '019426ca-2194-7efa-8ebe-1e9f28e82c00', '019426ca-a933-7874-b3b7-01df3fa80cc7', '019426ca-aa5c-75a5-ae29-c7b9c07067bc', '019426ca-ac25-7adb-b4df-4f59ee465a49', '019426ca-aca5-77ae-b779-11e2fba226db', '019426ca-af56-7760-8f13-924fe6c7cd27', '01943aec-09b2-744e-9591-649613247a27', '01943aeb-5955-7c8d-a1a4-433939c8b944');

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 = 'ua' 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 ='019426ca-1f5a-7b94-8f5d-18c1ec022153' 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 = ?
  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 = 'ua' 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 ='019426ca-2070-756f-9ba9-f55b268da6b1' LIMIT 1;

SELECT
  category.id as id
FROM
  category
  INNER JOIN event_category event_category ON event_category.category_id = category.id
WHERE
  (category.status = ?)
  AND (event_category.event_id = ?)

SELECT category.id as id FROM category INNER JOIN event_category event_category ON event_category.category_id = category.id WHERE (category.status = 1) AND (event_category.event_id = '019426ca-2148-7447-9a5c-34080356ea8a');

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 = 'ua' 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 ='019426ca-2253-7159-9f33-346552718e1d' LIMIT 1;