Query Metrics
19
Database Queries
7
Different statements
94.00 ms
Query time
0
Invalid entities
Queries
#▲ | 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.