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.status_id AS status_id_14,
  t0.sb_user AS sb_user_15,
  t0.reiseobjekt_option_id AS reiseobjekt_option_id_16,
  t0.verkaufskondition_termin_id AS verkaufskondition_termin_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.status_id AS status_id_14, t0.sb_user AS sb_user_15, t0.reiseobjekt_option_id AS reiseobjekt_option_id_16, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_17 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = 13894 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:45' 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.gruppe AS gruppe_6,
  t0.name AS name_7,
  t0.beschreibung AS beschreibung_8,
  t0.value AS value_9,
  t0.type AS type_10,
  t0.sb_user AS sb_user_11
FROM
  parameter t0
WHERE
  t0.name = ?
  AND t0.gruppe = ?
  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.gruppe AS gruppe_6, t0.name AS name_7, t0.beschreibung AS beschreibung_8, t0.value AS value_9, t0.type AS type_10, t0.sb_user AS sb_user_11 FROM parameter t0 WHERE t0.name = 'ERLAUBTE_LAENDER' AND t0.gruppe = 'Viator' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.allow_edit AS allow_edit_2,
  t0.allow_delete AS allow_delete_3,
  t0.right_id AS right_id_4,
  t0.role_id AS role_id_5
FROM
  role_right t0
WHERE
  t0.role_id = ?

SELECT t0.id AS id_1, t0.allow_edit AS allow_edit_2, t0.allow_delete AS allow_delete_3, t0.right_id AS right_id_4, t0.role_id AS role_id_5 FROM role_right t0 WHERE t0.role_id = 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.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:BO' 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.bezeichnung AS bezeichnung_7,
  t0.rang AS rang_8,
  t0.icon AS icon_9,
  t0.sb_user AS sb_user_10
FROM
  key_kontakt_typ 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.rang AS rang_8, t0.icon AS icon_9, t0.sb_user AS sb_user_10 FROM key_kontakt_typ t0 WHERE t0.id = 'email' 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.status_id AS status_id_14,
  t0.sb_user AS sb_user_15,
  t0.verkaufskondition_id AS verkaufskondition_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.status_id AS status_id_14, t0.sb_user AS sb_user_15, t0.verkaufskondition_id AS verkaufskondition_id_16 FROM verkaufskondition_termin t0 WHERE t0.verkaufskondition_id = 155 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.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 = 'BO' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.bundesland_key AS bundesland_key_2,
  t0.bezeichnung AS bezeichnung_3,
  t0.land_alpha2 AS land_alpha2_4
FROM
  bundesland t0
WHERE
  t0.land_alpha2 = ?

SELECT t0.id AS id_1, t0.bundesland_key AS bundesland_key_2, t0.bezeichnung AS bezeichnung_3, t0.land_alpha2 AS land_alpha2_4 FROM bundesland t0 WHERE t0.land_alpha2 = 'BO';

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.kuerzel AS kuerzel_7,
  t0.ist_unterkunft_kombinierbar AS ist_unterkunft_kombinierbar_8,
  t0.sb_user AS sb_user_9
FROM
  key_reiseobjekt_type 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.kuerzel AS kuerzel_7, t0.ist_unterkunft_kombinierbar AS ist_unterkunft_kombinierbar_8, t0.sb_user AS sb_user_9 FROM key_reiseobjekt_type t0 WHERE t0.id = 2 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.is_nicht_versicherungsrelevant AS is_nicht_versicherungsrelevant_12,
  t0.staffel_personen_max AS staffel_personen_max_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.is_nicht_versicherungsrelevant AS is_nicht_versicherungsrelevant_12, t0.staffel_personen_max AS staffel_personen_max_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 = 155 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.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 = 45 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_.vererbung_config AS vererbung_config_17,
  p0_.subpaket_kennung AS subpaket_kennung_18,
  p0_.sb_user AS sb_user_19,
  p0_.subpaketVon_id AS subpaketVon_id_20,
  p0_.key_id AS key_id_21,
  p0_.metainfo_id AS metainfo_id_22
FROM
  paket p0_
  INNER JOIN termin t1_ ON p0_.id = t1_.paket_id
  AND (t1_.deleted_at IS NULL)
  INNER JOIN paket_land p3_ ON p0_.id = p3_.paket_id
  INNER JOIN land l2_ ON l2_.alpha2 = p3_.land_id
  AND (l2_.deleted_at IS NULL)
WHERE
  (
    t1_.vakanz >= ?
    AND l2_.alpha2 IN (?)
  )
  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_.vererbung_config AS vererbung_config_17, p0_.subpaket_kennung AS subpaket_kennung_18, p0_.sb_user AS sb_user_19, p0_.subpaketVon_id AS subpaketVon_id_20, p0_.key_id AS key_id_21, p0_.metainfo_id AS metainfo_id_22 FROM paket p0_ INNER JOIN termin t1_ ON p0_.id = t1_.paket_id AND (t1_.deleted_at IS NULL) INNER JOIN paket_land p3_ ON p0_.id = p3_.paket_id INNER JOIN land l2_ ON l2_.alpha2 = p3_.land_id AND (l2_.deleted_at IS NULL) WHERE (t1_.vakanz >= 1 AND l2_.alpha2 IN ('BO')) 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.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,
  t0.metainfo_id AS metainfo_id_23,
  t0.fibukonto_storno_id AS fibukonto_storno_id_24,
  t0.fibukonto_erloes_id AS fibukonto_erloes_id_25,
  t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_26,
  t0.kostenstelle_id AS kostenstelle_id_27,
  t0.kostentraeger_id AS kostentraeger_id_28,
  t0.verteilungsschema_id AS verteilungsschema_id_29,
  t0.logistik_default_option_id AS logistik_default_option_id_30
FROM
  reiseobjekt 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.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, t0.metainfo_id AS metainfo_id_23, t0.fibukonto_storno_id AS fibukonto_storno_id_24, t0.fibukonto_erloes_id AS fibukonto_erloes_id_25, t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_26, t0.kostenstelle_id AS kostenstelle_id_27, t0.kostentraeger_id AS kostentraeger_id_28, t0.verteilungsschema_id AS verteilungsschema_id_29, t0.logistik_default_option_id AS logistik_default_option_id_30 FROM reiseobjekt t0 WHERE t0.id = 4125 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.type_id AS type_id_9,
  t0.sub_type AS sub_type_10,
  t0.to2id AS to2id_11,
  t0.to2nr AS to2nr_12,
  t0.legacy_password AS legacy_password_13,
  t0.legacy_password_salt AS legacy_password_salt_14,
  t0.agentur_nr AS agentur_nr_15,
  t0.name AS name_16,
  t0.name_addendum AS name_addendum_17,
  t0.name_official AS name_official_18,
  t0.ustid AS ustid_19,
  t0.steuernummer AS steuernummer_20,
  t0.kleinunternehmer AS kleinunternehmer_21,
  t0.reverse_charge AS reverse_charge_22,
  t0.registered_since AS registered_since_23,
  t0.iban AS iban_24,
  t0.bic AS bic_25,
  t0.auto_beleg_erstellung AS auto_beleg_erstellung_26,
  t0.selfbilling AS selfbilling_27,
  t0.passdaten_relevant AS passdaten_relevant_28,
  t0.pass_typ AS pass_typ_29,
  t0.pass_kopie AS pass_kopie_30,
  t0.adresse_relevant AS adresse_relevant_31,
  t0.telefondaten_relevant AS telefondaten_relevant_32,
  t0.provision_von_mutteragentur AS provision_von_mutteragentur_33,
  t0.provision_zeitpunkt AS provision_zeitpunkt_34,
  t0.mwst_in_prozent AS mwst_in_prozent_35,
  t0.kooperation AS kooperation_36,
  t0.sb_user AS sb_user_37,
  t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_38,
  t0.api_id AS api_id_39,
  t0.land_id AS land_id_40,
  t0.agt_id AS agt_id_41,
  t0.hierarchie_typ_id AS hierarchie_typ_id_42,
  t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_43,
  t0.leistung_gruppierung AS leistung_gruppierung_44,
  t0.prov_id AS prov_id_45,
  t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_46,
  t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_47,
  t0.inkasso_id AS inkasso_id_48,
  t0.zahlungsart_id AS zahlungsart_id_49
FROM
  agentur 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.type_id AS type_id_9, t0.sub_type AS sub_type_10, t0.to2id AS to2id_11, t0.to2nr AS to2nr_12, t0.legacy_password AS legacy_password_13, t0.legacy_password_salt AS legacy_password_salt_14, t0.agentur_nr AS agentur_nr_15, t0.name AS name_16, t0.name_addendum AS name_addendum_17, t0.name_official AS name_official_18, t0.ustid AS ustid_19, t0.steuernummer AS steuernummer_20, t0.kleinunternehmer AS kleinunternehmer_21, t0.reverse_charge AS reverse_charge_22, t0.registered_since AS registered_since_23, t0.iban AS iban_24, t0.bic AS bic_25, t0.auto_beleg_erstellung AS auto_beleg_erstellung_26, t0.selfbilling AS selfbilling_27, t0.passdaten_relevant AS passdaten_relevant_28, t0.pass_typ AS pass_typ_29, t0.pass_kopie AS pass_kopie_30, t0.adresse_relevant AS adresse_relevant_31, t0.telefondaten_relevant AS telefondaten_relevant_32, t0.provision_von_mutteragentur AS provision_von_mutteragentur_33, t0.provision_zeitpunkt AS provision_zeitpunkt_34, t0.mwst_in_prozent AS mwst_in_prozent_35, t0.kooperation AS kooperation_36, t0.sb_user AS sb_user_37, t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_38, t0.api_id AS api_id_39, t0.land_id AS land_id_40, t0.agt_id AS agt_id_41, t0.hierarchie_typ_id AS hierarchie_typ_id_42, t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_43, t0.leistung_gruppierung AS leistung_gruppierung_44, t0.prov_id AS prov_id_45, t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_46, t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_47, t0.inkasso_id AS inkasso_id_48, t0.zahlungsart_id AS zahlungsart_id_49 FROM agentur t0 WHERE t0.id = 5742 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 = 9 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.langdock_api_key AS langdock_api_key_27,
  t0.website_user AS website_user_28,
  t0.sb_user AS sb_user_29,
  t0.geschlecht_id AS geschlecht_id_30,
  t0.sprache_id AS sprache_id_31,
  t0.abteilung_id AS abteilung_id_32
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.langdock_api_key AS langdock_api_key_27, t0.website_user AS website_user_28, t0.sb_user AS sb_user_29, t0.geschlecht_id AS geschlecht_id_30, t0.sprache_id AS sprache_id_31, t0.abteilung_id AS abteilung_id_32 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.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:45' 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 = 106 AND ((t0.deleted_at IS NULL));