https://eventos.keoscx.com/de/event/check-event

Query Metrics

73 Database Queries
33 Different statements
12.69 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.91 ms
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
Parameters:
[
  "check-event"
  1
  1
]
2 0.17 ms
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 (?)
Parameters:
[
  [
    127
  ]
]
3 0.17 ms
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 (?)
Parameters:
[
  [
    124
  ]
]
4 0.08 ms
"START TRANSACTION"
Parameters:
[]
5 0.35 ms
UPDATE eventic_event SET views = ?, updated_at = ? WHERE id = ?
Parameters:
[
  98
  "2024-09-21 08:32:07"
  127
]
6 2.19 ms
"COMMIT"
Parameters:
[]
7 0.07 ms
SELECT * FROM  chatbot_lists WHERE id = :id
Parameters:
[
  "id" => 39
]
8 0.09 ms
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 = ?
Parameters:
[
  127
]
9 0.10 ms
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 = ?
Parameters:
[
  1
]
10 0.12 ms
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 = ?
Parameters:
[
  "header-menu"
]
11 0.10 ms
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
Parameters:
[
  1
]
12 0.09 ms
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 = ?
Parameters:
[
  1
]
13 0.09 ms
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 = ?
Parameters:
[
  2
]
14 0.07 ms
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 = ?
Parameters:
[
  3
]
15 0.10 ms
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
Parameters:
[
  0
  1
]
16 0.44 ms
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 = ?
Parameters:
[
  19
]
17 0.07 ms
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 = ?
Parameters:
[
  22
]
18 0.07 ms
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 = ?
Parameters:
[
  16
]
19 0.07 ms
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 = ?
Parameters:
[
  18
]
20 0.07 ms
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 = ?
Parameters:
[
  21
]
21 0.18 ms
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 = ?
Parameters:
[
  15
]
22 0.07 ms
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 = ?
Parameters:
[
  20
]
23 0.18 ms
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 = ?
Parameters:
[
  17
]
24 0.08 ms
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 = ?
Parameters:
[
  4
]
25 0.07 ms
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 = ?
Parameters:
[
  5
]
26 0.07 ms
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 = ?
Parameters:
[
  6
]
27 0.08 ms
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 = ?
Parameters:
[
  7
]
28 0.07 ms
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 = ?
Parameters:
[
  8
]
29 0.54 ms
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
Parameters:
[
  "check-event"
  1
]
30 0.08 ms
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))
Parameters:
[
  127
]
31 0.07 ms
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))
Parameters:
[
  127
]
32 0.06 ms
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))
Parameters:
[
  127
]
33 0.07 ms
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))
Parameters:
[
  127
]
34 0.07 ms
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 = ?
Parameters:
[
  127
]
35 0.32 ms
SELECT e0_.id AS id_0, e0_.rating AS rating_1, e0_.headline AS headline_2, e0_.slug AS slug_3, e0_.details AS details_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, e0_.deleted_at AS deleted_at_7, e0_.visible AS visible_8, e0_.event_id AS event_id_9, e0_.user_id AS user_id_10 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 LIMIT 8
Parameters:
[
  "check-event"
  1
]
36 0.10 ms
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))
Parameters:
[
  16
]
37 0.12 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.gender AS gender_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.slug AS slug_16, t0.street AS street_17, t0.street2 AS street2_18, t0.city AS city_19, t0.state AS state_20, t0.postalcode AS postalcode_21, t0.phone AS phone_22, t0.birthdate AS birthdate_23, t0.avatar_name AS avatar_name_24, t0.avatar_size AS avatar_size_25, t0.avatar_mime_type AS avatar_mime_type_26, t0.avatar_original_name AS avatar_original_name_27, t0.avatar_dimensions AS avatar_dimensions_28, t0.facebook_profile_picture AS facebook_profile_picture_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.deleted_at AS deleted_at_32, t0.facebook_id AS facebook_id_33, t0.facebook_access_token AS facebook_access_token_34, t0.google_id AS google_id_35, t0.google_access_token AS google_access_token_36, t0.api_key AS api_key_37, t0.organizer_id AS organizer_id_38, t0.scanner_id AS scanner_id_39, t0.pointofsale_id AS pointofsale_id_40, t0.isorganizeronhomepageslider_id AS isorganizeronhomepageslider_id_41, t0.country_id AS country_id_42 FROM eventic_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  49
]
38 0.08 ms
SELECT t0.id AS id_1, t0.unitprice AS unitprice_2, t0.quantity AS quantity_3, t0.deleted_at AS deleted_at_4, t0.order_id AS order_id_5, t0.eventticket_id AS eventticket_id_6 FROM eventic_order_element t0 WHERE t0.eventticket_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  124
]
39 0.12 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.expires_at AS expires_at_4, t0.deleted_at AS deleted_at_5, t0.eventticket_id AS eventticket_id_6, t0.user_id AS user_id_7, t0.orderelement_id AS orderelement_id_8 FROM eventic_ticket_reservation t0 WHERE t0.orderelement_id IN (?) AND ((t0.deleted_at IS NULL))
Parameters:
[
  [
    2325
    2331
  ]
]
40 0.11 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ticket_send_status AS ticket_send_status_3, t0.note AS note_4, t0.status AS status_5, t0.ticket_fee AS ticket_fee_6, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_7, t0.currency_ccy AS currency_ccy_8, t0.currency_symbol AS currency_symbol_9, t0.created_at AS created_at_10, t0.join_time AS join_time_11, t0.join_meeting AS join_meeting_12, t0.venue AS venue_13, t0.user_id AS user_id_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.user_id AS user_id_17, t0.paymentgateway_id AS paymentgateway_id_18, t0.payment_id AS payment_id_19, t20.number AS number_21, t20.description AS description_22, t20.client_email AS client_email_23, t20.client_id AS client_id_24, t20.total_amount AS total_amount_25, t20.currency_code AS currency_code_26, t20.details AS details_27, t20.id AS id_28, t20.status AS status_29, t20.firstname AS firstname_30, t20.lastname AS lastname_31, t20.state AS state_32, t20.city AS city_33, t20.postalcode AS postalcode_34, t20.street AS street_35, t20.street2 AS street2_36, t20.name_on_ticket AS name_on_ticket_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.deleted_at AS deleted_at_40, t20.order_id AS order_id_41, t20.country_id AS country_id_42 FROM eventic_order t0 LEFT JOIN eventic_payment t20 ON t0.payment_id = t20.id AND ((t20.deleted_at IS NULL)) WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  2303
]
41 0.10 ms
SELECT t0.id AS id_1, t0.unitprice AS unitprice_2, t0.quantity AS quantity_3, t0.deleted_at AS deleted_at_4, t0.order_id AS order_id_5, t0.eventticket_id AS eventticket_id_6 FROM eventic_order_element t0 WHERE t0.order_id IN (?) AND ((t0.deleted_at IS NULL))
Parameters:
[
  [
    2303
  ]
]
42 0.10 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.gender AS gender_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.slug AS slug_16, t0.street AS street_17, t0.street2 AS street2_18, t0.city AS city_19, t0.state AS state_20, t0.postalcode AS postalcode_21, t0.phone AS phone_22, t0.birthdate AS birthdate_23, t0.avatar_name AS avatar_name_24, t0.avatar_size AS avatar_size_25, t0.avatar_mime_type AS avatar_mime_type_26, t0.avatar_original_name AS avatar_original_name_27, t0.avatar_dimensions AS avatar_dimensions_28, t0.facebook_profile_picture AS facebook_profile_picture_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.deleted_at AS deleted_at_32, t0.facebook_id AS facebook_id_33, t0.facebook_access_token AS facebook_access_token_34, t0.google_id AS google_id_35, t0.google_access_token AS google_access_token_36, t0.api_key AS api_key_37, t0.organizer_id AS organizer_id_38, t0.scanner_id AS scanner_id_39, t0.pointofsale_id AS pointofsale_id_40, t0.isorganizeronhomepageslider_id AS isorganizeronhomepageslider_id_41, t0.country_id AS country_id_42 FROM eventic_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  3828
]
43 0.10 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ticket_send_status AS ticket_send_status_3, t0.note AS note_4, t0.status AS status_5, t0.ticket_fee AS ticket_fee_6, t0.ticket_price_percentage_cut AS ticket_price_percentage_cut_7, t0.currency_ccy AS currency_ccy_8, t0.currency_symbol AS currency_symbol_9, t0.created_at AS created_at_10, t0.join_time AS join_time_11, t0.join_meeting AS join_meeting_12, t0.venue AS venue_13, t0.user_id AS user_id_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.user_id AS user_id_17, t0.paymentgateway_id AS paymentgateway_id_18, t0.payment_id AS payment_id_19, t20.number AS number_21, t20.description AS description_22, t20.client_email AS client_email_23, t20.client_id AS client_id_24, t20.total_amount AS total_amount_25, t20.currency_code AS currency_code_26, t20.details AS details_27, t20.id AS id_28, t20.status AS status_29, t20.firstname AS firstname_30, t20.lastname AS lastname_31, t20.state AS state_32, t20.city AS city_33, t20.postalcode AS postalcode_34, t20.street AS street_35, t20.street2 AS street2_36, t20.name_on_ticket AS name_on_ticket_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.deleted_at AS deleted_at_40, t20.order_id AS order_id_41, t20.country_id AS country_id_42 FROM eventic_order t0 LEFT JOIN eventic_payment t20 ON t0.payment_id = t20.id AND ((t20.deleted_at IS NULL)) WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  2309
]
44 0.09 ms
SELECT t0.id AS id_1, t0.unitprice AS unitprice_2, t0.quantity AS quantity_3, t0.deleted_at AS deleted_at_4, t0.order_id AS order_id_5, t0.eventticket_id AS eventticket_id_6 FROM eventic_order_element t0 WHERE t0.order_id IN (?) AND ((t0.deleted_at IS NULL))
Parameters:
[
  [
    2309
  ]
]
45 0.09 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.gender AS gender_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.slug AS slug_16, t0.street AS street_17, t0.street2 AS street2_18, t0.city AS city_19, t0.state AS state_20, t0.postalcode AS postalcode_21, t0.phone AS phone_22, t0.birthdate AS birthdate_23, t0.avatar_name AS avatar_name_24, t0.avatar_size AS avatar_size_25, t0.avatar_mime_type AS avatar_mime_type_26, t0.avatar_original_name AS avatar_original_name_27, t0.avatar_dimensions AS avatar_dimensions_28, t0.facebook_profile_picture AS facebook_profile_picture_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.deleted_at AS deleted_at_32, t0.facebook_id AS facebook_id_33, t0.facebook_access_token AS facebook_access_token_34, t0.google_id AS google_id_35, t0.google_access_token AS google_access_token_36, t0.api_key AS api_key_37, t0.organizer_id AS organizer_id_38, t0.scanner_id AS scanner_id_39, t0.pointofsale_id AS pointofsale_id_40, t0.isorganizeronhomepageslider_id AS isorganizeronhomepageslider_id_41, t0.country_id AS country_id_42 FROM eventic_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  3829
]
46 1.04 ms
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) INNER JOIN eventic_order e2_ ON e0_.id = e2_.user_id AND (e2_.deleted_at IS NULL) INNER JOIN eventic_order_element e3_ ON e2_.id = e3_.order_id AND (e3_.deleted_at IS NULL) INNER JOIN eventic_event_date_ticket e4_ ON e3_.eventticket_id = e4_.id INNER JOIN eventic_event_date e5_ ON e4_.eventdate_id = e5_.id INNER JOIN eventic_event e6_ ON e5_.event_id = e6_.id AND (e6_.deleted_at IS NULL) INNER JOIN eventic_event_translation e7_ ON e6_.id = e7_.translatable_id WHERE (e0_.roles LIKE ? AND e0_.enabled = ? AND e2_.status = ? AND e7_.slug = ? AND e0_.slug <> ?) AND (e0_.deleted_at IS NULL) ORDER BY e2_.created_at DESC
Parameters:
[
  "%ROLE_ATTENDEE%"
  1
  1
  "check-event"
  "administrator"
]
47 0.88 ms
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) INNER JOIN eventic_order e2_ ON e0_.id = e2_.user_id AND (e2_.deleted_at IS NULL) INNER JOIN eventic_order_element e3_ ON e2_.id = e3_.order_id AND (e3_.deleted_at IS NULL) INNER JOIN eventic_event_date_ticket e4_ ON e3_.eventticket_id = e4_.id INNER JOIN eventic_event_date e5_ ON e4_.eventdate_id = e5_.id INNER JOIN eventic_event e6_ ON e5_.event_id = e6_.id AND (e6_.deleted_at IS NULL) INNER JOIN eventic_event_translation e7_ ON e6_.id = e7_.translatable_id WHERE (e0_.roles LIKE ? AND e0_.enabled = ? AND e2_.status = ? AND e7_.slug = ? AND e0_.slug <> ?) AND (e0_.deleted_at IS NULL) ORDER BY e2_.created_at DESC LIMIT 12
Parameters:
[
  "%ROLE_ATTENDEE%"
  1
  1
  "check-event"
  "administrator"
]
48 0.30 ms
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 (e4_.slug = ? AND e0_.published = ? AND e1_.slug <> ? AND e1_.slug = ? AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = ?) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC LIMIT 8
Parameters:
[
  "keos-2"
  1
  "check-event"
  "check-event"
  1
]
49 0.30 ms
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_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 e1_.slug <> ? AND e1_.slug = ? AND e4_.startdate >= CURRENT_TIMESTAMP AND e7_.enabled = ?) AND (e0_.deleted_at IS NULL) ORDER BY e4_.startdate ASC LIMIT 8
Parameters:
[
  "cata-de-vino"
  1
  "check-event"
  "check-event"
  1
]
50 0.07 ms
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 = ?
Parameters:
[
  "first-footer-section-menu"
]
51 0.08 ms
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 = ?
Parameters:
[
  2
]
52 0.07 ms
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 = ?
Parameters:
[
  "first-footer-section-menu"
]
53 0.07 ms
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
Parameters:
[
  2
]
54 0.08 ms
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 = ?
Parameters:
[
  9
]
55 0.07 ms
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 = ?
Parameters:
[
  10
]
56 0.07 ms
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 = ?
Parameters:
[
  11
]
57 0.07 ms
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 = ?
Parameters:
[
  12
]
58 0.08 ms
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 = ?
Parameters:
[
  13
]
59 0.06 ms
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 = ?
Parameters:
[
  "second-footer-section-menu"
]
60 0.07 ms
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 = ?
Parameters:
[
  3
]
61 0.07 ms
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 = ?
Parameters:
[
  "second-footer-section-menu"
]
62 0.07 ms
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
Parameters:
[
  3
]
63 0.07 ms
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 = ?
Parameters:
[
  14
]
64 0.07 ms
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 = ?
Parameters:
[
  15
]
65 0.08 ms
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 = ?
Parameters:
[
  16
]
66 0.07 ms
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 = ?
Parameters:
[
  17
]
67 0.07 ms
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 = ?
Parameters:
[
  18
]
68 0.06 ms
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 = ?
Parameters:
[
  "third-footer-section-menu"
]
69 0.07 ms
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 = ?
Parameters:
[
  4
]
70 0.06 ms
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 = ?
Parameters:
[
  "third-footer-section-menu"
]
71 0.07 ms
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
Parameters:
[
  4
]
72 0.09 ms
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
Parameters:
[
  0
  1
]
73 0.07 ms
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 = ?
Parameters:
[
  20
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\EventTranslation No errors.
App\Entity\EventDate No errors.
App\Entity\Venue No errors.
App\Entity\Organizer No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
App\Entity\Category No errors.
App\Entity\Country No errors.
App\Entity\HomepageHeroSettings No errors.
App\Entity\Language No errors.
App\Entity\Audience No errors.
App\Entity\EventImage No errors.
App\Entity\Review No errors.
App\Entity\EventTicket No errors.
App\Entity\Scanner No errors.
App\Entity\PointOfSale No errors.
App\Entity\PayoutRequest No errors.
App\Entity\CartElement No errors.
App\Entity\OrderElement No errors.
App\Entity\TicketReservation No errors.
App\Entity\AppLayoutSettings No errors.
App\Entity\Menu No errors.
App\Entity\MenuTranslation No errors.
App\Entity\MenuElement No errors.
App\Entity\MenuElementTranslation No errors.
App\Entity\CategoryTranslation No errors.
Payum\Core\Model\GatewayConfig No errors.
App\Entity\PaymentGateway No errors.
App\Entity\Order No errors.
App\Entity\OrderTicket No errors.
Payum\Core\Model\Payment No errors.
App\Entity\Payment No errors.