Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

2.39 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.32 ms
(55.34%)

SELECT t1.id AS id_2, t1.name AS name_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t1.type AS type_6, t1.slug AS slug_7, t1.published_at AS published_at_8, t1.public AS public_9, t1.template AS template_10, t0.title AS title_11, t0.subtitle AS subtitle_12, t0.description AS description_13, t0.best_for AS best_for_14, t0.duration AS duration_15, t0.needs AS needs_16, t0.benefits AS benefits_17, t0.start_at AS start_at_18, t0.end_at AS end_at_19, t0.location AS location_20, t0.price AS price_21, t0.package_type AS package_type_22, t0.participants AS participants_23, t0.learnings AS learnings_24, t0.process AS process_25, t0.inclusive AS inclusive_26, t1.author_id AS author_id_27, t0.hero_media_id AS hero_media_id_28, t0.benefits_media_id AS benefits_media_id_29, t1.discriminator FROM package_page t0 INNER JOIN core_abstract_page t1 ON t0.id = t1.id WHERE t1.type = ?

Parameters:

[
  "event"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.created_at AS created_at_4,
  t1.updated_at AS updated_at_5,
  t1.type AS type_6,
  t1.slug AS slug_7,
  t1.published_at AS published_at_8,
  t1.public AS public_9,
  t1.template AS template_10,
  t0.title AS title_11,
  t0.subtitle AS subtitle_12,
  t0.description AS description_13,
  t0.best_for AS best_for_14,
  t0.duration AS duration_15,
  t0.needs AS needs_16,
  t0.benefits AS benefits_17,
  t0.start_at AS start_at_18,
  t0.end_at AS end_at_19,
  t0.location AS location_20,
  t0.price AS price_21,
  t0.package_type AS package_type_22,
  t0.participants AS participants_23,
  t0.learnings AS learnings_24,
  t0.process AS process_25,
  t0.inclusive AS inclusive_26,
  t1.author_id AS author_id_27,
  t0.hero_media_id AS hero_media_id_28,
  t0.benefits_media_id AS benefits_media_id_29,
  t1.discriminator
FROM
  package_page t0
  INNER JOIN core_abstract_page t1 ON t0.id = t1.id
WHERE
  t1.type = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t1.type AS type_6, t1.slug AS slug_7, t1.published_at AS published_at_8, t1.public AS public_9, t1.template AS template_10, t0.title AS title_11, t0.subtitle AS subtitle_12, t0.description AS description_13, t0.best_for AS best_for_14, t0.duration AS duration_15, t0.needs AS needs_16, t0.benefits AS benefits_17, t0.start_at AS start_at_18, t0.end_at AS end_at_19, t0.location AS location_20, t0.price AS price_21, t0.package_type AS package_type_22, t0.participants AS participants_23, t0.learnings AS learnings_24, t0.process AS process_25, t0.inclusive AS inclusive_26, t1.author_id AS author_id_27, t0.hero_media_id AS hero_media_id_28, t0.benefits_media_id AS benefits_media_id_29, t1.discriminator FROM package_page t0 INNER JOIN core_abstract_page t1 ON t0.id = t1.id WHERE t1.type = 'event';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 32)
5	App\Form\EventContactFormType->buildForm (line 96)
6	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
7	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
8	Symfony\Component\Form\FormFactory->createNamedBuilder (line 41)
9	Symfony\Component\Form\FormFactory->createBuilder (line 26)
10	Symfony\Component\Form\FormFactory->create (line 323)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 23)
12	App\Controller\EventRegisterController->register (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.46 ms
(19.47%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.main_keyword AS main_keyword_5, t0.title_intent AS title_intent_6, t0.target_audience AS target_audience_7, t0.type AS type_8, t0.schema_markup_type AS schema_markup_type_9, t0.page_id AS page_id_10, t0.image_id AS image_id_11 FROM core_page_details t0 WHERE t0.page_id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.keywords AS keywords_4,
  t0.main_keyword AS main_keyword_5,
  t0.title_intent AS title_intent_6,
  t0.target_audience AS target_audience_7,
  t0.type AS type_8,
  t0.schema_markup_type AS schema_markup_type_9,
  t0.page_id AS page_id_10,
  t0.image_id AS image_id_11
FROM
  core_page_details t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.main_keyword AS main_keyword_5, t0.title_intent AS title_intent_6, t0.target_audience AS target_audience_7, t0.type AS type_8, t0.schema_markup_type AS schema_markup_type_9, t0.page_id AS page_id_10, t0.image_id AS image_id_11 FROM core_page_details t0 WHERE t0.page_id = 23;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 845)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2448)
4	Doctrine\ORM\UnitOfWork->createEntity (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 60)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 171)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 754)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
10	Doctrine\ORM\EntityManager->find (line 86)
11	Doctrine\ORM\EntityRepository->find (line 61)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 26)
13	App\Controller\EventRegisterController->register (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.35 ms
(14.79%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.type AS type_4, c0_.slug AS slug_5, c0_.published_at AS published_at_6, c0_.public AS public_7, c0_.template AS template_8, p1_.title AS title_9, p1_.subtitle AS subtitle_10, p1_.description AS description_11, p1_.best_for AS best_for_12, p1_.duration AS duration_13, p1_.needs AS needs_14, p1_.benefits AS benefits_15, p1_.start_at AS start_at_16, p1_.end_at AS end_at_17, p1_.location AS location_18, p1_.price AS price_19, p1_.package_type AS package_type_20, p1_.participants AS participants_21, p1_.learnings AS learnings_22, p1_.process AS process_23, p1_.inclusive AS inclusive_24, c0_.discriminator AS discriminator_25, c0_.author_id AS author_id_26, p1_.hero_media_id AS hero_media_id_27, p1_.benefits_media_id AS benefits_media_id_28 FROM package_page p1_ INNER JOIN core_abstract_page c0_ ON p1_.id = c0_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.type AS type_4,
  c0_.slug AS slug_5,
  c0_.published_at AS published_at_6,
  c0_.public AS public_7,
  c0_.template AS template_8,
  p1_.title AS title_9,
  p1_.subtitle AS subtitle_10,
  p1_.description AS description_11,
  p1_.best_for AS best_for_12,
  p1_.duration AS duration_13,
  p1_.needs AS needs_14,
  p1_.benefits AS benefits_15,
  p1_.start_at AS start_at_16,
  p1_.end_at AS end_at_17,
  p1_.location AS location_18,
  p1_.price AS price_19,
  p1_.package_type AS package_type_20,
  p1_.participants AS participants_21,
  p1_.learnings AS learnings_22,
  p1_.process AS process_23,
  p1_.inclusive AS inclusive_24,
  c0_.discriminator AS discriminator_25,
  c0_.author_id AS author_id_26,
  p1_.hero_media_id AS hero_media_id_27,
  p1_.benefits_media_id AS benefits_media_id_28
FROM
  package_page p1_
  INNER JOIN core_abstract_page c0_ ON p1_.id = c0_.id

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.type AS type_4, c0_.slug AS slug_5, c0_.published_at AS published_at_6, c0_.public AS public_7, c0_.template AS template_8, p1_.title AS title_9, p1_.subtitle AS subtitle_10, p1_.description AS description_11, p1_.best_for AS best_for_12, p1_.duration AS duration_13, p1_.needs AS needs_14, p1_.benefits AS benefits_15, p1_.start_at AS start_at_16, p1_.end_at AS end_at_17, p1_.location AS location_18, p1_.price AS price_19, p1_.package_type AS package_type_20, p1_.participants AS participants_21, p1_.learnings AS learnings_22, p1_.process AS process_23, p1_.inclusive AS inclusive_24, c0_.discriminator AS discriminator_25, c0_.author_id AS author_id_26, p1_.hero_media_id AS hero_media_id_27, p1_.benefits_media_id AS benefits_media_id_28 FROM package_page p1_ INNER JOIN core_abstract_page c0_ ON p1_.id = c0_.id;

#	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 479)
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 48)
21	App\Controller\EventRegisterController->register (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.25 ms
(10.40%)

SELECT t1.id AS id_2, t1.name AS name_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t1.type AS type_6, t1.slug AS slug_7, t1.published_at AS published_at_8, t1.public AS public_9, t1.template AS template_10, t0.title AS title_11, t0.subtitle AS subtitle_12, t0.description AS description_13, t0.best_for AS best_for_14, t0.duration AS duration_15, t0.needs AS needs_16, t0.benefits AS benefits_17, t0.start_at AS start_at_18, t0.end_at AS end_at_19, t0.location AS location_20, t0.price AS price_21, t0.package_type AS package_type_22, t0.participants AS participants_23, t0.learnings AS learnings_24, t0.process AS process_25, t0.inclusive AS inclusive_26, t1.author_id AS author_id_27, t0.hero_media_id AS hero_media_id_28, t0.benefits_media_id AS benefits_media_id_29, t1.discriminator FROM package_page t0 INNER JOIN core_abstract_page t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  "23"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.created_at AS created_at_4,
  t1.updated_at AS updated_at_5,
  t1.type AS type_6,
  t1.slug AS slug_7,
  t1.published_at AS published_at_8,
  t1.public AS public_9,
  t1.template AS template_10,
  t0.title AS title_11,
  t0.subtitle AS subtitle_12,
  t0.description AS description_13,
  t0.best_for AS best_for_14,
  t0.duration AS duration_15,
  t0.needs AS needs_16,
  t0.benefits AS benefits_17,
  t0.start_at AS start_at_18,
  t0.end_at AS end_at_19,
  t0.location AS location_20,
  t0.price AS price_21,
  t0.package_type AS package_type_22,
  t0.participants AS participants_23,
  t0.learnings AS learnings_24,
  t0.process AS process_25,
  t0.inclusive AS inclusive_26,
  t1.author_id AS author_id_27,
  t0.hero_media_id AS hero_media_id_28,
  t0.benefits_media_id AS benefits_media_id_29,
  t1.discriminator
FROM
  package_page t0
  INNER JOIN core_abstract_page t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t1.type AS type_6, t1.slug AS slug_7, t1.published_at AS published_at_8, t1.public AS public_9, t1.template AS template_10, t0.title AS title_11, t0.subtitle AS subtitle_12, t0.description AS description_13, t0.best_for AS best_for_14, t0.duration AS duration_15, t0.needs AS needs_16, t0.benefits AS benefits_17, t0.start_at AS start_at_18, t0.end_at AS end_at_19, t0.location AS location_20, t0.price AS price_21, t0.package_type AS package_type_22, t0.participants AS participants_23, t0.learnings AS learnings_24, t0.process AS process_25, t0.inclusive AS inclusive_26, t1.author_id AS author_id_27, t0.hero_media_id AS hero_media_id_28, t0.benefits_media_id AS benefits_media_id_29, t1.discriminator FROM package_page t0 INNER JOIN core_abstract_page t1 ON t0.id = t1.id WHERE t1.id = '23';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 26)
7	App\Controller\EventRegisterController->register (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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
Coretecs\CoreManagementBundle\Entity\Media	6
Coretecs\CoreManagementBundle\Entity\AbstractPage	2
Coretecs\CoreManagementBundle\Entity\PageDetails	2
Coretecs\CoreManagementBundle\Entity\User	1

Entities Mapping

Class	Mapping errors
Coretecs\CoreManagementBundle\Entity\AbstractPage	No errors.
App\Entity\PackagePage	No errors.
Coretecs\CoreManagementBundle\Entity\User	No errors.
Coretecs\CoreManagementBundle\Entity\Media	No errors.
Coretecs\CoreManagementBundle\Entity\PageDetails	No errors.
Coretecs\CoreManagementBundle\Entity\Component	No errors.
Coretecs\CoreManagementBundle\Entity\AnalyticsPageView	No errors.

Symfony Profiler

GET https://erlebnis-akademie.com/anmelden/23

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping