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-23') AND (event.available_to_sell = 1) AND (event.fm_status IN (0, 2, 3)) AND (city.domain = 'magdalinivka.bavtest.net') 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 = 'home' 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 = '018c1b5a-75e2-729c-a97a-85bb87f49fc2';

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,
      FIELD(
        event.external_id, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      ) as eventOrder
    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.external_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      )
  ) 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, FIELD(event.external_id, '018ebcc6-1ee2-72d1-a37c-a5f11ff7af41', '018eb282-bcad-772b-aea5-d48b5e379014', '018eb282-bd3d-754e-8651-de51e09fe1b2', '018eb282-e8fe-706f-a787-7bb2661ba206', '018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-a503-7fb7-8237-cd4d524e73c7', '018eb282-bc4d-7664-8fd5-5ff6f7cc9c01', '018eb282-be75-73e0-806b-f128a8c92bf4', '018eb282-de95-7b8a-a599-ed6487c3d640', '018eb282-e542-72e7-9575-109c702cb72f', '018ebcc6-2866-75e3-ac03-bbca98cb2a2f') as eventOrder FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'uk' 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-23 19:25:06') AND (event.external_id IN ('018ebcc6-1ee2-72d1-a37c-a5f11ff7af41', '018eb282-bcad-772b-aea5-d48b5e379014', '018eb282-bd3d-754e-8651-de51e09fe1b2', '018eb282-e8fe-706f-a787-7bb2661ba206', '018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-a503-7fb7-8237-cd4d524e73c7', '018eb282-bc4d-7664-8fd5-5ff6f7cc9c01', '018eb282-be75-73e0-806b-f128a8c92bf4', '018eb282-de95-7b8a-a599-ed6487c3d640', '018eb282-e542-72e7-9575-109c702cb72f', '018ebcc6-2866-75e3-ac03-bbca98cb2a2f'))) 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,
  FIELD(
    event.external_id, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  ) as eventOrder
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.external_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
ORDER BY
  eventOrder asc
LIMIT
  100

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, FIELD(event.external_id, '018ebcc6-1ee2-72d1-a37c-a5f11ff7af41', '018eb282-bcad-772b-aea5-d48b5e379014', '018eb282-bd3d-754e-8651-de51e09fe1b2', '018eb282-e8fe-706f-a787-7bb2661ba206', '018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-a503-7fb7-8237-cd4d524e73c7', '018eb282-bc4d-7664-8fd5-5ff6f7cc9c01', '018eb282-be75-73e0-806b-f128a8c92bf4', '018eb282-de95-7b8a-a599-ed6487c3d640', '018eb282-e542-72e7-9575-109c702cb72f', '018ebcc6-2866-75e3-ac03-bbca98cb2a2f') as eventOrder FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'uk' 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-23 19:25:06') AND (event.external_id IN ('018ebcc6-1ee2-72d1-a37c-a5f11ff7af41', '018eb282-bcad-772b-aea5-d48b5e379014', '018eb282-bd3d-754e-8651-de51e09fe1b2', '018eb282-e8fe-706f-a787-7bb2661ba206', '018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-a503-7fb7-8237-cd4d524e73c7', '018eb282-bc4d-7664-8fd5-5ff6f7cc9c01', '018eb282-be75-73e0-806b-f128a8c92bf4', '018eb282-de95-7b8a-a599-ed6487c3d640', '018eb282-e542-72e7-9575-109c702cb72f', '018ebcc6-2866-75e3-ac03-bbca98cb2a2f')) ORDER BY eventOrder asc LIMIT 100;

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 ('018ec7d1-dac8-7668-ac2b-181aa660a94e');

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,
      FIELD(
        event.external_id, ?, ?, ?, ?, ?, ?, ?,
        ?
      ) as eventOrder
    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.external_id IN (?, ?, ?, ?, ?, ?, ?, ?)
      )
  ) 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, FIELD(event.external_id, '018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-8e51-739e-8fa6-2fb61aab3749', '018eb282-a503-7fb7-8237-cd4d524e73c7', '018eb282-bc4d-7664-8fd5-5ff6f7cc9c01', '01902f6d-8543-78bc-a8ed-f0a237ee4ce2', '01902f6d-85bd-7525-ae7d-ee65a2d07d2b', '01902f6d-86c5-7370-8557-fe7166e65555', '01902f6d-874a-78dc-a54c-780b8a17b864') as eventOrder FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'uk' 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-23 19:25:06') AND (event.external_id IN ('018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-8e51-739e-8fa6-2fb61aab3749', '018eb282-a503-7fb7-8237-cd4d524e73c7', '018eb282-bc4d-7664-8fd5-5ff6f7cc9c01', '01902f6d-8543-78bc-a8ed-f0a237ee4ce2', '01902f6d-85bd-7525-ae7d-ee65a2d07d2b', '01902f6d-86c5-7370-8557-fe7166e65555', '01902f6d-874a-78dc-a54c-780b8a17b864'))) 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,
      FIELD(event.external_id, ?, ?, ?) as eventOrder
    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.external_id IN (?, ?, ?)
      )
  ) 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, FIELD(event.external_id, '018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-8e51-739e-8fa6-2fb61aab3749', '018eb282-a503-7fb7-8237-cd4d524e73c7') as eventOrder FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = 'uk' 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-23 19:25:06') AND (event.external_id IN ('018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-8e51-739e-8fa6-2fb61aab3749', '018eb282-a503-7fb7-8237-cd4d524e73c7'))) dbal_count_tbl;

SELECT
  city.id as city_id,
  city_lang.name as city_name,
  city_lang_default.name as default_city_name,
  city_lang.prepositional as city_prepositional,
  city_lang_default.name as default_city_prepositional
FROM
  cash_desk
  INNER JOIN city city ON city.id = cash_desk.city_id
  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 = ?
WHERE
  cash_desk.published_status = ?
GROUP BY
  city.id

SELECT city.id as city_id, city_lang.name as city_name, city_lang_default.name as default_city_name, city_lang.prepositional as city_prepositional, city_lang_default.name as default_city_prepositional FROM cash_desk INNER JOIN city city ON city.id = cash_desk.city_id LEFT JOIN city_lang city_lang ON city_lang.model_id = city.id AND city_lang.language_code = 'uk' LEFT JOIN city_lang city_lang_default ON city_lang_default.model_id = city.id AND city_lang_default.language_code = 'en' WHERE cash_desk.published_status = 1 GROUP BY city.id;

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.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 = 'uk' 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-23 19:25:06') AND (event.sales_end_time >= '2025-01-23 17:25:06')) 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.sales_end_time >= ?)
ORDER BY
  event_date asc
LIMIT
  100

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 = 'uk' 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-23 19:25:06') AND (event.sales_end_time >= '2025-01-23 17:25:06') ORDER BY event_date asc LIMIT 100;

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 ('019426c9-ada2-7390-9be4-f2af5f402c1c', '019426c9-aee1-7ac1-8b2a-2c1be6937af1', '0191eb24-6e65-7f68-8bf5-aa2a66c95167', '019426c9-aef7-7264-a8bd-0cdf8440ec7b', '019426c9-af06-7627-aced-3c2bcf0c5fc7', '019426c9-af14-7e1d-9ee0-0458bca6b8fe', '019426c9-af23-72aa-85d5-c57fcbefd0c0', '019426c9-af31-7ded-a0b6-3a63663d8ff5', '019426c9-af44-7f69-a8d8-8d19d4f07b2e', '019426c9-af55-7c3d-a832-cef03b20770f', '019426c9-af71-7d31-90f4-7567db33e466', '019426c9-af66-7661-9b05-263bc095b599', '019426c9-af7f-7a5e-b04f-ebf1702e34e8', '019426c9-af8a-77b3-adc2-1c7b17b5670b', '019426c9-afa3-769e-b8f8-09b1d6dcc342', '019426c9-afb0-7bb4-b222-7d1a3e4a91f6', '019426c9-afc1-7430-b898-5083fea7f6cc', '019426c9-b05c-710d-90a3-eecb7d662d1a', '019426c9-b04f-782b-885c-6fcb3aec97dc', '019426c9-b0ee-7a42-a00d-0b3a94c28ecb', '019426c9-b00a-7084-bcbd-47f493134be2', '019426c9-b0d1-75fb-900e-f294a7d61164', '019426c9-b246-7dfc-9eea-7e5bafecb782', '019426c9-b212-76dd-b285-84ad9ebe1fa9', '019426c9-b26e-7cb7-98ae-547cba91410d', '019426c9-b0c1-7a6e-bfb6-72e41307703c', '019426c9-b03f-7cd8-8e31-a4ddbdc290dd', '019426c9-b0b0-7934-b6ec-b0fdea1376fd', '019426c9-afe7-7303-848b-f16f827626b4', '019426c9-aff6-7bce-9158-61c38e701d69', '019426c9-b0a1-7678-b151-558d607f8ef0', '019426c9-b0df-73ea-a9ff-cf368c1e760e', '019426c9-b0fc-7eb0-b997-4f00b96057dc', '019426c9-b133-798f-b19f-adf7cb05fb6f', '019426c9-b10d-7cb3-9b48-901c6fedeff9', '019426c9-b155-711d-b867-3c01c9c7a8e3', '019426c9-b1aa-748d-938b-94e939087c40', '019426c9-b230-774d-86eb-c32e8d84790d', '019426c9-b090-7369-9c92-76126d86bac1', '019426c9-b081-7a4b-a496-e129a08eac12', '019426c9-b032-7fa2-8c8d-dc643eaf1973', '019426c9-b020-74df-8b6f-1af46e8eba57', '019426c9-b25a-71ee-9522-3d9d17716fc0', '019426c9-b06e-75f9-b1fe-706d67838dd3', '019426c9-b293-7b00-89b2-88c21094b670', '019426c9-b288-7449-b10a-7c0a592cd9fe', '019426c9-b2a1-7e34-bd0c-5d3d5270b0a8', '019426c9-b2b1-7bd9-bc8a-2b945920f1d8', '019426c9-b27c-7f39-a5cc-54684a65fd66', '019426c9-b2f3-7d4f-928c-ec7352ef9fa2', '019426c9-b30f-79ae-8b14-af2c3a0a6109', '019426c9-b2da-7c8d-9a90-a331b50c05fb', '019426c9-b32b-7b03-9b84-5436e9403bd4', '019426c9-b31f-77a2-a0b2-bb73a1e0d7c2', '019426c9-b301-7917-8775-5b5a95691c21', '019426c9-b2e6-7fa9-9db0-c13a40a323d6', '019426c9-b33c-7a1a-83cc-6a2030b21209', '019426c9-b38d-7dba-9e18-188d1653e290', '019426c9-b37d-75a6-bc2d-25370f6e573b', '019426c9-b3d6-7f45-8b79-6964a899be67', '019426c9-b3fc-7afb-ac24-3641696c0b55', '019426c9-b483-7156-88f0-b71c0126a738', '019426c9-b440-7518-9138-544dce216d54', '019426c9-b431-7827-b039-41bfbc9669e9', '019426c9-b421-7d43-80a4-67996dc7b399', '019426c9-b415-7edd-be2d-def2d6b784de', '019426c9-b408-7f6d-b968-9a5b5541a3ab', '019426c9-b3ee-7da6-b56e-f897550100a7', '019426c9-b4a4-7086-b224-5e4ed435181c', '019426c9-b496-7b0e-adfe-a21759f2a9d7', '019426c9-b4d2-7be9-b8c8-7575a9ad26c8', '019426c9-b4c4-7f66-a5aa-e72a0a725f53', '019426c9-b4b6-7f63-87cf-6fce6ce03c6a', '019426c9-b52f-7c45-a5f1-c0261683739d', '019426c9-b520-72e5-bcbc-2e7eb2b04e31', '019426c9-b511-7974-a799-d7850d4e815e', '019426c9-b504-762b-b01e-71081d2406ca', '019426c9-b4ee-7b61-8460-7367e2279a76', '019426c9-b569-7a01-b96e-ca62c22552b8', '019426c9-b5d1-7640-8b6c-8a350c17ecd9', '019426c9-b5c2-73e2-9b66-4623f10f209b', '019426c9-b5b6-75a4-b709-8e1958941dd0', '019426c9-b5a9-7d60-91c7-cc19377586eb', '019426c9-b599-7624-875f-d85308ce5b3d', '019426c9-b58b-7422-ace5-5ec87da54971', '019426c9-b57b-7359-9d04-af4e5422661b', '019426c9-b55a-7372-a833-fe797723d992', '019426c9-b548-7c9f-aff9-3901e8872463', '019426c9-b53a-730a-85d9-25b7862c6369', '0191eb0d-a061-7d15-91f9-6086064b941f');