Symfony Profiler

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 = 'ru' 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 05:24:07') AND (event.sales_end_time >= '2025-01-23 03:24:07')) 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 = 'ru' 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 05:24:07') AND (event.sales_end_time >= '2025-01-23 03:24:07') ORDER BY event_date asc LIMIT 100;

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 = 'ru' 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 ='019426c9-aef7-7264-a8bd-0cdf8440ec7b' LIMIT 1;

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 = 'ru' 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 05:24:07') 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
  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 = 'ru' 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 05:24:07') 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
  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 = 'kherson.bavtest.net') 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 = '019426c9-af66-7661-9b05-263bc095b599');

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 = 'ru' 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,
      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 = 'ru' 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 05:24:07') AND (event.external_id IN ('018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-8e51-739e-8fa6-2fb61aab3749', '018eb282-a503-7fb7-8237-cd4d524e73c7'))) dbal_count_tbl;

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 = 'ru' 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 ('019426c9-aef7-7264-a8bd-0cdf8440ec7b', '019426c9-af06-7627-aced-3c2bcf0c5fc7', '019426c9-af23-72aa-85d5-c57fcbefd0c0', '019426c9-af55-7c3d-a832-cef03b20770f', '019426c9-b212-76dd-b285-84ad9ebe1fa9', '019426c9-b293-7b00-89b2-88c21094b670', '019426c9-b288-7449-b10a-7c0a592cd9fe', '019426c9-b2b1-7bd9-bc8a-2b945920f1d8', '019426c9-b2da-7c8d-9a90-a331b50c05fb', '019426c9-b3d6-7f45-8b79-6964a899be67', '019426c9-b3fc-7afb-ac24-3641696c0b55', '019426c9-b511-7974-a799-d7850d4e815e', '019426c9-b504-762b-b01e-71081d2406ca', '019426c9-b4ee-7b61-8460-7367e2279a76');

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 = 'ru' 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 05:24:07') 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;