http://www.symfony.ungarische-gemeinde.de/cookie_consent_alt?locale=hu

Query Metrics

90 Database Queries
19 Different statements
61.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.59 ms
(33.28%)
3
SELECT t0.id AS id_1, t0.name AS name_2 FROM event_type t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "metas"
]
11.75 ms
(18.99%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.datum AS datum_3, t0.time AS time_4, t0.city AS city_5, t0.description AS description_6, t0.url AS url_7, t0.caption AS caption_8, t0.language AS language_9, t0.end_datum AS end_datum_10, t0.hide_datum AS hide_datum_11, t0.hide_title AS hide_title_12, t0.machine_name AS machine_name_13, t0.image AS image_14, t0.event_type_id AS event_type_id_15, t0.city_id_id AS city_id_id_16 FROM events t0 WHERE t0.id = ?
Parameters:
[
  244
]
9.77 ms
(15.80%)
30
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.comment AS comment_4, t0.deleted AS deleted_5, t0.is_visible AS is_visible_6, t0.tags AS tags_7, t0.uploaded_file AS uploaded_file_8, t0.event_id_id AS event_id_id_9 FROM picture t0 WHERE t0.event_id_id = ?
Parameters:
[
  203
]
7.81 ms
(12.63%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.caption AS caption_4, t0.url AS url_5, t0.text_icon AS text_icon_6, t0.description_de AS description_de_7, t0.description_hu AS description_hu_8, t0.cim AS cim_9 FROM cities t0 ORDER BY t0.name ASC
Parameters:
[]
5.37 ms
(8.69%)
30
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.comment AS comment_4, t0.deleted AS deleted_5, t0.is_visible AS is_visible_6, t0.tags AS tags_7, t0.uploaded_file AS uploaded_file_8, t0.event_id_id AS event_id_id_9 FROM picture t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  416
]
1.96 ms
(3.17%)
9
SELECT m0_.id AS id_0, m0_.caption AS caption_1, m0_.url AS url_2, m0_.icon AS icon_3, m0_.position AS position_4, m0_.section AS section_5, m0_.language AS language_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id = ? AND (m0_.language = '--' OR m0_.language = ?) ORDER BY m0_.position ASC
Parameters:
[
  1
  "hu"
]
0.78 ms
(1.26%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.language AS language_4, t0.content AS content_5 FROM pages t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "home"
  "hu"
]
0.50 ms
(0.81%)
1
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.datum AS datum_2, e0_.time AS time_3, e0_.city AS city_4, e0_.description AS description_5, e0_.url AS url_6, e0_.caption AS caption_7, e0_.language AS language_8, e0_.end_datum AS end_datum_9, e0_.hide_datum AS hide_datum_10, e0_.hide_title AS hide_title_11, e0_.machine_name AS machine_name_12, e0_.image AS image_13, e0_.event_type_id AS event_type_id_14, e0_.city_id_id AS city_id_id_15 FROM events e0_ WHERE e0_.event_type_id = ? AND (e0_.language = '--' OR e0_.language = ?) ORDER BY e0_.datum DESC
Parameters:
[
  4
  "hu"
]
0.44 ms
(0.71%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.language AS language_4, t0.content AS content_5 FROM pages t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "footer"
]
0.39 ms
(0.64%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.datum AS datum_3, t0.time AS time_4, t0.city AS city_5, t0.description AS description_6, t0.url AS url_7, t0.caption AS caption_8, t0.language AS language_9, t0.end_datum AS end_datum_10, t0.hide_datum AS hide_datum_11, t0.hide_title AS hide_title_12, t0.machine_name AS machine_name_13, t0.image AS image_14, t0.event_type_id AS event_type_id_15, t0.city_id_id AS city_id_id_16 FROM events t0 WHERE t0.event_type_id = ?
Parameters:
[
  9
]
0.39 ms
(0.64%)
1
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.datum AS datum_2, e0_.time AS time_3, e0_.city AS city_4, e0_.description AS description_5, e0_.url AS url_6, e0_.caption AS caption_7, e0_.language AS language_8, e0_.end_datum AS end_datum_9, e0_.hide_datum AS hide_datum_10, e0_.hide_title AS hide_title_11, e0_.machine_name AS machine_name_12, e0_.image AS image_13, e0_.event_type_id AS event_type_id_14, e0_.city_id_id AS city_id_id_15 FROM events e0_ WHERE e0_.event_type_id = ? AND e0_.datum >= ? AND (e0_.language = '--' OR e0_.language = ?) ORDER BY e0_.datum ASC, e0_.time ASC LIMIT 5
Parameters:
[
  2
  "2025-12-07"
  "hu"
]
0.33 ms
(0.53%)
1
SELECT m0_.id AS id_0, m0_.caption AS caption_1, m0_.url AS url_2, m0_.icon AS icon_3, m0_.position AS position_4, m0_.section AS section_5, m0_.language AS language_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ ORDER BY m0_.section ASC
Parameters:
[]
0.29 ms
(0.47%)
1
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.datum AS datum_2, e0_.time AS time_3, e0_.city AS city_4, e0_.description AS description_5, e0_.url AS url_6, e0_.caption AS caption_7, e0_.language AS language_8, e0_.end_datum AS end_datum_9, e0_.hide_datum AS hide_datum_10, e0_.hide_title AS hide_title_11, e0_.machine_name AS machine_name_12, e0_.image AS image_13, e0_.event_type_id AS event_type_id_14, e0_.city_id_id AS city_id_id_15 FROM events e0_ WHERE e0_.event_type_id = ? AND e0_.datum >= ? AND (e0_.language = '--' OR e0_.language = ?) ORDER BY e0_.datum DESC, e0_.time DESC LIMIT 5
Parameters:
[
  1
  "2025-12-07"
  "hu"
]
0.28 ms
(0.46%)
1
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.datum AS datum_2, e0_.time AS time_3, e0_.city AS city_4, e0_.description AS description_5, e0_.url AS url_6, e0_.caption AS caption_7, e0_.language AS language_8, e0_.end_datum AS end_datum_9, e0_.hide_datum AS hide_datum_10, e0_.hide_title AS hide_title_11, e0_.machine_name AS machine_name_12, e0_.image AS image_13, e0_.event_type_id AS event_type_id_14, e0_.city_id_id AS city_id_id_15 FROM events e0_ WHERE e0_.event_type_id = ? AND (e0_.language = '--' OR e0_.language = ?) ORDER BY e0_.datum DESC, e0_.time DESC LIMIT 1
Parameters:
[
  3
  "hu"
]
0.27 ms
(0.43%)
1
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.url AS url_3, t0.icon AS icon_4, t0.position AS position_5, t0.section AS section_6, t0.language AS language_7, t0.parent_id AS parent_id_8 FROM menu_item t0
Parameters:
[]
0.26 ms
(0.43%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.datum AS datum_3, t0.time AS time_4, t0.city AS city_5, t0.description AS description_6, t0.url AS url_7, t0.caption AS caption_8, t0.language AS language_9, t0.end_datum AS end_datum_10, t0.hide_datum AS hide_datum_11, t0.hide_title AS hide_title_12, t0.machine_name AS machine_name_13, t0.image AS image_14, t0.event_type_id AS event_type_id_15, t0.city_id_id AS city_id_id_16 FROM events t0 WHERE t0.event_type_id = ? LIMIT 1
Parameters:
[
  8
]
0.26 ms
(0.42%)
1
SELECT m0_.id AS id_0, m0_.caption AS caption_1, m0_.url AS url_2, m0_.icon AS icon_3, m0_.position AS position_4, m0_.section AS section_5, m0_.language AS language_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.section = ? AND (m0_.language = '--' OR m0_.language = ?) ORDER BY m0_.position ASC
Parameters:
[
  "main"
  "hu"
]
0.22 ms
(0.35%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.datum AS datum_3, t0.time AS time_4, t0.city AS city_5, t0.description AS description_6, t0.url AS url_7, t0.caption AS caption_8, t0.language AS language_9, t0.end_datum AS end_datum_10, t0.hide_datum AS hide_datum_11, t0.hide_title AS hide_title_12, t0.machine_name AS machine_name_13, t0.image AS image_14, t0.event_type_id AS event_type_id_15, t0.city_id_id AS city_id_id_16 FROM events t0 WHERE t0.event_type_id = ? AND t0.language = ? LIMIT 1
Parameters:
[
  11
  "hu"
]
0.20 ms
(0.32%)
1
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.url AS url_3, t0.icon AS icon_4, t0.position AS position_5, t0.section AS section_6, t0.language AS language_7, t0.parent_id AS parent_id_8 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  9
]

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

Class Mapping errors
App\Entity\EventType No errors.
App\Entity\Events No errors.
App\Entity\Cities No errors.
App\Entity\Picture No errors.
App\Entity\Pages No errors.
App\Entity\MenuItem No errors.
App\Entity\CitiesAddress No errors.