Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.43 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.47 ms

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.code AS code_2, i0_.enable AS enable_3, i0_.address_id AS address_id_4, i0_.logo_id AS logo_id_5 FROM inventory__channel i0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.title AS title_1,
  i0_.code AS code_2,
  i0_.enable AS enable_3,
  i0_.address_id AS address_id_4,
  i0_.logo_id AS logo_id_5
FROM
  inventory__channel i0_

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.code AS code_2, i0_.enable AS enable_3, i0_.address_id AS address_id_4, i0_.logo_id AS logo_id_5 FROM inventory__channel i0_;

#	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	SDRO\ShopBundle\src\Model\InventoryManager->getDefaultChannel (line 100)
7	SDRO\ShopBundle\src\Model\InventoryManager->__construct (line 40)
8	SDRO\ShopBundle\src\Model\ShopManager->__construct (line 16)
9	ContainerBz3QdcK\getShopManagerService->do (line 30)
10	ContainerBz3QdcK\App_KernelDevDebugContainer::load (line 685)
11	Symfony\Component\DependencyInjection\Container->getService (line 399)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 56)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
16	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.96 ms

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.variant AS variant_2, i0_.description AS description_3, i0_.sku AS sku_4, i0_.cogs AS cogs_5, i0_.original_price AS original_price_6, i0_.price AS price_7, i0_.tracked AS tracked_8, i0_.enable AS enable_9, i0_.parent_id AS parent_id_10, i0_.category_id AS category_id_11, i0_.unit_id AS unit_id_12, i0_.brand_id AS brand_id_13, i0_.discount_id AS discount_id_14 FROM inventory__product i0_ WHERE i0_.enable = ? AND i0_.parent_id IS NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.title AS title_1,
  i0_.variant AS variant_2,
  i0_.description AS description_3,
  i0_.sku AS sku_4,
  i0_.cogs AS cogs_5,
  i0_.original_price AS original_price_6,
  i0_.price AS price_7,
  i0_.tracked AS tracked_8,
  i0_.enable AS enable_9,
  i0_.parent_id AS parent_id_10,
  i0_.category_id AS category_id_11,
  i0_.unit_id AS unit_id_12,
  i0_.brand_id AS brand_id_13,
  i0_.discount_id AS discount_id_14
FROM
  inventory__product i0_
WHERE
  i0_.enable = ?
  AND i0_.parent_id IS NULL

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.variant AS variant_2, i0_.description AS description_3, i0_.sku AS sku_4, i0_.cogs AS cogs_5, i0_.original_price AS original_price_6, i0_.price AS price_7, i0_.tracked AS tracked_8, i0_.enable AS enable_9, i0_.parent_id AS parent_id_10, i0_.category_id AS category_id_11, i0_.unit_id AS unit_id_12, i0_.brand_id AS brand_id_13, i0_.discount_id AS discount_id_14 FROM inventory__product i0_ WHERE i0_.enable = 1 AND i0_.parent_id IS NULL;

#	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	SDRO\ShopBundle\src\Model\InventoryManager->getMasterProducts (line 293)
7	SDRO\ShopBundle\src\Controller\ShopController->indexAction (line 35)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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\Inventory\Product	2
SDRO\ShopBundle\src\Entity\Inventory\Channel	1
SDRO\ShopBundle\src\Entity\Inventory\Category	1
SDRO\ShopBundle\src\Entity\Inventory\Unit	1

Entities Mapping

Class	Mapping errors
SDRO\ShopBundle\src\Entity\Inventory\Channel	No errors.
SDRO\ProfileBundle\src\Entity\Address	No errors.
App\Entity\Profile\Media	No errors.
App\Entity\Inventory\Inventory	No errors.
App\Entity\Inventory\Product	No errors.
SDRO\ShopBundle\src\Entity\Inventory\Category	No errors.
SDRO\ShopBundle\src\Entity\Inventory\Unit	No errors.
SDRO\ShopBundle\src\Entity\Inventory\Brand	No errors.
SDRO\ShopBundle\src\Entity\Inventory\Discount	No errors.
App\Entity\Order\OrderItems	No errors.
App\Entity\Order\ProductPromotion	No errors.
SDRO\ShopBundle\src\Entity\Inventory\ProductVariant	No errors.
SDRO\ShopBundle\src\Entity\Inventory\ProductMedia	No errors.
SDRO\ShopBundle\src\Entity\Inventory\Favorite	No errors.

Symfony Profiler

GET https://feribazar.com/

Configuration Settings

Theme

Page Width