Symfony Profiler

Query Metrics

40 Database Queries

4 Different statements

5.69 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.88 ms
(85.73%)

SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?

Parameters:

[
  87
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.config AS config_2,
  t0.active AS active_3,
  t0.supplier_id AS supplier_id_4,
  t0.supplier_group_id AS supplier_group_id_5
FROM
  tariff_file_config_supplier t0
WHERE
  t0.supplier_id = ?

SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 87;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 35)
11	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
12	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
15	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
16	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
17	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
18	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
19	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
20	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
21	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
22	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
23	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
24	Symfony\Component\Form\Form->createView (line 891)
25	Symfony\Component\Form\Form->createView (line 423)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 68)
29	App\Controller\Upload\TariffUploadController->displayFormAndHandleUpload (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.36 ms
(6.27%)

SELECT t0.id AS id_1, t0.config AS config_2, t0.type AS type_3 FROM tariff_file_config_global t0 WHERE t0.type = ? LIMIT 1

Parameters:

[
  "state"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.config AS config_2,
  t0.type AS type_3
FROM
  tariff_file_config_global t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.config AS config_2, t0.type AS type_3 FROM tariff_file_config_global t0 WHERE t0.type = 'state' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 33)
7	App\FormType\TariffFileUploadFormType->buildForm (line 96)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 41)
11	Symfony\Component\Form\FormFactory->createBuilder (line 26)
12	Symfony\Component\Form\FormFactory->create (line 323)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 35)
14	App\Controller\Upload\TariffUploadController->displayFormAndHandleUpload (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.23 ms
(4.04%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.config AS config_2, t0_.active AS active_3 FROM tariff_file_config_supplier_group t0_ WHERE t0_.active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.config AS config_2,
  t0_.active AS active_3
FROM
  tariff_file_config_supplier_group t0_
WHERE
  t0_.active = 1

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.config AS config_2, t0_.active AS active_3 FROM tariff_file_config_supplier_group t0_ WHERE t0_.active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 38)
6	App\Repository\TariffFileConfigSupplierGroupRepository->getAllActiveOrderedByNameTranslated (line 55)
7	App\FormType\TariffFileUploadFormType->buildForm (line 96)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 41)
11	Symfony\Component\Form\FormFactory->createBuilder (line 26)
12	Symfony\Component\Form\FormFactory->create (line 323)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 35)
14	App\Controller\Upload\TariffUploadController->displayFormAndHandleUpload (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.23 ms
(3.96%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.dm24_id AS dm24_id_3 FROM supplier s0_ WHERE s0_.active = 1 ORDER BY s0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.active AS active_2,
  s0_.dm24_id AS dm24_id_3
FROM
  supplier s0_
WHERE
  s0_.active = 1
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.dm24_id AS dm24_id_3 FROM supplier s0_ WHERE s0_.active = 1 ORDER BY s0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 68)
24	App\Controller\Upload\TariffUploadController->displayFormAndHandleUpload (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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.

Entities Mapping

Class	Mapping errors
App\Entity\TariffFileConfigGlobal	No errors.
App\Entity\TariffFileConfigSupplierGroup	No errors.
App\Entity\Supplier	No errors.
App\Entity\Tariff	No errors.
App\Entity\TariffFileConfigSupplier	No errors.

Symfony Profiler

GET https://dm24.s3p.de/tariff/upload/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping