Redirect 301 redirect from GET @main_localized (c79d03)

GET https://izyaslav.bavtest.net/ua/

Query Metrics

5 Database Queries
5 Different statements
9.96 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.81 ms
SELECT city.id as id, city.country_id as country_id FROM city INNER JOIN event event ON city.id = event.city_id WHERE (event.status = ?) AND (event.event_date >= ?) AND (event.available_to_sell = 1) AND (event.fm_status IN (?, ?, ?)) AND (city.domain = ?) LIMIT 1
Parameters:
[
  1
  "2025-01-22"
  0
  2
  3
  "izyaslav.bavtest.net"
]
2 1.32 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=?) OR (seo_data.city_id is null AND seo_data.for_all_cities_status=1)) AND (seo_data.category_id is null) AND (seo_data.month is null) AND (seo_data.tag_id is null) ORDER BY city_id DESC LIMIT 1
Parameters:
[
  "ua"
  "018eb296-1af4-7881-a1be-ca5f108fbab1"
]
3 2.13 ms
SELECT count(*) as cnt 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 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.city_id IN (?)) AND (event.sales_end_time >= ?)) dbal_count_tbl
Parameters:
[
  "ua"
  "en"
  1
  0
  2
  3
  1
  "Discontinued"
  "InStock"
  "LimitedAvailability"
  "PreOrder"
  "PreSale"
  "Rescheduled"
  "Cancelled"
  "2025-01-22 20:19:07"
  "018eb296-1af4-7881-a1be-ca5f108fbab1"
  "2025-01-22 18:19:07"
]
4 1.74 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 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.city_id IN (?)) AND (event.sales_end_time >= ?) ORDER BY event_date asc LIMIT 30
Parameters:
[
  "ua"
  "en"
  1
  0
  2
  3
  1
  "Discontinued"
  "InStock"
  "LimitedAvailability"
  "PreOrder"
  "PreSale"
  "Rescheduled"
  "Cancelled"
  "2025-01-22 20:19:07"
  "018eb296-1af4-7881-a1be-ca5f108fbab1"
  "2025-01-22 18:19:07"
]
5 0.96 ms
SELECT running_line.image_desktop, running_line.image_tablet, running_line.image_mobile, running_line.gtm_event, running_line.gtm_event_name, running_line.starts_at, running_line.finishes_at, running_line_lang.link FROM running_line LEFT JOIN running_line_lang running_line_lang ON running_line_lang.model_id = running_line.id AND running_line_lang.language_code=? WHERE (running_line.starts_at <= ?) AND (running_line.finishes_at >= ?) ORDER BY running_line.position asc LIMIT 100
Parameters:
[
  "ua"
  "2025-01-22 18:19:08"
  "2025-01-22 18:19:08"
]

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.

Entities Mapping

No loaded entities.