Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          DISTINCT e0_.id AS id_0,
          e0_.chatbot_list AS chatbot_list_1,
          e0_.reference AS reference_2,
          e0_.views AS views_3,
          e0_.tickettemplate AS tickettemplate_4,
          e0_.youtubeurl AS youtubeurl_5,
          e0_.externallink AS externallink_6,
          e0_.phonenumber AS phonenumber_7,
          e0_.email AS email_8,
          e0_.twitter AS twitter_9,
          e0_.instagram AS instagram_10,
          e0_.facebook AS facebook_11,
          e0_.googleplus AS googleplus_12,
          e0_.linkedin AS linkedin_13,
          e0_.artists AS artists_14,
          e0_.tags AS tags_15,
          e0_.year AS year_16,
          e0_.image_name AS image_name_17,
          e0_.image_size AS image_size_18,
          e0_.image_mime_type AS image_mime_type_19,
          e0_.image_original_name AS image_original_name_20,
          e0_.image_dimensions AS image_dimensions_21,
          e0_.created_at AS created_at_22,
          e0_.updated_at AS updated_at_23,
          e0_.deleted_at AS deleted_at_24,
          e0_.published AS published_25,
          e0_.enablereviews AS enablereviews_26,
          e0_.whatsappnumber AS whatsappnumber_27,
          e0_.showattendees AS showattendees_28
        FROM
          eventic_event e0_
          INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id
          LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id
          LEFT JOIN eventic_venue e3_ ON e2_.venue_id = e3_.id
          AND (e3_.deleted_at IS NULL)
          LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id
          AND (e4_.deleted_at IS NULL)
          LEFT JOIN eventic_user e5_ ON e4_.user_id = e5_.id
          AND (e5_.deleted_at IS NULL)
        WHERE
          (
            (
              e1_.name LIKE ?
              OR ? LIKE e1_.name
              OR e1_.description LIKE ?
              OR ? LIKE e1_.description
              OR e0_.tags LIKE ?
              OR ? LIKE e0_.tags
              OR e0_.artists LIKE ?
              OR ? LIKE e0_.artists
            )
            AND e0_.published = ?
            AND e2_.startdate >= CURRENT_TIMESTAMP
            AND e5_.enabled = ?
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          e2_.startdate ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT e0_.id AS id_0, e0_.chatbot_list AS chatbot_list_1, e0_.reference AS reference_2, e0_.views AS views_3, e0_.tickettemplate AS tickettemplate_4, e0_.youtubeurl AS youtubeurl_5, e0_.externallink AS externallink_6, e0_.phonenumber AS phonenumber_7, e0_.email AS email_8, e0_.twitter AS twitter_9, e0_.instagram AS instagram_10, e0_.facebook AS facebook_11, e0_.googleplus AS googleplus_12, e0_.linkedin AS linkedin_13, e0_.artists AS artists_14, e0_.tags AS tags_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_size AS image_size_18, e0_.image_mime_type AS image_mime_type_19, e0_.image_original_name AS image_original_name_20, e0_.image_dimensions AS image_dimensions_21, e0_.created_at AS created_at_22, e0_.updated_at AS updated_at_23, e0_.deleted_at AS deleted_at_24, e0_.published AS published_25, e0_.enablereviews AS enablereviews_26, e0_.whatsappnumber AS whatsappnumber_27, e0_.showattendees AS showattendees_28 FROM eventic_event e0_ INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id LEFT JOIN eventic_venue e3_ ON e2_.venue_id = e3_.id AND (e3_.deleted_at IS NULL) LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id AND (e4_.deleted_at IS NULL) LEFT JOIN eventic_user e5_ ON e4_.user_id = e5_.id AND (e5_.deleted_at IS NULL) WHERE ((e1_.name LIKE '%Magia%' OR '%Magia%' LIKE e1_.name OR e1_.description LIKE '%Magia%' OR '%Magia%' LIKE e1_.description OR e0_.tags LIKE '%Magia%' OR '%Magia%' LIKE e0_.tags OR e0_.artists LIKE '%Magia%' OR '%Magia%' LIKE e0_.artists) AND e0_.published = 1 AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = 1) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      startdate_39
    FROM
      (
        SELECT
          DISTINCT e0_.id AS id_0,
          e0_.chatbot_list AS chatbot_list_1,
          e0_.reference AS reference_2,
          e0_.views AS views_3,
          e0_.tickettemplate AS tickettemplate_4,
          e0_.youtubeurl AS youtubeurl_5,
          e0_.externallink AS externallink_6,
          e0_.phonenumber AS phonenumber_7,
          e0_.email AS email_8,
          e0_.twitter AS twitter_9,
          e0_.instagram AS instagram_10,
          e0_.facebook AS facebook_11,
          e0_.googleplus AS googleplus_12,
          e0_.linkedin AS linkedin_13,
          e0_.artists AS artists_14,
          e0_.tags AS tags_15,
          e0_.year AS year_16,
          e0_.image_name AS image_name_17,
          e0_.image_size AS image_size_18,
          e0_.image_mime_type AS image_mime_type_19,
          e0_.image_original_name AS image_original_name_20,
          e0_.image_dimensions AS image_dimensions_21,
          e0_.created_at AS created_at_22,
          e0_.updated_at AS updated_at_23,
          e0_.deleted_at AS deleted_at_24,
          e0_.published AS published_25,
          e0_.enablereviews AS enablereviews_26,
          e0_.whatsappnumber AS whatsappnumber_27,
          e0_.showattendees AS showattendees_28,
          e1_.name AS name_29,
          e1_.description AS description_30,
          e1_.slug AS slug_31,
          e1_.locale AS locale_32,
          e1_.id AS id_33,
          e2_.id AS id_34,
          e2_.online AS online_35,
          e2_.meetinglink AS meetinglink_36,
          e2_.active AS active_37,
          e2_.reference AS reference_38,
          e2_.startdate AS startdate_39,
          e2_.enddate AS enddate_40,
          e3_.username AS username_41,
          e3_.username_canonical AS username_canonical_42,
          e3_.email AS email_43,
          e3_.email_canonical AS email_canonical_44,
          e3_.enabled AS enabled_45,
          e3_.salt AS salt_46,
          e3_.password AS password_47,
          e3_.last_login AS last_login_48,
          e3_.confirmation_token AS confirmation_token_49,
          e3_.password_requested_at AS password_requested_at_50,
          e3_.roles AS roles_51,
          e3_.id AS id_52,
          e3_.gender AS gender_53,
          e3_.firstname AS firstname_54,
          e3_.lastname AS lastname_55,
          e3_.slug AS slug_56,
          e3_.street AS street_57,
          e3_.street2 AS street2_58,
          e3_.city AS city_59,
          e3_.state AS state_60,
          e3_.postalcode AS postalcode_61,
          e3_.phone AS phone_62,
          e3_.birthdate AS birthdate_63,
          e3_.avatar_name AS avatar_name_64,
          e3_.avatar_size AS avatar_size_65,
          e3_.avatar_mime_type AS avatar_mime_type_66,
          e3_.avatar_original_name AS avatar_original_name_67,
          e3_.avatar_dimensions AS avatar_dimensions_68,
          e3_.facebook_profile_picture AS facebook_profile_picture_69,
          e3_.created_at AS created_at_70,
          e3_.updated_at AS updated_at_71,
          e3_.deleted_at AS deleted_at_72,
          e3_.facebook_id AS facebook_id_73,
          e3_.facebook_access_token AS facebook_access_token_74,
          e3_.google_id AS google_id_75,
          e3_.google_access_token AS google_access_token_76,
          e3_.api_key AS api_key_77
        FROM
          eventic_event e0_
          INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id
          LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id
          LEFT JOIN eventic_venue e4_ ON e2_.venue_id = e4_.id
          AND (e4_.deleted_at IS NULL)
          LEFT JOIN eventic_organizer e5_ ON e0_.organizer_id = e5_.id
          AND (e5_.deleted_at IS NULL)
          LEFT JOIN eventic_user e3_ ON e5_.user_id = e3_.id
          AND (e3_.deleted_at IS NULL)
        WHERE
          (
            (
              e1_.name LIKE ?
              OR ? LIKE e1_.name
              OR e1_.description LIKE ?
              OR ? LIKE e1_.description
              OR e0_.tags LIKE ?
              OR ? LIKE e0_.tags
              OR e0_.artists LIKE ?
              OR ? LIKE e0_.artists
            )
            AND e0_.published = ?
            AND e2_.startdate >= CURRENT_TIMESTAMP
            AND e3_.enabled = ?
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          e2_.startdate ASC
      ) dctrn_result_inner
    ORDER BY
      startdate_39 ASC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, startdate_39 FROM (SELECT DISTINCT e0_.id AS id_0, e0_.chatbot_list AS chatbot_list_1, e0_.reference AS reference_2, e0_.views AS views_3, e0_.tickettemplate AS tickettemplate_4, e0_.youtubeurl AS youtubeurl_5, e0_.externallink AS externallink_6, e0_.phonenumber AS phonenumber_7, e0_.email AS email_8, e0_.twitter AS twitter_9, e0_.instagram AS instagram_10, e0_.facebook AS facebook_11, e0_.googleplus AS googleplus_12, e0_.linkedin AS linkedin_13, e0_.artists AS artists_14, e0_.tags AS tags_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_size AS image_size_18, e0_.image_mime_type AS image_mime_type_19, e0_.image_original_name AS image_original_name_20, e0_.image_dimensions AS image_dimensions_21, e0_.created_at AS created_at_22, e0_.updated_at AS updated_at_23, e0_.deleted_at AS deleted_at_24, e0_.published AS published_25, e0_.enablereviews AS enablereviews_26, e0_.whatsappnumber AS whatsappnumber_27, e0_.showattendees AS showattendees_28, e1_.name AS name_29, e1_.description AS description_30, e1_.slug AS slug_31, e1_.locale AS locale_32, e1_.id AS id_33, e2_.id AS id_34, e2_.online AS online_35, e2_.meetinglink AS meetinglink_36, e2_.active AS active_37, e2_.reference AS reference_38, e2_.startdate AS startdate_39, e2_.enddate AS enddate_40, e3_.username AS username_41, e3_.username_canonical AS username_canonical_42, e3_.email AS email_43, e3_.email_canonical AS email_canonical_44, e3_.enabled AS enabled_45, e3_.salt AS salt_46, e3_.password AS password_47, e3_.last_login AS last_login_48, e3_.confirmation_token AS confirmation_token_49, e3_.password_requested_at AS password_requested_at_50, e3_.roles AS roles_51, e3_.id AS id_52, e3_.gender AS gender_53, e3_.firstname AS firstname_54, e3_.lastname AS lastname_55, e3_.slug AS slug_56, e3_.street AS street_57, e3_.street2 AS street2_58, e3_.city AS city_59, e3_.state AS state_60, e3_.postalcode AS postalcode_61, e3_.phone AS phone_62, e3_.birthdate AS birthdate_63, e3_.avatar_name AS avatar_name_64, e3_.avatar_size AS avatar_size_65, e3_.avatar_mime_type AS avatar_mime_type_66, e3_.avatar_original_name AS avatar_original_name_67, e3_.avatar_dimensions AS avatar_dimensions_68, e3_.facebook_profile_picture AS facebook_profile_picture_69, e3_.created_at AS created_at_70, e3_.updated_at AS updated_at_71, e3_.deleted_at AS deleted_at_72, e3_.facebook_id AS facebook_id_73, e3_.facebook_access_token AS facebook_access_token_74, e3_.google_id AS google_id_75, e3_.google_access_token AS google_access_token_76, e3_.api_key AS api_key_77 FROM eventic_event e0_ INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id LEFT JOIN eventic_venue e4_ ON e2_.venue_id = e4_.id AND (e4_.deleted_at IS NULL) LEFT JOIN eventic_organizer e5_ ON e0_.organizer_id = e5_.id AND (e5_.deleted_at IS NULL) LEFT JOIN eventic_user e3_ ON e5_.user_id = e3_.id AND (e3_.deleted_at IS NULL) WHERE ((e1_.name LIKE '%Magia%' OR '%Magia%' LIKE e1_.name OR e1_.description LIKE '%Magia%' OR '%Magia%' LIKE e1_.description OR e0_.tags LIKE '%Magia%' OR '%Magia%' LIKE e0_.tags OR e0_.artists LIKE '%Magia%' OR '%Magia%' LIKE e0_.artists) AND e0_.published = 1 AND e2_.startdate >= CURRENT_TIMESTAMP AND e3_.enabled = 1) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC) dctrn_result_inner ORDER BY startdate_39 ASC) dctrn_result LIMIT 10;

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = 0 AND e0_.featured = 1) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 9;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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_.deleted_at IS NULL)
ORDER BY
  e1_.name ASC

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 = 0) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC;

SELECT
  e0_.id AS id_0,
  e0_.code AS code_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
FROM
  eventic_country e0_
  INNER JOIN eventic_country_translation e1_ ON e0_.id = e1_.translatable_id
WHERE
  (
    e0_.hidden = ?
    AND e0_.code = ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e1_.name ASC

SELECT e0_.id AS id_0, e0_.code AS code_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 FROM eventic_country e0_ INNER JOIN eventic_country_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = 0 AND e0_.code = 'US') AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC;

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_country_translation t0
WHERE
  t0.translatable_id = ?

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_country_translation t0 WHERE t0.translatable_id = 198;

SELECT
  e0_.id AS id_0,
  e0_.code AS code_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
FROM
  eventic_country e0_
  INNER JOIN eventic_country_translation e1_ ON e0_.id = e1_.translatable_id
WHERE
  (e0_.hidden = ?)
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e1_.name ASC

SELECT e0_.id AS id_0, e0_.code AS code_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 FROM eventic_country e0_ INNER JOIN eventic_country_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = 0) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC;

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_country_translation t0
WHERE
  t0.translatable_id = ?

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_country_translation t0 WHERE t0.translatable_id = 228;

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_country_translation t0
WHERE
  t0.translatable_id = ?

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_country_translation t0 WHERE t0.translatable_id = 86;

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_country_translation t0
WHERE
  t0.translatable_id = ?

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_country_translation t0 WHERE t0.translatable_id = 85;