Symfony Profiler

Query Metrics

27 Database Queries

2 Different statements

2.92 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.69 ms
(92.26%)

SELECT t0.id AS id_1, t0.text AS text_2, t0.language AS language_3, t0.static_text_id AS static_text_id_4 FROM static_text_translation t0 WHERE t0.static_text_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.language AS language_3,
  t0.static_text_id AS static_text_id_4
FROM
  static_text_translation t0
WHERE
  t0.static_text_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.language AS language_3, t0.static_text_id AS static_text_id_4 FROM static_text_translation t0 WHERE t0.static_text_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3140)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 38)
8	App\Controller\Api\StaticTextApiController->App\Controller\Api\{closure} (line 1)
9	array_map (line 34)
10	App\Controller\Api\StaticTextApiController->getAll (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.23 ms
(7.74%)

SELECT t0.id AS id_1, t0.admin_description AS admin_description_2, t0.is_rich_text AS is_rich_text_3, t0.identifier AS identifier_4, t0.where_page AS where_page_5, t0.help AS help_6, t0.page_id AS page_id_7 FROM static_text t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.admin_description AS admin_description_2,
  t0.is_rich_text AS is_rich_text_3,
  t0.identifier AS identifier_4,
  t0.where_page AS where_page_5,
  t0.help AS help_6,
  t0.page_id AS page_id_7
FROM
  static_text t0

SELECT t0.id AS id_1, t0.admin_description AS admin_description_2, t0.is_rich_text AS is_rich_text_3, t0.identifier AS identifier_4, t0.where_page AS where_page_5, t0.help AS help_6, t0.page_id AS page_id_7 FROM static_text t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 32)
4	App\Controller\Api\StaticTextApiController->getAll (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\StaticText	No errors.
App\Entity\Page	No errors.
App\Entity\StaticTextTranslation	No errors.

Symfony Profiler

GET https://admin.hollandia.cz/api/static-texts/

Configuration Settings

Theme