Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      start_date_32
    FROM
      (
        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,
          e1_.id AS id_27,
          e1_.online AS online_28,
          e1_.has_seating_plan AS has_seating_plan_29,
          e1_.reference AS reference_30,
          e1_.active AS active_31,
          e1_.start_date AS start_date_32,
          e1_.end_date AS end_date_33,
          e2_.id AS id_34,
          e2_.email AS email_35,
          e2_.gender AS gender_36,
          e2_.first_name AS first_name_37,
          e2_.last_name AS last_name_38,
          e2_.slug AS slug_39,
          e2_.street AS street_40,
          e2_.street2 AS street2_41,
          e2_.city AS city_42,
          e2_.state AS state_43,
          e2_.postal_code AS postal_code_44,
          e2_.phone AS phone_45,
          e2_.birth_date AS birth_date_46,
          e2_.avatar_name AS avatar_name_47,
          e2_.avatar_dimensions AS avatar_dimensions_48,
          e2_.facebook_profile_picture AS facebook_profile_picture_49,
          e2_.google_profile_picture AS google_profile_picture_50,
          e2_.facebook_id AS facebook_id_51,
          e2_.google_id AS google_id_52,
          e2_.api_key AS api_key_53,
          e2_.created_at AS created_at_54,
          e2_.updated_at AS updated_at_55,
          e2_.last_login_at AS last_login_at_56,
          e2_.roles AS roles_57,
          e2_.password AS password_58,
          e2_.is_enabled AS is_enabled_59,
          e2_.is_verified AS is_verified_60
        FROM
          eventic_event e0_
          LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id
          LEFT JOIN eventic_venue e3_ ON e1_.venue_id = e3_.id
          LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id
          LEFT JOIN eventic_user e2_ ON e4_.user_id = e2_.id
        WHERE
          e0_.published = ?
          AND e1_.start_date >= CURRENT_TIMESTAMP
          AND e2_.is_enabled = ?
        ORDER BY
          e1_.start_date ASC
      ) dctrn_result_inner
    ORDER BY
      start_date_32 ASC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_date_32 FROM (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, e1_.id AS id_27, e1_.online AS online_28, e1_.has_seating_plan AS has_seating_plan_29, e1_.reference AS reference_30, e1_.active AS active_31, e1_.start_date AS start_date_32, e1_.end_date AS end_date_33, e2_.id AS id_34, e2_.email AS email_35, e2_.gender AS gender_36, e2_.first_name AS first_name_37, e2_.last_name AS last_name_38, e2_.slug AS slug_39, e2_.street AS street_40, e2_.street2 AS street2_41, e2_.city AS city_42, e2_.state AS state_43, e2_.postal_code AS postal_code_44, e2_.phone AS phone_45, e2_.birth_date AS birth_date_46, e2_.avatar_name AS avatar_name_47, e2_.avatar_dimensions AS avatar_dimensions_48, e2_.facebook_profile_picture AS facebook_profile_picture_49, e2_.google_profile_picture AS google_profile_picture_50, e2_.facebook_id AS facebook_id_51, e2_.google_id AS google_id_52, e2_.api_key AS api_key_53, e2_.created_at AS created_at_54, e2_.updated_at AS updated_at_55, e2_.last_login_at AS last_login_at_56, e2_.roles AS roles_57, e2_.password AS password_58, e2_.is_enabled AS is_enabled_59, e2_.is_verified AS is_verified_60 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e3_ ON e1_.venue_id = e3_.id LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id LEFT JOIN eventic_user e2_ ON e4_.user_id = e2_.id WHERE e0_.published = 1 AND e1_.start_date >= CURRENT_TIMESTAMP AND e2_.is_enabled = 1 ORDER BY e1_.start_date ASC) dctrn_result_inner ORDER BY start_date_32 ASC) dctrn_result LIMIT 10;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        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_.published = ?
          AND e1_.start_date >= CURRENT_TIMESTAMP
          AND e4_.is_enabled = ?
        ORDER BY
          e1_.start_date ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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_.published = 1 AND e1_.start_date >= CURRENT_TIMESTAMP AND e4_.is_enabled = 1 ORDER BY e1_.start_date ASC) dctrn_result) dctrn_table;

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

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 = 1 ORDER BY t0.position ASC;

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 = ?

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 = 1;

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 = ?

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 = 'header-menu';