Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.berechnungs_art AS berechnungs_art_3,
  t0.wert AS wert_4,
  t0.bezugs_groesse AS bezugs_groesse_5,
  t0.pauschalen_bezug AS pauschalen_bezug_6,
  t0.schwelle AS schwelle_7,
  t0.mindest_wert AS mindest_wert_8,
  t0.maximal_wert AS maximal_wert_9,
  t0.zeit_von AS zeit_von_10,
  t0.zeit_bis AS zeit_bis_11,
  t0.wochentage AS wochentage_12,
  t0.sortierung AS sortierung_13,
  t0.erstellt_am AS erstellt_am_14,
  t0.partner_kondition_id AS partner_kondition_id_15
FROM
  konditions_komponente t0
WHERE
  t0.partner_kondition_id = ?
ORDER BY
  t0.sortierung ASC

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.berechnungs_art AS berechnungs_art_3, t0.wert AS wert_4, t0.bezugs_groesse AS bezugs_groesse_5, t0.pauschalen_bezug AS pauschalen_bezug_6, t0.schwelle AS schwelle_7, t0.mindest_wert AS mindest_wert_8, t0.maximal_wert AS maximal_wert_9, t0.zeit_von AS zeit_von_10, t0.zeit_bis AS zeit_bis_11, t0.wochentage AS wochentage_12, t0.sortierung AS sortierung_13, t0.erstellt_am AS erstellt_am_14, t0.partner_kondition_id AS partner_kondition_id_15 FROM konditions_komponente t0 WHERE t0.partner_kondition_id = 0xD3CC6F0D1A5411F18AFDE20F6CABFCE3 ORDER BY t0.sortierung ASC;

SELECT
  p0_.id AS id_0,
  p0_.richtung AS richtung_1,
  p0_.saeulen_typ AS saeulen_typ_2,
  p0_.bezeichnung AS bezeichnung_3,
  p0_.mindest_preis AS mindest_preis_4,
  p0_.gueltig_von AS gueltig_von_5,
  p0_.gueltig_bis AS gueltig_bis_6,
  p0_.stopp_zeit_minuten AS stopp_zeit_minuten_7,
  p0_.ruest_zeit_minuten AS ruest_zeit_minuten_8,
  p0_.ist_aktiv AS ist_aktiv_9,
  p0_.zuschlag_verhalten AS zuschlag_verhalten_10,
  p0_.diesel_basis_preis AS diesel_basis_preis_11,
  p0_.diesel_durchschnitt_km AS diesel_durchschnitt_km_12,
  p0_.diesel_verbrauch_l_100km AS diesel_verbrauch_l_100km_13,
  p0_.diesel_durchschnitt_umsatz AS diesel_durchschnitt_umsatz_14,
  p0_.erstellt_am AS erstellt_am_15,
  p0_.aktualisiert_am AS aktualisiert_am_16,
  g1_.id AS id_17,
  g1_.partner_nummer AS partner_nummer_18,
  g1_.typ AS typ_19,
  g1_.firma AS firma_20,
  g1_.steuernummer AS steuernummer_21,
  g1_.ust_id_nr AS ust_id_nr_22,
  g1_.handelsregister_nr AS handelsregister_nr_23,
  g1_.ist_aktiv AS ist_aktiv_24,
  g1_.erstellt_am AS erstellt_am_25,
  g1_.aktualisiert_am AS aktualisiert_am_26,
  g1_.preis_modell AS preis_modell_27,
  g1_.diesel_verhalten AS diesel_verhalten_28,
  g1_.maut_verhalten AS maut_verhalten_29,
  g1_.carrier_strategie AS carrier_strategie_30,
  g1_.bevorzugte_carrier AS bevorzugte_carrier_31,
  g1_.carrier_volumen_ziele AS carrier_volumen_ziele_32,
  g1_.hat_verrechnungsvereinbarung AS hat_verrechnungsvereinbarung_33,
  g1_.hat_gutschriftverfahren AS hat_gutschriftverfahren_34,
  g1_.ist_oeffentlich_rechtlich AS ist_oeffentlich_rechtlich_35,
  g1_.verrechnungsvereinbarung_datum AS verrechnungsvereinbarung_datum_36,
  g1_.verrechnungsvereinbarung_referenz AS verrechnungsvereinbarung_referenz_37,
  p0_.geschaeftspartner_id AS geschaeftspartner_id_38,
  p0_.fahrzeug_klasse_id AS fahrzeug_klasse_id_39,
  p0_.dieselpreis_referenz_id AS dieselpreis_referenz_id_40,
  p0_.erstellt_von_id AS erstellt_von_id_41,
  g1_.rechtsform_id AS rechtsform_id_42,
  g1_.vk_preisliste_id AS vk_preisliste_id_43
FROM
  partner_kondition p0_
  INNER JOIN geschaeftspartner g1_ ON p0_.geschaeftspartner_id = g1_.id
WHERE
  p0_.ist_aktiv = ?
ORDER BY
  g1_.firma ASC,
  p0_.richtung ASC,
  p0_.saeulen_typ ASC,
  p0_.bezeichnung ASC

SELECT p0_.id AS id_0, p0_.richtung AS richtung_1, p0_.saeulen_typ AS saeulen_typ_2, p0_.bezeichnung AS bezeichnung_3, p0_.mindest_preis AS mindest_preis_4, p0_.gueltig_von AS gueltig_von_5, p0_.gueltig_bis AS gueltig_bis_6, p0_.stopp_zeit_minuten AS stopp_zeit_minuten_7, p0_.ruest_zeit_minuten AS ruest_zeit_minuten_8, p0_.ist_aktiv AS ist_aktiv_9, p0_.zuschlag_verhalten AS zuschlag_verhalten_10, p0_.diesel_basis_preis AS diesel_basis_preis_11, p0_.diesel_durchschnitt_km AS diesel_durchschnitt_km_12, p0_.diesel_verbrauch_l_100km AS diesel_verbrauch_l_100km_13, p0_.diesel_durchschnitt_umsatz AS diesel_durchschnitt_umsatz_14, p0_.erstellt_am AS erstellt_am_15, p0_.aktualisiert_am AS aktualisiert_am_16, g1_.id AS id_17, g1_.partner_nummer AS partner_nummer_18, g1_.typ AS typ_19, g1_.firma AS firma_20, g1_.steuernummer AS steuernummer_21, g1_.ust_id_nr AS ust_id_nr_22, g1_.handelsregister_nr AS handelsregister_nr_23, g1_.ist_aktiv AS ist_aktiv_24, g1_.erstellt_am AS erstellt_am_25, g1_.aktualisiert_am AS aktualisiert_am_26, g1_.preis_modell AS preis_modell_27, g1_.diesel_verhalten AS diesel_verhalten_28, g1_.maut_verhalten AS maut_verhalten_29, g1_.carrier_strategie AS carrier_strategie_30, g1_.bevorzugte_carrier AS bevorzugte_carrier_31, g1_.carrier_volumen_ziele AS carrier_volumen_ziele_32, g1_.hat_verrechnungsvereinbarung AS hat_verrechnungsvereinbarung_33, g1_.hat_gutschriftverfahren AS hat_gutschriftverfahren_34, g1_.ist_oeffentlich_rechtlich AS ist_oeffentlich_rechtlich_35, g1_.verrechnungsvereinbarung_datum AS verrechnungsvereinbarung_datum_36, g1_.verrechnungsvereinbarung_referenz AS verrechnungsvereinbarung_referenz_37, p0_.geschaeftspartner_id AS geschaeftspartner_id_38, p0_.fahrzeug_klasse_id AS fahrzeug_klasse_id_39, p0_.dieselpreis_referenz_id AS dieselpreis_referenz_id_40, p0_.erstellt_von_id AS erstellt_von_id_41, g1_.rechtsform_id AS rechtsform_id_42, g1_.vk_preisliste_id AS vk_preisliste_id_43 FROM partner_kondition p0_ INNER JOIN geschaeftspartner g1_ ON p0_.geschaeftspartner_id = g1_.id WHERE p0_.ist_aktiv = 1 ORDER BY g1_.firma ASC, p0_.richtung ASC, p0_.saeulen_typ ASC, p0_.bezeichnung ASC;

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.firma AS firma_1
FROM
  partner_kondition p1_
  INNER JOIN geschaeftspartner g0_ ON p1_.geschaeftspartner_id = g0_.id
ORDER BY
  g0_.firma ASC

SELECT DISTINCT g0_.id AS id_0, g0_.firma AS firma_1 FROM partner_kondition p1_ INNER JOIN geschaeftspartner g0_ ON p1_.geschaeftspartner_id = g0_.id ORDER BY g0_.firma ASC;

SELECT
  f0_.id AS id_0,
  f0_.code AS code_1,
  f0_.bezeichnung AS bezeichnung_2,
  f0_.badge_klasse AS badge_klasse_3,
  f0_.sortierung AS sortierung_4,
  f0_.ist_aktiv AS ist_aktiv_5,
  f0_.erstellt_am AS erstellt_am_6,
  f0_.aktualisiert_am AS aktualisiert_am_7,
  f0_.mindest_fuehrerscheinklasse_id AS mindest_fuehrerscheinklasse_id_8,
  f0_.erstellt_von_id AS erstellt_von_id_9
FROM
  fahrzeug_klasse f0_
WHERE
  f0_.ist_aktiv = ?
ORDER BY
  f0_.sortierung ASC,
  f0_.bezeichnung ASC

SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.bezeichnung AS bezeichnung_2, f0_.badge_klasse AS badge_klasse_3, f0_.sortierung AS sortierung_4, f0_.ist_aktiv AS ist_aktiv_5, f0_.erstellt_am AS erstellt_am_6, f0_.aktualisiert_am AS aktualisiert_am_7, f0_.mindest_fuehrerscheinklasse_id AS mindest_fuehrerscheinklasse_id_8, f0_.erstellt_von_id AS erstellt_von_id_9 FROM fahrzeug_klasse f0_ WHERE f0_.ist_aktiv = 1 ORDER BY f0_.sortierung ASC, f0_.bezeichnung ASC;

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

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

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

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

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
  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,
  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
  COUNT(*) AS anzahl
FROM
  messenger_messages
WHERE
  queue_name = ?

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