Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.95 ms Query time

2 Invalid entities

2297 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.43 ms
(48.39%)

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.63 ms
(21.51%)

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.lab_external_id AS lab_external_id_3, t0.external_url AS external_url_4, t0.google_url AS google_url_5, t0.name AS name_6, t0.type AS type_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.phone1 AS phone1_10, t0.phone2 AS phone2_11, t0.email1 AS email1_12, t0.email2 AS email2_13, t0.description AS description_14, t0.description_working_hours AS description_working_hours_15, t0.description_location AS description_location_16, t0.at_id AS at_id_17, t0.nfz_phone1 AS nfz_phone1_18, t0.nfz_phone2 AS nfz_phone2_19, t0.ks_id AS ks_id_20, t0.working_day_notes AS working_day_notes_21, t0.saturday_notes AS saturday_notes_22, t0.sunday_notes AS sunday_notes_23, t0.working_day_material_collection_until AS working_day_material_collection_until_24, t0.saturday_material_collection_until AS saturday_material_collection_until_25, t0.sunday_material_collection_until AS sunday_material_collection_until_26, t0.open24_hours AS open24_hours_27, t0.open24_hours_restrictions AS open24_hours_restrictions_28, t0.poz AS poz_29, t0.active AS active_30, t0.description_working_hours_short AS description_working_hours_short_31, t0.postal_code AS postal_code_32, t0.city AS city_33, t0.street AS street_34, t0.building_number AS building_number_35, t0.local_number AS local_number_36, t0.voivodeship AS voivodeship_37, t0.commune AS commune_38, t0.district AS district_39, t0.country AS country_40, t0.census_tract AS census_tract_41, t0.logo_id AS logo_id_42, t0.photo_id AS photo_id_43, t0.photo2_id AS photo2_id_44 FROM institution t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.lab_external_id AS lab_external_id_3,
  t0.external_url AS external_url_4,
  t0.google_url AS google_url_5,
  t0.name AS name_6,
  t0.type AS type_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.phone1 AS phone1_10,
  t0.phone2 AS phone2_11,
  t0.email1 AS email1_12,
  t0.email2 AS email2_13,
  t0.description AS description_14,
  t0.description_working_hours AS description_working_hours_15,
  t0.description_location AS description_location_16,
  t0.at_id AS at_id_17,
  t0.nfz_phone1 AS nfz_phone1_18,
  t0.nfz_phone2 AS nfz_phone2_19,
  t0.ks_id AS ks_id_20,
  t0.working_day_notes AS working_day_notes_21,
  t0.saturday_notes AS saturday_notes_22,
  t0.sunday_notes AS sunday_notes_23,
  t0.working_day_material_collection_until AS working_day_material_collection_until_24,
  t0.saturday_material_collection_until AS saturday_material_collection_until_25,
  t0.sunday_material_collection_until AS sunday_material_collection_until_26,
  t0.open24_hours AS open24_hours_27,
  t0.open24_hours_restrictions AS open24_hours_restrictions_28,
  t0.poz AS poz_29,
  t0.active AS active_30,
  t0.description_working_hours_short AS description_working_hours_short_31,
  t0.postal_code AS postal_code_32,
  t0.city AS city_33,
  t0.street AS street_34,
  t0.building_number AS building_number_35,
  t0.local_number AS local_number_36,
  t0.voivodeship AS voivodeship_37,
  t0.commune AS commune_38,
  t0.district AS district_39,
  t0.country AS country_40,
  t0.census_tract AS census_tract_41,
  t0.logo_id AS logo_id_42,
  t0.photo_id AS photo_id_43,
  t0.photo2_id AS photo2_id_44
FROM
  institution t0

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.lab_external_id AS lab_external_id_3, t0.external_url AS external_url_4, t0.google_url AS google_url_5, t0.name AS name_6, t0.type AS type_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.phone1 AS phone1_10, t0.phone2 AS phone2_11, t0.email1 AS email1_12, t0.email2 AS email2_13, t0.description AS description_14, t0.description_working_hours AS description_working_hours_15, t0.description_location AS description_location_16, t0.at_id AS at_id_17, t0.nfz_phone1 AS nfz_phone1_18, t0.nfz_phone2 AS nfz_phone2_19, t0.ks_id AS ks_id_20, t0.working_day_notes AS working_day_notes_21, t0.saturday_notes AS saturday_notes_22, t0.sunday_notes AS sunday_notes_23, t0.working_day_material_collection_until AS working_day_material_collection_until_24, t0.saturday_material_collection_until AS saturday_material_collection_until_25, t0.sunday_material_collection_until AS sunday_material_collection_until_26, t0.open24_hours AS open24_hours_27, t0.open24_hours_restrictions AS open24_hours_restrictions_28, t0.poz AS poz_29, t0.active AS active_30, t0.description_working_hours_short AS description_working_hours_short_31, t0.postal_code AS postal_code_32, t0.city AS city_33, t0.street AS street_34, t0.building_number AS building_number_35, t0.local_number AS local_number_36, t0.voivodeship AS voivodeship_37, t0.commune AS commune_38, t0.district AS district_39, t0.country AS country_40, t0.census_tract AS census_tract_41, t0.logo_id AS logo_id_42, t0.photo_id AS photo_id_43, t0.photo2_id AS photo2_id_44 FROM institution t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 55)
5	App\Controller\Site\PageController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.27 ms
(9.09%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.external_id AS external_id_8, t0.seo_json AS seo_json_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sources AS sources_12, t0.active AS active_13, t0.publish_at AS publish_at_14, t0.deleted_at AS deleted_at_15, t0.thumbnail_id AS thumbnail_id_16, t0.user_id AS user_id_17 FROM blog_post t0 WHERE t0.active = ? ORDER BY t0.publish_at DESC LIMIT 4

Parameters:

[
  1
]

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,
  t0.excerpt AS excerpt_4,
  t0.content AS content_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.external_id AS external_id_8,
  t0.seo_json AS seo_json_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.sources AS sources_12,
  t0.active AS active_13,
  t0.publish_at AS publish_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.thumbnail_id AS thumbnail_id_16,
  t0.user_id AS user_id_17
FROM
  blog_post t0
WHERE
  t0.active = ?
ORDER BY
  t0.publish_at DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.external_id AS external_id_8, t0.seo_json AS seo_json_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sources AS sources_12, t0.active AS active_13, t0.publish_at AS publish_at_14, t0.deleted_at AS deleted_at_15, t0.thumbnail_id AS thumbnail_id_16, t0.user_id AS user_id_17 FROM blog_post t0 WHERE t0.active = 1 ORDER BY t0.publish_at DESC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 50)
4	App\Controller\Site\PageController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.23 ms
(7.81%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.cta_text AS cta_text_4, t0.link AS link_5, t0.position AS position_6, t0.image_id AS image_id_7 FROM box t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.cta_text AS cta_text_4,
  t0.link AS link_5,
  t0.position AS position_6,
  t0.image_id AS image_id_7
FROM
  box t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.cta_text AS cta_text_4, t0.link AS link_5, t0.position AS position_6, t0.image_id AS image_id_7 FROM box t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 51)
4	App\Controller\Site\PageController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.22 ms
(7.33%)

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.type AS type_6, t0.gender_requirements AS gender_requirements_7, t0.max_age AS max_age_8, t0.comparison AS comparison_9, t0.short_description AS short_description_10, t0.alt_name AS alt_name_11, t0.image_id AS image_id_12 FROM package t0 WHERE t0.status = ?

Parameters:

[
  "ACTIVE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.status AS status_5,
  t0.type AS type_6,
  t0.gender_requirements AS gender_requirements_7,
  t0.max_age AS max_age_8,
  t0.comparison AS comparison_9,
  t0.short_description AS short_description_10,
  t0.alt_name AS alt_name_11,
  t0.image_id AS image_id_12
FROM
  package t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.type AS type_6, t0.gender_requirements AS gender_requirements_7, t0.max_age AS max_age_8, t0.comparison AS comparison_9, t0.short_description AS short_description_10, t0.alt_name AS alt_name_11, t0.image_id AS image_id_12 FROM package t0 WHERE t0.status = 'ACTIVE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 52)
4	App\Controller\Site\PageController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 73)

0.17 ms
(5.87%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total_price AS total_price_4, t0.position AS position_5, t0.image_id AS image_id_6 FROM lab_examination_group t0

Parameters:

[]

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.total_price AS total_price_4,
  t0.position AS position_5,
  t0.image_id AS image_id_6
FROM
  lab_examination_group t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total_price AS total_price_4, t0.position AS position_5, t0.image_id AS image_id_6 FROM lab_examination_group t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 53)
4	App\Controller\Site\PageController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Institution	2202
App\Entity\File	51
App\Entity\Package	30
App\Entity\LabExaminationGroup	7
App\Entity\BlogPost	4
App\Entity\User	2
App\Entity\Site	1

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\BlogPost	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\BlogTag	No errors.
App\Entity\BlogPostComment	No errors.
App\Entity\BlogCustomLink	No errors.
App\Entity\DoctorSpecialization	No errors.
App\Entity\Faq	No errors.
App\Entity\Box	No errors.
App\Entity\Package	No errors.
App\Entity\SubPackage	No errors.
App\Entity\PackageTextPart	No errors.
App\Entity\LabExaminationGroup	No errors.
App\Entity\LabExaminationItem	No errors.
App\Entity\OrderItem	No errors.
App\Entity\LabExaminationTextPart	No errors.
App\Entity\LabExaminationResult	No errors.
App\Entity\LabExaminationGroupPrice	No errors.
App\Entity\Institution	The mappings App\Entity\Institution#logo and App\Entity\File#institution are inconsistent with each other. The mappings App\Entity\Institution#photo2 and App\Entity\File#institution are inconsistent with each other.
App\Entity\InstitutionWorkingHour	No errors.
App\Entity\Cell	No errors.
App\Entity\SubPackageInstitutionPrice	No errors.
App\Entity\Order	No errors.
App\Entity\Declaration	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

Managed Entities

default entity manager

Entities Mapping