Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.60 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.55 ms
(59.65%)

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.code AS code_2, i0_.description AS description_3, i0_.parent_id AS parent_id_4, i0_.media_id AS media_id_5 FROM inventory__category i0_ INNER JOIN inventory__category i1_ ON i0_.parent_id = i1_.id WHERE i1_.title = ? ORDER BY i0_.title ASC LIMIT 12

Parameters:

[
  "root"
]

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_.description AS description_3,
  i0_.parent_id AS parent_id_4,
  i0_.media_id AS media_id_5
FROM
  inventory__category i0_
  INNER JOIN inventory__category i1_ ON i0_.parent_id = i1_.id
WHERE
  i1_.title = ?
ORDER BY
  i0_.title ASC
LIMIT
  12

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.code AS code_2, i0_.description AS description_3, i0_.parent_id AS parent_id_4, i0_.media_id AS media_id_5 FROM inventory__category i0_ INNER JOIN inventory__category i1_ ON i0_.parent_id = i1_.id WHERE i1_.title = 'root' ORDER BY i0_.title ASC LIMIT 12;

#	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\Controller\ShopController->indexAction (line 52)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

1.05 ms
(40.35%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.enable AS enable_4, t0.address_id AS address_id_5, t0.logo_id AS logo_id_6 FROM inventory__channel t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.enable AS enable_4,
  t0.address_id AS address_id_5,
  t0.logo_id AS logo_id_6
FROM
  inventory__channel t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.enable AS enable_4, t0.address_id AS address_id_5, t0.logo_id AS logo_id_6 FROM inventory__channel t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	SDRO\ShopBundle\src\Model\InventoryManager->getDefaultChannel (line 101)
5	SDRO\ShopBundle\src\Model\InventoryManager->__construct (line 35)
6	SDRO\ShopBundle\src\Model\ShopManager->__construct (line 16)
7	ContainerXFwdcNp\getShopManagerService->do (line 30)
8	ContainerXFwdcNp\App_KernelDevDebugContainer::load (line 694)
9	Symfony\Component\DependencyInjection\Container->getService (line 399)
10	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
11	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 56)
12	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
14	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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)

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\Category	3
SDRO\ShopBundle\src\Entity\Inventory\Channel	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.
SDRO\ShopBundle\src\Entity\Inventory\Category	No errors.
App\Entity\Inventory\Product	No errors.

Symfony Profiler

GET https://alifcart.com/

Configuration Settings

Theme

Page Width