Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.68 ms Query time

1 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.76 ms
(45.12%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.brand AS brand_4, t0.model AS model_5, t0.description AS description_6, t0.price AS price_7, t0.stock_quantity AS stock_quantity_8, t0.image_url AS image_url_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM product t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.brand AS brand_4,
  t0.model AS model_5,
  t0.description AS description_6,
  t0.price AS price_7,
  t0.stock_quantity AS stock_quantity_8,
  t0.image_url AS image_url_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.brand AS brand_4, t0.model AS model_5, t0.description AS description_6, t0.price AS price_7, t0.stock_quantity AS stock_quantity_8, t0.image_url AS image_url_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM product t0 WHERE t0.id = '2';

#	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 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
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.48 ms
(28.57%)

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 51)
7	App\Controller\User\ProductController->show (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.44 ms
(26.31%)

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

Parameters:

[
  "8b6faad1ef9f1130169dcc54d11ba2cf"
]

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 = '8b6faad1ef9f1130169dcc54d11ba2cf';

#	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_6ba2b15c90d6079e6d8f77e77eb580c6->doDisplay (line 402)
19	Twig\Template->yield (line 53)
20	__TwigTemplate_489d4a37514c8b2b66167940792a0074->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 52)
29	App\Controller\User\ProductController->show (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\Product	1
App\Entity\AboutUs	1

Entities Mapping

Class	Mapping 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\AboutUs	No errors.
App\Entity\CartItem	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.somitel-group.com/product/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping