Query Metrics
116
Database Queries
31
Different statements
94.22 ms
Query time
0
Invalid entities
256
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.48 ms |
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
Parameters:
[
"qkTJjXyKOG3D8Eqqn6RBf4Y9Mi0pfTnKDmOE9tKYSOYxMnoVe0KNkL9wGg3I9YtqNcxItOMrvtqdhqpWxsJRDCamzr7isg8njocvzpbK2YbmyUgsVUc2gR0RuhbbBxJUTYbsREHmKNpWBJwVoEwBLB4nAcWvK4PoyDWKiv3ZQVgsds46oQemyOU4lr4GcG8tsD1fy9iBoLRd70PAhFokd7Xs01M27vowCon5Ye9A0j3zE68Q3Gos2E4ckflyS37VdxsvDE4vt7kclunbm3PfIU55AIrGKCMwEtUuQNHoSBysdDHkBjmx6nUc6sF8c4eHJZOcyL6ZZ36qXeq1aM9ioL5aFCtpQvQQ4VSwjg8kNnn09hMAdhVTQgcxALM0TqeriusSjyVpkmxOa3231231"
]
|
| 2 | 0.43 ms |
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.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"admin@tourone.de"
]
|
| 3 | 0.35 ms |
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 = ?
Parameters:
[
54
]
|
| 4 | 0.38 ms |
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
Parameters:
[ "AUTH_TOKEN" "Pixxio" ] |
| 5 | 0.22 ms |
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
Parameters:
[ "BASE_URL" "Pixxio" ] |
| 6 | 0.40 ms |
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))
Parameters:
[
"36"
]
|
| 7 | 0.36 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\Paket:36"
]
|
| 8 | 0.26 ms |
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))
Parameters:
[
36
]
|
| 9 | 3.07 ms |
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))
Parameters:
[
36
]
|
| 10 | 1.50 ms |
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))
Parameters:
[
36
]
|
| 11 | 0.22 ms |
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))
Parameters:
[
36
]
|
| 12 | 0.21 ms |
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))
Parameters:
[
"App\Entity\Reise\Reiseart:11"
]
|
| 13 | 0.23 ms |
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))
Parameters:
[
1
]
|
| 14 | 0.26 ms |
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, t0.reiseverlauf_tf_t_id AS reiseverlauf_tf_t_id_13 FROM paket_reiseverlauf t0 WHERE t0.paket_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
36
]
|
| 15 | 0.20 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:78"
]
|
| 16 | 0.18 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:79"
]
|
| 17 | 0.22 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:80"
]
|
| 18 | 0.22 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:81"
]
|
| 19 | 0.25 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:82"
]
|
| 20 | 0.20 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:83"
]
|
| 21 | 0.17 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:84"
]
|
| 22 | 0.19 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:85"
]
|
| 23 | 0.18 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:86"
]
|
| 24 | 0.17 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:87"
]
|
| 25 | 0.19 ms |
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
Parameters:
[
36
]
|
| 26 | 0.23 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\Paket:36"
]
|
| 27 | 0.27 ms |
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
Parameters:
[
36
]
|
| 28 | 0.25 ms |
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))
Parameters:
[
36
]
|
| 29 | 0.36 ms |
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))
Parameters:
[
36
]
|
| 30 | 2.11 ms |
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.type AS type_10, t0.buchungsdatum_vor AS buchungsdatum_vor_11, t0.buchungsdatum_nach AS buchungsdatum_nach_12, t0.sb_user AS sb_user_13, t0.stornoprofil_id AS stornoprofil_id_14, t0.paket_id AS paket_id_15, t0.leistungstraeger_id AS leistungstraeger_id_16, t0.reiseobjekt_id AS reiseobjekt_id_17, t0.reiseart_id AS reiseart_id_18, t0.reiseobjekt_option_id AS reiseobjekt_option_id_19 FROM stornoprofil_bedingungen t0 WHERE t0.paket_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
36
]
|
| 31 | 1.80 ms |
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.type AS type_10, t0.buchungsdatum_vor AS buchungsdatum_vor_11, t0.buchungsdatum_nach AS buchungsdatum_nach_12, t0.sb_user AS sb_user_13, t0.zahlungsprofil_id AS zahlungsprofil_id_14, t0.paket_id AS paket_id_15, t0.leistungstraeger_id AS leistungstraeger_id_16, t0.reiseobjekt_id AS reiseobjekt_id_17, t0.reiseart_id AS reiseart_id_18, t0.reiseobjekt_option_id AS reiseobjekt_option_id_19 FROM zahlungsprofil_bedingung t0 WHERE t0.paket_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
36
]
|
| 32 | 0.24 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260805"
]
|
| 33 | 0.37 ms |
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.anz_validation AS anz_validation_14, t0.auswahlopt_buchungsstr AS auswahlopt_buchungsstr_15, t0.rang AS rang_16, t0.pflicht AS pflicht_17, t0.start_option AS start_option_18, t0.start_verschiebung AS start_verschiebung_19, t0.sb_user AS sb_user_20, t0.gruppenelement_id AS gruppenelement_id_21, t0.paket_id AS paket_id_22, t0.reisobjekt_id AS reisobjekt_id_23, t0.key_id AS key_id_24, t0.vkk_id AS vkk_id_25, t0.fibukonto_storno_id AS fibukonto_storno_id_26, t0.fibukonto_erloes_id AS fibukonto_erloes_id_27, t0.kostenstelle_id AS kostenstelle_id_28, t0.kostentraeger_id AS kostentraeger_id_29, t0.verteilungsschema_id AS verteilungsschema_id_30, t0.start_leistung_id AS start_leistung_id_31 FROM paket_reiseobjekt t0 WHERE t0.paket_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
36
]
|
| 34 | 0.26 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:111"
]
|
| 35 | 0.23 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:112"
]
|
| 36 | 0.25 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:114"
]
|
| 37 | 0.21 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:115"
]
|
| 38 | 0.19 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:118"
]
|
| 39 | 0.23 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:116"
]
|
| 40 | 0.19 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:119"
]
|
| 41 | 0.18 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:120"
]
|
| 42 | 0.19 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseobjekt:113"
]
|
| 43 | 0.32 ms |
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.sb_user AS sb_user_13, t0.type_id AS type_id_14, t0.lt_ag_einkauf_id AS lt_ag_einkauf_id_15, t0.lt_ag_vorOrt_id AS lt_ag_vorOrt_id_16, t17.deleted_at AS deleted_at_18, t17.anlage_datum AS anlage_datum_19, t17.aenderung_datum AS aenderung_datum_20, t17.aktiv AS aktiv_21, t17.sb_name AS sb_name_22, t17.id AS id_23, t17.strasse AS strasse_24, t17.bundesland AS bundesland_25, t17.hausnummer AS hausnummer_26, t17.zusatz AS zusatz_27, t17.plz AS plz_28, t17.ort AS ort_29, t17.rang AS rang_30, t17.anmerkung AS anmerkung_31, t17.is_default AS is_default_32, t17.latitude AS latitude_33, t17.longitude AS longitude_34, t17.sb_user AS sb_user_35, t17.land_id AS land_id_36, t17.kunde_id AS kunde_id_37, t17.reiseobjekt_id AS reiseobjekt_id_38, t17.agentur_id AS agentur_id_39, t0.metainfo_id AS metainfo_id_40, t0.fibukonto_storno_id AS fibukonto_storno_id_41, t0.fibukonto_erloes_id AS fibukonto_erloes_id_42, t0.fibukonto_aufwand_id AS fibukonto_aufwand_id_43, t0.kostenstelle_id AS kostenstelle_id_44, t0.kostentraeger_id AS kostentraeger_id_45, t0.verteilungsschema_id AS verteilungsschema_id_46 FROM reiseobjekt t0 LEFT JOIN adresse t17 ON t17.reiseobjekt_id = t0.id AND ((t17.deleted_at IS NULL)) WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
4099
]
|
| 44 | 0.23 ms |
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))
Parameters:
[
"App\Entity\Reise\Reiseobjekt:4099"
]
|
| 45 | 0.17 ms |
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.kuerzel AS kuerzel_7, t0.sb_user AS sb_user_8 FROM key_reiseobjekt_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
| 46 | 0.21 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260812"
]
|
| 47 | 0.21 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260819"
]
|
| 48 | 0.18 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260826"
]
|
| 49 | 0.19 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260902"
]
|
| 50 | 0.19 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260909"
]
|
| 51 | 0.20 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260916"
]
|
| 52 | 0.34 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260923"
]
|
| 53 | 0.22 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_260930"
]
|
| 54 | 0.19 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261007"
]
|
| 55 | 0.17 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261014"
]
|
| 56 | 0.16 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261021"
]
|
| 57 | 0.20 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261028"
]
|
| 58 | 0.19 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261104"
]
|
| 59 | 0.16 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261111"
]
|
| 60 | 0.16 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261118"
]
|
| 61 | 0.17 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261125"
]
|
| 62 | 0.19 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261202"
]
|
| 63 | 0.17 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261209"
]
|
| 64 | 0.17 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261216"
]
|
| 65 | 0.21 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261223"
]
|
| 66 | 0.17 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_261230"
]
|
| 67 | 0.17 ms |
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.type AS type_7, t0.rang AS rang_8, t0.from_iata AS from_iata_9, t0.to_iata AS to_iata_10, t0.nachtflug AS nachtflug_11, t0.sb_user AS sb_user_12, t0.termin AS termin_13 FROM termin_flight t0 WHERE t0.termin = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.rang ASC
Parameters:
[
"LTBAL_270106"
]
|
| 68 | 0.27 ms |
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.preistyp AS preistyp_9, t0.bezeichnung AS bezeichnung_10, t0.pauschalpreis AS pauschalpreis_11, t0.preis_bei_saisonueberschneidung AS preis_bei_saisonueberschneidung_12, t0.is_nicht_versicherungsrelevant AS is_nicht_versicherungsrelevant_13, t0.preis_fuer_tag_nacht_anzahl AS preis_fuer_tag_nacht_anzahl_14, t0.preis_fuer_tag_nacht_typ AS preis_fuer_tag_nacht_typ_15, t0.sb_user AS sb_user_16, t0.reiseobjekt_id AS reiseobjekt_id_17, t0.key_pruefschema_id AS key_pruefschema_id_18 FROM reiseobjekt_verkaufskondition t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
157
]
|
| 69 | 0.25 ms |
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.datum AS datum_9, t0.saison AS saison_10, t0.min_personen AS min_personen_11, t0.max_personen AS max_personen_12, t0.bemerkung AS bemerkung_13, t0.sb_user AS sb_user_14, t0.verkaufskondition_id AS verkaufskondition_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin t0 WHERE t0.verkaufskondition_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.datum ASC
Parameters:
[
157
]
|
| 70 | 0.27 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13917
]
|
| 71 | 0.26 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13918
]
|
| 72 | 0.19 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13919
]
|
| 73 | 0.24 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13920
]
|
| 74 | 0.26 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13921
]
|
| 75 | 0.21 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13922
]
|
| 76 | 0.23 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13923
]
|
| 77 | 0.21 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13924
]
|
| 78 | 0.20 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13925
]
|
| 79 | 0.22 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13926
]
|
| 80 | 0.22 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13927
]
|
| 81 | 0.24 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13928
]
|
| 82 | 0.20 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13929
]
|
| 83 | 0.23 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13930
]
|
| 84 | 0.22 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13931
]
|
| 85 | 0.20 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13932
]
|
| 86 | 0.30 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13933
]
|
| 87 | 0.23 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13934
]
|
| 88 | 0.22 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13935
]
|
| 89 | 0.23 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13936
]
|
| 90 | 0.22 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13937
]
|
| 91 | 0.20 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13938
]
|
| 92 | 0.22 ms |
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.preis AS preis_7, t0.kontingent_gesamt AS kontingent_gesamt_8, t0.kontingent_frei AS kontingent_frei_9, t0.release_datum AS release_datum_10, t0.preisDefault AS preisDefault_11, t0.preis_mit_zuschlag AS preis_mit_zuschlag_12, t0.sb_user AS sb_user_13, t0.reiseobjekt_option_id AS reiseobjekt_option_id_14, t0.verkaufskondition_termin_id AS verkaufskondition_termin_id_15, t0.status_id AS status_id_16 FROM verkaufskondition_termin_preis t0 WHERE t0.verkaufskondition_termin_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13939
]
|
| 93 | 0.20 ms |
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.parent_property = ? AND ((t0.deleted_at IS NULL))
Parameters:
[ "App\Entity\Reise\Land:EE" "landBeschreibungTexte" ] |
| 94 | 0.19 ms |
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.metainfo_id AS metainfo_id_8 FROM kontinent t0 INNER JOIN land_kontinent ON t0.id = land_kontinent.kontinent_id WHERE land_kontinent.land_alpha2 = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"EE"
]
|
| 95 | 2.08 ms |
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.code AS code_9, t0.int_beschreibung AS int_beschreibung_10, t0.no_index AS no_index_11, t0.no_follow AS no_follow_12, t0.type AS type_13, t0.sb_user AS sb_user_14 FROM metainfo t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
7
]
|
| 96 | 52.87 ms |
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))
Parameters:
[
"App\Entity\CMS\Metainfo:7"
]
|
| 97 | 0.54 ms |
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.parent_property = ? AND ((t0.deleted_at IS NULL))
Parameters:
[ "App\Entity\Reise\Land:LT" "landBeschreibungTexte" ] |
| 98 | 0.34 ms |
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.metainfo_id AS metainfo_id_8 FROM kontinent t0 INNER JOIN land_kontinent ON t0.id = land_kontinent.kontinent_id WHERE land_kontinent.land_alpha2 = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"LT"
]
|
| 99 | 0.37 ms |
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.parent_property = ? AND ((t0.deleted_at IS NULL))
Parameters:
[ "App\Entity\Reise\Land:LV" "landBeschreibungTexte" ] |
| 100 | 0.32 ms |
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.metainfo_id AS metainfo_id_8 FROM kontinent t0 INNER JOIN land_kontinent ON t0.id = land_kontinent.kontinent_id WHERE land_kontinent.land_alpha2 = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"LV"
]
|
| 101 | 0.91 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
94
]
|
| 102 | 0.55 ms |
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.kuerzel AS kuerzel_8, t0.rang AS rang_9, t0.vorgangsbetreuung AS vorgangsbetreuung_10, t0.in_kalender AS in_kalender_11, t0.signatur_email AS signatur_email_12, t0.type AS type_13, t0.sb_user AS sb_user_14, t0.user_id AS user_id_15 FROM abteilung t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
10
]
|
| 103 | 0.38 ms |
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.code AS code_9, t0.int_beschreibung AS int_beschreibung_10, t0.no_index AS no_index_11, t0.no_follow AS no_follow_12, t0.type AS type_13, t0.sb_user AS sb_user_14 FROM metainfo t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
9
]
|
| 104 | 0.36 ms |
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))
Parameters:
[
"App\Entity\CMS\Metainfo:9"
]
|
| 105 | 0.92 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:78"
]
|
| 106 | 0.52 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:79"
]
|
| 107 | 0.44 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:80"
]
|
| 108 | 0.53 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:81"
]
|
| 109 | 0.72 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:82"
]
|
| 110 | 0.57 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:83"
]
|
| 111 | 0.53 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:84"
]
|
| 112 | 0.56 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:85"
]
|
| 113 | 0.46 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:86"
]
|
| 114 | 0.44 ms |
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))
Parameters:
[
"App\Entity\Reise\Paket\PaketReiseverlauf:87"
]
|
| 115 | 0.39 ms |
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.code AS code_9, t0.int_beschreibung AS int_beschreibung_10, t0.no_index AS no_index_11, t0.no_follow AS no_follow_12, t0.type AS type_13, t0.sb_user AS sb_user_14 FROM metainfo t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
16
]
|
| 116 | 0.34 ms |
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))
Parameters:
[
"App\Entity\CMS\Metainfo:16"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Reise\VerkaufskonditionTerminPreis | 92 |
| App\Entity\Reise\Paket\Termin | 23 |
| App\Entity\Reise\VerkaufskonditionTermin | 23 |
| App\Entity\Administration\UserRight | 19 |
| App\Entity\Texte\SpracheText | 18 |
| App\Entity\Administration\Right | 13 |
| App\Entity\Reise\Paket\PaketReiseverlauf | 10 |
| App\Entity\Reise\Paket\PaketReiseobjekt | 9 |
| App\Entity\Reise\Reiseobjekt | 8 |
| App\Entity\Administration\User | 6 |
| App\Entity\CMS\Metainfo | 4 |
| App\Entity\Reise\ReiseobjektOption | 4 |
| App\Entity\Reise\Land | 3 |
| App\Entity\Key\KeyGeschlecht | 2 |
| App\Entity\Administration\Abteilung | 2 |
| App\Entity\Administration\Parameter | 2 |
| App\Entity\CMS\Sprache | 2 |
| App\Entity\Key\KeyPaketReiseobjektType | 2 |
| App\Entity\Reise\Paket\PaketGruppeElement | 2 |
| App\Entity\Reise\Paket\Paket | 1 |
| App\Entity\Key\KeyPaketType | 1 |
| App\Entity\Reise\Paket\PaketUser | 1 |
| App\Entity\Key\KeyPaketUserType | 1 |
| App\Entity\Reise\Reiseart | 1 |
| App\Entity\Stammdaten\Tag | 1 |
| App\Entity\Stammdaten\TagGruppe | 1 |
| App\Entity\Reise\ReiseobjektVerkaufskondition | 1 |
| App\Entity\Key\KeyReiseobjektType | 1 |
| App\Entity\Key\KeyKontingentPruefschema | 1 |
| App\Entity\Reise\Kontinent | 1 |
| App\Entity\Stammdaten\SpracheAPI | 1 |