GET https://kiiv.bavtest.net/ua/march/?page=2

Query Metrics

19 Database Queries
7 Different statements
94.00 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 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:
[
  "march"
  1
]
2 31.81 ms
SELECT count(*) as cnt FROM (SELECT event.id as id, event.fm_id as fm_id, event.currency_id as currency_id, event.building_id as building_id, event.activity_id as activity_id, event.city_id as city_id, event.free_places as free_places, event.use_event_name as use_event_name, event.slug as slug, event.custom_link as custom_link, event.available_to_sell as available_to_sell, event.sticker_id as sticker_id, event.sticker_activity_time_from as sticker_activity_time_from, event.sticker_activity_time_to as sticker_activity_time_to, event.price_from as price_from, event.price_to as price_to, event.event_status as event_status, event.fm_status as fm_status, event.event_date as event_date, event.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event_lang.description as description, event_lang_default.name as default_name, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, CASE
               WHEN event.event_date <= CURRENT_DATE AND (event.event_end_date >= CURRENT_DATE OR event.event_end_date IS NULL) THEN CURRENT_DATE
               WHEN (event.event_end_date > CURRENT_DATE OR event.event_date < CURRENT_DATE OR event.event_end_date IS NULL) THEN COALESCE(event.event_end_date, event.event_date)
            END AS virtual_date FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = ? LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = ? WHERE (event.status = ?) AND (event.sales_end_time > ?) AND (((event.event_date >= "2025-03-01 00:00:00" AND event.event_date <= "2025-03-31 23:59:59")))) dbal_count_tbl
Parameters:
[
  "ua"
  "en"
  1
  "2025-01-23 02:10:26"
]
3 49.34 ms
SELECT event.id as id, event.fm_id as fm_id, event.currency_id as currency_id, event.building_id as building_id, event.activity_id as activity_id, event.city_id as city_id, event.free_places as free_places, event.use_event_name as use_event_name, event.slug as slug, event.custom_link as custom_link, event.available_to_sell as available_to_sell, event.sticker_id as sticker_id, event.sticker_activity_time_from as sticker_activity_time_from, event.sticker_activity_time_to as sticker_activity_time_to, event.price_from as price_from, event.price_to as price_to, event.event_status as event_status, event.fm_status as fm_status, event.event_date as event_date, event.event_end_date as event_end_date, event.sales_end_time as sales_end_time, event_lang.name as name, event_lang.description as description, event_lang_default.name as default_name, event.image_big as image_big, event.image_medium as image_medium, event.image_large as image_large, event.image_small as image_small, CASE
               WHEN event.event_date <= CURRENT_DATE AND (event.event_end_date >= CURRENT_DATE OR event.event_end_date IS NULL) THEN CURRENT_DATE
               WHEN (event.event_end_date > CURRENT_DATE OR event.event_date < CURRENT_DATE OR event.event_end_date IS NULL) THEN COALESCE(event.event_end_date, event.event_date)
            END AS virtual_date FROM event LEFT JOIN event_lang event_lang ON event_lang.model_id = event.id AND event_lang.language_code = ? LEFT JOIN event_lang event_lang_default ON event_lang_default.model_id = event.id AND event_lang_default.language_code = ? WHERE (event.status = ?) AND (event.sales_end_time > ?) AND (((event.event_date >= "2025-03-01 00:00:00" AND event.event_date <= "2025-03-31 23:59:59"))) ORDER BY virtual_date asc, event_date asc LIMIT 100 OFFSET 100
Parameters:
[
  "ua"
  "en"
  1
  "2025-01-23 02:10:26"
]
4 0.84 ms
SELECT event_category.category_id as id, event_category.event_id as event_id FROM event_category WHERE event_category.event_id IN (?, ?, ?, ?)
Parameters:
[
  "019426ca-ac25-7adb-b4df-4f59ee465a49"
  "019426ca-aca5-77ae-b779-11e2fba226db"
  "019426ca-af56-7760-8f13-924fe6c7cd27"
  "01943aec-09b2-744e-9591-649613247a27"
]
5 1.18 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "ua"
  "en"
  "019426ca-acb3-7e17-b86f-73ec90ecd9bc"
  "019426ca-acd4-7a3b-b5c8-b3ed757bbbeb"
  "019426ca-ada1-78ee-ba40-4d645349629e"
  "019426ca-b101-7b44-95a0-5259b6b1b78a"
  "019426ca-7854-71a9-8ab2-93c0fd45b4d5"
  "019426ca-7919-70f2-8720-ce0f8b4514da"
  "019426ca-7992-723f-b358-1d8301b09748"
  "019426ca-7a28-740c-bb72-d8ce6d8bbfa9"
  "019426ca-7a8b-7114-8321-d9f0f7b2b2da"
  "019426ca-7b18-7a1f-9e8c-5f1e0eab3ee6"
  "019426ca-7b37-7973-8d45-1f00c299900f"
  "019426ca-7b97-7bfc-bf87-7fd2f1932f35"
  "019426ca-7ba4-7918-90ba-50154aeae91c"
]
6 0.81 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-acb3-7e17-b86f-73ec90ecd9bc"
]
7 0.60 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-acd4-7a3b-b5c8-b3ed757bbbeb"
]
8 0.57 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-ada1-78ee-ba40-4d645349629e"
]
9 0.67 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-b101-7b44-95a0-5259b6b1b78a"
]
10 0.64 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7854-71a9-8ab2-93c0fd45b4d5"
]
11 0.75 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7919-70f2-8720-ce0f8b4514da"
]
12 0.75 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7992-723f-b358-1d8301b09748"
]
13 0.76 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7a28-740c-bb72-d8ce6d8bbfa9"
]
14 0.73 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7a8b-7114-8321-d9f0f7b2b2da"
]
15 0.74 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7b18-7a1f-9e8c-5f1e0eab3ee6"
]
16 0.60 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7b37-7973-8d45-1f00c299900f"
]
17 0.75 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7b97-7bfc-bf87-7fd2f1932f35"
]
18 0.62 ms
SELECT activity.id as id, activity.external_id as external_id, activity.sticker_id as sticker_id, activity.sticker_activity_time_from as sticker_activity_time_from, activity.sticker_activity_time_to as sticker_activity_time_to, activity_lang.name as name, activity_lang.description as description, activity_lang_default.name as default_name, activity_lang_default.description as default_description, activity_lang.sticker_description as sticker_description, activity_lang_default.sticker_description as default_sticker_description, event.id as event_id FROM activity LEFT JOIN activity_lang activity_lang ON activity_lang.model_id = activity.id AND activity_lang.language_code = ? LEFT JOIN activity_lang activity_lang_default ON activity_lang_default.model_id = activity.id AND activity_lang_default.language_code = ? INNER JOIN event event ON event.activity_id = activity.id WHERE event.id =? LIMIT 1
Parameters:
[
  "ua"
  "en"
  "019426ca-7ba4-7918-90ba-50154aeae91c"
]
19 1.21 ms
SELECT seo_data.id as id, seo_data_lang.title, seo_data_lang.h1Seo, seo_data_lang.seo_text, seo_data_lang.description FROM seo_data INNER JOIN seo_data_lang seo_data_lang ON seo_data_lang.model_id = seo_data.id AND seo_data_lang.language_code = ? WHERE ((seo_data.city_id is null) OR (seo_data.for_all_cities_status=1)) AND (seo_data.category_id is null) AND (seo_data.month in (?)) AND (seo_data.tag_id is null) ORDER BY city_id ASC, month DESC LIMIT 1
Parameters:
[
  "ua"
  "3"
]

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.