Symfony Profiler

Query Metrics

21 Database Queries

4 Different statements

10.51 ms Query time

1 Invalid entities

153 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.36 ms
(79.52%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.position AS position_3,
  t0.product_id AS product_id_4
FROM
  product_image t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 5 ORDER BY t0.position ASC, t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_a47f9ea29275d7d3ae0f3f92c56ef9fa->doDisplay (line 65)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1526)
14	__TwigTemplate_9efb4cccb4dc06b28927cf8d909cd40c::doDisplay (line 57)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Extension\CoreExtension->include (line 1526)
20	__TwigTemplate_a4e3e90d79d2226fda8aa0ca7449f938::doDisplay (line 70)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_4f534d5df01e08b14981e6b720362ce3->block_body (line 133)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_eb69e86e323c859250f9926a57a88f5d->doDisplay (line 130)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_4f534d5df01e08b14981e6b720362ce3->doDisplay (line 56)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
35	App\Controller\SearchController->results (line 80)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 191)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	require_once (line 5)

0.90 ms
(8.59%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.price_amount AS price_amount_3, p0_.price_unit AS price_unit_4, p0_.deposit_amount AS deposit_amount_5, p0_.manual_included AS manual_included_6, p0_.consumables_policy AS consumables_policy_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.view_count AS view_count_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, c1_.description AS description_15, c1_.deleted_at AS deleted_at_16, c2_.id AS id_17, c2_.name AS name_18, c2_.slug AS slug_19, c2_.latitude AS latitude_20, c2_.longitude AS longitude_21, c2_.deleted_at AS deleted_at_22, p0_.owner_id AS owner_id_23, p0_.city_id AS city_id_24, c1_.parent_id AS parent_id_25 FROM product p0_ LEFT JOIN product_category p3_ ON p0_.id = p3_.product_id LEFT JOIN category c1_ ON c1_.id = p3_.category_id LEFT JOIN city c2_ ON p0_.city_id = c2_.id WHERE p0_.deleted_at IS NULL ORDER BY p0_.updated_at DESC LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.price_amount AS price_amount_3,
  p0_.price_unit AS price_unit_4,
  p0_.deposit_amount AS deposit_amount_5,
  p0_.manual_included AS manual_included_6,
  p0_.consumables_policy AS consumables_policy_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.deleted_at AS deleted_at_10,
  p0_.view_count AS view_count_11,
  c1_.id AS id_12,
  c1_.name AS name_13,
  c1_.slug AS slug_14,
  c1_.description AS description_15,
  c1_.deleted_at AS deleted_at_16,
  c2_.id AS id_17,
  c2_.name AS name_18,
  c2_.slug AS slug_19,
  c2_.latitude AS latitude_20,
  c2_.longitude AS longitude_21,
  c2_.deleted_at AS deleted_at_22,
  p0_.owner_id AS owner_id_23,
  p0_.city_id AS city_id_24,
  c1_.parent_id AS parent_id_25
FROM
  product p0_
  LEFT JOIN product_category p3_ ON p0_.id = p3_.product_id
  LEFT JOIN category c1_ ON c1_.id = p3_.category_id
  LEFT JOIN city c2_ ON p0_.city_id = c2_.id
WHERE
  p0_.deleted_at IS NULL
ORDER BY
  p0_.updated_at DESC
LIMIT
  50

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.price_amount AS price_amount_3, p0_.price_unit AS price_unit_4, p0_.deposit_amount AS deposit_amount_5, p0_.manual_included AS manual_included_6, p0_.consumables_policy AS consumables_policy_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.view_count AS view_count_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, c1_.description AS description_15, c1_.deleted_at AS deleted_at_16, c2_.id AS id_17, c2_.name AS name_18, c2_.slug AS slug_19, c2_.latitude AS latitude_20, c2_.longitude AS longitude_21, c2_.deleted_at AS deleted_at_22, p0_.owner_id AS owner_id_23, p0_.city_id AS city_id_24, c1_.parent_id AS parent_id_25 FROM product p0_ LEFT JOIN product_category p3_ ON p0_.id = p3_.product_id LEFT JOIN category c1_ ON c1_.id = p3_.category_id LEFT JOIN city c2_ ON p0_.city_id = c2_.id WHERE p0_.deleted_at IS NULL ORDER BY p0_.updated_at DESC LIMIT 50;

#	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->getResult (line 688)
6	App\Repository\ProductRepository->search (line 151)
7	App\Controller\SearchController->results (line 65)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.69 ms
(6.54%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.deleted_at AS deleted_at_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.deleted_at AS deleted_at_4,
  c0_.parent_id AS parent_id_5
FROM
  category c0_
WHERE
  c0_.deleted_at IS NULL
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.deleted_at AS deleted_at_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.name 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 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\SearchController->results (line 81)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.56 ms
(5.35%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.latitude AS latitude_3, c0_.longitude AS longitude_4, c0_.deleted_at AS deleted_at_5 FROM city c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.latitude AS latitude_3,
  c0_.longitude AS longitude_4,
  c0_.deleted_at AS deleted_at_5
FROM
  city c0_
WHERE
  c0_.deleted_at IS NULL
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.latitude AS latitude_3, c0_.longitude AS longitude_4, c0_.deleted_at AS deleted_at_5 FROM city c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.name 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 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\SearchController->results (line 81)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
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\City	68
App\Entity\Category	54
App\Entity\Product	18
App\Entity\ProductImage	12
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\City	No errors.
App\Entity\Product	The field App\Entity\Product#booked is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductBooked#product does not contain the required 'inversedBy: "booked"' attribute.
App\Entity\User	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductRating	No errors.
App\Entity\Rental	No errors.
App\Entity\ProductBooked	No errors.

Symfony Profiler

GET http://mom.home.domroese.eu/search

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping