Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

17.25 ms Query time

0 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.89 ms
(57.38%)

SELECT t0.id AS id_1, t0.position_custom AS position_custom_2, t0.default_custom AS default_custom_3, t0.status_custom AS status_custom_4, t0.required_custom AS required_custom_5, t0.phase_id AS phase_id_6, t0.formtype_template_id AS formtype_template_id_7 FROM formtype t0 WHERE t0.phase_id = ?

Parameters:

[
  38
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position_custom AS position_custom_2,
  t0.default_custom AS default_custom_3,
  t0.status_custom AS status_custom_4,
  t0.required_custom AS required_custom_5,
  t0.phase_id AS phase_id_6,
  t0.formtype_template_id AS formtype_template_id_7
FROM
  formtype t0
WHERE
  t0.phase_id = ?

SELECT t0.id AS id_1, t0.position_custom AS position_custom_2, t0.default_custom AS default_custom_3, t0.status_custom AS status_custom_4, t0.required_custom AS required_custom_5, t0.phase_id AS phase_id_6, t0.formtype_template_id AS formtype_template_id_7 FROM formtype t0 WHERE t0.phase_id = 38;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->getValues (line 113)
7	App\Controller\CampaignController->showPhase (line 152)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

5.71 ms
(33.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.headline_custom AS headline_custom_4, t0.subline_custom AS subline_custom_5, t0.campaign_id AS campaign_id_6, t0.phase_template_id AS phase_template_id_7 FROM phase t0 WHERE t0.campaign_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.headline_custom AS headline_custom_4,
  t0.subline_custom AS subline_custom_5,
  t0.campaign_id AS campaign_id_6,
  t0.phase_template_id AS phase_template_id_7
FROM
  phase t0
WHERE
  t0.campaign_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.headline_custom AS headline_custom_4, t0.subline_custom AS subline_custom_5, t0.campaign_id AS campaign_id_6, t0.phase_template_id AS phase_template_id_7 FROM phase t0 WHERE t0.campaign_id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 34)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	count (line 129)
9	App\Controller\CampaignController::showPhase (line 129)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

1.07 ms
(6.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.handle AS handle_6, t0.date_end_manually AS date_end_manually_7 FROM campaign t0 WHERE t0.handle = ? LIMIT 1

Parameters:

[
  "ergotherapie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.date_start AS date_start_4,
  t0.date_end AS date_end_5,
  t0.handle AS handle_6,
  t0.date_end_manually AS date_end_manually_7
FROM
  campaign t0
WHERE
  t0.handle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.handle AS handle_6, t0.date_end_manually AS date_end_manually_7 FROM campaign t0 WHERE t0.handle = 'ergotherapie' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\CampaignController->showPhase (line 110)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.34 ms
(1.96%)

SELECT t0.id AS id_1, t0.phase_template_ids AS phase_template_ids_2, t0.position AS position_3, t0.type AS type_4, t0.name AS name_5, t0.choices AS choices_6, t0.default_value AS default_value_7, t0.status AS status_8, t0.label AS label_9, t0.required AS required_10 FROM formtype_template t0 WHERE t0.id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phase_template_ids AS phase_template_ids_2,
  t0.position AS position_3,
  t0.type AS type_4,
  t0.name AS name_5,
  t0.choices AS choices_6,
  t0.default_value AS default_value_7,
  t0.status AS status_8,
  t0.label AS label_9,
  t0.required AS required_10
FROM
  formtype_template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phase_template_ids AS phase_template_ids_2, t0.position AS position_3, t0.type AS type_4, t0.name AS name_5, t0.choices AS choices_6, t0.default_value AS default_value_7, t0.status AS status_8, t0.label AS label_9, t0.required AS required_10 FROM formtype_template t0 WHERE t0.id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\FormtypeTemplate::isStatus (line 108)
5	App\Controller\CampaignController->showPhase (line 172)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.24 ms
(1.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.headline AS headline_3, t0.subline AS subline_4 FROM phase_template t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.headline AS headline_3,
  t0.subline AS subline_4
FROM
  phase_template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.headline AS headline_3, t0.subline AS subline_4 FROM phase_template t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\PhaseTemplate::getHeadline (line 54)
5	App\Controller\CampaignController->showPhase (line 140)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	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\Phase	5
App\Entity\PhaseTemplate	5
App\Entity\Campaign	1
App\Entity\Formtype	1
App\Entity\FormtypeTemplate	1

Entities Mapping

Class	Mapping errors
App\Entity\Campaign	No errors.
App\Entity\Applicant	No errors.
App\Entity\Phase	No errors.
App\Entity\User	No errors.
App\Entity\PhaseTemplate	No errors.
App\Entity\Formtype	No errors.
App\Entity\FormtypeTemplate	No errors.
App\Entity\FormtypeValue	No errors.

GET https://bewerbung-dev.daheim.info/kampagne/ergotherapie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping