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 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 COUNT(b0_.id) AS sclr_0 FROM benutzer b0_ WHERE b0_.ist_aktiv = ?

[
  1
]

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  benutzer b0_
WHERE
  b0_.ist_aktiv = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM benutzer b0_ WHERE b0_.ist_aktiv = 1;

SELECT COUNT(r0_.id) AS sclr_0 FROM rolle r0_

[]

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  rolle r0_

SELECT COUNT(r0_.id) AS sclr_0 FROM rolle r0_;

SELECT p0_.id AS id_0, p0_.zeitstempel AS zeitstempel_1, p0_.benutzer_id AS benutzer_id_2, p0_.benutzername AS benutzername_3, p0_.ip_adresse AS ip_adresse_4, p0_.benutzer_agent AS benutzer_agent_5, p0_.aktion AS aktion_6, p0_.kategorie AS kategorie_7, p0_.schweregrad AS schweregrad_8, p0_.entitaets_typ AS entitaets_typ_9, p0_.entitaets_id AS entitaets_id_10, p0_.aenderungen AS aenderungen_11, p0_.kontext AS kontext_12, p0_.anfrage_id AS anfrage_id_13 FROM protokoll p0_ ORDER BY p0_.zeitstempel DESC LIMIT 10

[]

SELECT
  p0_.id AS id_0,
  p0_.zeitstempel AS zeitstempel_1,
  p0_.benutzer_id AS benutzer_id_2,
  p0_.benutzername AS benutzername_3,
  p0_.ip_adresse AS ip_adresse_4,
  p0_.benutzer_agent AS benutzer_agent_5,
  p0_.aktion AS aktion_6,
  p0_.kategorie AS kategorie_7,
  p0_.schweregrad AS schweregrad_8,
  p0_.entitaets_typ AS entitaets_typ_9,
  p0_.entitaets_id AS entitaets_id_10,
  p0_.aenderungen AS aenderungen_11,
  p0_.kontext AS kontext_12,
  p0_.anfrage_id AS anfrage_id_13
FROM
  protokoll p0_
ORDER BY
  p0_.zeitstempel DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.zeitstempel AS zeitstempel_1, p0_.benutzer_id AS benutzer_id_2, p0_.benutzername AS benutzername_3, p0_.ip_adresse AS ip_adresse_4, p0_.benutzer_agent AS benutzer_agent_5, p0_.aktion AS aktion_6, p0_.kategorie AS kategorie_7, p0_.schweregrad AS schweregrad_8, p0_.entitaets_typ AS entitaets_typ_9, p0_.entitaets_id AS entitaets_id_10, p0_.aenderungen AS aenderungen_11, p0_.kontext AS kontext_12, p0_.anfrage_id AS anfrage_id_13 FROM protokoll p0_ ORDER BY p0_.zeitstempel DESC LIMIT 10;

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

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, 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);