Symfony Profiler

Query Metrics

10 Database Queries

3 Different statements

49.06 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

9.27 ms

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

Parameters:

[
  "a62a1522b40ccf80285577104b8bebf1"
]

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 = 'a62a1522b40ccf80285577104b8bebf1';

#	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)

10.82 ms

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_alapszin p2_ ON p0_.id = p2_.product_id LEFT JOIN alapszin a1_ ON a1_.id = p2_.alapszin_id AND (a1_.active = 1) WHERE p0_.active = ? AND p0_.meret = ? AND p0_.category_id IN (?) GROUP BY p0_.id ORDER BY CASE WHEN MIN(a1_.sorrend) IS NULL THEN -1 ELSE MIN(a1_.sorrend) END DESC, p0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN product_alapszin p2_ ON p0_.id = p2_.product_id
  LEFT JOIN alapszin a1_ ON a1_.id = p2_.alapszin_id
  AND (a1_.active = 1)
WHERE
  p0_.active = ?
  AND p0_.meret = ?
  AND p0_.category_id IN (?)
GROUP BY
  p0_.id
ORDER BY
  CASE WHEN MIN(a1_.sorrend) IS NULL THEN
    -1
  ELSE
    MIN(a1_.sorrend)
  END DESC,
  p0_.id ASC

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_alapszin p2_ ON p0_.id = p2_.product_id LEFT JOIN alapszin a1_ ON a1_.id = p2_.alapszin_id AND (a1_.active = 1) WHERE p0_.active = 1 AND p0_.meret = 0 AND p0_.category_id IN (44) GROUP BY p0_.id ORDER BY CASE WHEN MIN(a1_.sorrend) IS NULL THEN -1 ELSE MIN(a1_.sorrend) END DESC, p0_.id 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	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)

intralog connection


SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?
SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?
SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?
SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?
SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?
SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?
SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?
SELECT
    ARAK.AR AS ar,
    ARAK.BRUTTO_AR AS brutto_ar,
    COALESCE(KESZLETEK.KESZLET, 0) - COALESCE(KESZLETEK.FOGLALT, 0) AS keszlet
FROM ANYAGOK
LEFT JOIN ARAK
    ON ANYAGOK.ID = ARAK.ANYAG
AND ARAK.ARLISTA = ?
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = ?

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

Entities Mapping

Class	Mapping errors
App\Entity\Cart	No errors.
App\Entity\Product	No errors.
App\Entity\Alapszin	No errors.
App\Entity\ProductCategoryGyik	No errors.