Query Metrics

13 Database Queries
12 Different statements
72.39 ms Query time
2 Invalid entities
54 Managed entities

Queries

Group similar statements

# Time Info
1 0.91 ms
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"
]
2 0.57 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM blog_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "homocysteina-a-cholesterol"
]
3 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM blog_category t0 ORDER BY t0.title ASC
Parameters:
[]
4 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM blog_tag t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "homocysteina-a-cholesterol"
]
5 2.32 ms
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.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "homocysteina-a-cholesterol"
  1
]
6 0.87 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.hash AS hash_6, t0.deleted_at AS deleted_at_7, t0.reg1 AS reg1_8, t0.reg3 AS reg3_9, t0.reg4 AS reg4_10, t0.reg5 AS reg5_11, t0.password_changed_at AS password_changed_at_12, t0.new_reg AS new_reg_13, t0.first_name AS first_name_14, t0.last_name AS last_name_15, t0.name AS name_16, t0.slug AS slug_17, t0.note AS note_18, t0.facebook_url AS facebook_url_19, t0.linkedin_url AS linkedin_url_20, t0.twitter_url AS twitter_url_21, t0.instagram_url AS instagram_url_22, t0.seo_title AS seo_title_23, t0.seo_description AS seo_description_24, t0.suspended AS suspended_25, t0.wk AS wk_26, t0.wk_attempts AS wk_attempts_27, t0.reg9 AS reg9_28, t0.google_authenticator_secret AS google_authenticator_secret_29, t0.google_authenticator_complete AS google_authenticator_complete_30, t0.reg10 AS reg10_31, t0.reg11 AS reg11_32, t0.wk_auth_status AS wk_auth_status_33, t0.wk_auth_last_attempt AS wk_auth_last_attempt_34, t0.wk_at AS wk_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.reg6_reg AS reg6_reg_38, t0.reg6_first_name AS reg6_first_name_39, t0.reg6_last_name AS reg6_last_name_40, t0.reg6_pesel AS reg6_pesel_41, t0.reg6_no_pesel AS reg6_no_pesel_42, t0.reg6_other_document AS reg6_other_document_43, t0.reg6_other_document_number AS reg6_other_document_number_44, t0.reg7_reg AS reg7_reg_45, t0.reg7_first_name AS reg7_first_name_46, t0.reg7_last_name AS reg7_last_name_47, t0.reg7_pesel AS reg7_pesel_48, t0.reg7_no_pesel AS reg7_no_pesel_49, t0.reg7_other_document AS reg7_other_document_50, t0.reg7_other_document_number AS reg7_other_document_number_51, t0.reg8_reg AS reg8_reg_52, t0.reg8_first_name AS reg8_first_name_53, t0.reg8_last_name AS reg8_last_name_54, t0.reg8_pesel AS reg8_pesel_55, t0.reg8_no_pesel AS reg8_no_pesel_56, t0.reg8_other_document AS reg8_other_document_57, t0.reg8_other_document_number AS reg8_other_document_number_58, t0.group_id AS group_id_59, t0.avatar_id AS avatar_id_60, t0.site_id AS site_id_61, t0.default_doctor_id AS default_doctor_id_62 FROM user t0 WHERE t0.id = ?
Parameters:
[
  26617
]
7 0.39 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.hash AS hash_6, t0.deleted_at AS deleted_at_7, t0.reg1 AS reg1_8, t0.reg3 AS reg3_9, t0.reg4 AS reg4_10, t0.reg5 AS reg5_11, t0.password_changed_at AS password_changed_at_12, t0.new_reg AS new_reg_13, t0.first_name AS first_name_14, t0.last_name AS last_name_15, t0.name AS name_16, t0.slug AS slug_17, t0.note AS note_18, t0.facebook_url AS facebook_url_19, t0.linkedin_url AS linkedin_url_20, t0.twitter_url AS twitter_url_21, t0.instagram_url AS instagram_url_22, t0.seo_title AS seo_title_23, t0.seo_description AS seo_description_24, t0.suspended AS suspended_25, t0.wk AS wk_26, t0.wk_attempts AS wk_attempts_27, t0.reg9 AS reg9_28, t0.google_authenticator_secret AS google_authenticator_secret_29, t0.google_authenticator_complete AS google_authenticator_complete_30, t0.reg10 AS reg10_31, t0.reg11 AS reg11_32, t0.wk_auth_status AS wk_auth_status_33, t0.wk_auth_last_attempt AS wk_auth_last_attempt_34, t0.wk_at AS wk_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.reg6_reg AS reg6_reg_38, t0.reg6_first_name AS reg6_first_name_39, t0.reg6_last_name AS reg6_last_name_40, t0.reg6_pesel AS reg6_pesel_41, t0.reg6_no_pesel AS reg6_no_pesel_42, t0.reg6_other_document AS reg6_other_document_43, t0.reg6_other_document_number AS reg6_other_document_number_44, t0.reg7_reg AS reg7_reg_45, t0.reg7_first_name AS reg7_first_name_46, t0.reg7_last_name AS reg7_last_name_47, t0.reg7_pesel AS reg7_pesel_48, t0.reg7_no_pesel AS reg7_no_pesel_49, t0.reg7_other_document AS reg7_other_document_50, t0.reg7_other_document_number AS reg7_other_document_number_51, t0.reg8_reg AS reg8_reg_52, t0.reg8_first_name AS reg8_first_name_53, t0.reg8_last_name AS reg8_last_name_54, t0.reg8_pesel AS reg8_pesel_55, t0.reg8_no_pesel AS reg8_no_pesel_56, t0.reg8_other_document AS reg8_other_document_57, t0.reg8_other_document_number AS reg8_other_document_number_58, t0.group_id AS group_id_59, t0.avatar_id AS avatar_id_60, t0.site_id AS site_id_61, t0.default_doctor_id AS default_doctor_id_62 FROM user t0 WHERE t0.id = ?
Parameters:
[
  ""
]
8 1.17 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.created_at AS created_at_3, t0.sick_leave_id AS sick_leave_id_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.description AS description_8, t0.name AS name_9, t0.order_id AS order_id_10, t0.medical_history_id AS medical_history_id_11, t0.order_message_id AS order_message_id_12, t0.user_id AS user_id_13, t0.patient_id AS patient_id_14, t0.email_id AS email_id_15, t0.chat_message_id AS chat_message_id_16, t17.id AS id_18, t17.type AS type_19, t17.data AS data_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.order_id AS order_id_23, t17.pdf_id AS pdf_id_24, t25.id AS id_26, t25.external_id AS external_id_27, t25.lab_external_id AS lab_external_id_28, t25.external_url AS external_url_29, t25.google_url AS google_url_30, t25.name AS name_31, t25.type AS type_32, t25.latitude AS latitude_33, t25.longitude AS longitude_34, t25.phone1 AS phone1_35, t25.phone2 AS phone2_36, t25.email1 AS email1_37, t25.email2 AS email2_38, t25.description AS description_39, t25.description_working_hours AS description_working_hours_40, t25.description_location AS description_location_41, t25.at_id AS at_id_42, t25.nfz_phone1 AS nfz_phone1_43, t25.nfz_phone2 AS nfz_phone2_44, t25.ks_id AS ks_id_45, t25.working_day_notes AS working_day_notes_46, t25.saturday_notes AS saturday_notes_47, t25.sunday_notes AS sunday_notes_48, t25.working_day_material_collection_until AS working_day_material_collection_until_49, t25.saturday_material_collection_until AS saturday_material_collection_until_50, t25.sunday_material_collection_until AS sunday_material_collection_until_51, t25.open24_hours AS open24_hours_52, t25.open24_hours_restrictions AS open24_hours_restrictions_53, t25.poz AS poz_54, t25.active AS active_55, t25.description_working_hours_short AS description_working_hours_short_56, t25.position AS position_57, t25.postal_code AS postal_code_58, t25.city AS city_59, t25.street AS street_60, t25.building_number AS building_number_61, t25.local_number AS local_number_62, t25.voivodeship AS voivodeship_63, t25.commune AS commune_64, t25.district AS district_65, t25.country AS country_66, t25.census_tract AS census_tract_67, t25.logo_id AS logo_id_68, t25.photo_id AS photo_id_69, t25.photo2_id AS photo2_id_70, t71.id AS id_72, t71.name AS name_73, t71.type AS type_74, t71.price AS price_75, t71.description AS description_76, t71.subtitle AS subtitle_77, t71.account_required AS account_required_78, t71.bullets AS bullets_79, t71.data AS data_80, t71.has_calendar AS has_calendar_81, t71.has_phone AS has_phone_82, t71.title AS title_83, t71.active AS active_84, t71.position AS position_85, t71.default_package AS default_package_86, t71.parent_id AS parent_id_87, t71.icon_id AS icon_id_88, t0.package_id AS package_id_89, t0.lab_examination_group_id AS lab_examination_group_id_90, t0.lab_examination_id AS lab_examination_id_91 FROM file t0 LEFT JOIN form_entry t17 ON t17.pdf_id = t0.id LEFT JOIN institution t25 ON t25.photo_id = t0.id LEFT JOIN service t71 ON t71.icon_id = t0.id WHERE t0.id = ?
Parameters:
[
  759865
]
9 0.83 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.content AS content_3, t0.accepted AS accepted_4, t0.user_ip AS user_ip_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.post_id AS post_id_9, t0.user_id AS user_id_10 FROM blog_post_comment t0 WHERE t0.post_id = ? AND t0.accepted = ?
Parameters:
[
  528
  1
]
10 59.38 ms
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 3
Parameters:
[
  1
]
11 2.01 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM blog_category t0 INNER JOIN blog_post_blog_category ON t0.id = blog_post_blog_category.blog_category_id WHERE blog_post_blog_category.blog_post_id = ?
Parameters:
[
  528
]
12 2.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_post_id AS blog_post_id_6 FROM blog_custom_link t0 WHERE t0.blog_post_id = ?
Parameters:
[
  528
]
13 0.89 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.blog_post_id AS blog_post_id_5 FROM blog_custom_link b0_ INNER JOIN blog_post b1_ ON b0_.blog_post_id = b1_.id WHERE b0_.blog_post_id = ? AND b1_.active = ? ORDER BY b0_.created_at DESC LIMIT 5
Parameters:
[
  528
  1
]

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\BlogCategory 38
App\Entity\BlogCustomLink 5
App\Entity\BlogPost 4
App\Entity\File 3
App\Entity\User 2
App\Entity\Site 1
App\Entity\UserGroup 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\BlogCategory No errors.
App\Entity\BlogPost No errors.
App\Entity\Affliction No errors.
App\Entity\Specialization 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\UserGroup No errors.
App\Entity\Doctor No errors.
App\Entity\BaseMedicalHistory No errors.
App\Entity\Embeddable\InvoiceAddress No errors.
App\Entity\MedicalHistory No errors.
App\Entity\OrderMessageTemplate No errors.
App\Entity\Patient No errors.
App\Entity\Reflink No errors.
App\Entity\UserSetting No errors.
App\Entity\ContentTemplate No errors.
App\Entity\Prescription No errors.
App\Entity\Note No errors.
App\Entity\MedicinesComment No errors.
App\Entity\UserSubscription No errors.
App\Entity\Log No errors.
App\Entity\Order No errors.
App\Entity\LogEntry No errors.
App\Entity\OrderDownloadLog No errors.
App\Entity\NotificationHistory No errors.
App\Entity\OrderMessage No errors.
App\Entity\Email No errors.
App\Entity\ChatMessage No errors.
App\Entity\FormEntry 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\Package No errors.
App\Entity\LabExaminationGroup No errors.
App\Entity\LabExamination No errors.
App\Entity\LabExaminationResult No errors.