Symfony Profiler

Query Metrics

21 Database Queries

7 Different statements

129.32 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

70.55 ms
(54.56%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.created_at AS created_at_3, p0_.subtitle AS subtitle_4, p0_.content AS content_5, p0_.published AS published_6, p0_.excerpt AS excerpt_7, p0_.show_on_home AS show_on_home_8, p0_.sort_order AS sort_order_9, p0_.image_file_name AS image_file_name_10, p0_.user_id AS user_id_11 FROM pages p0_ WHERE p0_.show_on_home = ? ORDER BY p0_.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.created_at AS created_at_3,
  p0_.subtitle AS subtitle_4,
  p0_.content AS content_5,
  p0_.published AS published_6,
  p0_.excerpt AS excerpt_7,
  p0_.show_on_home AS show_on_home_8,
  p0_.sort_order AS sort_order_9,
  p0_.image_file_name AS image_file_name_10,
  p0_.user_id AS user_id_11
FROM
  pages p0_
WHERE
  p0_.show_on_home = ?
ORDER BY
  p0_.sort_order ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.created_at AS created_at_3, p0_.subtitle AS subtitle_4, p0_.content AS content_5, p0_.published AS published_6, p0_.excerpt AS excerpt_7, p0_.show_on_home AS show_on_home_8, p0_.sort_order AS sort_order_9, p0_.image_file_name AS image_file_name_10, p0_.user_id AS user_id_11 FROM pages p0_ WHERE p0_.show_on_home = 1 ORDER BY p0_.sort_order ASC;

#	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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 86)
7	App\Repository\PageRepository->getHomePagePages (line 132)
8	App\Controller\DefaultController->index (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)

34.44 ms
(26.63%)

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:

[
  1
]

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 = 1;

#	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 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 412)
8	Doctrine\ORM\PersistentCollection->containsKey (line 496)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1560)
10	Twig\Extension\CoreExtension::getAttribute (line 174)
11	__TwigTemplate_698fc2268bdb7ed55b812078c1ea62c5->block_body (line 430)
12	Twig\Template->yieldBlock (line 174)
13	__TwigTemplate_94bf437f32085399a2a906d0254dd966->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_698fc2268bdb7ed55b812078c1ea62c5->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 135)
23	App\Controller\DefaultController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

10.32 ms
(7.98%)

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.copy AS copy_2, t0_.published AS published_3, t0_.slug AS slug_4, t0_.created_at AS created_at_5, t0_.wheel_order AS wheel_order_6, t0_.child_wheel_order AS child_wheel_order_7, t0_.user_id AS user_id_8, t0_.module_id AS module_id_9 FROM tests t0_ WHERE t0_.wheel_order IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.copy AS copy_2,
  t0_.published AS published_3,
  t0_.slug AS slug_4,
  t0_.created_at AS created_at_5,
  t0_.wheel_order AS wheel_order_6,
  t0_.child_wheel_order AS child_wheel_order_7,
  t0_.user_id AS user_id_8,
  t0_.module_id AS module_id_9
FROM
  tests t0_
WHERE
  t0_.wheel_order IS NOT NULL

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.copy AS copy_2, t0_.published AS published_3, t0_.slug AS slug_4, t0_.created_at AS created_at_5, t0_.wheel_order AS wheel_order_6, t0_.child_wheel_order AS child_wheel_order_7, t0_.user_id AS user_id_8, t0_.module_id AS module_id_9 FROM tests t0_ WHERE t0_.wheel_order IS NOT NULL;

#	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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 85)
7	App\Repository\TestRepository->getWheelTests (line 33)
8	App\Controller\DefaultController->index (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)

8.21 ms
(6.35%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.answers AS answers_3, t0.created_at AS created_at_4, t0.published AS published_5, t0.test_id AS test_id_6, t0.user_id AS user_id_7 FROM questions t0 WHERE t0.test_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.answers AS answers_3,
  t0.created_at AS created_at_4,
  t0.published AS published_5,
  t0.test_id AS test_id_6,
  t0.user_id AS user_id_7
FROM
  questions t0
WHERE
  t0.test_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.answers AS answers_3, t0.created_at AS created_at_4, t0.published AS published_5, t0.test_id AS test_id_6, t0.user_id AS user_id_7 FROM questions t0 WHERE t0.test_id = 1;

#	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 59)
8	App\Controller\DefaultController->index (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)

3.24 ms
(2.50%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.roles AS roles_3, t0.verified AS verified_4, t0.agreement AS agreement_5, t0.username AS username_6, t0.email AS email_7, t0.password AS password_8, t0.birthyear AS birthyear_9, t0.residence AS residence_10, t0.last_active AS last_active_11, t0.is_subscribed AS is_subscribed_12 FROM users t0 WHERE t0.id = ?

Parameters:

[
  6022
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.roles AS roles_3,
  t0.verified AS verified_4,
  t0.agreement AS agreement_5,
  t0.username AS username_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.birthyear AS birthyear_9,
  t0.residence AS residence_10,
  t0.last_active AS last_active_11,
  t0.is_subscribed AS is_subscribed_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.roles AS roles_3, t0.verified AS verified_4, t0.agreement AS agreement_5, t0.username AS username_6, t0.email AS email_7, t0.password AS password_8, t0.birthyear AS birthyear_9, t0.residence AS residence_10, t0.last_active AS last_active_11, t0.is_subscribed AS is_subscribed_12 FROM users t0 WHERE t0.id = 6022;

#	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\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\User->__get (line 189)
8	App\Entity\User->getUsername (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 337)
10	__TwigTemplate_698fc2268bdb7ed55b812078c1ea62c5->block_body (line 430)
11	Twig\Template->yieldBlock (line 174)
12	__TwigTemplate_94bf437f32085399a2a906d0254dd966->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_698fc2268bdb7ed55b812078c1ea62c5->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 135)
22	App\Controller\DefaultController->index (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)

1.35 ms
(1.04%)

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.title AS title_2, m0_.slug AS slug_3, m0_.content AS content_4, m0_.published AS published_5, m0_.excerpt AS excerpt_6, m0_.subtitle AS subtitle_7, m0_.show_on_home AS show_on_home_8, m0_.sort_order AS sort_order_9, m0_.image_file_name AS image_file_name_10, m0_.user_id AS user_id_11, m0_.theme_id AS theme_id_12 FROM modules m0_ WHERE m0_.show_on_home = ? ORDER BY m0_.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.created_at AS created_at_1,
  m0_.title AS title_2,
  m0_.slug AS slug_3,
  m0_.content AS content_4,
  m0_.published AS published_5,
  m0_.excerpt AS excerpt_6,
  m0_.subtitle AS subtitle_7,
  m0_.show_on_home AS show_on_home_8,
  m0_.sort_order AS sort_order_9,
  m0_.image_file_name AS image_file_name_10,
  m0_.user_id AS user_id_11,
  m0_.theme_id AS theme_id_12
FROM
  modules m0_
WHERE
  m0_.show_on_home = ?
ORDER BY
  m0_.sort_order ASC

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.title AS title_2, m0_.slug AS slug_3, m0_.content AS content_4, m0_.published AS published_5, m0_.excerpt AS excerpt_6, m0_.subtitle AS subtitle_7, m0_.show_on_home AS show_on_home_8, m0_.sort_order AS sort_order_9, m0_.image_file_name AS image_file_name_10, m0_.user_id AS user_id_11, m0_.theme_id AS theme_id_12 FROM modules m0_ WHERE m0_.show_on_home = 1 ORDER BY m0_.sort_order ASC;

#	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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 110)
7	App\Repository\ModuleRepository->getHomePageModules (line 131)
8	App\Controller\DefaultController->index (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.20 ms
(0.93%)

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.name AS name_2, b0_.level AS level_3, b0_.user_id AS user_id_4, b0_.module_id AS module_id_5, b0_.test_id AS test_id_6, b0_.theme_id AS theme_id_7, b0_.section_id AS section_id_8 FROM badges b0_ ORDER BY b0_.id DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.created_at AS created_at_1,
  b0_.name AS name_2,
  b0_.level AS level_3,
  b0_.user_id AS user_id_4,
  b0_.module_id AS module_id_5,
  b0_.test_id AS test_id_6,
  b0_.theme_id AS theme_id_7,
  b0_.section_id AS section_id_8
FROM
  badges b0_
ORDER BY
  b0_.id DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.name AS name_2, b0_.level AS level_3, b0_.user_id AS user_id_4, b0_.module_id AS module_id_5, b0_.test_id AS test_id_6, b0_.theme_id AS theme_id_7, b0_.section_id AS section_id_8 FROM badges b0_ ORDER BY b0_.id DESC LIMIT 3;

#	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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 49)
7	App\Repository\BadgeRepository->last3Badges (line 38)
8	App\Controller\DefaultController->index (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\Test	No errors.
App\Entity\User	No errors.
App\Entity\Module	No errors.
App\Entity\Question	No errors.
App\Entity\Score	No errors.
App\Entity\TestLog	No errors.
App\Entity\Badge	No errors.
App\Entity\Theme	No errors.
App\Entity\Section	No errors.
App\Entity\Chapter	No errors.
App\Entity\Page	No errors.
App\Entity\ChapterLogs	No errors.
App\Entity\PasswordReset	No errors.
App\Entity\UserChangelog	No errors.
App\Entity\Trivia	No errors.
App\Entity\UserActivity	No errors.

Symfony Profiler

GET https://ersteznali.m1.rs/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping