Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.22 ms Query time

0 Invalid entities

7 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

0.15 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.pk AS pk_2, c0_.description AS description_3, c0_.keywords AS keywords_4, c0_.parent AS parent_5 FROM category c0_ WHERE c0_.name = ?

Parameters:

[
  "LemduPink"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.pk AS pk_2,
  c0_.description AS description_3,
  c0_.keywords AS keywords_4,
  c0_.parent AS parent_5
FROM
  category c0_
WHERE
  c0_.name = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.pk AS pk_2, c0_.description AS description_3, c0_.keywords AS keywords_4, c0_.parent AS parent_5 FROM category c0_ WHERE c0_.name = 'LemduPink';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 50)
7	App\Repository\CategoryRepository->findOneByName (line 71)
8	App\Handler\InventreeHandler->getStoreCategory (line 15)
9	App\Controller\DefaultController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.07 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.pk AS pk_2, c0_.description AS description_3, c0_.keywords AS keywords_4, c0_.parent AS parent_5 FROM category c0_ WHERE c0_.parent = ? ORDER BY c0_.pk ASC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.pk AS pk_2,
  c0_.description AS description_3,
  c0_.keywords AS keywords_4,
  c0_.parent AS parent_5
FROM
  category c0_
WHERE
  c0_.parent = ?
ORDER BY
  c0_.pk ASC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.pk AS pk_2, c0_.description AS description_3, c0_.keywords AS keywords_4, c0_.parent AS parent_5 FROM category c0_ WHERE c0_.parent = 1 ORDER BY c0_.pk ASC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 30)
7	App\Repository\CategoryRepository->findAllByParent (line 102)
8	App\Handler\InventreeHandler->getSubCategories (line 19)
9	App\Controller\DefaultController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Category	7

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Product	No errors.

Symfony Profiler

GET https://lemdu.pink/

Configuration Settings

Theme

Page Width