No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT COUNT(*) AS `count` FROM `pvers`.`transfusions` AS `Transfusion` WHERE `Transfusion`.`id` = 644 | 1 | 1 | 5 | maybe slow |
SELECT `Transfusion`.`id`, `Transfusion`.`user_id`, `Transfusion`.`pqmp_id`, `Transfusion`.`transfusion_id`, `Transfusion`.`reference_no`, `Transfusion`.`county_id`, `Transfusion`.`designation_id`, `Transfusion`.`form_type`, `Transfusion`.`patient_name`, `Transfusion`.`gender`, `Transfusion`.`patient_address`, `Transfusion`.`patient_phone`, `Transfusion`.`date_of_birth`, `Transfusion`.`age_years`, `Transfusion`.`diagnosis`, `Transfusion`.`ward`, `Transfusion`.`pre_hb`, `Transfusion`.`transfusion_reason`, `Transfusion`.`current_medications`, `Transfusion`.`obstetric_history`, `Transfusion`.`previous_transfusion`, `Transfusion`.`transfusion_comment`, `Transfusion`.`previous_reactions`, `Transfusion`.`reaction_comment`, `Transfusion`.`reaction_general`, `Transfusion`.`reaction_fever`, `Transfusion`.`reaction_chills`, `Transfusion`.`reaction_flushing`, `Transfusion`.`reaction_vomiting`, `Transfusion`.`reaction_dermatological`, `Transfusion`.`reaction_cardiac`, `Transfusion`.`reaction_chest`, `Transfusion`.`reaction_dyspnoea`, `Transfusion`.`reaction_hypotension`, `Transfusion`.`reaction_tachycardia`, `Transfusion`.`reaction_renal`, `Transfusion`.`reaction_anuria`, `Transfusion`.`reaction_oliguria`, `Transfusion`.`reaction_dark`, `Transfusion`.`reaction_haematological`, `Transfusion`.`reaction_other`, `Transfusion`.`vital_start_bp`, `Transfusion`.`vital_start_t`, `Transfusion`.`vital_start_p`, `Transfusion`.`vital_start_r`, `Transfusion`.`vital_during_bp`, `Transfusion`.`vital_during_t`, `Transfusion`.`vital_during_p`, `Transfusion`.`vital_during_r`, `Transfusion`.`vital_stop_bp`, `Transfusion`.`vital_stop_t`, `Transfusion`.`vital_stop_p`, `Transfusion`.`vital_stop_r`, `Transfusion`.`nurse_name`, `Transfusion`.`lab_hemolysis`, `Transfusion`.`lab_hemolysis_present`, `Transfusion`.`recipient_blood`, `Transfusion`.`hae_wbc`, `Transfusion`.`hae_hb`, `Transfusion`.`hae_rbc`, `Transfusion`.`hae_hct`, `Transfusion`.`hae_mcv`, `Transfusion`.`hae_mch`, `Transfusion`.`hae_mchc`, `Transfusion`.`hae_plt`, `Transfusion`.`film_rbc`, `Transfusion`.`film_wbc`, `Transfusion`.`film_plt`, `Transfusion`.`donor_hemolysis`, `Transfusion`.`donor_age`, `Transfusion`.`culture_donor_pack`, `Transfusion`.`culture_recipient_blood`, `Transfusion`.`compatible_saline_rt`, `Transfusion`.`compatible_saline_ii`, `Transfusion`.`compatible_ahg`, `Transfusion`.`compatible_albumin`, `Transfusion`.`negative_result`, `Transfusion`.`anti_a`, `Transfusion`.`anti_b`, `Transfusion`.`urinalysis`, `Transfusion`.`evaluation`, `Transfusion`.`adverse_reaction`, `Transfusion`.`reporter_name`, `Transfusion`.`reporter_email`, `Transfusion`.`reporter_phone`, `Transfusion`.`report_type`, `Transfusion`.`submitted`, `Transfusion`.`submitted_date`, `Transfusion`.`copied`, `Transfusion`.`archived`, `Transfusion`.`archived_date`, `Transfusion`.`active`, `Transfusion`.`created`, `Transfusion`.`modified`, `Transfusion`.`reporter_date`, `Transfusion`.`person_submitting`, `Transfusion`.`reporter_name_diff`, `Transfusion`.`reporter_designation_diff`, `Transfusion`.`reporter_email_diff`, `Transfusion`.`reporter_phone_diff`, `Transfusion`.`reporter_date_diff`, `Transfusion`.`assigned_to`, `Transfusion`.`assigned_by`, `Transfusion`.`assigned_date`, `Transfusion`.`clinic_venue`, `Transfusion`.`specimens_post_transfusion`, `Transfusion`.`specimens_edta_blood`, `Transfusion`.`specimens_void_urine`, `Transfusion`.`specimens_blood_reacted`, `Transfusion`.`specimens_blood_bags`, `Transfusion`.`clinic_code`, `Transfusion`.`donor_number`, `Transfusion`.`national_number`, `Transfusion`.`home_phone`, `Transfusion`.`cell_phone`, `Transfusion`.`email_address`, `Transfusion`.`residence`, `Transfusion`.`nurse_date`, `Transfusion`.`low_volume`, `Transfusion`.`venepuncture`, `Transfusion`.`hematoma`, `Transfusion`.`faint`, `Transfusion`.`deleted`, `Transfusion`.`deleted_date`, `User`.`id`, `User`.`designation_id`, `User`.`county_id`, `User`.`username`, `User`.`password`, `User`.`confirm_password`, `User`.`name`, `User`.`email`, `User`.`group_id`, `User`.`name_of_institution`, `User`.`institution_address`, `User`.`institution_code`, `User`.`institution_email`, `User`.`institution_contact`, `User`.`ward`, `User`.`phone_no`, `User`.`forgot_password`, `User`.`initial_email`, `User`.`is_active`, `User`.`is_admin`, `User`.`deleted`, `User`.`deleted_date`, `User`.`created`, `User`.`modified`, `User`.`user_type`, `User`.`sponsor_email`, `User`.`health_program`, `User`.`active_date`, `County`.`id`, `County`.`county_name`, `County`.`org_unit`, `County`.`created`, `County`.`modified`, `Designation`.`id`, `Designation`.`name`, `Designation`.`category`, `Designation`.`created`, `Designation`.`modified`, `TransfusionOriginal`.`id`, `TransfusionOriginal`.`user_id`, `TransfusionOriginal`.`pqmp_id`, `TransfusionOriginal`.`transfusion_id`, `TransfusionOriginal`.`reference_no`, `TransfusionOriginal`.`county_id`, `TransfusionOriginal`.`designation_id`, `TransfusionOriginal`.`form_type`, `TransfusionOriginal`.`patient_name`, `TransfusionOriginal`.`gender`, `TransfusionOriginal`.`patient_address`, `TransfusionOriginal`.`patient_phone`, `TransfusionOriginal`.`date_of_birth`, `TransfusionOriginal`.`age_years`, `TransfusionOriginal`.`diagnosis`, `TransfusionOriginal`.`ward`, `TransfusionOriginal`.`pre_hb`, `TransfusionOriginal`.`transfusion_reason`, `TransfusionOriginal`.`current_medications`, `TransfusionOriginal`.`obstetric_history`, `TransfusionOriginal`.`previous_transfusion`, `TransfusionOriginal`.`transfusion_comment`, `TransfusionOriginal`.`previous_reactions`, `TransfusionOriginal`.`reaction_comment`, `TransfusionOriginal`.`reaction_general`, `TransfusionOriginal`.`reaction_fever`, `TransfusionOriginal`.`reaction_chills`, `TransfusionOriginal`.`reaction_flushing`, `TransfusionOriginal`.`reaction_vomiting`, `TransfusionOriginal`.`reaction_dermatological`, `TransfusionOriginal`.`reaction_cardiac`, `TransfusionOriginal`.`reaction_chest`, `TransfusionOriginal`.`reaction_dyspnoea`, `TransfusionOriginal`.`reaction_hypotension`, `TransfusionOriginal`.`reaction_tachycardia`, `TransfusionOriginal`.`reaction_renal`, `TransfusionOriginal`.`reaction_anuria`, `TransfusionOriginal`.`reaction_oliguria`, `TransfusionOriginal`.`reaction_dark`, `TransfusionOriginal`.`reaction_haematological`, `TransfusionOriginal`.`reaction_other`, `TransfusionOriginal`.`vital_start_bp`, `TransfusionOriginal`.`vital_start_t`, `TransfusionOriginal`.`vital_start_p`, `TransfusionOriginal`.`vital_start_r`, `TransfusionOriginal`.`vital_during_bp`, `TransfusionOriginal`.`vital_during_t`, `TransfusionOriginal`.`vital_during_p`, `TransfusionOriginal`.`vital_during_r`, `TransfusionOriginal`.`vital_stop_bp`, `TransfusionOriginal`.`vital_stop_t`, `TransfusionOriginal`.`vital_stop_p`, `TransfusionOriginal`.`vital_stop_r`, `TransfusionOriginal`.`nurse_name`, `TransfusionOriginal`.`lab_hemolysis`, `TransfusionOriginal`.`lab_hemolysis_present`, `TransfusionOriginal`.`recipient_blood`, `TransfusionOriginal`.`hae_wbc`, `TransfusionOriginal`.`hae_hb`, `TransfusionOriginal`.`hae_rbc`, `TransfusionOriginal`.`hae_hct`, `TransfusionOriginal`.`hae_mcv`, `TransfusionOriginal`.`hae_mch`, `TransfusionOriginal`.`hae_mchc`, `TransfusionOriginal`.`hae_plt`, `TransfusionOriginal`.`film_rbc`, `TransfusionOriginal`.`film_wbc`, `TransfusionOriginal`.`film_plt`, `TransfusionOriginal`.`donor_hemolysis`, `TransfusionOriginal`.`donor_age`, `TransfusionOriginal`.`culture_donor_pack`, `TransfusionOriginal`.`culture_recipient_blood`, `TransfusionOriginal`.`compatible_saline_rt`, `TransfusionOriginal`.`compatible_saline_ii`, `TransfusionOriginal`.`compatible_ahg`, `TransfusionOriginal`.`compatible_albumin`, `TransfusionOriginal`.`negative_result`, `TransfusionOriginal`.`anti_a`, `TransfusionOriginal`.`anti_b`, `TransfusionOriginal`.`urinalysis`, `TransfusionOriginal`.`evaluation`, `TransfusionOriginal`.`adverse_reaction`, `TransfusionOriginal`.`reporter_name`, `TransfusionOriginal`.`reporter_email`, `TransfusionOriginal`.`reporter_phone`, `TransfusionOriginal`.`report_type`, `TransfusionOriginal`.`submitted`, `TransfusionOriginal`.`submitted_date`, `TransfusionOriginal`.`copied`, `TransfusionOriginal`.`archived`, `TransfusionOriginal`.`archived_date`, `TransfusionOriginal`.`active`, `TransfusionOriginal`.`created`, `TransfusionOriginal`.`modified`, `TransfusionOriginal`.`reporter_date`, `TransfusionOriginal`.`person_submitting`, `TransfusionOriginal`.`reporter_name_diff`, `TransfusionOriginal`.`reporter_designation_diff`, `TransfusionOriginal`.`reporter_email_diff`, `TransfusionOriginal`.`reporter_phone_diff`, `TransfusionOriginal`.`reporter_date_diff`, `TransfusionOriginal`.`assigned_to`, `TransfusionOriginal`.`assigned_by`, `TransfusionOriginal`.`assigned_date`, `TransfusionOriginal`.`clinic_venue`, `TransfusionOriginal`.`specimens_post_transfusion`, `TransfusionOriginal`.`specimens_edta_blood`, `TransfusionOriginal`.`specimens_void_urine`, `TransfusionOriginal`.`specimens_blood_reacted`, `TransfusionOriginal`.`specimens_blood_bags`, `TransfusionOriginal`.`clinic_code`, `TransfusionOriginal`.`donor_number`, `TransfusionOriginal`.`national_number`, `TransfusionOriginal`.`home_phone`, `TransfusionOriginal`.`cell_phone`, `TransfusionOriginal`.`email_address`, `TransfusionOriginal`.`residence`, `TransfusionOriginal`.`nurse_date`, `TransfusionOriginal`.`low_volume`, `TransfusionOriginal`.`venepuncture`, `TransfusionOriginal`.`hematoma`, `TransfusionOriginal`.`faint`, `TransfusionOriginal`.`deleted`, `TransfusionOriginal`.`deleted_date` FROM `pvers`.`transfusions` AS `Transfusion` LEFT JOIN `pvers`.`users` AS `User` ON (`Transfusion`.`user_id` = `User`.`id`) LEFT JOIN `pvers`.`counties` AS `County` ON (`Transfusion`.`county_id` = `County`.`id`) LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Transfusion`.`designation_id` = `Designation`.`id`) LEFT JOIN `pvers`.`transfusions` AS `TransfusionOriginal` ON (`Transfusion`.`transfusion_id` = `TransfusionOriginal`.`id` AND `TransfusionOriginal`.`copied` = 1) WHERE `Transfusion`.`id` = 644 LIMIT 1 | 1 | 1 | 7 | maybe slow |
SELECT `TransfusionFollowup`.`id`, `TransfusionFollowup`.`user_id`, `TransfusionFollowup`.`pqmp_id`, `TransfusionFollowup`.`transfusion_id`, `TransfusionFollowup`.`reference_no`, `TransfusionFollowup`.`county_id`, `TransfusionFollowup`.`designation_id`, `TransfusionFollowup`.`form_type`, `TransfusionFollowup`.`patient_name`, `TransfusionFollowup`.`gender`, `TransfusionFollowup`.`patient_address`, `TransfusionFollowup`.`patient_phone`, `TransfusionFollowup`.`date_of_birth`, `TransfusionFollowup`.`age_years`, `TransfusionFollowup`.`diagnosis`, `TransfusionFollowup`.`ward`, `TransfusionFollowup`.`pre_hb`, `TransfusionFollowup`.`transfusion_reason`, `TransfusionFollowup`.`current_medications`, `TransfusionFollowup`.`obstetric_history`, `TransfusionFollowup`.`previous_transfusion`, `TransfusionFollowup`.`transfusion_comment`, `TransfusionFollowup`.`previous_reactions`, `TransfusionFollowup`.`reaction_comment`, `TransfusionFollowup`.`reaction_general`, `TransfusionFollowup`.`reaction_fever`, `TransfusionFollowup`.`reaction_chills`, `TransfusionFollowup`.`reaction_flushing`, `TransfusionFollowup`.`reaction_vomiting`, `TransfusionFollowup`.`reaction_dermatological`, `TransfusionFollowup`.`reaction_cardiac`, `TransfusionFollowup`.`reaction_chest`, `TransfusionFollowup`.`reaction_dyspnoea`, `TransfusionFollowup`.`reaction_hypotension`, `TransfusionFollowup`.`reaction_tachycardia`, `TransfusionFollowup`.`reaction_renal`, `TransfusionFollowup`.`reaction_anuria`, `TransfusionFollowup`.`reaction_oliguria`, `TransfusionFollowup`.`reaction_dark`, `TransfusionFollowup`.`reaction_haematological`, `TransfusionFollowup`.`reaction_other`, `TransfusionFollowup`.`vital_start_bp`, `TransfusionFollowup`.`vital_start_t`, `TransfusionFollowup`.`vital_start_p`, `TransfusionFollowup`.`vital_start_r`, `TransfusionFollowup`.`vital_during_bp`, `TransfusionFollowup`.`vital_during_t`, `TransfusionFollowup`.`vital_during_p`, `TransfusionFollowup`.`vital_during_r`, `TransfusionFollowup`.`vital_stop_bp`, `TransfusionFollowup`.`vital_stop_t`, `TransfusionFollowup`.`vital_stop_p`, `TransfusionFollowup`.`vital_stop_r`, `TransfusionFollowup`.`nurse_name`, `TransfusionFollowup`.`lab_hemolysis`, `TransfusionFollowup`.`lab_hemolysis_present`, `TransfusionFollowup`.`recipient_blood`, `TransfusionFollowup`.`hae_wbc`, `TransfusionFollowup`.`hae_hb`, `TransfusionFollowup`.`hae_rbc`, `TransfusionFollowup`.`hae_hct`, `TransfusionFollowup`.`hae_mcv`, `TransfusionFollowup`.`hae_mch`, `TransfusionFollowup`.`hae_mchc`, `TransfusionFollowup`.`hae_plt`, `TransfusionFollowup`.`film_rbc`, `TransfusionFollowup`.`film_wbc`, `TransfusionFollowup`.`film_plt`, `TransfusionFollowup`.`donor_hemolysis`, `TransfusionFollowup`.`donor_age`, `TransfusionFollowup`.`culture_donor_pack`, `TransfusionFollowup`.`culture_recipient_blood`, `TransfusionFollowup`.`compatible_saline_rt`, `TransfusionFollowup`.`compatible_saline_ii`, `TransfusionFollowup`.`compatible_ahg`, `TransfusionFollowup`.`compatible_albumin`, `TransfusionFollowup`.`negative_result`, `TransfusionFollowup`.`anti_a`, `TransfusionFollowup`.`anti_b`, `TransfusionFollowup`.`urinalysis`, `TransfusionFollowup`.`evaluation`, `TransfusionFollowup`.`adverse_reaction`, `TransfusionFollowup`.`reporter_name`, `TransfusionFollowup`.`reporter_email`, `TransfusionFollowup`.`reporter_phone`, `TransfusionFollowup`.`report_type`, `TransfusionFollowup`.`submitted`, `TransfusionFollowup`.`submitted_date`, `TransfusionFollowup`.`copied`, `TransfusionFollowup`.`archived`, `TransfusionFollowup`.`archived_date`, `TransfusionFollowup`.`active`, `TransfusionFollowup`.`created`, `TransfusionFollowup`.`modified`, `TransfusionFollowup`.`reporter_date`, `TransfusionFollowup`.`person_submitting`, `TransfusionFollowup`.`reporter_name_diff`, `TransfusionFollowup`.`reporter_designation_diff`, `TransfusionFollowup`.`reporter_email_diff`, `TransfusionFollowup`.`reporter_phone_diff`, `TransfusionFollowup`.`reporter_date_diff`, `TransfusionFollowup`.`assigned_to`, `TransfusionFollowup`.`assigned_by`, `TransfusionFollowup`.`assigned_date`, `TransfusionFollowup`.`clinic_venue`, `TransfusionFollowup`.`specimens_post_transfusion`, `TransfusionFollowup`.`specimens_edta_blood`, `TransfusionFollowup`.`specimens_void_urine`, `TransfusionFollowup`.`specimens_blood_reacted`, `TransfusionFollowup`.`specimens_blood_bags`, `TransfusionFollowup`.`clinic_code`, `TransfusionFollowup`.`donor_number`, `TransfusionFollowup`.`national_number`, `TransfusionFollowup`.`home_phone`, `TransfusionFollowup`.`cell_phone`, `TransfusionFollowup`.`email_address`, `TransfusionFollowup`.`residence`, `TransfusionFollowup`.`nurse_date`, `TransfusionFollowup`.`low_volume`, `TransfusionFollowup`.`venepuncture`, `TransfusionFollowup`.`hematoma`, `TransfusionFollowup`.`faint`, `TransfusionFollowup`.`deleted`, `TransfusionFollowup`.`deleted_date` FROM `pvers`.`transfusions` AS `TransfusionFollowup` WHERE `TransfusionFollowup`.`report_type` = 'Followup' AND `TransfusionFollowup`.`transfusion_id` = (644) | 0 | 0 | 3 | maybe slow |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`file`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`description`, `Attachment`.`year`, `Attachment`.`file_date`, `Attachment`.`pocket_name`, `Attachment`.`version_no`, `Attachment`.`created`, `Attachment`.`modified` FROM `pvers`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Transfusion' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (644) | 0 | 0 | 1 | maybe slow |
SELECT `Pint`.`id`, `Pint`.`transfusion_id`, `Pint`.`component_type`, `Pint`.`pint_no`, `Pint`.`expiry_date`, `Pint`.`volume_transfused`, `Pint`.`created`, `Pint`.`modified` FROM `pvers`.`pints` AS `Pint` WHERE `Pint`.`transfusion_id` = (644) | 0 | 0 | 1 | maybe slow |
SELECT `ExternalComment`.`id`, `ExternalComment`.`foreign_key`, `ExternalComment`.`user_id`, `ExternalComment`.`model_id`, `ExternalComment`.`model`, `ExternalComment`.`category`, `ExternalComment`.`sender`, `ExternalComment`.`subject`, `ExternalComment`.`content`, `ExternalComment`.`review`, `ExternalComment`.`deleted`, `ExternalComment`.`created`, `ExternalComment`.`modified` FROM `pvers`.`comments` AS `ExternalComment` WHERE `ExternalComment`.`model` = 'Transfusion' AND `ExternalComment`.`category` = 'external' AND `ExternalComment`.`foreign_key` = (644) | 0 | 0 | 1 | maybe slow |
SELECT `ReviewComment`.`id`, `ReviewComment`.`foreign_key`, `ReviewComment`.`user_id`, `ReviewComment`.`model_id`, `ReviewComment`.`model`, `ReviewComment`.`category`, `ReviewComment`.`sender`, `ReviewComment`.`subject`, `ReviewComment`.`content`, `ReviewComment`.`review`, `ReviewComment`.`deleted`, `ReviewComment`.`created`, `ReviewComment`.`modified` FROM `pvers`.`comments` AS `ReviewComment` WHERE `ReviewComment`.`model` = 'Transfusion' AND `ReviewComment`.`category` = 'review' AND `ReviewComment`.`foreign_key` = (644) | 0 | 0 | 0 | |
SELECT `Transfusion`.`id`, `Transfusion`.`user_id`, `Transfusion`.`pqmp_id`, `Transfusion`.`transfusion_id`, `Transfusion`.`reference_no`, `Transfusion`.`county_id`, `Transfusion`.`designation_id`, `Transfusion`.`form_type`, `Transfusion`.`patient_name`, `Transfusion`.`gender`, `Transfusion`.`patient_address`, `Transfusion`.`patient_phone`, `Transfusion`.`date_of_birth`, `Transfusion`.`age_years`, `Transfusion`.`diagnosis`, `Transfusion`.`ward`, `Transfusion`.`pre_hb`, `Transfusion`.`transfusion_reason`, `Transfusion`.`current_medications`, `Transfusion`.`obstetric_history`, `Transfusion`.`previous_transfusion`, `Transfusion`.`transfusion_comment`, `Transfusion`.`previous_reactions`, `Transfusion`.`reaction_comment`, `Transfusion`.`reaction_general`, `Transfusion`.`reaction_fever`, `Transfusion`.`reaction_chills`, `Transfusion`.`reaction_flushing`, `Transfusion`.`reaction_vomiting`, `Transfusion`.`reaction_dermatological`, `Transfusion`.`reaction_cardiac`, `Transfusion`.`reaction_chest`, `Transfusion`.`reaction_dyspnoea`, `Transfusion`.`reaction_hypotension`, `Transfusion`.`reaction_tachycardia`, `Transfusion`.`reaction_renal`, `Transfusion`.`reaction_anuria`, `Transfusion`.`reaction_oliguria`, `Transfusion`.`reaction_dark`, `Transfusion`.`reaction_haematological`, `Transfusion`.`reaction_other`, `Transfusion`.`vital_start_bp`, `Transfusion`.`vital_start_t`, `Transfusion`.`vital_start_p`, `Transfusion`.`vital_start_r`, `Transfusion`.`vital_during_bp`, `Transfusion`.`vital_during_t`, `Transfusion`.`vital_during_p`, `Transfusion`.`vital_during_r`, `Transfusion`.`vital_stop_bp`, `Transfusion`.`vital_stop_t`, `Transfusion`.`vital_stop_p`, `Transfusion`.`vital_stop_r`, `Transfusion`.`nurse_name`, `Transfusion`.`lab_hemolysis`, `Transfusion`.`lab_hemolysis_present`, `Transfusion`.`recipient_blood`, `Transfusion`.`hae_wbc`, `Transfusion`.`hae_hb`, `Transfusion`.`hae_rbc`, `Transfusion`.`hae_hct`, `Transfusion`.`hae_mcv`, `Transfusion`.`hae_mch`, `Transfusion`.`hae_mchc`, `Transfusion`.`hae_plt`, `Transfusion`.`film_rbc`, `Transfusion`.`film_wbc`, `Transfusion`.`film_plt`, `Transfusion`.`donor_hemolysis`, `Transfusion`.`donor_age`, `Transfusion`.`culture_donor_pack`, `Transfusion`.`culture_recipient_blood`, `Transfusion`.`compatible_saline_rt`, `Transfusion`.`compatible_saline_ii`, `Transfusion`.`compatible_ahg`, `Transfusion`.`compatible_albumin`, `Transfusion`.`negative_result`, `Transfusion`.`anti_a`, `Transfusion`.`anti_b`, `Transfusion`.`urinalysis`, `Transfusion`.`evaluation`, `Transfusion`.`adverse_reaction`, `Transfusion`.`reporter_name`, `Transfusion`.`reporter_email`, `Transfusion`.`reporter_phone`, `Transfusion`.`report_type`, `Transfusion`.`submitted`, `Transfusion`.`submitted_date`, `Transfusion`.`copied`, `Transfusion`.`archived`, `Transfusion`.`archived_date`, `Transfusion`.`active`, `Transfusion`.`created`, `Transfusion`.`modified`, `Transfusion`.`reporter_date`, `Transfusion`.`person_submitting`, `Transfusion`.`reporter_name_diff`, `Transfusion`.`reporter_designation_diff`, `Transfusion`.`reporter_email_diff`, `Transfusion`.`reporter_phone_diff`, `Transfusion`.`reporter_date_diff`, `Transfusion`.`assigned_to`, `Transfusion`.`assigned_by`, `Transfusion`.`assigned_date`, `Transfusion`.`clinic_venue`, `Transfusion`.`specimens_post_transfusion`, `Transfusion`.`specimens_edta_blood`, `Transfusion`.`specimens_void_urine`, `Transfusion`.`specimens_blood_reacted`, `Transfusion`.`specimens_blood_bags`, `Transfusion`.`clinic_code`, `Transfusion`.`donor_number`, `Transfusion`.`national_number`, `Transfusion`.`home_phone`, `Transfusion`.`cell_phone`, `Transfusion`.`email_address`, `Transfusion`.`residence`, `Transfusion`.`nurse_date`, `Transfusion`.`low_volume`, `Transfusion`.`venepuncture`, `Transfusion`.`hematoma`, `Transfusion`.`faint`, `Transfusion`.`deleted`, `Transfusion`.`deleted_date`, `User`.`id`, `User`.`designation_id`, `User`.`county_id`, `User`.`username`, `User`.`password`, `User`.`confirm_password`, `User`.`name`, `User`.`email`, `User`.`group_id`, `User`.`name_of_institution`, `User`.`institution_address`, `User`.`institution_code`, `User`.`institution_email`, `User`.`institution_contact`, `User`.`ward`, `User`.`phone_no`, `User`.`forgot_password`, `User`.`initial_email`, `User`.`is_active`, `User`.`is_admin`, `User`.`deleted`, `User`.`deleted_date`, `User`.`created`, `User`.`modified`, `User`.`user_type`, `User`.`sponsor_email`, `User`.`health_program`, `User`.`active_date`, `County`.`id`, `County`.`county_name`, `County`.`org_unit`, `County`.`created`, `County`.`modified`, `Designation`.`id`, `Designation`.`name`, `Designation`.`category`, `Designation`.`created`, `Designation`.`modified`, `TransfusionOriginal`.`id`, `TransfusionOriginal`.`user_id`, `TransfusionOriginal`.`pqmp_id`, `TransfusionOriginal`.`transfusion_id`, `TransfusionOriginal`.`reference_no`, `TransfusionOriginal`.`county_id`, `TransfusionOriginal`.`designation_id`, `TransfusionOriginal`.`form_type`, `TransfusionOriginal`.`patient_name`, `TransfusionOriginal`.`gender`, `TransfusionOriginal`.`patient_address`, `TransfusionOriginal`.`patient_phone`, `TransfusionOriginal`.`date_of_birth`, `TransfusionOriginal`.`age_years`, `TransfusionOriginal`.`diagnosis`, `TransfusionOriginal`.`ward`, `TransfusionOriginal`.`pre_hb`, `TransfusionOriginal`.`transfusion_reason`, `TransfusionOriginal`.`current_medications`, `TransfusionOriginal`.`obstetric_history`, `TransfusionOriginal`.`previous_transfusion`, `TransfusionOriginal`.`transfusion_comment`, `TransfusionOriginal`.`previous_reactions`, `TransfusionOriginal`.`reaction_comment`, `TransfusionOriginal`.`reaction_general`, `TransfusionOriginal`.`reaction_fever`, `TransfusionOriginal`.`reaction_chills`, `TransfusionOriginal`.`reaction_flushing`, `TransfusionOriginal`.`reaction_vomiting`, `TransfusionOriginal`.`reaction_dermatological`, `TransfusionOriginal`.`reaction_cardiac`, `TransfusionOriginal`.`reaction_chest`, `TransfusionOriginal`.`reaction_dyspnoea`, `TransfusionOriginal`.`reaction_hypotension`, `TransfusionOriginal`.`reaction_tachycardia`, `TransfusionOriginal`.`reaction_renal`, `TransfusionOriginal`.`reaction_anuria`, `TransfusionOriginal`.`reaction_oliguria`, `TransfusionOriginal`.`reaction_dark`, `TransfusionOriginal`.`reaction_haematological`, `TransfusionOriginal`.`reaction_other`, `TransfusionOriginal`.`vital_start_bp`, `TransfusionOriginal`.`vital_start_t`, `TransfusionOriginal`.`vital_start_p`, `TransfusionOriginal`.`vital_start_r`, `TransfusionOriginal`.`vital_during_bp`, `TransfusionOriginal`.`vital_during_t`, `TransfusionOriginal`.`vital_during_p`, `TransfusionOriginal`.`vital_during_r`, `TransfusionOriginal`.`vital_stop_bp`, `TransfusionOriginal`.`vital_stop_t`, `TransfusionOriginal`.`vital_stop_p`, `TransfusionOriginal`.`vital_stop_r`, `TransfusionOriginal`.`nurse_name`, `TransfusionOriginal`.`lab_hemolysis`, `TransfusionOriginal`.`lab_hemolysis_present`, `TransfusionOriginal`.`recipient_blood`, `TransfusionOriginal`.`hae_wbc`, `TransfusionOriginal`.`hae_hb`, `TransfusionOriginal`.`hae_rbc`, `TransfusionOriginal`.`hae_hct`, `TransfusionOriginal`.`hae_mcv`, `TransfusionOriginal`.`hae_mch`, `TransfusionOriginal`.`hae_mchc`, `TransfusionOriginal`.`hae_plt`, `TransfusionOriginal`.`film_rbc`, `TransfusionOriginal`.`film_wbc`, `TransfusionOriginal`.`film_plt`, `TransfusionOriginal`.`donor_hemolysis`, `TransfusionOriginal`.`donor_age`, `TransfusionOriginal`.`culture_donor_pack`, `TransfusionOriginal`.`culture_recipient_blood`, `TransfusionOriginal`.`compatible_saline_rt`, `TransfusionOriginal`.`compatible_saline_ii`, `TransfusionOriginal`.`compatible_ahg`, `TransfusionOriginal`.`compatible_albumin`, `TransfusionOriginal`.`negative_result`, `TransfusionOriginal`.`anti_a`, `TransfusionOriginal`.`anti_b`, `TransfusionOriginal`.`urinalysis`, `TransfusionOriginal`.`evaluation`, `TransfusionOriginal`.`adverse_reaction`, `TransfusionOriginal`.`reporter_name`, `TransfusionOriginal`.`reporter_email`, `TransfusionOriginal`.`reporter_phone`, `TransfusionOriginal`.`report_type`, `TransfusionOriginal`.`submitted`, `TransfusionOriginal`.`submitted_date`, `TransfusionOriginal`.`copied`, `TransfusionOriginal`.`archived`, `TransfusionOriginal`.`archived_date`, `TransfusionOriginal`.`active`, `TransfusionOriginal`.`created`, `TransfusionOriginal`.`modified`, `TransfusionOriginal`.`reporter_date`, `TransfusionOriginal`.`person_submitting`, `TransfusionOriginal`.`reporter_name_diff`, `TransfusionOriginal`.`reporter_designation_diff`, `TransfusionOriginal`.`reporter_email_diff`, `TransfusionOriginal`.`reporter_phone_diff`, `TransfusionOriginal`.`reporter_date_diff`, `TransfusionOriginal`.`assigned_to`, `TransfusionOriginal`.`assigned_by`, `TransfusionOriginal`.`assigned_date`, `TransfusionOriginal`.`clinic_venue`, `TransfusionOriginal`.`specimens_post_transfusion`, `TransfusionOriginal`.`specimens_edta_blood`, `TransfusionOriginal`.`specimens_void_urine`, `TransfusionOriginal`.`specimens_blood_reacted`, `TransfusionOriginal`.`specimens_blood_bags`, `TransfusionOriginal`.`clinic_code`, `TransfusionOriginal`.`donor_number`, `TransfusionOriginal`.`national_number`, `TransfusionOriginal`.`home_phone`, `TransfusionOriginal`.`cell_phone`, `TransfusionOriginal`.`email_address`, `TransfusionOriginal`.`residence`, `TransfusionOriginal`.`nurse_date`, `TransfusionOriginal`.`low_volume`, `TransfusionOriginal`.`venepuncture`, `TransfusionOriginal`.`hematoma`, `TransfusionOriginal`.`faint`, `TransfusionOriginal`.`deleted`, `TransfusionOriginal`.`deleted_date` FROM `pvers`.`transfusions` AS `Transfusion` LEFT JOIN `pvers`.`users` AS `User` ON (`Transfusion`.`user_id` = `User`.`id`) LEFT JOIN `pvers`.`counties` AS `County` ON (`Transfusion`.`county_id` = `County`.`id`) LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Transfusion`.`designation_id` = `Designation`.`id`) LEFT JOIN `pvers`.`transfusions` AS `TransfusionOriginal` ON (`Transfusion`.`transfusion_id` = `TransfusionOriginal`.`id` AND `TransfusionOriginal`.`copied` = 1) WHERE `Transfusion`.`id` = 644 LIMIT 1 | 1 | 1 | 1 | |
SELECT `TransfusionFollowup`.`id`, `TransfusionFollowup`.`user_id`, `TransfusionFollowup`.`pqmp_id`, `TransfusionFollowup`.`transfusion_id`, `TransfusionFollowup`.`reference_no`, `TransfusionFollowup`.`county_id`, `TransfusionFollowup`.`designation_id`, `TransfusionFollowup`.`form_type`, `TransfusionFollowup`.`patient_name`, `TransfusionFollowup`.`gender`, `TransfusionFollowup`.`patient_address`, `TransfusionFollowup`.`patient_phone`, `TransfusionFollowup`.`date_of_birth`, `TransfusionFollowup`.`age_years`, `TransfusionFollowup`.`diagnosis`, `TransfusionFollowup`.`ward`, `TransfusionFollowup`.`pre_hb`, `TransfusionFollowup`.`transfusion_reason`, `TransfusionFollowup`.`current_medications`, `TransfusionFollowup`.`obstetric_history`, `TransfusionFollowup`.`previous_transfusion`, `TransfusionFollowup`.`transfusion_comment`, `TransfusionFollowup`.`previous_reactions`, `TransfusionFollowup`.`reaction_comment`, `TransfusionFollowup`.`reaction_general`, `TransfusionFollowup`.`reaction_fever`, `TransfusionFollowup`.`reaction_chills`, `TransfusionFollowup`.`reaction_flushing`, `TransfusionFollowup`.`reaction_vomiting`, `TransfusionFollowup`.`reaction_dermatological`, `TransfusionFollowup`.`reaction_cardiac`, `TransfusionFollowup`.`reaction_chest`, `TransfusionFollowup`.`reaction_dyspnoea`, `TransfusionFollowup`.`reaction_hypotension`, `TransfusionFollowup`.`reaction_tachycardia`, `TransfusionFollowup`.`reaction_renal`, `TransfusionFollowup`.`reaction_anuria`, `TransfusionFollowup`.`reaction_oliguria`, `TransfusionFollowup`.`reaction_dark`, `TransfusionFollowup`.`reaction_haematological`, `TransfusionFollowup`.`reaction_other`, `TransfusionFollowup`.`vital_start_bp`, `TransfusionFollowup`.`vital_start_t`, `TransfusionFollowup`.`vital_start_p`, `TransfusionFollowup`.`vital_start_r`, `TransfusionFollowup`.`vital_during_bp`, `TransfusionFollowup`.`vital_during_t`, `TransfusionFollowup`.`vital_during_p`, `TransfusionFollowup`.`vital_during_r`, `TransfusionFollowup`.`vital_stop_bp`, `TransfusionFollowup`.`vital_stop_t`, `TransfusionFollowup`.`vital_stop_p`, `TransfusionFollowup`.`vital_stop_r`, `TransfusionFollowup`.`nurse_name`, `TransfusionFollowup`.`lab_hemolysis`, `TransfusionFollowup`.`lab_hemolysis_present`, `TransfusionFollowup`.`recipient_blood`, `TransfusionFollowup`.`hae_wbc`, `TransfusionFollowup`.`hae_hb`, `TransfusionFollowup`.`hae_rbc`, `TransfusionFollowup`.`hae_hct`, `TransfusionFollowup`.`hae_mcv`, `TransfusionFollowup`.`hae_mch`, `TransfusionFollowup`.`hae_mchc`, `TransfusionFollowup`.`hae_plt`, `TransfusionFollowup`.`film_rbc`, `TransfusionFollowup`.`film_wbc`, `TransfusionFollowup`.`film_plt`, `TransfusionFollowup`.`donor_hemolysis`, `TransfusionFollowup`.`donor_age`, `TransfusionFollowup`.`culture_donor_pack`, `TransfusionFollowup`.`culture_recipient_blood`, `TransfusionFollowup`.`compatible_saline_rt`, `TransfusionFollowup`.`compatible_saline_ii`, `TransfusionFollowup`.`compatible_ahg`, `TransfusionFollowup`.`compatible_albumin`, `TransfusionFollowup`.`negative_result`, `TransfusionFollowup`.`anti_a`, `TransfusionFollowup`.`anti_b`, `TransfusionFollowup`.`urinalysis`, `TransfusionFollowup`.`evaluation`, `TransfusionFollowup`.`adverse_reaction`, `TransfusionFollowup`.`reporter_name`, `TransfusionFollowup`.`reporter_email`, `TransfusionFollowup`.`reporter_phone`, `TransfusionFollowup`.`report_type`, `TransfusionFollowup`.`submitted`, `TransfusionFollowup`.`submitted_date`, `TransfusionFollowup`.`copied`, `TransfusionFollowup`.`archived`, `TransfusionFollowup`.`archived_date`, `TransfusionFollowup`.`active`, `TransfusionFollowup`.`created`, `TransfusionFollowup`.`modified`, `TransfusionFollowup`.`reporter_date`, `TransfusionFollowup`.`person_submitting`, `TransfusionFollowup`.`reporter_name_diff`, `TransfusionFollowup`.`reporter_designation_diff`, `TransfusionFollowup`.`reporter_email_diff`, `TransfusionFollowup`.`reporter_phone_diff`, `TransfusionFollowup`.`reporter_date_diff`, `TransfusionFollowup`.`assigned_to`, `TransfusionFollowup`.`assigned_by`, `TransfusionFollowup`.`assigned_date`, `TransfusionFollowup`.`clinic_venue`, `TransfusionFollowup`.`specimens_post_transfusion`, `TransfusionFollowup`.`specimens_edta_blood`, `TransfusionFollowup`.`specimens_void_urine`, `TransfusionFollowup`.`specimens_blood_reacted`, `TransfusionFollowup`.`specimens_blood_bags`, `TransfusionFollowup`.`clinic_code`, `TransfusionFollowup`.`donor_number`, `TransfusionFollowup`.`national_number`, `TransfusionFollowup`.`home_phone`, `TransfusionFollowup`.`cell_phone`, `TransfusionFollowup`.`email_address`, `TransfusionFollowup`.`residence`, `TransfusionFollowup`.`nurse_date`, `TransfusionFollowup`.`low_volume`, `TransfusionFollowup`.`venepuncture`, `TransfusionFollowup`.`hematoma`, `TransfusionFollowup`.`faint`, `TransfusionFollowup`.`deleted`, `TransfusionFollowup`.`deleted_date` FROM `pvers`.`transfusions` AS `TransfusionFollowup` WHERE `TransfusionFollowup`.`report_type` = 'Followup' AND `TransfusionFollowup`.`transfusion_id` = (644) | 0 | 0 | 2 | maybe slow |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`file`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`description`, `Attachment`.`year`, `Attachment`.`file_date`, `Attachment`.`pocket_name`, `Attachment`.`version_no`, `Attachment`.`created`, `Attachment`.`modified` FROM `pvers`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Transfusion' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (644) | 0 | 0 | 1 | maybe slow |
SELECT `Pint`.`id`, `Pint`.`transfusion_id`, `Pint`.`component_type`, `Pint`.`pint_no`, `Pint`.`expiry_date`, `Pint`.`volume_transfused`, `Pint`.`created`, `Pint`.`modified` FROM `pvers`.`pints` AS `Pint` WHERE `Pint`.`transfusion_id` = (644) | 0 | 0 | 0 | |
SELECT `ExternalComment`.`id`, `ExternalComment`.`foreign_key`, `ExternalComment`.`user_id`, `ExternalComment`.`model_id`, `ExternalComment`.`model`, `ExternalComment`.`category`, `ExternalComment`.`sender`, `ExternalComment`.`subject`, `ExternalComment`.`content`, `ExternalComment`.`review`, `ExternalComment`.`deleted`, `ExternalComment`.`created`, `ExternalComment`.`modified` FROM `pvers`.`comments` AS `ExternalComment` WHERE `ExternalComment`.`model` = 'Transfusion' AND `ExternalComment`.`category` = 'external' AND `ExternalComment`.`foreign_key` = (644) | 0 | 0 | 0 | |
SELECT `ReviewComment`.`id`, `ReviewComment`.`foreign_key`, `ReviewComment`.`user_id`, `ReviewComment`.`model_id`, `ReviewComment`.`model`, `ReviewComment`.`category`, `ReviewComment`.`sender`, `ReviewComment`.`subject`, `ReviewComment`.`content`, `ReviewComment`.`review`, `ReviewComment`.`deleted`, `ReviewComment`.`created`, `ReviewComment`.`modified` FROM `pvers`.`comments` AS `ReviewComment` WHERE `ReviewComment`.`model` = 'Transfusion' AND `ReviewComment`.`category` = 'review' AND `ReviewComment`.`foreign_key` = (644) | 0 | 0 | 0 | |
SELECT `County`.`id`, `County`.`county_name` FROM `pvers`.`counties` AS `County` WHERE 1 = 1 | 47 | 47 | 0 | |
SELECT `Designation`.`id`, `Designation`.`name` FROM `pvers`.`designations` AS `Designation` WHERE 1 = 1 ORDER BY `Designation`.`name` ASC | 26 | 26 | 0 |
6 duplicate queries run.
Peak Memory Use 6.29 MB
Message | Memory use |
---|---|
Component initialization | 2.46 MB |
Controller action start | 2.85 MB |
Controller render start | 4.53 MB |
View render complete | 5.30 MB |
Total Request Time: 108 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 5.17 | |
Event: Controller.initialize | 0.64 | |
Event: Controller.startup | 0.26 | |
Controller action | 53.06 | |
Event: Controller.beforeRender | 2.58 | |
» Processing toolbar data | 2.45 | |
Rendering View | 34.40 | |
» Event: View.beforeRender | 0.03 | |
» Rendering APP/View/Transfusions/guest_edit.ctp | 32.22 | |
» » Rendering APP/View/Elements/transfusion/transfusion_edit.ctp | 31.73 | |
» » » Rendering APP/View/Elements/alerts/flash_success.ctp | 0.89 | |
» » » Rendering APP/View/Elements/multi/list_of_pints.ctp | 0.35 | |
» » » Rendering APP/View/Elements/multi/attachments.ctp | 0.15 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 1.50 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | '/var/www/pvers/app/Config/' |
MEDIA | '/var/www/pvers/app/webroot/media/' |
MEDIA_STATIC | '/var/www/pvers/app/webroot/media/static/' |
MEDIA_FILTER | '/var/www/pvers/app/webroot/media/filter/' |
MEDIA_TRANSFER | '/var/www/pvers/app/webroot/media/transfer/' |
MEDIA_UPLOAD_TMP_DIR | '/tmp' |
MEDIA_URL | 'media/' |
MEDIA_STATIC_URL | 'media/static/' |
MEDIA_FILTER_URL | 'media/filter/' |
MEDIA_TRANSFER_URL | 'media/transfer/' |
HTTP_HOST | '45.79.161.190' |
HTTP_BASE | 'http://45.79.161.190' |
HTTP_SELF | '/app/webroot/index.php' |
HTTP_URI | '/transfusions/guest_edit/644' |
HTTP_REF | 'http://45.79.161.190/transfusions/guest_add' |
CHOWN_PUBLIC | (int) 504 |
LF | '' |
NL | '' |
CR | '' |
TB | '' |
BR | ' ' |
WINDOWS | false |
FORMAT_DB_DATETIME | 'Y-m-d H:i:s' |
FORMAT_DB_DATE | 'Y-m-d' |
FORMAT_DB_TIME | 'H:i:s' |
DEFAULT_DATETIME | '0000-00-00 00:00:00' |
DEFAULT_DATE | '0000-00-00' |
DEFAULT_TIME | '00:00:00' |
FILES | '/var/www/pvers/app/files/' |
LOCALE | '/var/www/pvers/app/locale/' |
CLASS_USER | 'User' |
VALID_ALPHA | '/^[a-zA-Z]+$/' |
VALID_ALPHA_UNDERSCORES | '/^[a-zA-Z_]+$/' |
VALID_ALPHA_MINUS_UNDERSCORES | '/^[a-zA-Z_-]+$/' |
VALID_ALPHA_WHITESPACES | '/^[a-zA-Z ]+$/' |
VALID_ALPHANUMERIC_UNDERSCORES | '/^[\da-zA-Z_]+$/' |
VALID_ALPHANUMERIC_MINUS_UNDERSCORES | '/^[\da-zA-Z_-]+$/' |
VALID_ALPHANUMERIC_WHITESPACES | '/^[\da-zA-Z ]+$/' |
VALID_ALPHANUMERIC_WHITESPACES_UNDERSCORES | '/^[\da-zA-Z _]+$/' |
VALID_NUMERIC_UNDERSCORES | '/^[\d_]+$/' |
VALID_NUMERIC_WHITESPACES | '/^[\d ]+$/' |
VALID_NUMERIC_WHITESPACES_UNDERSCORES | '/^[\d _]+$/' |
VALID_INTEGERS | '/^[\d]+$/' |
FORMAT_NICE_YMDHMS | 'd.m.Y, H:i:s' |
FORMAT_NICE_YMDHM | 'd.m.Y, H:i' |
FORMAT_NICE_YM | 'm.Y' |
FORMAT_NICE_YMD | 'd.m.Y' |
FORMAT_NICE_MD | 'd.m.' |
FORMAT_NICE_D | 'd' |
FORMAT_NICE_W_NUM | 'w' |
FORMAT_NICE_W_ABBR | 'D' |
FORMAT_NICE_W_FULL | 'l' |
FORMAT_NICE_M | 'm' |
FORMAT_NICE_M_ABBR | 'M' |
FORMAT_NICE_M_FULL | 'F' |
FORMAT_NICE_Y_ABBR | 'y' |
FORMAT_NICE_Y | 'Y' |
FORMAT_NICE_HM | 'H:i' |
FORMAT_NICE_HMS | 'H:i:s' |
FORMAT_LOCAL_WA_YMDHMS | '%a, %d.%m.%Y, %H:%M:%S' |
FORMAT_LOCAL_WF_YMDHMS | '%A, %d.%m.%Y, %H:%M:%S' |
FORMAT_LOCAL_WA_YMDHM | '%a, %d.%m.%Y, %H:%M' |
FORMAT_LOCAL_WF_YMDHM | '%A, %d.%m.%Y, %H:%M' |
FORMAT_LOCAL_YMDHMS | '%d.%m.%Y, %H:%M:%S' |
FORMAT_LOCAL_YMDHM | '%d.%m.%Y, %H:%M' |
FORMAT_LOCAL_YMD | '%d.%m.%Y' |
FORMAT_LOCAL_MD | '%d.%m.' |
FORMAT_LOCAL_D | '%d' |
FORMAT_LOCAL_W_NUM | '%w' |
FORMAT_LOCAL_W_ABBR | '%a' |
FORMAT_LOCAL_W_FULL | '%A' |
FORMAT_LOCAL_M | '%m' |
FORMAT_LOCAL_M_ABBR | '%b' |
FORMAT_LOCAL_M_FULL | '%B' |
FORMAT_LOCAL_Y_ABBR | '%y' |
FORMAT_LOCAL_YMS_ABBR | '%d.%m.%y' |
FORMAT_LOCAL_Y | '%Y' |
FORMAT_LOCAL_H | '%H' |
FORMAT_LOCAL_S | '%S' |
FORMAT_LOCAL_HM | '%H:%M' |
FORMAT_LOCAL_HMS | '%H:%M:%S' |
CHAR_LESS | '<' |
CHAR_GREATER | '>' |
CHAR_QUOTE | '"' |
CHAR_APOSTROPHE | ''' |
CHAR_ARROWS | '»' |
CHAR_ARROWS_R | '»' |
CHAR_ARROWS_L | '«' |
CHAR_AVERAGE | 'Ø' |
CHAR_INFIN | '∞' |
CHAR_MILL | '' |
CHAR_PLUSMN | '±' |
CHAR_HELLIP | '…' |
CHAR_CIRCA | '≈' |
CHAR_CHECKBOX_EMPTY | '☐]' |
CHAR_CHECKBOX_MAKRED | '☑' |
CHAR_CHECKMARK | '✓' |
CHAR_CHECKMARK_BOLD | '✔' |
CHAR_BALLOT | '✗' |
CHAR_BALLOT_BOLD | '✘' |
CHAR_ABOUT | '≈' |
CHAR_RPIME | '′' |
CHAR_DOUBLE_RPIME | '″' |
Constant | Value |
---|---|
APP | '/var/www/pvers/app/' |
APP_DIR | 'app' |
APPLIBS | '/var/www/pvers/app/Lib/' |
CACHE | '/var/www/pvers/app/tmp/cache/' |
CAKE | '/var/www/pvers/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/var/www/pvers/lib' |
CORE_PATH | '/var/www/pvers/lib/' |
CAKE_VERSION | '2.10.20' |
CSS | '/var/www/pvers/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'http://45.79.161.190' |
IMAGES | '/var/www/pvers/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/var/www/pvers/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/var/www/pvers/app/tmp/logs/' |
ROOT | '/var/www/pvers' |
TESTS | '/var/www/pvers/app/Test/' |
TMP | '/var/www/pvers/app/tmp/' |
VENDORS | '/var/www/pvers/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/var/www/pvers/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '5.6.40-63+ubuntu18.04.1+deb.sury.org+2' |
Redirect Redirect Status | '200' |
Redirect Http Authorization | '' |
Redirect Status | '200' |
Http Authorization | '' |
Http Accept | '*/*' |
Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
Http Accept Encoding | 'gzip, br, zstd, deflate' |
Http Referer | 'http://45.79.161.190/transfusions/guest_add' |
Http Cookie | 'CAKEPHP=7jp00gqfj3lq4lldf81317sg42' |
Http Host | '45.79.161.190' |
Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin' |
Server Signature | 'Apache/2.4.29 (Ubuntu) Server at 45.79.161.190 Port 80 ' |
Server Software | 'Apache/2.4.29 (Ubuntu)' |
Server Name | '45.79.161.190' |
Server Addr | '45.79.161.190' |
Server Port | '80' |
Remote Addr | '18.117.10.27' |
Document Root | '/var/www/pvers' |
Request Scheme | 'http' |
Context Prefix | '' |
Context Document Root | '/var/www/pvers' |
Server Admin | 'webmaster@localhost' |
Script Filename | '/var/www/pvers/app/webroot/index.php' |
Remote Port | '14116' |
Redirect Url | '/app/webroot/transfusions/guest_edit/644' |
Gateway Interface | 'CGI/1.1' |
Server Protocol | 'HTTP/1.1' |
Request Method | 'GET' |
Query String | '' |
Request Uri | '/transfusions/guest_edit/644' |
Script Name | '/app/webroot/index.php' |
Php Self | '/app/webroot/index.php' |
Request Time Float | (float) 1735363248.565 |
Request Time | (int) 1735363248 |