Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.14 ms Query time

0 Invalid entities

64 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.11 ms
(83.20%)

SELECT empfaenger FROM kosten GROUP BY empfaenger ORDER BY empfaenger

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  empfaenger
FROM
  kosten
GROUP BY
  empfaenger
ORDER BY
  empfaenger

SELECT empfaenger FROM kosten GROUP BY empfaenger ORDER BY empfaenger;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 224)
2	App\Controller\KostenController->new (line 261)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 197)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

0.56 ms
(9.14%)

SELECT s0_.id AS id_0, s0_.kontotyp_fk_id AS kontotyp_fk_id_1, s0_.aaknr_fk_id AS aaknr_fk_id_2, s0_.knr AS knr_3, s0_.knrbezeichnung AS knrbezeichnung_4, s0_.bgr AS bgr_5, s0_.anfangsbestand AS anfangsbestand_6, s0_.fa_anfangsbestand AS fa_anfangsbestand_7, s0_.datum_ab AS datum_ab_8, s0_.kommissionsruecklage AS kommissionsruecklage_9, s0_.in_bwa AS in_bwa_10, s0_.budgetgruppe AS budgetgruppe_11, s0_.kontotyp_fk_id AS kontotyp_fk_id_12, s0_.aaknr_fk_id AS aaknr_fk_id_13 FROM sdkontenrahmen s0_ ORDER BY s0_.knr ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.kontotyp_fk_id AS kontotyp_fk_id_1,
  s0_.aaknr_fk_id AS aaknr_fk_id_2,
  s0_.knr AS knr_3,
  s0_.knrbezeichnung AS knrbezeichnung_4,
  s0_.bgr AS bgr_5,
  s0_.anfangsbestand AS anfangsbestand_6,
  s0_.fa_anfangsbestand AS fa_anfangsbestand_7,
  s0_.datum_ab AS datum_ab_8,
  s0_.kommissionsruecklage AS kommissionsruecklage_9,
  s0_.in_bwa AS in_bwa_10,
  s0_.budgetgruppe AS budgetgruppe_11,
  s0_.kontotyp_fk_id AS kontotyp_fk_id_12,
  s0_.aaknr_fk_id AS aaknr_fk_id_13
FROM
  sdkontenrahmen s0_
ORDER BY
  s0_.knr ASC

SELECT s0_.id AS id_0, s0_.kontotyp_fk_id AS kontotyp_fk_id_1, s0_.aaknr_fk_id AS aaknr_fk_id_2, s0_.knr AS knr_3, s0_.knrbezeichnung AS knrbezeichnung_4, s0_.bgr AS bgr_5, s0_.anfangsbestand AS anfangsbestand_6, s0_.fa_anfangsbestand AS fa_anfangsbestand_7, s0_.datum_ab AS datum_ab_8, s0_.kommissionsruecklage AS kommissionsruecklage_9, s0_.in_bwa AS in_bwa_10, s0_.budgetgruppe AS budgetgruppe_11, s0_.kontotyp_fk_id AS kontotyp_fk_id_12, s0_.aaknr_fk_id AS aaknr_fk_id_13 FROM sdkontenrahmen s0_ ORDER BY s0_.knr ASC;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 208)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 238)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 116)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 114)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
18	Symfony\Component\Form\Form->createView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	App\Controller\KostenController->new (line 267)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 197)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.47 ms
(7.66%)

SELECT s0_.id AS id_0, s0_.mwstkz AS mwstkz_1, s0_.mwstsatz AS mwstsatz_2, s0_.land AS land_3 FROM sdmwst_saetze s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.mwstkz AS mwstkz_1,
  s0_.mwstsatz AS mwstsatz_2,
  s0_.land AS land_3
FROM
  sdmwst_saetze s0_

SELECT s0_.id AS id_0, s0_.mwstkz AS mwstkz_1, s0_.mwstsatz AS mwstsatz_2, s0_.land AS land_3 FROM sdmwst_saetze s0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 208)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 467)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 238)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 116)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 114)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 87)
18	Symfony\Component\Form\Form->createView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	App\Controller\KostenController->new (line 267)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 197)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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\SDKontenrahmen	44
App\Entity\SDKontenrahmenArbeitsamt	10
App\Entity\SDMwstSaetze	7
App\Entity\SDKontotypen	3

Entities Mapping

Class	Mapping errors
App\Entity\Kosten	No errors.
App\Entity\SDMwstSaetze	No errors.
App\Entity\SDKontenrahmen	No errors.
App\Entity\SDKontotypen	No errors.
App\Entity\SDKontenrahmenArbeitsamt	No errors.

Symfony Profiler

GET https://www.textilwork.com/kosten/new/-/-/-/bnrab/20561

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping