Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

5.05 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

5.05 ms
(100.00%)

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_continuous AS is_continuous_2, c0_.is_medical_product AS is_medical_product_3, c0_.position AS position_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.short_body AS short_body_7, c0_.difficulty AS difficulty_8, c0_.start_date AS start_date_9, c0_.hide_date AS hide_date_10, c0_.deactivation_date AS deactivation_date_11, c0_.duration AS duration_12, c0_.action_number AS action_number_13, c0_.from_source AS from_source_14, c0_.products_for_cos AS products_for_cos_15, c0_.redirect_to_url AS redirect_to_url_16, c0_.gos_id AS gos_id_17, c0_.certificate_gos_id AS certificate_gos_id_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.seo_keywords AS seo_keywords_21, c0_.seo_meta_title AS seo_meta_title_22, c0_.seo_meta_description AS seo_meta_description_23, c0_.seo_is_no_index AS seo_is_no_index_24, c0_.beacon_name AS beacon_name_25, c0_.type AS type_26, c0_.category_id AS category_id_27, c0_.image_id AS image_id_28, c0_.created_by_id AS created_by_id_29, c0_.updated_by_id AS updated_by_id_30 FROM course c0_ WHERE (c0_.slug = ?) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') LIMIT 1

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.is_active AS is_active_1,
  c0_.is_continuous AS is_continuous_2,
  c0_.is_medical_product AS is_medical_product_3,
  c0_.position AS position_4,
  c0_.name AS name_5,
  c0_.slug AS slug_6,
  c0_.short_body AS short_body_7,
  c0_.difficulty AS difficulty_8,
  c0_.start_date AS start_date_9,
  c0_.hide_date AS hide_date_10,
  c0_.deactivation_date AS deactivation_date_11,
  c0_.duration AS duration_12,
  c0_.action_number AS action_number_13,
  c0_.from_source AS from_source_14,
  c0_.products_for_cos AS products_for_cos_15,
  c0_.redirect_to_url AS redirect_to_url_16,
  c0_.gos_id AS gos_id_17,
  c0_.certificate_gos_id AS certificate_gos_id_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.seo_keywords AS seo_keywords_21,
  c0_.seo_meta_title AS seo_meta_title_22,
  c0_.seo_meta_description AS seo_meta_description_23,
  c0_.seo_is_no_index AS seo_is_no_index_24,
  c0_.beacon_name AS beacon_name_25,
  c0_.type AS type_26,
  c0_.category_id AS category_id_27,
  c0_.image_id AS image_id_28,
  c0_.created_by_id AS created_by_id_29,
  c0_.updated_by_id AS updated_by_id_30
FROM
  course c0_
WHERE
  (c0_.slug = ?)
  AND c0_.type IN (
    'academy', 'future_degree', 'webinar',
    'no_front'
  )
LIMIT
  1

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_continuous AS is_continuous_2, c0_.is_medical_product AS is_medical_product_3, c0_.position AS position_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.short_body AS short_body_7, c0_.difficulty AS difficulty_8, c0_.start_date AS start_date_9, c0_.hide_date AS hide_date_10, c0_.deactivation_date AS deactivation_date_11, c0_.duration AS duration_12, c0_.action_number AS action_number_13, c0_.from_source AS from_source_14, c0_.products_for_cos AS products_for_cos_15, c0_.redirect_to_url AS redirect_to_url_16, c0_.gos_id AS gos_id_17, c0_.certificate_gos_id AS certificate_gos_id_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.seo_keywords AS seo_keywords_21, c0_.seo_meta_title AS seo_meta_title_22, c0_.seo_meta_description AS seo_meta_description_23, c0_.seo_is_no_index AS seo_is_no_index_24, c0_.beacon_name AS beacon_name_25, c0_.type AS type_26, c0_.category_id AS category_id_27, c0_.image_id AS image_id_28, c0_.created_by_id AS created_by_id_29, c0_.updated_by_id AS updated_by_id_30 FROM course c0_ WHERE (c0_.slug = '4') AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Education\Course\CourseRepository->findOneBySlug (line 193)
7	App\Request\ParamConverter\CourseParamConverter->resolve (line 34)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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

gos entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Seo\Seo	No errors.
App\Entity\Education\Course\Course	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\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\Education\Course\CourseImage	No errors.
App\Entity\User\User	No errors.
App\Entity\User\Admin	No errors.
App\Entity\Education\Module\Module	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSection	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\Category\CategoryImage	No errors.
App\Entity\Category\CategoryDesktopBanner	No errors.
App\Entity\Category\CategoryMobileBanner	No errors.
App\Entity\User\Client	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/medycyna/dietetyka-kliniczna/4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

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