Symfony Profiler

Query Metrics

8 Database Queries

7 Different statements

4.45 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.25 ms
(28.05%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.seo_title AS seo_title_5, b0_.seo_description AS seo_description_6, b0_.external_id AS external_id_7, b0_.seo_json AS seo_json_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.sources AS sources_11, b0_.active AS active_12, b0_.publish_at AS publish_at_13, b0_.deleted_at AS deleted_at_14, b1_.id AS id_15, b1_.title AS title_16, b1_.slug AS slug_17 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b1_.slug = ? AND b0_.active = ? ORDER BY b0_.created_at DESC

Parameters:

[
  "depresja"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.excerpt AS excerpt_3,
  b0_.content AS content_4,
  b0_.seo_title AS seo_title_5,
  b0_.seo_description AS seo_description_6,
  b0_.external_id AS external_id_7,
  b0_.seo_json AS seo_json_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.sources AS sources_11,
  b0_.active AS active_12,
  b0_.publish_at AS publish_at_13,
  b0_.deleted_at AS deleted_at_14,
  b1_.id AS id_15,
  b1_.title AS title_16,
  b1_.slug AS slug_17
FROM
  blog_post b0_
  INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id
  INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id
WHERE
  b1_.slug = ?
  AND b0_.active = ?
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.seo_title AS seo_title_5, b0_.seo_description AS seo_description_6, b0_.external_id AS external_id_7, b0_.seo_json AS seo_json_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.sources AS sources_11, b0_.active AS active_12, b0_.publish_at AS publish_at_13, b0_.deleted_at AS deleted_at_14, b1_.id AS id_15, b1_.title AS title_16, b1_.slug AS slug_17 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b1_.slug = 'depresja' AND b0_.active = 1 ORDER BY b0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 50)
7	App\Controller\Site\AfflictionController->affliction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.88 ms
(19.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.email AS email_4, t0.email_title AS email_title_5, t0.email_title_sick_leave AS email_title_sick_leave_6, t0.logo_url AS logo_url_7, t0.faq_url AS faq_url_8, t0.contact_url AS contact_url_9, t0.rule_url AS rule_url_10, t0.privacy_policy_url AS privacy_policy_url_11, t0.sms_sender AS sms_sender_12, t0.sms_content AS sms_content_13, t0.url AS url_14, t0.has_refund AS has_refund_15, t0.slug AS slug_16, t0.iframe_head_text AS iframe_head_text_17, t0.iframe_top_text AS iframe_top_text_18, t0.hash AS hash_19, t0.virtual_ AS virtual__20, t0.redirect AS redirect_21, t0.default_api_state AS default_api_state_22, t0.show_top_bar AS show_top_bar_23, t0.top_bar_message AS top_bar_message_24, t0.top_bar_bg_color AS top_bar_bg_color_25, t0.top_bar_text_color AS top_bar_text_color_26, t0.api AS api_27, t0.logo_id AS logo_id_28 FROM site t0 WHERE t0.id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.token AS token_3,
  t0.email AS email_4,
  t0.email_title AS email_title_5,
  t0.email_title_sick_leave AS email_title_sick_leave_6,
  t0.logo_url AS logo_url_7,
  t0.faq_url AS faq_url_8,
  t0.contact_url AS contact_url_9,
  t0.rule_url AS rule_url_10,
  t0.privacy_policy_url AS privacy_policy_url_11,
  t0.sms_sender AS sms_sender_12,
  t0.sms_content AS sms_content_13,
  t0.url AS url_14,
  t0.has_refund AS has_refund_15,
  t0.slug AS slug_16,
  t0.iframe_head_text AS iframe_head_text_17,
  t0.iframe_top_text AS iframe_top_text_18,
  t0.hash AS hash_19,
  t0.virtual_ AS virtual__20,
  t0.redirect AS redirect_21,
  t0.default_api_state AS default_api_state_22,
  t0.show_top_bar AS show_top_bar_23,
  t0.top_bar_message AS top_bar_message_24,
  t0.top_bar_bg_color AS top_bar_bg_color_25,
  t0.top_bar_text_color AS top_bar_text_color_26,
  t0.api AS api_27,
  t0.logo_id AS logo_id_28
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.email AS email_4, t0.email_title AS email_title_5, t0.email_title_sick_leave AS email_title_sick_leave_6, t0.logo_url AS logo_url_7, t0.faq_url AS faq_url_8, t0.contact_url AS contact_url_9, t0.rule_url AS rule_url_10, t0.privacy_policy_url AS privacy_policy_url_11, t0.sms_sender AS sms_sender_12, t0.sms_content AS sms_content_13, t0.url AS url_14, t0.has_refund AS has_refund_15, t0.slug AS slug_16, t0.iframe_head_text AS iframe_head_text_17, t0.iframe_top_text AS iframe_top_text_18, t0.hash AS hash_19, t0.virtual_ AS virtual__20, t0.redirect AS redirect_21, t0.default_api_state AS default_api_state_22, t0.show_top_bar AS show_top_bar_23, t0.top_bar_message AS top_bar_message_24, t0.top_bar_bg_color AS top_bar_bg_color_25, t0.top_bar_text_color AS top_bar_text_color_26, t0.api AS api_27, t0.logo_id AS logo_id_28 FROM site t0 WHERE t0.id = '3';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 154)
6	App\EventSubscriber\RequestSubscriber->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.80 ms
(17.90%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.page_title AS page_title_2, a0_.slug AS slug_3, a0_.excerpt AS excerpt_4, a0_.content AS content_5, a0_.seo_title AS seo_title_6, a0_.seo_description AS seo_description_7, a0_.accusative AS accusative_8, a0_.sources AS sources_9, a0_.icon_id AS icon_id_10, a0_.thumbnail_id AS thumbnail_id_11, a0_.category_id AS category_id_12 FROM affliction a0_ LEFT JOIN affliction_translation a1_ ON a0_.id = a1_.translatable_id WHERE a1_.slug = ? AND a1_.locale = ?

Parameters:

[
  "depresja"
  "pl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.page_title AS page_title_2,
  a0_.slug AS slug_3,
  a0_.excerpt AS excerpt_4,
  a0_.content AS content_5,
  a0_.seo_title AS seo_title_6,
  a0_.seo_description AS seo_description_7,
  a0_.accusative AS accusative_8,
  a0_.sources AS sources_9,
  a0_.icon_id AS icon_id_10,
  a0_.thumbnail_id AS thumbnail_id_11,
  a0_.category_id AS category_id_12
FROM
  affliction a0_
  LEFT JOIN affliction_translation a1_ ON a0_.id = a1_.translatable_id
WHERE
  a1_.slug = ?
  AND a1_.locale = ?

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.page_title AS page_title_2, a0_.slug AS slug_3, a0_.excerpt AS excerpt_4, a0_.content AS content_5, a0_.seo_title AS seo_title_6, a0_.seo_description AS seo_description_7, a0_.accusative AS accusative_8, a0_.sources AS sources_9, a0_.icon_id AS icon_id_10, a0_.thumbnail_id AS thumbnail_id_11, a0_.category_id AS category_id_12 FROM affliction a0_ LEFT JOIN affliction_translation a1_ ON a0_.id = a1_.translatable_id WHERE a1_.slug = 'depresja' AND a1_.locale = 'pl';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 71)
7	App\Repository\AfflictionRepository->findOneBySlug (line 34)
8	App\Controller\Site\AfflictionController->affliction (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 73)

0.56 ms
(12.64%)

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM faq_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  189
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.answer AS answer_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  faq_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM faq_translation t0 WHERE t0.translatable_id = 189;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
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 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Faq->findTranslationByLocale (line 138)
10	App\Entity\Faq->doTranslate (line 75)
11	App\Entity\Faq->translate (line 148)
12	App\Entity\Faq->getQuestion (line 1882)
13	Twig\Extension\CoreExtension::getAttribute (line 83)
14	__TwigTemplate_bcd90d515afb179559d33cf843b234bc->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 30)
20	App\Service\TextRenderService->faqsShortcode (line 54)
21	App\Controller\Site\AfflictionController->affliction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.37 ms
(8.24%)

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.position AS position_4, t0.app AS app_5, t0.service_id AS service_id_6, t0.specialization_id AS specialization_id_7, t0.product_text_id AS product_text_id_8, t0.affliction_id AS affliction_id_9, t0.blog_post_id AS blog_post_id_10, t0.package_id AS package_id_11, t0.lab_examination_id AS lab_examination_id_12, t0.lab_examination_group_id AS lab_examination_group_id_13 FROM faq t0 WHERE t0.affliction_id = ? ORDER BY t0.position ASC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.answer AS answer_3,
  t0.position AS position_4,
  t0.app AS app_5,
  t0.service_id AS service_id_6,
  t0.specialization_id AS specialization_id_7,
  t0.product_text_id AS product_text_id_8,
  t0.affliction_id AS affliction_id_9,
  t0.blog_post_id AS blog_post_id_10,
  t0.package_id AS package_id_11,
  t0.lab_examination_id AS lab_examination_id_12,
  t0.lab_examination_group_id AS lab_examination_group_id_13
FROM
  faq t0
WHERE
  t0.affliction_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.position AS position_4, t0.app AS app_5, t0.service_id AS service_id_6, t0.specialization_id AS specialization_id_7, t0.product_text_id AS product_text_id_8, t0.affliction_id AS affliction_id_9, t0.blog_post_id AS blog_post_id_10, t0.package_id AS package_id_11, t0.lab_examination_id AS lab_examination_id_12, t0.lab_examination_group_id AS lab_examination_group_id_13 FROM faq t0 WHERE t0.affliction_id = 13 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 62)
9	__TwigTemplate_bcd90d515afb179559d33cf843b234bc->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 334)
14	Twig\Environment->render (line 30)
15	App\Service\TextRenderService->faqsShortcode (line 54)
16	App\Controller\Site\AfflictionController->affliction (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.30 ms
(6.76%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.accusative AS accusative_9, t0.genitive AS genitive_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12 FROM affliction_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.page_title AS page_title_3,
  t0.slug AS slug_4,
  t0.excerpt AS excerpt_5,
  t0.content AS content_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8,
  t0.accusative AS accusative_9,
  t0.genitive AS genitive_10,
  t0.locale AS locale_11,
  t0.translatable_id AS translatable_id_12
FROM
  affliction_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.page_title AS page_title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.accusative AS accusative_9, t0.genitive AS genitive_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12 FROM affliction_translation t0 WHERE t0.translatable_id = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
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 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 445)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Affliction->findTranslationByLocale (line 138)
10	App\Entity\Affliction->doTranslate (line 75)
11	App\Entity\Affliction->translate (line 179)
12	App\Entity\Affliction->proxyCurrentLocaleTranslation (line 19)
13	App\Entity\Affliction->__call (line 54)
14	App\Controller\Site\AfflictionController->affliction (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.30 ms
(6.71%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM blog_category t0 WHERE t0.id = ?

Parameters:

[
  8
]

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
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM blog_category t0 WHERE t0.id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\BlogCategory::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\BlogCategory->__get (line 80)
8	App\Entity\BlogCategory->getSlug (line 46)
9	App\Controller\Site\AfflictionController->affliction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 73)

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\Site	No errors.
App\Entity\File	No errors.
App\Entity\Service	The association App\Entity\Service#banners refers to the owning side field App\Entity\Banner#service which does not exist.
App\Entity\PriceRate	No errors.
App\Entity\Discount	No errors.
App\Entity\Chat	No errors.
App\Entity\Opinion	No errors.
App\Entity\Embeddable\RegLegal	No errors.
App\Entity\User	No errors.
App\Entity\Affliction	No errors.
App\Entity\Translation\AfflictionTranslation	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\Product	No errors.
App\Entity\Faq	No errors.
App\Entity\BlogPost	No errors.
App\Entity\Specialization	No errors.
App\Entity\ProductText	No errors.
App\Entity\Package	No errors.
App\Entity\LabExamination	No errors.
App\Entity\LabExaminationGroup	No errors.
App\Entity\Translation\FaqTranslation	No errors.

Symfony Profiler

GET https://dev.e-recepta.net/_fragment?_path=_format%3Dhtml%26_locale%3Dpl%26_controller%3DApp%255CController%255CSite%255CPageController%253A%253AgetTopSiteHeader…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping