| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `County`.`county_name`, COUNT(*) as cnt, `County`.`id` FROM `pvers`.`medications` AS `Medication` LEFT JOIN `pvers`.`counties` AS `County` ON (`Medication`.`county_id` = `County`.`id`) WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY `County`.`county_name`, `County`.`id` HAVING COUNT(*) > 0 | 13 | 13 | 4 | maybe slow |
| SELECT `County`.`id`, `County`.`county_name` FROM `pvers`.`counties` AS `County` WHERE 1 = 1 ORDER BY `County`.`county_name` ASC | 47 | 47 | 1 | |
| SELECT `Medication`.`gender`, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY gender HAVING COUNT(*) > 0 | 2 | 2 | 1 | maybe slow |
| SELECT ((case
when trim(age_years) in ('neonate', 'infant', 'child', 'adolescent', 'adult', 'elderly') then age_years
when year(now()) - right(date_of_birth, 4) between 0 and 1 then 'infant'
when year(now()) - right(date_of_birth, 4) between 1 and 10 then 'child'
when year(now()) - right(date_of_birth, 4) between 18 and 65 then 'adult'
when year(now()) - right(date_of_birth, 4) between 10 and 18 then 'adolescent'
when year(now()) - right(date_of_birth, 4) between 65 and 155 then 'elderly'
else 'unknown'
end)) as ager, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY ((case
when trim(age_years) in ('neonate', 'infant', 'child', 'adolescent', 'adult', 'elderly') then age_years
when year(now()) - right(date_of_birth, 4) between 0 and 1 then 'infant'
when year(now()) - right(date_of_birth, 4) between 1 and 10 then 'child'
when year(now()) - right(date_of_birth, 4) between 18 and 65 then 'adult'
when year(now()) - right(date_of_birth, 4) between 10 and 18 then 'adolescent'
when year(now()) - right(date_of_birth, 4) between 65 and 155 then 'elderly'
else 'unknown'
end)) HAVING COUNT(*) > 0 | 6 | 6 | 2 | maybe slow |
| SELECT year(ifnull(created, created)) as year, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY year(ifnull(created, created)) HAVING COUNT(*) > 0 ORDER BY `year` ASC | 3 | 3 | 1 | maybe slow |
| SELECT DATE_FORMAT(created, "%b %Y") as month, month(ifnull(created, created)) as salit, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY DATE_FORMAT(created, "%b %Y"), salit HAVING COUNT(*) > 0 ORDER BY `salit` ASC | 12 | 12 | 2 | maybe slow |
| SELECT `Medication`.`name_of_institution`, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY name_of_institution HAVING COUNT(*) > 0 ORDER BY COUNT(*) DESC | 38 | 38 | 2 | maybe slow |
| SELECT `Medication`.`process_occur`, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY process_occur HAVING COUNT(*) > 0 ORDER BY COUNT(*) DESC | 4 | 4 | 2 | maybe slow |
| SELECT ((case
when outcome in ('Potential error, circumstances/events have potential to cause incident') then 'NO ERROR'
when outcome in ('Treatment /intervention required-caused temporary harm', 'Initial/prolonged hospitalization-caused temporary harm', 'Caused permanent harm', 'Near death event') then 'ERROR, HARM'
when outcome in ('Actual error-did not reach patient', 'Actual error-caused no harm', 'Additional monitoring required-caused no harm') then 'ERROR, NO HARM'
when outcome in ('Death') then 'ERROR, DEATH'
else 'N/A'
end)) as error, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY ((case
when outcome in ('Potential error, circumstances/events have potential to cause incident') then 'NO ERROR'
when outcome in ('Treatment /intervention required-caused temporary harm', 'Initial/prolonged hospitalization-caused temporary harm', 'Caused permanent harm', 'Near death event') then 'ERROR, HARM'
when outcome in ('Actual error-did not reach patient', 'Actual error-caused no harm', 'Additional monitoring required-caused no harm') then 'ERROR, NO HARM'
when outcome in ('Death') then 'ERROR, DEATH'
else 'N/A'
end)) HAVING COUNT(*) > 0 | 5 | 5 | 2 | maybe slow |
| SELECT `Designation`.`name`, COUNT(*) as cnt, `Designation`.`id` FROM `pvers`.`medications` AS `Medication` LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Medication`.`designation_id` = `Designation`.`id`) WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY `Designation`.`name`, `Designation`.`id` HAVING COUNT(*) > 0 | 13 | 13 | 3 | maybe slow |
| SELECT ((case
when error_cause_inexperience = 1 or error_cause_knowledge = 1 or error_cause_distraction = 1 then 'Staff factors'
when error_cause_medication = 1 or error_cause_packaging = 1 or error_cause_sound = 1 then 'Medication related'
when error_cause_workload = 1 or error_cause_peak = 1 or error_cause_stock = 1 then 'Work and environment'
when error_cause_procedure = 1 or error_cause_abbreviations = 1 or error_cause_illegible = 1 or error_cause_inaccurate = 1 or error_cause_labelling = 1 or error_cause_computer = 1 or error_cause_other = 1 then 'Task and technology'
else 'N/A'
end)) as factor, COUNT(*) as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 GROUP BY ((case
when error_cause_inexperience = 1 or error_cause_knowledge = 1 or error_cause_distraction = 1 then 'Staff factors'
when error_cause_medication = 1 or error_cause_packaging = 1 or error_cause_sound = 1 then 'Medication related'
when error_cause_workload = 1 or error_cause_peak = 1 or error_cause_stock = 1 then 'Work and environment'
when error_cause_procedure = 1 or error_cause_abbreviations = 1 or error_cause_illegible = 1 or error_cause_inaccurate = 1 or error_cause_labelling = 1 or error_cause_computer = 1 or error_cause_other = 1 then 'Task and technology'
else 'N/A'
end)) HAVING COUNT(*) > 0 | 5 | 5 | 2 | maybe slow |
| SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup' | 116 | 116 | 1 | |
| SELECT `MedicationProduct`.`product_name_i` AS `product_name_i`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 158, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 304, 305, 341, 347, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674) GROUP BY `MedicationProduct`.`product_name_i` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0 | 33 | 33 | 3 | maybe slow |
| SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup' | 116 | 116 | 1 | |
| SELECT `MedicationProduct`.`product_name_ii` AS `product_name_ii`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 158, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 304, 305, 341, 347, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674) GROUP BY `MedicationProduct`.`product_name_ii` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0 | 26 | 26 | 1 | |
| SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup' | 116 | 116 | 1 | |
| SELECT `MedicationProduct`.`generic_name_i` AS `generic_name_i`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`created` > '2020-04-01 08:08:08' AND `MedicationProduct`.`generic_name_i` > '' AND `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 158, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 304, 305, 341, 347, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674) GROUP BY `MedicationProduct`.`generic_name_i` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0 | 50 | 50 | 1 | |
| SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup' | 116 | 116 | 1 | |
| SELECT `MedicationProduct`.`generic_name_ii` AS `generic_name_ii`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`created` > '2020-04-01 08:08:08' AND `MedicationProduct`.`generic_name_ii` > '' AND `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 158, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 304, 305, 341, 347, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674) GROUP BY `MedicationProduct`.`generic_name_ii` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0 | 57 | 57 | 2 | |
3 duplicate queries run.
