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 ('AF')) AND (p0_.deleted_at IS NULL);