Symfony Profiler

Query Metrics

23 Database Queries

4 Different statements

16.26 ms Query time

0 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.51 ms
(40.01%)

SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  products t0
WHERE
  t0.category_id = ?

SELECT COUNT(*) FROM products t0 WHERE t0.category_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\Persisters\Collection\OneToManyPersister->count (line 94)
3	Doctrine\ORM\PersistentCollection->count (line 388)
4	Twig\Extension\CoreExtension->length (line 1270)
5	__TwigTemplate_10965e6a7397443360e83b6cebca2ca4::doDisplay (line 249)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_c37f16c066f4f749128779a029b2227c->doDisplay (line 54)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
16	App\Controller\ShopController->showCategory (line 42)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

5.45 ms
(33.53%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM categories c0_ WHERE c0_.slug = ?

Parameters:

[
  "home-appliances"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.parent_id AS parent_id_3
FROM
  categories c0_
WHERE
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM categories c0_ WHERE c0_.slug = 'home-appliances';

#	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->getOneOrNullResult (line 737)
6	App\Repository\CategoryRepository->findBySlug (line 31)
7	App\Controller\ShopController->showCategory (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

2.71 ms
(16.67%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM categories c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.parent_id AS parent_id_3
FROM
  categories c0_
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM categories c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC;

#	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->getResult (line 688)
6	App\Repository\CategoryRepository->findAllRootCategories (line 22)
7	App\Controller\ShopController->showCategory (line 40)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.59 ms
(9.80%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.stock AS stock_5, t0.image AS image_6, t0.is_featured AS is_featured_7, t0.category_id AS category_id_8 FROM products t0 WHERE t0.category_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.stock AS stock_5,
  t0.image AS image_6,
  t0.is_featured AS is_featured_7,
  t0.category_id AS category_id_8
FROM
  products t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.stock AS stock_5, t0.image AS image_6, t0.is_featured AS is_featured_7, t0.category_id AS category_id_8 FROM products t0 WHERE t0.category_id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 154)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Controller\ShopController->showCategory (line 39)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	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\Catalog\Domain\Entity\Category	18

Entities Mapping

Class	Mapping errors
App\Catalog\Domain\Entity\Category	No errors.
App\Catalog\Domain\Entity\Product	No errors.

Symfony Profiler

GET https://e-commerce.it.com/category/home-appliances

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping