GET https://dev.e-recepta.net/api/v2/chats/check

Query Metrics

9 Database Queries
8 Different statements
2.52 ms Query time
1 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.59 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.token = ? LIMIT 1
Parameters:
[
  "pPfaGDatpMD91ub76vXpG7UiWL2yZUgSVZ74dV7K"
]
2 0.19 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:
[
  "14"
]
3 0.39 ms
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:
[
  45470
]
4 0.39 ms
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:
[
  "jan.nowak@e-recepta.net"
  1
]
5 0.31 ms
SELECT t0.recommendations AS recommendations_1, t0.physical_examination AS physical_examination_2, t0.test_results AS test_results_3, t0.growth AS growth_4, t0.weight AS weight_5, t0.report AS report_6, t0.created_at AS created_at_7, t0.postal_code AS postal_code_8, t0.city AS city_9, t0.street AS street_10, t0.building_number AS building_number_11, t0.local_number AS local_number_12, t0.voivodeship AS voivodeship_13, t0.commune AS commune_14, t0.district AS district_15, t0.country AS country_16, t0.census_tract AS census_tract_17, t0.reg1 AS reg1_18, t0.reg2 AS reg2_19, t0.reg3 AS reg3_20, t0.reg4 AS reg4_21, t0.reg5 AS reg5_22, t0.guardian_first_name AS guardian_first_name_23, t0.guardian_last_name AS guardian_last_name_24, t0.guardian_pesel AS guardian_pesel_25, t0.pesel AS pesel_26, t0.no_pesel AS no_pesel_27, t0.other_document AS other_document_28, t0.other_document_number AS other_document_number_29, t0.birthday_at AS birthday_at_30, t0.nationality AS nationality_31, t0.sex AS sex_32, t0.senior AS senior_33, t0.first_name AS first_name_34, t0.last_name AS last_name_35, t0.email AS email_36, t0.phone AS phone_37, t0.updated_at AS updated_at_38, t0.id AS id_39, t0.deleted_at AS deleted_at_40, t0.hash AS hash_41, t0.stripe_customer_id AS stripe_customer_id_42, t0.polmed_token AS polmed_token_43, t0.polmed_id AS polmed_id_44, t0.polmed_packets AS polmed_packets_45, t0.polmed_has_chat_doctor AS polmed_has_chat_doctor_46, t0.wk_pesel AS wk_pesel_47, t0.wk_first_name AS wk_first_name_48, t0.wk_last_name AS wk_last_name_49, t0.has_user AS has_user_50, t0.sr_id AS sr_id_51, t0.has_new_order_message AS has_new_order_message_52, t0.has_new_chat_message AS has_new_chat_message_53, t0.dolegliwosci AS dolegliwosci_54, t0.alergie AS alergie_55, t0.choroby_przewlekle AS choroby_przewlekle_56, t0.leki AS leki_57, t0.notes AS notes_58, t0.pregnant AS pregnant_59, t0.doctor_id AS doctor_id_60, t0.user_id AS user_id_61 FROM patient t0 WHERE t0.user_id = ?
Parameters:
[
  45470
]
6 0.22 ms
SELECT d0_.id AS id_0 FROM doctor d0_ INNER JOIN doctor_user d2_ ON d0_.id = d2_.doctor_id INNER JOIN user u1_ ON u1_.id = d2_.user_id LEFT JOIN user_group u3_ ON u1_.group_id = u3_.id WHERE d0_.consultant_available = ? AND (JSON_CONTAINS(u1_.roles, ?, ?) = ? OR JSON_CONTAINS(u3_.roles, ?, ?) = ?) LIMIT 1
Parameters:
[
  1
  ""ROLE_CONSULTANT""
  "$"
  1
  ""ROLE_CONSULTANT""
  "$"
  1
]
7 0.16 ms
SELECT t0.id AS id_1, t0.closed AS closed_2, t0.created_at AS created_at_3, t0.type AS type_4, t0.send_at AS send_at_5, t0.doctor_helped AS doctor_helped_6, t0.patient_helped AS patient_helped_7, t0.updated_at AS updated_at_8, t0.patient_id AS patient_id_9, t0.doctor_id AS doctor_id_10, t0.site_id AS site_id_11 FROM chat t0 WHERE t0.patient_id = ? AND t0.closed = ? AND t0.type = ? LIMIT 1
Parameters:
[
  155712
  0
  "consultant"
]
8 0.13 ms
SELECT t0.id AS id_1, t0.closed AS closed_2, t0.created_at AS created_at_3, t0.type AS type_4, t0.send_at AS send_at_5, t0.doctor_helped AS doctor_helped_6, t0.patient_helped AS patient_helped_7, t0.updated_at AS updated_at_8, t0.patient_id AS patient_id_9, t0.doctor_id AS doctor_id_10, t0.site_id AS site_id_11 FROM chat t0 WHERE t0.patient_id = ? AND t0.closed = ? AND t0.type = ? LIMIT 1
Parameters:
[
  155712
  0
  "doctor"
]
9 0.13 ms
SELECT t0.id AS id_1, t0.closed AS closed_2, t0.created_at AS created_at_3, t0.type AS type_4, t0.send_at AS send_at_5, t0.doctor_helped AS doctor_helped_6, t0.patient_helped AS patient_helped_7, t0.updated_at AS updated_at_8, t0.patient_id AS patient_id_9, t0.doctor_id AS doctor_id_10, t0.site_id AS site_id_11 FROM chat t0 WHERE t0.patient_id = ? AND t0.closed = ?
Parameters:
[
  155712
  0
]

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\Patient 1

Entities Mapping

Class Mapping errors
App\Entity\Site No errors.
App\Entity\File No errors.
App\Entity\Service
  • The association App\Entity\Service#banners refers to the owning side field App\Entity\Banner#service which does not exist.
App\Entity\PriceRate No errors.
App\Entity\Discount No errors.
App\Entity\Chat No errors.
App\Entity\Opinion No errors.
App\Entity\Embeddable\RegLegal No errors.
App\Entity\User No errors.
App\Entity\UserGroup No errors.
App\Entity\Doctor No errors.
App\Entity\BaseMedicalHistory No errors.
App\Entity\Embeddable\InvoiceAddress No errors.
App\Entity\MedicalHistory No errors.
App\Entity\OrderMessageTemplate No errors.
App\Entity\Patient No errors.
App\Entity\Reflink No errors.
App\Entity\UserSetting No errors.
App\Entity\ContentTemplate No errors.
App\Entity\Prescription No errors.
App\Entity\Note No errors.
App\Entity\BlogPostComment No errors.
App\Entity\BlogPost No errors.
App\Entity\MedicinesComment No errors.
App\Entity\UserSubscription No errors.
App\Entity\Log No errors.
App\Entity\Order No errors.
App\Entity\LogEntry No errors.
App\Entity\OrderDownloadLog No errors.
App\Entity\NotificationHistory No errors.
App\Entity\UserPackage No errors.
App\Entity\Declaration No errors.