Symfony Profiler

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.preis AS preis_7,
  t0.kontingent_gesamt AS kontingent_gesamt_8,
  t0.kontingent_frei AS kontingent_frei_9,
  t0.release_datum AS release_datum_10,
  t0.preisDefault AS preisDefault_11,
  t0.preis_mit_zuschlag AS preis_mit_zuschlag_12,
  t0.staffelpreise AS staffelpreise_13,
  t0.sb_user AS sb_user_14,
  t0.reiseobjekt_option_id AS reiseobjekt_option_id_15,
  t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_16,
  t0.status_id AS status_id_17
FROM
  verkaufskondition_termin_preis t0
WHERE
  t0.verkaufskondition_termin_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.staffelpreise AS staffelpreise_13, t0.sb_user AS sb_user_14, t0.reiseobjekt_option_id AS reiseobjekt_option_id_15, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_16, t0.status_id AS status_id_17 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = 11871 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.parent AS parent_7,
  t0.parent_property AS parent_property_8,
  t0.text AS text_9,
  t0.sb_user AS sb_user_10,
  t0.sprache_id AS sprache_id_11
FROM
  sprache_text t0
WHERE
  t0.parent = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.parent AS parent_7, t0.parent_property AS parent_property_8, t0.text AS text_9, t0.sb_user AS sb_user_10, t0.sprache_id AS sprache_id_11 FROM sprache_text t0 WHERE t0.parent = 'App\\Entity\\Reise\\Paket\\Paket:34' AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.type AS type_7,
  t0.rang AS rang_8,
  t0.from_iata AS from_iata_9,
  t0.to_iata AS to_iata_10,
  t0.nachtflug AS nachtflug_11,
  t0.pnr AS pnr_12,
  t0.flight_number AS flight_number_13,
  t0.earliest_departure AS earliest_departure_14,
  t0.latest_arrival AS latest_arrival_15,
  t0.flight_class AS flight_class_16,
  t0.sb_user AS sb_user_17,
  t0.termin AS termin_18,
  t0.platzhalter_id AS platzhalter_id_19
FROM
  termin_flight t0
WHERE
  t0.termin = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.rang ASC

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.pnr AS pnr_12, t0.flight_number AS flight_number_13, t0.earliest_departure AS earliest_departure_14, t0.latest_arrival AS latest_arrival_15, t0.flight_class AS flight_class_16, t0.sb_user AS sb_user_17, t0.termin AS termin_18, t0.platzhalter_id AS platzhalter_id_19 FROM termin_flight t0 WHERE t0.termin = 'NASOS_2026-09-05' AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.tempFlag AS tempFlag_6,
  t0.deleteFlag AS deleteFlag_7,
  t0.id AS id_8,
  t0.datum AS datum_9,
  t0.saison AS saison_10,
  t0.min_personen AS min_personen_11,
  t0.max_personen AS max_personen_12,
  t0.bemerkung AS bemerkung_13,
  t0.sb_user AS sb_user_14,
  t0.verkaufskondition_id AS verkaufskondition_id_15,
  t0.status_id AS status_id_16
FROM
  verkaufskondition_termin t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.datum AS datum_9, t0.saison AS saison_10, t0.min_personen AS min_personen_11, t0.max_personen AS max_personen_12, t0.bemerkung AS bemerkung_13, t0.sb_user AS sb_user_14, t0.verkaufskondition_id AS verkaufskondition_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin t0 WHERE t0.id = 15996 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.origin AS origin_7,
  t0.media_file_name AS media_file_name_8,
  t0.media_file_id AS media_file_id_9,
  t0.media_file_url AS media_file_url_10,
  t0.alt_text AS alt_text_11,
  t0.media_file_type AS media_file_type_12,
  t0.blur_hash AS blur_hash_13,
  t0.metadata AS metadata_14,
  t0.parent AS parent_15,
  t0.rang AS rang_16,
  t0.available AS available_17,
  t0.sb_user AS sb_user_18
FROM
  media t0
WHERE
  t0.parent = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.origin AS origin_7, t0.media_file_name AS media_file_name_8, t0.media_file_id AS media_file_id_9, t0.media_file_url AS media_file_url_10, t0.alt_text AS alt_text_11, t0.media_file_type AS media_file_type_12, t0.blur_hash AS blur_hash_13, t0.metadata AS metadata_14, t0.parent AS parent_15, t0.rang AS rang_16, t0.available AS available_17, t0.sb_user AS sb_user_18 FROM media t0 WHERE t0.parent = 'App\\Entity\\Reise\\Paket\\Paket:34' AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.tempFlag AS tempFlag_6,
  t0.deleteFlag AS deleteFlag_7,
  t0.id AS id_8,
  t0.username AS username_9,
  t0.vorname AS vorname_10,
  t0.nachname AS nachname_11,
  t0.password AS password_12,
  t0.email AS email_13,
  t0.to_user AS to_user_14,
  t0.auth_counter AS auth_counter_15,
  t0.auth_sperre AS auth_sperre_16,
  t0.telefonnummer AS telefonnummer_17,
  t0.kuerzel AS kuerzel_18,
  t0.veroeffentlichen AS veroeffentlichen_19,
  t0.geburtstag AS geburtstag_20,
  t0.letzter_login AS letzter_login_21,
  t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22,
  t0.text AS text_23,
  t0.signatur_email AS signatur_email_24,
  t0.token AS token_25,
  t0.to2_token AS to2_token_26,
  t0.sb_user AS sb_user_27,
  t0.geschlecht_id AS geschlecht_id_28,
  t0.sprache_id AS sprache_id_29,
  t0.abteilung_id AS abteilung_id_30
FROM
  user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.username AS username_9, t0.vorname AS vorname_10, t0.nachname AS nachname_11, t0.password AS password_12, t0.email AS email_13, t0.to_user AS to_user_14, t0.auth_counter AS auth_counter_15, t0.auth_sperre AS auth_sperre_16, t0.telefonnummer AS telefonnummer_17, t0.kuerzel AS kuerzel_18, t0.veroeffentlichen AS veroeffentlichen_19, t0.geburtstag AS geburtstag_20, t0.letzter_login AS letzter_login_21, t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22, t0.text AS text_23, t0.signatur_email AS signatur_email_24, t0.token AS token_25, t0.to2_token AS to2_token_26, t0.sb_user AS sb_user_27, t0.geschlecht_id AS geschlecht_id_28, t0.sprache_id AS sprache_id_29, t0.abteilung_id AS abteilung_id_30 FROM user t0 WHERE t0.id = 92 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.bezeichnung AS bezeichnung_7,
  t0.kuerzel AS kuerzel_8,
  t0.rang AS rang_9,
  t0.vorgangsbetreuung AS vorgangsbetreuung_10,
  t0.in_kalender AS in_kalender_11,
  t0.ist_queue AS ist_queue_12,
  t0.signatur_email AS signatur_email_13,
  t0.type AS type_14,
  t0.sb_user AS sb_user_15,
  t0.user_id AS user_id_16
FROM
  abteilung t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.bezeichnung AS bezeichnung_7, t0.kuerzel AS kuerzel_8, t0.rang AS rang_9, t0.vorgangsbetreuung AS vorgangsbetreuung_10, t0.in_kalender AS in_kalender_11, t0.ist_queue AS ist_queue_12, t0.signatur_email AS signatur_email_13, t0.type AS type_14, t0.sb_user AS sb_user_15, t0.user_id AS user_id_16 FROM abteilung t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.sb_user AS sb_user_7,
  t0.media_id AS media_id_8,
  t0.key_id AS key_id_9
FROM
  media_key_type t0
WHERE
  t0.media_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.sb_user AS sb_user_7, t0.media_id AS media_id_8, t0.key_id AS key_id_9 FROM media_key_type t0 WHERE t0.media_id = 275 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.tempFlag AS tempFlag_6,
  t0.deleteFlag AS deleteFlag_7,
  t0.id AS id_8,
  t0.code AS code_9,
  t0.int_beschreibung AS int_beschreibung_10,
  t0.no_index AS no_index_11,
  t0.no_follow AS no_follow_12,
  t0.type AS type_13,
  t0.sb_user AS sb_user_14
FROM
  metainfo t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.code AS code_9, t0.int_beschreibung AS int_beschreibung_10, t0.no_index AS no_index_11, t0.no_follow AS no_follow_12, t0.type AS type_13, t0.sb_user AS sb_user_14 FROM metainfo t0 WHERE t0.id = 16 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.bezeichnung AS bezeichnung_7,
  t0.lt_einkauf_is_vor_ort AS lt_einkauf_is_vor_ort_8,
  t0.position_is_lt AS position_is_lt_9,
  t0.keine_lage AS keine_lage_10,
  t0.url AS url_11,
  t0.to2id AS to2id_12,
  t0.logistik_in_vorgaengen_aktiv AS logistik_in_vorgaengen_aktiv_13,
  t0.logistik_frontend_abwaehlbar AS logistik_frontend_abwaehlbar_14,
  t0.logistik_backend_automatisch AS logistik_backend_automatisch_15,
  t0.logistik_backend_modus AS logistik_backend_modus_16,
  t0.logistik_ausnahmen_invertiert AS logistik_ausnahmen_invertiert_17,
  t0.logistik_ausnahme_reisecodes AS logistik_ausnahme_reisecodes_18,
  t0.sb_user AS sb_user_19,
  t0.type_id AS type_id_20,
  t0.lt_ag_einkauf_id AS lt_ag_einkauf_id_21,
  t0.lt_ag_vorOrt_id AS lt_ag_vorOrt_id_22,
  t23.deleted_at AS deleted_at_24,
  t23.anlage_datum AS anlage_datum_25,
  t23.aenderung_datum AS aenderung_datum_26,
  t23.aktiv AS aktiv_27,
  t23.sb_name AS sb_name_28,
  t23.id AS id_29,
  t23.strasse AS strasse_30,
  t23.bundesland AS bundesland_31,
  t23.hausnummer AS hausnummer_32,
  t23.zusatz AS zusatz_33,
  t23.plz AS plz_34,
  t23.ort AS ort_35,
  t23.rang AS rang_36,
  t23.anmerkung AS anmerkung_37,
  t23.is_default AS is_default_38,
  t23.latitude AS latitude_39,
  t23.longitude AS longitude_40,
  t23.to2id AS to2id_41,
  t23.sb_user AS sb_user_42,
  t23.land_id AS land_id_43,
  t23.kunde_id AS kunde_id_44,
  t23.reiseobjekt_id AS reiseobjekt_id_45,
  t23.poi_id AS poi_id_46,
  t23.agentur_id AS agentur_id_47,
  t0.metainfo_id AS metainfo_id_48,
  t0.fibukonto_storno_id AS fibukonto_storno_id_49,
  t0.fibukonto_erloes_id AS fibukonto_erloes_id_50,
  t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_51,
  t0.kostenstelle_id AS kostenstelle_id_52,
  t0.kostentraeger_id AS kostentraeger_id_53,
  t0.verteilungsschema_id AS verteilungsschema_id_54,
  t0.logistik_default_option_id AS logistik_default_option_id_55
FROM
  reiseobjekt t0
  LEFT JOIN adresse t23 ON t23.reiseobjekt_id = t0.id
  AND (
    (t23.deleted_at IS NULL)
  )
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.bezeichnung AS bezeichnung_7, t0.lt_einkauf_is_vor_ort AS lt_einkauf_is_vor_ort_8, t0.position_is_lt AS position_is_lt_9, t0.keine_lage AS keine_lage_10, t0.url AS url_11, t0.to2id AS to2id_12, t0.logistik_in_vorgaengen_aktiv AS logistik_in_vorgaengen_aktiv_13, t0.logistik_frontend_abwaehlbar AS logistik_frontend_abwaehlbar_14, t0.logistik_backend_automatisch AS logistik_backend_automatisch_15, t0.logistik_backend_modus AS logistik_backend_modus_16, t0.logistik_ausnahmen_invertiert AS logistik_ausnahmen_invertiert_17, t0.logistik_ausnahme_reisecodes AS logistik_ausnahme_reisecodes_18, t0.sb_user AS sb_user_19, t0.type_id AS type_id_20, t0.lt_ag_einkauf_id AS lt_ag_einkauf_id_21, t0.lt_ag_vorOrt_id AS lt_ag_vorOrt_id_22, t23.deleted_at AS deleted_at_24, t23.anlage_datum AS anlage_datum_25, t23.aenderung_datum AS aenderung_datum_26, t23.aktiv AS aktiv_27, t23.sb_name AS sb_name_28, t23.id AS id_29, t23.strasse AS strasse_30, t23.bundesland AS bundesland_31, t23.hausnummer AS hausnummer_32, t23.zusatz AS zusatz_33, t23.plz AS plz_34, t23.ort AS ort_35, t23.rang AS rang_36, t23.anmerkung AS anmerkung_37, t23.is_default AS is_default_38, t23.latitude AS latitude_39, t23.longitude AS longitude_40, t23.to2id AS to2id_41, t23.sb_user AS sb_user_42, t23.land_id AS land_id_43, t23.kunde_id AS kunde_id_44, t23.reiseobjekt_id AS reiseobjekt_id_45, t23.poi_id AS poi_id_46, t23.agentur_id AS agentur_id_47, t0.metainfo_id AS metainfo_id_48, t0.fibukonto_storno_id AS fibukonto_storno_id_49, t0.fibukonto_erloes_id AS fibukonto_erloes_id_50, t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_51, t0.kostenstelle_id AS kostenstelle_id_52, t0.kostentraeger_id AS kostentraeger_id_53, t0.verteilungsschema_id AS verteilungsschema_id_54, t0.logistik_default_option_id AS logistik_default_option_id_55 FROM reiseobjekt t0 LEFT JOIN adresse t23 ON t23.reiseobjekt_id = t0.id AND ((t23.deleted_at IS NULL)) WHERE t0.id = 107 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.bezeichnung AS bezeichnung_7,
  t0.sb_user AS sb_user_8
FROM
  role t0
  INNER JOIN role_user ON t0.id = role_user.role_id
WHERE
  role_user.user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.bezeichnung AS bezeichnung_7, t0.sb_user AS sb_user_8 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = 54 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.reisecode AS reisecode_7,
  t0.dauer AS dauer_8,
  t0.dauer_max AS dauer_max_9,
  t0.info_intern AS info_intern_10,
  t0.co2emission AS co2emission_11,
  t0.co2emission_flug AS co2emission_flug_12,
  t0.co2emission_transport AS co2emission_transport_13,
  t0.co2emission_unterkunft AS co2emission_unterkunft_14,
  t0.co2emission_aktivitaet AS co2emission_aktivitaet_15,
  t0.local_share AS local_share_16,
  t0.zertifikat_flaeche AS zertifikat_flaeche_17,
  t0.vererbung_config AS vererbung_config_18,
  t0.subpaket_kennung AS subpaket_kennung_19,
  t0.sb_user AS sb_user_20,
  t0.subpaketVon_id AS subpaketVon_id_21,
  t0.key_id AS key_id_22,
  t0.metainfo_id AS metainfo_id_23
FROM
  paket t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.reisecode AS reisecode_7, t0.dauer AS dauer_8, t0.dauer_max AS dauer_max_9, t0.info_intern AS info_intern_10, t0.co2emission AS co2emission_11, t0.co2emission_flug AS co2emission_flug_12, t0.co2emission_transport AS co2emission_transport_13, t0.co2emission_unterkunft AS co2emission_unterkunft_14, t0.co2emission_aktivitaet AS co2emission_aktivitaet_15, t0.local_share AS local_share_16, t0.zertifikat_flaeche AS zertifikat_flaeche_17, t0.vererbung_config AS vererbung_config_18, t0.subpaket_kennung AS subpaket_kennung_19, t0.sb_user AS sb_user_20, t0.subpaketVon_id AS subpaketVon_id_21, t0.key_id AS key_id_22, t0.metainfo_id AS metainfo_id_23 FROM paket t0 WHERE t0.id = '34' AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.tempFlag AS tempFlag_6,
  t0.deleteFlag AS deleteFlag_7,
  t0.id AS id_8,
  t0.username AS username_9,
  t0.vorname AS vorname_10,
  t0.nachname AS nachname_11,
  t0.password AS password_12,
  t0.email AS email_13,
  t0.to_user AS to_user_14,
  t0.auth_counter AS auth_counter_15,
  t0.auth_sperre AS auth_sperre_16,
  t0.telefonnummer AS telefonnummer_17,
  t0.kuerzel AS kuerzel_18,
  t0.veroeffentlichen AS veroeffentlichen_19,
  t0.geburtstag AS geburtstag_20,
  t0.letzter_login AS letzter_login_21,
  t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22,
  t0.text AS text_23,
  t0.signatur_email AS signatur_email_24,
  t0.token AS token_25,
  t0.to2_token AS to2_token_26,
  t0.sb_user AS sb_user_27,
  t0.geschlecht_id AS geschlecht_id_28,
  t0.sprache_id AS sprache_id_29,
  t0.abteilung_id AS abteilung_id_30
FROM
  user t0
WHERE
  t0.token = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.username AS username_9, t0.vorname AS vorname_10, t0.nachname AS nachname_11, t0.password AS password_12, t0.email AS email_13, t0.to_user AS to_user_14, t0.auth_counter AS auth_counter_15, t0.auth_sperre AS auth_sperre_16, t0.telefonnummer AS telefonnummer_17, t0.kuerzel AS kuerzel_18, t0.veroeffentlichen AS veroeffentlichen_19, t0.geburtstag AS geburtstag_20, t0.letzter_login AS letzter_login_21, t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22, t0.text AS text_23, t0.signatur_email AS signatur_email_24, t0.token AS token_25, t0.to2_token AS to2_token_26, t0.sb_user AS sb_user_27, t0.geschlecht_id AS geschlecht_id_28, t0.sprache_id AS sprache_id_29, t0.abteilung_id AS abteilung_id_30 FROM user t0 WHERE t0.token = 'qkTJjXyKOG3D8Eqqn6RBf4Y9Mi0pfTnKDmOE9tKYSOYxMnoVe0KNkL9wGg3I9YtqNcxItOMrvtqdhqpWxsJRDCamzr7isg8njocvzpbK2YbmyUgsVUc2gR0RuhbbBxJUTYbsREHmKNpWBJwVoEwBLB4nAcWvK4PoyDWKiv3ZQVgsds46oQemyOU4lr4GcG8tsD1fy9iBoLRd70PAhFokd7Xs01M27vowCon5Ye9A0j3zE68Q3Gos2E4ckflyS37VdxsvDE4vt7kclunbm3PfIU55AIrGKCMwEtUuQNHoSBysdDHkBjmx6nUc6sF8c4eHJZOcyL6ZZ36qXeq1aM9ioL5aFCtpQvQQ4VSwjg8kNnn09hMAdhVTQgcxALM0TqeriusSjyVpkmxOa3231231' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.modus_zeitspanne AS modus_zeitspanne_7,
  t0.nur_aktiv_als AS nur_aktiv_als_8,
  t0.unterkunft_bedingung AS unterkunft_bedingung_9,
  t0.leistungsregel_notiz AS leistungsregel_notiz_10,
  t0.dauer AS dauer_11,
  t0.max_dauer AS max_dauer_12,
  t0.w_buchungsstr_sichtbar AS w_buchungsstr_sichtbar_13,
  t0.w_buchungsstr_preis_sichtbar AS w_buchungsstr_preis_sichtbar_14,
  t0.auf_dokumenten_sichtbar AS auf_dokumenten_sichtbar_15,
  t0.is_standard_leistung AS is_standard_leistung_16,
  t0.anz_validation AS anz_validation_17,
  t0.auswahlopt_buchungsstr AS auswahlopt_buchungsstr_18,
  t0.passdaten_relevant_override AS passdaten_relevant_override_19,
  t0.pass_typ_override AS pass_typ_override_20,
  t0.pass_kopie_override AS pass_kopie_override_21,
  t0.adresse_relevant_override AS adresse_relevant_override_22,
  t0.telefondaten_relevant_override AS telefondaten_relevant_override_23,
  t0.rang AS rang_24,
  t0.pflicht AS pflicht_25,
  t0.start_option AS start_option_26,
  t0.start_verschiebung AS start_verschiebung_27,
  t0.sb_user AS sb_user_28,
  t0.gruppenelement_id AS gruppenelement_id_29,
  t0.paket_id AS paket_id_30,
  t0.reisobjekt_id AS reisobjekt_id_31,
  t0.key_id AS key_id_32,
  t0.vkk_id AS vkk_id_33,
  t0.fibukonto_storno_id AS fibukonto_storno_id_34,
  t0.fibukonto_erloes_id AS fibukonto_erloes_id_35,
  t0.kostenstelle_id AS kostenstelle_id_36,
  t0.kostentraeger_id AS kostentraeger_id_37,
  t0.verteilungsschema_id AS verteilungsschema_id_38,
  t0.start_leistung_id AS start_leistung_id_39
FROM
  paket_reiseobjekt t0
WHERE
  t0.paket_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.rang ASC

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.modus_zeitspanne AS modus_zeitspanne_7, t0.nur_aktiv_als AS nur_aktiv_als_8, t0.unterkunft_bedingung AS unterkunft_bedingung_9, t0.leistungsregel_notiz AS leistungsregel_notiz_10, t0.dauer AS dauer_11, t0.max_dauer AS max_dauer_12, t0.w_buchungsstr_sichtbar AS w_buchungsstr_sichtbar_13, t0.w_buchungsstr_preis_sichtbar AS w_buchungsstr_preis_sichtbar_14, t0.auf_dokumenten_sichtbar AS auf_dokumenten_sichtbar_15, t0.is_standard_leistung AS is_standard_leistung_16, t0.anz_validation AS anz_validation_17, t0.auswahlopt_buchungsstr AS auswahlopt_buchungsstr_18, t0.passdaten_relevant_override AS passdaten_relevant_override_19, t0.pass_typ_override AS pass_typ_override_20, t0.pass_kopie_override AS pass_kopie_override_21, t0.adresse_relevant_override AS adresse_relevant_override_22, t0.telefondaten_relevant_override AS telefondaten_relevant_override_23, t0.rang AS rang_24, t0.pflicht AS pflicht_25, t0.start_option AS start_option_26, t0.start_verschiebung AS start_verschiebung_27, t0.sb_user AS sb_user_28, t0.gruppenelement_id AS gruppenelement_id_29, t0.paket_id AS paket_id_30, t0.reisobjekt_id AS reisobjekt_id_31, t0.key_id AS key_id_32, t0.vkk_id AS vkk_id_33, t0.fibukonto_storno_id AS fibukonto_storno_id_34, t0.fibukonto_erloes_id AS fibukonto_erloes_id_35, t0.kostenstelle_id AS kostenstelle_id_36, t0.kostentraeger_id AS kostentraeger_id_37, t0.verteilungsschema_id AS verteilungsschema_id_38, t0.start_leistung_id AS start_leistung_id_39 FROM paket_reiseobjekt t0 WHERE t0.paket_id = 34 AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.von_datum AS von_datum_7,
  t0.bis_datum AS bis_datum_8,
  t0.info_booking_classes AS info_booking_classes_9,
  t0.gds AS gds_10,
  t0.ab_preis AS ab_preis_11,
  t0.vakanz AS vakanz_12,
  t0.min_tage AS min_tage_13,
  t0.max_tage AS max_tage_14,
  t0.zimmer_kontingente AS zimmer_kontingente_15,
  t0.personen_kontingente AS personen_kontingente_16,
  t0.type AS type_17,
  t0.sb_user AS sb_user_18,
  t0.paket_id AS paket_id_19,
  t20.deleted_at AS deleted_at_21,
  t20.anlage_datum AS anlage_datum_22,
  t20.aenderung_datum AS aenderung_datum_23,
  t20.aktiv AS aktiv_24,
  t20.sb_name AS sb_name_25,
  t20.base AS base_26,
  t20.fee_class_bc AS fee_class_bc_27,
  t20.fee_class_pe AS fee_class_pe_28,
  t20.fee_airport_de AS fee_airport_de_29,
  t20.fee_airport_other AS fee_airport_other_30,
  t20.sb_user AS sb_user_31,
  t20.termin AS termin_32,
  t0.vkk_id AS vkk_id_33,
  t0.status_id AS status_id_34
FROM
  termin t0
  LEFT JOIN termin_flight_price t20 ON t20.termin = t0.id
  AND (
    (t20.deleted_at IS NULL)
  )
WHERE
  t0.paket_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.von_datum AS von_datum_7, t0.bis_datum AS bis_datum_8, t0.info_booking_classes AS info_booking_classes_9, t0.gds AS gds_10, t0.ab_preis AS ab_preis_11, t0.vakanz AS vakanz_12, t0.min_tage AS min_tage_13, t0.max_tage AS max_tage_14, t0.zimmer_kontingente AS zimmer_kontingente_15, t0.personen_kontingente AS personen_kontingente_16, t0.type AS type_17, t0.sb_user AS sb_user_18, t0.paket_id AS paket_id_19, t20.deleted_at AS deleted_at_21, t20.anlage_datum AS anlage_datum_22, t20.aenderung_datum AS aenderung_datum_23, t20.aktiv AS aktiv_24, t20.sb_name AS sb_name_25, t20.base AS base_26, t20.fee_class_bc AS fee_class_bc_27, t20.fee_class_pe AS fee_class_pe_28, t20.fee_airport_de AS fee_airport_de_29, t20.fee_airport_other AS fee_airport_other_30, t20.sb_user AS sb_user_31, t20.termin AS termin_32, t0.vkk_id AS vkk_id_33, t0.status_id AS status_id_34 FROM termin t0 LEFT JOIN termin_flight_price t20 ON t20.termin = t0.id AND ((t20.deleted_at IS NULL)) WHERE t0.paket_id = 34 AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.sb_user AS sb_user_7,
  t0.paket_id AS paket_id_8,
  t0.user_id AS user_id_9,
  t0.type_id AS type_id_10
FROM
  paket_user t0
WHERE
  t0.paket_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.sb_user AS sb_user_7, t0.paket_id AS paket_id_8, t0.user_id AS user_id_9, t0.type_id AS type_id_10 FROM paket_user t0 WHERE t0.paket_id = 34 AND ((t0.deleted_at IS NULL));