POST https://consentz.tribital.com/admin/message/get_total_unread_messages

Query Metrics

4 Database Queries
4 Different statements
1.92 ms Query time
2 Invalid entities
4 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.85 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.full_name AS full_name_6, t0.password AS password_7, t0.booking_btn_name AS booking_btn_name_8, t0.booking_btn_clr AS booking_btn_clr_9, t0.booking_btn_bg_clr AS booking_btn_bg_clr_10, t0.inner_color AS inner_color_11, t0.outer_color AS outer_color_12, t0.background_img AS background_img_13, t0.profile_img AS profile_img_14, t0.role AS role_15, t0.enabled AS enabled_16, t0.locked AS locked_17, t0.visible AS visible_18, t0.is_disengaged AS is_disengaged_19, t0.otp AS otp_20, t0.otp_sent_at AS otp_sent_at_21, t0.last_otp_verified AS last_otp_verified_22, t0.imap_setting AS imap_setting_23, t0.country_code AS country_code_24, t0.phone AS phone_25, t0.practitioner_commission AS practitioner_commission_26, t0.coordinator_commission AS coordinator_commission_27, t0.course_commission AS course_commission_28, t0.membership_commission AS membership_commission_29, t0.product_commission AS product_commission_30, t0.token AS token_31, t0.access_all_calendars AS access_all_calendars_32, t0.current_auth_token AS current_auth_token_33, t0.last_auth_time AS last_auth_time_34, t0.hash AS hash_35, t0.fcm_token AS fcm_token_36, t0.hx_change_token AS hx_change_token_37, t0.login_from AS login_from_38, t0.ever_login_in_v3 AS ever_login_in_v3_39, t0.permissions AS permissions_40, t0.clinic_id AS clinic_id_41, t0.fp_promoter_id AS fp_promoter_id_42, t0.referral_link AS referral_link_43, t0.fp_tracking_id AS fp_tracking_id_44, t0.receive_special_offer_email AS receive_special_offer_email_45, t0.receive_special_offer_sms AS receive_special_offer_sms_46, t0.deleted_at AS deleted_at_47, t0.created_at AS created_at_48, t0.updated_at AS updated_at_49, t0.media_id AS media_id_50, t0.device_id AS device_id_51, t0.created_by_id AS created_by_id_52, t0.type, t0.stripe_customer_id AS stripe_customer_id_53, t0.stripe_customer_id AS stripe_customer_id_54, t0.organisation_id AS organisation_id_55, t0.current_clinic_id AS current_clinic_id_56, t0.status AS status_57, t0.birthday AS birthday_58, t0.country_code_alt AS country_code_alt_59, t0.secondary_phone AS secondary_phone_60, t0.next_kin AS next_kin_61, t0.next_kin_phone AS next_kin_phone_62, t0.description AS description_63, t0.glogau_scale AS glogau_scale_64, t0.fitzpatrick_scale AS fitzpatrick_scale_65, t0.gender AS gender_66, t0.receive_special_offer_push AS receive_special_offer_push_67, t0.receive_reminder_email AS receive_reminder_email_68, t0.receive_reminder_sms AS receive_reminder_sms_69, t0.receive_reminder_push AS receive_reminder_push_70, t0.parent_user_id AS parent_user_id_71, t0.account_type AS account_type_72, t0.terms_accepted AS terms_accepted_73, t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_74, t0.referral AS referral_75, t0.export_in_progress AS export_in_progress_76, t0.occupation AS occupation_77, t0.number_nhs AS number_nhs_78, t0.gp_name AS gp_name_79, t0.contact_gp AS contact_gp_80, t0.gp_address1 AS gp_address1_81, t0.gp_address2 AS gp_address2_82, t0.gp_town AS gp_town_83, t0.gp_county AS gp_county_84, t0.gp_post_code AS gp_post_code_85, t0.gp_country AS gp_country_86, t0.ref AS ref_87, t0.chronoscan_code AS chronoscan_code_88, t0.ethnicity AS ethnicity_89, t0.height AS height_90, t0.weight AS weight_91, t0.passport AS passport_92, t0.reference_number AS reference_number_93, t0.photo_consent AS photo_consent_94, t0.all_marketing AS all_marketing_95, t0.in_clinic_marketing AS in_clinic_marketing_96, t0.in_consultation AS in_consultation_97, t0.interested_in AS interested_in_98, t0.consultation_type AS consultation_type_99, t0.google_click_id AS google_click_id_100, t0.campaign_name AS campaign_name_101, t0.campaign_source AS campaign_source_102, t0.campaign_medium AS campaign_medium_103, t0.campaign_term AS campaign_term_104, t0.campaign_content AS campaign_content_105, t0.marketing_source AS marketing_source_106, t0.author AS author_107, t0.address1 AS address1_108, t0.address2 AS address2_109, t0.town AS town_110, t0.state AS state_111, t0.country AS country_112, t0.postcode AS postcode_113, t0.parent_id AS parent_id_114, t0.active_photo_id AS active_photo_id_115, t0.bar_code_image_id AS bar_code_image_id_116, t0.clinic_id AS clinic_id_117, t0.prospect_id AS prospect_id_118, t0.qualification AS qualification_119, t0.summary AS summary_120, t0.deleted AS deleted_121, t0.calendar_color AS calendar_color_122, t0.calendar_order_number AS calendar_order_number_123, t0.calendar_id AS calendar_id_124, t0.position AS position_125, t0.online_booking_availability AS online_booking_availability_126, t0.title AS title_127, t0.email_verify AS email_verify_128, t0.hash_user_short_url AS hash_user_short_url_129, t0.licence_number AS licence_number_130, t0.stripe_customer_id AS stripe_customer_id_131, t0.is_online AS is_online_132, t0.last_call_time AS last_call_time_133, t0.hide_report_menus AS hide_report_menus_134, t0.clinic_id AS clinic_id_135, t0.i_calendar_id AS i_calendar_id_136 FROM user t0 WHERE t0.id = ? AND t0.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user')
Parameters:
[
  3229
]
2 0.45 ms
SELECT cm.* FROM `chat_messages` as cm join conversation as c on c.id=cm.conversation_id where not FIND_IN_SET(?,cm.read_user_ids) and FIND_IN_SET(?,c.user_ids) limit 1
Parameters:
[
  3229
  3229
]
3 0.29 ms
SELECT c.*,pc.clinic_id FROM communication as c join patient_conversation as pc on pc.id=c.conversation_id where  pc.clinic_id=? and c.read_status=0 and c.sender_type=? LIMIT 1
Parameters:
[
  "3"
  1
]
4 0.32 ms
SELECT c.*,pc.clinic_id FROM prospect_communication as c join prospect_conversation as pc on pc.id=c.conversation_id where pc.clinic_id=? and c.read_status=0 and c.sender_type=? LIMIT 1
Parameters:
[
  "3"
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection
pgsql doctrine.dbal.pgsql_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\Person\User 1
App\Entity\Media\Media 1
App\Entity\Clinic\Clinic 1
App\Entity\Organisation\Organisation 1

Entities Mapping

Class Mapping errors
App\Entity\Person\User No errors.
App\Entity\Media\Media No errors.
App\Entity\Person\Device No errors.
App\Entity\Person\Admin No errors.
App\Entity\Person\AdminSupport No errors.
App\Entity\Clinic\Person\ClinicUser No errors.
App\Entity\Person\SuperClinicAdmin No errors.
App\Entity\Organisation\Organisation No errors.
App\Entity\Clinic\Clinic
  • The mappings App\Entity\Clinic\Clinic#memberships and App\Entity\Clinic\Membership\Membership#clinic are inconsistent with each other.
App\Entity\Person\Patient No errors.
App\Entity\Patient\Photo No errors.
App\Entity\LeadCapture\LeadCapture No errors.
App\Entity\ProspectsMessage No errors.
App\Entity\Clinic\Appointment No errors.
App\Entity\Event No errors.
App\Entity\Patient\TreatmentPlan
  • The mappings App\Entity\Patient\TreatmentPlan#superClinicAdmin and App\Entity\Person\SuperClinicAdmin#treatmentPlans are inconsistent with each other.
App\Entity\Patient\BaseInvoice No errors.
App\Entity\Clinic\Stock\TreatmentClinic No errors.
App\Entity\Clinic\Person\DailySchedule No errors.