Symfony Profiler

Query Metrics

15 Database Queries

9 Different statements

31.47 ms Query time

0 Invalid entities

4 Managed entities

Queries


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.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 COUNT(*) 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, 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.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 >= ?)) tmp
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, 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.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 virtual_date asc, event_date asc, event.id asc LIMIT 100
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 = ?
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 COUNT(*) 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, 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, 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 (?, ?, ?, ?, ?, ?, ?, ?))) tmp
SELECT COUNT(*) 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, 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, 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 (?, ?, ?))) tmp
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 COUNT(*) 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, 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.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 >= ?)) tmp
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, 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.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 virtual_date asc, event_date asc, event.id asc LIMIT 100
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 COUNT(*) 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, 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.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 >= ?)) tmp
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, 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.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 virtual_date asc, event_date asc, event.id asc LIMIT 100
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

#▲	Time	Info
1	0.65 ms	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 Parameters: [`"home" 1`] View formatted query View runnable query Explain query 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;
2	0.73 ms	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 = ? Parameters: [`"018c1b5a-75e2-729c-a97a-85bb87f49fc2"`] View formatted query View runnable query Explain query 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';
3	3.26 ms	SELECT COUNT() 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, 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.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 >= ?)) tmp Parameters: [`"ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "2025-07-16 09:33:33"`] View formatted query View runnable query Explain query SELECT COUNT() 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, 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.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 >= ?) ) tmp SELECT COUNT(*) 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, 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.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-07-16 12:33:33') AND (event.sales_end_time >= '2025-07-16 09:33:33')) tmp;
4	3.36 ms	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, 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.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 virtual_date asc, event_date asc, event.id asc LIMIT 100 Parameters: [`"ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "2025-07-16 09:33:33"`] View formatted query View runnable query Explain query 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, 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.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 virtual_date asc, event_date asc, event.id 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, 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.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-07-16 12:33:33') AND (event.sales_end_time >= '2025-07-16 09:33:33') ORDER BY virtual_date asc, event_date asc, event.id asc LIMIT 100;
5	2.44 ms	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 = ? Parameters: [`"ua" "en"`] View formatted query View runnable query Explain query 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 = ? 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';
6	0.85 ms	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 Parameters: [`"ua" "en" "01971265-c947-7904-827f-a9f29055cce8"`] View formatted query View runnable query Explain query 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 = '01971265-c947-7904-827f-a9f29055cce8' LIMIT 1;
7	1.74 ms	SELECT COUNT() 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, 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, 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 (?, ?, ?, ?, ?, ?, ?, ?))) tmp Parameters: ["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" "ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "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"] View formatted query View runnable query Explain query SELECT COUNT() 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, 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, 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 (?, ?, ?, ?, ?, ?, ?, ?) ) ) tmp SELECT COUNT(*) 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, 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, 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 = '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.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-07-16 12:33:33') 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'))) tmp;
8	1.67 ms	SELECT COUNT() 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, 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, 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 (?, ?, ?))) tmp Parameters: [`"018eb281-cdb4-7cd7-91e1-c515a8871087" "018eb282-8e51-739e-8fa6-2fb61aab3749" "018eb282-a503-7fb7-8237-cd4d524e73c7" "ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "018eb281-cdb4-7cd7-91e1-c515a8871087" "018eb282-8e51-739e-8fa6-2fb61aab3749" "018eb282-a503-7fb7-8237-cd4d524e73c7"`] View formatted query View runnable query Explain query SELECT COUNT() 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, 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, 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 (?, ?, ?) ) ) tmp SELECT COUNT(*) 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, 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, 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 = '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.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-07-16 12:33:33') AND (event.external_id IN ('018eb281-cdb4-7cd7-91e1-c515a8871087', '018eb282-8e51-739e-8fa6-2fb61aab3749', '018eb282-a503-7fb7-8237-cd4d524e73c7'))) tmp;
9	1.14 ms	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 Parameters: [`"ua" "en" 1`] View formatted query View runnable query Explain query 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 = 'ua' 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;
10	3.02 ms	SELECT COUNT() 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, 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.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 >= ?)) tmp Parameters: [`"ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "2025-07-16 09:33:33"`] View formatted query View runnable query Explain query SELECT COUNT() 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, 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.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 >= ?) ) tmp SELECT COUNT(*) 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, 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.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-07-16 12:33:33') AND (event.sales_end_time >= '2025-07-16 09:33:33')) tmp;
11	3.85 ms	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, 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.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 virtual_date asc, event_date asc, event.id asc LIMIT 100 Parameters: [`"ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "2025-07-16 09:33:33"`] View formatted query View runnable query Explain query 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, 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.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 virtual_date asc, event_date asc, event.id 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, 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.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-07-16 12:33:33') AND (event.sales_end_time >= '2025-07-16 09:33:33') ORDER BY virtual_date asc, event_date asc, event.id asc LIMIT 100;
12	0.81 ms	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 Parameters: [`"ua" "en" "01971265-c947-7904-827f-a9f29055cce8"`] View formatted query View runnable query Explain query 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 = '01971265-c947-7904-827f-a9f29055cce8' LIMIT 1;
13	3.08 ms	SELECT COUNT() 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, 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.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 >= ?)) tmp Parameters: [`"ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "2025-07-16 09:33:33"`] View formatted query View runnable query Explain query SELECT COUNT() 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, 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.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 >= ?) ) tmp SELECT COUNT(*) 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, 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.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-07-16 12:33:33') AND (event.sales_end_time >= '2025-07-16 09:33:33')) tmp;
14	4.01 ms	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, 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.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 virtual_date asc, event_date asc, event.id asc LIMIT 100 Parameters: [`"ua" "en" 1 0 2 3 1 "Discontinued" "InStock" "LimitedAvailability" "PreOrder" "PreSale" "Rescheduled" "Cancelled" "2025-07-16 12:33:33" "2025-07-16 09:33:33"`] View formatted query View runnable query Explain query 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, 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.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 virtual_date asc, event_date asc, event.id 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, 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.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-07-16 12:33:33') AND (event.sales_end_time >= '2025-07-16 09:33:33') ORDER BY virtual_date asc, event_date asc, event.id asc LIMIT 100;
15	0.84 ms	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 Parameters: [`"ua" "en" "01971265-c947-7904-827f-a9f29055cce8"`] View formatted query View runnable query Explain query 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 = '01971265-c947-7904-827f-a9f29055cce8' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\ProjectCatalogBundle\Domain\Entity\PageLang\PageLang	3
App\ProjectCatalogBundle\Domain\Entity\Page\Page	1

Entities Mapping

Class	Mapping errors
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\Slug	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\ExternalId	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\Status	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\Timestamp	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\Index	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\Css	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\JsHead	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\JsBodyStart	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\ValueObject\JsBodyEnd	No errors.
App\ProjectCatalogBundle\Domain\Entity\Page\Page	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\ValueObject\LanguageCode	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\ValueObject\Title	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\ValueObject\Canonical	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\ValueObject\SeoTitle	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\ValueObject\SeoImage	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\ValueObject\SeoDescription	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\ValueObject\SeoKeywords	No errors.
App\ProjectCatalogBundle\Domain\Entity\PageLang\PageLang	No errors.

Symfony Profiler

GET https://bavtest.net/ua/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping