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.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.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.id AS id_1,
  t0.user_id AS user_id_2,
  t0.right_id AS right_id_3
FROM
  user_right t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.right_id AS right_id_3 FROM user_right t0 WHERE t0.user_id = 54;

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.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.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.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.rang AS rang_7,
  t0.pflicht AS pflicht_8,
  t0.start_option AS start_option_9,
  t0.start_verschiebung AS start_verschiebung_10,
  t0.sb_user AS sb_user_11,
  t0.baustein_id AS baustein_id_12,
  t13.id AS id_14,
  t13.gruppe_id AS gruppe_id_15,
  t13.platzhalter_id AS platzhalter_id_16,
  t13.paket_baustein_id AS paket_baustein_id_17,
  t0.hauptpaket_id AS hauptpaket_id_18,
  t0.start_leistung_id AS start_leistung_id_19
FROM
  paket_baustein t0
  LEFT JOIN paket_gruppe_element t13 ON t13.paket_baustein_id = t0.id
WHERE
  t0.baustein_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.rang AS rang_7, t0.pflicht AS pflicht_8, t0.start_option AS start_option_9, t0.start_verschiebung AS start_verschiebung_10, t0.sb_user AS sb_user_11, t0.baustein_id AS baustein_id_12, t13.id AS id_14, t13.gruppe_id AS gruppe_id_15, t13.platzhalter_id AS platzhalter_id_16, t13.paket_baustein_id AS paket_baustein_id_17, t0.hauptpaket_id AS hauptpaket_id_18, t0.start_leistung_id AS start_leistung_id_19 FROM paket_baustein t0 LEFT JOIN paket_gruppe_element t13 ON t13.paket_baustein_id = t0.id WHERE t0.baustein_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.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 = 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.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.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.tempFlag AS tempFlag_6,
  t0.deleteFlag AS deleteFlag_7,
  t0.id AS id_8,
  t0.rang AS rang_9,
  t0.nr AS nr_10,
  t0.sb_user AS sb_user_11,
  t0.paket_id AS paket_id_12
FROM
  paket_reiseverlauf 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.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.rang AS rang_9, t0.nr AS nr_10, t0.sb_user AS sb_user_11, t0.paket_id AS paket_id_12 FROM paket_reiseverlauf t0 WHERE t0.paket_id = 34 AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.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\\PaketReiseverlauf:70' 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\\PaketReiseverlauf:71' 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\\PaketReiseverlauf:72' 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\\PaketReiseverlauf:73' 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\\PaketReiseverlauf:74' 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\\PaketReiseverlauf:75' 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\\PaketReiseverlauf:76' 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\\PaketReiseverlauf:77' 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.nr AS nr_10,
  t0.sb_user AS sb_user_11,
  t0.paket_id AS paket_id_12
FROM
  paket_reiseverlauf_tft 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.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.rang AS rang_9, t0.nr AS nr_10, t0.sb_user AS sb_user_11, t0.paket_id AS paket_id_12 FROM paket_reiseverlauf_tft t0 WHERE t0.paket_id = 34 AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC;

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.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.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;

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 = 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)
  )