https://eventos.keoscx.com/de/help-center/%D9%85%D9%86%D8%B8%D9%85-%D8%A3%D8%AD%D8%AF%D8%A7%D8%AB

Query Metrics

47 Database Queries
11 Different statements
4.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.61 ms
(39.03%)
19
SELECT t0.label AS label_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_menu_element_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.61 ms
(14.82%)
8
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
0.56 ms
(13.62%)
7
SELECT e0_.id AS id_0 FROM eventic_menu e0_ INNER JOIN eventic_menu_translation e1_ ON e0_.id = e1_.translatable_id WHERE e1_.slug = ?
Parameters:
[
  "header-menu"
]
0.33 ms
(8.09%)
4
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.link AS link_3, t0.custom_link AS custom_link_4, t0.position AS position_5, t0.menu_id AS menu_id_6 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.29 ms
(6.97%)
3
SELECT t0.name AS name_1, t0.header AS header_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM eventic_menu_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.22 ms
(5.22%)
1
SELECT e0_.id AS id_0, e0_.icon AS icon_1, e0_.hidden AS hidden_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.deleted_at AS deleted_at_5, e0_.parent_id AS parent_id_6 FROM eventic_help_center_category e0_ INNER JOIN eventic_help_center_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e1_.slug = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC
Parameters:
[
  0
  "منظم-أحداث"
]
0.11 ms
(2.69%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.icon AS icon_1, e0_.image_name AS image_name_2, e0_.image_size AS image_size_3, e0_.image_mime_type AS image_mime_type_4, e0_.image_original_name AS image_original_name_5, e0_.image_dimensions AS image_dimensions_6, e0_.hidden AS hidden_7, e0_.featured AS featured_8, e0_.featuredorder AS featuredorder_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.deleted_at AS deleted_at_12 FROM eventic_category e0_ INNER JOIN eventic_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.featured = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 9
Parameters:
[
  0
  1
]
0.11 ms
(2.58%)
1
SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_mime_type AS logo_mime_type_4, t0.logo_original_name AS logo_original_name_5, t0.logo_dimensions AS logo_dimensions_6, t0.favicon_name AS favicon_name_7, t0.favicon_size AS favicon_size_8, t0.favicon_mime_type AS favicon_mime_type_9, t0.favicon_original_name AS favicon_original_name_10, t0.favicon_dimensions AS favicon_dimensions_11, t0.og_image_name AS og_image_name_12, t0.og_image_size AS og_image_size_13, t0.og_image_mime_type AS og_image_mime_type_14, t0.og_image_original_name AS og_image_original_name_15, t0.og_image_dimensions AS og_image_dimensions_16, t0.updated_at AS updated_at_17 FROM eventic_app_layout_setting t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.10 ms
(2.41%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.icon AS icon_1, e0_.image_name AS image_name_2, e0_.image_size AS image_size_3, e0_.image_mime_type AS image_mime_type_4, e0_.image_original_name AS image_original_name_5, e0_.image_dimensions AS image_dimensions_6, e0_.hidden AS hidden_7, e0_.featured AS featured_8, e0_.featuredorder AS featuredorder_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.deleted_at AS deleted_at_12 FROM eventic_category e0_ INNER JOIN eventic_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.featured = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 4
Parameters:
[
  0
  1
]
0.10 ms
(2.38%)
1
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_help_center_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.09 ms
(2.19%)
1
SELECT e0_.id AS id_0, e0_.views AS views_1, e0_.hidden AS hidden_2, e0_.featured AS featured_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.deleted_at AS deleted_at_6, e0_.category_id AS category_id_7 FROM eventic_help_center_article e0_ LEFT JOIN eventic_help_center_category e1_ ON e0_.category_id = e1_.id AND (e1_.deleted_at IS NULL) LEFT JOIN eventic_help_center_category_translation e2_ ON e1_.id = e2_.translatable_id WHERE (e0_.hidden = ? AND e2_.slug = ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.created_at DESC
Parameters:
[
  0
  "veranstalter"
]

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\HelpCenterCategory No errors.
App\Entity\HelpCenterCategoryTranslation No errors.
App\Entity\HelpCenterArticle No errors.
App\Entity\AppLayoutSettings No errors.
App\Entity\Menu No errors.
App\Entity\MenuTranslation No errors.
App\Entity\MenuElement No errors.
App\Entity\MenuElementTranslation No errors.
App\Entity\Category No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\Event No errors.
App\Entity\Organizer No errors.