Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

1.88 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

1.03 ms

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Biznes"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug = 'Biznes' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.86 ms

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  course_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug = '4' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
gos	doctrine.dbal.gos_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
gos	doctrine.orm.gos_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Education\Category\Category	1
App\Entity\User\User	1

gos entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Category\BaseCategory	No errors.
App\Entity\Education\Category\Category	No errors.
App\Entity\File\File	No errors.
App\Entity\File\ImageFile	No errors.
App\Entity\Category\CategoryImage	No errors.
App\Entity\Category\CategoryDesktopBanner	No errors.
App\Entity\Category\CategoryMobileBanner	No errors.
App\Entity\User\User	No errors.
App\Entity\User\Admin	No errors.
App\Entity\Seo\Seo	No errors.
App\Entity\Education\Course\Course	No errors.
App\Entity\Education\Module\Module	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSection	No errors.
App\Entity\Education\Course\CourseImage	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Education\Test\Test	No errors.
App\Entity\Education\Test\CourseTest	No errors.
App\Entity\Education\Course\UserCourse	No errors.
App\Entity\Access\BaseAccess	No errors.
App\Entity\Education\Course\CourseAccess	No errors.
App\Entity\Education\Course\Price\CoursePrice	No errors.
App\Entity\User\Client	No errors.
App\Entity\Education\Course\AcademyCourse	No errors.
App\Entity\Education\Course\FutureDegreeCourse	No errors.
App\Entity\Education\Course\WebinarCourse	No errors.
App\Entity\Education\Course\NoFrontCourse	No errors.
App\Entity\Education\Lesson\Lesson	No errors.
App\Entity\Education\Test\ModuleTest	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section1Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section2Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section3Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section4Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section5Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section6Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section7Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section8Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section9Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section10aTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section10bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section11Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section11bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section12Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section13Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section14Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section15Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section15bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section16Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section17Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section18Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\SectionHtmlTemplate	No errors.
App\Entity\Partner\PartnerImage	No errors.
App\Entity\Education\Test\LessonTest	No errors.
App\Entity\Education\Test\Question	No errors.
App\Entity\Education\Test\UserTest	No errors.
App\Entity\Order\GosOrder	No errors.
App\Entity\Education\Lesson\UserLesson	No errors.
App\Entity\Education\Course\Price\VariantPrice	No errors.
App\Entity\Education\Course\Price\PackPrice	No errors.
App\Entity\File\AudioFile	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSectionImage	No errors.
App\Entity\Education\Lesson\LessonFile	No errors.
App\Entity\Education\Lesson\DownloadLesson	No errors.
App\Entity\Education\Lesson\LessonAudio	No errors.
App\Entity\Education\Lesson\LessonImage	No errors.
App\Entity\Education\Lesson\QuizLesson	No errors.
App\Entity\Education\Lesson\VideoLesson	No errors.
App\Entity\Education\Lesson\LessonAccess	No errors.
App\Entity\Education\Lesson\AudioLesson	No errors.
App\Entity\Education\Lesson\TextLesson	No errors.
App\Entity\Education\Test\Answer	No errors.
App\Entity\Education\Test\CloseQuestion	No errors.
App\Entity\StaticPage\StaticPage	No errors.
App\Entity\PortalSettings\HomepageLandingSectionImage	No errors.
App\Entity\Social\Social	No errors.
App\Entity\PortalSettings\PortalSettings	No errors.
App\Entity\PortalSettings\HomepageLandingSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\TestimonialSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\CoursesCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\AuthorsCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\PartnersCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\CountersSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\MultiCoursesCarouselSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\KnowledgeBaseSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\PartnersDescriptionSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\HtmlSection	No errors.
App\Entity\PortalSettings\HomepageLandingSections\CategoryCarouselSection	No errors.
App\Entity\PortalSettings\FooterLink\FooterLink	No errors.
App\Entity\User\ClientAvatar	No errors.
App\Entity\Author\Author	No errors.
App\Entity\Author\AuthorImage	No errors.
App\Entity\KnowledgeBase\Category\Category	No errors.
App\Entity\KnowledgeBase\Article\Article	No errors.
App\Entity\KnowledgeBase\Article\AudioArticle	No errors.
App\Entity\KnowledgeBase\Article\ArticleImage	No errors.
App\Entity\KnowledgeBase\Article\VideoArticle	No errors.
App\Entity\KnowledgeBase\Article\ArticleFile	No errors.
App\Entity\KnowledgeBase\Article\TextArticle	No errors.
App\Entity\KnowledgeBase\Article\DownloadArticle	No errors.
App\Entity\KnowledgeBase\Article\ArticleAudio	No errors.
App\Entity\Order\GosOrderParticipant	No errors.
Vich\UploaderBundle\Entity\File	No errors.

gos entity manager

Class	Mapping errors
App\GOS\Entity\PortalSettings	No errors.
App\GOS\Entity\Test	No errors.
App\GOS\Entity\ProductVariant	No errors.
App\GOS\Entity\Answer	No errors.
App\GOS\Entity\UserLesson	No errors.
App\GOS\Entity\Lesson	No errors.
App\GOS\Entity\User	No errors.
App\GOS\Entity\UserTest	No errors.
App\GOS\Entity\Coupon	No errors.
App\GOS\Entity\Certificate	No errors.
App\GOS\Entity\ProductPack	No errors.
App\GOS\Entity\Module	No errors.
App\GOS\Entity\Question	No errors.
App\GOS\Entity\Course	No errors.
App\GOS\Entity\LessonType	No errors.

Symfony Profiler

GET https://2.uniqskills.com/pl/kursy/Biznes/4?duration=2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

gos entity manager

Entities Mapping

default entity manager

gos entity manager