Symfony Profiler

Query Metrics

8 Database Queries

7 Different statements

1.90 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.46 ms
(24.06%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.created_on AS created_on_3,
  t0.updated_on AS updated_on_4,
  t0.product_id AS product_id_5,
  t0.product_packing_id AS product_packing_id_6
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.product_id = 12;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Product->getMainImage (line 326)
9	App\Controller\ProductController->productView (line 116)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.33 ms
(17.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.webslug AS webslug_3, t0.description AS description_4, t0.directions AS directions_5, t0.is_featured AS is_featured_6, t0.price AS price_7, t0.sort_index AS sort_index_8, t0.available_packs AS available_packs_9, t0.contains AS contains_10, t0.dosage AS dosage_11, t0.brochure_file_name AS brochure_file_name_12, t0.brochure_file_size AS brochure_file_size_13, t0.feature_list AS feature_list_14, t0.created_on AS created_on_15, t0.updated_on AS updated_on_16, t0.category_id AS category_id_17, t0.main_image_id AS main_image_id_18 FROM product t0 WHERE t0.webslug = ? LIMIT 1

Parameters:

[
  "vitamin-b12-injection-11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.webslug AS webslug_3,
  t0.description AS description_4,
  t0.directions AS directions_5,
  t0.is_featured AS is_featured_6,
  t0.price AS price_7,
  t0.sort_index AS sort_index_8,
  t0.available_packs AS available_packs_9,
  t0.contains AS contains_10,
  t0.dosage AS dosage_11,
  t0.brochure_file_name AS brochure_file_name_12,
  t0.brochure_file_size AS brochure_file_size_13,
  t0.feature_list AS feature_list_14,
  t0.created_on AS created_on_15,
  t0.updated_on AS updated_on_16,
  t0.category_id AS category_id_17,
  t0.main_image_id AS main_image_id_18
FROM
  product t0
WHERE
  t0.webslug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.webslug AS webslug_3, t0.description AS description_4, t0.directions AS directions_5, t0.is_featured AS is_featured_6, t0.price AS price_7, t0.sort_index AS sort_index_8, t0.available_packs AS available_packs_9, t0.contains AS contains_10, t0.dosage AS dosage_11, t0.brochure_file_name AS brochure_file_name_12, t0.brochure_file_size AS brochure_file_size_13, t0.feature_list AS feature_list_14, t0.created_on AS created_on_15, t0.updated_on AS updated_on_16, t0.category_id AS category_id_17, t0.main_image_id AS main_image_id_18 FROM product t0 WHERE t0.webslug = 'vitamin-b12-injection-11' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->__call (line 100)
6	App\Controller\ProductController->productView (line 64)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.30 ms
(15.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.webslug AS webslug_3, t0.description AS description_4, t0.directions AS directions_5, t0.is_featured AS is_featured_6, t0.price AS price_7, t0.sort_index AS sort_index_8, t0.available_packs AS available_packs_9, t0.contains AS contains_10, t0.dosage AS dosage_11, t0.brochure_file_name AS brochure_file_name_12, t0.brochure_file_size AS brochure_file_size_13, t0.feature_list AS feature_list_14, t0.created_on AS created_on_15, t0.updated_on AS updated_on_16, t0.category_id AS category_id_17, t0.main_image_id AS main_image_id_18 FROM product t0 WHERE t0.category_id = ? ORDER BY t0.sort_index ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.webslug AS webslug_3,
  t0.description AS description_4,
  t0.directions AS directions_5,
  t0.is_featured AS is_featured_6,
  t0.price AS price_7,
  t0.sort_index AS sort_index_8,
  t0.available_packs AS available_packs_9,
  t0.contains AS contains_10,
  t0.dosage AS dosage_11,
  t0.brochure_file_name AS brochure_file_name_12,
  t0.brochure_file_size AS brochure_file_size_13,
  t0.feature_list AS feature_list_14,
  t0.created_on AS created_on_15,
  t0.updated_on AS updated_on_16,
  t0.category_id AS category_id_17,
  t0.main_image_id AS main_image_id_18
FROM
  product t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.sort_index ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.webslug AS webslug_3, t0.description AS description_4, t0.directions AS directions_5, t0.is_featured AS is_featured_6, t0.price AS price_7, t0.sort_index AS sort_index_8, t0.available_packs AS available_packs_9, t0.contains AS contains_10, t0.dosage AS dosage_11, t0.brochure_file_name AS brochure_file_name_12, t0.brochure_file_size AS brochure_file_size_13, t0.feature_list AS feature_list_14, t0.created_on AS created_on_15, t0.updated_on AS updated_on_16, t0.category_id AS category_id_17, t0.main_image_id AS main_image_id_18 FROM product t0 WHERE t0.category_id = 3 ORDER BY t0.sort_index ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\ProductController->productView (line 112)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.22 ms
(11.59%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4 FROM product_packing t0 INNER JOIN product_product_packing ON t0.id = product_product_packing.product_packing_id WHERE product_product_packing.product_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_on AS created_on_3,
  t0.updated_on AS updated_on_4
FROM
  product_packing t0
  INNER JOIN product_product_packing ON t0.id = product_product_packing.product_packing_id
WHERE
  product_product_packing.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4 FROM product_packing t0 INNER JOIN product_product_packing ON t0.id = product_product_packing.product_packing_id WHERE product_product_packing.product_id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002::block_body (line 587)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_293d50560894cee4c3bba3ecaaf3c715->doDisplay (line 199)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002->doDisplay (line 58)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
22	App\Controller\ProductController->productView (line 125)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
25	Symfony\Component\HttpKernel\Kernel->handle (line 143)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.22 ms
(11.37%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.icon AS icon_4, t0.webslug AS webslug_5, t0.created_on AS created_on_6, t0.updated_on AS updated_on_7 FROM category t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_description AS short_description_3,
  t0.icon AS icon_4,
  t0.webslug AS webslug_5,
  t0.created_on AS created_on_6,
  t0.updated_on AS updated_on_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.icon AS icon_4, t0.webslug AS webslug_5, t0.created_on AS created_on_6, t0.updated_on AS updated_on_7 FROM category t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1801)
5	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002::block_body (line 425)
6	Twig\Template->yieldBlock (line 458)
7	__TwigTemplate_293d50560894cee4c3bba3ecaaf3c715->doDisplay (line 199)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002->doDisplay (line 58)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
18	App\Controller\ProductController->productView (line 125)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
21	Symfony\Component\HttpKernel\Kernel->handle (line 143)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.19 ms
(9.95%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_feature_id AS product_feature_id_6 FROM product_feature_value t0 WHERE t0.product_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_on AS created_on_3,
  t0.updated_on AS updated_on_4,
  t0.product_id AS product_id_5,
  t0.product_feature_id AS product_feature_id_6
FROM
  product_feature_value t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_feature_id AS product_feature_id_6 FROM product_feature_value t0 WHERE t0.product_id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002::block_body (line 618)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_293d50560894cee4c3bba3ecaaf3c715->doDisplay (line 199)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002->doDisplay (line 58)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
22	App\Controller\ProductController->productView (line 125)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
25	Symfony\Component\HttpKernel\Kernel->handle (line 143)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.19 ms
(9.80%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = ?

Parameters:

[
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.created_on AS created_on_3,
  t0.updated_on AS updated_on_4,
  t0.product_id AS product_id_5,
  t0.product_packing_id AS product_packing_id_6
FROM
  product_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.created_on AS created_on_3, t0.updated_on AS updated_on_4, t0.product_id AS product_id_5, t0.product_packing_id AS product_packing_id_6 FROM product_image t0 WHERE t0.id = 30;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\ProductImage::getImageName (line 87)
5	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
6	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
7	Vich\UploaderBundle\Mapping\PropertyMapping->readProperty (line 152)
8	Vich\UploaderBundle\Mapping\PropertyMapping->getFileName (line 94)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 154)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 66)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 35)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 28)
13	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002->block_body (line 852)
14	Twig\Template->yieldBlock (line 458)
15	__TwigTemplate_293d50560894cee4c3bba3ecaaf3c715->doDisplay (line 199)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_faadd4795860cc2fb7dec4fbb9c65002->doDisplay (line 58)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
26	App\Controller\ProductController->productView (line 125)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
29	Symfony\Component\HttpKernel\Kernel->handle (line 143)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	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\ProductImage	5
App\Entity\Product	3
App\Entity\Category	1

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductFeatureValue	No errors.
App\Entity\ProductTag	No errors.
App\Entity\ProductPacking	No errors.
App\Entity\ProductFeature	No errors.

GET https://w5.mtio.dev/product/injectables-3/vitamin-b12-injection-11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping