Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.82 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

0.86 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.active AS active_4, t0.sorrend AS sorrend_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icon_alt AS icon_alt_8, t0.icon_title AS icon_title_9, t0.icon AS icon_10, t0.image AS image_11, t0.image_alt AS image_alt_12, t0.image_title AS image_title_13, t0.article_image AS article_image_14, t0.article_image_alt AS article_image_alt_15, t0.article_image_title AS article_image_title_16, t0.description AS description_17, t0.short_description AS short_description_18, t0.featured AS featured_19, t0.seo_title AS seo_title_20, t0.meta_desc AS meta_desc_21, t0.beepites AS beepites_22, t0.parent_id AS parent_id_23 FROM product_category t0 WHERE t0.alias = ? LIMIT 1

Parameters:

[
  "rusztikus-terburkolat"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.active AS active_4,
  t0.sorrend AS sorrend_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.icon_alt AS icon_alt_8,
  t0.icon_title AS icon_title_9,
  t0.icon AS icon_10,
  t0.image AS image_11,
  t0.image_alt AS image_alt_12,
  t0.image_title AS image_title_13,
  t0.article_image AS article_image_14,
  t0.article_image_alt AS article_image_alt_15,
  t0.article_image_title AS article_image_title_16,
  t0.description AS description_17,
  t0.short_description AS short_description_18,
  t0.featured AS featured_19,
  t0.seo_title AS seo_title_20,
  t0.meta_desc AS meta_desc_21,
  t0.beepites AS beepites_22,
  t0.parent_id AS parent_id_23
FROM
  product_category t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.active AS active_4, t0.sorrend AS sorrend_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icon_alt AS icon_alt_8, t0.icon_title AS icon_title_9, t0.icon AS icon_10, t0.image AS image_11, t0.image_alt AS image_alt_12, t0.image_title AS image_title_13, t0.article_image AS article_image_14, t0.article_image_alt AS article_image_alt_15, t0.article_image_title AS article_image_title_16, t0.description AS description_17, t0.short_description AS short_description_18, t0.featured AS featured_19, t0.seo_title AS seo_title_20, t0.meta_desc AS meta_desc_21, t0.beepites AS beepites_22, t0.parent_id AS parent_id_23 FROM product_category t0 WHERE t0.alias = 'rusztikus-terburkolat' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\Pages\PageResolver->{closure:App\Service\Pages\PageResolver::resolve():73} (line 73)
5	App\Service\Infrastructure\CacheService->getOrSetIndexed (line 93)
6	App\Service\Pages\PageResolver->resolve (line 70)
7	App\Controller\Frontend\PageController->index (line 42)
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)

1.33 ms

SELECT COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = ?

Parameters:

[
  "3c2794beb10297d6f051702b5de0297b"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0,
  COALESCE(
    SUM(c0_.total),
    0
  ) AS sclr_1
FROM
  cart c0_
WHERE
  c0_.session_id = ?

SELECT COUNT(c0_.id) AS sclr_0, COALESCE(SUM(c0_.total), 0) AS sclr_1 FROM cart c0_ WHERE c0_.session_id = '3c2794beb10297d6f051702b5de0297b';

#	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->getSingleResult (line 772)
6	App\Repository\CartRepository->getCartSummaryBySession (line 27)
7	App\Service\CMS\CommonService->getCommonValues (line 70)
8	App\Service\Pages\PageResolver->resolve (line 91)
9	App\Controller\Frontend\PageController->index (line 42)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.85 ms

SELECT p0_.id AS id_0 FROM product_category p0_ WHERE p0_.parent_id IN (?)

Parameters:

[
  57
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0
FROM
  product_category p0_
WHERE
  p0_.parent_id IN (?)

SELECT p0_.id AS id_0 FROM product_category p0_ WHERE p0_.parent_id IN (57);

#	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->getArrayResult (line 700)
6	App\Repository\ProductCategoryRepository->{closure:App\Repository\ProductCategoryRepository::findDescendantIdsIncludingSelf():26} (line 36)
7	App\Service\Infrastructure\CacheService->getOrSet (line 39)
8	App\Repository\ProductCategoryRepository->findDescendantIdsIncludingSelf (line 24)
9	App\Service\Product\Filter\ProductSearchService->buildProductQuery (line 30)
10	App\Service\Product\Filter\ProductSearchService->getProductIds (line 84)
11	App\Service\Product\Filter\FilterService->{closure:App\Service\Product\Filter\FilterService::getProductIdsForFilterState():86} (line 86)
12	App\Service\Infrastructure\CacheService->getOrSet (line 39)
13	App\Service\Product\Filter\FilterCacheService->getProductIds (line 32)
14	App\Service\Product\Filter\FilterService->getProductIdsForFilterState (line 81)
15	App\Service\Product\ProductQueryService->setProducts (line 61)
16	App\Service\Pages\ProductCategoryService->getData (line 63)
17	App\Controller\Frontend\PageController->index (line 51)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.77 ms

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ WHERE p0_.active = ? AND p0_.meret = ? AND p0_.category_id IN (?) ORDER BY p0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.active = ?
  AND p0_.meret = ?
  AND p0_.category_id IN (?)
ORDER BY
  p0_.id DESC

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ WHERE p0_.active = 1 AND p0_.meret = 0 AND p0_.category_id IN (57) ORDER BY p0_.id DESC;

#	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->getScalarResult (line 724)
6	App\Service\Product\Filter\ProductSearchService->getProductIds (line 87)
7	App\Service\Product\Filter\FilterService->{closure:App\Service\Product\Filter\FilterService::getProductIdsForFilterState():86} (line 86)
8	App\Service\Infrastructure\CacheService->getOrSet (line 39)
9	App\Service\Product\Filter\FilterCacheService->getProductIds (line 32)
10	App\Service\Product\Filter\FilterService->getProductIdsForFilterState (line 81)
11	App\Service\Product\ProductQueryService->setProducts (line 61)
12	App\Service\Pages\ProductCategoryService->getData (line 63)
13	App\Controller\Frontend\PageController->index (line 51)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
intralog	doctrine.dbal.intralog_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\ProductCategory	2

Entities Mapping

Class	Mapping errors
App\Entity\ProductCategory	No errors.
App\Entity\Product	No errors.
App\Entity\ProductCategoryGyik	No errors.
App\Entity\Cart	No errors.
App\Entity\Fuga	No errors.
App\Entity\ProductSize	No errors.
App\Entity\Alapszin	No errors.
App\Entity\Felulet	No errors.
App\Entity\Tarkasag	No errors.
App\Entity\ProductGyik	No errors.
App\Entity\Downloads	No errors.
App\Entity\Icons	No errors.
App\Entity\ProductGallery	No errors.
App\Entity\ProductOtherSize	No errors.
App\Entity\Ablaktok	No errors.
App\Entity\Cserep	No errors.
App\Entity\House	No errors.
App\Entity\Vakolat	No errors.

Symfony Profiler

GET https://poth-api.keszul.hu/terburkolat/rusztikus-terburkolat/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping