GET https://backend.flex-systeme.de/admin/preislisten

Response
200 OK
Browse referrer URL
IP
83.135.2.234
Profiled on
Token
9d311c

Query Metrics

44 Database Queries
12 Different statements
17.91 ms Query time
0 Invalid entities
140 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.27 ms 
SELECT t0.id AS id_1, t0.benutzername AS benutzername_2, t0.email AS email_3, t0.passwort AS passwort_4, t0.vorname AS vorname_5, t0.nachname AS nachname_6, t0.ist_aktiv AS ist_aktiv_7, t0.ist_super_admin AS ist_super_admin_8, t0.erstellt_am AS erstellt_am_9, t0.aktualisiert_am AS aktualisiert_am_10, t0.letzter_login_am AS letzter_login_am_11, t0.letzte_login_ip AS letzte_login_ip_12, t0.fehlgeschlagene_logins AS fehlgeschlagene_logins_13, t0.gesperrt_bis AS gesperrt_bis_14, t0.passwort_geaendert_am AS passwort_geaendert_am_15, t0.muss_passwort_aendern AS muss_passwort_aendern_16 FROM benutzer t0 WHERE t0.id = ?
Parameters: 
[
  b"\x01œF*K|`‰È\x1C¡g*ñÑ"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 7.98 ms 
SELECT p0_.id AS id_0, p0_.typ AS typ_1, p0_.code AS code_2, p0_.name AS name_3, p0_.beschreibung AS beschreibung_4, p0_.ist_standard AS ist_standard_5, p0_.gueltig_von AS gueltig_von_6, p0_.gueltig_bis AS gueltig_bis_7, p0_.ist_aktiv AS ist_aktiv_8, p0_.ist_entwurf AS ist_entwurf_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.created_by AS created_by_12, g1_.id AS id_13, g1_.partner_nummer AS partner_nummer_14, g1_.typ AS typ_15, g1_.firma AS firma_16, g1_.steuernummer AS steuernummer_17, g1_.ust_id_nr AS ust_id_nr_18, g1_.handelsregister_nr AS handelsregister_nr_19, g1_.ist_aktiv AS ist_aktiv_20, g1_.erstellt_am AS erstellt_am_21, g1_.aktualisiert_am AS aktualisiert_am_22, g1_.preis_modell AS preis_modell_23, g1_.diesel_verhalten AS diesel_verhalten_24, g1_.maut_verhalten AS maut_verhalten_25, g1_.carrier_strategie AS carrier_strategie_26, g1_.bevorzugte_carrier AS bevorzugte_carrier_27, g1_.carrier_volumen_ziele AS carrier_volumen_ziele_28, g1_.hat_verrechnungsvereinbarung AS hat_verrechnungsvereinbarung_29, g1_.hat_gutschriftverfahren AS hat_gutschriftverfahren_30, g1_.ist_oeffentlich_rechtlich AS ist_oeffentlich_rechtlich_31, g1_.verrechnungsvereinbarung_datum AS verrechnungsvereinbarung_datum_32, g1_.verrechnungsvereinbarung_referenz AS verrechnungsvereinbarung_referenz_33, p0_.geschaeftspartner_id AS geschaeftspartner_id_34, p0_.parent_id AS parent_id_35, p0_.carrier_id AS carrier_id_36, g1_.rechtsform_id AS rechtsform_id_37, g1_.vk_preisliste_id AS vk_preisliste_id_38 FROM preisliste p0_ LEFT JOIN geschaeftspartner g1_ ON p0_.geschaeftspartner_id = g1_.id ORDER BY g1_.firma ASC, p0_.typ ASC, p0_.gueltig_von ASC, p0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.32 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþF|Ѧæ6­/*\x05ó"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.25 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþF|Ѧæ6­/*\x05ó"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.24 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÅ\tLƒt÷É¶Œ‡%ݶ"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.21 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÅ\tLƒt÷É¶Œ‡%ݶ"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.16 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþ s§¿n§ë¢ðmt"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.14 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþ s§¿n§ë¢ðmt"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.16 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œµoŽ\x07q)”!eqÊâl«"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.12 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œµoŽ\x07q)”!eqÊâl«"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.15 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01cêÓ‰x’³½¢ß;À\x13L"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.15 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01cêÓ‰x’³½¢ß;À\x13L"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.18 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþ1s§™Åø¬£ýΧ"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.20 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþ1s§™Åø¬£ýΧ"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.15 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþ=uu£=:eÜ‚e2"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.16 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÈöþ=uu£=:eÜ‚e2"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.14 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"""
    \x01œ¾3\x18^q\n
    ²\x1EÄx¡E,x
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.12 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"""
    \x01œ¾3\x18^q\n
    ²\x1EÄx¡E,x
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.13 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œ‘wc"z\x04š\x1Fè#ÎðV1"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.12 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œ‘wc"z\x04š\x1Fè#ÎðV1"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.14 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œµoŽ\x07u¹”!eqÐ@Ïõ"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.14 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œµoŽ\x07u¹”!eqÐ@Ïõ"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.96 ms 
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.ist_aktiv AS ist_aktiv_3, c0_.ist_fallback AS ist_fallback_4, c0_.api_typ AS api_typ_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.geschaeftspartner_id AS geschaeftspartner_id_8 FROM carrier c0_ ORDER BY c0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.31 ms 
SELECT g0_.id AS id_0, g0_.partner_nummer AS partner_nummer_1, g0_.typ AS typ_2, g0_.firma AS firma_3, g0_.steuernummer AS steuernummer_4, g0_.ust_id_nr AS ust_id_nr_5, g0_.handelsregister_nr AS handelsregister_nr_6, g0_.ist_aktiv AS ist_aktiv_7, g0_.erstellt_am AS erstellt_am_8, g0_.aktualisiert_am AS aktualisiert_am_9, g0_.preis_modell AS preis_modell_10, g0_.diesel_verhalten AS diesel_verhalten_11, g0_.maut_verhalten AS maut_verhalten_12, g0_.carrier_strategie AS carrier_strategie_13, g0_.bevorzugte_carrier AS bevorzugte_carrier_14, g0_.carrier_volumen_ziele AS carrier_volumen_ziele_15, g0_.hat_verrechnungsvereinbarung AS hat_verrechnungsvereinbarung_16, g0_.hat_gutschriftverfahren AS hat_gutschriftverfahren_17, g0_.ist_oeffentlich_rechtlich AS ist_oeffentlich_rechtlich_18, g0_.verrechnungsvereinbarung_datum AS verrechnungsvereinbarung_datum_19, g0_.verrechnungsvereinbarung_referenz AS verrechnungsvereinbarung_referenz_20, g0_.rechtsform_id AS rechtsform_id_21, g0_.vk_preisliste_id AS vk_preisliste_id_22 FROM geschaeftspartner g0_ WHERE g0_.ist_aktiv = ? ORDER BY g0_.firma ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.17 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÉ+$ßwF»ãðÂò>në"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.14 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œÉ+$ßwF»ãðÂò>në"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.21 ms 
SELECT t0.id AS id_1, t0.debitor_nummer AS debitor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.kreditlimit AS kreditlimit_6, t0.mahnverfahren AS mahnverfahren_7, t0.sepa_mandat AS sepa_mandat_8, t0.e_rechnungs_format AS e_rechnungs_format_9, t0.leitweg_id AS leitweg_id_10, t0.e_rechnungs_email AS e_rechnungs_email_11, t0.erstellt_am AS erstellt_am_12, t0.aktualisiert_am AS aktualisiert_am_13, t0.geschaeftspartner_id AS geschaeftspartner_id_14 FROM debitor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œµoŽ\x05{C¤®\x01Ü×_5"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.13 ms 
SELECT t0.id AS id_1, t0.kreditor_nummer AS kreditor_nummer_2, t0.zahlungsziel_tage AS zahlungsziel_tage_3, t0.skonto_prozent AS skonto_prozent_4, t0.skonto_tage AS skonto_tage_5, t0.incoterm AS incoterm_6, t0.selbstabrechnung AS selbstabrechnung_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9, t0.geschaeftspartner_id AS geschaeftspartner_id_10 FROM kreditor_details t0 WHERE t0.geschaeftspartner_id = ?
Parameters: 
[
  b"\x01œµoŽ\x05{C¤®\x01Ü×_5"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.anzeige_name AS anzeige_name_3, t0.beschreibung AS beschreibung_4, t0.farbe AS farbe_5, t0.ist_system_rolle AS ist_system_rolle_6, t0.ist_aktiv AS ist_aktiv_7, t0.erstellt_am AS erstellt_am_8, t0.aktualisiert_am AS aktualisiert_am_9 FROM rolle t0 INNER JOIN benutzer_rolle ON t0.id = benutzer_rolle.rolle_id WHERE benutzer_rolle.benutzer_id = ?
Parameters: 
[
  b"\x01œF*K|`‰È\x1C¡g*ñÑ"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.24 ms 
SELECT letzter_heartbeat, status
                FROM worker_heartbeat
                WHERE worker_name = ?
                LIMIT 1
Parameters: 
[
  "abrechnung"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.18 ms 
SELECT COUNT(*) AS anzahl
                FROM messenger_messages
                WHERE queue_name = ?
Parameters: 
[
  "failed"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.16 ms 
SELECT COUNT(*) AS anzahl, MIN(created_at) AS aelteste
                FROM messenger_messages
                WHERE queue_name = ?
                  AND delivered_at IS NULL
                  AND created_at < DATE_SUB(NOW(), INTERVAL ? MINUTE)
Parameters: 
[
  "abrechnung"
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.16 ms 
SELECT COUNT(*) AS anzahl, MIN(erstellt_am) AS aelteste
                FROM abrechnungs_lauf
                WHERE status IN (?, ?)
                  AND erstellt_am < DATE_SUB(NOW(), INTERVAL ? MINUTE)
Parameters: 
[
  "gestartet"
  "verarbeitet"
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
34 1.40 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œC6HZ|E¨\x0Eè(8î^¼"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.21 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œò¸µ\x18ym¶åÖ\x11Û¶_d"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.16 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œC\x1A~y}E†œ“ë{/Úæ"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.16 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œC6H›~òœ\x05'$Š%ÀÁ"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.17 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œC6HÌ{ÿûˆ)Cîžî"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.14 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œC6Hów.—În˜\faH\x1D"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.36 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œC6HlsÈ¡}ùy¤\x1D¾"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.23 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œò¹Êâ{¸í¢LÉ\x10\o"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.18 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01cð/X~üµªƒ©\x15öˆ¿"
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.18 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œÃŽžžpX¨\x01ñtk\x12\x15˜"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.17 ms 
SELECT t0.id AS id_1, t0.staffel_typ AS staffel_typ_2, t0.staffel_config AS staffel_config_3, t0.waehrung AS waehrung_4, t0.gueltig_von AS gueltig_von_5, t0.gueltig_bis AS gueltig_bis_6, t0.ist_aktiv AS ist_aktiv_7, t0.notizen AS notizen_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.preisliste_id AS preisliste_id_11, t0.komponente_typ_id AS komponente_typ_id_12, t0.carrier_produkt_id AS carrier_produkt_id_13, t0.preisgebiet_id AS preisgebiet_id_14, t0.basis_komponente_id AS basis_komponente_id_15 FROM preiskomponente t0 WHERE t0.preisliste_id = ?
Parameters: 
[
  b"\x01œò¼\x1A9|© ñ³Ò{üÂö"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Preis\Entity\Preiskomponente 70
App\Preis\Entity\Preisliste 14
App\Carrier\Entity\CarrierProdukt 13
App\Geschaeftspartner\Entity\Geschaeftspartner 12
App\Preis\Entity\PreiskomponenteTyp 12
App\Geschaeftspartner\Entity\KreditorDetails 6
App\Carrier\Entity\Carrier 6
App\Geschaeftspartner\Entity\DebitorDetails 4
App\Geschaeftspartner\Entity\Rechtsform 2
App\Benutzer\Entity\Benutzer 1

Entities Mapping

Class Mapping errors
App\Benutzer\Entity\Benutzer No errors.
App\Rolle\Entity\Rolle No errors.
App\Benutzer\Entity\BenutzerBerechtigung No errors.
App\Preis\Entity\Preisliste No errors.
App\Geschaeftspartner\Entity\Geschaeftspartner No errors.
App\Carrier\Entity\Carrier No errors.
App\Geschaeftspartner\Entity\Rechtsform No errors.
App\Preis\Entity\Preiskomponente No errors.
App\Geschaeftspartner\Entity\DebitorDetails No errors.
App\Geschaeftspartner\Entity\KreditorDetails No errors.
App\Geschaeftspartner\Entity\GeschaeftspartnerAdresse No errors.
App\Geschaeftspartner\Entity\GeschaeftspartnerBankverbindung No errors.
App\Geschaeftspartner\Entity\GeschaeftspartnerAnsprechpartner No errors.
App\Geschaeftspartner\Entity\ExternePartnerZuordnung No errors.
App\Carrier\Entity\CarrierProdukt No errors.
App\Preis\Entity\PreiskomponenteTyp No errors.
App\Preis\Entity\Preisgebiet No errors.
App\Preis\Entity\Zuschlagsregel No errors.