Symfony Profiler

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

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 = '85136c79cbf9fe36bb9d05d0639c70c265c18d37' LIMIT 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.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.reg6_reg AS reg6_reg_33,
  t0.reg6_first_name AS reg6_first_name_34,
  t0.reg6_last_name AS reg6_last_name_35,
  t0.reg6_pesel AS reg6_pesel_36,
  t0.reg6_no_pesel AS reg6_no_pesel_37,
  t0.reg6_other_document AS reg6_other_document_38,
  t0.reg6_other_document_number AS reg6_other_document_number_39,
  t0.reg7_reg AS reg7_reg_40,
  t0.reg7_first_name AS reg7_first_name_41,
  t0.reg7_last_name AS reg7_last_name_42,
  t0.reg7_pesel AS reg7_pesel_43,
  t0.reg7_no_pesel AS reg7_no_pesel_44,
  t0.reg7_other_document AS reg7_other_document_45,
  t0.reg7_other_document_number AS reg7_other_document_number_46,
  t0.reg8_reg AS reg8_reg_47,
  t0.reg8_first_name AS reg8_first_name_48,
  t0.reg8_last_name AS reg8_last_name_49,
  t0.reg8_pesel AS reg8_pesel_50,
  t0.reg8_no_pesel AS reg8_no_pesel_51,
  t0.reg8_other_document AS reg8_other_document_52,
  t0.reg8_other_document_number AS reg8_other_document_number_53,
  t0.group_id AS group_id_54,
  t0.avatar_id AS avatar_id_55
FROM
  user t0
WHERE
  t0.id = ?

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.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.reg6_reg AS reg6_reg_33, t0.reg6_first_name AS reg6_first_name_34, t0.reg6_last_name AS reg6_last_name_35, t0.reg6_pesel AS reg6_pesel_36, t0.reg6_no_pesel AS reg6_no_pesel_37, t0.reg6_other_document AS reg6_other_document_38, t0.reg6_other_document_number AS reg6_other_document_number_39, t0.reg7_reg AS reg7_reg_40, t0.reg7_first_name AS reg7_first_name_41, t0.reg7_last_name AS reg7_last_name_42, t0.reg7_pesel AS reg7_pesel_43, t0.reg7_no_pesel AS reg7_no_pesel_44, t0.reg7_other_document AS reg7_other_document_45, t0.reg7_other_document_number AS reg7_other_document_number_46, t0.reg8_reg AS reg8_reg_47, t0.reg8_first_name AS reg8_first_name_48, t0.reg8_last_name AS reg8_last_name_49, t0.reg8_pesel AS reg8_pesel_50, t0.reg8_no_pesel AS reg8_no_pesel_51, t0.reg8_other_document AS reg8_other_document_52, t0.reg8_other_document_number AS reg8_other_document_number_53, t0.group_id AS group_id_54, t0.avatar_id AS avatar_id_55 FROM user t0 WHERE t0.id = 45392;

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_.created_at AS created_at_30,
  u0_.updated_at AS updated_at_31,
  u0_.reg6_reg AS reg6_reg_32,
  u0_.reg6_first_name AS reg6_first_name_33,
  u0_.reg6_last_name AS reg6_last_name_34,
  u0_.reg6_pesel AS reg6_pesel_35,
  u0_.reg6_no_pesel AS reg6_no_pesel_36,
  u0_.reg6_other_document AS reg6_other_document_37,
  u0_.reg6_other_document_number AS reg6_other_document_number_38,
  u0_.reg7_reg AS reg7_reg_39,
  u0_.reg7_first_name AS reg7_first_name_40,
  u0_.reg7_last_name AS reg7_last_name_41,
  u0_.reg7_pesel AS reg7_pesel_42,
  u0_.reg7_no_pesel AS reg7_no_pesel_43,
  u0_.reg7_other_document AS reg7_other_document_44,
  u0_.reg7_other_document_number AS reg7_other_document_number_45,
  u0_.reg8_reg AS reg8_reg_46,
  u0_.reg8_first_name AS reg8_first_name_47,
  u0_.reg8_last_name AS reg8_last_name_48,
  u0_.reg8_pesel AS reg8_pesel_49,
  u0_.reg8_no_pesel AS reg8_no_pesel_50,
  u0_.reg8_other_document AS reg8_other_document_51,
  u0_.reg8_other_document_number AS reg8_other_document_number_52,
  u0_.group_id AS group_id_53,
  u0_.avatar_id AS avatar_id_54
FROM
  user u0_
WHERE
  u0_.username = ?
  AND u0_.active = ?

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_.created_at AS created_at_30, u0_.updated_at AS updated_at_31, u0_.reg6_reg AS reg6_reg_32, u0_.reg6_first_name AS reg6_first_name_33, u0_.reg6_last_name AS reg6_last_name_34, u0_.reg6_pesel AS reg6_pesel_35, u0_.reg6_no_pesel AS reg6_no_pesel_36, u0_.reg6_other_document AS reg6_other_document_37, u0_.reg6_other_document_number AS reg6_other_document_number_38, u0_.reg7_reg AS reg7_reg_39, u0_.reg7_first_name AS reg7_first_name_40, u0_.reg7_last_name AS reg7_last_name_41, u0_.reg7_pesel AS reg7_pesel_42, u0_.reg7_no_pesel AS reg7_no_pesel_43, u0_.reg7_other_document AS reg7_other_document_44, u0_.reg7_other_document_number AS reg7_other_document_number_45, u0_.reg8_reg AS reg8_reg_46, u0_.reg8_first_name AS reg8_first_name_47, u0_.reg8_last_name AS reg8_last_name_48, u0_.reg8_pesel AS reg8_pesel_49, u0_.reg8_no_pesel AS reg8_no_pesel_50, u0_.reg8_other_document AS reg8_other_document_51, u0_.reg8_other_document_number AS reg8_other_document_number_52, u0_.group_id AS group_id_53, u0_.avatar_id AS avatar_id_54 FROM user u0_ WHERE u0_.username = 'ender.kozik@gmail.com' AND u0_.active = 1;

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.census_tract AS census_tract_13,
  t0.reg1 AS reg1_14,
  t0.reg2 AS reg2_15,
  t0.reg3 AS reg3_16,
  t0.reg4 AS reg4_17,
  t0.reg5 AS reg5_18,
  t0.guardian_first_name AS guardian_first_name_19,
  t0.guardian_last_name AS guardian_last_name_20,
  t0.guardian_pesel AS guardian_pesel_21,
  t0.pesel AS pesel_22,
  t0.no_pesel AS no_pesel_23,
  t0.other_document AS other_document_24,
  t0.other_document_number AS other_document_number_25,
  t0.birthday_at AS birthday_at_26,
  t0.nationality AS nationality_27,
  t0.sex AS sex_28,
  t0.senior AS senior_29,
  t0.first_name AS first_name_30,
  t0.last_name AS last_name_31,
  t0.email AS email_32,
  t0.phone AS phone_33,
  t0.updated_at AS updated_at_34,
  t0.id AS id_35,
  t0.deleted_at AS deleted_at_36,
  t0.hash AS hash_37,
  t0.stripe_customer_id AS stripe_customer_id_38,
  t0.polmed_token AS polmed_token_39,
  t0.polmed_id AS polmed_id_40,
  t0.polmed_packets AS polmed_packets_41,
  t0.polmed_has_chat_doctor AS polmed_has_chat_doctor_42,
  t0.wk_pesel AS wk_pesel_43,
  t0.wk_first_name AS wk_first_name_44,
  t0.wk_last_name AS wk_last_name_45,
  t0.has_user AS has_user_46,
  t0.dolegliwosci AS dolegliwosci_47,
  t0.alergie AS alergie_48,
  t0.choroby_przewlekle AS choroby_przewlekle_49,
  t0.leki AS leki_50,
  t0.notes AS notes_51,
  t0.pregnant AS pregnant_52,
  t0.doctor_id AS doctor_id_53,
  t0.user_id AS user_id_54
FROM
  patient t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.birthday_at ASC
LIMIT
  1

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.census_tract AS census_tract_13, t0.reg1 AS reg1_14, t0.reg2 AS reg2_15, t0.reg3 AS reg3_16, t0.reg4 AS reg4_17, t0.reg5 AS reg5_18, t0.guardian_first_name AS guardian_first_name_19, t0.guardian_last_name AS guardian_last_name_20, t0.guardian_pesel AS guardian_pesel_21, t0.pesel AS pesel_22, t0.no_pesel AS no_pesel_23, t0.other_document AS other_document_24, t0.other_document_number AS other_document_number_25, t0.birthday_at AS birthday_at_26, t0.nationality AS nationality_27, t0.sex AS sex_28, t0.senior AS senior_29, t0.first_name AS first_name_30, t0.last_name AS last_name_31, t0.email AS email_32, t0.phone AS phone_33, t0.updated_at AS updated_at_34, t0.id AS id_35, t0.deleted_at AS deleted_at_36, t0.hash AS hash_37, t0.stripe_customer_id AS stripe_customer_id_38, t0.polmed_token AS polmed_token_39, t0.polmed_id AS polmed_id_40, t0.polmed_packets AS polmed_packets_41, t0.polmed_has_chat_doctor AS polmed_has_chat_doctor_42, t0.wk_pesel AS wk_pesel_43, t0.wk_first_name AS wk_first_name_44, t0.wk_last_name AS wk_last_name_45, t0.has_user AS has_user_46, t0.dolegliwosci AS dolegliwosci_47, t0.alergie AS alergie_48, t0.choroby_przewlekle AS choroby_przewlekle_49, t0.leki AS leki_50, t0.notes AS notes_51, t0.pregnant AS pregnant_52, t0.doctor_id AS doctor_id_53, t0.user_id AS user_id_54 FROM patient t0 WHERE t0.user_id = 45392 ORDER BY t0.birthday_at ASC LIMIT 1;

SELECT
  c0_.id AS id_0
FROM
  chat_hour c0_
WHERE
  c0_.week_day = ?
  AND c0_.from_time <= ?
  AND c0_.to_time >= ?
LIMIT
  1

SELECT c0_.id AS id_0 FROM chat_hour c0_ WHERE c0_.week_day = 'N5' AND c0_.from_time <= '14:16:00' AND c0_.to_time >= '14:16:00' LIMIT 1;

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

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 = 1 AND (JSON_CONTAINS(u1_.roles, '\"ROLE_CONSULTANT\"', '$') = 1 OR JSON_CONTAINS(u3_.roles, '\"ROLE_CONSULTANT\"', '$') = 1) LIMIT 1;

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

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 = 155556 AND t0.closed = 0 AND t0.type = 'consultant' LIMIT 1;

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

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 = 155556 AND t0.closed = 0 AND t0.type = 'doctor' LIMIT 1;

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 = ?

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 = 155556 AND t0.closed = 0;