Query Metrics
23
Database Queries
9
Different statements
23.03 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
13.08 ms (56.82%) |
1 |
SELECT CONCAT_WS(';#;', i0_.name, COALESCE(i0_.city, ''), COALESCE(i0_.postal_code, ''), COALESCE(i0_.street, ''), COALESCE(i0_.building_number, ''), COALESCE(i0_.local_number, '')) AS sclr_0, i0_.id AS sclr_1, CONCAT_WS(';#;', i0_.name, COALESCE(i0_.city, ''), COALESCE(i0_.postal_code, ''), COALESCE(i0_.street, ''), COALESCE(i0_.building_number, ''), COALESCE(i0_.local_number, '')) AS sclr_2, ? AS sclr_3 FROM institution i0_ WHERE i0_.type = ? AND (i0_.name LIKE ? OR i0_.city LIKE ?) AND i0_.active = ? GROUP BY i0_.id ORDER BY sclr_0 ASC LIMIT 30
Parameters:
[ "App\Entity\Institution" "AtineaEpolmed" "%gda%" "%gda%" 1 ] |
||||||||||||||||||||||||
|
4.38 ms (19.01%) |
8 |
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.lab_external_id AS lab_external_id_3, t0.external_url AS external_url_4, t0.google_url AS google_url_5, t0.name AS name_6, t0.type AS type_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.phone1 AS phone1_10, t0.phone2 AS phone2_11, t0.email1 AS email1_12, t0.email2 AS email2_13, t0.description AS description_14, t0.description_working_hours AS description_working_hours_15, t0.description_location AS description_location_16, t0.at_id AS at_id_17, t0.nfz_phone1 AS nfz_phone1_18, t0.nfz_phone2 AS nfz_phone2_19, t0.ks_id AS ks_id_20, t0.working_day_notes AS working_day_notes_21, t0.saturday_notes AS saturday_notes_22, t0.sunday_notes AS sunday_notes_23, t0.working_day_material_collection_until AS working_day_material_collection_until_24, t0.saturday_material_collection_until AS saturday_material_collection_until_25, t0.sunday_material_collection_until AS sunday_material_collection_until_26, t0.open24_hours AS open24_hours_27, t0.open24_hours_restrictions AS open24_hours_restrictions_28, t0.poz AS poz_29, t0.active AS active_30, t0.description_working_hours_short AS description_working_hours_short_31, t0.postal_code AS postal_code_32, t0.city AS city_33, t0.street AS street_34, t0.building_number AS building_number_35, t0.local_number AS local_number_36, t0.voivodeship AS voivodeship_37, t0.commune AS commune_38, t0.district AS district_39, t0.country AS country_40, t0.census_tract AS census_tract_41, t0.logo_id AS logo_id_42, t0.photo_id AS photo_id_43, t0.photo2_id AS photo2_id_44 FROM institution t0 WHERE t0.id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||
|
3.32 ms (14.43%) |
8 |
SELECT t0.id AS id_1, t0.week_day AS week_day_2, t0.from_time AS from_time_3, t0.to_time AS to_time_4, t0.institution_id AS institution_id_5, t0.nfz_institution_id AS nfz_institution_id_6 FROM institution_working_hour t0 WHERE t0.institution_id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||
|
0.71 ms (3.10%) |
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.35 ms (1.51%) |
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:
[ "denispawelek1307@gmail.com" 1 ] |
||||||||||||||||||||||||
|
0.32 ms (1.37%) |
1 |
SELECT p0_.recommendations AS recommendations_0, p0_.physical_examination AS physical_examination_1, p0_.test_results AS test_results_2, p0_.growth AS growth_3, p0_.weight AS weight_4, p0_.report AS report_5, p0_.created_at AS created_at_6, p0_.postal_code AS postal_code_7, p0_.city AS city_8, p0_.street AS street_9, p0_.building_number AS building_number_10, p0_.local_number AS local_number_11, p0_.voivodeship AS voivodeship_12, p0_.commune AS commune_13, p0_.district AS district_14, p0_.country AS country_15, p0_.census_tract AS census_tract_16, p0_.reg1 AS reg1_17, p0_.reg2 AS reg2_18, p0_.reg3 AS reg3_19, p0_.reg4 AS reg4_20, p0_.reg5 AS reg5_21, p0_.guardian_first_name AS guardian_first_name_22, p0_.guardian_last_name AS guardian_last_name_23, p0_.guardian_pesel AS guardian_pesel_24, p0_.pesel AS pesel_25, p0_.no_pesel AS no_pesel_26, p0_.other_document AS other_document_27, p0_.other_document_number AS other_document_number_28, p0_.birthday_at AS birthday_at_29, p0_.nationality AS nationality_30, p0_.sex AS sex_31, p0_.senior AS senior_32, p0_.first_name AS first_name_33, p0_.last_name AS last_name_34, p0_.email AS email_35, p0_.phone AS phone_36, p0_.updated_at AS updated_at_37, p0_.id AS id_38, p0_.deleted_at AS deleted_at_39, p0_.hash AS hash_40, p0_.stripe_customer_id AS stripe_customer_id_41, p0_.polmed_token AS polmed_token_42, p0_.polmed_id AS polmed_id_43, p0_.polmed_packets AS polmed_packets_44, p0_.polmed_has_chat_doctor AS polmed_has_chat_doctor_45, p0_.wk_pesel AS wk_pesel_46, p0_.wk_first_name AS wk_first_name_47, p0_.wk_last_name AS wk_last_name_48, p0_.has_user AS has_user_49, p0_.sr_id AS sr_id_50, p0_.dolegliwosci AS dolegliwosci_51, p0_.alergie AS alergie_52, p0_.choroby_przewlekle AS choroby_przewlekle_53, p0_.leki AS leki_54, p0_.notes AS notes_55, p0_.pregnant AS pregnant_56, d1_.id AS id_57, d1_.first_name AS first_name_58, d1_.last_name AS last_name_59, d1_.email AS email_60, d1_.phone AS phone_61, d1_.nip AS nip_62, d1_.company_name AS company_name_63, d1_.active AS active_64, d1_.pesel AS pesel_65, d1_.pwz AS pwz_66, d1_.title AS title_67, d1_.npwz AS npwz_68, d1_.author_cert_pass AS author_cert_pass_69, d1_.auto_medyc_prescription AS auto_medyc_prescription_70, d1_.notification_telegram_enabled AS notification_telegram_enabled_71, d1_.notification_telegram_channel_id AS notification_telegram_channel_id_72, d1_.ksr AS ksr_73, d1_.regon AS regon_74, d1_.res5 AS res5_75, d1_.moidext AS moidext_76, d1_.id_biznesowe_podmiotu_ext AS id_biznesowe_podmiotu_ext_77, d1_.oid AS oid_78, d1_.ex_session_id AS ex_session_id_79, d1_.patients_limit AS patients_limit_80, d1_.items_limit AS items_limit_81, d1_.in_order_rotation AS in_order_rotation_82, d1_.in_order_rotation_admin AS in_order_rotation_admin_83, d1_.consultant_available AS consultant_available_84, d1_.hd_id AS hd_id_85, d1_.description AS description_86, d1_.at_id AS at_id_87, d1_.pwz_root AS pwz_root_88, d1_.cert_valid_to AS cert_valid_to_89, d1_.rated AS rated_90, d1_.lab_examination AS lab_examination_91, d1_.calendar_color AS calendar_color_92, d1_.postal_code AS postal_code_93, d1_.city AS city_94, d1_.street AS street_95, d1_.building_number AS building_number_96, d1_.local_number AS local_number_97, d1_.voivodeship AS voivodeship_98, d1_.commune AS commune_99, d1_.district AS district_100, d1_.country AS country_101, d1_.census_tract AS census_tract_102, d1_.deleted_at AS deleted_at_103, d2_.id AS id_104, d2_.show_on_page AS show_on_page_105, d2_.price AS price_106, d2_.seoDescription AS seoDescription_107, d2_.available AS available_108, d2_.active AS active_109, d2_.default_ AS default__110, u3_.id AS id_111, u3_.username AS username_112, u3_.roles AS roles_113, u3_.password AS password_114, u3_.active AS active_115, u3_.hash AS hash_116, u3_.deleted_at AS deleted_at_117, u3_.reg1 AS reg1_118, u3_.reg3 AS reg3_119, u3_.reg4 AS reg4_120, u3_.reg5 AS reg5_121, u3_.password_changed_at AS password_changed_at_122, u3_.new_reg AS new_reg_123, u3_.first_name AS first_name_124, u3_.last_name AS last_name_125, u3_.name AS name_126, u3_.slug AS slug_127, u3_.note AS note_128, u3_.facebook_url AS facebook_url_129, u3_.linkedin_url AS linkedin_url_130, u3_.twitter_url AS twitter_url_131, u3_.instagram_url AS instagram_url_132, u3_.seo_title AS seo_title_133, u3_.seo_description AS seo_description_134, u3_.suspended AS suspended_135, u3_.wk AS wk_136, u3_.wk_attempts AS wk_attempts_137, u3_.reg9 AS reg9_138, u3_.google_authenticator_secret AS google_authenticator_secret_139, u3_.google_authenticator_complete AS google_authenticator_complete_140, u3_.reg10 AS reg10_141, u3_.reg11 AS reg11_142, u3_.created_at AS created_at_143, u3_.updated_at AS updated_at_144, u3_.reg6_reg AS reg6_reg_145, u3_.reg6_first_name AS reg6_first_name_146, u3_.reg6_last_name AS reg6_last_name_147, u3_.reg6_pesel AS reg6_pesel_148, u3_.reg6_no_pesel AS reg6_no_pesel_149, u3_.reg6_other_document AS reg6_other_document_150, u3_.reg6_other_document_number AS reg6_other_document_number_151, u3_.reg7_reg AS reg7_reg_152, u3_.reg7_first_name AS reg7_first_name_153, u3_.reg7_last_name AS reg7_last_name_154, u3_.reg7_pesel AS reg7_pesel_155, u3_.reg7_no_pesel AS reg7_no_pesel_156, u3_.reg7_other_document AS reg7_other_document_157, u3_.reg7_other_document_number AS reg7_other_document_number_158, u3_.reg8_reg AS reg8_reg_159, u3_.reg8_first_name AS reg8_first_name_160, u3_.reg8_last_name AS reg8_last_name_161, u3_.reg8_pesel AS reg8_pesel_162, u3_.reg8_no_pesel AS reg8_no_pesel_163, u3_.reg8_other_document AS reg8_other_document_164, u3_.reg8_other_document_number AS reg8_other_document_number_165, p0_.doctor_id AS doctor_id_166, p0_.user_id AS user_id_167, d1_.occupation_group_id AS occupation_group_id_168, d1_.author_cert_id AS author_cert_id_169, d1_.avatar_id AS avatar_id_170, d1_.parent_doctor_id AS parent_doctor_id_171, d2_.doctor_id AS doctor_id_172, d2_.specialization_id AS specialization_id_173, d2_.institution_id AS institution_id_174, u3_.group_id AS group_id_175, u3_.avatar_id AS avatar_id_176, u3_.site_id AS site_id_177, u3_.default_doctor_id AS default_doctor_id_178 FROM patient p0_ LEFT JOIN doctor d1_ ON p0_.doctor_id = d1_.id LEFT JOIN doctor_specialization d2_ ON d1_.id = d2_.doctor_id LEFT JOIN user u3_ ON p0_.user_id = u3_.id WHERE p0_.id = ? AND p0_.user_id = ?
Parameters:
[ 155490 45343 ] |
||||||||||||||||||||||||
|
0.31 ms (1.35%) |
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:
[
45343
]
|
||||||||||||||||||||||||
|
0.31 ms (1.34%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.nip AS nip_6, t0.company_name AS company_name_7, t0.active AS active_8, t0.pesel AS pesel_9, t0.pwz AS pwz_10, t0.title AS title_11, t0.npwz AS npwz_12, t0.author_cert_pass AS author_cert_pass_13, t0.auto_medyc_prescription AS auto_medyc_prescription_14, t0.notification_telegram_enabled AS notification_telegram_enabled_15, t0.notification_telegram_channel_id AS notification_telegram_channel_id_16, t0.ksr AS ksr_17, t0.regon AS regon_18, t0.res5 AS res5_19, t0.moidext AS moidext_20, t0.id_biznesowe_podmiotu_ext AS id_biznesowe_podmiotu_ext_21, t0.oid AS oid_22, t0.ex_session_id AS ex_session_id_23, t0.patients_limit AS patients_limit_24, t0.items_limit AS items_limit_25, t0.in_order_rotation AS in_order_rotation_26, t0.in_order_rotation_admin AS in_order_rotation_admin_27, t0.consultant_available AS consultant_available_28, t0.hd_id AS hd_id_29, t0.description AS description_30, t0.at_id AS at_id_31, t0.pwz_root AS pwz_root_32, t0.cert_valid_to AS cert_valid_to_33, t0.rated AS rated_34, t0.lab_examination AS lab_examination_35, t0.calendar_color AS calendar_color_36, t0.postal_code AS postal_code_37, t0.city AS city_38, t0.street AS street_39, t0.building_number AS building_number_40, t0.local_number AS local_number_41, t0.voivodeship AS voivodeship_42, t0.commune AS commune_43, t0.district AS district_44, t0.country AS country_45, t0.census_tract AS census_tract_46, t0.deleted_at AS deleted_at_47, t0.occupation_group_id AS occupation_group_id_48, t0.author_cert_id AS author_cert_id_49, t0.avatar_id AS avatar_id_50, t0.parent_doctor_id AS parent_doctor_id_51 FROM doctor t0 INNER JOIN doctor_user ON t0.id = doctor_user.doctor_id WHERE doctor_user.user_id = ?
Parameters:
[
45343
]
|
||||||||||||||||||||||||
|
0.25 ms (1.07%) |
1 |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.url AS url_3, r0_.cookie_lifetime AS cookie_lifetime_4, r0_.query_key AS query_key_5, r0_.query_value AS query_value_6, r0_.user_display_type AS user_display_type_7, r0_.awin AS awin_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.user_id AS user_id_11, r0_.discount_id AS discount_id_12 FROM reflink r0_ WHERE r0_.query_key IS NOT NULL AND r0_.query_key <> ?
Parameters:
[ "" ] |
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.