Symfony Profiler

UPDATE
  user
SET
  letzter_login = ?,
  aenderung_datum = ?
WHERE
  id = ?

UPDATE user SET letzter_login = '2025-12-17 16:57:54', aenderung_datum = '2025-12-17 16:57:54' WHERE id = 93;

DELETE FROM
  user
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (user.deleted_at IS NULL)

DELETE FROM user WHERE (sb_user = 93 AND tempFlag = 1) AND (user.deleted_at IS NULL);

"COMMIT"

"COMMIT";

DELETE FROM
  metainfo
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (metainfo.deleted_at IS NULL)

DELETE FROM metainfo WHERE (sb_user = 93 AND tempFlag = 1) AND (metainfo.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.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.username = ?
  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.username = 'gbaganz' 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 = 93;

DELETE FROM
  preisregel
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (preisregel.deleted_at IS NULL)

DELETE FROM preisregel WHERE (sb_user = 93 AND tempFlag = 1) AND (preisregel.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.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 = 'gunther.baganz@tourone.de' AND ((t0.deleted_at IS NULL)) LIMIT 1;

DELETE FROM
  agentur
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (agentur.deleted_at IS NULL)

DELETE FROM agentur WHERE (sb_user = 93 AND tempFlag = 1) AND (agentur.deleted_at IS NULL);

DELETE FROM
  zahlungsprofil_bedingung
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    zahlungsprofil_bedingung.deleted_at IS NULL
  )

DELETE FROM zahlungsprofil_bedingung WHERE (sb_user = 93 AND tempFlag = 1) AND (zahlungsprofil_bedingung.deleted_at IS NULL);

DELETE FROM
  agentur_mitarbeiter
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    agentur_mitarbeiter.deleted_at IS NULL
  )

DELETE FROM agentur_mitarbeiter WHERE (sb_user = 93 AND tempFlag = 1) AND (agentur_mitarbeiter.deleted_at IS NULL);

DELETE FROM
  layout
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (layout.deleted_at IS NULL)

DELETE FROM layout WHERE (sb_user = 93 AND tempFlag = 1) AND (layout.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.buchungsdatum AS buchungsdatum_7,
  t0.vorgangsnummer AS vorgangsnummer_8,
  t0.gruppenmarker AS gruppenmarker_9,
  t0.anzahl_reisende AS anzahl_reisende_10,
  t0.gesamtpreis AS gesamtpreis_11,
  t0.reisebeginn AS reisebeginn_12,
  t0.reiseende AS reiseende_13,
  t0.dauer AS dauer_14,
  t0.waehrungskurs AS waehrungskurs_15,
  t0.passolution_data AS passolution_data_16,
  t0.passolution_timestamp AS passolution_timestamp_17,
  t0.optionsdatum AS optionsdatum_18,
  t0.angebotsdatum AS angebotsdatum_19,
  t0.anzahlung_datum AS anzahlung_datum_20,
  t0.schlusszahlung_datum AS schlusszahlung_datum_21,
  t0.anzahlung_betrag AS anzahlung_betrag_22,
  t0.schlusszahlung_betrag AS schlusszahlung_betrag_23,
  t0.anzahlung_datum_manuell AS anzahlung_datum_manuell_24,
  t0.ueberweisung AS ueberweisung_25,
  t0.anzahlung_betrag_manuell AS anzahlung_betrag_manuell_26,
  t0.schlusszahlung_manuell AS schlusszahlung_manuell_27,
  t0.abflughafen AS abflughafen_28,
  t0.sb_user AS sb_user_29,
  t0.typ AS typ_30,
  t0.herkunft_id AS herkunft_id_31,
  t0.status AS status_32,
  t0.referenz_vorgang_id AS referenz_vorgang_id_33,
  t0.buchungsanfrage_id AS buchungsanfrage_id_34,
  t0.paket_id AS paket_id_35,
  t0.agentur_id AS agentur_id_36,
  t0.zahlungsschema_id AS zahlungsschema_id_37,
  t0.waehrung_id AS waehrung_id_38,
  t0.betreuer AS betreuer_39
FROM
  vorgang t0
WHERE
  t0.sb_user = ?
  AND t0.vorgangsnummer IS NULL
  AND t0.buchungsanfrage_id IS NULL
  AND t0.typ IS NULL
  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.buchungsdatum AS buchungsdatum_7, t0.vorgangsnummer AS vorgangsnummer_8, t0.gruppenmarker AS gruppenmarker_9, t0.anzahl_reisende AS anzahl_reisende_10, t0.gesamtpreis AS gesamtpreis_11, t0.reisebeginn AS reisebeginn_12, t0.reiseende AS reiseende_13, t0.dauer AS dauer_14, t0.waehrungskurs AS waehrungskurs_15, t0.passolution_data AS passolution_data_16, t0.passolution_timestamp AS passolution_timestamp_17, t0.optionsdatum AS optionsdatum_18, t0.angebotsdatum AS angebotsdatum_19, t0.anzahlung_datum AS anzahlung_datum_20, t0.schlusszahlung_datum AS schlusszahlung_datum_21, t0.anzahlung_betrag AS anzahlung_betrag_22, t0.schlusszahlung_betrag AS schlusszahlung_betrag_23, t0.anzahlung_datum_manuell AS anzahlung_datum_manuell_24, t0.ueberweisung AS ueberweisung_25, t0.anzahlung_betrag_manuell AS anzahlung_betrag_manuell_26, t0.schlusszahlung_manuell AS schlusszahlung_manuell_27, t0.abflughafen AS abflughafen_28, t0.sb_user AS sb_user_29, t0.typ AS typ_30, t0.herkunft_id AS herkunft_id_31, t0.status AS status_32, t0.referenz_vorgang_id AS referenz_vorgang_id_33, t0.buchungsanfrage_id AS buchungsanfrage_id_34, t0.paket_id AS paket_id_35, t0.agentur_id AS agentur_id_36, t0.zahlungsschema_id AS zahlungsschema_id_37, t0.waehrung_id AS waehrung_id_38, t0.betreuer AS betreuer_39 FROM vorgang t0 WHERE t0.sb_user = 93 AND t0.vorgangsnummer IS NULL AND t0.buchungsanfrage_id IS NULL AND t0.typ IS NULL AND ((t0.deleted_at IS NULL));

DELETE FROM
  email_vorlage
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (email_vorlage.deleted_at IS NULL)

DELETE FROM email_vorlage WHERE (sb_user = 93 AND tempFlag = 1) AND (email_vorlage.deleted_at IS NULL);

DELETE FROM
  reiseobjekt_option
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    reiseobjekt_option.deleted_at IS NULL
  )

DELETE FROM reiseobjekt_option WHERE (sb_user = 93 AND tempFlag = 1) AND (reiseobjekt_option.deleted_at IS NULL);

DELETE FROM
  eingangsrechnung
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    eingangsrechnung.deleted_at IS NULL
  )

DELETE FROM eingangsrechnung WHERE (sb_user = 93 AND tempFlag = 1) AND (eingangsrechnung.deleted_at IS NULL);

DELETE FROM
  einkaufskondition_termin
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    einkaufskondition_termin.deleted_at IS NULL
  )

DELETE FROM einkaufskondition_termin WHERE (sb_user = 93 AND tempFlag = 1) AND (einkaufskondition_termin.deleted_at IS NULL);

DELETE FROM
  layout_bereich_zeile
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    layout_bereich_zeile.deleted_at IS NULL
  )

DELETE FROM layout_bereich_zeile WHERE (sb_user = 93 AND tempFlag = 1) AND (layout_bereich_zeile.deleted_at IS NULL);

DELETE FROM
  verteilungsschema_regel
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    verteilungsschema_regel.deleted_at IS NULL
  )

DELETE FROM verteilungsschema_regel WHERE (sb_user = 93 AND tempFlag = 1) AND (verteilungsschema_regel.deleted_at IS NULL);

DELETE FROM
  provisionsschema_regel
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    provisionsschema_regel.deleted_at IS NULL
  )

DELETE FROM provisionsschema_regel WHERE (sb_user = 93 AND tempFlag = 1) AND (provisionsschema_regel.deleted_at IS NULL);

DELETE FROM
  reiseobjekt_verkaufskondition
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    reiseobjekt_verkaufskondition.deleted_at IS NULL
  )

DELETE FROM reiseobjekt_verkaufskondition WHERE (sb_user = 93 AND tempFlag = 1) AND (reiseobjekt_verkaufskondition.deleted_at IS NULL);

DELETE FROM
  layout_bereich
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    layout_bereich.deleted_at IS NULL
  )

DELETE FROM layout_bereich WHERE (sb_user = 93 AND tempFlag = 1) AND (layout_bereich.deleted_at IS NULL);

DELETE FROM
  layout_bereich_zeile_element
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    layout_bereich_zeile_element.deleted_at IS NULL
  )

DELETE FROM layout_bereich_zeile_element WHERE (sb_user = 93 AND tempFlag = 1) AND (layout_bereich_zeile_element.deleted_at IS NULL);

DELETE FROM
  seo_object
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (seo_object.deleted_at IS NULL)

DELETE FROM seo_object WHERE (sb_user = 93 AND tempFlag = 1) AND (seo_object.deleted_at IS NULL);

DELETE FROM
  paket_reiseverlauf_tft
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    paket_reiseverlauf_tft.deleted_at IS NULL
  )

DELETE FROM paket_reiseverlauf_tft WHERE (sb_user = 93 AND tempFlag = 1) AND (paket_reiseverlauf_tft.deleted_at IS NULL);

DELETE FROM
  textbaustein
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (textbaustein.deleted_at IS NULL)

DELETE FROM textbaustein WHERE (sb_user = 93 AND tempFlag = 1) AND (textbaustein.deleted_at IS NULL);

DELETE FROM
  verkaufskondition_termin
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    verkaufskondition_termin.deleted_at IS NULL
  )

DELETE FROM verkaufskondition_termin WHERE (sb_user = 93 AND tempFlag = 1) AND (verkaufskondition_termin.deleted_at IS NULL);

DELETE FROM
  verkaufskondition_option
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    verkaufskondition_option.deleted_at IS NULL
  )

DELETE FROM verkaufskondition_option WHERE (sb_user = 93 AND tempFlag = 1) AND (verkaufskondition_option.deleted_at IS NULL);

DELETE FROM
  paket_reiseverlauf
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    paket_reiseverlauf.deleted_at IS NULL
  )

DELETE FROM paket_reiseverlauf WHERE (sb_user = 93 AND tempFlag = 1) AND (paket_reiseverlauf.deleted_at IS NULL);

DELETE FROM
  stornoprofil_bedingungen
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    stornoprofil_bedingungen.deleted_at IS NULL
  )

DELETE FROM stornoprofil_bedingungen WHERE (sb_user = 93 AND tempFlag = 1) AND (stornoprofil_bedingungen.deleted_at IS NULL);

DELETE FROM
  reiseobjekt_einkaufskondition
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    reiseobjekt_einkaufskondition.deleted_at IS NULL
  )

DELETE FROM reiseobjekt_einkaufskondition WHERE (sb_user = 93 AND tempFlag = 1) AND (reiseobjekt_einkaufskondition.deleted_at IS NULL);

DELETE FROM
  provisionsschema
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    provisionsschema.deleted_at IS NULL
  )

DELETE FROM provisionsschema WHERE (sb_user = 93 AND tempFlag = 1) AND (provisionsschema.deleted_at IS NULL);

DELETE FROM
  zahlungsschema_regel
WHERE
  (
    sb_user = ?
    AND tempFlag = 1
  )
  AND (
    zahlungsschema_regel.deleted_at IS NULL
  )

DELETE FROM zahlungsschema_regel WHERE (sb_user = 93 AND tempFlag = 1) AND (zahlungsschema_regel.deleted_at IS NULL);

"START TRANSACTION"

"START TRANSACTION";

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\\Administration\\User:93' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.fk AS fk_2,
  t0.type AS type_3,
  t0.info AS info_4,
  t0.sperre AS sperre_5,
  t0.user_id AS user_id_6
FROM
  datensatzsperre t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.fk AS fk_2, t0.type AS type_3, t0.info AS info_4, t0.sperre AS sperre_5, t0.user_id AS user_id_6 FROM datensatzsperre t0 WHERE t0.user_id = 93;