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_language_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_language_translation t0 WHERE t0.translatable_id = 3;

"COMMIT"

"COMMIT";

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
  (
    e1_.slug = ?
    AND e0_.published = ?
    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 (e1_.slug = 'victor-atkinson' AND e0_.published = 1 AND e5_.enabled = 1) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate 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 = 22;

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
  COUNT(e0_.id) AS sclr_0
FROM
  eventic_review e0_
  LEFT JOIN eventic_event e1_ ON e0_.event_id = e1_.id
  AND (e1_.deleted_at IS NULL)
  LEFT JOIN eventic_event_translation e2_ ON e1_.id = e2_.translatable_id
WHERE
  (
    e2_.slug = ?
    AND e0_.visible = ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.created_at DESC

SELECT COUNT(e0_.id) AS sclr_0 FROM eventic_review e0_ LEFT JOIN eventic_event e1_ ON e0_.event_id = e1_.id AND (e1_.deleted_at IS NULL) LEFT JOIN eventic_event_translation e2_ ON e1_.id = e2_.translatable_id WHERE (e2_.slug = 'victor-atkinson' AND e0_.visible = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.created_at DESC;

UPDATE
  eventic_event
SET
  views = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE eventic_event SET views = 140, updated_at = '2024-11-15 08:39:15' WHERE id = 53;

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.code AS code_2,
  t0.hidden AS hidden_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  eventic_language t0
  INNER JOIN eventic_event_subtitle ON t0.id = eventic_event_subtitle.Language_Id
WHERE
  eventic_event_subtitle.Event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.hidden AS hidden_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM eventic_language t0 INNER JOIN eventic_event_subtitle ON t0.id = eventic_event_subtitle.Language_Id WHERE eventic_event_subtitle.Event_id = 53 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.hidden AS hidden_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  eventic_language t0
  INNER JOIN eventic_event_language ON t0.id = eventic_event_language.Language_Id
WHERE
  eventic_event_language.Event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.hidden AS hidden_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM eventic_language t0 INNER JOIN eventic_event_language ON t0.id = eventic_event_language.Language_Id WHERE eventic_event_language.Event_id = 53 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.online AS online_2,
  t0.meetinglink AS meetinglink_3,
  t0.active AS active_4,
  t0.reference AS reference_5,
  t0.startdate AS startdate_6,
  t0.enddate AS enddate_7,
  t0.event_id AS event_id_8,
  t0.venue_id AS venue_id_9
FROM
  eventic_event_date t0
WHERE
  t0.event_id IN (?)

SELECT t0.id AS id_1, t0.online AS online_2, t0.meetinglink AS meetinglink_3, t0.active AS active_4, t0.reference AS reference_5, t0.startdate AS startdate_6, t0.enddate AS enddate_7, t0.event_id AS event_id_8, t0.venue_id AS venue_id_9 FROM eventic_event_date t0 WHERE t0.event_id IN (53);

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.free AS free_6,
  t0.price AS price_7,
  t0.promotionalprice AS promotionalprice_8,
  t0.quantity AS quantity_9,
  t0.ticketsperattendee AS ticketsperattendee_10,
  t0.salesstartdate AS salesstartdate_11,
  t0.salesenddate AS salesenddate_12,
  t0.position AS position_13,
  t0.eventdate_id AS eventdate_id_14
FROM
  eventic_event_date_ticket t0
WHERE
  t0.eventdate_id IN (?)

SELECT t0.id AS id_1, t0.active AS active_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.free AS free_6, t0.price AS price_7, t0.promotionalprice AS promotionalprice_8, t0.quantity AS quantity_9, t0.ticketsperattendee AS ticketsperattendee_10, t0.salesstartdate AS salesstartdate_11, t0.salesenddate AS salesenddate_12, t0.position AS position_13, t0.eventdate_id AS eventdate_id_14 FROM eventic_event_date_ticket t0 WHERE t0.eventdate_id IN (50);

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.image_name AS image_name_3,
  t0.image_size AS image_size_4,
  t0.image_mime_type AS image_mime_type_5,
  t0.image_original_name AS image_original_name_6,
  t0.image_dimensions AS image_dimensions_7,
  t0.hidden AS hidden_8,
  t0.featured AS featured_9,
  t0.featuredorder AS featuredorder_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13
FROM
  eventic_category t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_mime_type AS image_mime_type_5, t0.image_original_name AS image_original_name_6, t0.image_dimensions AS image_dimensions_7, t0.hidden AS hidden_8, t0.featured AS featured_9, t0.featuredorder AS featuredorder_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13 FROM eventic_category t0 WHERE t0.id = 22 AND ((t0.deleted_at IS NULL));

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.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
  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_event_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_event_translation t0 WHERE t0.translatable_id = 53;

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.id AS id_1,
  t0.rating AS rating_2,
  t0.headline AS headline_3,
  t0.slug AS slug_4,
  t0.details AS details_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.visible AS visible_9,
  t0.event_id AS event_id_10,
  t0.user_id AS user_id_11
FROM
  eventic_review t0
WHERE
  t0.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.headline AS headline_3, t0.slug AS slug_4, t0.details AS details_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.visible AS visible_9, t0.event_id AS event_id_10, t0.user_id AS user_id_11 FROM eventic_review t0 WHERE t0.event_id = 53 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_mime_type AS image_mime_type_4,
  t0.image_original_name AS image_original_name_5,
  t0.image_dimensions AS image_dimensions_6,
  t0.hidden AS hidden_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  eventic_audience t0
  INNER JOIN eventic_event_audience ON t0.id = eventic_event_audience.Audience_Id
WHERE
  eventic_event_audience.Event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_mime_type AS image_mime_type_4, t0.image_original_name AS image_original_name_5, t0.image_dimensions AS image_dimensions_6, t0.hidden AS hidden_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM eventic_audience t0 INNER JOIN eventic_event_audience ON t0.id = eventic_event_audience.Audience_Id WHERE eventic_event_audience.Event_id = 53 AND ((t0.deleted_at IS NULL));

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

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.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.image_mime_type AS image_mime_type_4,
  t0.image_original_name AS image_original_name_5,
  t0.image_dimensions AS image_dimensions_6,
  t0.position AS position_7,
  t0.updated_at AS updated_at_8,
  t0.event_id AS event_id_9
FROM
  eventic_event_image t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_mime_type AS image_mime_type_4, t0.image_original_name AS image_original_name_5, t0.image_dimensions AS image_dimensions_6, t0.position AS position_7, t0.updated_at AS updated_at_8, t0.event_id AS event_id_9 FROM eventic_event_image t0 WHERE t0.event_id = 53;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.hidden AS hidden_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  eventic_country t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.hidden AS hidden_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM eventic_country t0 WHERE t0.id = 55 AND ((t0.deleted_at IS NULL));

SELECT
  *
FROM
  chatbot_lists
WHERE
  id = :id

SELECT * FROM  chatbot_lists WHERE id = NULL;

"START TRANSACTION"

"START TRANSACTION";