Query Metrics
8
Database Queries
8
Different statements
4.88 ms
Query time
1
Invalid entities
Queries
#▲ | 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.