Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

604.50 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

592.68 ms
(98.04%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.excerpt AS excerpt_3, c0_.content AS content_4, c0_.subtitle AS subtitle_5, c0_.published AS published_6, c0_.created_at AS created_at_7, c0_.user_id AS user_id_8, c0_.module_id AS module_id_9 FROM chapters c0_ WHERE c0_.slug = ?

Parameters:

[
  "bilans-stanja"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.excerpt AS excerpt_3,
  c0_.content AS content_4,
  c0_.subtitle AS subtitle_5,
  c0_.published AS published_6,
  c0_.created_at AS created_at_7,
  c0_.user_id AS user_id_8,
  c0_.module_id AS module_id_9
FROM
  chapters c0_
WHERE
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.excerpt AS excerpt_3, c0_.content AS content_4, c0_.subtitle AS subtitle_5, c0_.published AS published_6, c0_.created_at AS created_at_7, c0_.user_id AS user_id_8, c0_.module_id AS module_id_9 FROM chapters c0_ WHERE c0_.slug = 'bilans-stanja';

#	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 63)
7	App\Repository\ChapterRepository->getChapterBySlug (line 41)
8	App\Controller\ChapterController->chapter (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)

4.46 ms
(0.74%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.subtitle AS subtitle_6, t0.published AS published_7, t0.created_at AS created_at_8, t0.user_id AS user_id_9, t0.module_id AS module_id_10 FROM chapters t0 WHERE t0.module_id = ?

Parameters:

[
  19
]

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.excerpt AS excerpt_4,
  t0.content AS content_5,
  t0.subtitle AS subtitle_6,
  t0.published AS published_7,
  t0.created_at AS created_at_8,
  t0.user_id AS user_id_9,
  t0.module_id AS module_id_10
FROM
  chapters t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.subtitle AS subtitle_6, t0.published AS published_7, t0.created_at AS created_at_8, t0.user_id AS user_id_9, t0.module_id AS module_id_10 FROM chapters t0 WHERE t0.module_id = 19;

#	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 177)
7	Doctrine\Common\Collections\AbstractLazyCollection->last (line 1063)
8	App\Controller\ChapterController->chapter (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)

2.54 ms
(0.42%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.excerpt AS excerpt_3, c0_.content AS content_4, c0_.subtitle AS subtitle_5, c0_.published AS published_6, c0_.created_at AS created_at_7, c0_.user_id AS user_id_8, c0_.module_id AS module_id_9 FROM chapters c0_ WHERE c0_.id < ? AND c0_.module_id = ? ORDER BY c0_.id DESC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.excerpt AS excerpt_3,
  c0_.content AS content_4,
  c0_.subtitle AS subtitle_5,
  c0_.published AS published_6,
  c0_.created_at AS created_at_7,
  c0_.user_id AS user_id_8,
  c0_.module_id AS module_id_9
FROM
  chapters c0_
WHERE
  c0_.id < ?
  AND c0_.module_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.excerpt AS excerpt_3, c0_.content AS content_4, c0_.subtitle AS subtitle_5, c0_.published AS published_6, c0_.created_at AS created_at_7, c0_.user_id AS user_id_8, c0_.module_id AS module_id_9 FROM chapters c0_ WHERE c0_.id < 73 AND c0_.module_id = 19 ORDER BY c0_.id DESC LIMIT 1;

#	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 106)
7	App\Repository\ChapterRepository->getPrevChapter (line 128)
8	App\Controller\ChapterController->chapter (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)

1.23 ms
(0.20%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.excerpt AS excerpt_3, c0_.content AS content_4, c0_.subtitle AS subtitle_5, c0_.published AS published_6, c0_.created_at AS created_at_7, c0_.user_id AS user_id_8, c0_.module_id AS module_id_9 FROM chapters c0_ WHERE c0_.id > ? AND c0_.module_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.excerpt AS excerpt_3,
  c0_.content AS content_4,
  c0_.subtitle AS subtitle_5,
  c0_.published AS published_6,
  c0_.created_at AS created_at_7,
  c0_.user_id AS user_id_8,
  c0_.module_id AS module_id_9
FROM
  chapters c0_
WHERE
  c0_.id > ?
  AND c0_.module_id = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.excerpt AS excerpt_3, c0_.content AS content_4, c0_.subtitle AS subtitle_5, c0_.published AS published_6, c0_.created_at AS created_at_7, c0_.user_id AS user_id_8, c0_.module_id AS module_id_9 FROM chapters c0_ WHERE c0_.id > 73 AND c0_.module_id = 19 LIMIT 1;

#	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\ChapterRepository->getNextChapter (line 123)
8	App\Controller\ChapterController->chapter (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)

1.02 ms
(0.17%)

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.id = ?

Parameters:

[
  8
]

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.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.id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\Theme::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Theme->__get (line 199)
8	App\Entity\Theme->getSection (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 289)
10	__TwigTemplate_d62e19199ea47108df0f2fff3e122a0f->block_body (line 430)
11	Twig\Template->yieldBlock (line 174)
12	__TwigTemplate_94bf437f32085399a2a906d0254dd966->doDisplay (line 360)
13	Twig\Template->yield (line 234)
14	__TwigTemplate_d62e19199ea47108df0f2fff3e122a0f->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1080)
22	App\Controller\ChapterController->chapter (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.92 ms
(0.15%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.published AS published_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.wheel_order AS wheel_order_7, t0.child_wheel_order AS child_wheel_order_8, t0.user_id AS user_id_9, t0.module_id AS module_id_10 FROM tests t0 WHERE t0.module_id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.copy AS copy_3,
  t0.published AS published_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.wheel_order AS wheel_order_7,
  t0.child_wheel_order AS child_wheel_order_8,
  t0.user_id AS user_id_9,
  t0.module_id AS module_id_10
FROM
  tests t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.published AS published_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.wheel_order AS wheel_order_7, t0.child_wheel_order AS child_wheel_order_8, t0.user_id AS user_id_9, t0.module_id AS module_id_10 FROM tests t0 WHERE t0.module_id = 19;

#	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 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 505)
9	Doctrine\ORM\PersistentCollection->offsetGet (line 1088)
10	App\Controller\ChapterController->chapter (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.87 ms
(0.14%)

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.show_on_home AS show_on_home_9, t0.sort_order AS sort_order_10, t0.image_file_name AS image_file_name_11, t0.user_id AS user_id_12, t0.theme_id AS theme_id_13 FROM modules t0 WHERE t0.id = ?

Parameters:

[
  19
]

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.show_on_home AS show_on_home_9,
  t0.sort_order AS sort_order_10,
  t0.image_file_name AS image_file_name_11,
  t0.user_id AS user_id_12,
  t0.theme_id AS theme_id_13
FROM
  modules t0
WHERE
  t0.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.show_on_home AS show_on_home_9, t0.sort_order AS sort_order_10, t0.image_file_name AS image_file_name_11, t0.user_id AS user_id_12, t0.theme_id AS theme_id_13 FROM modules t0 WHERE t0.id = 19;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\Module::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Module->__get (line 179)
8	App\Entity\Module->getChapters (line 1063)
9	App\Controller\ChapterController->chapter (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.79 ms
(0.13%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.published AS published_6, t0.content AS content_7, t0.excerpt AS excerpt_8, t0.user_id AS user_id_9 FROM sections t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.slug AS slug_4,
  t0.created_at AS created_at_5,
  t0.published AS published_6,
  t0.content AS content_7,
  t0.excerpt AS excerpt_8,
  t0.user_id AS user_id_9
FROM
  sections t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.published AS published_6, t0.content AS content_7, t0.excerpt AS excerpt_8, t0.user_id AS user_id_9 FROM sections t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\Section::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Section->__get (line 90)
8	App\Entity\Section->getSlug (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 289)
10	__TwigTemplate_d62e19199ea47108df0f2fff3e122a0f->block_body (line 430)
11	Twig\Template->yieldBlock (line 174)
12	__TwigTemplate_94bf437f32085399a2a906d0254dd966->doDisplay (line 360)
13	Twig\Template->yield (line 234)
14	__TwigTemplate_d62e19199ea47108df0f2fff3e122a0f->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1080)
22	App\Controller\ChapterController->chapter (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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\Chapter	No errors.
App\Entity\User	No errors.
App\Entity\Module	No errors.
App\Entity\ChapterLogs	No errors.
App\Entity\Theme	No errors.
App\Entity\Test	No errors.
App\Entity\Badge	No errors.
App\Entity\Question	No errors.
App\Entity\Score	No errors.
App\Entity\TestLog	No errors.
App\Entity\Section	No errors.

Symfony Profiler

GET https://ersteznali.m1.rs/poglavlje/bilans-stanja

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping