Symfony Profiler

Query Metrics

10 Database Queries

9 Different statements

90.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

83.33 ms
(91.93%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.last_modified AS last_modified_3, t0.enabled AS enabled_4 FROM sitemap_url t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "https://xm7.skiyurt.kg/lesson/view/18/2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.last_modified AS last_modified_3,
  t0.enabled AS enabled_4
FROM
  sitemap_url t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.last_modified AS last_modified_3, t0.enabled AS enabled_4 FROM sitemap_url t0 WHERE t0.url = 'https://xm7.skiyurt.kg/lesson/view/18/2' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 21)
5	App\Repository\SitemapUrlRepository->findOrCreate (line 37)
6	App\EventListener\SitemapListener->onKernelRequest (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
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)

1.35 ms
(1.49%)

SELECT t0.id AS id_1, t0.sysname AS sysname_2, t0.sysaval AS sysaval_3 FROM seo_settings t0 WHERE t0.sysname = ? LIMIT 1

Parameters:

[
  "ym"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sysname AS sysname_2,
  t0.sysaval AS sysaval_3
FROM
  seo_settings t0
WHERE
  t0.sysname = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sysname AS sysname_2, t0.sysaval AS sysaval_3 FROM seo_settings t0 WHERE t0.sysname = 'ym' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 21)
5	App\Twig\Components\YandexMetric->getCode (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 48)
7	__TwigTemplate_0938df4785370847f0f5372d59f14340->doDisplay (line 388)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 91)
14	__TwigTemplate_22dd32119cdac3b49026e09a641eb0e8->doDisplay (line 388)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_4c1bc0cc93b6be70ef5b95a74e5ddae1->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
25	App\Controller\LessonController->lessonOpen (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.22 ms
(1.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.enable_announce AS enable_announce_4, t0.published AS published_5, t0.icon AS icon_6, t0.editable AS editable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sysname AS sysname_10, t0.announce_text AS announce_text_11, t0.route AS route_12, t0.options AS options_13 FROM section t0 WHERE t0.sysname = ? LIMIT 1

Parameters:

[
  "lessons"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.enable_announce AS enable_announce_4,
  t0.published AS published_5,
  t0.icon AS icon_6,
  t0.editable AS editable_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.sysname AS sysname_10,
  t0.announce_text AS announce_text_11,
  t0.route AS route_12,
  t0.options AS options_13
FROM
  section t0
WHERE
  t0.sysname = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.enable_announce AS enable_announce_4, t0.published AS published_5, t0.icon AS icon_6, t0.editable AS editable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sysname AS sysname_10, t0.announce_text AS announce_text_11, t0.route AS route_12, t0.options AS options_13 FROM section t0 WHERE t0.sysname = 'lessons' LIMIT 1;

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

1.10 ms
(1.21%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.announce AS announce_3, t0.edufield_id AS edufield_id_4, t0.scholar_class_id AS scholar_class_id_5 FROM edu_field_classes t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.announce AS announce_3,
  t0.edufield_id AS edufield_id_4,
  t0.scholar_class_id AS scholar_class_id_5
FROM
  edu_field_classes t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.announce AS announce_3, t0.edufield_id AS edufield_id_4, t0.scholar_class_id AS scholar_class_id_5 FROM edu_field_classes t0 WHERE t0.id = 2 LIMIT 1;

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

0.89 ms
(0.98%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.published AS published_4, t0.icon AS icon_5, t0.media_files AS media_files_6 FROM lesson t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  18
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.published AS published_4,
  t0.icon AS icon_5,
  t0.media_files AS media_files_6
FROM
  lesson t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.published AS published_4, t0.icon AS icon_5, t0.media_files AS media_files_6 FROM lesson t0 WHERE t0.id = 18 LIMIT 1;

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

0.81 ms
(0.89%)

SELECT t0.id AS id_1, t0.announce AS announce_2, t0.edu_field_class_id AS edu_field_class_id_3, t0.lesson_id AS lesson_id_4 FROM edu_field_classes_lessons t0 WHERE t0.edu_field_class_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.announce AS announce_2,
  t0.edu_field_class_id AS edu_field_class_id_3,
  t0.lesson_id AS lesson_id_4
FROM
  edu_field_classes_lessons t0
WHERE
  t0.edu_field_class_id = ?

SELECT t0.id AS id_1, t0.announce AS announce_2, t0.edu_field_class_id AS edu_field_class_id_3, t0.lesson_id AS lesson_id_4 FROM edu_field_classes_lessons t0 WHERE t0.edu_field_class_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 117)
8	App\Controller\LessonController->lessonOpen (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.71 ms
(0.79%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5 FROM seo_meta t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "/lesson/view/18/2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.keywords AS keywords_5
FROM
  seo_meta t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5 FROM seo_meta t0 WHERE t0.url = '/lesson/view/18/2' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 21)
5	App\Repository\SeoMetaRepository->findOrCreate (line 24)
6	App\Service\SeoService->getSeoData (line 130)
7	App\Controller\LessonController->lessonOpen (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.66 ms
(0.73%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.description AS description_4, t0.published AS published_5, t0.sort AS sort_6 FROM edu_field t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.description AS description_4,
  t0.published AS published_5,
  t0.sort AS sort_6
FROM
  edu_field t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.description AS description_4, t0.published AS published_5, t0.sort AS sort_6 FROM edu_field t0 WHERE t0.id = 4;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\EduField::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\EduField->__get (line 53)
8	App\Entity\EduField->getName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 107)
10	__TwigTemplate_4c1bc0cc93b6be70ef5b95a74e5ddae1->block_body (line 432)
11	Twig\Template->yieldBlock (line 99)
12	__TwigTemplate_22dd32119cdac3b49026e09a641eb0e8->doDisplay (line 388)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_4c1bc0cc93b6be70ef5b95a74e5ddae1->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
23	App\Controller\LessonController->lessonOpen (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.58 ms
(0.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.published AS published_4 FROM scholar_class t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.published AS published_4
FROM
  scholar_class t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.published AS published_4 FROM scholar_class t0 WHERE t0.id = 2;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\ScholarClass::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\ScholarClass->__get (line 32)
8	App\Entity\ScholarClass->getName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 109)
10	__TwigTemplate_4c1bc0cc93b6be70ef5b95a74e5ddae1->block_body (line 432)
11	Twig\Template->yieldBlock (line 99)
12	__TwigTemplate_22dd32119cdac3b49026e09a641eb0e8->doDisplay (line 388)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_4c1bc0cc93b6be70ef5b95a74e5ddae1->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 125)
23	App\Controller\LessonController->lessonOpen (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\SitemapUrl	No errors.
App\Entity\Section	No errors.
App\Entity\EduFieldClasses	No errors.
App\Entity\EduField	No errors.
App\Entity\ScholarClass	No errors.
App\Entity\EduFieldClassesLessons	No errors.
App\Entity\Lesson	No errors.
App\Entity\SeoMeta	No errors.
App\Entity\SeoSettings	No errors.

Symfony Profiler

GET https://xm7.skiyurt.kg/lesson/view/18/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping