GET https://devel.la-tickets.eu/

Query Metrics

24 Database Queries
4 Different statements
37.96 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.time_zone AS time_zone_4, t0.locale AS locale_5, t0.paypal_client_key AS paypal_client_key_6, t0.paypal_secret AS paypal_secret_7, t0.com_mail AS com_mail_8, t0.com_server AS com_server_9, t0.com_server_port AS com_server_port_10, t0.com_mail_user AS com_mail_user_11, t0.com_mail_password AS com_mail_password_12, t0.paypal_verified AS paypal_verified_13, t0.public_key AS public_key_14, t0.iban AS iban_15, t0.bic AS bic_16, t0.company_street AS company_street_17, t0.company_zip AS company_zip_18, t0.company_city AS company_city_19, t0.vat AS vat_20, t0.vat_value AS vat_value_21, t0.two_factor_required AS two_factor_required_22, t0.homepage_banner AS homepage_banner_23, t0.homepage_text AS homepage_text_24 FROM company t0
Parameters:
[]
2 1.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.long_description AS long_description_5, t0.hero_image_path AS hero_image_path_6, t0.card_image_path AS card_image_path_7, t0.company_id AS company_id_8, t9.id AS id_10, t9.data AS data_11, t9.event_collection_id AS event_collection_id_12, t9.company_id AS company_id_13 FROM event_collection t0 LEFT JOIN posters t9 ON t9.event_collection_id = t0.id WHERE t0.company_id = ?
Parameters:
[
  1
]
3 2.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  1
]
4 2.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  5
]
5 6.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  9
]
6 2.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  11
]
7 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.company_id = ? AND t0.event_collection_id IS NULL AND t0.deleted = ?
Parameters:
[
  1
  0
]
8 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.long_description AS long_description_5, t0.hero_image_path AS hero_image_path_6, t0.card_image_path AS card_image_path_7, t0.company_id AS company_id_8, t9.id AS id_10, t9.data AS data_11, t9.event_collection_id AS event_collection_id_12, t9.company_id AS company_id_13 FROM event_collection t0 LEFT JOIN posters t9 ON t9.event_collection_id = t0.id WHERE t0.company_id = ?
Parameters:
[
  2
]
9 0.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  6
]
10 2.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  7
]
11 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.company_id = ? AND t0.event_collection_id IS NULL AND t0.deleted = ?
Parameters:
[
  2
  0
]
12 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.long_description AS long_description_5, t0.hero_image_path AS hero_image_path_6, t0.card_image_path AS card_image_path_7, t0.company_id AS company_id_8, t9.id AS id_10, t9.data AS data_11, t9.event_collection_id AS event_collection_id_12, t9.company_id AS company_id_13 FROM event_collection t0 LEFT JOIN posters t9 ON t9.event_collection_id = t0.id WHERE t0.company_id = ?
Parameters:
[
  3
]
13 1.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  2
]
14 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  3
]
15 5.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  8
]
16 1.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  10
]
17 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.company_id = ? AND t0.event_collection_id IS NULL AND t0.deleted = ?
Parameters:
[
  3
  0
]
18 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.long_description AS long_description_5, t0.hero_image_path AS hero_image_path_6, t0.card_image_path AS card_image_path_7, t0.company_id AS company_id_8, t9.id AS id_10, t9.data AS data_11, t9.event_collection_id AS event_collection_id_12, t9.company_id AS company_id_13 FROM event_collection t0 LEFT JOIN posters t9 ON t9.event_collection_id = t0.id WHERE t0.company_id = ?
Parameters:
[
  4
]
19 3.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  12
]
20 1.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  13
]
21 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.company_id = ? AND t0.event_collection_id IS NULL AND t0.deleted = ?
Parameters:
[
  4
  0
]
22 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.long_description AS long_description_5, t0.hero_image_path AS hero_image_path_6, t0.card_image_path AS card_image_path_7, t0.company_id AS company_id_8, t9.id AS id_10, t9.data AS data_11, t9.event_collection_id AS event_collection_id_12, t9.company_id AS company_id_13 FROM event_collection t0 LEFT JOIN posters t9 ON t9.event_collection_id = t0.id WHERE t0.company_id = ?
Parameters:
[
  5
]
23 1.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
  14
]
24 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.company_id = ? AND t0.event_collection_id IS NULL AND t0.deleted = ?
Parameters:
[
  5
  0
]

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