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
  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.titel AS titel_9,
  t0.vorname AS vorname_10,
  t0.name AS name_11,
  t0.geburtstag AS geburtstag_12,
  t0.veroeffentlichen AS veroeffentlichen_13,
  t0.profil_text AS profil_text_14,
  t0.confirmed_email AS confirmed_email_15,
  t0.password AS password_16,
  t0.last_login_date AS last_login_date_17,
  t0.validation_date AS validation_date_18,
  t0.account_active AS account_active_19,
  t0.legacy_password AS legacy_password_20,
  t0.legacy_password_salt AS legacy_password_salt_21,
  t0.to2id AS to2id_22,
  t0.to2nr AS to2nr_23,
  t0.sb_user AS sb_user_24,
  t0.geschlecht_id AS geschlecht_id_25
FROM
  agentur_mitarbeiter 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.titel AS titel_9, t0.vorname AS vorname_10, t0.name AS name_11, t0.geburtstag AS geburtstag_12, t0.veroeffentlichen AS veroeffentlichen_13, t0.profil_text AS profil_text_14, t0.confirmed_email AS confirmed_email_15, t0.password AS password_16, t0.last_login_date AS last_login_date_17, t0.validation_date AS validation_date_18, t0.account_active AS account_active_19, t0.legacy_password AS legacy_password_20, t0.legacy_password_salt AS legacy_password_salt_21, t0.to2id AS to2id_22, t0.to2nr AS to2nr_23, t0.sb_user AS sb_user_24, t0.geschlecht_id AS geschlecht_id_25 FROM agentur_mitarbeiter t0 WHERE t0.id = 57099 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.titel AS titel_9,
  t0.vorname AS vorname_10,
  t0.name AS name_11,
  t0.geburtstag AS geburtstag_12,
  t0.veroeffentlichen AS veroeffentlichen_13,
  t0.profil_text AS profil_text_14,
  t0.confirmed_email AS confirmed_email_15,
  t0.password AS password_16,
  t0.last_login_date AS last_login_date_17,
  t0.validation_date AS validation_date_18,
  t0.account_active AS account_active_19,
  t0.legacy_password AS legacy_password_20,
  t0.legacy_password_salt AS legacy_password_salt_21,
  t0.to2id AS to2id_22,
  t0.to2nr AS to2nr_23,
  t0.sb_user AS sb_user_24,
  t0.geschlecht_id AS geschlecht_id_25
FROM
  agentur_mitarbeiter t0
WHERE
  t0.confirmed_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.titel AS titel_9, t0.vorname AS vorname_10, t0.name AS name_11, t0.geburtstag AS geburtstag_12, t0.veroeffentlichen AS veroeffentlichen_13, t0.profil_text AS profil_text_14, t0.confirmed_email AS confirmed_email_15, t0.password AS password_16, t0.last_login_date AS last_login_date_17, t0.validation_date AS validation_date_18, t0.account_active AS account_active_19, t0.legacy_password AS legacy_password_20, t0.legacy_password_salt AS legacy_password_salt_21, t0.to2id AS to2id_22, t0.to2nr AS to2nr_23, t0.sb_user AS sb_user_24, t0.geschlecht_id AS geschlecht_id_25 FROM agentur_mitarbeiter t0 WHERE t0.confirmed_email = 'testopopesto@mail.de' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  MAX(e0_.version) AS sclr_0
FROM
  ext_log_entries e0_
WHERE
  e0_.object_id = ?
  AND e0_.object_class = ?

SELECT MAX(e0_.version) AS sclr_0 FROM ext_log_entries e0_ WHERE e0_.object_id = '57099' AND e0_.object_class = 'App\\Entity\\CRM\\AgenturMitarbeiter';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO account_log (
  anlage_datum, account, action, data
)
VALUES
  (?, ?, ?, ?)

INSERT INTO account_log (anlage_datum, account, action, data) VALUES ('2026-10-20 18:08:55', 'App\\Entity\\CRM\\AgenturMitarbeiter:57099', 'validate', '');

INSERT INTO ext_log_entries (
  action, data, version, logged_at, username,
  object_class, object_id, sb_user
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ext_log_entries (action, data, version, logged_at, username, object_class, object_id, sb_user) VALUES ('update', '{\"password\":\"$2y$13$Aw5VdnUxnpitTYGOs6QSn.DrX7HsYEWwwhkgh.yn6hy1\\/G5BkjfA2\",\"lastLoginDate\":{\"date\":\"2026-10-20 18:08:55.536234\",\"timezone_type\":3,\"timezone\":\"Europe\\/Berlin\"},\"validationDate\":{\"date\":\"2026-10-20 18:08:55.536226\",\"timezone_type\":3,\"timezone\":\"Europe\\/Berlin\"}}', 9, '2026-10-20 18:08:55', 'feuser.anonym@tourone.de', 'App\\Entity\\CRM\\AgenturMitarbeiter', '57099', 106);

UPDATE
  agentur_mitarbeiter
SET
  password = ?,
  last_login_date = ?,
  validation_date = ?,
  aenderung_datum = ?,
  sb_user = ?
WHERE
  id = ?

UPDATE agentur_mitarbeiter SET password = '$2y$13$Aw5VdnUxnpitTYGOs6QSn.DrX7HsYEWwwhkgh.yn6hy1/G5BkjfA2', last_login_date = '2026-10-20 18:08:55', validation_date = '2026-10-20 18:08:55', aenderung_datum = '2026-10-20 18:08:55', sb_user = 106 WHERE id = 57099;

"COMMIT"

"COMMIT";

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.kontakt AS kontakt_7,
  t0.telefon_normalisiert AS telefon_normalisiert_8,
  t0.rang AS rang_9,
  t0.anmerkung AS anmerkung_10,
  t0.is_default AS is_default_11,
  t0.sb_user AS sb_user_12,
  t0.typ_id AS typ_id_13,
  t0.kunde_id AS kunde_id_14,
  t0.agt_mitarbeiter_id AS agt_mitarbeiter_id_15,
  t0.agentur_id AS agentur_id_16
FROM
  kontakt t0
WHERE
  t0.agt_mitarbeiter_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.kontakt AS kontakt_7, t0.telefon_normalisiert AS telefon_normalisiert_8, t0.rang AS rang_9, t0.anmerkung AS anmerkung_10, t0.is_default AS is_default_11, t0.sb_user AS sb_user_12, t0.typ_id AS typ_id_13, t0.kunde_id AS kunde_id_14, t0.agt_mitarbeiter_id AS agt_mitarbeiter_id_15, t0.agentur_id AS agentur_id_16 FROM kontakt t0 WHERE t0.agt_mitarbeiter_id = 57099 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.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 agt_mtb_tag ON t0.id = agt_mtb_tag.tag_id
WHERE
  agt_mtb_tag.agt_mtb_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 agt_mtb_tag ON t0.id = agt_mtb_tag.tag_id WHERE agt_mtb_tag.agt_mtb_id = 57099 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.kundennr AS kundennr_7,
  t0.titel AS titel_8,
  t0.vorname AS vorname_9,
  t0.typ AS typ_10,
  t0.geburtstag AS geburtstag_11,
  t0.name AS name_12,
  t0.count_vorgaenge_adjust AS count_vorgaenge_adjust_13,
  t0.is_dummy AS is_dummy_14,
  t0.confirmed_email AS confirmed_email_15,
  t0.password AS password_16,
  t0.last_login_date AS last_login_date_17,
  t0.validation_date AS validation_date_18,
  t0.account_active AS account_active_19,
  t0.legacy_password AS legacy_password_20,
  t0.legacy_password_salt AS legacy_password_salt_21,
  t0.to2id AS to2id_22,
  t0.to2nr AS to2nr_23,
  t0.sb_user AS sb_user_24,
  t0.geschlecht_id AS geschlecht_id_25,
  t0.sprache_id AS sprache_id_26,
  t0.expedient_von_agentur AS expedient_von_agentur_27,
  t0.kunde_von_agentur AS kunde_von_agentur_28,
  t0.user_im_backend AS user_im_backend_29,
  t0.club_id AS club_id_30
FROM
  kunde t0
WHERE
  t0.expedient_von_agentur = ?
  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.kundennr AS kundennr_7, t0.titel AS titel_8, t0.vorname AS vorname_9, t0.typ AS typ_10, t0.geburtstag AS geburtstag_11, t0.name AS name_12, t0.count_vorgaenge_adjust AS count_vorgaenge_adjust_13, t0.is_dummy AS is_dummy_14, t0.confirmed_email AS confirmed_email_15, t0.password AS password_16, t0.last_login_date AS last_login_date_17, t0.validation_date AS validation_date_18, t0.account_active AS account_active_19, t0.legacy_password AS legacy_password_20, t0.legacy_password_salt AS legacy_password_salt_21, t0.to2id AS to2id_22, t0.to2nr AS to2nr_23, t0.sb_user AS sb_user_24, t0.geschlecht_id AS geschlecht_id_25, t0.sprache_id AS sprache_id_26, t0.expedient_von_agentur AS expedient_von_agentur_27, t0.kunde_von_agentur AS kunde_von_agentur_28, t0.user_im_backend AS user_im_backend_29, t0.club_id AS club_id_30 FROM kunde t0 WHERE t0.expedient_von_agentur = 57099 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\\CRM\\AgenturMitarbeiter:57099' 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.rolle_id AS rolle_id_7,
  t0.to2id AS to2id_8,
  t0.sb_user AS sb_user_9,
  t0.agentur_mitarbeiter_id AS agentur_mitarbeiter_id_10,
  t0.agentur_id AS agentur_id_11
FROM
  agentur_mitarbeiter_zugehoerigkeit t0
WHERE
  t0.agentur_mitarbeiter_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.rolle_id AS rolle_id_7, t0.to2id AS to2id_8, t0.sb_user AS sb_user_9, t0.agentur_mitarbeiter_id AS agentur_mitarbeiter_id_10, t0.agentur_id AS agentur_id_11 FROM agentur_mitarbeiter_zugehoerigkeit t0 WHERE t0.agentur_mitarbeiter_id = 57099 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.kontoinhaber AS kontoinhaber_24,
  t0.iban AS iban_25,
  t0.bic AS bic_26,
  t0.auto_beleg_erstellung AS auto_beleg_erstellung_27,
  t0.selfbilling AS selfbilling_28,
  t0.passdaten_relevant AS passdaten_relevant_29,
  t0.pass_typ AS pass_typ_30,
  t0.pass_kopie AS pass_kopie_31,
  t0.adresse_relevant AS adresse_relevant_32,
  t0.telefondaten_relevant AS telefondaten_relevant_33,
  t0.provision_von_mutteragentur AS provision_von_mutteragentur_34,
  t0.provision_zeitpunkt AS provision_zeitpunkt_35,
  t0.mwst_in_prozent AS mwst_in_prozent_36,
  t0.kooperation AS kooperation_37,
  t0.sb_user AS sb_user_38,
  t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_39,
  t0.api_id AS api_id_40,
  t0.land_id AS land_id_41,
  t0.agt_id AS agt_id_42,
  t0.hierarchie_typ_id AS hierarchie_typ_id_43,
  t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_44,
  t0.leistung_gruppierung AS leistung_gruppierung_45,
  t0.prov_id AS prov_id_46,
  t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_47,
  t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_48,
  t0.inkasso_id AS inkasso_id_49,
  t0.zahlungsart_id AS zahlungsart_id_50
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.kontoinhaber AS kontoinhaber_24, t0.iban AS iban_25, t0.bic AS bic_26, t0.auto_beleg_erstellung AS auto_beleg_erstellung_27, t0.selfbilling AS selfbilling_28, t0.passdaten_relevant AS passdaten_relevant_29, t0.pass_typ AS pass_typ_30, t0.pass_kopie AS pass_kopie_31, t0.adresse_relevant AS adresse_relevant_32, t0.telefondaten_relevant AS telefondaten_relevant_33, t0.provision_von_mutteragentur AS provision_von_mutteragentur_34, t0.provision_zeitpunkt AS provision_zeitpunkt_35, t0.mwst_in_prozent AS mwst_in_prozent_36, t0.kooperation AS kooperation_37, t0.sb_user AS sb_user_38, t0.fibukonto_kreditor_id AS fibukonto_kreditor_id_39, t0.api_id AS api_id_40, t0.land_id AS land_id_41, t0.agt_id AS agt_id_42, t0.hierarchie_typ_id AS hierarchie_typ_id_43, t0.fibukonto_aufwand_einkauf_id AS fibukonto_aufwand_einkauf_id_44, t0.leistung_gruppierung AS leistung_gruppierung_45, t0.prov_id AS prov_id_46, t0.fibukonto_provision_aufwand_id AS fibukonto_provision_aufwand_id_47, t0.fibukonto_provision_versicherung_id AS fibukonto_provision_versicherung_id_48, t0.inkasso_id AS inkasso_id_49, t0.zahlungsart_id AS zahlungsart_id_50 FROM agentur t0 WHERE t0.id = 8759 AND ((t0.deleted_at IS NULL));