Symfony Profiler

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 = ?

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 = 0x019C90462A4B7C6089C81CA1672AF1D1;

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,
  d1_.id AS id_21,
  d1_.debitor_nummer AS debitor_nummer_22,
  d1_.zahlungsziel_tage AS zahlungsziel_tage_23,
  d1_.skonto_prozent AS skonto_prozent_24,
  d1_.skonto_tage AS skonto_tage_25,
  d1_.kreditlimit AS kreditlimit_26,
  d1_.mahnverfahren AS mahnverfahren_27,
  d1_.sepa_mandat AS sepa_mandat_28,
  d1_.e_rechnungs_format AS e_rechnungs_format_29,
  d1_.leitweg_id AS leitweg_id_30,
  d1_.e_rechnungs_email AS e_rechnungs_email_31,
  d1_.erstellt_am AS erstellt_am_32,
  d1_.aktualisiert_am AS aktualisiert_am_33,
  k2_.id AS id_34,
  k2_.kreditor_nummer AS kreditor_nummer_35,
  k2_.zahlungsziel_tage AS zahlungsziel_tage_36,
  k2_.skonto_prozent AS skonto_prozent_37,
  k2_.skonto_tage AS skonto_tage_38,
  k2_.incoterm AS incoterm_39,
  k2_.selbstabrechnung AS selbstabrechnung_40,
  k2_.erstellt_am AS erstellt_am_41,
  k2_.aktualisiert_am AS aktualisiert_am_42,
  g0_.rechtsform_id AS rechtsform_id_43,
  g0_.vk_preisliste_id AS vk_preisliste_id_44,
  d1_.geschaeftspartner_id AS geschaeftspartner_id_45,
  k2_.geschaeftspartner_id AS geschaeftspartner_id_46
FROM
  geschaeftspartner g0_
  LEFT JOIN debitor_details d1_ ON g0_.id = d1_.geschaeftspartner_id
  LEFT JOIN kreditor_details k2_ ON g0_.id = k2_.geschaeftspartner_id
ORDER BY
  g0_.firma ASC
LIMIT
  20

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, d1_.id AS id_21, d1_.debitor_nummer AS debitor_nummer_22, d1_.zahlungsziel_tage AS zahlungsziel_tage_23, d1_.skonto_prozent AS skonto_prozent_24, d1_.skonto_tage AS skonto_tage_25, d1_.kreditlimit AS kreditlimit_26, d1_.mahnverfahren AS mahnverfahren_27, d1_.sepa_mandat AS sepa_mandat_28, d1_.e_rechnungs_format AS e_rechnungs_format_29, d1_.leitweg_id AS leitweg_id_30, d1_.e_rechnungs_email AS e_rechnungs_email_31, d1_.erstellt_am AS erstellt_am_32, d1_.aktualisiert_am AS aktualisiert_am_33, k2_.id AS id_34, k2_.kreditor_nummer AS kreditor_nummer_35, k2_.zahlungsziel_tage AS zahlungsziel_tage_36, k2_.skonto_prozent AS skonto_prozent_37, k2_.skonto_tage AS skonto_tage_38, k2_.incoterm AS incoterm_39, k2_.selbstabrechnung AS selbstabrechnung_40, k2_.erstellt_am AS erstellt_am_41, k2_.aktualisiert_am AS aktualisiert_am_42, g0_.rechtsform_id AS rechtsform_id_43, g0_.vk_preisliste_id AS vk_preisliste_id_44, d1_.geschaeftspartner_id AS geschaeftspartner_id_45, k2_.geschaeftspartner_id AS geschaeftspartner_id_46 FROM geschaeftspartner g0_ LEFT JOIN debitor_details d1_ ON g0_.id = d1_.geschaeftspartner_id LEFT JOIN kreditor_details k2_ ON g0_.id = k2_.geschaeftspartner_id ORDER BY g0_.firma ASC LIMIT 20;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  geschaeftspartner g0_

SELECT COUNT(g0_.id) AS sclr_0 FROM geschaeftspartner g0_;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  geschaeftspartner g0_
WHERE
  g0_.ist_aktiv = ?

SELECT COUNT(g0_.id) AS sclr_0 FROM geschaeftspartner g0_ WHERE g0_.ist_aktiv = 1;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  geschaeftspartner g0_
  INNER JOIN debitor_details d1_ ON g0_.id = d1_.geschaeftspartner_id

SELECT COUNT(g0_.id) AS sclr_0 FROM geschaeftspartner g0_ INNER JOIN debitor_details d1_ ON g0_.id = d1_.geschaeftspartner_id;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  geschaeftspartner g0_
  INNER JOIN kreditor_details k1_ ON g0_.id = k1_.geschaeftspartner_id

SELECT COUNT(g0_.id) AS sclr_0 FROM geschaeftspartner g0_ INNER JOIN kreditor_details k1_ ON g0_.id = k1_.geschaeftspartner_id;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  geschaeftspartner g0_
  INNER JOIN debitor_details d1_ ON g0_.id = d1_.geschaeftspartner_id
  INNER JOIN kreditor_details k2_ ON g0_.id = k2_.geschaeftspartner_id

SELECT COUNT(g0_.id) AS sclr_0 FROM geschaeftspartner g0_ INNER JOIN debitor_details d1_ ON g0_.id = d1_.geschaeftspartner_id INNER JOIN kreditor_details k2_ ON g0_.id = k2_.geschaeftspartner_id;

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 = ?

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 = 0x019C90462A4B7C6089C81CA1672AF1D1;

SELECT
  letzter_heartbeat,
  status
FROM
  worker_heartbeat
WHERE
  worker_name = ?
LIMIT
  1

SELECT letzter_heartbeat, status
                FROM worker_heartbeat
                WHERE worker_name = 'abrechnung'
                LIMIT 1;

SELECT
  COUNT(*) AS anzahl
FROM
  messenger_messages
WHERE
  queue_name = ?

SELECT COUNT(*) AS anzahl
                FROM messenger_messages
                WHERE queue_name = 'failed';

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
  )

SELECT COUNT(*) AS anzahl, MIN(created_at) AS aelteste
                FROM messenger_messages
                WHERE queue_name = 'abrechnung'
                  AND delivered_at IS NULL
                  AND created_at < DATE_SUB(NOW(), INTERVAL 10 MINUTE);

SELECT
  COUNT(*) AS anzahl,
  MIN(erstellt_am) AS aelteste
FROM
  abrechnungs_lauf
WHERE
  status IN (?, ?)
  AND erstellt_am < DATE_SUB(
    NOW(),
    INTERVAL ? MINUTE
  )

SELECT COUNT(*) AS anzahl, MIN(erstellt_am) AS aelteste
                FROM abrechnungs_lauf
                WHERE status IN ('gestartet', 'verarbeitet')
                  AND erstellt_am < DATE_SUB(NOW(), INTERVAL 10 MINUTE);

SELECT
  t0.id AS id_1,
  t0.anrede AS anrede_2,
  t0.titel AS titel_3,
  t0.vorname AS vorname_4,
  t0.nachname AS nachname_5,
  t0.position AS position_6,
  t0.telefon AS telefon_7,
  t0.mobiltelefon AS mobiltelefon_8,
  t0.email AS email_9,
  t0.ist_hauptkontakt AS ist_hauptkontakt_10,
  t0.erstellt_am AS erstellt_am_11,
  t0.aktualisiert_am AS aktualisiert_am_12,
  t0.rechtliche_rolle_id AS rechtliche_rolle_id_13,
  t0.abteilung_id AS abteilung_id_14,
  t0.geschaeftspartner_id AS geschaeftspartner_id_15
FROM
  geschaeftspartner_ansprechpartner t0
WHERE
  t0.geschaeftspartner_id = ?

SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.titel AS titel_3, t0.vorname AS vorname_4, t0.nachname AS nachname_5, t0.position AS position_6, t0.telefon AS telefon_7, t0.mobiltelefon AS mobiltelefon_8, t0.email AS email_9, t0.ist_hauptkontakt AS ist_hauptkontakt_10, t0.erstellt_am AS erstellt_am_11, t0.aktualisiert_am AS aktualisiert_am_12, t0.rechtliche_rolle_id AS rechtliche_rolle_id_13, t0.abteilung_id AS abteilung_id_14, t0.geschaeftspartner_id AS geschaeftspartner_id_15 FROM geschaeftspartner_ansprechpartner t0 WHERE t0.geschaeftspartner_id = 0x019CC8F6FE467CD1A6E636AD2F2A05F3;

SELECT
  t0.id AS id_1,
  t0.anrede AS anrede_2,
  t0.titel AS titel_3,
  t0.vorname AS vorname_4,
  t0.nachname AS nachname_5,
  t0.position AS position_6,
  t0.telefon AS telefon_7,
  t0.mobiltelefon AS mobiltelefon_8,
  t0.email AS email_9,
  t0.ist_hauptkontakt AS ist_hauptkontakt_10,
  t0.erstellt_am AS erstellt_am_11,
  t0.aktualisiert_am AS aktualisiert_am_12,
  t0.rechtliche_rolle_id AS rechtliche_rolle_id_13,
  t0.abteilung_id AS abteilung_id_14,
  t0.geschaeftspartner_id AS geschaeftspartner_id_15
FROM
  geschaeftspartner_ansprechpartner t0
WHERE
  t0.geschaeftspartner_id = ?

SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.titel AS titel_3, t0.vorname AS vorname_4, t0.nachname AS nachname_5, t0.position AS position_6, t0.telefon AS telefon_7, t0.mobiltelefon AS mobiltelefon_8, t0.email AS email_9, t0.ist_hauptkontakt AS ist_hauptkontakt_10, t0.erstellt_am AS erstellt_am_11, t0.aktualisiert_am AS aktualisiert_am_12, t0.rechtliche_rolle_id AS rechtliche_rolle_id_13, t0.abteilung_id AS abteilung_id_14, t0.geschaeftspartner_id AS geschaeftspartner_id_15 FROM geschaeftspartner_ansprechpartner t0 WHERE t0.geschaeftspartner_id = 0x019CC5094C8374F790C9B68C8725DDB6;

SELECT
  t0.id AS id_1,
  t0.anrede AS anrede_2,
  t0.titel AS titel_3,
  t0.vorname AS vorname_4,
  t0.nachname AS nachname_5,
  t0.position AS position_6,
  t0.telefon AS telefon_7,
  t0.mobiltelefon AS mobiltelefon_8,
  t0.email AS email_9,
  t0.ist_hauptkontakt AS ist_hauptkontakt_10,
  t0.erstellt_am AS erstellt_am_11,
  t0.aktualisiert_am AS aktualisiert_am_12,
  t0.rechtliche_rolle_id AS rechtliche_rolle_id_13,
  t0.abteilung_id AS abteilung_id_14,
  t0.geschaeftspartner_id AS geschaeftspartner_id_15
FROM
  geschaeftspartner_ansprechpartner t0
WHERE
  t0.geschaeftspartner_id = ?

SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.titel AS titel_3, t0.vorname AS vorname_4, t0.nachname AS nachname_5, t0.position AS position_6, t0.telefon AS telefon_7, t0.mobiltelefon AS mobiltelefon_8, t0.email AS email_9, t0.ist_hauptkontakt AS ist_hauptkontakt_10, t0.erstellt_am AS erstellt_am_11, t0.aktualisiert_am AS aktualisiert_am_12, t0.rechtliche_rolle_id AS rechtliche_rolle_id_13, t0.abteilung_id AS abteilung_id_14, t0.geschaeftspartner_id AS geschaeftspartner_id_15 FROM geschaeftspartner_ansprechpartner t0 WHERE t0.geschaeftspartner_id = 0x019CC8F6FE2073A7BF6EA7EBA2F06D74;

SELECT
  t0.id AS id_1,
  t0.anrede AS anrede_2,
  t0.titel AS titel_3,
  t0.vorname AS vorname_4,
  t0.nachname AS nachname_5,
  t0.position AS position_6,
  t0.telefon AS telefon_7,
  t0.mobiltelefon AS mobiltelefon_8,
  t0.email AS email_9,
  t0.ist_hauptkontakt AS ist_hauptkontakt_10,
  t0.erstellt_am AS erstellt_am_11,
  t0.aktualisiert_am AS aktualisiert_am_12,
  t0.rechtliche_rolle_id AS rechtliche_rolle_id_13,
  t0.abteilung_id AS abteilung_id_14,
  t0.geschaeftspartner_id AS geschaeftspartner_id_15
FROM
  geschaeftspartner_ansprechpartner t0
WHERE
  t0.geschaeftspartner_id = ?

SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.titel AS titel_3, t0.vorname AS vorname_4, t0.nachname AS nachname_5, t0.position AS position_6, t0.telefon AS telefon_7, t0.mobiltelefon AS mobiltelefon_8, t0.email AS email_9, t0.ist_hauptkontakt AS ist_hauptkontakt_10, t0.erstellt_am AS erstellt_am_11, t0.aktualisiert_am AS aktualisiert_am_12, t0.rechtliche_rolle_id AS rechtliche_rolle_id_13, t0.abteilung_id AS abteilung_id_14, t0.geschaeftspartner_id AS geschaeftspartner_id_15 FROM geschaeftspartner_ansprechpartner t0 WHERE t0.geschaeftspartner_id = 0x019CC92B24DF7746BBE3F0C2F23E6EEB;

SELECT
  t0.id AS id_1,
  t0.anrede AS anrede_2,
  t0.titel AS titel_3,
  t0.vorname AS vorname_4,
  t0.nachname AS nachname_5,
  t0.position AS position_6,
  t0.telefon AS telefon_7,
  t0.mobiltelefon AS mobiltelefon_8,
  t0.email AS email_9,
  t0.ist_hauptkontakt AS ist_hauptkontakt_10,
  t0.erstellt_am AS erstellt_am_11,
  t0.aktualisiert_am AS aktualisiert_am_12,
  t0.rechtliche_rolle_id AS rechtliche_rolle_id_13,
  t0.abteilung_id AS abteilung_id_14,
  t0.geschaeftspartner_id AS geschaeftspartner_id_15
FROM
  geschaeftspartner_ansprechpartner t0
WHERE
  t0.geschaeftspartner_id = ?

SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.titel AS titel_3, t0.vorname AS vorname_4, t0.nachname AS nachname_5, t0.position AS position_6, t0.telefon AS telefon_7, t0.mobiltelefon AS mobiltelefon_8, t0.email AS email_9, t0.ist_hauptkontakt AS ist_hauptkontakt_10, t0.erstellt_am AS erstellt_am_11, t0.aktualisiert_am AS aktualisiert_am_12, t0.rechtliche_rolle_id AS rechtliche_rolle_id_13, t0.abteilung_id AS abteilung_id_14, t0.geschaeftspartner_id AS geschaeftspartner_id_15 FROM geschaeftspartner_ansprechpartner t0 WHERE t0.geschaeftspartner_id = 0x019CC8F6FE3173A799C5F8ACA3FDCEA7;

SELECT
  t0.id AS id_1,
  t0.anrede AS anrede_2,
  t0.titel AS titel_3,
  t0.vorname AS vorname_4,
  t0.nachname AS nachname_5,
  t0.position AS position_6,
  t0.telefon AS telefon_7,
  t0.mobiltelefon AS mobiltelefon_8,
  t0.email AS email_9,
  t0.ist_hauptkontakt AS ist_hauptkontakt_10,
  t0.erstellt_am AS erstellt_am_11,
  t0.aktualisiert_am AS aktualisiert_am_12,
  t0.rechtliche_rolle_id AS rechtliche_rolle_id_13,
  t0.abteilung_id AS abteilung_id_14,
  t0.geschaeftspartner_id AS geschaeftspartner_id_15
FROM
  geschaeftspartner_ansprechpartner t0
WHERE
  t0.geschaeftspartner_id = ?

SELECT t0.id AS id_1, t0.anrede AS anrede_2, t0.titel AS titel_3, t0.vorname AS vorname_4, t0.nachname AS nachname_5, t0.position AS position_6, t0.telefon AS telefon_7, t0.mobiltelefon AS mobiltelefon_8, t0.email AS email_9, t0.ist_hauptkontakt AS ist_hauptkontakt_10, t0.erstellt_am AS erstellt_am_11, t0.aktualisiert_am AS aktualisiert_am_12, t0.rechtliche_rolle_id AS rechtliche_rolle_id_13, t0.abteilung_id AS abteilung_id_14, t0.geschaeftspartner_id AS geschaeftspartner_id_15 FROM geschaeftspartner_ansprechpartner t0 WHERE t0.geschaeftspartner_id = 0x019CC8F6FE3D7575A33D3A65DC826532;