Query Metrics
18
Database Queries
6
Different statements
354.52 ms
Query time
0
Invalid entities
Queries
#▲ | 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 | 43.52 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 11:46:12" ] |
3 | 49.41 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 11:46:12" ] |
4 | 1.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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "en" "en" "019426cb-2419-77dd-85ff-4a9f771d2df5" "019426cb-249c-7c58-a65d-4f1d2d4d7551" "019426cb-24db-71be-aa48-7ead9f38cc63" "019426cb-254e-7446-a61a-74edf56fdefb" "019426cb-2577-7baa-b69b-f9af86183ba9" "019426cb-25ad-7b7d-a8dc-b95faa8065a7" "019426ca-ee48-710b-b437-b0975cca93be" "019426ca-eeb4-7066-bbf2-6a42cffc66dd" "019426ca-ee9e-7f63-9c97-e06db994d663" "019426ca-ef03-7061-a350-d21e8b4913b6" "019426ca-efac-7ee6-be82-51df19c5b128" "019426ca-ef67-7928-bef7-a8f52c823591" "019426ca-f035-7a77-b03e-50b7d646561a" ] |
5 | 0.93 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.94 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 | 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:
[ "en" "en" "019426cb-24db-71be-aa48-7ead9f38cc63" ] |
8 | 0.87 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 | 2.26 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 | 0.91 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 | 0.88 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 | 0.86 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 | 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:
[ "en" "en" "019426ca-ee9e-7f63-9c97-e06db994d663" ] |
14 | 0.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 | 0.72 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 | 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" "019426ca-ef67-7928-bef7-a8f52c823591" ] |
17 | 0.84 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 | 246.96 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.