Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.95 ms Query time

0 Invalid entities

19 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.16 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.text AS text_4, t0.image AS image_5, t0.category_id AS category_id_6 FROM post t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "test-fyvfyv"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.text AS text_4,
  t0.image AS image_5,
  t0.category_id AS category_id_6
FROM
  post t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.text AS text_4, t0.image AS image_5, t0.category_id AS category_id_6 FROM post t0 WHERE t0.slug = 'test-fyvfyv' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\HomePageController->article_page (line 61)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.79 ms

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9 FROM doctor t0 ORDER BY t0.full_name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.slug AS slug_3,
  t0.photo AS photo_4,
  t0.list_photo AS list_photo_5,
  t0.list_description AS list_description_6,
  t0.short_description AS short_description_7,
  t0.left_description AS left_description_8,
  t0.right_description AS right_description_9
FROM
  doctor t0
ORDER BY
  t0.full_name ASC

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9 FROM doctor t0 ORDER BY t0.full_name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\DoctorGlobalsExtension->getGlobals (line 18)
5	Twig\ExtensionSet->getGlobals (line 359)
6	Twig\Environment->getGlobals (line 900)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
15	App\Controller\HomePageController->article_page (line 65)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	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\Doctor	18
App\Entity\Blog\Post	1

Entities Mapping

Class	Mapping errors
App\Entity\Blog\Post	No errors.
App\Entity\Blog\Category	No errors.
App\Entity\Doctor	No errors.
App\Entity\DoctorDiploma	No errors.

Symfony Profiler

GET https://www.hlife.1dev.su/articles/test-fyvfyv

Configuration Settings

Theme

Page Width