Symfony Profiler

Query Metrics

17 Database Queries

7 Different statements

11.07 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.14 ms
(73.51%)

"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 592)
5	App\Controller\ShopController->changeState (line 419)
6	App\Controller\ShopController->deliveryaddress (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.70 ms
(15.33%)

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:

[
  ""
]

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 = '' 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.34 ms
(3.12%)

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:

[
  2
]

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 = 2;

#	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.30 ms
(2.69%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.eu AS eu_2, c0_.iso AS iso_3 FROM country c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.eu AS eu_2,
  c0_.iso AS iso_3
FROM
  country c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.eu AS eu_2, c0_.iso AS iso_3 FROM country c0_;

#	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 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 179)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 190)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 468)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 239)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 443)
23	App\Controller\ShopController->deliveryaddress (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.21 ms
(1.93%)

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

Parameters:

[
  "shopping"
  "j6fcdh11rjnfd5vbcdknupsq19"
  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', 'j6fcdh11rjnfd5vbcdknupsq19', 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 607)
8	App\Controller\ShopController->changeState (line 419)
9	App\Controller\ShopController->deliveryaddress (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.20 ms
(1.80%)

UPDATE shopping_cart SET state = ? WHERE id = ?

Parameters:

[
  "delivery_address"
  2
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  shopping_cart
SET
  state = ?
WHERE
  id = ?

UPDATE shopping_cart SET state = 'delivery_address' WHERE id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 528)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 414)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1274)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 451)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 592)
7	App\Controller\ShopController->changeState (line 419)
8	App\Controller\ShopController->deliveryaddress (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.18 ms
(1.62%)

"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 592)
4	App\Controller\ShopController->changeState (line 419)
5	App\Controller\ShopController->deliveryaddress (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)

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\Country	No errors.
App\Entity\Address	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping