Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

1.77 ms Query time

0 Invalid entities

2 Managed entities

0 Cache hits

1 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

0.55 ms
(30.75%)

SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.parent_id = ? ORDER BY p0_.id ASC

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.active AS active_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.name AS name_4,
  p0_.image AS image_5,
  p0_.thumbnail AS thumbnail_6,
  p0_.pk AS pk_7,
  p0_.template AS template_8,
  p0_.salable AS salable_9,
  p0_.in_stock AS in_stock_10,
  p0_.price_min AS price_min_11,
  p0_.price_max AS price_max_12,
  p0_.virtual_product AS virtual_product_13,
  p0_.purchaseable AS purchaseable_14,
  p0_.category_id AS category_id_15,
  p0_.parent_id AS parent_id_16
FROM
  product p0_
WHERE
  p0_.parent_id = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.parent_id = '4' ORDER BY p0_.id ASC;

#	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 29)
7	App\Repository\ProductRepository->findAllByParentPk (line 389)
8	App\Handler\InventreeHandler->getAllVariantParts (line 37)
9	App\Controller\ProductController->productPage (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.54 ms
(30.30%)

SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.pk = ?

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.active AS active_1,
  p0_.description AS description_2,
  p0_.keywords AS keywords_3,
  p0_.name AS name_4,
  p0_.image AS image_5,
  p0_.thumbnail AS thumbnail_6,
  p0_.pk AS pk_7,
  p0_.template AS template_8,
  p0_.salable AS salable_9,
  p0_.in_stock AS in_stock_10,
  p0_.price_min AS price_min_11,
  p0_.price_max AS price_max_12,
  p0_.virtual_product AS virtual_product_13,
  p0_.purchaseable AS purchaseable_14,
  p0_.category_id AS category_id_15,
  p0_.parent_id AS parent_id_16
FROM
  product p0_
WHERE
  p0_.pk = ?

SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.pk = '4';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 39)
7	App\Repository\ProductRepository->findOneByPk (line 322)
8	App\Handler\InventreeHandler->getSinglePartByID (line 25)
9	App\Controller\ProductController->productPage (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.39 ms
(22.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.pk AS pk_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.parent AS parent_6 FROM category t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.pk AS pk_3,
  t0.description AS description_4,
  t0.keywords AS keywords_5,
  t0.parent AS parent_6
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.pk AS pk_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.parent AS parent_6 FROM category t0 WHERE t0.id = 5;

#	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 394)
4	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadById (line 220)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
6	Proxies\__CG__\App\Entity\Category::Doctrine\ORM\Proxy\{closure} (line 59)
7	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
8	Proxies\__CG__\App\Entity\Category->__get (line 77)
9	App\Entity\Category->getPk (line 101)
10	App\Entity\Product->toArray (line 328)
11	App\Handler\InventreeHandler->getSinglePartByID (line 25)
12	App\Controller\ProductController->productPage (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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
(16.94%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.pk AS pk_4, t0.product_id AS product_id_5 FROM parameter t0 WHERE t0.product_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.pk AS pk_4,
  t0.product_id AS product_id_5
FROM
  parameter t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.pk AS pk_4, t0.product_id AS product_id_5 FROM parameter t0 WHERE t0.product_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 95)
8	App\Entity\Product->toArray (line 328)
9	App\Handler\InventreeHandler->getSinglePartByID (line 25)
10	App\Controller\ProductController->productPage (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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

0 Hits

1 Misses

0 Puts

Number of cache misses

Region	Misses
app_entity_category	1

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Product	1
App\Entity\Category	1

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Parameter	No errors.

Symfony Profiler

GET https://lemdu.pink/product/4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache misses

Managed Entities

default entity manager

Entities Mapping