Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.name AS name_2, d0_.beschreibung AS beschreibung_3, d0_.quelle AS quelle_4, d0_.quelle_url AS quelle_url_5, d0_.aktueller_literpreis AS aktueller_literpreis_6, d0_.literpreis_gueltig_ab AS literpreis_gueltig_ab_7, d0_.ist_aktiv AS ist_aktiv_8, d0_.erstellt_am AS erstellt_am_9, d0_.aktualisiert_am AS aktualisiert_am_10 FROM dieselpreis_referenz d0_ ORDER BY d0_.name ASC

[]

SELECT
  d0_.id AS id_0,
  d0_.code AS code_1,
  d0_.name AS name_2,
  d0_.beschreibung AS beschreibung_3,
  d0_.quelle AS quelle_4,
  d0_.quelle_url AS quelle_url_5,
  d0_.aktueller_literpreis AS aktueller_literpreis_6,
  d0_.literpreis_gueltig_ab AS literpreis_gueltig_ab_7,
  d0_.ist_aktiv AS ist_aktiv_8,
  d0_.erstellt_am AS erstellt_am_9,
  d0_.aktualisiert_am AS aktualisiert_am_10
FROM
  dieselpreis_referenz d0_
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.name AS name_2, d0_.beschreibung AS beschreibung_3, d0_.quelle AS quelle_4, d0_.quelle_url AS quelle_url_5, d0_.aktueller_literpreis AS aktueller_literpreis_6, d0_.literpreis_gueltig_ab AS literpreis_gueltig_ab_7, d0_.ist_aktiv AS ist_aktiv_8, d0_.erstellt_am AS erstellt_am_9, d0_.aktualisiert_am AS aktualisiert_am_10 FROM dieselpreis_referenz d0_ ORDER BY d0_.name ASC;

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

[
  b"\x01œF*K|`‰È\x1C¡g*ñÑ"
]

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

[
  b"\x01œF*K|`‰È\x1C¡g*ñÑ"
]

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 COUNT(*) AS anzahl, MIN(erstellt_am) AS aelteste
                FROM abrechnungs_lauf
                WHERE status IN (?, ?)
                  AND erstellt_am < DATE_SUB(NOW(), INTERVAL ? MINUTE)

[
  "gestartet"
  "verarbeitet"
  10
]

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 letzter_heartbeat, status
                FROM worker_heartbeat
                WHERE worker_name = ?
                LIMIT 1

[
  "abrechnung"
]

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)

[
  "abrechnung"
  10
]

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
                FROM messenger_messages
                WHERE queue_name = ?

[
  "failed"
]

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

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