Symfony Profiler

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
  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
  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_.published = ?
  AND e1_.start_date >= CURRENT_TIMESTAMP
  AND e4_.is_enabled = ?
  AND e0_.id IN (?, ?)
ORDER BY
  e1_.start_date ASC

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_.published = 1 AND e1_.start_date >= CURRENT_TIMESTAMP AND e4_.is_enabled = 1 AND e0_.id IN (21, 20) ORDER BY e1_.start_date ASC;

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

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

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

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

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';

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

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

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

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

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

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

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

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 = 21 ORDER BY t0.start_date ASC;

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

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

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