Symfony Profiler

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

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 = 1 ORDER BY g0_.firma ASC;

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

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

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.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
  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

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;

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

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;

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

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