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

Query Metrics

21 Database Queries
11 Different statements
2.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.67 ms
(25.95%)
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.48 ms
(18.37%)
2
SELECT t0.id AS id_1, t0.name AS name_2 FROM event_type t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "metas"
]
0.36 ms
(13.71%)
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 50
Parameters:
[
  1
  "2024-03-19"
  "hu"
]
0.35 ms
(13.55%)
1
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:
[
  "hirek"
  "hu"
]
0.16 ms
(6.09%)
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.13 ms
(5.01%)
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.13 ms
(4.97%)
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.11 ms
(4.20%)
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.09 ms
(3.65%)
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.07 ms
(2.77%)
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.05 ms
(1.74%)
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.