Query Metrics
5
Database Queries
5
Different statements
2.06 ms
Query time
1
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.73 ms (35.55%) |
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.42 ms (20.44%) |
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.wk_auth_status AS wk_auth_status_33, t0.wk_auth_last_attempt AS wk_auth_last_attempt_34, t0.wk_at AS wk_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.reg6_reg AS reg6_reg_38, t0.reg6_first_name AS reg6_first_name_39, t0.reg6_last_name AS reg6_last_name_40, t0.reg6_pesel AS reg6_pesel_41, t0.reg6_no_pesel AS reg6_no_pesel_42, t0.reg6_other_document AS reg6_other_document_43, t0.reg6_other_document_number AS reg6_other_document_number_44, t0.reg7_reg AS reg7_reg_45, t0.reg7_first_name AS reg7_first_name_46, t0.reg7_last_name AS reg7_last_name_47, t0.reg7_pesel AS reg7_pesel_48, t0.reg7_no_pesel AS reg7_no_pesel_49, t0.reg7_other_document AS reg7_other_document_50, t0.reg7_other_document_number AS reg7_other_document_number_51, t0.reg8_reg AS reg8_reg_52, t0.reg8_first_name AS reg8_first_name_53, t0.reg8_last_name AS reg8_last_name_54, t0.reg8_pesel AS reg8_pesel_55, t0.reg8_no_pesel AS reg8_no_pesel_56, t0.reg8_other_document AS reg8_other_document_57, t0.reg8_other_document_number AS reg8_other_document_number_58, t0.group_id AS group_id_59, t0.avatar_id AS avatar_id_60, t0.site_id AS site_id_61, t0.default_doctor_id AS default_doctor_id_62 FROM user t0 WHERE t0.id = ?
Parameters:
[
45343
]
|
||||||||||||||||||||||||||||||||
|
0.31 ms (15.10%) |
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_.wk_auth_status AS wk_auth_status_32, u0_.wk_auth_last_attempt AS wk_auth_last_attempt_33, u0_.wk_at AS wk_at_34, u0_.created_at AS created_at_35, u0_.updated_at AS updated_at_36, u0_.reg6_reg AS reg6_reg_37, u0_.reg6_first_name AS reg6_first_name_38, u0_.reg6_last_name AS reg6_last_name_39, u0_.reg6_pesel AS reg6_pesel_40, u0_.reg6_no_pesel AS reg6_no_pesel_41, u0_.reg6_other_document AS reg6_other_document_42, u0_.reg6_other_document_number AS reg6_other_document_number_43, u0_.reg7_reg AS reg7_reg_44, u0_.reg7_first_name AS reg7_first_name_45, u0_.reg7_last_name AS reg7_last_name_46, u0_.reg7_pesel AS reg7_pesel_47, u0_.reg7_no_pesel AS reg7_no_pesel_48, u0_.reg7_other_document AS reg7_other_document_49, u0_.reg7_other_document_number AS reg7_other_document_number_50, u0_.reg8_reg AS reg8_reg_51, u0_.reg8_first_name AS reg8_first_name_52, u0_.reg8_last_name AS reg8_last_name_53, u0_.reg8_pesel AS reg8_pesel_54, u0_.reg8_no_pesel AS reg8_no_pesel_55, u0_.reg8_other_document AS reg8_other_document_56, u0_.reg8_other_document_number AS reg8_other_document_number_57, u0_.group_id AS group_id_58, u0_.avatar_id AS avatar_id_59, u0_.site_id AS site_id_60, u0_.default_doctor_id AS default_doctor_id_61 FROM user u0_ WHERE u0_.username = ? AND u0_.active = ?
Parameters:
[ "denispawelek1307@gmail.com" 1 ] |
||||||||||||||||||||||||||||||||
|
0.31 ms (15.10%) |
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:
[
"cByEGENdRFydQ9dyq2DmwZ:APA91bHvMoul5WqGOSwDa37G6X-5r718QuZLxumnfMJc3SDssyUTJnD4CpE7PadjP_J5J1SHTomX_1Z_SDlE0347oIr25L2WnG6kvEw17-Xk2YbqGBFEE5o"
]
|
||||||||||||||||||||||||||||||||
|
0.28 ms (13.80%) |
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:
[
480
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Site | 1 |
| App\Entity\User | 1 |
| App\Entity\UserSubscription | 1 |