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.parent AS parent_7,
  t0.parent_property AS parent_property_8,
  t0.text AS text_9,
  t0.sb_user AS sb_user_10,
  t0.sprache_id AS sprache_id_11
FROM
  sprache_text t0
WHERE
  t0.parent = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.parent AS parent_7, t0.parent_property AS parent_property_8, t0.text AS text_9, t0.sb_user AS sb_user_10, t0.sprache_id AS sprache_id_11 FROM sprache_text t0 WHERE t0.parent = 'App\\Entity\\Reise\\Paket\\Paket:34' AND ((t0.deleted_at IS NULL));

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.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,
  t23.deleted_at AS deleted_at_24,
  t23.anlage_datum AS anlage_datum_25,
  t23.aenderung_datum AS aenderung_datum_26,
  t23.aktiv AS aktiv_27,
  t23.sb_name AS sb_name_28,
  t23.id AS id_29,
  t23.strasse AS strasse_30,
  t23.bundesland AS bundesland_31,
  t23.hausnummer AS hausnummer_32,
  t23.zusatz AS zusatz_33,
  t23.plz AS plz_34,
  t23.ort AS ort_35,
  t23.rang AS rang_36,
  t23.anmerkung AS anmerkung_37,
  t23.is_default AS is_default_38,
  t23.latitude AS latitude_39,
  t23.longitude AS longitude_40,
  t23.sb_user AS sb_user_41,
  t23.land_id AS land_id_42,
  t23.kunde_id AS kunde_id_43,
  t23.reiseobjekt_id AS reiseobjekt_id_44,
  t23.poi_id AS poi_id_45,
  t23.agentur_id AS agentur_id_46,
  t0.metainfo_id AS metainfo_id_47,
  t0.fibukonto_storno_id AS fibukonto_storno_id_48,
  t0.fibukonto_erloes_id AS fibukonto_erloes_id_49,
  t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_50,
  t0.kostenstelle_id AS kostenstelle_id_51,
  t0.kostentraeger_id AS kostentraeger_id_52,
  t0.verteilungsschema_id AS verteilungsschema_id_53,
  t0.logistik_default_option_id AS logistik_default_option_id_54
FROM
  reiseobjekt t0
  LEFT JOIN adresse t23 ON t23.reiseobjekt_id = t0.id
  AND (
    (t23.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.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, t23.deleted_at AS deleted_at_24, t23.anlage_datum AS anlage_datum_25, t23.aenderung_datum AS aenderung_datum_26, t23.aktiv AS aktiv_27, t23.sb_name AS sb_name_28, t23.id AS id_29, t23.strasse AS strasse_30, t23.bundesland AS bundesland_31, t23.hausnummer AS hausnummer_32, t23.zusatz AS zusatz_33, t23.plz AS plz_34, t23.ort AS ort_35, t23.rang AS rang_36, t23.anmerkung AS anmerkung_37, t23.is_default AS is_default_38, t23.latitude AS latitude_39, t23.longitude AS longitude_40, t23.sb_user AS sb_user_41, t23.land_id AS land_id_42, t23.kunde_id AS kunde_id_43, t23.reiseobjekt_id AS reiseobjekt_id_44, t23.poi_id AS poi_id_45, t23.agentur_id AS agentur_id_46, t0.metainfo_id AS metainfo_id_47, t0.fibukonto_storno_id AS fibukonto_storno_id_48, t0.fibukonto_erloes_id AS fibukonto_erloes_id_49, t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_50, t0.kostenstelle_id AS kostenstelle_id_51, t0.kostentraeger_id AS kostentraeger_id_52, t0.verteilungsschema_id AS verteilungsschema_id_53, t0.logistik_default_option_id AS logistik_default_option_id_54 FROM reiseobjekt t0 LEFT JOIN adresse t23 ON t23.reiseobjekt_id = t0.id AND ((t23.deleted_at IS NULL)) WHERE t0.id = 107 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.mwst_in_prozent AS mwst_in_prozent_10,
  t0.ustid AS ustid_11,
  t0.steuernummer AS steuernummer_12,
  t0.iban AS iban_13,
  t0.bic AS bic_14,
  t0.name AS name_15,
  t0.name_addendum AS name_addendum_16,
  t0.name_official AS name_official_17,
  t0.kooperation AS kooperation_18,
  t0.kleinunternehmer AS kleinunternehmer_19,
  t0.auto_beleg_erstellung AS auto_beleg_erstellung_20,
  t0.selfbilling AS selfbilling_21,
  t0.passdaten_relevant AS passdaten_relevant_22,
  t0.pass_typ AS pass_typ_23,
  t0.pass_kopie AS pass_kopie_24,
  t0.adresse_relevant AS adresse_relevant_25,
  t0.telefondaten_relevant AS telefondaten_relevant_26,
  t0.to2id AS to2id_27,
  t0.to2nr AS to2nr_28,
  t0.sb_user AS sb_user_29,
  t0.type_id AS type_id_30,
  t0.inkasso_id AS inkasso_id_31,
  t0.agt_id AS agt_id_32,
  t0.zahlungsart_id AS zahlungsart_id_33,
  t0.prov_id AS prov_id_34,
  t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_35,
  t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_36,
  t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_37,
  t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_38,
  t0.leistung_gruppierung AS leistung_gruppierung_39,
  t0.api_id AS api_id_40
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.agentur_nr AS agentur_nr_9, t0.mwst_in_prozent AS mwst_in_prozent_10, t0.ustid AS ustid_11, t0.steuernummer AS steuernummer_12, t0.iban AS iban_13, t0.bic AS bic_14, t0.name AS name_15, t0.name_addendum AS name_addendum_16, t0.name_official AS name_official_17, t0.kooperation AS kooperation_18, t0.kleinunternehmer AS kleinunternehmer_19, t0.auto_beleg_erstellung AS auto_beleg_erstellung_20, t0.selfbilling AS selfbilling_21, t0.passdaten_relevant AS passdaten_relevant_22, t0.pass_typ AS pass_typ_23, t0.pass_kopie AS pass_kopie_24, t0.adresse_relevant AS adresse_relevant_25, t0.telefondaten_relevant AS telefondaten_relevant_26, t0.to2id AS to2id_27, t0.to2nr AS to2nr_28, t0.sb_user AS sb_user_29, t0.type_id AS type_id_30, t0.inkasso_id AS inkasso_id_31, t0.agt_id AS agt_id_32, t0.zahlungsart_id AS zahlungsart_id_33, t0.prov_id AS prov_id_34, t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_35, t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_36, t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_37, t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_38, t0.leistung_gruppierung AS leistung_gruppierung_39, t0.api_id AS api_id_40 FROM agentur t0 WHERE t0.id = 11 AND ((t0.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_
WHERE
  (
    p0_.id = ?
    OR p0_.reisecode = ?
  )
  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_ WHERE (p0_.id = 34 OR p0_.reisecode = 'NASOS') 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.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 = 54 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;

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.is_standard_leistung AS is_standard_leistung_14,
  t0.anz_validation AS anz_validation_15,
  t0.auswahlopt_buchungsstr AS auswahlopt_buchungsstr_16,
  t0.passdaten_relevant_override AS passdaten_relevant_override_17,
  t0.pass_typ_override AS pass_typ_override_18,
  t0.pass_kopie_override AS pass_kopie_override_19,
  t0.adresse_relevant_override AS adresse_relevant_override_20,
  t0.telefondaten_relevant_override AS telefondaten_relevant_override_21,
  t0.rang AS rang_22,
  t0.pflicht AS pflicht_23,
  t0.start_option AS start_option_24,
  t0.start_verschiebung AS start_verschiebung_25,
  t0.sb_user AS sb_user_26,
  t0.gruppenelement_id AS gruppenelement_id_27,
  t0.paket_id AS paket_id_28,
  t0.reisobjekt_id AS reisobjekt_id_29,
  t0.key_id AS key_id_30,
  t0.vkk_id AS vkk_id_31,
  t0.fibukonto_storno_id AS fibukonto_storno_id_32,
  t0.fibukonto_erloes_id AS fibukonto_erloes_id_33,
  t0.kostenstelle_id AS kostenstelle_id_34,
  t0.kostentraeger_id AS kostentraeger_id_35,
  t0.verteilungsschema_id AS verteilungsschema_id_36,
  t0.start_leistung_id AS start_leistung_id_37
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.is_standard_leistung AS is_standard_leistung_14, t0.anz_validation AS anz_validation_15, t0.auswahlopt_buchungsstr AS auswahlopt_buchungsstr_16, t0.passdaten_relevant_override AS passdaten_relevant_override_17, t0.pass_typ_override AS pass_typ_override_18, t0.pass_kopie_override AS pass_kopie_override_19, t0.adresse_relevant_override AS adresse_relevant_override_20, t0.telefondaten_relevant_override AS telefondaten_relevant_override_21, t0.rang AS rang_22, t0.pflicht AS pflicht_23, t0.start_option AS start_option_24, t0.start_verschiebung AS start_verschiebung_25, t0.sb_user AS sb_user_26, t0.gruppenelement_id AS gruppenelement_id_27, t0.paket_id AS paket_id_28, t0.reisobjekt_id AS reisobjekt_id_29, t0.key_id AS key_id_30, t0.vkk_id AS vkk_id_31, t0.fibukonto_storno_id AS fibukonto_storno_id_32, t0.fibukonto_erloes_id AS fibukonto_erloes_id_33, t0.kostenstelle_id AS kostenstelle_id_34, t0.kostentraeger_id AS kostentraeger_id_35, t0.verteilungsschema_id AS verteilungsschema_id_36, t0.start_leistung_id AS start_leistung_id_37 FROM paket_reiseobjekt t0 WHERE t0.paket_id = 34 AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC;

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;