Symfony Profiler

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
WHERE
  t0.identifier = ?
LIMIT
  1

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 WHERE t0.identifier = 'THEATERKONRAD' LIMIT 1;

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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 = 1 AND t0.event_collection_id IS NULL AND t0.deleted = 0;