GET https://usmofoot.ma/fr/event/usmo-vs-test

Query Metrics

14 Database Queries
13 Different statements
4.16 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 1.41 ms
SELECT DISTINCT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.reference AS reference_4, e0_.views AS views_5, e0_.youtube_url AS youtube_url_6, e0_.external_link AS external_link_7, e0_.phone_number AS phone_number_8, e0_.email AS email_9, e0_.x AS x_10, e0_.instagram AS instagram_11, e0_.facebook AS facebook_12, e0_.linked_in AS linked_in_13, e0_.tags AS tags_14, e0_.artists AS artists_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_dimensions AS image_dimensions_18, e0_.created_at AS created_at_19, e0_.updated_at AS updated_at_20, e0_.published AS published_21, e0_.enable_reviews AS enable_reviews_22, e0_.show_attendees AS show_attendees_23, e0_.opponent_name AS opponent_name_24, e0_.journee AS journee_25, e0_.opponent_logo AS opponent_logo_26, e0_.category_id AS category_id_27, e0_.country_id AS country_id_28, e0_.organizer_id AS organizer_id_29, e0_.is_on_homepage_slider_id AS is_on_homepage_slider_id_30 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id WHERE e0_.slug = ? AND e0_.published = ? AND e4_.is_enabled = ? ORDER BY e1_.start_date ASC
Parameters:
[
  "usmo-vs-test"
  1
  1
]
2 0.25 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_event_translation t0 WHERE t0.object_id = ?
Parameters:
[
  18
]
3 0.11 ms
"START TRANSACTION"
Parameters:
[]
4 0.24 ms
UPDATE eventic_event SET views = ?, updated_at = ? WHERE id = ?
Parameters:
[
  24
  "2026-08-11 19:48:01"
  18
]
5 0.09 ms
"COMMIT"
Parameters:
[]
6 0.22 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
]
7 0.24 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"
]
8 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_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
9 0.23 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
]
10 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:
[
  1
]
11 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:
[
  2
]
12 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.website AS website_5, t0.email AS email_6, t0.phone AS phone_7, t0.facebook AS facebook_8, t0.x AS x_9, t0.instagram AS instagram_10, t0.linked_in AS linked_in_11, t0.youtube_url AS youtube_url_12, t0.logo_name AS logo_name_13, t0.logo_dimensions AS logo_dimensions_14, t0.cover_name AS cover_name_15, t0.cover_dimensions AS cover_dimensions_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.views AS views_19, t0.show_venues_map AS show_venues_map_20, t0.show_followers AS show_followers_21, t0.show_reviews AS show_reviews_22, t0.show_event_date_stats_on_scanner_app AS show_event_date_stats_on_scanner_app_23, t0.allow_tap_to_check_in_on_scanner_app AS allow_tap_to_check_in_on_scanner_app_24, t0.user_id AS user_id_25, t0.country_id AS country_id_26 FROM eventic_organizer t0 WHERE t0.id = ?
Parameters:
[
  12
]
13 0.27 ms
SELECT t0.id AS id_1, t0.online AS online_2, t0.has_seating_plan AS has_seating_plan_3, t0.reference AS reference_4, t0.active AS active_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.event_id AS event_id_8, t0.venue_id AS venue_id_9, t0.seating_plan_id AS seating_plan_id_10 FROM eventic_event_date t0 WHERE t0.event_id = ? ORDER BY t0.start_date ASC
Parameters:
[
  18
]
14 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.gender AS gender_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.slug AS slug_6, t0.street AS street_7, t0.street2 AS street2_8, t0.city AS city_9, t0.state AS state_10, t0.postal_code AS postal_code_11, t0.phone AS phone_12, t0.birth_date AS birth_date_13, t0.avatar_name AS avatar_name_14, t0.avatar_dimensions AS avatar_dimensions_15, t0.facebook_profile_picture AS facebook_profile_picture_16, t0.google_profile_picture AS google_profile_picture_17, t0.facebook_id AS facebook_id_18, t0.google_id AS google_id_19, t0.api_key AS api_key_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.last_login_at AS last_login_at_23, t0.roles AS roles_24, t0.password AS password_25, t0.is_enabled AS is_enabled_26, t0.is_verified AS is_verified_27, t0.country_id AS country_id_28, t0.organizer_id AS organizer_id_29, t0.scanner_id AS scanner_id_30, t0.point_of_sale_id AS point_of_sale_id_31, t0.is_organizer_on_homepage_slider_id AS is_organizer_on_homepage_slider_id_32 FROM eventic_user t0 WHERE t0.id = ?
Parameters:
[
  34
]

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 16
App\Entity\MenuTranslation 8
App\Entity\EventTranslation 2
App\Entity\MenuElement 2
App\Entity\Event 1
App\Entity\Category 1
App\Entity\Organizer 1
App\Entity\HomepageHeroSettings 1
App\Entity\AppLayoutSettings 1
App\Entity\Menu 1
App\Entity\User 1
App\Entity\EventDate 1
App\Entity\Venue 1