Symfony Profiler

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

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;

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.twitter AS twitter_9,
  t0.instagram AS instagram_10,
  t0.googleplus AS googleplus_11,
  t0.linkedin AS linkedin_12,
  t0.youtubeurl AS youtubeurl_13,
  t0.logo_name AS logo_name_14,
  t0.logo_size AS logo_size_15,
  t0.logo_mime_type AS logo_mime_type_16,
  t0.logo_original_name AS logo_original_name_17,
  t0.logo_dimensions AS logo_dimensions_18,
  t0.cover_name AS cover_name_19,
  t0.cover_size AS cover_size_20,
  t0.cover_mime_type AS cover_mime_type_21,
  t0.cover_original_name AS cover_original_name_22,
  t0.cover_dimensions AS cover_dimensions_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.deleted_at AS deleted_at_26,
  t0.views AS views_27,
  t0.showvenuesmap AS showvenuesmap_28,
  t0.showfollowers AS showfollowers_29,
  t0.showreviews AS showreviews_30,
  t0.show_event_date_stats_on_scanner_app AS show_event_date_stats_on_scanner_app_31,
  t0.allow_tap_to_check_in_on_scanner_app AS allow_tap_to_check_in_on_scanner_app_32,
  t0.user_id AS user_id_33,
  t0.country_id AS country_id_34
FROM
  eventic_organizer t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.twitter AS twitter_9, t0.instagram AS instagram_10, t0.googleplus AS googleplus_11, t0.linkedin AS linkedin_12, t0.youtubeurl AS youtubeurl_13, t0.logo_name AS logo_name_14, t0.logo_size AS logo_size_15, t0.logo_mime_type AS logo_mime_type_16, t0.logo_original_name AS logo_original_name_17, t0.logo_dimensions AS logo_dimensions_18, t0.cover_name AS cover_name_19, t0.cover_size AS cover_size_20, t0.cover_mime_type AS cover_mime_type_21, t0.cover_original_name AS cover_original_name_22, t0.cover_dimensions AS cover_dimensions_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.views AS views_27, t0.showvenuesmap AS showvenuesmap_28, t0.showfollowers AS showfollowers_29, t0.showreviews AS showreviews_30, t0.show_event_date_stats_on_scanner_app AS show_event_date_stats_on_scanner_app_31, t0.allow_tap_to_check_in_on_scanner_app AS allow_tap_to_check_in_on_scanner_app_32, t0.user_id AS user_id_33, t0.country_id AS country_id_34 FROM eventic_organizer t0 WHERE t0.id = 32 AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.description AS description_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_venue_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.description AS description_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_venue_translation t0 WHERE t0.translatable_id = 24;

SELECT
  t0.title AS title_1,
  t0.slug AS slug_2,
  t0.content AS content_3,
  t0.locale AS locale_4,
  t0.id AS id_5,
  t0.translatable_id AS translatable_id_6
FROM
  eventic_page_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.slug AS slug_2, t0.content AS content_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM eventic_page_translation t0 WHERE t0.translatable_id = 1;

SELECT
  e0_.username AS username_0,
  e0_.username_canonical AS username_canonical_1,
  e0_.email AS email_2,
  e0_.email_canonical AS email_canonical_3,
  e0_.enabled AS enabled_4,
  e0_.salt AS salt_5,
  e0_.password AS password_6,
  e0_.last_login AS last_login_7,
  e0_.confirmation_token AS confirmation_token_8,
  e0_.password_requested_at AS password_requested_at_9,
  e0_.roles AS roles_10,
  e0_.id AS id_11,
  e0_.gender AS gender_12,
  e0_.firstname AS firstname_13,
  e0_.lastname AS lastname_14,
  e0_.slug AS slug_15,
  e0_.street AS street_16,
  e0_.street2 AS street2_17,
  e0_.city AS city_18,
  e0_.state AS state_19,
  e0_.postalcode AS postalcode_20,
  e0_.phone AS phone_21,
  e0_.birthdate AS birthdate_22,
  e0_.avatar_name AS avatar_name_23,
  e0_.avatar_size AS avatar_size_24,
  e0_.avatar_mime_type AS avatar_mime_type_25,
  e0_.avatar_original_name AS avatar_original_name_26,
  e0_.avatar_dimensions AS avatar_dimensions_27,
  e0_.facebook_profile_picture AS facebook_profile_picture_28,
  e0_.created_at AS created_at_29,
  e0_.updated_at AS updated_at_30,
  e0_.deleted_at AS deleted_at_31,
  e0_.facebook_id AS facebook_id_32,
  e0_.facebook_access_token AS facebook_access_token_33,
  e0_.google_id AS google_id_34,
  e0_.google_access_token AS google_access_token_35,
  e0_.api_key AS api_key_36,
  e0_.organizer_id AS organizer_id_37,
  e0_.scanner_id AS scanner_id_38,
  e0_.pointofsale_id AS pointofsale_id_39,
  e0_.isorganizeronhomepageslider_id AS isorganizeronhomepageslider_id_40,
  e0_.country_id AS country_id_41
FROM
  eventic_user e0_
  LEFT JOIN eventic_organizer e1_ ON e0_.organizer_id = e1_.id
  AND (e1_.deleted_at IS NULL)
WHERE
  (
    e0_.roles LIKE ?
    AND e0_.enabled = ?
    AND e0_.slug <> ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.created_at DESC

SELECT e0_.username AS username_0, e0_.username_canonical AS username_canonical_1, e0_.email AS email_2, e0_.email_canonical AS email_canonical_3, e0_.enabled AS enabled_4, e0_.salt AS salt_5, e0_.password AS password_6, e0_.last_login AS last_login_7, e0_.confirmation_token AS confirmation_token_8, e0_.password_requested_at AS password_requested_at_9, e0_.roles AS roles_10, e0_.id AS id_11, e0_.gender AS gender_12, e0_.firstname AS firstname_13, e0_.lastname AS lastname_14, e0_.slug AS slug_15, e0_.street AS street_16, e0_.street2 AS street2_17, e0_.city AS city_18, e0_.state AS state_19, e0_.postalcode AS postalcode_20, e0_.phone AS phone_21, e0_.birthdate AS birthdate_22, e0_.avatar_name AS avatar_name_23, e0_.avatar_size AS avatar_size_24, e0_.avatar_mime_type AS avatar_mime_type_25, e0_.avatar_original_name AS avatar_original_name_26, e0_.avatar_dimensions AS avatar_dimensions_27, e0_.facebook_profile_picture AS facebook_profile_picture_28, e0_.created_at AS created_at_29, e0_.updated_at AS updated_at_30, e0_.deleted_at AS deleted_at_31, e0_.facebook_id AS facebook_id_32, e0_.facebook_access_token AS facebook_access_token_33, e0_.google_id AS google_id_34, e0_.google_access_token AS google_access_token_35, e0_.api_key AS api_key_36, e0_.organizer_id AS organizer_id_37, e0_.scanner_id AS scanner_id_38, e0_.pointofsale_id AS pointofsale_id_39, e0_.isorganizeronhomepageslider_id AS isorganizeronhomepageslider_id_40, e0_.country_id AS country_id_41 FROM eventic_user e0_ LEFT JOIN eventic_organizer e1_ ON e0_.organizer_id = e1_.id AND (e1_.deleted_at IS NULL) WHERE (e0_.roles LIKE '%ROLE_ORGANIZER%' AND e0_.enabled = 1 AND e0_.slug <> 'administrator') AND (e0_.deleted_at IS NULL) ORDER BY e0_.created_at DESC;

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

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;

SELECT
  e0_.id AS id_0,
  e0_.updated_at AS updated_at_1
FROM
  eventic_page e0_
  INNER JOIN eventic_page_translation e1_ ON e0_.id = e1_.translatable_id

SELECT e0_.id AS id_0, e0_.updated_at AS updated_at_1 FROM eventic_page e0_ INNER JOIN eventic_page_translation e1_ ON e0_.id = e1_.translatable_id;

SELECT
  e0_.id AS id_0,
  e0_.seatedguests AS seatedguests_1,
  e0_.standingguests AS standingguests_2,
  e0_.neighborhoods AS neighborhoods_3,
  e0_.foodbeverage AS foodbeverage_4,
  e0_.pricing AS pricing_5,
  e0_.availibility AS availibility_6,
  e0_.hidden AS hidden_7,
  e0_.showmap AS showmap_8,
  e0_.quoteform AS quoteform_9,
  e0_.street AS street_10,
  e0_.street2 AS street2_11,
  e0_.city AS city_12,
  e0_.state AS state_13,
  e0_.postalcode AS postalcode_14,
  e0_.lat AS lat_15,
  e0_.lng AS lng_16,
  e0_.listedondirectory AS listedondirectory_17,
  e0_.contactemail AS contactemail_18,
  e0_.created_at AS created_at_19,
  e0_.updated_at AS updated_at_20,
  e0_.deleted_at AS deleted_at_21,
  e0_.organizer_id AS organizer_id_22,
  e0_.type_id AS type_id_23,
  e0_.country_id AS country_id_24
FROM
  eventic_venue e0_
WHERE
  (
    e0_.hidden = ?
    AND e0_.listedondirectory = ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.created_at DESC

SELECT e0_.id AS id_0, e0_.seatedguests AS seatedguests_1, e0_.standingguests AS standingguests_2, e0_.neighborhoods AS neighborhoods_3, e0_.foodbeverage AS foodbeverage_4, e0_.pricing AS pricing_5, e0_.availibility AS availibility_6, e0_.hidden AS hidden_7, e0_.showmap AS showmap_8, e0_.quoteform AS quoteform_9, e0_.street AS street_10, e0_.street2 AS street2_11, e0_.city AS city_12, e0_.state AS state_13, e0_.postalcode AS postalcode_14, e0_.lat AS lat_15, e0_.lng AS lng_16, e0_.listedondirectory AS listedondirectory_17, e0_.contactemail AS contactemail_18, e0_.created_at AS created_at_19, e0_.updated_at AS updated_at_20, e0_.deleted_at AS deleted_at_21, e0_.organizer_id AS organizer_id_22, e0_.type_id AS type_id_23, e0_.country_id AS country_id_24 FROM eventic_venue e0_ WHERE (e0_.hidden = 0 AND e0_.listedondirectory = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.created_at DESC;

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_help_center_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_help_center_category_translation t0 WHERE t0.translatable_id = 1;

SELECT
  e0_.id AS id_0,
  e0_.icon AS icon_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,
  e0_.parent_id AS parent_id_6
FROM
  eventic_help_center_category e0_
  INNER JOIN eventic_help_center_category_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_.icon AS icon_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, e0_.parent_id AS parent_id_6 FROM eventic_help_center_category e0_ INNER JOIN eventic_help_center_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_.views AS views_1,
  e0_.hidden AS hidden_2,
  e0_.featured AS featured_3,
  e0_.created_at AS created_at_4,
  e0_.updated_at AS updated_at_5,
  e0_.deleted_at AS deleted_at_6,
  e0_.category_id AS category_id_7
FROM
  eventic_help_center_article e0_
WHERE
  (e0_.hidden = ?)
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.created_at DESC

SELECT e0_.id AS id_0, e0_.views AS views_1, e0_.hidden AS hidden_2, e0_.featured AS featured_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.deleted_at AS deleted_at_6, e0_.category_id AS category_id_7 FROM eventic_help_center_article e0_ WHERE (e0_.hidden = 0) AND (e0_.deleted_at IS NULL) ORDER BY e0_.created_at DESC;