Symfony Profiler

Query Metrics

366 Database Queries

2 Different statements

112.18 ms Query time

0 Invalid entities

408 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

110.18 ms
(98.22%)

365

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.last_updated AS last_updated_4, t0.used AS used_5, t0.title AS title_6, t0.alt AS alt_7, t0.type AS type_8, t0.id_image_kit AS id_image_kit_9 FROM image t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.last_updated AS last_updated_4,
  t0.used AS used_5,
  t0.title AS title_6,
  t0.alt AS alt_7,
  t0.type AS type_8,
  t0.id_image_kit AS id_image_kit_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.last_updated AS last_updated_4, t0.used AS used_5, t0.title AS title_6, t0.alt AS alt_7, t0.type AS type_8, t0.id_image_kit AS id_image_kit_9 FROM image t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 105)
7	App\Services\TemplateAppService->getImageKit (line 98)
8	App\Controller\Api\v2\ApiController->App\Controller\Api\v2\{closure} (line 1)
9	array_map (line 90)
10	App\Controller\Api\v2\ApiController->monuments (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

2.00 ms
(1.78%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.icon AS icon_3, t0.title AS title_4, t0.meta AS meta_5, t0.thumbnail AS thumbnail_6, t0.gallery AS gallery_7, t0.publish AS publish_8 FROM monument t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.icon AS icon_3,
  t0.title AS title_4,
  t0.meta AS meta_5,
  t0.thumbnail AS thumbnail_6,
  t0.gallery AS gallery_7,
  t0.publish AS publish_8
FROM
  monument t0

SELECT t0.id AS id_1, t0.position AS position_2, t0.icon AS icon_3, t0.title AS title_4, t0.meta AS meta_5, t0.thumbnail AS thumbnail_6, t0.gallery AS gallery_7, t0.publish AS publish_8 FROM monument t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 88)
6	App\Controller\Api\v2\ApiController->monuments (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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
App\Entity\Image	365
App\Entity\Monument	43

Entities Mapping

Class	Mapping errors
App\Entity\Monument	No errors.
App\Entity\Image	No errors.

Symfony Profiler

GET https://pbguide.prague-boats.cz/v2/api/pamatky/it

Configuration Settings

Theme

Page Width