Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

24.12 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

24.12 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ WHERE (a0_.slug = ?) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 1

Parameters:

[
  "opatrunki na rany"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.is_active AS is_active_3,
  a0_.public_date AS public_date_4,
  a0_.deactivation_date AS deactivation_date_5,
  a0_.hide_date AS hide_date_6,
  a0_.redirect_to_url AS redirect_to_url_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.seo_meta_title AS seo_meta_title_11,
  a0_.seo_meta_description AS seo_meta_description_12,
  a0_.seo_open_graph_title AS seo_open_graph_title_13,
  a0_.seo_open_graph_description AS seo_open_graph_description_14,
  a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15,
  a0_.seo_is_no_index AS seo_is_no_index_16,
  a0_.description AS description_17,
  a0_.description AS description_18,
  a0_.lead AS lead_19,
  a0_.table_of_contents AS table_of_contents_20,
  a0_.content AS content_21,
  a0_.video_url AS video_url_22,
  a0_.description AS description_23,
  a0_.type AS type_24,
  a0_.image_id AS image_id_25,
  a0_.created_by_id AS created_by_id_26,
  a0_.updated_by_id AS updated_by_id_27,
  a0_.audio_id AS audio_id_28,
  a0_.file_id AS file_id_29
FROM
  article a0_
WHERE
  (a0_.slug = ?)
  AND a0_.type IN (
    'audio', 'download', 'text', 'video'
  )
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ WHERE (a0_.slug = 'opatrunki na rany') AND a0_.type IN ('audio', 'download', 'text', 'video') 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\KnowledgeBase\Article\ArticleRepository->findOneBySlug (line 28)
7	App\Request\ParamConverter\ArticleParamConverter->resolve (line 35)
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\KnowledgeBase\Article\Article	No errors.
App\Entity\KnowledgeBase\Article\AudioArticle	No errors.
App\Entity\KnowledgeBase\Article\DownloadArticle	No errors.
App\Entity\KnowledgeBase\Article\TextArticle	No errors.
App\Entity\KnowledgeBase\Article\VideoArticle	No errors.
App\Entity\File\File	No errors.
App\Entity\File\ImageFile	No errors.
App\Entity\KnowledgeBase\Article\ArticleImage	No errors.
App\Entity\User\User	No errors.
App\Entity\User\Admin	No errors.
App\Entity\File\AudioFile	No errors.
App\Entity\KnowledgeBase\Article\ArticleAudio	No errors.
App\Entity\KnowledgeBase\Article\ArticleFile	No errors.
App\Entity\Category\BaseCategory	No errors.
App\Entity\KnowledgeBase\Category\Category	No errors.
App\Entity\Author\Author	No errors.
App\Entity\User\Client	No errors.
App\Entity\Category\CategoryImage	No errors.
App\Entity\Category\CategoryDesktopBanner	No errors.
App\Entity\Category\CategoryMobileBanner	No errors.
App\Entity\Author\AuthorImage	No errors.
App\Entity\Education\Lesson\Lesson	No errors.
App\Entity\Education\Category\Category	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSection	No errors.
App\Entity\Education\CourseLandingSection\CourseLandingSectionImage	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section11bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section17Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section20Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section4Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section15bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section7Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section3Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section10aTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section5Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section14Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section10bTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section2Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section1Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section11Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section18Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section6Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section19Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\SectionHtmlTemplate	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section15Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section13Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section16Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section8Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section12Template	No errors.
App\Entity\Education\CourseLandingSection\Sections\Section9Template	No errors.
App\Entity\Education\Lesson\LessonFile	No errors.
App\Entity\Education\Lesson\UserLesson	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\Access\BaseAccess	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\Module\Module	No errors.
App\Entity\Education\Course\Course	No errors.
App\Entity\Education\Course\AcademyCourse	No errors.
App\Entity\Education\Course\CourseAccess	No errors.
App\Entity\Education\Course\WebinarCourse	No errors.
App\Entity\Education\Course\FavouriteCourse	No errors.
App\Entity\Education\Course\Price\CoursePrice	No errors.
App\Entity\Education\Course\Price\VariantPrice	No errors.
App\Entity\Education\Course\Price\PackPrice	No errors.
App\Entity\Education\Course\NoFrontCourse	No errors.
App\Entity\Education\Course\UserCourse	No errors.
App\Entity\Education\Course\CourseImage	No errors.
App\Entity\Education\Course\FutureDegreeCourse	No errors.
App\Entity\Education\Test\Test	No errors.
App\Entity\Education\Test\Answer	No errors.
App\Entity\Education\Test\Question	No errors.
App\Entity\Education\Test\CloseQuestion	No errors.
App\Entity\Education\Test\UserTest	No errors.
App\Entity\Education\Test\LessonTest	No errors.
App\Entity\Education\Test\ModuleTest	No errors.
App\Entity\Education\Test\CourseTest	No errors.
App\Entity\Education\Survey\Survey	No errors.
App\Entity\Education\Survey\CourseSurvey	No errors.
App\Entity\Education\Survey\SurveySubmission	No errors.
App\Entity\Education\Survey\SurveySubmissionAnswer	No errors.
App\Entity\Education\Survey\ModuleSurvey	No errors.
App\Entity\Education\Survey\Sections\SurveySection	No errors.
App\Entity\Education\Survey\Sections\OpenAnswerSurveySection	No errors.
App\Entity\Education\Survey\Sections\RatingSurveySection	No errors.
App\Entity\Education\Survey\Sections\DetailedScaleSurveySection	No errors.
App\Entity\StaticPage\StaticPage	No errors.
App\Entity\PortalSettings\HomepageLandingSectionImage	No errors.
App\Entity\Social\Social	No errors.
App\Entity\LoginSettings\LoginSettings	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\AiMentor\AiMentorSession	No errors.
App\Entity\AiMentor\AiGeneratedArtifact	No errors.
App\Entity\AiMentor\AiCourseConfig	No errors.
App\Entity\AiMentor\AiVideoKnowledgeCache	No errors.
App\Entity\AiMentor\AiKnowledgeChunk	No errors.
App\Entity\AiMentor\AiKnowledgeSource	No errors.
App\Entity\AiMentor\AiMentorMessage	No errors.
App\Entity\AiMentor\AiAudioKnowledgeCache	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Partner\PartnerImage	No errors.
App\Entity\Order\GosOrderParticipant	No errors.
App\Entity\Order\GosOrder	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/baza-wiedzy/artykuly-medyczne/opatrunki%20na%20rany

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