Query Metrics

12 Database Queries
12 Different statements
5.43 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.69 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.39 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:
[
  "cukrzyca-u-noworodka-przyczyny-objawy-leczenie"
]
3 0.12 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.33 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:
[
  "cukrzyca-u-noworodka-przyczyny-objawy-leczenie"
]
5 0.44 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:
[
  "cukrzyca-u-noworodka-przyczyny-objawy-leczenie"
  1
]
6 0.30 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.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.reg6_reg AS reg6_reg_35, t0.reg6_first_name AS reg6_first_name_36, t0.reg6_last_name AS reg6_last_name_37, t0.reg6_pesel AS reg6_pesel_38, t0.reg6_no_pesel AS reg6_no_pesel_39, t0.reg6_other_document AS reg6_other_document_40, t0.reg6_other_document_number AS reg6_other_document_number_41, t0.reg7_reg AS reg7_reg_42, t0.reg7_first_name AS reg7_first_name_43, t0.reg7_last_name AS reg7_last_name_44, t0.reg7_pesel AS reg7_pesel_45, t0.reg7_no_pesel AS reg7_no_pesel_46, t0.reg7_other_document AS reg7_other_document_47, t0.reg7_other_document_number AS reg7_other_document_number_48, t0.reg8_reg AS reg8_reg_49, t0.reg8_first_name AS reg8_first_name_50, t0.reg8_last_name AS reg8_last_name_51, t0.reg8_pesel AS reg8_pesel_52, t0.reg8_no_pesel AS reg8_no_pesel_53, t0.reg8_other_document AS reg8_other_document_54, t0.reg8_other_document_number AS reg8_other_document_number_55, t0.group_id AS group_id_56, t0.avatar_id AS avatar_id_57, t0.site_id AS site_id_58, t0.default_doctor_id AS default_doctor_id_59 FROM user t0 WHERE t0.id = ?
Parameters:
[
  8
]
7 1.10 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.postal_code AS postal_code_57, t25.city AS city_58, t25.street AS street_59, t25.building_number AS building_number_60, t25.local_number AS local_number_61, t25.voivodeship AS voivodeship_62, t25.commune AS commune_63, t25.district AS district_64, t25.country AS country_65, t25.census_tract AS census_tract_66, t25.logo_id AS logo_id_67, t25.photo_id AS photo_id_68, t25.photo2_id AS photo2_id_69, t70.id AS id_71, t70.name AS name_72, t70.type AS type_73, t70.price AS price_74, t70.description AS description_75, t70.subtitle AS subtitle_76, t70.account_required AS account_required_77, t70.bullets AS bullets_78, t70.data AS data_79, t70.has_calendar AS has_calendar_80, t70.has_phone AS has_phone_81, t70.title AS title_82, t70.active AS active_83, t70.position AS position_84, t70.default_package AS default_package_85, t70.parent_id AS parent_id_86, t70.icon_id AS icon_id_87, t0.package_id AS package_id_88, t0.lab_examination_group_id AS lab_examination_group_id_89, t0.lab_examination_id AS lab_examination_id_90 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 t70 ON t70.icon_id = t0.id WHERE t0.id = ?
Parameters:
[
  -748941
]
8 0.39 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:
[
  440
  1
]
9 0.30 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.created_at DESC LIMIT 3
Parameters:
[
  1
]
10 0.37 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:
[
  440
]
11 0.34 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:
[
  440
]
12 0.67 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:
[
  440
  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.

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.