No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT COUNT(*) AS `count` FROM `pvers`.`devices` AS `Device` WHERE `Device`.`id` = 1370 | 1 | 1 | 14 | maybe slow |
SELECT `Device`.`id`, `Device`.`user_id`, `Device`.`pqmp_id`, `Device`.`reference_no`, `Device`.`county_id`, `Device`.`designation_id`, `Device`.`device_id`, `Device`.`report_type`, `Device`.`report_title`, `Device`.`name_of_institution`, `Device`.`institution_code`, `Device`.`institution_address`, `Device`.`institution_contact`, `Device`.`patient_name`, `Device`.`gender`, `Device`.`patient_address`, `Device`.`patient_phone`, `Device`.`patient_weight`, `Device`.`patient_height`, `Device`.`pregnancy_status`, `Device`.`trimester`, `Device`.`ip_no`, `Device`.`date_of_birth`, `Device`.`age_years`, `Device`.`allergy`, `Device`.`allergy_specify`, `Device`.`problem_noted`, `Device`.`brand_name`, `Device`.`serial_no`, `Device`.`common_name`, `Device`.`device_model`, `Device`.`catalogue`, `Device`.`manufacturer_name`, `Device`.`manufacturer_address`, `Device`.`manufacture_date`, `Device`.`expiry_date`, `Device`.`operator`, `Device`.`operator_specify`, `Device`.`device_usage`, `Device`.`device_duration_type`, `Device`.`device_duration`, `Device`.`device_availability`, `Device`.`device_unavailability`, `Device`.`implant_date`, `Device`.`explant_date`, `Device`.`implant_duration_type`, `Device`.`implant_duration`, `Device`.`specimen_type`, `Device`.`patients_involved`, `Device`.`tests_done`, `Device`.`false_positives`, `Device`.`false_negatives`, `Device`.`true_positives`, `Device`.`true_negatives`, `Device`.`date_onset_incident`, `Device`.`serious`, `Device`.`serious_yes`, `Device`.`death_date`, `Device`.`description_of_reaction`, `Device`.`remedial_action`, `Device`.`outcome`, `Device`.`reporter_name`, `Device`.`reporter_email`, `Device`.`reporter_phone`, `Device`.`reporter_date`, `Device`.`person_submitting`, `Device`.`reporter_name_diff`, `Device`.`reporter_designation_diff`, `Device`.`reporter_email_diff`, `Device`.`reporter_phone_diff`, `Device`.`reporter_date_diff`, `Device`.`assigned_to`, `Device`.`assigned_by`, `Device`.`assigned_date`, `Device`.`submitted`, `Device`.`submitted_date`, `Device`.`copied`, `Device`.`archived`, `Device`.`archived_date`, `Device`.`active`, `Device`.`created`, `Device`.`modified`, `Device`.`deleted`, `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`, `County`.`id`, `County`.`county_name`, `County`.`org_unit`, `County`.`created`, `County`.`modified`, `Designation`.`id`, `Designation`.`name`, `Designation`.`category`, `Designation`.`created`, `Designation`.`modified`, `DeviceOriginal`.`id`, `DeviceOriginal`.`user_id`, `DeviceOriginal`.`pqmp_id`, `DeviceOriginal`.`reference_no`, `DeviceOriginal`.`county_id`, `DeviceOriginal`.`designation_id`, `DeviceOriginal`.`device_id`, `DeviceOriginal`.`report_type`, `DeviceOriginal`.`report_title`, `DeviceOriginal`.`name_of_institution`, `DeviceOriginal`.`institution_code`, `DeviceOriginal`.`institution_address`, `DeviceOriginal`.`institution_contact`, `DeviceOriginal`.`patient_name`, `DeviceOriginal`.`gender`, `DeviceOriginal`.`patient_address`, `DeviceOriginal`.`patient_phone`, `DeviceOriginal`.`patient_weight`, `DeviceOriginal`.`patient_height`, `DeviceOriginal`.`pregnancy_status`, `DeviceOriginal`.`trimester`, `DeviceOriginal`.`ip_no`, `DeviceOriginal`.`date_of_birth`, `DeviceOriginal`.`age_years`, `DeviceOriginal`.`allergy`, `DeviceOriginal`.`allergy_specify`, `DeviceOriginal`.`problem_noted`, `DeviceOriginal`.`brand_name`, `DeviceOriginal`.`serial_no`, `DeviceOriginal`.`common_name`, `DeviceOriginal`.`device_model`, `DeviceOriginal`.`catalogue`, `DeviceOriginal`.`manufacturer_name`, `DeviceOriginal`.`manufacturer_address`, `DeviceOriginal`.`manufacture_date`, `DeviceOriginal`.`expiry_date`, `DeviceOriginal`.`operator`, `DeviceOriginal`.`operator_specify`, `DeviceOriginal`.`device_usage`, `DeviceOriginal`.`device_duration_type`, `DeviceOriginal`.`device_duration`, `DeviceOriginal`.`device_availability`, `DeviceOriginal`.`device_unavailability`, `DeviceOriginal`.`implant_date`, `DeviceOriginal`.`explant_date`, `DeviceOriginal`.`implant_duration_type`, `DeviceOriginal`.`implant_duration`, `DeviceOriginal`.`specimen_type`, `DeviceOriginal`.`patients_involved`, `DeviceOriginal`.`tests_done`, `DeviceOriginal`.`false_positives`, `DeviceOriginal`.`false_negatives`, `DeviceOriginal`.`true_positives`, `DeviceOriginal`.`true_negatives`, `DeviceOriginal`.`date_onset_incident`, `DeviceOriginal`.`serious`, `DeviceOriginal`.`serious_yes`, `DeviceOriginal`.`death_date`, `DeviceOriginal`.`description_of_reaction`, `DeviceOriginal`.`remedial_action`, `DeviceOriginal`.`outcome`, `DeviceOriginal`.`reporter_name`, `DeviceOriginal`.`reporter_email`, `DeviceOriginal`.`reporter_phone`, `DeviceOriginal`.`reporter_date`, `DeviceOriginal`.`person_submitting`, `DeviceOriginal`.`reporter_name_diff`, `DeviceOriginal`.`reporter_designation_diff`, `DeviceOriginal`.`reporter_email_diff`, `DeviceOriginal`.`reporter_phone_diff`, `DeviceOriginal`.`reporter_date_diff`, `DeviceOriginal`.`assigned_to`, `DeviceOriginal`.`assigned_by`, `DeviceOriginal`.`assigned_date`, `DeviceOriginal`.`submitted`, `DeviceOriginal`.`submitted_date`, `DeviceOriginal`.`copied`, `DeviceOriginal`.`archived`, `DeviceOriginal`.`archived_date`, `DeviceOriginal`.`active`, `DeviceOriginal`.`created`, `DeviceOriginal`.`modified`, `DeviceOriginal`.`deleted` FROM `pvers`.`devices` AS `Device` LEFT JOIN `pvers`.`users` AS `User` ON (`Device`.`user_id` = `User`.`id`) LEFT JOIN `pvers`.`counties` AS `County` ON (`Device`.`county_id` = `County`.`id`) LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Device`.`designation_id` = `Designation`.`id`) LEFT JOIN `pvers`.`devices` AS `DeviceOriginal` ON (`Device`.`device_id` = `DeviceOriginal`.`id` AND `DeviceOriginal`.`copied` = 1) WHERE `Device`.`id` = 1370 LIMIT 1 | 1 | 1 | 1 | |
SELECT `DeviceFollowup`.`id`, `DeviceFollowup`.`user_id`, `DeviceFollowup`.`pqmp_id`, `DeviceFollowup`.`reference_no`, `DeviceFollowup`.`county_id`, `DeviceFollowup`.`designation_id`, `DeviceFollowup`.`device_id`, `DeviceFollowup`.`report_type`, `DeviceFollowup`.`report_title`, `DeviceFollowup`.`name_of_institution`, `DeviceFollowup`.`institution_code`, `DeviceFollowup`.`institution_address`, `DeviceFollowup`.`institution_contact`, `DeviceFollowup`.`patient_name`, `DeviceFollowup`.`gender`, `DeviceFollowup`.`patient_address`, `DeviceFollowup`.`patient_phone`, `DeviceFollowup`.`patient_weight`, `DeviceFollowup`.`patient_height`, `DeviceFollowup`.`pregnancy_status`, `DeviceFollowup`.`trimester`, `DeviceFollowup`.`ip_no`, `DeviceFollowup`.`date_of_birth`, `DeviceFollowup`.`age_years`, `DeviceFollowup`.`allergy`, `DeviceFollowup`.`allergy_specify`, `DeviceFollowup`.`problem_noted`, `DeviceFollowup`.`brand_name`, `DeviceFollowup`.`serial_no`, `DeviceFollowup`.`common_name`, `DeviceFollowup`.`device_model`, `DeviceFollowup`.`catalogue`, `DeviceFollowup`.`manufacturer_name`, `DeviceFollowup`.`manufacturer_address`, `DeviceFollowup`.`manufacture_date`, `DeviceFollowup`.`expiry_date`, `DeviceFollowup`.`operator`, `DeviceFollowup`.`operator_specify`, `DeviceFollowup`.`device_usage`, `DeviceFollowup`.`device_duration_type`, `DeviceFollowup`.`device_duration`, `DeviceFollowup`.`device_availability`, `DeviceFollowup`.`device_unavailability`, `DeviceFollowup`.`implant_date`, `DeviceFollowup`.`explant_date`, `DeviceFollowup`.`implant_duration_type`, `DeviceFollowup`.`implant_duration`, `DeviceFollowup`.`specimen_type`, `DeviceFollowup`.`patients_involved`, `DeviceFollowup`.`tests_done`, `DeviceFollowup`.`false_positives`, `DeviceFollowup`.`false_negatives`, `DeviceFollowup`.`true_positives`, `DeviceFollowup`.`true_negatives`, `DeviceFollowup`.`date_onset_incident`, `DeviceFollowup`.`serious`, `DeviceFollowup`.`serious_yes`, `DeviceFollowup`.`death_date`, `DeviceFollowup`.`description_of_reaction`, `DeviceFollowup`.`remedial_action`, `DeviceFollowup`.`outcome`, `DeviceFollowup`.`reporter_name`, `DeviceFollowup`.`reporter_email`, `DeviceFollowup`.`reporter_phone`, `DeviceFollowup`.`reporter_date`, `DeviceFollowup`.`person_submitting`, `DeviceFollowup`.`reporter_name_diff`, `DeviceFollowup`.`reporter_designation_diff`, `DeviceFollowup`.`reporter_email_diff`, `DeviceFollowup`.`reporter_phone_diff`, `DeviceFollowup`.`reporter_date_diff`, `DeviceFollowup`.`assigned_to`, `DeviceFollowup`.`assigned_by`, `DeviceFollowup`.`assigned_date`, `DeviceFollowup`.`submitted`, `DeviceFollowup`.`submitted_date`, `DeviceFollowup`.`copied`, `DeviceFollowup`.`archived`, `DeviceFollowup`.`archived_date`, `DeviceFollowup`.`active`, `DeviceFollowup`.`created`, `DeviceFollowup`.`modified`, `DeviceFollowup`.`deleted` FROM `pvers`.`devices` AS `DeviceFollowup` WHERE `DeviceFollowup`.`report_type` = 'Followup' AND `DeviceFollowup`.`device_id` = (1370) | 0 | 0 | 6 | 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` = 'Device' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (1370) | 0 | 0 | 4 | maybe slow |
SELECT `ListOfDevice`.`id`, `ListOfDevice`.`device_id`, `ListOfDevice`.`brand_name`, `ListOfDevice`.`serial_no`, `ListOfDevice`.`common_name`, `ListOfDevice`.`manufacturer`, `ListOfDevice`.`manufacture_date`, `ListOfDevice`.`expiry_date`, `ListOfDevice`.`created`, `ListOfDevice`.`modified` FROM `pvers`.`list_of_devices` AS `ListOfDevice` WHERE `ListOfDevice`.`device_id` = (1370) | 0 | 0 | 16 | 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` = 'Device' AND `ExternalComment`.`category` = 'external' AND `ExternalComment`.`foreign_key` = (1370) | 0 | 0 | 32 | 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` = 'Device' AND `ReviewComment`.`category` = 'review' AND `ReviewComment`.`foreign_key` = (1370) | 0 | 0 | 7 | maybe slow |
SELECT `Device`.`id`, `Device`.`user_id`, `Device`.`pqmp_id`, `Device`.`reference_no`, `Device`.`county_id`, `Device`.`designation_id`, `Device`.`device_id`, `Device`.`report_type`, `Device`.`report_title`, `Device`.`name_of_institution`, `Device`.`institution_code`, `Device`.`institution_address`, `Device`.`institution_contact`, `Device`.`patient_name`, `Device`.`gender`, `Device`.`patient_address`, `Device`.`patient_phone`, `Device`.`patient_weight`, `Device`.`patient_height`, `Device`.`pregnancy_status`, `Device`.`trimester`, `Device`.`ip_no`, `Device`.`date_of_birth`, `Device`.`age_years`, `Device`.`allergy`, `Device`.`allergy_specify`, `Device`.`problem_noted`, `Device`.`brand_name`, `Device`.`serial_no`, `Device`.`common_name`, `Device`.`device_model`, `Device`.`catalogue`, `Device`.`manufacturer_name`, `Device`.`manufacturer_address`, `Device`.`manufacture_date`, `Device`.`expiry_date`, `Device`.`operator`, `Device`.`operator_specify`, `Device`.`device_usage`, `Device`.`device_duration_type`, `Device`.`device_duration`, `Device`.`device_availability`, `Device`.`device_unavailability`, `Device`.`implant_date`, `Device`.`explant_date`, `Device`.`implant_duration_type`, `Device`.`implant_duration`, `Device`.`specimen_type`, `Device`.`patients_involved`, `Device`.`tests_done`, `Device`.`false_positives`, `Device`.`false_negatives`, `Device`.`true_positives`, `Device`.`true_negatives`, `Device`.`date_onset_incident`, `Device`.`serious`, `Device`.`serious_yes`, `Device`.`death_date`, `Device`.`description_of_reaction`, `Device`.`remedial_action`, `Device`.`outcome`, `Device`.`reporter_name`, `Device`.`reporter_email`, `Device`.`reporter_phone`, `Device`.`reporter_date`, `Device`.`person_submitting`, `Device`.`reporter_name_diff`, `Device`.`reporter_designation_diff`, `Device`.`reporter_email_diff`, `Device`.`reporter_phone_diff`, `Device`.`reporter_date_diff`, `Device`.`assigned_to`, `Device`.`assigned_by`, `Device`.`assigned_date`, `Device`.`submitted`, `Device`.`submitted_date`, `Device`.`copied`, `Device`.`archived`, `Device`.`archived_date`, `Device`.`active`, `Device`.`created`, `Device`.`modified`, `Device`.`deleted`, `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`, `County`.`id`, `County`.`county_name`, `County`.`org_unit`, `County`.`created`, `County`.`modified`, `Designation`.`id`, `Designation`.`name`, `Designation`.`category`, `Designation`.`created`, `Designation`.`modified`, `DeviceOriginal`.`id`, `DeviceOriginal`.`user_id`, `DeviceOriginal`.`pqmp_id`, `DeviceOriginal`.`reference_no`, `DeviceOriginal`.`county_id`, `DeviceOriginal`.`designation_id`, `DeviceOriginal`.`device_id`, `DeviceOriginal`.`report_type`, `DeviceOriginal`.`report_title`, `DeviceOriginal`.`name_of_institution`, `DeviceOriginal`.`institution_code`, `DeviceOriginal`.`institution_address`, `DeviceOriginal`.`institution_contact`, `DeviceOriginal`.`patient_name`, `DeviceOriginal`.`gender`, `DeviceOriginal`.`patient_address`, `DeviceOriginal`.`patient_phone`, `DeviceOriginal`.`patient_weight`, `DeviceOriginal`.`patient_height`, `DeviceOriginal`.`pregnancy_status`, `DeviceOriginal`.`trimester`, `DeviceOriginal`.`ip_no`, `DeviceOriginal`.`date_of_birth`, `DeviceOriginal`.`age_years`, `DeviceOriginal`.`allergy`, `DeviceOriginal`.`allergy_specify`, `DeviceOriginal`.`problem_noted`, `DeviceOriginal`.`brand_name`, `DeviceOriginal`.`serial_no`, `DeviceOriginal`.`common_name`, `DeviceOriginal`.`device_model`, `DeviceOriginal`.`catalogue`, `DeviceOriginal`.`manufacturer_name`, `DeviceOriginal`.`manufacturer_address`, `DeviceOriginal`.`manufacture_date`, `DeviceOriginal`.`expiry_date`, `DeviceOriginal`.`operator`, `DeviceOriginal`.`operator_specify`, `DeviceOriginal`.`device_usage`, `DeviceOriginal`.`device_duration_type`, `DeviceOriginal`.`device_duration`, `DeviceOriginal`.`device_availability`, `DeviceOriginal`.`device_unavailability`, `DeviceOriginal`.`implant_date`, `DeviceOriginal`.`explant_date`, `DeviceOriginal`.`implant_duration_type`, `DeviceOriginal`.`implant_duration`, `DeviceOriginal`.`specimen_type`, `DeviceOriginal`.`patients_involved`, `DeviceOriginal`.`tests_done`, `DeviceOriginal`.`false_positives`, `DeviceOriginal`.`false_negatives`, `DeviceOriginal`.`true_positives`, `DeviceOriginal`.`true_negatives`, `DeviceOriginal`.`date_onset_incident`, `DeviceOriginal`.`serious`, `DeviceOriginal`.`serious_yes`, `DeviceOriginal`.`death_date`, `DeviceOriginal`.`description_of_reaction`, `DeviceOriginal`.`remedial_action`, `DeviceOriginal`.`outcome`, `DeviceOriginal`.`reporter_name`, `DeviceOriginal`.`reporter_email`, `DeviceOriginal`.`reporter_phone`, `DeviceOriginal`.`reporter_date`, `DeviceOriginal`.`person_submitting`, `DeviceOriginal`.`reporter_name_diff`, `DeviceOriginal`.`reporter_designation_diff`, `DeviceOriginal`.`reporter_email_diff`, `DeviceOriginal`.`reporter_phone_diff`, `DeviceOriginal`.`reporter_date_diff`, `DeviceOriginal`.`assigned_to`, `DeviceOriginal`.`assigned_by`, `DeviceOriginal`.`assigned_date`, `DeviceOriginal`.`submitted`, `DeviceOriginal`.`submitted_date`, `DeviceOriginal`.`copied`, `DeviceOriginal`.`archived`, `DeviceOriginal`.`archived_date`, `DeviceOriginal`.`active`, `DeviceOriginal`.`created`, `DeviceOriginal`.`modified`, `DeviceOriginal`.`deleted` FROM `pvers`.`devices` AS `Device` LEFT JOIN `pvers`.`users` AS `User` ON (`Device`.`user_id` = `User`.`id`) LEFT JOIN `pvers`.`counties` AS `County` ON (`Device`.`county_id` = `County`.`id`) LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Device`.`designation_id` = `Designation`.`id`) LEFT JOIN `pvers`.`devices` AS `DeviceOriginal` ON (`Device`.`device_id` = `DeviceOriginal`.`id` AND `DeviceOriginal`.`copied` = 1) WHERE `Device`.`id` = 1370 LIMIT 1 | 1 | 1 | 0 | |
SELECT `DeviceFollowup`.`id`, `DeviceFollowup`.`user_id`, `DeviceFollowup`.`pqmp_id`, `DeviceFollowup`.`reference_no`, `DeviceFollowup`.`county_id`, `DeviceFollowup`.`designation_id`, `DeviceFollowup`.`device_id`, `DeviceFollowup`.`report_type`, `DeviceFollowup`.`report_title`, `DeviceFollowup`.`name_of_institution`, `DeviceFollowup`.`institution_code`, `DeviceFollowup`.`institution_address`, `DeviceFollowup`.`institution_contact`, `DeviceFollowup`.`patient_name`, `DeviceFollowup`.`gender`, `DeviceFollowup`.`patient_address`, `DeviceFollowup`.`patient_phone`, `DeviceFollowup`.`patient_weight`, `DeviceFollowup`.`patient_height`, `DeviceFollowup`.`pregnancy_status`, `DeviceFollowup`.`trimester`, `DeviceFollowup`.`ip_no`, `DeviceFollowup`.`date_of_birth`, `DeviceFollowup`.`age_years`, `DeviceFollowup`.`allergy`, `DeviceFollowup`.`allergy_specify`, `DeviceFollowup`.`problem_noted`, `DeviceFollowup`.`brand_name`, `DeviceFollowup`.`serial_no`, `DeviceFollowup`.`common_name`, `DeviceFollowup`.`device_model`, `DeviceFollowup`.`catalogue`, `DeviceFollowup`.`manufacturer_name`, `DeviceFollowup`.`manufacturer_address`, `DeviceFollowup`.`manufacture_date`, `DeviceFollowup`.`expiry_date`, `DeviceFollowup`.`operator`, `DeviceFollowup`.`operator_specify`, `DeviceFollowup`.`device_usage`, `DeviceFollowup`.`device_duration_type`, `DeviceFollowup`.`device_duration`, `DeviceFollowup`.`device_availability`, `DeviceFollowup`.`device_unavailability`, `DeviceFollowup`.`implant_date`, `DeviceFollowup`.`explant_date`, `DeviceFollowup`.`implant_duration_type`, `DeviceFollowup`.`implant_duration`, `DeviceFollowup`.`specimen_type`, `DeviceFollowup`.`patients_involved`, `DeviceFollowup`.`tests_done`, `DeviceFollowup`.`false_positives`, `DeviceFollowup`.`false_negatives`, `DeviceFollowup`.`true_positives`, `DeviceFollowup`.`true_negatives`, `DeviceFollowup`.`date_onset_incident`, `DeviceFollowup`.`serious`, `DeviceFollowup`.`serious_yes`, `DeviceFollowup`.`death_date`, `DeviceFollowup`.`description_of_reaction`, `DeviceFollowup`.`remedial_action`, `DeviceFollowup`.`outcome`, `DeviceFollowup`.`reporter_name`, `DeviceFollowup`.`reporter_email`, `DeviceFollowup`.`reporter_phone`, `DeviceFollowup`.`reporter_date`, `DeviceFollowup`.`person_submitting`, `DeviceFollowup`.`reporter_name_diff`, `DeviceFollowup`.`reporter_designation_diff`, `DeviceFollowup`.`reporter_email_diff`, `DeviceFollowup`.`reporter_phone_diff`, `DeviceFollowup`.`reporter_date_diff`, `DeviceFollowup`.`assigned_to`, `DeviceFollowup`.`assigned_by`, `DeviceFollowup`.`assigned_date`, `DeviceFollowup`.`submitted`, `DeviceFollowup`.`submitted_date`, `DeviceFollowup`.`copied`, `DeviceFollowup`.`archived`, `DeviceFollowup`.`archived_date`, `DeviceFollowup`.`active`, `DeviceFollowup`.`created`, `DeviceFollowup`.`modified`, `DeviceFollowup`.`deleted` FROM `pvers`.`devices` AS `DeviceFollowup` WHERE `DeviceFollowup`.`report_type` = 'Followup' AND `DeviceFollowup`.`device_id` = (1370) | 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` = 'Device' AND `Attachment`.`group` = 'attachment' AND `Attachment`.`foreign_key` = (1370) | 0 | 0 | 0 | |
SELECT `ListOfDevice`.`id`, `ListOfDevice`.`device_id`, `ListOfDevice`.`brand_name`, `ListOfDevice`.`serial_no`, `ListOfDevice`.`common_name`, `ListOfDevice`.`manufacturer`, `ListOfDevice`.`manufacture_date`, `ListOfDevice`.`expiry_date`, `ListOfDevice`.`created`, `ListOfDevice`.`modified` FROM `pvers`.`list_of_devices` AS `ListOfDevice` WHERE `ListOfDevice`.`device_id` = (1370) | 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` = 'Device' AND `ExternalComment`.`category` = 'external' AND `ExternalComment`.`foreign_key` = (1370) | 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` = 'Device' AND `ReviewComment`.`category` = 'review' AND `ReviewComment`.`foreign_key` = (1370) | 0 | 0 | 0 | |
SELECT `County`.`id`, `County`.`county_name` FROM `pvers`.`counties` AS `County` WHERE 1 = 1 ORDER BY `County`.`county_name` ASC | 49 | 49 | 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.74 MB
Message | Memory use |
---|---|
Component initialization | 2.48 MB |
Controller action start | 2.88 MB |
Controller render start | 4.43 MB |
View render complete | 5.23 MB |
Total Request Time: 193 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 11.38 | |
Event: Controller.initialize | 2.94 | |
Event: Controller.startup | 0.81 | |
Controller action | 108.53 | |
Event: Controller.beforeRender | 5.20 | |
» Processing toolbar data | 5.02 | |
Rendering View | 35.78 | |
» Event: View.beforeRender | 0.04 | |
» Rendering APP/View/Devices/guest_edit.ctp | 33.27 | |
» » Rendering APP/View/Elements/device/device_edit.ctp | 32.70 | |
» » » Rendering APP/View/Elements/multi/list_of_devices.ctp | 0.33 | |
» » » Rendering APP/View/Elements/multi/attachments.ctp | 0.16 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 1.53 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | '/var/www/html/pvers/app/Config/' |
MEDIA | '/var/www/html/pvers/app/webroot/media/' |
MEDIA_STATIC | '/var/www/html/pvers/app/webroot/media/static/' |
MEDIA_FILTER | '/var/www/html/pvers/app/webroot/media/filter/' |
MEDIA_TRANSFER | '/var/www/html/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 | 'pv.pharmacyboardkenya.org' |
HTTP_BASE | 'http://pv.pharmacyboardkenya.org' |
HTTP_SELF | '/app/webroot/index.php' |
HTTP_URI | '/devices/guest_edit/1370' |
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/html/pvers/app/files/' |
LOCALE | '/var/www/html/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/html/pvers/app/' |
APP_DIR | 'app' |
APPLIBS | '/var/www/html/pvers/app/Lib/' |
CACHE | '/var/www/html/pvers/app/tmp/cache/' |
CAKE | '/var/www/html/pvers/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/var/www/html/pvers/lib' |
CORE_PATH | '/var/www/html/pvers/lib/' |
CAKE_VERSION | '2.10.20' |
CSS | '/var/www/html/pvers/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'https://pv.pharmacyboardkenya.org' |
IMAGES | '/var/www/html/pvers/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/var/www/html/pvers/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/var/www/html/pvers/app/tmp/logs/' |
ROOT | '/var/www/html/pvers' |
TESTS | '/var/www/html/pvers/app/Test/' |
TMP | '/var/www/html/pvers/app/tmp/' |
VENDORS | '/var/www/html/pvers/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/var/www/html/pvers/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '5.5.9-1ubuntu4.26' |
Redirect Redirect Https | 'on' |
Redirect Redirect Ssl Tls Sni | 'pv.pharmacyboardkenya.org' |
Redirect Redirect Status | '200' |
Redirect Http Authorization | '' |
Redirect Https | 'on' |
Redirect Ssl Tls Sni | 'pv.pharmacyboardkenya.org' |
Redirect Status | '200' |
Http Authorization | '' |
Https | 'on' |
Ssl Tls Sni | 'pv.pharmacyboardkenya.org' |
Http User Agent | 'CCBot/2.0 (https://commoncrawl.org/faq/)' |
Http Accept | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
Http Accept Language | 'en-US,en;q=0.5' |
Http If Modified Since | 'Wed, 28 Feb 2024 23:04:11 GMT' |
Http Accept Encoding | 'br,gzip' |
Http Host | 'pv.pharmacyboardkenya.org' |
Http Connection | 'Keep-Alive' |
Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' |
Server Signature | 'Apache/2.4.7 (Ubuntu) Server at pv.pharmacyboardkenya.org Port 443 ' |
Server Software | 'Apache/2.4.7 (Ubuntu)' |
Server Name | 'pv.pharmacyboardkenya.org' |
Server Addr | '192.168.10.21' |
Server Port | '443' |
Remote Addr | '18.97.9.173' |
Document Root | '/var/www/html/pvers' |
Request Scheme | 'https' |
Context Prefix | '' |
Context Document Root | '/var/www/html/pvers' |
Server Admin | 'webmaster@localhost' |
Script Filename | '/var/www/html/pvers/app/webroot/index.php' |
Remote Port | '49024' |
Redirect Url | '/app/webroot/devices/guest_edit/1370' |
Gateway Interface | 'CGI/1.1' |
Server Protocol | 'HTTP/1.1' |
Request Method | 'GET' |
Query String | '' |
Request Uri | '/devices/guest_edit/1370' |
Script Name | '/app/webroot/index.php' |
Php Self | '/app/webroot/index.php' |
Request Time Float | (float) 1733855184.375 |
Request Time | (int) 1733855184 |