Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.59 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.59 ms
(100.00%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.parent_id AS sclr_2, t0_.enabled AS enabled_3 FROM theme t0_ ORDER BY t0_.parent_id ASC, t0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.parent_id AS sclr_2,
  t0_.enabled AS enabled_3
FROM
  theme t0_
ORDER BY
  t0_.parent_id ASC,
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.parent_id AS sclr_2, t0_.enabled AS enabled_3 FROM theme t0_ ORDER BY t0_.parent_id ASC, t0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 913)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 55)
7	App\Repository\ThemeRepository->getThemeTree (line 57)
8	App\Service\Tree\GetTreeTheme->getTree (line 23)
9	App\EventSubscriber\NavigationSubscriber->onKernelController (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
16	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
21	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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.

Entities Mapping

Class	Mapping errors
App\Entity\Theme	No errors.
App\Entity\Frame	No errors.
App\Entity\Address	No errors.
App\Entity\Download	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Photography	No errors.
App\Entity\User	No errors.
App\Entity\Order	The field 'App\Entity\Order#totalAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Payment	The field 'App\Entity\Payment#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\OrderItem	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.pics-world.com/robots.txt

Configuration Settings

Theme