Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

1.79 ms Query time

1 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.70 ms

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.session_id AS session_id_2, c0_.created_at AS created_at_3, c0_.product_id AS product_id_4, c0_.user_id AS user_id_5 FROM cart_item c0_ WHERE c0_.session_id = ? ORDER BY c0_.created_at DESC

Parameters:

[
  "95314f9a08abacad815bc0e6fb096f6d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.quantity AS quantity_1,
  c0_.session_id AS session_id_2,
  c0_.created_at AS created_at_3,
  c0_.product_id AS product_id_4,
  c0_.user_id AS user_id_5
FROM
  cart_item c0_
WHERE
  c0_.session_id = ?
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.session_id AS session_id_2, c0_.created_at AS created_at_3, c0_.product_id AS product_id_4, c0_.user_id AS user_id_5 FROM cart_item c0_ WHERE c0_.session_id = '95314f9a08abacad815bc0e6fb096f6d' ORDER BY c0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\CartItemRepository->findBySessionId (line 159)
8	App\Service\CartService->getCartItems (line 36)
9	App\Controller\User\CartController->index (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.30 ms

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.session_id AS session_id_2, c0_.created_at AS created_at_3, c0_.product_id AS product_id_4, c0_.user_id AS user_id_5 FROM cart_item c0_ WHERE c0_.session_id = ? ORDER BY c0_.created_at DESC

Parameters:

[
  "95314f9a08abacad815bc0e6fb096f6d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.quantity AS quantity_1,
  c0_.session_id AS session_id_2,
  c0_.created_at AS created_at_3,
  c0_.product_id AS product_id_4,
  c0_.user_id AS user_id_5
FROM
  cart_item c0_
WHERE
  c0_.session_id = ?
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.session_id AS session_id_2, c0_.created_at AS created_at_3, c0_.product_id AS product_id_4, c0_.user_id AS user_id_5 FROM cart_item c0_ WHERE c0_.session_id = '95314f9a08abacad815bc0e6fb096f6d' ORDER BY c0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\CartItemRepository->findBySessionId (line 159)
8	App\Service\CartService->getCartItems (line 183)
9	App\Service\CartService->getCartTotal (line 37)
10	App\Controller\User\CartController->index (line 181)
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.41 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.features AS features_4, t0.contact_number AS contact_number_5, t0.image AS image_6, t0.email AS email_7, t0.address AS address_8, t0.links AS links_9 FROM about_us t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.features AS features_4,
  t0.contact_number AS contact_number_5,
  t0.image AS image_6,
  t0.email AS email_7,
  t0.address AS address_8,
  t0.links AS links_9
FROM
  about_us t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.features AS features_4, t0.contact_number AS contact_number_5, t0.image AS image_6, t0.email AS email_7, t0.address AS address_8, t0.links AS links_9 FROM about_us t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 38)
7	App\Controller\User\CartController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.39 ms

SELECT SUM(c0_.quantity) AS sclr_0 FROM cart_item c0_ WHERE c0_.session_id = ?

Parameters:

[
  "95314f9a08abacad815bc0e6fb096f6d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(c0_.quantity) AS sclr_0
FROM
  cart_item c0_
WHERE
  c0_.session_id = ?

SELECT SUM(c0_.quantity) AS sclr_0 FROM cart_item c0_ WHERE c0_.session_id = '95314f9a08abacad815bc0e6fb096f6d';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 75)
8	App\Repository\CartItemRepository->getTotalQuantityBySessionId (line 173)
9	App\Service\CartService->getCartItemCount (line 102)
10	App\Controller\User\CartController->count (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 217)
18	__TwigTemplate_0c792b11d706d0c44d2ac4c655bb3089->doDisplay (line 402)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_3d895afb0ec11f65bc5406bcc7f192a6->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 38)
29	App\Controller\User\CartController->index (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AboutUs	1

Entities Mapping

Class	Mapping errors
App\Entity\CartItem	No errors.
App\Entity\Product	The field 'App\Entity\Product#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\User	No errors.
App\Entity\AboutUs	No errors.
App\Entity\Ticket	No errors.
App\Entity\Message	No errors.

Symfony Profiler

GET https://www.somitel-group.com/cart

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping