Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.09 ms Query time

0 Invalid entities

119 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.79 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM pr_category t0 WHERE t0.parent_id IS NULL AND t0.is_published = ? ORDER BY t0.sort_order ASC, t0.name ASC

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.slug AS slug_3,
  t0.description AS description_4,
  t0.sort_order AS sort_order_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.is_published AS is_published_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  pr_category t0
WHERE
  t0.parent_id IS NULL
  AND t0.is_published = ?
ORDER BY
  t0.sort_order ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM pr_category t0 WHERE t0.parent_id IS NULL AND t0.is_published = 1 ORDER BY t0.sort_order ASC, t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 974)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\EventSubscriber\TwigGlobalsSubscriber->onKernelController (line 34)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.71 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM pr_category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "absperrsysteme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.sort_order AS sort_order_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.is_published AS is_published_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  pr_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM pr_category t0 WHERE t0.slug = 'absperrsysteme' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Repository\ResourceRepository->findByCategorySlug (line 131)
4	App\Controller\Shop\CityController->cityLanding (line 149)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.53 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM pr_category t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC, t0.name ASC

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.slug AS slug_3,
  t0.description AS description_4,
  t0.sort_order AS sort_order_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.is_published AS is_published_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.parent_id AS parent_id_11
FROM
  pr_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent_id AS parent_id_11 FROM pr_category t0 WHERE t0.parent_id = 1 ORDER BY t0.sort_order ASC, t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1870)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3309)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Repository\ResourceRepository->findByCategorySlug (line 139)
8	App\Controller\Shop\CityController->cityLanding (line 149)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

2.06 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.type AS type_3, p0_.slug AS slug_4, p0_.price AS price_5, p0_.price_unit AS price_unit_6, p0_.pricing_type AS pricing_type_7, p0_.published_domains AS published_domains_8, p0_.published_pages AS published_pages_9, p0_.variants AS variants_10, p0_.is_published AS is_published_11, p0_.published_at AS published_at_12, p0_.meta_title AS meta_title_13, p0_.meta_description AS meta_description_14, p0_.canonical AS canonical_15, p0_.sort_order AS sort_order_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p1_.id AS id_19, p1_.filename AS filename_20, p1_.alt AS alt_21, p1_.sort_order AS sort_order_22, p1_.is_main AS is_main_23, p1_.uploaded_at AS uploaded_at_24, p1_.updated_at AS updated_at_25, p0_.category_id AS category_id_26, p1_.resource_id AS resource_id_27 FROM pr_resource p0_ INNER JOIN pr_category p2_ ON p0_.category_id = p2_.id LEFT JOIN pr_resource_image p1_ ON p0_.id = p1_.resource_id WHERE p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_published = 1 ORDER BY p2_.sort_order ASC, p0_.sort_order ASC, p0_.name ASC, p1_.sort_order ASC, p1_.is_main DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.type AS type_3,
  p0_.slug AS slug_4,
  p0_.price AS price_5,
  p0_.price_unit AS price_unit_6,
  p0_.pricing_type AS pricing_type_7,
  p0_.published_domains AS published_domains_8,
  p0_.published_pages AS published_pages_9,
  p0_.variants AS variants_10,
  p0_.is_published AS is_published_11,
  p0_.published_at AS published_at_12,
  p0_.meta_title AS meta_title_13,
  p0_.meta_description AS meta_description_14,
  p0_.canonical AS canonical_15,
  p0_.sort_order AS sort_order_16,
  p0_.created_at AS created_at_17,
  p0_.updated_at AS updated_at_18,
  p1_.id AS id_19,
  p1_.filename AS filename_20,
  p1_.alt AS alt_21,
  p1_.sort_order AS sort_order_22,
  p1_.is_main AS is_main_23,
  p1_.uploaded_at AS uploaded_at_24,
  p1_.updated_at AS updated_at_25,
  p0_.category_id AS category_id_26,
  p1_.resource_id AS resource_id_27
FROM
  pr_resource p0_
  INNER JOIN pr_category p2_ ON p0_.category_id = p2_.id
  LEFT JOIN pr_resource_image p1_ ON p0_.id = p1_.resource_id
WHERE
  p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND p0_.is_published = 1
ORDER BY
  p2_.sort_order ASC,
  p0_.sort_order ASC,
  p0_.name ASC,
  p1_.sort_order ASC,
  p1_.is_main DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.type AS type_3, p0_.slug AS slug_4, p0_.price AS price_5, p0_.price_unit AS price_unit_6, p0_.pricing_type AS pricing_type_7, p0_.published_domains AS published_domains_8, p0_.published_pages AS published_pages_9, p0_.variants AS variants_10, p0_.is_published AS is_published_11, p0_.published_at AS published_at_12, p0_.meta_title AS meta_title_13, p0_.meta_description AS meta_description_14, p0_.canonical AS canonical_15, p0_.sort_order AS sort_order_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p1_.id AS id_19, p1_.filename AS filename_20, p1_.alt AS alt_21, p1_.sort_order AS sort_order_22, p1_.is_main AS is_main_23, p1_.uploaded_at AS uploaded_at_24, p1_.updated_at AS updated_at_25, p0_.category_id AS category_id_26, p1_.resource_id AS resource_id_27 FROM pr_resource p0_ INNER JOIN pr_category p2_ ON p0_.category_id = p2_.id LEFT JOIN pr_resource_image p1_ ON p0_.id = p1_.resource_id WHERE p2_.id IN (1, 4, 15, 5, 7, 8, 9, 10, 11, 12, 16) AND p0_.is_published = 1 ORDER BY p2_.sort_order ASC, p0_.sort_order ASC, p0_.name ASC, p1_.sort_order ASC, p1_.is_main DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\ResourceRepository->findByCategorySlug (line 157)
7	App\Controller\Shop\CityController->cityLanding (line 149)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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\Resource	53
App\Entity\ResourceImage	53
App\Entity\Category	13

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Resource	No errors.
App\Entity\ResourceImage	No errors.

Symfony Profiler

GET https://test.bauzaun-mieten-nrw.de/ahlen

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping