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 = 'pan-kots-kyy-6' AND t0.status = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.free_places AS free_places_3,
  t0.event_date AS event_date_4,
  t0.event_new_date AS event_new_date_5,
  t0.event_end_date AS event_end_date_6,
  t0.event_old_date AS event_old_date_7,
  t0.external_id AS external_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.has_certificates AS has_certificates_11,
  t0.replace_activity_description AS replace_activity_description_12,
  t0.reserve_end_time AS reserve_end_time_13,
  t0.sales_end_time AS sales_end_time_14,
  t0.price_from AS price_from_15,
  t0.price_to AS price_to_16,
  t0.image_small AS image_small_17,
  t0.image_medium AS image_medium_18,
  t0.image_big AS image_big_19,
  t0.image_large AS image_large_20,
  t0.css AS css_21,
  t0.js_body_end AS js_body_end_22,
  t0.js_body_start AS js_body_start_23,
  t0.js_head AS js_head_24,
  t0.status AS status_25,
  t0.fm_status AS fm_status_26,
  t0.event_status AS event_status_27,
  t0.fm_id AS fm_id_28,
  t0.available_to_sell AS available_to_sell_29,
  t0.use_event_name AS use_event_name_30,
  t0.custom_link AS custom_link_31,
  t0.sticker_activity_time_from AS sticker_activity_time_from_32,
  t0.sticker_activity_time_to AS sticker_activity_time_to_33,
  t0.last_status_updated_at AS last_status_updated_at_34,
  t0.currency_id AS currency_id_35,
  t0.activity_id AS activity_id_36,
  t37.id AS id_38,
  t37.slug AS slug_39,
  t37.status AS status_40,
  t37.external_id AS external_id_41,
  t37.created_at AS created_at_42,
  t37.updated_at AS updated_at_43,
  t37.image_gallery AS image_gallery_44,
  t37.video_gallery AS video_gallery_45,
  t37.youtube_video_gallery AS youtube_video_gallery_46,
  t37.sticker_activity_time_from AS sticker_activity_time_from_47,
  t37.sticker_activity_time_to AS sticker_activity_time_to_48,
  t37.sticker_id AS sticker_id_49,
  t0.city_id AS city_id_50,
  t0.building_id AS building_id_51,
  t0.sticker_id AS sticker_id_52,
  t53.id AS id_54,
  t53.external_id AS external_id_55,
  t53.sticker_order AS sticker_order_56,
  t53.back_color AS back_color_57,
  t53.text_color AS text_color_58,
  t53.activity_time_from AS activity_time_from_59,
  t53.activity_time_to AS activity_time_to_60,
  t53.created_at AS created_at_61,
  t53.updated_at AS updated_at_62,
  t0.hall_id AS hall_id_63,
  t0.organization_id AS organization_id_64,
  t0.legal_id AS legal_id_65
FROM
  event t0
  LEFT JOIN activity t37 ON t0.activity_id = t37.id
  LEFT JOIN sticker t53 ON t0.sticker_id = t53.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.free_places AS free_places_3, t0.event_date AS event_date_4, t0.event_new_date AS event_new_date_5, t0.event_end_date AS event_end_date_6, t0.event_old_date AS event_old_date_7, t0.external_id AS external_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.has_certificates AS has_certificates_11, t0.replace_activity_description AS replace_activity_description_12, t0.reserve_end_time AS reserve_end_time_13, t0.sales_end_time AS sales_end_time_14, t0.price_from AS price_from_15, t0.price_to AS price_to_16, t0.image_small AS image_small_17, t0.image_medium AS image_medium_18, t0.image_big AS image_big_19, t0.image_large AS image_large_20, t0.css AS css_21, t0.js_body_end AS js_body_end_22, t0.js_body_start AS js_body_start_23, t0.js_head AS js_head_24, t0.status AS status_25, t0.fm_status AS fm_status_26, t0.event_status AS event_status_27, t0.fm_id AS fm_id_28, t0.available_to_sell AS available_to_sell_29, t0.use_event_name AS use_event_name_30, t0.custom_link AS custom_link_31, t0.sticker_activity_time_from AS sticker_activity_time_from_32, t0.sticker_activity_time_to AS sticker_activity_time_to_33, t0.last_status_updated_at AS last_status_updated_at_34, t0.currency_id AS currency_id_35, t0.activity_id AS activity_id_36, t37.id AS id_38, t37.slug AS slug_39, t37.status AS status_40, t37.external_id AS external_id_41, t37.created_at AS created_at_42, t37.updated_at AS updated_at_43, t37.image_gallery AS image_gallery_44, t37.video_gallery AS video_gallery_45, t37.youtube_video_gallery AS youtube_video_gallery_46, t37.sticker_activity_time_from AS sticker_activity_time_from_47, t37.sticker_activity_time_to AS sticker_activity_time_to_48, t37.sticker_id AS sticker_id_49, t0.city_id AS city_id_50, t0.building_id AS building_id_51, t0.sticker_id AS sticker_id_52, t53.id AS id_54, t53.external_id AS external_id_55, t53.sticker_order AS sticker_order_56, t53.back_color AS back_color_57, t53.text_color AS text_color_58, t53.activity_time_from AS activity_time_from_59, t53.activity_time_to AS activity_time_to_60, t53.created_at AS created_at_61, t53.updated_at AS updated_at_62, t0.hall_id AS hall_id_63, t0.organization_id AS organization_id_64, t0.legal_id AS legal_id_65 FROM event t0 LEFT JOIN activity t37 ON t0.activity_id = t37.id LEFT JOIN sticker t53 ON t0.sticker_id = t53.id WHERE t0.slug = 'pan-kots-kyy-6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alternate_name AS alternate_name_3,
  t0.description AS description_4,
  t0.description_text AS description_text_5,
  t0.press_release AS press_release_6,
  t0.canonical AS canonical_7,
  t0.seo_description AS seo_description_8,
  t0.seo_image AS seo_image_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.seo_title AS seo_title_11,
  t0.language_code AS language_code_12,
  t0.sticker_description AS sticker_description_13,
  t0.status_tooltip AS status_tooltip_14,
  t0.model_id AS model_id_15
FROM
  event_lang t0
WHERE
  t0.model_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.description AS description_4, t0.description_text AS description_text_5, t0.press_release AS press_release_6, t0.canonical AS canonical_7, t0.seo_description AS seo_description_8, t0.seo_image AS seo_image_9, t0.seo_keywords AS seo_keywords_10, t0.seo_title AS seo_title_11, t0.language_code AS language_code_12, t0.sticker_description AS sticker_description_13, t0.status_tooltip AS status_tooltip_14, t0.model_id AS model_id_15 FROM event_lang t0 WHERE t0.model_id = '019426c9-b55a-7372-a833-fe797723d992';

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.event_id AS event_id_4,
  t0.category_id AS category_id_5,
  t6.id AS id_7,
  t6.slug AS slug_8,
  t6.schema_name AS schema_name_9,
  t6.status AS status_10,
  t6.external_id AS external_id_11,
  t6.created_at AS created_at_12,
  t6.updated_at AS updated_at_13,
  t6.use_in_filtration AS use_in_filtration_14,
  t6.emoji AS emoji_15,
  t6.position AS position_16,
  t6.sticker_activity_time_from AS sticker_activity_time_from_17,
  t6.sticker_activity_time_to AS sticker_activity_time_to_18,
  t6.category_style_id AS category_style_id_19,
  t6.sticker_id AS sticker_id_20
FROM
  event_category t0
  LEFT JOIN category t6 ON t0.category_id = t6.id
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.event_id AS event_id_4, t0.category_id AS category_id_5, t6.id AS id_7, t6.slug AS slug_8, t6.schema_name AS schema_name_9, t6.status AS status_10, t6.external_id AS external_id_11, t6.created_at AS created_at_12, t6.updated_at AS updated_at_13, t6.use_in_filtration AS use_in_filtration_14, t6.emoji AS emoji_15, t6.position AS position_16, t6.sticker_activity_time_from AS sticker_activity_time_from_17, t6.sticker_activity_time_to AS sticker_activity_time_to_18, t6.category_style_id AS category_style_id_19, t6.sticker_id AS sticker_id_20 FROM event_category t0 LEFT JOIN category t6 ON t0.category_id = t6.id WHERE t0.event_id = '019426c9-b55a-7372-a833-fe797723d992';

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.sticker_order AS sticker_order_3,
  t0.back_color AS back_color_4,
  t0.text_color AS text_color_5,
  t0.activity_time_from AS activity_time_from_6,
  t0.activity_time_to AS activity_time_to_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  sticker t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.sticker_order AS sticker_order_3, t0.back_color AS back_color_4, t0.text_color AS text_color_5, t0.activity_time_from AS activity_time_from_6, t0.activity_time_to AS activity_time_to_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM sticker t0 WHERE t0.id = '018f5efb-675f-73c7-828a-a709d9dd1306';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.language_code AS language_code_4,
  t0.model_id AS model_id_5
FROM
  sticker_lang t0
WHERE
  t0.model_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.language_code AS language_code_4, t0.model_id AS model_id_5 FROM sticker_lang t0 WHERE t0.model_id = '018f5efb-675f-73c7-828a-a709d9dd1306';

SELECT
  tag.id as id
FROM
  tag
  INNER JOIN event_tag event_tag ON event_tag.tag_id = tag.id
WHERE
  (tag.status = ?)
  AND (event_tag.event_id = ?)
GROUP BY
  tag.id

SELECT tag.id as id FROM tag INNER JOIN event_tag event_tag ON event_tag.tag_id = tag.id WHERE (tag.status = 1) AND (event_tag.event_id = '019426c9-b55a-7372-a833-fe797723d992') GROUP BY tag.id;

SELECT
  tag.id as id
FROM
  tag
  INNER JOIN activity_tag activity_tag ON activity_tag.tag_id = tag.id
WHERE
  (tag.status = ?)
  AND (activity_tag.activity_id = ?)
GROUP BY
  tag.id

SELECT tag.id as id FROM tag INNER JOIN activity_tag activity_tag ON activity_tag.tag_id = tag.id WHERE (tag.status = 1) AND (activity_tag.activity_id = '018eb2a5-3088-780a-a1fd-5415533020c4') GROUP BY tag.id;

SELECT
  event.id as id,
  event.slug as slug,
  event.external_id as external_id,
  event.activity_id as activity_id,
  event.currency_id as currency_id,
  event.building_id as building_id,
  event.available_to_sell as available_to_sell,
  event.city_id as city_id,
  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.use_event_name as use_event_name,
  event.currency_id as currency_id,
  event.fm_status as fm_status,
  event.free_places as free_places,
  event.event_end_date as event_end_date,
  event.event_date as event_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.activity_id = ?)
  AND (event.id != ?)
  AND (event.available_to_sell = 1)
  AND (
    event.fm_status IN (?, ?, ?)
  )
  AND (
    event.event_status IN (?, ?, ?, ?, ?, ?, ?)
  )
  AND (event.event_date >= ?)
GROUP BY
  event.id
ORDER BY
  event_date asc

SELECT event.id as id, event.slug as slug, event.external_id as external_id, event.activity_id as activity_id, event.currency_id as currency_id, event.building_id as building_id, event.available_to_sell as available_to_sell, event.city_id as city_id, 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.use_event_name as use_event_name, event.currency_id as currency_id, event.fm_status as fm_status, event.free_places as free_places, event.event_end_date as event_end_date, event.event_date as event_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 = 'en' 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.activity_id = '018eb2a5-3088-780a-a1fd-5415533020c4') AND (event.id != '019426c9-b55a-7372-a833-fe797723d992') AND (event.available_to_sell = 1) AND (event.fm_status IN (0, 3, 2)) AND (event.event_status IN ('Discontinued', 'InStock', 'LimitedAvailability', 'PreOrder', 'PreSale', 'Rescheduled', 'Cancelled')) AND (event.event_date >= '2025-01-22 00:00:00') GROUP BY event.id ORDER BY event_date asc;

SELECT
  t0.id AS id_1,
  t0.language_code AS language_code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.description_long AS description_long_5,
  t0.sticker_description AS sticker_description_6,
  t0.model_id AS model_id_7
FROM
  activity_lang t0
WHERE
  t0.model_id = ?

SELECT t0.id AS id_1, t0.language_code AS language_code_2, t0.name AS name_3, t0.description AS description_4, t0.description_long AS description_long_5, t0.sticker_description AS sticker_description_6, t0.model_id AS model_id_7 FROM activity_lang t0 WHERE t0.model_id = '018eb2a5-3088-780a-a1fd-5415533020c4';