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

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

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,
  e0_.category_id AS category_id_29,
  e0_.country_id AS country_id_30,
  e0_.organizer_id AS organizer_id_31,
  e0_.isonhomepageslider_id AS isonhomepageslider_id_32
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
  (
    e0_.published = ?
    AND e2_.startdate >= CURRENT_TIMESTAMP
    AND e5_.enabled = ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e2_.startdate ASC
LIMIT
  12

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, e0_.category_id AS category_id_29, e0_.country_id AS country_id_30, e0_.organizer_id AS organizer_id_31, e0_.isonhomepageslider_id AS isonhomepageslider_id_32 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 (e0_.published = 1 AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = 1) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC LIMIT 12;

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.chatbot_list AS chatbot_list_2,
  t0.reference AS reference_3,
  t0.views AS views_4,
  t0.tickettemplate AS tickettemplate_5,
  t0.youtubeurl AS youtubeurl_6,
  t0.externallink AS externallink_7,
  t0.phonenumber AS phonenumber_8,
  t0.email AS email_9,
  t0.twitter AS twitter_10,
  t0.instagram AS instagram_11,
  t0.facebook AS facebook_12,
  t0.googleplus AS googleplus_13,
  t0.linkedin AS linkedin_14,
  t0.artists AS artists_15,
  t0.tags AS tags_16,
  t0.year AS year_17,
  t0.image_name AS image_name_18,
  t0.image_size AS image_size_19,
  t0.image_mime_type AS image_mime_type_20,
  t0.image_original_name AS image_original_name_21,
  t0.image_dimensions AS image_dimensions_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.deleted_at AS deleted_at_25,
  t0.published AS published_26,
  t0.enablereviews AS enablereviews_27,
  t0.whatsappnumber AS whatsappnumber_28,
  t0.showattendees AS showattendees_29,
  t0.category_id AS category_id_30,
  t0.country_id AS country_id_31,
  t0.organizer_id AS organizer_id_32,
  t0.isonhomepageslider_id AS isonhomepageslider_id_33
FROM
  eventic_event t0
WHERE
  t0.isonhomepageslider_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.chatbot_list AS chatbot_list_2, t0.reference AS reference_3, t0.views AS views_4, t0.tickettemplate AS tickettemplate_5, t0.youtubeurl AS youtubeurl_6, t0.externallink AS externallink_7, t0.phonenumber AS phonenumber_8, t0.email AS email_9, t0.twitter AS twitter_10, t0.instagram AS instagram_11, t0.facebook AS facebook_12, t0.googleplus AS googleplus_13, t0.linkedin AS linkedin_14, t0.artists AS artists_15, t0.tags AS tags_16, t0.year AS year_17, t0.image_name AS image_name_18, t0.image_size AS image_size_19, t0.image_mime_type AS image_mime_type_20, t0.image_original_name AS image_original_name_21, t0.image_dimensions AS image_dimensions_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25, t0.published AS published_26, t0.enablereviews AS enablereviews_27, t0.whatsappnumber AS whatsappnumber_28, t0.showattendees AS showattendees_29, t0.category_id AS category_id_30, t0.country_id AS country_id_31, t0.organizer_id AS organizer_id_32, t0.isonhomepageslider_id AS isonhomepageslider_id_33 FROM eventic_event t0 WHERE t0.isonhomepageslider_id = 1 AND ((t0.deleted_at IS NULL));

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
  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.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
  t0.id AS id_1,
  t0.content AS content_2,
  t0.custom_background_name AS custom_background_name_3,
  t0.custom_background_size AS custom_background_size_4,
  t0.custom_background_mime_type AS custom_background_mime_type_5,
  t0.custom_background_original_name AS custom_background_original_name_6,
  t0.custom_background_dimensions AS custom_background_dimensions_7,
  t0.show_search_box AS show_search_box_8,
  t0.updated_at AS updated_at_9
FROM
  eventic_homepage_hero_setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.custom_background_name AS custom_background_name_3, t0.custom_background_size AS custom_background_size_4, t0.custom_background_mime_type AS custom_background_mime_type_5, t0.custom_background_original_name AS custom_background_original_name_6, t0.custom_background_dimensions AS custom_background_dimensions_7, t0.show_search_box AS show_search_box_8, t0.updated_at AS updated_at_9 FROM eventic_homepage_hero_setting t0 WHERE t0.id = 1;

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
  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_.readtime AS readtime_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_.views AS views_7,
  e0_.hidden AS hidden_8,
  e0_.created_at AS created_at_9,
  e0_.updated_at AS updated_at_10,
  e0_.deleted_at AS deleted_at_11,
  e0_.category_id AS category_id_12
FROM
  eventic_blog_post e0_
WHERE
  (e0_.hidden = ?)
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.created_at DESC
LIMIT
  8

SELECT e0_.id AS id_0, e0_.readtime AS readtime_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_.views AS views_7, e0_.hidden AS hidden_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.deleted_at AS deleted_at_11, e0_.category_id AS category_id_12 FROM eventic_blog_post e0_ WHERE (e0_.hidden = 0) AND (e0_.deleted_at IS NULL) ORDER BY e0_.created_at DESC LIMIT 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_.featured = ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e1_.name ASC
LIMIT
  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 = 0 AND e0_.featured = 1) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 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_.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;