GET https://budapest-1.bavtest.net/february/?page=2

Query Metrics

18 Database Queries
6 Different statements
586.25 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 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:
[
  "february"
  1
]
2 45.12 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-02-01 00:00:00" AND event.event_date <= "2025-02-28 23:59:59")))) dbal_count_tbl
Parameters:
[
  "en"
  "en"
  1
  "2025-01-23 22:47:08"
]
3 80.98 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-02-01 00:00:00" AND event.event_date <= "2025-02-28 23:59:59"))) ORDER BY virtual_date asc, event_date asc LIMIT 100 OFFSET 100
Parameters:
[
  "en"
  "en"
  1
  "2025-01-23 22:47:08"
]
4 5.90 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:
[
  "en"
  "en"
  "019426cb-23cb-783c-be38-a8d92f9a5f9d"
  "019426cb-23bf-7145-b674-d035ad8bcf75"
  "019426cb-2423-7f29-880c-9c6bd9173fd6"
  "019426cb-2419-77dd-85ff-4a9f771d2df5"
  "019426cb-246a-7705-a3a3-0566c7000812"
  "019426cb-245d-787e-b481-812a72aa004e"
  "019426cb-2452-7678-8410-984dc11c7602"
  "019426cb-2448-7486-8c55-2fdeee555611"
  "019426cb-249c-7c58-a65d-4f1d2d4d7551"
  "019426cb-24db-71be-aa48-7ead9f38cc63"
  "019426cb-2536-7433-adba-3739be8040d4"
  "019426cb-254e-7446-a61a-74edf56fdefb"
  "019426cb-2569-7dc3-91b1-d83407fad583"
  "019426cb-2577-7baa-b69b-f9af86183ba9"
  "019426cb-2592-7562-ba9d-a0c8538dfd7c"
  "019426cb-25c7-742c-a9ad-1bd3e9b15701"
  "019426cb-25bb-76b0-9074-d851501b1f5d"
  "019426cb-25ad-7b7d-a8dc-b95faa8065a7"
  "019426c8-f396-70a9-9f8a-8a15d76b2634"
  "019426ca-ee48-710b-b437-b0975cca93be"
  "019426ca-ee33-7262-83ca-8f6a392a34e7"
  "019426ca-ee27-722e-813a-1358a2a57485"
  "019426ca-ee93-7a5f-a488-ee5b43a774b8"
  "019426ca-eea8-7fae-826c-92b4fbd65ab0"
  "019426ca-eec7-7520-b98d-c3956c1d9f5f"
  "019426ca-eeb4-7066-bbf2-6a42cffc66dd"
  "019426ca-ee9e-7f63-9c97-e06db994d663"
  "019426ca-ef03-7061-a350-d21e8b4913b6"
  "019426ca-ef29-7585-bfc9-fc8a2d9387cc"
  "019426ca-ef1c-7cb3-9fe6-e77607112e28"
  "019426ca-ef42-74bf-acb4-9703a00a5183"
  "019426c8-f3c4-7eec-b877-f11f9d890781"
  "019426ca-efd5-75b6-9934-5af3b7e51e7c"
  "019426ca-efc9-73c4-9db4-414d74378b72"
  "019426ca-efac-7ee6-be82-51df19c5b128"
  "019426ca-ef67-7928-bef7-a8f52c823591"
  "019426ca-ef50-73fa-88d9-a2221cf09085"
  "019426ca-f045-7310-9462-d56f824992dd"
  "019426ca-f035-7a77-b03e-50b7d646561a"
]
5 6.52 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:
[
  "en"
  "en"
  "019426cb-2419-77dd-85ff-4a9f771d2df5"
]
6 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:
[
  "en"
  "en"
  "019426cb-249c-7c58-a65d-4f1d2d4d7551"
]
7 16.20 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:
[
  "en"
  "en"
  "019426cb-24db-71be-aa48-7ead9f38cc63"
]
8 7.59 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:
[
  "en"
  "en"
  "019426cb-254e-7446-a61a-74edf56fdefb"
]
9 10.30 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:
[
  "en"
  "en"
  "019426cb-2577-7baa-b69b-f9af86183ba9"
]
10 17.50 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:
[
  "en"
  "en"
  "019426cb-25ad-7b7d-a8dc-b95faa8065a7"
]
11 21.15 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:
[
  "en"
  "en"
  "019426ca-ee48-710b-b437-b0975cca93be"
]
12 18.23 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:
[
  "en"
  "en"
  "019426ca-eeb4-7066-bbf2-6a42cffc66dd"
]
13 2.95 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:
[
  "en"
  "en"
  "019426ca-ee9e-7f63-9c97-e06db994d663"
]
14 6.71 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:
[
  "en"
  "en"
  "019426ca-ef03-7061-a350-d21e8b4913b6"
]
15 16.92 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:
[
  "en"
  "en"
  "019426ca-efac-7ee6-be82-51df19c5b128"
]
16 5.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:
[
  "en"
  "en"
  "019426ca-ef67-7928-bef7-a8f52c823591"
]
17 13.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:
[
  "en"
  "en"
  "019426ca-f035-7a77-b03e-50b7d646561a"
]
18 309.25 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:
[
  "en"
  "2"
]

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.