Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

2.54 ms Query time

1 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.73 ms
(28.58%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ ORDER BY p0_.depth ASC, p0_.lft ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.icon AS icon_4,
  p0_.lft AS lft_5,
  p0_.rgt AS rgt_6,
  p0_.depth AS depth_7
FROM
  product_category p0_
ORDER BY
  p0_.depth ASC,
  p0_.lft ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ ORDER BY p0_.depth ASC, p0_.lft 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\Modules\Product\Service\ProductCategoryService->getCategoryTree (line 53)
7	App\Modules\Product\Form\ProductSearchFilterType->buildForm (line 39)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 75)
11	Symfony\Component\Form\FormFactory->createBuilder (line 53)
12	Symfony\Component\Form\FormFactory->create (line 32)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 359)
14	App\Modules\Product\Controller\ProductController->list (line 39)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.62 ms
(24.63%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < ? AND p0_.rgt > ? ORDER BY p0_.lft DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.icon AS icon_4,
  p0_.lft AS lft_5,
  p0_.rgt AS rgt_6,
  p0_.depth AS depth_7
FROM
  product_category p0_
WHERE
  p0_.lft < ?
  AND p0_.rgt > ?
ORDER BY
  p0_.lft DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < 3 AND p0_.rgt > 4 ORDER BY p0_.lft DESC;

#	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\Admin\Modules\Settings\Service\ProductCategoryService->getParents (line 218)
7	App\Admin\Modules\Product\Service\ProductService->getDetails (line 70)
8	App\Modules\Product\Service\ProductService->getDetails (line 45)
9	App\Modules\Product\Controller\ProductController->list (line 58)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.46 ms
(18.21%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.ean AS ean_5, p0_.sku AS sku_6, p0_.price AS price_7, p0_.vat AS vat_8, p0_.gross_price AS gross_price_9, p0_.stock_quantity AS stock_quantity_10, p0_.gross_weight AS gross_weight_11, p0_.package_width AS package_width_12, p0_.package_height AS package_height_13, p0_.package_length AS package_length_14, p0_.shipping_type AS shipping_type_15, p0_.is_active AS is_active_16, p0_.added_at AS added_at_17, p0_.id_product_category AS id_product_category_18, p0_.id_added_by_user AS id_added_by_user_19 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.description AS description_4,
  p0_.ean AS ean_5,
  p0_.sku AS sku_6,
  p0_.price AS price_7,
  p0_.vat AS vat_8,
  p0_.gross_price AS gross_price_9,
  p0_.stock_quantity AS stock_quantity_10,
  p0_.gross_weight AS gross_weight_11,
  p0_.package_width AS package_width_12,
  p0_.package_height AS package_height_13,
  p0_.package_length AS package_length_14,
  p0_.shipping_type AS shipping_type_15,
  p0_.is_active AS is_active_16,
  p0_.added_at AS added_at_17,
  p0_.id_product_category AS id_product_category_18,
  p0_.id_added_by_user AS id_added_by_user_19
FROM
  product p0_
  INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id
WHERE
  p0_.is_active = 1
  AND u1_.is_active = 1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.ean AS ean_5, p0_.sku AS sku_6, p0_.price AS price_7, p0_.vat AS vat_8, p0_.gross_price AS gross_price_9, p0_.stock_quantity AS stock_quantity_10, p0_.gross_weight AS gross_weight_11, p0_.package_width AS package_width_12, p0_.package_height AS package_height_13, p0_.package_length AS package_length_14, p0_.shipping_type AS shipping_type_15, p0_.is_active AS is_active_16, p0_.added_at AS added_at_17, p0_.id_product_category AS id_product_category_18, p0_.id_added_by_user AS id_added_by_user_19 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1;

#	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\Modules\Product\Service\ProductRepositoryService->getSearchQuery (line 56)
7	App\Modules\Product\Controller\ProductController->list (line 44)
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)

0.44 ms
(17.42%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = ? ORDER BY t0.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.id_product AS id_product_3
FROM
  product_image t0
WHERE
  t0.id_product = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = 1 ORDER BY t0.id ASC;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 61)
9	App\Admin\Modules\Product\Service\ProductService::getDetails (line 61)
10	App\Modules\Product\Service\ProductService->getDetails (line 45)
11	App\Modules\Product\Controller\ProductController->list (line 58)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.15 ms
(5.76%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.email AS email_4,
  t0.type AS type_5,
  t0.is_active AS is_active_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user 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::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Modules\User\Entity\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Modules\User\Entity\User->__get (line 153)
7	App\Modules\User\Entity\User->_getFromCollection (line 59)
8	App\Modules\User\Entity\User->getCompany (line 81)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_db78269fcce9762a78ffce382b6000b6::doDisplay (line 110)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Extension\CoreExtension->include (line 1518)
16	__TwigTemplate_aab34447c3cb5993496115d2bec7e557::block_content (line 116)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_f91b4fd21d22fce73f36a091495ecaeb->block_body (line 124)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_92d65ae0af2cf32306c2779155e0e016->doDisplay (line 120)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_f91b4fd21d22fce73f36a091495ecaeb->doDisplay (line 54)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_aab34447c3cb5993496115d2bec7e557->doDisplay (line 54)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	App\Modules\Product\Controller\ProductController->list (line 82)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

0.14 ms
(5.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.image AS image_6, t0.tin AS tin_7, t0.street AS street_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.company_data_visible AS company_data_visible_11, t0.bank_account_number AS bank_account_number_12, t0.id_user AS id_user_13 FROM user_company t0 WHERE t0.id_user = ?

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.slug AS slug_3,
  t0.description AS description_4,
  t0.logo AS logo_5,
  t0.image AS image_6,
  t0.tin AS tin_7,
  t0.street AS street_8,
  t0.postal_code AS postal_code_9,
  t0.city AS city_10,
  t0.company_data_visible AS company_data_visible_11,
  t0.bank_account_number AS bank_account_number_12,
  t0.id_user AS id_user_13
FROM
  user_company t0
WHERE
  t0.id_user = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.image AS image_6, t0.tin AS tin_7, t0.street AS street_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.company_data_visible AS company_data_visible_11, t0.bank_account_number AS bank_account_number_12, t0.id_user AS id_user_13 FROM user_company t0 WHERE t0.id_user = '3';

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 59)
9	App\Modules\User\Entity\User::_getFromCollection (line 59)
10	App\Modules\User\Entity\User->getCompany (line 81)
11	Twig\Extension\CoreExtension->getAttribute (line 1911)
12	__TwigTemplate_db78269fcce9762a78ffce382b6000b6::doDisplay (line 110)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Extension\CoreExtension->include (line 1518)
18	__TwigTemplate_aab34447c3cb5993496115d2bec7e557::block_content (line 116)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_f91b4fd21d22fce73f36a091495ecaeb->block_body (line 124)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_92d65ae0af2cf32306c2779155e0e016->doDisplay (line 120)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_f91b4fd21d22fce73f36a091495ecaeb->doDisplay (line 54)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_aab34447c3cb5993496115d2bec7e557->doDisplay (line 54)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
35	App\Modules\Product\Controller\ProductController->list (line 82)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	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\Admin\Modules\Settings\Entity\ProductCategory	5
App\Admin\Modules\Product\Entity\ProductImage	3
App\Admin\Modules\Product\Entity\Product	2
App\Modules\User\Entity\User	1
App\Admin\Modules\Company\Entity\UserCompany	1

Entities Mapping

Class	Mapping errors
App\Admin\Modules\Settings\Entity\ProductCategory	No errors.
App\Admin\Modules\Product\Entity\Product	No errors.
App\Modules\User\Entity\User	No errors.
App\Admin\Modules\Product\Entity\ProductImage	No errors.
App\Admin\Modules\Product\Entity\ProductTag	No errors.
App\Admin\Modules\Presentation\Entity\PresentationProduct	No errors.
App\Admin\Modules\Company\Entity\UserCompany	The field 'App\Admin\Modules\Company\Entity\UserCompany#companyDataVisible' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Admin\Modules\Client\Entity\UserClient	No errors.
App\Admin\Modules\Presentation\Entity\Presentation	No errors.
App\Admin\Modules\Promotion\Entity\PromotionProduct	No errors.

Symfony Profiler

GET https://www.testy.skleponline.pl/produkty/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping