Query Metrics
5
Database Queries
5
Different statements
3.23 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.96 ms (29.62%) |
1 |
SELECT t0.id AS id_1, t0.subscription_hash AS subscription_hash_2, t0.subscription AS subscription_3, t0.notify_new_order AS notify_new_order_4, t0.notify_new_order_message AS notify_new_order_message_5, t0.label AS label_6, t0.type AS type_7, t0.notify_start_consultation AS notify_start_consultation_8, t0.notify_only_offline AS notify_only_offline_9, t0.notify_new_chat_message AS notify_new_chat_message_10, t0.user_id AS user_id_11 FROM user_subscription t0 WHERE t0.subscription_hash = ? LIMIT 1
Parameters:
[
"fbOx2FqVQtCAzONhnJNMbR:APA91bGP5sDB1gGpwNR8uyTPdD5MKqAtnzFaMysbivFXpZAiP6icC2rKFTNgvbxjoZa2VoaHXrawoiNkxxrwLJnRYRtKPaHeXTg8uQJ8tAHGLkJMDRsAS-s"
]
|
||||||||||||||||||||||||||||||||
|
0.81 ms (25.02%) |
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.token = ? LIMIT 1
Parameters:
[
"85136c79cbf9fe36bb9d05d0639c70c265c18d37"
]
|
||||||||||||||||||||||||||||||||
|
0.69 ms (21.24%) |
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.id = ?
Parameters:
[
45341
]
|
||||||||||||||||||||||||||||||||
|
0.47 ms (14.69%) |
1 |
SELECT t0.id AS id_1, t0.subscription_hash AS subscription_hash_2, t0.subscription AS subscription_3, t0.notify_new_order AS notify_new_order_4, t0.notify_new_order_message AS notify_new_order_message_5, t0.label AS label_6, t0.type AS type_7, t0.notify_start_consultation AS notify_start_consultation_8, t0.notify_only_offline AS notify_only_offline_9, t0.notify_new_chat_message AS notify_new_chat_message_10, t0.user_id AS user_id_11 FROM user_subscription t0 WHERE t0.id = ?
Parameters:
[
377
]
|
||||||||||||||||||||||||||||||||
|
0.30 ms (9.43%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.active AS active_4, u0_.hash AS hash_5, u0_.deleted_at AS deleted_at_6, u0_.reg1 AS reg1_7, u0_.reg3 AS reg3_8, u0_.reg4 AS reg4_9, u0_.reg5 AS reg5_10, u0_.password_changed_at AS password_changed_at_11, u0_.new_reg AS new_reg_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.name AS name_15, u0_.slug AS slug_16, u0_.note AS note_17, u0_.facebook_url AS facebook_url_18, u0_.linkedin_url AS linkedin_url_19, u0_.twitter_url AS twitter_url_20, u0_.instagram_url AS instagram_url_21, u0_.seo_title AS seo_title_22, u0_.seo_description AS seo_description_23, u0_.suspended AS suspended_24, u0_.wk AS wk_25, u0_.wk_attempts AS wk_attempts_26, u0_.reg9 AS reg9_27, u0_.google_authenticator_secret AS google_authenticator_secret_28, u0_.google_authenticator_complete AS google_authenticator_complete_29, u0_.reg10 AS reg10_30, u0_.reg11 AS reg11_31, u0_.created_at AS created_at_32, u0_.updated_at AS updated_at_33, u0_.reg6_reg AS reg6_reg_34, u0_.reg6_first_name AS reg6_first_name_35, u0_.reg6_last_name AS reg6_last_name_36, u0_.reg6_pesel AS reg6_pesel_37, u0_.reg6_no_pesel AS reg6_no_pesel_38, u0_.reg6_other_document AS reg6_other_document_39, u0_.reg6_other_document_number AS reg6_other_document_number_40, u0_.reg7_reg AS reg7_reg_41, u0_.reg7_first_name AS reg7_first_name_42, u0_.reg7_last_name AS reg7_last_name_43, u0_.reg7_pesel AS reg7_pesel_44, u0_.reg7_no_pesel AS reg7_no_pesel_45, u0_.reg7_other_document AS reg7_other_document_46, u0_.reg7_other_document_number AS reg7_other_document_number_47, u0_.reg8_reg AS reg8_reg_48, u0_.reg8_first_name AS reg8_first_name_49, u0_.reg8_last_name AS reg8_last_name_50, u0_.reg8_pesel AS reg8_pesel_51, u0_.reg8_no_pesel AS reg8_no_pesel_52, u0_.reg8_other_document AS reg8_other_document_53, u0_.reg8_other_document_number AS reg8_other_document_number_54, u0_.group_id AS group_id_55, u0_.avatar_id AS avatar_id_56, u0_.site_id AS site_id_57, u0_.default_doctor_id AS default_doctor_id_58 FROM user u0_ WHERE u0_.username = ? AND u0_.active = ?
Parameters:
[ "mszczerba1204@gmail.com" 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.