GET https://www.sopovia.com/ar/help-center/organizer

Query Metrics

31 Database Queries
10 Different statements
6.44 ms Query time
0 Invalid entities
160 Managed entities

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.icon AS icon_3, e0_.hidden AS hidden_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, e0_.parent_id AS parent_id_7 FROM eventic_help_center_category e0_ WHERE e0_.hidden = ? AND e0_.slug = ? ORDER BY e0_.name ASC
Parameters:
[
  0
  "organizer"
]
2 0.31 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_help_center_category_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
3 0.27 ms
SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.favicon_name AS favicon_name_3, t0.og_image_name AS og_image_name_4, t0.updated_at AS updated_at_5 FROM eventic_app_layout_setting t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.25 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?
Parameters:
[
  "header-menu"
]
5 0.26 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
6 0.24 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
7 0.22 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
8 0.23 ms
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.content AS content_2, e0_.tags AS tags_3, e0_.slug AS slug_4, e0_.views AS views_5, e0_.hidden AS hidden_6, e0_.featured AS featured_7, e0_.created_at AS created_at_8, e0_.updated_at AS updated_at_9, e0_.category_id AS category_id_10 FROM eventic_help_center_article e0_ LEFT JOIN eventic_help_center_category e1_ ON e0_.category_id = e1_.id WHERE e0_.hidden = ? AND e1_.slug = ? ORDER BY e0_.created_at DESC
Parameters:
[
  0
  "organizer"
]
9 0.17 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?
Parameters:
[
  "first-footer-section-menu"
]
10 0.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?
Parameters:
[
  2
]
11 0.15 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?
Parameters:
[
  "first-footer-section-menu"
]
12 0.20 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
13 0.20 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  10
]
14 0.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  12
]
15 0.16 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?
Parameters:
[
  "second-footer-section-menu"
]
16 0.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?
Parameters:
[
  3
]
17 0.16 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?
Parameters:
[
  "second-footer-section-menu"
]
18 0.21 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
19 0.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  14
]
20 0.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  15
]
21 0.21 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  16
]
22 0.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  17
]
23 0.18 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  18
]
24 0.16 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?
Parameters:
[
  "third-footer-section-menu"
]
25 0.17 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?
Parameters:
[
  4
]
26 0.15 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?
Parameters:
[
  "third-footer-section-menu"
]
27 0.20 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
28 0.16 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  19
]
29 0.19 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?
Parameters:
[
  20
]
30 0.25 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.icon AS icon_3, e0_.image_name AS image_name_4, e0_.image_dimensions AS image_dimensions_5, e0_.hidden AS hidden_6, e0_.featured AS featured_7, e0_.featured_order AS featured_order_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10 FROM eventic_category e0_ WHERE e0_.hidden = ? AND e0_.slug <> ? AND e0_.featured = ? ORDER BY e0_.featured_order ASC LIMIT 4
Parameters:
[
  0
  "notSlug"
  1
]
31 0.23 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_category_translation t0 WHERE t0.object_id = ?
Parameters:
[
  11
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MenuElementTranslation 73
App\Entity\MenuTranslation 56
App\Entity\MenuElement 10
App\Entity\HelpCenterCategoryTranslation 7
App\Entity\CategoryTranslation 7
App\Entity\Menu 4
App\Entity\HelpCenterCategory 1
App\Entity\AppLayoutSettings 1
App\Entity\Category 1