Query Metrics

8 Database Queries
8 Different statements
4.88 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.94 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.52 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:
[
  "kobieta"
]
3 0.36 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.34 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:
[
  "kobieta"
]
5 1.11 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 INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_post_id WHERE blog_post_blog_tag.blog_tag_id = ?
Parameters:
[
  1
]
6 0.61 ms
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_post b0_ INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id LEFT JOIN blog_post_blog_category b4_ ON b0_.id = b4_.blog_post_id LEFT JOIN blog_category b3_ ON b3_.id = b4_.blog_category_id LEFT JOIN file f5_ ON b0_.thumbnail_id = f5_.id WHERE b1_.slug = ?
Parameters:
[
  "kobieta"
]
7 0.45 ms
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM blog_post b0_ INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id LEFT JOIN blog_post_blog_category b4_ ON b0_.id = b4_.blog_post_id LEFT JOIN blog_category b3_ ON b3_.id = b4_.blog_category_id LEFT JOIN file f5_ ON b0_.thumbnail_id = f5_.id WHERE b1_.slug = ? ORDER BY b0_.created_at DESC LIMIT 42
Parameters:
[
  "kobieta"
]
8 0.56 ms
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, f2_.id AS id_18, f2_.path AS path_19, f2_.created_at AS created_at_20, f2_.sick_leave_id AS sick_leave_id_21, f2_.size AS size_22, f2_.mime_type AS mime_type_23, f2_.type AS type_24, f2_.description AS description_25, f2_.name AS name_26, b0_.thumbnail_id AS thumbnail_id_27, b0_.user_id AS user_id_28, f2_.order_id AS order_id_29, f2_.medical_history_id AS medical_history_id_30, f2_.order_message_id AS order_message_id_31, f2_.user_id AS user_id_32, f2_.patient_id AS patient_id_33, f2_.email_id AS email_id_34, f2_.chat_message_id AS chat_message_id_35, f2_.package_id AS package_id_36, f2_.lab_examination_group_id AS lab_examination_group_id_37, f2_.lab_examination_id AS lab_examination_id_38 FROM blog_post b0_ INNER JOIN blog_post_blog_tag b4_ ON b0_.id = b4_.blog_post_id INNER JOIN blog_tag b3_ ON b3_.id = b4_.blog_tag_id LEFT JOIN blog_post_blog_category b5_ ON b0_.id = b5_.blog_post_id LEFT JOIN blog_category b1_ ON b1_.id = b5_.blog_category_id LEFT JOIN file f2_ ON b0_.thumbnail_id = f2_.id WHERE b3_.slug = ? AND b0_.id IN (?) ORDER BY b0_.created_at DESC
Parameters:
[
  "kobieta"
  156
]

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\Order No errors.
App\Entity\BaseMedicalHistory No errors.
App\Entity\Embeddable\InvoiceAddress No errors.
App\Entity\MedicalHistory No errors.
App\Entity\OrderMessage No errors.
App\Entity\Patient No errors.
App\Entity\Email No errors.
App\Entity\ChatMessage No errors.
App\Entity\Package No errors.
App\Entity\LabExaminationGroup No errors.
App\Entity\LabExamination No errors.