Symfony Profiler

Query Metrics

12 Database Queries

6 Different statements

8.34 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.76 ms
(69.06%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1422)
2	Doctrine\DBAL\Connection->commit (line 475)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 74)
5	App\Services\ProductService->getShoppingCart (line 33)
6	App\Services\ProductService->getShoppingCartProducts (line 69)
7	App\EventListener\ShoppingcartStatusSubscriber->onKernelRequest (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.55 ms
(18.54%)

SELECT t0.id AS id_1, t0.state AS state_2, t0.session_id AS session_id_3, t0.user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0.session_id = ? LIMIT 1

Parameters:

[
  "1td3pg4557vlqcc33oh2nebu2g"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.state AS state_2,
  t0.session_id AS session_id_3,
  t0.user_id_id AS user_id_id_4
FROM
  shopping_cart t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.state AS state_2, t0.session_id AS session_id_3, t0.user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0.session_id = '1td3pg4557vlqcc33oh2nebu2g' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 67)
4	App\Services\ProductService->getShoppingCart (line 33)
5	App\Services\ProductService->getShoppingCartProducts (line 69)
6	App\EventListener\ShoppingcartStatusSubscriber->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.35 ms
(4.22%)

SELECT p0_.id AS id_0, s1_.quantity AS quantity_1, p0_.name AS name_2, p0_.price AS price_3, p0_.price * s1_.quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_.product_id = p0_.id WHERE s1_.shoppingcart_id = ?

Parameters:

[
  299
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  s1_.quantity AS quantity_1,
  p0_.name AS name_2,
  p0_.price AS price_3,
  p0_.price * s1_.quantity AS sclr_4
FROM
  shopping_cart_product s1_
  INNER JOIN product p0_ ON s1_.product_id = p0_.id
WHERE
  s1_.shoppingcart_id = ?

SELECT p0_.id AS id_0, s1_.quantity AS quantity_1, p0_.name AS name_2, p0_.price AS price_3, p0_.price * s1_.quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_.product_id = p0_.id WHERE s1_.shoppingcart_id = 299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 49)
7	App\Services\ProductService->getShoppingCartProducts (line 69)
8	App\EventListener\ShoppingcartStatusSubscriber->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.29 ms
(3.42%)

INSERT INTO shopping_cart (state, session_id, user_id_id) VALUES (?, ?, ?)

Parameters:

[
  "shopping"
  "1td3pg4557vlqcc33oh2nebu2g"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO shopping_cart (state, session_id, user_id_id)
VALUES
  (?, ?, ?)

INSERT INTO shopping_cart (state, session_id, user_id_id) VALUES ('shopping', '1td3pg4557vlqcc33oh2nebu2g', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 280)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1182)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 446)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 74)
7	App\Services\ProductService->getShoppingCart (line 33)
8	App\Services\ProductService->getShoppingCartProducts (line 69)
9	App\EventListener\ShoppingcartStatusSubscriber->onKernelRequest (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.22 ms
(2.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.price AS price_4, t0.description AS description_5 FROM product t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stock AS stock_3,
  t0.price AS price_4,
  t0.description AS description_5
FROM
  product t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.price AS price_4, t0.description AS description_5 FROM product t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 77)
5	App\Controller\ShopController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.18 ms
(2.14%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 427)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 74)
4	App\Services\ProductService->getShoppingCart (line 33)
5	App\Services\ProductService->getShoppingCartProducts (line 69)
6	App\EventListener\ShoppingcartStatusSubscriber->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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.

Entities Mapping

Class	Mapping errors
App\Entity\ShoppingCart	No errors.
App\Entity\User	No errors.
App\Entity\ShoppingCartProduct	The association App\Entity\ShoppingCartProduct#shoppingcart refers to the inverse side field App\Entity\ShoppingCart#shoppingCartProducts which does not exist.
App\Entity\Product	No errors.
App\Entity\OrderProduct	No errors.

Symfony Profiler

GET https://checkout.unkonventionell.at/shop

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping