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.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.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_INT_FLUGHAEFEN' AND t0.gruppe = 'Viator' 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 = ?
  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 = 'AUFSCHLAG_AT' AND t0.gruppe = 'Viator' 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 = ?
  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 = 'AUFSCHLAG_CH' AND t0.gruppe = 'Viator' 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 = ?
  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.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));

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

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

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.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.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.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 = 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.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.calling_code AS calling_code_14,
  t0.verbergen_im_frontend AS verbergen_im_frontend_15,
  t0.sb_user AS sb_user_16,
  t0.metainfo_id AS metainfo_id_17
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.calling_code AS calling_code_14, t0.verbergen_im_frontend AS verbergen_im_frontend_15, t0.sb_user AS sb_user_16, t0.metainfo_id AS metainfo_id_17 FROM land t0 INNER JOIN paket_land ON t0.alpha2 = paket_land.land_id WHERE paket_land.paket_id = 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.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.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.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.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:CL' AND t0.parent_property = 'landBeschreibungTexte' 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 = 'CL';

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 = 'CL' 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:PE' AND t0.parent_property = 'landBeschreibungTexte' 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 = 'PE';

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 = 'PE' 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: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.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 = 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.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\\Reiseart: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.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