Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.85 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.16 ms
(62.64%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.title AS title_3, t0.slug AS slug_4, t0.content AS content_5, t0.published AS published_6, t0.excerpt AS excerpt_7, t0.subtitle AS subtitle_8, t0.image_file_name AS image_file_name_9, t0.user_id AS user_id_10, t0.section_id AS section_id_11 FROM themes t0 WHERE t0.section_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.content AS content_5,
  t0.published AS published_6,
  t0.excerpt AS excerpt_7,
  t0.subtitle AS subtitle_8,
  t0.image_file_name AS image_file_name_9,
  t0.user_id AS user_id_10,
  t0.section_id AS section_id_11
FROM
  themes t0
WHERE
  t0.section_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.title AS title_3, t0.slug AS slug_4, t0.content AS content_5, t0.published AS published_6, t0.excerpt AS excerpt_7, t0.subtitle AS subtitle_8, t0.image_file_name AS image_file_name_9, t0.user_id AS user_id_10, t0.section_id AS section_id_11 FROM themes t0 WHERE t0.section_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 112)
8	__TwigTemplate_1891d8fca2cdfbb58c150bbde04854c4->block_body (line 430)
9	Twig\Template->yieldBlock (line 174)
10	__TwigTemplate_94bf437f32085399a2a906d0254dd966->doDisplay (line 360)
11	Twig\Template->yield (line 50)
12	__TwigTemplate_1891d8fca2cdfbb58c150bbde04854c4->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 202)
20	App\Controller\SectionController->section (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
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)

0.69 ms
(37.36%)

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.subtitle AS subtitle_2, s0_.slug AS slug_3, s0_.created_at AS created_at_4, s0_.published AS published_5, s0_.content AS content_6, s0_.excerpt AS excerpt_7, s0_.user_id AS user_id_8 FROM sections s0_ WHERE s0_.slug = ?

Parameters:

[
  "nauci-za-svoj-biznis"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.subtitle AS subtitle_2,
  s0_.slug AS slug_3,
  s0_.created_at AS created_at_4,
  s0_.published AS published_5,
  s0_.content AS content_6,
  s0_.excerpt AS excerpt_7,
  s0_.user_id AS user_id_8
FROM
  sections s0_
WHERE
  s0_.slug = ?

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.subtitle AS subtitle_2, s0_.slug AS slug_3, s0_.created_at AS created_at_4, s0_.published AS published_5, s0_.content AS content_6, s0_.excerpt AS excerpt_7, s0_.user_id AS user_id_8 FROM sections s0_ WHERE s0_.slug = 'nauci-za-svoj-biznis';

#	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 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 90)
7	App\Repository\SectionRepository->getSectionBySlug (line 26)
8	App\Controller\SectionController->section (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\Section	No errors.
App\Entity\User	No errors.
App\Entity\Theme	No errors.
App\Entity\Badge	No errors.
App\Entity\Module	No errors.
App\Entity\Score	No errors.

Symfony Profiler

GET https://ersteznali.m1.rs/oblast/nauci-za-svoj-biznis

Configuration Settings

Theme