Query Metrics
5
Database Queries
5
Different statements
61.27 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59.11 ms (96.47%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"katarzyna-szafraniec"
]
|
||||||||||||||||||||||||||||
0.87 ms (1.42%) |
1 |
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"
]
|
||||||||||||||||||||||||||||
0.55 ms (0.89%) |
1 |
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, b0_.thumbnail_id AS thumbnail_id_15, b0_.user_id AS user_id_16 FROM blog_post b0_ WHERE b0_.user_id = ? AND b0_.active = ? AND b0_.id IN (?, ?, ?) ORDER BY b0_.created_at DESC
Parameters:
[ 36892 1 738 737 732 ] |
||||||||||||||||||||||||||||
0.48 ms (0.78%) |
1 |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.user_id = ? AND b0_.active = ?
Parameters:
[ 36892 1 ] |
||||||||||||||||||||||||||||
0.27 ms (0.44%) |
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM blog_post b0_ WHERE b0_.user_id = ? AND b0_.active = ? ORDER BY b0_.created_at DESC LIMIT 42
Parameters:
[ 36892 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.