Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.81 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

0.68 ms

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

Parameters:

[
  "3c6c12d54610158e801f637338a929c0"
]

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 = '3c6c12d54610158e801f637338a929c0';

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

intralog connection

#▲

Time

Info

1.13 ms

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 = ?

Parameters:

[
  "0"
  240526758513712
]

View formatted query View runnable query Explain query View query backtrace

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 = '0'
LEFT JOIN KESZLETEK
    ON ANYAGOK.ID = KESZLETEK.ID
WHERE ANYAGOK.ID = 240526758513712;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Service\Product\Data\ProductIntralogDataProvider->setIntralogData (line 37)
3	App\Service\Product\Data\ProductIntralogDataProvider->provide (line 18)
4	App\Service\Product\Data\ProductDataService->getProductData (line 63)
5	App\Service\Pages\ProductService->getData (line 42)
6	App\Controller\Frontend\PageController->index (line 51)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	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

Entities Mapping

Class	Mapping errors
App\Entity\Cart	No errors.
App\Entity\ProductGyik	No errors.