Symfony Profiler

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
  COUNT(e0_.id) AS sclr_0
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
  (
    DATE(e2_.startdate) >= ?
    AND DATE(e2_.startdate) <= ?
    AND e0_.published = ?
    AND e2_.startdate >= CURRENT_TIMESTAMP
    AND e5_.enabled = ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e2_.startdate ASC

SELECT COUNT(e0_.id) AS sclr_0 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 (DATE(e2_.startdate) >= '2025-09-20' AND DATE(e2_.startdate) <= '2025-09-21' AND e0_.published = 1 AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = 1) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate 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
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      startdate_38
    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_.slug AS slug_30,
          e1_.locale AS locale_31,
          e1_.id AS id_32,
          e2_.id AS id_33,
          e2_.online AS online_34,
          e2_.meetinglink AS meetinglink_35,
          e2_.active AS active_36,
          e2_.reference AS reference_37,
          e2_.startdate AS startdate_38,
          e2_.enddate AS enddate_39,
          e3_.username AS username_40,
          e3_.username_canonical AS username_canonical_41,
          e3_.email AS email_42,
          e3_.email_canonical AS email_canonical_43,
          e3_.enabled AS enabled_44,
          e3_.salt AS salt_45,
          e3_.password AS password_46,
          e3_.last_login AS last_login_47,
          e3_.confirmation_token AS confirmation_token_48,
          e3_.password_requested_at AS password_requested_at_49,
          e3_.roles AS roles_50,
          e3_.id AS id_51,
          e3_.gender AS gender_52,
          e3_.firstname AS firstname_53,
          e3_.lastname AS lastname_54,
          e3_.slug AS slug_55,
          e3_.street AS street_56,
          e3_.street2 AS street2_57,
          e3_.city AS city_58,
          e3_.state AS state_59,
          e3_.postalcode AS postalcode_60,
          e3_.phone AS phone_61,
          e3_.birthdate AS birthdate_62,
          e3_.avatar_name AS avatar_name_63,
          e3_.avatar_size AS avatar_size_64,
          e3_.avatar_mime_type AS avatar_mime_type_65,
          e3_.avatar_original_name AS avatar_original_name_66,
          e3_.avatar_dimensions AS avatar_dimensions_67,
          e3_.facebook_profile_picture AS facebook_profile_picture_68,
          e3_.created_at AS created_at_69,
          e3_.updated_at AS updated_at_70,
          e3_.deleted_at AS deleted_at_71,
          e3_.facebook_id AS facebook_id_72,
          e3_.facebook_access_token AS facebook_access_token_73,
          e3_.google_id AS google_id_74,
          e3_.google_access_token AS google_access_token_75,
          e3_.api_key AS api_key_76
        FROM
          eventic_event e0_
          INNER JOIN eventic_event_translation e4_ ON e0_.id = e4_.translatable_id
          LEFT JOIN eventic_category e5_ ON e0_.category_id = e5_.id
          AND (e5_.deleted_at IS NULL)
          INNER JOIN eventic_category_translation e1_ ON e5_.id = e1_.translatable_id
          LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id
          LEFT JOIN eventic_venue e6_ ON e2_.venue_id = e6_.id
          AND (e6_.deleted_at IS NULL)
          LEFT JOIN eventic_organizer e7_ ON e0_.organizer_id = e7_.id
          AND (e7_.deleted_at IS NULL)
          LEFT JOIN eventic_user e3_ ON e7_.user_id = e3_.id
          AND (e3_.deleted_at IS NULL)
        WHERE
          (
            e1_.slug = ?
            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_38 ASC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, startdate_38 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_.slug AS slug_30, e1_.locale AS locale_31, e1_.id AS id_32, e2_.id AS id_33, e2_.online AS online_34, e2_.meetinglink AS meetinglink_35, e2_.active AS active_36, e2_.reference AS reference_37, e2_.startdate AS startdate_38, e2_.enddate AS enddate_39, e3_.username AS username_40, e3_.username_canonical AS username_canonical_41, e3_.email AS email_42, e3_.email_canonical AS email_canonical_43, e3_.enabled AS enabled_44, e3_.salt AS salt_45, e3_.password AS password_46, e3_.last_login AS last_login_47, e3_.confirmation_token AS confirmation_token_48, e3_.password_requested_at AS password_requested_at_49, e3_.roles AS roles_50, e3_.id AS id_51, e3_.gender AS gender_52, e3_.firstname AS firstname_53, e3_.lastname AS lastname_54, e3_.slug AS slug_55, e3_.street AS street_56, e3_.street2 AS street2_57, e3_.city AS city_58, e3_.state AS state_59, e3_.postalcode AS postalcode_60, e3_.phone AS phone_61, e3_.birthdate AS birthdate_62, e3_.avatar_name AS avatar_name_63, e3_.avatar_size AS avatar_size_64, e3_.avatar_mime_type AS avatar_mime_type_65, e3_.avatar_original_name AS avatar_original_name_66, e3_.avatar_dimensions AS avatar_dimensions_67, e3_.facebook_profile_picture AS facebook_profile_picture_68, e3_.created_at AS created_at_69, e3_.updated_at AS updated_at_70, e3_.deleted_at AS deleted_at_71, e3_.facebook_id AS facebook_id_72, e3_.facebook_access_token AS facebook_access_token_73, e3_.google_id AS google_id_74, e3_.google_access_token AS google_access_token_75, e3_.api_key AS api_key_76 FROM eventic_event e0_ INNER JOIN eventic_event_translation e4_ ON e0_.id = e4_.translatable_id LEFT JOIN eventic_category e5_ ON e0_.category_id = e5_.id AND (e5_.deleted_at IS NULL) INNER JOIN eventic_category_translation e1_ ON e5_.id = e1_.translatable_id LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id LEFT JOIN eventic_venue e6_ ON e2_.venue_id = e6_.id AND (e6_.deleted_at IS NULL) LEFT JOIN eventic_organizer e7_ ON e0_.organizer_id = e7_.id AND (e7_.deleted_at IS NULL) LEFT JOIN eventic_user e3_ ON e7_.user_id = e3_.id AND (e3_.deleted_at IS NULL) WHERE (e1_.slug = 'simposio' 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_38 ASC) dctrn_result LIMIT 10;

SELECT
  COUNT(e0_.id) AS sclr_0
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
  (
    DATE(e2_.startdate) = ?
    AND e0_.published = ?
    AND e2_.startdate >= CURRENT_TIMESTAMP
    AND e5_.enabled = ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e2_.startdate ASC

SELECT COUNT(e0_.id) AS sclr_0 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 (DATE(e2_.startdate) = '2025-09-17' AND e0_.published = 1 AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = 1) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC;

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_category e2_ ON e0_.category_id = e2_.id
          AND (e2_.deleted_at IS NULL)
          INNER JOIN eventic_category_translation e3_ ON e2_.id = e3_.translatable_id
          LEFT JOIN eventic_event_date e4_ ON e0_.id = e4_.event_id
          LEFT JOIN eventic_venue e5_ ON e4_.venue_id = e5_.id
          AND (e5_.deleted_at IS NULL)
          LEFT JOIN eventic_organizer e6_ ON e0_.organizer_id = e6_.id
          AND (e6_.deleted_at IS NULL)
          LEFT JOIN eventic_user e7_ ON e6_.user_id = e7_.id
          AND (e7_.deleted_at IS NULL)
        WHERE
          (
            e3_.slug = ?
            AND e0_.published = ?
            AND e4_.startdate >= CURRENT_TIMESTAMP
            AND e7_.enabled = ?
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          e4_.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_category e2_ ON e0_.category_id = e2_.id AND (e2_.deleted_at IS NULL) INNER JOIN eventic_category_translation e3_ ON e2_.id = e3_.translatable_id LEFT JOIN eventic_event_date e4_ ON e0_.id = e4_.event_id LEFT JOIN eventic_venue e5_ ON e4_.venue_id = e5_.id AND (e5_.deleted_at IS NULL) LEFT JOIN eventic_organizer e6_ ON e0_.organizer_id = e6_.id AND (e6_.deleted_at IS NULL) LEFT JOIN eventic_user e7_ ON e6_.user_id = e7_.id AND (e7_.deleted_at IS NULL) WHERE (e3_.slug = 'simposio' AND e0_.published = 1 AND e4_.startdate >= CURRENT_TIMESTAMP AND e7_.enabled = 1) AND (e0_.deleted_at IS NULL) ORDER BY e4_.startdate ASC) dctrn_result) dctrn_table;

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
  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_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.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_audience_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_audience_translation t0 WHERE t0.translatable_id = 1;

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.name AS name_1,
  t0.header AS header_2,
  t0.slug AS slug_3,
  t0.locale AS locale_4,
  t0.id AS id_5,
  t0.translatable_id AS translatable_id_6
FROM
  eventic_menu_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.header AS header_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM eventic_menu_translation t0 WHERE t0.translatable_id = 2;

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

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,
  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
  e0_.id AS id_0,
  e0_.image_name AS image_name_1,
  e0_.image_size AS image_size_2,
  e0_.image_mime_type AS image_mime_type_3,
  e0_.image_original_name AS image_original_name_4,
  e0_.image_dimensions AS image_dimensions_5,
  e0_.hidden AS hidden_6,
  e0_.created_at AS created_at_7,
  e0_.updated_at AS updated_at_8,
  e0_.deleted_at AS deleted_at_9
FROM
  eventic_audience e0_
  INNER JOIN eventic_audience_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_.image_name AS image_name_1, e0_.image_size AS image_size_2, e0_.image_mime_type AS image_mime_type_3, e0_.image_original_name AS image_original_name_4, e0_.image_dimensions AS image_dimensions_5, e0_.hidden AS hidden_6, e0_.created_at AS created_at_7, e0_.updated_at AS updated_at_8, e0_.deleted_at AS deleted_at_9 FROM eventic_audience e0_ INNER JOIN eventic_audience_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = 0) 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 = ?
    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
  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
  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
  4

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