Symfony Profiler

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 = 'february' AND t0.status = 1 LIMIT 1;

SELECT
  count(*) as cnt
FROM
  (
    SELECT
      event.id as id,
      event.fm_id as fm_id,
      event.currency_id as currency_id,
      event.building_id as building_id,
      event.activity_id as activity_id,
      event.city_id as city_id,
      event.free_places as free_places,
      event.use_event_name as use_event_name,
      event.slug as slug,
      event.custom_link as custom_link,
      event.available_to_sell as available_to_sell,
      event.sticker_id as sticker_id,
      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.event_end_date as event_end_date,
      event.sales_end_time as sales_end_time,
      event_lang.name as name,
      event_lang.description as description,
      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,
      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.status = ?)
      AND (event.sales_end_time > ?)
      AND (
        (
          (
            event.event_date >= "2025-02-01 00:00:00"
            AND event.event_date <= "2025-02-28 23:59:59"
          )
        )
      )
  ) dbal_count_tbl

SELECT count(*) as cnt FROM (SELECT event.id as id, event.fm_id as fm_id, event.currency_id as currency_id, event.building_id as building_id, event.activity_id as activity_id, event.city_id as city_id, event.free_places as free_places, event.use_event_name as use_event_name, event.slug as slug, event.custom_link as custom_link, event.available_to_sell as available_to_sell, event.sticker_id as sticker_id, 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.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event_lang.description as description, 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, 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.status = 1) AND (event.sales_end_time > '2025-02-02 18:55:54') AND (((event.event_date >= "2025-02-01 00:00:00" AND event.event_date <= "2025-02-28 23:59:59")))) dbal_count_tbl;

SELECT
  event.id as id,
  event.fm_id as fm_id,
  event.currency_id as currency_id,
  event.building_id as building_id,
  event.activity_id as activity_id,
  event.city_id as city_id,
  event.free_places as free_places,
  event.use_event_name as use_event_name,
  event.slug as slug,
  event.custom_link as custom_link,
  event.available_to_sell as available_to_sell,
  event.sticker_id as sticker_id,
  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.event_end_date as event_end_date,
  event.sales_end_time as sales_end_time,
  event_lang.name as name,
  event_lang.description as description,
  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,
  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.status = ?)
  AND (event.sales_end_time > ?)
  AND (
    (
      (
        event.event_date >= "2025-02-01 00:00:00"
        AND event.event_date <= "2025-02-28 23:59:59"
      )
    )
  )
ORDER BY
  virtual_date asc,
  event_date asc
LIMIT
  100 OFFSET 300

SELECT event.id as id, event.fm_id as fm_id, event.currency_id as currency_id, event.building_id as building_id, event.activity_id as activity_id, event.city_id as city_id, event.free_places as free_places, event.use_event_name as use_event_name, event.slug as slug, event.custom_link as custom_link, event.available_to_sell as available_to_sell, event.sticker_id as sticker_id, 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.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event_lang.description as description, 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, 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.status = 1) AND (event.sales_end_time > '2025-02-02 18:55:54') AND (((event.event_date >= "2025-02-01 00:00:00" AND event.event_date <= "2025-02-28 23:59:59"))) ORDER BY virtual_date asc, event_date asc LIMIT 100 OFFSET 300;

SELECT
  sticker.id,
  sticker.text_color,
  sticker.back_color,
  sticker.activity_time_from,
  sticker.activity_time_to,
  sticker_lang.name as name,
  sticker_lang_default.name as default_name
FROM
  sticker
  LEFT JOIN sticker_lang sticker_lang ON sticker_lang.model_id = sticker.id
  AND sticker_lang.language_code = ?
  LEFT JOIN sticker_lang sticker_lang_default ON sticker_lang_default.model_id = sticker.id
  AND sticker_lang_default.language_code = ?
WHERE
  sticker.id = ?
LIMIT
  1

SELECT sticker.id, sticker.text_color, sticker.back_color, sticker.activity_time_from, sticker.activity_time_to, sticker_lang.name as name, sticker_lang_default.name as default_name FROM sticker LEFT JOIN sticker_lang sticker_lang ON sticker_lang.model_id = sticker.id AND sticker_lang.language_code = 'ua' LEFT JOIN sticker_lang sticker_lang_default ON sticker_lang_default.model_id = sticker.id AND sticker_lang_default.language_code = 'en' WHERE sticker.id = '018f5efb-675f-73c7-828a-a709d9dd1306' LIMIT 1;

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 ('019426ca-1f08-7b30-b889-e79ef0927723', '019426ca-1f21-7dfe-a4b6-369edb2f937d', '019426ca-1fad-72ac-be13-8f6b2927120c', '018ef0ae-16c5-763e-adb8-04e7578741d2', '019426ca-1fe7-79e5-97af-ec5f14262263', '019426ca-20e6-7b05-bb4a-993910cf9f8b', '019426ca-2101-7f2e-b8d6-44c6eabe9fa6', '019426ca-210a-7c0e-8aff-51223332b841', '019426ca-2117-7b14-a0c4-dc36de2b3b02', '019426ca-2148-7447-9a5c-34080356ea8a', '019426ca-2167-7572-ab72-8384a3700bfb', '019426ca-2188-7614-8866-5d1fb5e516d4', '019426ca-2194-7efa-8ebe-1e9f28e82c00', '019426ca-21c4-7f88-95ca-3f6cd51ae161', '019426ca-2229-7965-aa07-1b205f28fc28', '019426ca-2283-71ac-bb3d-94478929159f', '019426ca-228e-7eb9-a288-0b639d0465bb', '019426ca-22a8-7e75-9e41-d2237b517b81', '019426ca-22b4-71f7-be40-366090403cca', '019426ca-22c0-7152-85eb-d017d91126b2', '019426ca-230d-7b75-ba28-1074c5426aa2', '019426ca-232c-7fb8-bb1b-ca44d7b2b066');

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 ('019426ca-1ed3-7948-a17a-3b5d9a24ed65', '019426ca-1f08-7b30-b889-e79ef0927723', '019426ca-1f14-756a-b77d-16986bbb48a6', '019426ca-1fd9-7d2e-ba42-e1bb0b40ff18', '019426ca-20d9-7e8e-961c-611d19307c7b', '019426ca-21b3-72a5-95b7-47821f562116', '019426ca-2253-7159-9f33-346552718e1d');

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-1ed3-7948-a17a-3b5d9a24ed65' 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-1f08-7b30-b889-e79ef0927723');

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-1f08-7b30-b889-e79ef0927723' 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-1f14-756a-b77d-16986bbb48a6' 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-1fd9-7d2e-ba42-e1bb0b40ff18' 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-20d9-7e8e-961c-611d19307c7b' 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
  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-2167-7572-ab72-8384a3700bfb');

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-21b3-72a5-95b7-47821f562116' 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-21c4-7f88-95ca-3f6cd51ae161');

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;

SELECT
  seo_data.id as id,
  seo_data_lang.title,
  seo_data_lang.h1Seo,
  seo_data_lang.seo_text,
  seo_data_lang.description
FROM
  seo_data
  INNER JOIN seo_data_lang seo_data_lang ON seo_data_lang.model_id = seo_data.id
  AND seo_data_lang.language_code = ?
WHERE
  (
    (seo_data.city_id is null)
    OR (
      seo_data.for_all_cities_status = 1
    )
  )
  AND (seo_data.category_id is null)
  AND (
    seo_data.month in (?)
  )
  AND (seo_data.tag_id is null)
ORDER BY
  city_id ASC,
  month DESC
LIMIT
  1

SELECT seo_data.id as id, seo_data_lang.title, seo_data_lang.h1Seo, seo_data_lang.seo_text, seo_data_lang.description FROM seo_data INNER JOIN seo_data_lang seo_data_lang ON seo_data_lang.model_id = seo_data.id AND seo_data_lang.language_code = 'ua' WHERE ((seo_data.city_id is null) OR (seo_data.for_all_cities_status=1)) AND (seo_data.category_id is null) AND (seo_data.month in ('2')) AND (seo_data.tag_id is null) ORDER BY city_id ASC, month DESC LIMIT 1;