No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT COUNT(*) AS `count` FROM `pvers`.`sadrs` AS `Sadr` WHERE `Sadr`.`id` = 827 | 1 | 1 | 3 | maybe slow |
SELECT `Sadr`.`id`, `Sadr`.`sadr_id`, `Sadr`.`user_id`, `Sadr`.`pqmp_id`, `Sadr`.`medication_id`, `Sadr`.`county_id`, `Sadr`.`sub_county_id`, `Sadr`.`designation_id`, `Sadr`.`reference_no`, `Sadr`.`vigiflow_id`, `Sadr`.`report_title`, `Sadr`.`report_type`, `Sadr`.`report_sadr`, `Sadr`.`report_therapeutic`, `Sadr`.`report_misuse`, `Sadr`.`report_off_label`, `Sadr`.`product_category`, `Sadr`.`medicinal_product`, `Sadr`.`blood_products`, `Sadr`.`herbal_product`, `Sadr`.`cosmeceuticals`, `Sadr`.`product_other`, `Sadr`.`product_specify`, `Sadr`.`name_of_institution`, `Sadr`.`institution_code`, `Sadr`.`address`, `Sadr`.`contact`, `Sadr`.`patient_name`, `Sadr`.`ip_no`, `Sadr`.`date_of_birth`, `Sadr`.`age_group`, `Sadr`.`patient_address`, `Sadr`.`ward`, `Sadr`.`gender`, `Sadr`.`known_allergy`, `Sadr`.`known_allergy_specify`, `Sadr`.`pregnant`, `Sadr`.`pregnancy_status`, `Sadr`.`weight`, `Sadr`.`height`, `Sadr`.`diagnosis`, `Sadr`.`reaction`, `Sadr`.`medical_history`, `Sadr`.`date_of_onset_of_reaction`, `Sadr`.`description_of_reaction`, `Sadr`.`reaction_resolve`, `Sadr`.`reaction_reappear`, `Sadr`.`lab_investigation`, `Sadr`.`severity`, `Sadr`.`serious`, `Sadr`.`serious_reason`, `Sadr`.`action_taken`, `Sadr`.`outcome`, `Sadr`.`causality`, `Sadr`.`any_other_comment`, `Sadr`.`reporter_name`, `Sadr`.`reporter_email`, `Sadr`.`reporter_phone`, `Sadr`.`submitted`, `Sadr`.`emails`, `Sadr`.`active`, `Sadr`.`device`, `Sadr`.`deleted`, `Sadr`.`archived`, `Sadr`.`archived_date`, `Sadr`.`deleted_date`, `Sadr`.`notified`, `Sadr`.`created`, `Sadr`.`modified`, `Sadr`.`reporter_date`, `Sadr`.`person_submitting`, `Sadr`.`reporter_name_diff`, `Sadr`.`reporter_designation_diff`, `Sadr`.`reporter_email_diff`, `Sadr`.`reporter_phone_diff`, `Sadr`.`reporter_date_diff`, `Sadr`.`assigned_to`, `Sadr`.`assigned_by`, `Sadr`.`assigned_date`, `Sadr`.`vigiflow_message`, `Sadr`.`vigiflow_ref`, `Sadr`.`vigiflow_date`, `Sadr`.`webradr_ref`, `Sadr`.`webradr_date`, `Sadr`.`submitted_date`, `Sadr`.`webradr_message`, `Sadr`.`copied`, `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`, `SubCounty`.`id`, `SubCounty`.`county_id`, `SubCounty`.`sub_county_name`, `SubCounty`.`county_name`, `SubCounty`.`Province`, `SubCounty`.`Pop_2009`, `SubCounty`.`RegVoters`, `SubCounty`.`AreaSqKms`, `SubCounty`.`CAWards`, `SubCounty`.`MainEthnicGroup`, `SubCounty`.`created`, `SubCounty`.`modified`, `Designation`.`id`, `Designation`.`name`, `Designation`.`category`, `Designation`.`created`, `Designation`.`modified`, `SadrOriginal`.`id`, `SadrOriginal`.`sadr_id`, `SadrOriginal`.`user_id`, `SadrOriginal`.`pqmp_id`, `SadrOriginal`.`medication_id`, `SadrOriginal`.`county_id`, `SadrOriginal`.`sub_county_id`, `SadrOriginal`.`designation_id`, `SadrOriginal`.`reference_no`, `SadrOriginal`.`vigiflow_id`, `SadrOriginal`.`report_title`, `SadrOriginal`.`report_type`, `SadrOriginal`.`report_sadr`, `SadrOriginal`.`report_therapeutic`, `SadrOriginal`.`report_misuse`, `SadrOriginal`.`report_off_label`, `SadrOriginal`.`product_category`, `SadrOriginal`.`medicinal_product`, `SadrOriginal`.`blood_products`, `SadrOriginal`.`herbal_product`, `SadrOriginal`.`cosmeceuticals`, `SadrOriginal`.`product_other`, `SadrOriginal`.`product_specify`, `SadrOriginal`.`name_of_institution`, `SadrOriginal`.`institution_code`, `SadrOriginal`.`address`, `SadrOriginal`.`contact`, `SadrOriginal`.`patient_name`, `SadrOriginal`.`ip_no`, `SadrOriginal`.`date_of_birth`, `SadrOriginal`.`age_group`, `SadrOriginal`.`patient_address`, `SadrOriginal`.`ward`, `SadrOriginal`.`gender`, `SadrOriginal`.`known_allergy`, `SadrOriginal`.`known_allergy_specify`, `SadrOriginal`.`pregnant`, `SadrOriginal`.`pregnancy_status`, `SadrOriginal`.`weight`, `SadrOriginal`.`height`, `SadrOriginal`.`diagnosis`, `SadrOriginal`.`reaction`, `SadrOriginal`.`medical_history`, `SadrOriginal`.`date_of_onset_of_reaction`, `SadrOriginal`.`description_of_reaction`, `SadrOriginal`.`reaction_resolve`, `SadrOriginal`.`reaction_reappear`, `SadrOriginal`.`lab_investigation`, `SadrOriginal`.`severity`, `SadrOriginal`.`serious`, `SadrOriginal`.`serious_reason`, `SadrOriginal`.`action_taken`, `SadrOriginal`.`outcome`, `SadrOriginal`.`causality`, `SadrOriginal`.`any_other_comment`, `SadrOriginal`.`reporter_name`, `SadrOriginal`.`reporter_email`, `SadrOriginal`.`reporter_phone`, `SadrOriginal`.`submitted`, `SadrOriginal`.`emails`, `SadrOriginal`.`active`, `SadrOriginal`.`device`, `SadrOriginal`.`deleted`, `SadrOriginal`.`archived`, `SadrOriginal`.`archived_date`, `SadrOriginal`.`deleted_date`, `SadrOriginal`.`notified`, `SadrOriginal`.`created`, `SadrOriginal`.`modified`, `SadrOriginal`.`reporter_date`, `SadrOriginal`.`person_submitting`, `SadrOriginal`.`reporter_name_diff`, `SadrOriginal`.`reporter_designation_diff`, `SadrOriginal`.`reporter_email_diff`, `SadrOriginal`.`reporter_phone_diff`, `SadrOriginal`.`reporter_date_diff`, `SadrOriginal`.`assigned_to`, `SadrOriginal`.`assigned_by`, `SadrOriginal`.`assigned_date`, `SadrOriginal`.`vigiflow_message`, `SadrOriginal`.`vigiflow_ref`, `SadrOriginal`.`vigiflow_date`, `SadrOriginal`.`webradr_ref`, `SadrOriginal`.`webradr_date`, `SadrOriginal`.`submitted_date`, `SadrOriginal`.`webradr_message`, `SadrOriginal`.`copied` FROM `pvers`.`sadrs` AS `Sadr` LEFT JOIN `pvers`.`users` AS `User` ON (`Sadr`.`user_id` = `User`.`id`) LEFT JOIN `pvers`.`counties` AS `County` ON (`Sadr`.`county_id` = `County`.`id`) LEFT JOIN `pvers`.`sub_counties` AS `SubCounty` ON (`Sadr`.`sub_county_id` = `SubCounty`.`id`) LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Sadr`.`designation_id` = `Designation`.`id`) LEFT JOIN `pvers`.`sadrs` AS `SadrOriginal` ON (`Sadr`.`sadr_id` = `SadrOriginal`.`id` AND `SadrOriginal`.`copied` = 1) WHERE `Sadr`.`id` = 827 LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `SadrListOfDrug`.`id`, `SadrListOfDrug`.`sadr_id`, `SadrListOfDrug`.`sadr_followup_id`, `SadrListOfDrug`.`dose_id`, `SadrListOfDrug`.`route_id`, `SadrListOfDrug`.`frequency_id`, `SadrListOfDrug`.`frequency_id_other`, `SadrListOfDrug`.`drug_name`, `SadrListOfDrug`.`brand_name`, `SadrListOfDrug`.`batch_no`, `SadrListOfDrug`.`manufacturer`, `SadrListOfDrug`.`dose`, `SadrListOfDrug`.`start_date`, `SadrListOfDrug`.`stop_date`, `SadrListOfDrug`.`indication`, `SadrListOfDrug`.`suspected_drug`, `SadrListOfDrug`.`created`, `SadrListOfDrug`.`modified` FROM `pvers`.`sadr_list_of_drugs` AS `SadrListOfDrug` WHERE `SadrListOfDrug`.`sadr_id` = (827) | 0 | 0 | 1 | maybe slow |
SELECT `SadrDescription`.`id`, `SadrDescription`.`sadr_id`, `SadrDescription`.`description`, `SadrDescription`.`created`, `SadrDescription`.`modified` FROM `pvers`.`sadr_descriptions` AS `SadrDescription` WHERE `SadrDescription`.`sadr_id` = (827) | 0 | 0 | 1 | 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` = 'Sadr' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (827) | 0 | 0 | 2 | maybe slow |
SELECT `SadrListOfMedicine`.`id`, `SadrListOfMedicine`.`sadr_id`, `SadrListOfMedicine`.`sadr_followup_id`, `SadrListOfMedicine`.`dose_id`, `SadrListOfMedicine`.`route_id`, `SadrListOfMedicine`.`frequency_id`, `SadrListOfMedicine`.`frequency_other`, `SadrListOfMedicine`.`drug_name`, `SadrListOfMedicine`.`brand_name`, `SadrListOfMedicine`.`batch_no`, `SadrListOfMedicine`.`manufacturer`, `SadrListOfMedicine`.`dose`, `SadrListOfMedicine`.`start_date`, `SadrListOfMedicine`.`stop_date`, `SadrListOfMedicine`.`indication`, `SadrListOfMedicine`.`suspected_drug`, `SadrListOfMedicine`.`created`, `SadrListOfMedicine`.`modified` FROM `pvers`.`sadr_list_of_medicines` AS `SadrListOfMedicine` WHERE `SadrListOfMedicine`.`sadr_id` = (827) | 0 | 0 | 1 | maybe slow |
SELECT `SadrFollowup`.`id`, `SadrFollowup`.`sadr_id`, `SadrFollowup`.`user_id`, `SadrFollowup`.`pqmp_id`, `SadrFollowup`.`medication_id`, `SadrFollowup`.`county_id`, `SadrFollowup`.`sub_county_id`, `SadrFollowup`.`designation_id`, `SadrFollowup`.`reference_no`, `SadrFollowup`.`vigiflow_id`, `SadrFollowup`.`report_title`, `SadrFollowup`.`report_type`, `SadrFollowup`.`report_sadr`, `SadrFollowup`.`report_therapeutic`, `SadrFollowup`.`report_misuse`, `SadrFollowup`.`report_off_label`, `SadrFollowup`.`product_category`, `SadrFollowup`.`medicinal_product`, `SadrFollowup`.`blood_products`, `SadrFollowup`.`herbal_product`, `SadrFollowup`.`cosmeceuticals`, `SadrFollowup`.`product_other`, `SadrFollowup`.`product_specify`, `SadrFollowup`.`name_of_institution`, `SadrFollowup`.`institution_code`, `SadrFollowup`.`address`, `SadrFollowup`.`contact`, `SadrFollowup`.`patient_name`, `SadrFollowup`.`ip_no`, `SadrFollowup`.`date_of_birth`, `SadrFollowup`.`age_group`, `SadrFollowup`.`patient_address`, `SadrFollowup`.`ward`, `SadrFollowup`.`gender`, `SadrFollowup`.`known_allergy`, `SadrFollowup`.`known_allergy_specify`, `SadrFollowup`.`pregnant`, `SadrFollowup`.`pregnancy_status`, `SadrFollowup`.`weight`, `SadrFollowup`.`height`, `SadrFollowup`.`diagnosis`, `SadrFollowup`.`reaction`, `SadrFollowup`.`medical_history`, `SadrFollowup`.`date_of_onset_of_reaction`, `SadrFollowup`.`description_of_reaction`, `SadrFollowup`.`reaction_resolve`, `SadrFollowup`.`reaction_reappear`, `SadrFollowup`.`lab_investigation`, `SadrFollowup`.`severity`, `SadrFollowup`.`serious`, `SadrFollowup`.`serious_reason`, `SadrFollowup`.`action_taken`, `SadrFollowup`.`outcome`, `SadrFollowup`.`causality`, `SadrFollowup`.`any_other_comment`, `SadrFollowup`.`reporter_name`, `SadrFollowup`.`reporter_email`, `SadrFollowup`.`reporter_phone`, `SadrFollowup`.`submitted`, `SadrFollowup`.`emails`, `SadrFollowup`.`active`, `SadrFollowup`.`device`, `SadrFollowup`.`deleted`, `SadrFollowup`.`archived`, `SadrFollowup`.`archived_date`, `SadrFollowup`.`deleted_date`, `SadrFollowup`.`notified`, `SadrFollowup`.`created`, `SadrFollowup`.`modified`, `SadrFollowup`.`reporter_date`, `SadrFollowup`.`person_submitting`, `SadrFollowup`.`reporter_name_diff`, `SadrFollowup`.`reporter_designation_diff`, `SadrFollowup`.`reporter_email_diff`, `SadrFollowup`.`reporter_phone_diff`, `SadrFollowup`.`reporter_date_diff`, `SadrFollowup`.`assigned_to`, `SadrFollowup`.`assigned_by`, `SadrFollowup`.`assigned_date`, `SadrFollowup`.`vigiflow_message`, `SadrFollowup`.`vigiflow_ref`, `SadrFollowup`.`vigiflow_date`, `SadrFollowup`.`webradr_ref`, `SadrFollowup`.`webradr_date`, `SadrFollowup`.`submitted_date`, `SadrFollowup`.`webradr_message`, `SadrFollowup`.`copied` FROM `pvers`.`sadrs` AS `SadrFollowup` WHERE `SadrFollowup`.`report_type` = 'Followup' AND `SadrFollowup`.`sadr_id` = (827) | 0 | 0 | 3 | maybe slow |
SELECT `Reminder`.`id`, `Reminder`.`foreign_key`, `Reminder`.`model`, `Reminder`.`user_id`, `Reminder`.`reminder_type`, `Reminder`.`created`, `Reminder`.`modified` FROM `pvers`.`reminders` AS `Reminder` WHERE `Reminder`.`model` = 'Sadr' AND `Reminder`.`foreign_key` = (827) | 1 | 1 | 3 | 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` = 'Sadr' AND `ExternalComment`.`category` = 'external' AND `ExternalComment`.`foreign_key` = (827) | 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` = 'Sadr' AND `ReviewComment`.`category` = 'review' AND `ReviewComment`.`foreign_key` = (827) | 0 | 0 | 1 | maybe slow |
SELECT `SadrReaction`.`id`, `SadrReaction`.`sadr_id`, `SadrReaction`.`reaction`, `SadrReaction`.`created`, `SadrReaction`.`modified` FROM `pvers`.`sadr_reaction` AS `SadrReaction` WHERE `SadrReaction`.`sadr_id` = (827) | 0 | 0 | 1 | maybe slow |
SELECT `Sadr`.`id`, `Sadr`.`sadr_id`, `Sadr`.`user_id`, `Sadr`.`pqmp_id`, `Sadr`.`medication_id`, `Sadr`.`county_id`, `Sadr`.`sub_county_id`, `Sadr`.`designation_id`, `Sadr`.`reference_no`, `Sadr`.`vigiflow_id`, `Sadr`.`report_title`, `Sadr`.`report_type`, `Sadr`.`report_sadr`, `Sadr`.`report_therapeutic`, `Sadr`.`report_misuse`, `Sadr`.`report_off_label`, `Sadr`.`product_category`, `Sadr`.`medicinal_product`, `Sadr`.`blood_products`, `Sadr`.`herbal_product`, `Sadr`.`cosmeceuticals`, `Sadr`.`product_other`, `Sadr`.`product_specify`, `Sadr`.`name_of_institution`, `Sadr`.`institution_code`, `Sadr`.`address`, `Sadr`.`contact`, `Sadr`.`patient_name`, `Sadr`.`ip_no`, `Sadr`.`date_of_birth`, `Sadr`.`age_group`, `Sadr`.`patient_address`, `Sadr`.`ward`, `Sadr`.`gender`, `Sadr`.`known_allergy`, `Sadr`.`known_allergy_specify`, `Sadr`.`pregnant`, `Sadr`.`pregnancy_status`, `Sadr`.`weight`, `Sadr`.`height`, `Sadr`.`diagnosis`, `Sadr`.`reaction`, `Sadr`.`medical_history`, `Sadr`.`date_of_onset_of_reaction`, `Sadr`.`description_of_reaction`, `Sadr`.`reaction_resolve`, `Sadr`.`reaction_reappear`, `Sadr`.`lab_investigation`, `Sadr`.`severity`, `Sadr`.`serious`, `Sadr`.`serious_reason`, `Sadr`.`action_taken`, `Sadr`.`outcome`, `Sadr`.`causality`, `Sadr`.`any_other_comment`, `Sadr`.`reporter_name`, `Sadr`.`reporter_email`, `Sadr`.`reporter_phone`, `Sadr`.`submitted`, `Sadr`.`emails`, `Sadr`.`active`, `Sadr`.`device`, `Sadr`.`deleted`, `Sadr`.`archived`, `Sadr`.`archived_date`, `Sadr`.`deleted_date`, `Sadr`.`notified`, `Sadr`.`created`, `Sadr`.`modified`, `Sadr`.`reporter_date`, `Sadr`.`person_submitting`, `Sadr`.`reporter_name_diff`, `Sadr`.`reporter_designation_diff`, `Sadr`.`reporter_email_diff`, `Sadr`.`reporter_phone_diff`, `Sadr`.`reporter_date_diff`, `Sadr`.`assigned_to`, `Sadr`.`assigned_by`, `Sadr`.`assigned_date`, `Sadr`.`vigiflow_message`, `Sadr`.`vigiflow_ref`, `Sadr`.`vigiflow_date`, `Sadr`.`webradr_ref`, `Sadr`.`webradr_date`, `Sadr`.`submitted_date`, `Sadr`.`webradr_message`, `Sadr`.`copied`, `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`, `SubCounty`.`id`, `SubCounty`.`county_id`, `SubCounty`.`sub_county_name`, `SubCounty`.`county_name`, `SubCounty`.`Province`, `SubCounty`.`Pop_2009`, `SubCounty`.`RegVoters`, `SubCounty`.`AreaSqKms`, `SubCounty`.`CAWards`, `SubCounty`.`MainEthnicGroup`, `SubCounty`.`created`, `SubCounty`.`modified`, `Designation`.`id`, `Designation`.`name`, `Designation`.`category`, `Designation`.`created`, `Designation`.`modified`, `SadrOriginal`.`id`, `SadrOriginal`.`sadr_id`, `SadrOriginal`.`user_id`, `SadrOriginal`.`pqmp_id`, `SadrOriginal`.`medication_id`, `SadrOriginal`.`county_id`, `SadrOriginal`.`sub_county_id`, `SadrOriginal`.`designation_id`, `SadrOriginal`.`reference_no`, `SadrOriginal`.`vigiflow_id`, `SadrOriginal`.`report_title`, `SadrOriginal`.`report_type`, `SadrOriginal`.`report_sadr`, `SadrOriginal`.`report_therapeutic`, `SadrOriginal`.`report_misuse`, `SadrOriginal`.`report_off_label`, `SadrOriginal`.`product_category`, `SadrOriginal`.`medicinal_product`, `SadrOriginal`.`blood_products`, `SadrOriginal`.`herbal_product`, `SadrOriginal`.`cosmeceuticals`, `SadrOriginal`.`product_other`, `SadrOriginal`.`product_specify`, `SadrOriginal`.`name_of_institution`, `SadrOriginal`.`institution_code`, `SadrOriginal`.`address`, `SadrOriginal`.`contact`, `SadrOriginal`.`patient_name`, `SadrOriginal`.`ip_no`, `SadrOriginal`.`date_of_birth`, `SadrOriginal`.`age_group`, `SadrOriginal`.`patient_address`, `SadrOriginal`.`ward`, `SadrOriginal`.`gender`, `SadrOriginal`.`known_allergy`, `SadrOriginal`.`known_allergy_specify`, `SadrOriginal`.`pregnant`, `SadrOriginal`.`pregnancy_status`, `SadrOriginal`.`weight`, `SadrOriginal`.`height`, `SadrOriginal`.`diagnosis`, `SadrOriginal`.`reaction`, `SadrOriginal`.`medical_history`, `SadrOriginal`.`date_of_onset_of_reaction`, `SadrOriginal`.`description_of_reaction`, `SadrOriginal`.`reaction_resolve`, `SadrOriginal`.`reaction_reappear`, `SadrOriginal`.`lab_investigation`, `SadrOriginal`.`severity`, `SadrOriginal`.`serious`, `SadrOriginal`.`serious_reason`, `SadrOriginal`.`action_taken`, `SadrOriginal`.`outcome`, `SadrOriginal`.`causality`, `SadrOriginal`.`any_other_comment`, `SadrOriginal`.`reporter_name`, `SadrOriginal`.`reporter_email`, `SadrOriginal`.`reporter_phone`, `SadrOriginal`.`submitted`, `SadrOriginal`.`emails`, `SadrOriginal`.`active`, `SadrOriginal`.`device`, `SadrOriginal`.`deleted`, `SadrOriginal`.`archived`, `SadrOriginal`.`archived_date`, `SadrOriginal`.`deleted_date`, `SadrOriginal`.`notified`, `SadrOriginal`.`created`, `SadrOriginal`.`modified`, `SadrOriginal`.`reporter_date`, `SadrOriginal`.`person_submitting`, `SadrOriginal`.`reporter_name_diff`, `SadrOriginal`.`reporter_designation_diff`, `SadrOriginal`.`reporter_email_diff`, `SadrOriginal`.`reporter_phone_diff`, `SadrOriginal`.`reporter_date_diff`, `SadrOriginal`.`assigned_to`, `SadrOriginal`.`assigned_by`, `SadrOriginal`.`assigned_date`, `SadrOriginal`.`vigiflow_message`, `SadrOriginal`.`vigiflow_ref`, `SadrOriginal`.`vigiflow_date`, `SadrOriginal`.`webradr_ref`, `SadrOriginal`.`webradr_date`, `SadrOriginal`.`submitted_date`, `SadrOriginal`.`webradr_message`, `SadrOriginal`.`copied` FROM `pvers`.`sadrs` AS `Sadr` LEFT JOIN `pvers`.`users` AS `User` ON (`Sadr`.`user_id` = `User`.`id`) LEFT JOIN `pvers`.`counties` AS `County` ON (`Sadr`.`county_id` = `County`.`id`) LEFT JOIN `pvers`.`sub_counties` AS `SubCounty` ON (`Sadr`.`sub_county_id` = `SubCounty`.`id`) LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Sadr`.`designation_id` = `Designation`.`id`) LEFT JOIN `pvers`.`sadrs` AS `SadrOriginal` ON (`Sadr`.`sadr_id` = `SadrOriginal`.`id` AND `SadrOriginal`.`copied` = 1) WHERE `Sadr`.`id` = 827 LIMIT 1 | 1 | 1 | 1 | |
SELECT `SadrListOfDrug`.`id`, `SadrListOfDrug`.`sadr_id`, `SadrListOfDrug`.`sadr_followup_id`, `SadrListOfDrug`.`dose_id`, `SadrListOfDrug`.`route_id`, `SadrListOfDrug`.`frequency_id`, `SadrListOfDrug`.`frequency_id_other`, `SadrListOfDrug`.`drug_name`, `SadrListOfDrug`.`brand_name`, `SadrListOfDrug`.`batch_no`, `SadrListOfDrug`.`manufacturer`, `SadrListOfDrug`.`dose`, `SadrListOfDrug`.`start_date`, `SadrListOfDrug`.`stop_date`, `SadrListOfDrug`.`indication`, `SadrListOfDrug`.`suspected_drug`, `SadrListOfDrug`.`created`, `SadrListOfDrug`.`modified` FROM `pvers`.`sadr_list_of_drugs` AS `SadrListOfDrug` WHERE `SadrListOfDrug`.`sadr_id` = (827) | 0 | 0 | 1 | maybe slow |
SELECT `SadrDescription`.`id`, `SadrDescription`.`sadr_id`, `SadrDescription`.`description`, `SadrDescription`.`created`, `SadrDescription`.`modified` FROM `pvers`.`sadr_descriptions` AS `SadrDescription` WHERE `SadrDescription`.`sadr_id` = (827) | 0 | 0 | 0 | |
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` = 'Sadr' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (827) | 0 | 0 | 1 | maybe slow |
SELECT `SadrListOfMedicine`.`id`, `SadrListOfMedicine`.`sadr_id`, `SadrListOfMedicine`.`sadr_followup_id`, `SadrListOfMedicine`.`dose_id`, `SadrListOfMedicine`.`route_id`, `SadrListOfMedicine`.`frequency_id`, `SadrListOfMedicine`.`frequency_other`, `SadrListOfMedicine`.`drug_name`, `SadrListOfMedicine`.`brand_name`, `SadrListOfMedicine`.`batch_no`, `SadrListOfMedicine`.`manufacturer`, `SadrListOfMedicine`.`dose`, `SadrListOfMedicine`.`start_date`, `SadrListOfMedicine`.`stop_date`, `SadrListOfMedicine`.`indication`, `SadrListOfMedicine`.`suspected_drug`, `SadrListOfMedicine`.`created`, `SadrListOfMedicine`.`modified` FROM `pvers`.`sadr_list_of_medicines` AS `SadrListOfMedicine` WHERE `SadrListOfMedicine`.`sadr_id` = (827) | 0 | 0 | 0 | |
SELECT `SadrFollowup`.`id`, `SadrFollowup`.`sadr_id`, `SadrFollowup`.`user_id`, `SadrFollowup`.`pqmp_id`, `SadrFollowup`.`medication_id`, `SadrFollowup`.`county_id`, `SadrFollowup`.`sub_county_id`, `SadrFollowup`.`designation_id`, `SadrFollowup`.`reference_no`, `SadrFollowup`.`vigiflow_id`, `SadrFollowup`.`report_title`, `SadrFollowup`.`report_type`, `SadrFollowup`.`report_sadr`, `SadrFollowup`.`report_therapeutic`, `SadrFollowup`.`report_misuse`, `SadrFollowup`.`report_off_label`, `SadrFollowup`.`product_category`, `SadrFollowup`.`medicinal_product`, `SadrFollowup`.`blood_products`, `SadrFollowup`.`herbal_product`, `SadrFollowup`.`cosmeceuticals`, `SadrFollowup`.`product_other`, `SadrFollowup`.`product_specify`, `SadrFollowup`.`name_of_institution`, `SadrFollowup`.`institution_code`, `SadrFollowup`.`address`, `SadrFollowup`.`contact`, `SadrFollowup`.`patient_name`, `SadrFollowup`.`ip_no`, `SadrFollowup`.`date_of_birth`, `SadrFollowup`.`age_group`, `SadrFollowup`.`patient_address`, `SadrFollowup`.`ward`, `SadrFollowup`.`gender`, `SadrFollowup`.`known_allergy`, `SadrFollowup`.`known_allergy_specify`, `SadrFollowup`.`pregnant`, `SadrFollowup`.`pregnancy_status`, `SadrFollowup`.`weight`, `SadrFollowup`.`height`, `SadrFollowup`.`diagnosis`, `SadrFollowup`.`reaction`, `SadrFollowup`.`medical_history`, `SadrFollowup`.`date_of_onset_of_reaction`, `SadrFollowup`.`description_of_reaction`, `SadrFollowup`.`reaction_resolve`, `SadrFollowup`.`reaction_reappear`, `SadrFollowup`.`lab_investigation`, `SadrFollowup`.`severity`, `SadrFollowup`.`serious`, `SadrFollowup`.`serious_reason`, `SadrFollowup`.`action_taken`, `SadrFollowup`.`outcome`, `SadrFollowup`.`causality`, `SadrFollowup`.`any_other_comment`, `SadrFollowup`.`reporter_name`, `SadrFollowup`.`reporter_email`, `SadrFollowup`.`reporter_phone`, `SadrFollowup`.`submitted`, `SadrFollowup`.`emails`, `SadrFollowup`.`active`, `SadrFollowup`.`device`, `SadrFollowup`.`deleted`, `SadrFollowup`.`archived`, `SadrFollowup`.`archived_date`, `SadrFollowup`.`deleted_date`, `SadrFollowup`.`notified`, `SadrFollowup`.`created`, `SadrFollowup`.`modified`, `SadrFollowup`.`reporter_date`, `SadrFollowup`.`person_submitting`, `SadrFollowup`.`reporter_name_diff`, `SadrFollowup`.`reporter_designation_diff`, `SadrFollowup`.`reporter_email_diff`, `SadrFollowup`.`reporter_phone_diff`, `SadrFollowup`.`reporter_date_diff`, `SadrFollowup`.`assigned_to`, `SadrFollowup`.`assigned_by`, `SadrFollowup`.`assigned_date`, `SadrFollowup`.`vigiflow_message`, `SadrFollowup`.`vigiflow_ref`, `SadrFollowup`.`vigiflow_date`, `SadrFollowup`.`webradr_ref`, `SadrFollowup`.`webradr_date`, `SadrFollowup`.`submitted_date`, `SadrFollowup`.`webradr_message`, `SadrFollowup`.`copied` FROM `pvers`.`sadrs` AS `SadrFollowup` WHERE `SadrFollowup`.`report_type` = 'Followup' AND `SadrFollowup`.`sadr_id` = (827) | 0 | 0 | 2 | maybe slow |
SELECT `Reminder`.`id`, `Reminder`.`foreign_key`, `Reminder`.`model`, `Reminder`.`user_id`, `Reminder`.`reminder_type`, `Reminder`.`created`, `Reminder`.`modified` FROM `pvers`.`reminders` AS `Reminder` WHERE `Reminder`.`model` = 'Sadr' AND `Reminder`.`foreign_key` = (827) | 1 | 1 | 1 | |
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` = 'Sadr' AND `ExternalComment`.`category` = 'external' AND `ExternalComment`.`foreign_key` = (827) | 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` = 'Sadr' AND `ReviewComment`.`category` = 'review' AND `ReviewComment`.`foreign_key` = (827) | 0 | 0 | 0 | |
SELECT `SadrReaction`.`id`, `SadrReaction`.`sadr_id`, `SadrReaction`.`reaction`, `SadrReaction`.`created`, `SadrReaction`.`modified` FROM `pvers`.`sadr_reaction` AS `SadrReaction` WHERE `SadrReaction`.`sadr_id` = (827) | 0 | 0 | 0 | |
SELECT `County`.`id`, `County`.`county_name` FROM `pvers`.`counties` AS `County` WHERE 1 = 1 ORDER BY `County`.`county_name` ASC | 47 | 47 | 1 | |
SELECT `SubCounty`.`id`, `SubCounty`.`sub_county_name` FROM `pvers`.`sub_counties` AS `SubCounty` WHERE 1 = 1 ORDER BY `SubCounty`.`sub_county_name` ASC | 293 | 293 | 1 | |
SELECT `Designation`.`id`, `Designation`.`name` FROM `pvers`.`designations` AS `Designation` WHERE 1 = 1 ORDER BY `Designation`.`name` ASC | 26 | 26 | 1 | |
SELECT `Route`.`id`, `Route`.`name` FROM `pvers`.`routes` AS `Route` WHERE 1 = 1 | 67 | 67 | 1 | |
SELECT `Frequency`.`id`, `Frequency`.`name` FROM `pvers`.`frequencies` AS `Frequency` WHERE 1 = 1 | 12 | 12 | 0 | |
SELECT `Dose`.`id`, `Dose`.`name` FROM `pvers`.`doses` AS `Dose` WHERE 1 = 1 | 32 | 32 | 1 |
10 duplicate queries run.
Peak Memory Use 9.03 MB
Message | Memory use |
---|---|
Component initialization | 2.47 MB |
Controller action start | 2.90 MB |
Controller render start | 5.37 MB |
View render complete | 6.30 MB |
Total Request Time: 172 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 7.39 | |
Event: Controller.initialize | 1.07 | |
Event: Controller.startup | 0.41 | |
Controller action | 85.88 | |
Event: Controller.beforeRender | 9.39 | |
» Processing toolbar data | 9.26 | |
Rendering View | 45.08 | |
» Event: View.beforeRender | 0.03 | |
» Rendering APP/View/Sadrs/guest_edit.ctp | 42.65 | |
» » Rendering APP/View/Elements/alerts/flash_success.ctp | 0.16 | |
» » Rendering APP/View/Elements/sadr/sadr_edit.ctp | 41.47 | |
» » » Rendering APP/View/Elements/multi/sadr_reactions.ctp | 1.01 | |
» » » Rendering APP/View/Elements/multi/sadr_descriptions.ctp | 0.36 | |
» » » Rendering APP/View/Elements/multi/list_of_drugs.ctp | 6.28 | |
» » » Rendering APP/View/Elements/multi/list_of_medicines.ctp | 1.61 | |
» » » Rendering APP/View/Elements/help/assessment.ctp | 0.97 | |
» » » Rendering APP/View/Elements/multi/attachments.ctp | 0.15 | |
» » » Rendering APP/View/Elements/help/explanatory.ctp | 0.52 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 1.57 | |
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 | '/sadrs/guest_edit/827' |
HTTP_REF | 'http://45.79.161.190/sadrs/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/sadrs/guest_add' |
Http Cookie | 'CAKEPHP=6fv84rvj5g2igjj763b3s2i6q2' |
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 | '3.142.98.186' |
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 | '40236' |
Redirect Url | '/app/webroot/sadrs/guest_edit/827' |
Gateway Interface | 'CGI/1.1' |
Server Protocol | 'HTTP/1.1' |
Request Method | 'GET' |
Query String | '' |
Request Uri | '/sadrs/guest_edit/827' |
Script Name | '/app/webroot/index.php' |
Php Self | '/app/webroot/index.php' |
Request Time Float | (float) 1735364236.775 |
Request Time | (int) 1735364236 |