Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.36 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.40 ms
(59.37%)

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.description AS description_2, i0_.enable AS enable_3, i0_.category_id AS category_id_4, i0_.brand_id AS brand_id_5 FROM inventory__product i0_ WHERE i0_.enable = ?

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_.description AS description_2,
  i0_.enable AS enable_3,
  i0_.category_id AS category_id_4,
  i0_.brand_id AS brand_id_5
FROM
  inventory__product i0_
WHERE
  i0_.enable = ?

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.description AS description_2, i0_.enable AS enable_3, i0_.category_id AS category_id_4, i0_.brand_id AS brand_id_5 FROM inventory__product i0_ WHERE i0_.enable = 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	SDRO\ShopBundle\src\Model\InventoryManager->getMasterProducts (line 308)
7	SDRO\ShopBundle\src\Controller\ShopController->indexAction (line 39)
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 29)
13	require_once (line 5)

0.96 ms
(40.63%)

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	ContainerV7E6Gae\getShopManagerService->do (line 30)
10	ContainerV7E6Gae\App_KernelDevDebugContainer::load (line 871)
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 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	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
SDRO\ShopBundle\src\Entity\Inventory\Channel	1
App\Entity\Inventory\Product	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\Brand	No errors.
SDRO\ShopBundle\src\Entity\Inventory\ProductMedia	No errors.
SDRO\ShopBundle\src\Entity\Inventory\ProductVariant	No errors.
SDRO\ShopBundle\src\Entity\Inventory\ProductOption	No errors.
SDRO\ShopBundle\src\Entity\Inventory\Favorite	No errors.

Symfony Profiler

GET https://alifcart.com/

Configuration Settings

Theme

Page Width