Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.74 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.67 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.vorname AS vorname_5, t0.nachname AS nachname_6, t0.telefon AS telefon_7, t0.position AS position_8, t0.avatar_pfad AS avatar_pfad_9, t0.aktiv AS aktiv_10, t0.email_bestaetigt AS email_bestaetigt_11, t0.letzter_login AS letzter_login_12, t0.sprache AS sprache_13, t0.zeitzone AS zeitzone_14, t0.einstellungen AS einstellungen_15, t0.erstellt_am AS erstellt_am_16, t0.aktualisiert_am AS aktualisiert_am_17, t0.mandant_id AS mandant_id_18, t19.id AS id_20, t19.name AS name_21, t19.subdomain AS subdomain_22, t19.aktiv AS aktiv_23, t19.speicher_limit_mb AS speicher_limit_mb_24, t19.benutzer_limit AS benutzer_limit_25, t19.einstellungen AS einstellungen_26, t19.erstellt_am AS erstellt_am_27, t19.aktualisiert_am AS aktualisiert_am_28 FROM benutzer t0 LEFT JOIN mandant t19 ON t0.mandant_id = t19.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.vorname AS vorname_5,
  t0.nachname AS nachname_6,
  t0.telefon AS telefon_7,
  t0.position AS position_8,
  t0.avatar_pfad AS avatar_pfad_9,
  t0.aktiv AS aktiv_10,
  t0.email_bestaetigt AS email_bestaetigt_11,
  t0.letzter_login AS letzter_login_12,
  t0.sprache AS sprache_13,
  t0.zeitzone AS zeitzone_14,
  t0.einstellungen AS einstellungen_15,
  t0.erstellt_am AS erstellt_am_16,
  t0.aktualisiert_am AS aktualisiert_am_17,
  t0.mandant_id AS mandant_id_18,
  t19.id AS id_20,
  t19.name AS name_21,
  t19.subdomain AS subdomain_22,
  t19.aktiv AS aktiv_23,
  t19.speicher_limit_mb AS speicher_limit_mb_24,
  t19.benutzer_limit AS benutzer_limit_25,
  t19.einstellungen AS einstellungen_26,
  t19.erstellt_am AS erstellt_am_27,
  t19.aktualisiert_am AS aktualisiert_am_28
FROM
  benutzer t0
  LEFT JOIN mandant t19 ON t0.mandant_id = t19.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.vorname AS vorname_5, t0.nachname AS nachname_6, t0.telefon AS telefon_7, t0.position AS position_8, t0.avatar_pfad AS avatar_pfad_9, t0.aktiv AS aktiv_10, t0.email_bestaetigt AS email_bestaetigt_11, t0.letzter_login AS letzter_login_12, t0.sprache AS sprache_13, t0.zeitzone AS zeitzone_14, t0.einstellungen AS einstellungen_15, t0.erstellt_am AS erstellt_am_16, t0.aktualisiert_am AS aktualisiert_am_17, t0.mandant_id AS mandant_id_18, t19.id AS id_20, t19.name AS name_21, t19.subdomain AS subdomain_22, t19.aktiv AS aktiv_23, t19.speicher_limit_mb AS speicher_limit_mb_24, t19.benutzer_limit AS benutzer_limit_25, t19.einstellungen AS einstellungen_26, t19.erstellt_am AS erstellt_am_27, t19.aktualisiert_am AS aktualisiert_am_28 FROM benutzer t0 LEFT JOIN mandant t19 ON t0.mandant_id = t19.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 74)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Bundle\SecurityBundle\Security->getToken (line 68)
14	Symfony\Bundle\SecurityBundle\Security->getUser (line 50)
15	App\EventSubscriber\MandantFilterSubscriber->onKernelRequest (line 37)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.07 ms

SELECT t0_.id AS id_0, t0_.titel AS titel_1, t0_.beschreibung AS beschreibung_2, t0_.ort AS ort_3, t0_.typ AS typ_4, t0_.start_zeit AS start_zeit_5, t0_.ende_zeit AS ende_zeit_6, t0_.ganztaegig AS ganztaegig_7, t0_.zeitzone AS zeitzone_8, t0_.wiederholung AS wiederholung_9, t0_.wiederholung_intervall AS wiederholung_intervall_10, t0_.wiederholung_bis AS wiederholung_bis_11, t0_.farbe AS farbe_12, t0_.erinnerung_minuten AS erinnerung_minuten_13, t0_.teilnehmer AS teilnehmer_14, t0_.metadaten AS metadaten_15, t0_.ist_hard_timebox AS ist_hard_timebox_16, t0_.timebox_ergebnis AS timebox_ergebnis_17, t0_.timebox_gestartet_am AS timebox_gestartet_am_18, t0_.timebox_beendet_am AS timebox_beendet_am_19, t0_.timebox_tatsaechliche_dauer AS timebox_tatsaechliche_dauer_20, t0_.timebox_puffer AS timebox_puffer_21, t0_.erstellt_am AS erstellt_am_22, t0_.aktualisiert_am AS aktualisiert_am_23, t0_.mandant_id AS mandant_id_24, t0_.aufgabe_id AS aufgabe_id_25, t0_.erstellt_von_id AS erstellt_von_id_26, t0_.ursprungs_termin_id AS ursprungs_termin_id_27 FROM termin t0_ WHERE t0_.mandant_id = ? AND t0_.erstellt_von_id = ? AND t0_.typ = ? AND t0_.timebox_gestartet_am IS NOT NULL AND t0_.timebox_beendet_am IS NULL LIMIT 1

Parameters:

[
  b"\x01›qY>€uÆ›vV\x16\x7Fmx"
  1
  "timebox"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.titel AS titel_1,
  t0_.beschreibung AS beschreibung_2,
  t0_.ort AS ort_3,
  t0_.typ AS typ_4,
  t0_.start_zeit AS start_zeit_5,
  t0_.ende_zeit AS ende_zeit_6,
  t0_.ganztaegig AS ganztaegig_7,
  t0_.zeitzone AS zeitzone_8,
  t0_.wiederholung AS wiederholung_9,
  t0_.wiederholung_intervall AS wiederholung_intervall_10,
  t0_.wiederholung_bis AS wiederholung_bis_11,
  t0_.farbe AS farbe_12,
  t0_.erinnerung_minuten AS erinnerung_minuten_13,
  t0_.teilnehmer AS teilnehmer_14,
  t0_.metadaten AS metadaten_15,
  t0_.ist_hard_timebox AS ist_hard_timebox_16,
  t0_.timebox_ergebnis AS timebox_ergebnis_17,
  t0_.timebox_gestartet_am AS timebox_gestartet_am_18,
  t0_.timebox_beendet_am AS timebox_beendet_am_19,
  t0_.timebox_tatsaechliche_dauer AS timebox_tatsaechliche_dauer_20,
  t0_.timebox_puffer AS timebox_puffer_21,
  t0_.erstellt_am AS erstellt_am_22,
  t0_.aktualisiert_am AS aktualisiert_am_23,
  t0_.mandant_id AS mandant_id_24,
  t0_.aufgabe_id AS aufgabe_id_25,
  t0_.erstellt_von_id AS erstellt_von_id_26,
  t0_.ursprungs_termin_id AS ursprungs_termin_id_27
FROM
  termin t0_
WHERE
  t0_.mandant_id = ?
  AND t0_.erstellt_von_id = ?
  AND t0_.typ = ?
  AND t0_.timebox_gestartet_am IS NOT NULL
  AND t0_.timebox_beendet_am IS NULL
LIMIT
  1

SELECT t0_.id AS id_0, t0_.titel AS titel_1, t0_.beschreibung AS beschreibung_2, t0_.ort AS ort_3, t0_.typ AS typ_4, t0_.start_zeit AS start_zeit_5, t0_.ende_zeit AS ende_zeit_6, t0_.ganztaegig AS ganztaegig_7, t0_.zeitzone AS zeitzone_8, t0_.wiederholung AS wiederholung_9, t0_.wiederholung_intervall AS wiederholung_intervall_10, t0_.wiederholung_bis AS wiederholung_bis_11, t0_.farbe AS farbe_12, t0_.erinnerung_minuten AS erinnerung_minuten_13, t0_.teilnehmer AS teilnehmer_14, t0_.metadaten AS metadaten_15, t0_.ist_hard_timebox AS ist_hard_timebox_16, t0_.timebox_ergebnis AS timebox_ergebnis_17, t0_.timebox_gestartet_am AS timebox_gestartet_am_18, t0_.timebox_beendet_am AS timebox_beendet_am_19, t0_.timebox_tatsaechliche_dauer AS timebox_tatsaechliche_dauer_20, t0_.timebox_puffer AS timebox_puffer_21, t0_.erstellt_am AS erstellt_am_22, t0_.aktualisiert_am AS aktualisiert_am_23, t0_.mandant_id AS mandant_id_24, t0_.aufgabe_id AS aufgabe_id_25, t0_.erstellt_von_id AS erstellt_von_id_26, t0_.ursprungs_termin_id AS ursprungs_termin_id_27 FROM termin t0_ WHERE t0_.mandant_id = 0x019B71593E8075C69B765616907F6D78 AND t0_.erstellt_von_id = 1 AND t0_.typ = 'timebox' AND t0_.timebox_gestartet_am IS NOT NULL AND t0_.timebox_beendet_am IS NULL LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\TerminRepository->findAktivenTimebox (line 312)
7	App\Service\TimeboxingService->getAktiverTimebox (line 248)
8	App\Controller\Api\TimeboxApiController->aktiv (line 48)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Benutzer	1
App\Entity\Mandant	1

Entities Mapping

Class	Mapping errors
App\Entity\Benutzer	No errors.
App\Entity\Mandant	No errors.
App\Entity\Berechtigung	No errors.
App\Entity\BenutzerGruppe	No errors.
App\Entity\BenutzerRolle	No errors.
App\Entity\BenutzerMandant	No errors.
App\Entity\BenutzerRecht	No errors.
App\Entity\Ordner	No errors.
App\Entity\Dokument	No errors.
App\Entity\Schlagwort	No errors.
App\Entity\Termin	No errors.
App\Entity\Aufgabe	No errors.

Symfony Profiler

GET https://dms.flex-systeme.de/api/timebox/aktiv

Configuration Settings

Theme

Page Width