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.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 = 13917 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.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 = 'LTBAL_260805' 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.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.sb_user AS sb_user_13,
  t0.type_id AS type_id_14,
  t0.lt_ag_einkauf_id AS lt_ag_einkauf_id_15,
  t0.lt_ag_vorOrt_id AS lt_ag_vorOrt_id_16,
  t17.deleted_at AS deleted_at_18,
  t17.anlage_datum AS anlage_datum_19,
  t17.aenderung_datum AS aenderung_datum_20,
  t17.aktiv AS aktiv_21,
  t17.sb_name AS sb_name_22,
  t17.id AS id_23,
  t17.strasse AS strasse_24,
  t17.bundesland AS bundesland_25,
  t17.hausnummer AS hausnummer_26,
  t17.zusatz AS zusatz_27,
  t17.plz AS plz_28,
  t17.ort AS ort_29,
  t17.rang AS rang_30,
  t17.anmerkung AS anmerkung_31,
  t17.is_default AS is_default_32,
  t17.latitude AS latitude_33,
  t17.longitude AS longitude_34,
  t17.sb_user AS sb_user_35,
  t17.land_id AS land_id_36,
  t17.kunde_id AS kunde_id_37,
  t17.reiseobjekt_id AS reiseobjekt_id_38,
  t17.agentur_id AS agentur_id_39,
  t0.metainfo_id AS metainfo_id_40,
  t0.fibukonto_storno_id AS fibukonto_storno_id_41,
  t0.fibukonto_erloes_id AS fibukonto_erloes_id_42,
  t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_43,
  t0.kostenstelle_id AS kostenstelle_id_44,
  t0.kostentraeger_id AS kostentraeger_id_45,
  t0.verteilungsschema_id AS verteilungsschema_id_46
FROM
  reiseobjekt t0
  LEFT JOIN adresse t17 ON t17.reiseobjekt_id = t0.id
  AND (
    (t17.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.sb_user AS sb_user_13, t0.type_id AS type_id_14, t0.lt_ag_einkauf_id AS lt_ag_einkauf_id_15, t0.lt_ag_vorOrt_id AS lt_ag_vorOrt_id_16, t17.deleted_at AS deleted_at_18, t17.anlage_datum AS anlage_datum_19, t17.aenderung_datum AS aenderung_datum_20, t17.aktiv AS aktiv_21, t17.sb_name AS sb_name_22, t17.id AS id_23, t17.strasse AS strasse_24, t17.bundesland AS bundesland_25, t17.hausnummer AS hausnummer_26, t17.zusatz AS zusatz_27, t17.plz AS plz_28, t17.ort AS ort_29, t17.rang AS rang_30, t17.anmerkung AS anmerkung_31, t17.is_default AS is_default_32, t17.latitude AS latitude_33, t17.longitude AS longitude_34, t17.sb_user AS sb_user_35, t17.land_id AS land_id_36, t17.kunde_id AS kunde_id_37, t17.reiseobjekt_id AS reiseobjekt_id_38, t17.agentur_id AS agentur_id_39, t0.metainfo_id AS metainfo_id_40, t0.fibukonto_storno_id AS fibukonto_storno_id_41, t0.fibukonto_erloes_id AS fibukonto_erloes_id_42, t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_43, t0.kostenstelle_id AS kostenstelle_id_44, t0.kostentraeger_id AS kostentraeger_id_45, t0.verteilungsschema_id AS verteilungsschema_id_46 FROM reiseobjekt t0 LEFT JOIN adresse t17 ON t17.reiseobjekt_id = t0.id AND ((t17.deleted_at IS NULL)) WHERE t0.id = 4099 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 = 36 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:36' 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.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 = 36 AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC;

SELECT
  p0_.deleted_at AS deleted_at_0,
  p0_.anlage_datum AS anlage_datum_1,
  p0_.aenderung_datum AS aenderung_datum_2,
  p0_.aktiv AS aktiv_3,
  p0_.sb_name AS sb_name_4,
  p0_.id AS id_5,
  p0_.reisecode AS reisecode_6,
  p0_.dauer AS dauer_7,
  p0_.dauer_max AS dauer_max_8,
  p0_.info_intern AS info_intern_9,
  p0_.co2emission AS co2emission_10,
  p0_.co2emission_flug AS co2emission_flug_11,
  p0_.co2emission_transport AS co2emission_transport_12,
  p0_.co2emission_unterkunft AS co2emission_unterkunft_13,
  p0_.co2emission_aktivitaet AS co2emission_aktivitaet_14,
  p0_.local_share AS local_share_15,
  p0_.zertifikat_flaeche AS zertifikat_flaeche_16,
  p0_.sb_user AS sb_user_17,
  p0_.key_id AS key_id_18,
  p0_.metainfo_id AS metainfo_id_19
FROM
  paket p0_
  INNER JOIN termin t1_ ON p0_.id = t1_.paket_id
  AND (t1_.deleted_at IS NULL)
WHERE
  (t1_.vakanz >= ?)
  AND (p0_.deleted_at IS NULL)

SELECT p0_.deleted_at AS deleted_at_0, p0_.anlage_datum AS anlage_datum_1, p0_.aenderung_datum AS aenderung_datum_2, p0_.aktiv AS aktiv_3, p0_.sb_name AS sb_name_4, p0_.id AS id_5, p0_.reisecode AS reisecode_6, p0_.dauer AS dauer_7, p0_.dauer_max AS dauer_max_8, p0_.info_intern AS info_intern_9, p0_.co2emission AS co2emission_10, p0_.co2emission_flug AS co2emission_flug_11, p0_.co2emission_transport AS co2emission_transport_12, p0_.co2emission_unterkunft AS co2emission_unterkunft_13, p0_.co2emission_aktivitaet AS co2emission_aktivitaet_14, p0_.local_share AS local_share_15, p0_.zertifikat_flaeche AS zertifikat_flaeche_16, p0_.sb_user AS sb_user_17, p0_.key_id AS key_id_18, p0_.metainfo_id AS metainfo_id_19 FROM paket p0_ INNER JOIN termin t1_ ON p0_.id = t1_.paket_id AND (t1_.deleted_at IS NULL) WHERE (t1_.vakanz >= 1) AND (p0_.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.preistyp AS preistyp_9,
  t0.bezeichnung AS bezeichnung_10,
  t0.pauschalpreis AS pauschalpreis_11,
  t0.preis_bei_saisonueberschneidung AS preis_bei_saisonueberschneidung_12,
  t0.is_nicht_versicherungsrelevant AS is_nicht_versicherungsrelevant_13,
  t0.preis_fuer_tag_nacht_anzahl AS preis_fuer_tag_nacht_anzahl_14,
  t0.preis_fuer_tag_nacht_typ AS preis_fuer_tag_nacht_typ_15,
  t0.sb_user AS sb_user_16,
  t0.reiseobjekt_id AS reiseobjekt_id_17,
  t0.key_pruefschema_id AS key_pruefschema_id_18
FROM
  reiseobjekt_verkaufskondition 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.preistyp AS preistyp_9, t0.bezeichnung AS bezeichnung_10, t0.pauschalpreis AS pauschalpreis_11, t0.preis_bei_saisonueberschneidung AS preis_bei_saisonueberschneidung_12, t0.is_nicht_versicherungsrelevant AS is_nicht_versicherungsrelevant_13, t0.preis_fuer_tag_nacht_anzahl AS preis_fuer_tag_nacht_anzahl_14, t0.preis_fuer_tag_nacht_typ AS preis_fuer_tag_nacht_typ_15, t0.sb_user AS sb_user_16, t0.reiseobjekt_id AS reiseobjekt_id_17, t0.key_pruefschema_id AS key_pruefschema_id_18 FROM reiseobjekt_verkaufskondition t0 WHERE t0.id = 157 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:36' 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.parent_property = ?
  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\\Land:EE' AND t0.parent_property = 'landBeschreibungTexte' 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.metainfo_id AS metainfo_id_8
FROM
  kontinent t0
  INNER JOIN land_kontinent ON t0.id = land_kontinent.kontinent_id
WHERE
  land_kontinent.land_alpha2 = ?
  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.metainfo_id AS metainfo_id_8 FROM kontinent t0 INNER JOIN land_kontinent ON t0.id = land_kontinent.kontinent_id WHERE land_kontinent.land_alpha2 = 'EE' 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.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 = 157 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.id AS id_6,
  t0.code AS code_7,
  t0.name AS name_8,
  t0.funktionsbeschreibung AS funktionsbeschreibung_9,
  t0.types AS types_10,
  t0.sb_user AS sb_user_11,
  t0.gruppe_id AS gruppe_id_12,
  t0.metainfo_id AS metainfo_id_13
FROM
  tag t0
  INNER JOIN paket_tag ON t0.id = paket_tag.tag_id
WHERE
  paket_tag.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.code AS code_7, t0.name AS name_8, t0.funktionsbeschreibung AS funktionsbeschreibung_9, t0.types AS types_10, t0.sb_user AS sb_user_11, t0.gruppe_id AS gruppe_id_12, t0.metainfo_id AS metainfo_id_13 FROM tag t0 INNER JOIN paket_tag ON t0.id = paket_tag.tag_id WHERE paket_tag.paket_id = 36 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.sb_user AS sb_user_8,
  t0.metainfo_id AS metainfo_id_9
FROM
  reiseart t0
  INNER JOIN paket_reiseart ON t0.id = paket_reiseart.reiseart_id
WHERE
  paket_reiseart.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.code AS code_7, t0.sb_user AS sb_user_8, t0.metainfo_id AS metainfo_id_9 FROM reiseart t0 INNER JOIN paket_reiseart ON t0.id = paket_reiseart.reiseart_id WHERE paket_reiseart.paket_id = 36 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 = 36 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.agentur_nr AS agentur_nr_9,
  t0.to2id AS to2id_10,
  t0.to2nr AS to2nr_11,
  t0.mwst_in_prozent AS mwst_in_prozent_12,
  t0.ustid AS ustid_13,
  t0.steuernummer AS steuernummer_14,
  t0.bankname AS bankname_15,
  t0.iban AS iban_16,
  t0.bic AS bic_17,
  t0.name AS name_18,
  t0.name_zusatz AS name_zusatz_19,
  t0.kleinunternehmer AS kleinunternehmer_20,
  t0.auto_beleg_erstellung AS auto_beleg_erstellung_21,
  t0.selfbilling AS selfbilling_22,
  t0.sb_user AS sb_user_23,
  t0.type_id AS type_id_24,
  t0.inkasso_id AS inkasso_id_25,
  t0.agt_id AS agt_id_26,
  t0.zahlungsart_id AS zahlungsart_id_27,
  t0.prov_id AS prov_id_28,
  t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_29,
  t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_30,
  t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_31,
  t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_32,
  t0.leistung_gruppierung AS leistung_gruppierung_33,
  t34.api_key AS api_key_35,
  t34.active AS active_36,
  t34.last_used AS last_used_37,
  t34.last_used_ip AS last_used_ip_38,
  t34.agentur_id AS agentur_id_39
FROM
  agentur t0
  LEFT JOIN agentur_api t34 ON t34.agentur_id = t0.id
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.agentur_nr AS agentur_nr_9, t0.to2id AS to2id_10, t0.to2nr AS to2nr_11, t0.mwst_in_prozent AS mwst_in_prozent_12, t0.ustid AS ustid_13, t0.steuernummer AS steuernummer_14, t0.bankname AS bankname_15, t0.iban AS iban_16, t0.bic AS bic_17, t0.name AS name_18, t0.name_zusatz AS name_zusatz_19, t0.kleinunternehmer AS kleinunternehmer_20, t0.auto_beleg_erstellung AS auto_beleg_erstellung_21, t0.selfbilling AS selfbilling_22, t0.sb_user AS sb_user_23, t0.type_id AS type_id_24, t0.inkasso_id AS inkasso_id_25, t0.agt_id AS agt_id_26, t0.zahlungsart_id AS zahlungsart_id_27, t0.prov_id AS prov_id_28, t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_29, t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_30, t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_31, t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_32, t0.leistung_gruppierung AS leistung_gruppierung_33, t34.api_key AS api_key_35, t34.active AS active_36, t34.last_used AS last_used_37, t34.last_used_ip AS last_used_ip_38, t34.agentur_id AS agentur_id_39 FROM agentur t0 LEFT JOIN agentur_api t34 ON t34.agentur_id = t0.id WHERE t0.id = 11 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;