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.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.sb_user AS sb_user_12,
  t0.termin AS termin_13
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.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = 'NASOS_260110' 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.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.sb_user AS sb_user_13,
  t0.reiseobjekt_option_id AS reiseobjekt_option_id_14,
  t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15,
  t0.status_id AS status_id_16
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.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 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.media_file_name AS media_file_name_7,
  t0.media_file_id AS media_file_id_8,
  t0.media_file_type AS media_file_type_9,
  t0.blur_hash AS blur_hash_10,
  t0.metadata AS metadata_11,
  t0.parent AS parent_12,
  t0.rang AS rang_13,
  t0.sb_user AS sb_user_14
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.media_file_name AS media_file_name_7, t0.media_file_id AS media_file_id_8, t0.media_file_type AS media_file_type_9, t0.blur_hash AS blur_hash_10, t0.metadata AS metadata_11, t0.parent AS parent_12, t0.rang AS rang_13, t0.sb_user AS sb_user_14 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.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 = 7 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.sb_user AS sb_user_26,
  t0.geschlecht_id AS geschlecht_id_27,
  t0.sprache_id AS sprache_id_28,
  t0.abteilung_id AS abteilung_id_29
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.sb_user AS sb_user_26, t0.geschlecht_id AS geschlecht_id_27, t0.sprache_id AS sprache_id_28, t0.abteilung_id AS abteilung_id_29 FROM user t0 WHERE t0.id = 29 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 = 274 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.signatur_email AS signatur_email_12,
  t0.sb_user AS sb_user_13,
  t0.user_id AS user_id_14
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.signatur_email AS signatur_email_12, t0.sb_user AS sb_user_13, t0.user_id AS user_id_14 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.alpha2 AS alpha2_6,
  t0.alpha3 AS alpha3_7,
  t0.numeric_code AS numeric_code_8,
  t0.prio AS prio_9,
  t0.currency AS currency_10,
  t0.currency_code AS currency_code_11,
  t0.currency_name AS currency_name_12,
  t0.top_level_domain AS top_level_domain_13,
  t0.sb_user AS sb_user_14,
  t0.metainfo_id AS metainfo_id_15
FROM
  land t0
  INNER JOIN paket_land ON t0.alpha2 = paket_land.land_id
WHERE
  paket_land.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.alpha2 AS alpha2_6, t0.alpha3 AS alpha3_7, t0.numeric_code AS numeric_code_8, t0.prio AS prio_9, t0.currency AS currency_10, t0.currency_code AS currency_code_11, t0.currency_name AS currency_name_12, t0.top_level_domain AS top_level_domain_13, t0.sb_user AS sb_user_14, t0.metainfo_id AS metainfo_id_15 FROM land t0 INNER JOIN paket_land ON t0.alpha2 = paket_land.land_id WHERE paket_land.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.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.sb_user AS sb_user_26,
  t0.geschlecht_id AS geschlecht_id_27,
  t0.sprache_id AS sprache_id_28,
  t0.abteilung_id AS abteilung_id_29
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.sb_user AS sb_user_26, t0.geschlecht_id AS geschlecht_id_27, t0.sprache_id AS sprache_id_28, t0.abteilung_id AS abteilung_id_29 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.dauer AS dauer_9,
  t0.max_dauer AS max_dauer_10,
  t0.w_buchungsstr_sichtbar AS w_buchungsstr_sichtbar_11,
  t0.w_buchungsstr_preis_sichtbar AS w_buchungsstr_preis_sichtbar_12,
  t0.auf_dokumenten_sichtbar AS auf_dokumenten_sichtbar_13,
  t0.anz_validation AS anz_validation_14,
  t0.auswahlopt_buchungsstr AS auswahlopt_buchungsstr_15,
  t0.rang AS rang_16,
  t0.pflicht AS pflicht_17,
  t0.start_option AS start_option_18,
  t0.start_verschiebung AS start_verschiebung_19,
  t0.sb_user AS sb_user_20,
  t0.gruppenelement_id AS gruppenelement_id_21,
  t0.paket_id AS paket_id_22,
  t0.reisobjekt_id AS reisobjekt_id_23,
  t0.key_id AS key_id_24,
  t0.vkk_id AS vkk_id_25,
  t0.fibukonto_storno_id AS fibukonto_storno_id_26,
  t0.fibukonto_erloes_id AS fibukonto_erloes_id_27,
  t0.kostenstelle_id AS kostenstelle_id_28,
  t0.kostentraeger_id AS kostentraeger_id_29,
  t0.verteilungsschema_id AS verteilungsschema_id_30,
  t0.start_leistung_id AS start_leistung_id_31
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.dauer AS dauer_9, t0.max_dauer AS max_dauer_10, t0.w_buchungsstr_sichtbar AS w_buchungsstr_sichtbar_11, t0.w_buchungsstr_preis_sichtbar AS w_buchungsstr_preis_sichtbar_12, t0.auf_dokumenten_sichtbar AS auf_dokumenten_sichtbar_13, t0.anz_validation AS anz_validation_14, t0.auswahlopt_buchungsstr AS auswahlopt_buchungsstr_15, t0.rang AS rang_16, t0.pflicht AS pflicht_17, t0.start_option AS start_option_18, t0.start_verschiebung AS start_verschiebung_19, t0.sb_user AS sb_user_20, t0.gruppenelement_id AS gruppenelement_id_21, t0.paket_id AS paket_id_22, t0.reisobjekt_id AS reisobjekt_id_23, t0.key_id AS key_id_24, t0.vkk_id AS vkk_id_25, t0.fibukonto_storno_id AS fibukonto_storno_id_26, t0.fibukonto_erloes_id AS fibukonto_erloes_id_27, t0.kostenstelle_id AS kostenstelle_id_28, t0.kostentraeger_id AS kostentraeger_id_29, t0.verteilungsschema_id AS verteilungsschema_id_30, t0.start_leistung_id AS start_leistung_id_31 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.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.verkaufskondition_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.datum 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.verkaufskondition_id = 137 AND ((t0.deleted_at IS NULL)) ORDER BY t0.datum 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.rang AS rang_9,
  t0.type AS type_10,
  t0.buchungsdatum_vor AS buchungsdatum_vor_11,
  t0.buchungsdatum_nach AS buchungsdatum_nach_12,
  t0.sb_user AS sb_user_13,
  t0.stornoprofil_id AS stornoprofil_id_14,
  t0.paket_id AS paket_id_15,
  t0.leistungstraeger_id AS leistungstraeger_id_16,
  t0.reiseobjekt_id AS reiseobjekt_id_17,
  t0.reiseart_id AS reiseart_id_18,
  t0.reiseobjekt_option_id AS reiseobjekt_option_id_19
FROM
  stornoprofil_bedingungen 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.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.rang AS rang_9, t0.type AS type_10, t0.buchungsdatum_vor AS buchungsdatum_vor_11, t0.buchungsdatum_nach AS buchungsdatum_nach_12, t0.sb_user AS sb_user_13, t0.stornoprofil_id AS stornoprofil_id_14, t0.paket_id AS paket_id_15, t0.leistungstraeger_id AS leistungstraeger_id_16, t0.reiseobjekt_id AS reiseobjekt_id_17, t0.reiseart_id AS reiseart_id_18, t0.reiseobjekt_option_id AS reiseobjekt_option_id_19 FROM stornoprofil_bedingungen t0 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));

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.pnr_gruppe AS pnr_gruppe_10,
  t0.gds AS gds_11,
  t0.ab_preis AS ab_preis_12,
  t0.vakanz AS vakanz_13,
  t0.min_tage AS min_tage_14,
  t0.max_tage AS max_tage_15,
  t0.zimmer_kontingente AS zimmer_kontingente_16,
  t0.personen_kontingente AS personen_kontingente_17,
  t0.type AS type_18,
  t0.sb_user AS sb_user_19,
  t0.paket_id AS paket_id_20,
  t21.deleted_at AS deleted_at_22,
  t21.anlage_datum AS anlage_datum_23,
  t21.aenderung_datum AS aenderung_datum_24,
  t21.aktiv AS aktiv_25,
  t21.sb_name AS sb_name_26,
  t21.base AS base_27,
  t21.fee_class_bc AS fee_class_bc_28,
  t21.fee_class_pe AS fee_class_pe_29,
  t21.fee_airport_de AS fee_airport_de_30,
  t21.fee_airport_other AS fee_airport_other_31,
  t21.sb_user AS sb_user_32,
  t21.termin AS termin_33,
  t0.vkk_id AS vkk_id_34,
  t0.status_id AS status_id_35
FROM
  termin t0
  LEFT JOIN termin_flight_price t21 ON t21.termin = t0.id
  AND (
    (t21.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.pnr_gruppe AS pnr_gruppe_10, t0.gds AS gds_11, t0.ab_preis AS ab_preis_12, t0.vakanz AS vakanz_13, t0.min_tage AS min_tage_14, t0.max_tage AS max_tage_15, t0.zimmer_kontingente AS zimmer_kontingente_16, t0.personen_kontingente AS personen_kontingente_17, t0.type AS type_18, t0.sb_user AS sb_user_19, t0.paket_id AS paket_id_20, t21.deleted_at AS deleted_at_22, t21.anlage_datum AS anlage_datum_23, t21.aenderung_datum AS aenderung_datum_24, t21.aktiv AS aktiv_25, t21.sb_name AS sb_name_26, t21.base AS base_27, t21.fee_class_bc AS fee_class_bc_28, t21.fee_class_pe AS fee_class_pe_29, t21.fee_airport_de AS fee_airport_de_30, t21.fee_airport_other AS fee_airport_other_31, t21.sb_user AS sb_user_32, t21.termin AS termin_33, t0.vkk_id AS vkk_id_34, t0.status_id AS status_id_35 FROM termin t0 LEFT JOIN termin_flight_price t21 ON t21.termin = t0.id AND ((t21.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.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.sb_user AS sb_user_18,
  t0.key_id AS key_id_19,
  t0.metainfo_id AS metainfo_id_20
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.sb_user AS sb_user_18, t0.key_id AS key_id_19, t0.metainfo_id AS metainfo_id_20 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.sb_user AS sb_user_26,
  t0.geschlecht_id AS geschlecht_id_27,
  t0.sprache_id AS sprache_id_28,
  t0.abteilung_id AS abteilung_id_29
FROM
  user t0
WHERE
  t0.email = ?
  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.sb_user AS sb_user_26, t0.geschlecht_id AS geschlecht_id_27, t0.sprache_id AS sprache_id_28, t0.abteilung_id AS abteilung_id_29 FROM user t0 WHERE t0.email = 'admin@tourone.de' 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.code AS code_7,
  t0.bezeichnung AS bezeichnung_8,
  t0.is_default AS is_default_9,
  t0.sb_user AS sb_user_10
FROM
  sprache 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.code AS code_7, t0.bezeichnung AS bezeichnung_8, t0.is_default AS is_default_9, t0.sb_user AS sb_user_10 FROM sprache t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.friendly_url AS friendly_url_2,
  t0.is_default AS is_default_3,
  t0.rang AS rang_4,
  t0.paket_id AS paket_id_5,
  t0.domain_id AS domain_id_6
FROM
  paket_friendlyUrl t0
WHERE
  t0.paket_id = ?
ORDER BY
  t0.rang ASC

SELECT t0.id AS id_1, t0.friendly_url AS friendly_url_2, t0.is_default AS is_default_3, t0.rang AS rang_4, t0.paket_id AS paket_id_5, t0.domain_id AS domain_id_6 FROM paket_friendlyUrl t0 WHERE t0.paket_id = 34 ORDER BY t0.rang ASC;